Create an ER table and relationship of each entity. Entities and attributes are provided below.

Users:

user$\_$id$,$ username, email, password$\_$hash, balance, registration$\_$date, status, phone$\_$number, date$\_$of$\_$birth

Events $($Basketball Games$)$:

event$\_$id$,$ event$\_$name, event$\_$date, home$\_$team, away$\_$team, league, venue, status, season

Teams:

team$\_$id$,$ team$\_$name, abbreviation, city, arena, coach

Bets:

bet$\_$id$,$ user$\_$id$,$ event$\_$id$,$ bet$\_$type, bet$\_$amount, odds, bet$\_$status, result, date$\_$placed

Odds:

odds$\_$id$,$ event$\_$id$,$ bet$\_$type, home$\_$team$\_$odds, away$\_$team$\_$odds, spread, over$\_$under, odds$\_$date, status

Transactions:

transaction$\_$id$,$ user$\_$id$,$ transaction$\_$type, amount, transaction$\_$date, balance$\_$after, status

Betting History:

history$\_$id$,$ user$\_$id$,$ bet$\_$id$,$ event$\_$id$,$ bet$\_$amount, odds$\_$at$\_$bet, result, date$\_$placed, payout

Promotions:

promotion$\_$id$,$ promotion$\_$name, promotion$\_$type, description, start$\_$date, end$\_$date, minimum$\_$bet, status.

SQL of the table are provided below.

$--$ Teams table

CREATE TABLE teams $($

team$\_$id SERIAL PRIMARY KEY,

team$\_$name VARCHAR$(100)$ NOT NULL,

city VARCHAR$(100),$

created$\_$at TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP

$)$;

$--$ Games table

CREATE TABLE games $($

game$\_$id SERIAL PRIMARY KEY,

home$\_$team$\_$id INTEGER REFERENCES teams$($team$\_$id$),$

away$\_$team$\_$id INTEGER REFERENCES teams$($team$\_$id$),$

game$\_$date TIMESTAMP NOT NULL,

home$\_$team$\_$score INTEGER,

away$\_$team$\_$score INTEGER,

status VARCHAR$(20),--$ Scheduled, Final

created$\_$at TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP

$)$;

$--$ Odds table

CREATE TABLE odds $($

odds$\_$id SERIAL PRIMARY KEY,

game$\_$id INTEGER REFERENCES games$($game$\_$id$),$

bookmaker$\_$id INTEGER REFERENCES bookmakers$($bookmaker$\_$id$),$

home$\_$team$\_$moneyline DECIMAL$(10,2),$

away$\_$team$\_$moneyline DECIMAL$(10,2),$

odds$\_$timestamp TIMESTAMP NOT NULL,

created$\_$at TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP

$)$;

$--$ Bookmakers table

CREATE TABLE bookmakers $($

bookmaker$\_$id SERIAL PRIMARY KEY,

bookmaker$\_$name VARCHAR$(100)$ NOT NULL,

status VARCHAR$(20),--$ Active, Inactive

created$\_$at TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP

$)$;

$--$ Users table

CREATE TABLE users $($

user$\_$id SERIAL PRIMARY KEY,

username VARCHAR$(50)$ UNIQUE NOT NULL,

email VARCHAR$(100)$ UNIQUE NOT NULL,

password$\_$hash VARCHAR$(255)$ NOT NULL,

balance DECIMAL$(10,2)$ DEFAULT $0,$

status VARCHAR$(20),--$ Active, Suspended

created$\_$at TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP

$)$;

$--$ Bets table

CREATE TABLE bets $($

bet$\_$id SERIAL PRIMARY KEY,

user$\_$id INTEGER REFERENCES users$($user$\_$id$),$

game$\_$id INTEGER REFERENCES games$($game$\_$id$),$

odds$\_$id INTEGER REFERENCES odds$($odds$\_$id$),$

bet$\_$amount DECIMAL$(10,2)$ NOT NULL,

odds$\_$value DECIMAL$(10,2)$ NOT NULL,

potential$\_$payout DECIMAL$(10,2)$ NOT NULL,

team$\_$id INTEGER REFERENCES teams$($team$\_$id$),--$ The team bet on to win

status VARCHAR$(20),--$ Pending, Won, Lost

placed$\_$at TIMESTAMP DEFAULT CURRENT$\_$TIMESTAMP,

settled$\_$at TIMESTAMP

$)$;