Update db with stats table

b1k-00 / Fan-Dev

1 stars 0 forks source link

Update db with stats table #4

Closed b1k-00 closed 1 year ago

b1k-00 commented 1 year ago

update ssms first add a new table

will need to make a relationship btw another table in DB
this may affect whole db

Update Scripts in VS

to reflect a new table
along with the new relationship

refer to fiba.wasl to see what stats will be captured main stats are (pts, oreb, dreb, totreb, assist, steal, blocks, minutes, efficiency) please add to the list where you see fit

b1k-00 commented 1 year ago

After creation of BoxScore table Needed to update relationship between game table & informations table to reflect new columns. Since info table has relationship to team table it was not needed

Order of create script will follow

Game > Team > Info > BoxScore