Table Name | Name | Data Type | Primary Key | Unique | Required | Autoincrement | Charset | Collation | Comment |
player | id | int(11) | true | false | true | true | |||
player | first_name | varchar(50) | false | false | true | false | utf8 | utf8_general_ci | |
player | last_name | varchar(50) | false | false | true | false | utf8 | utf8_general_ci | |
player | photo | longblob | false | false | false | false | |||
player | career_start_year | int(11) | false | false | true | false | |||
player | career_end_year | int(11) | false | false | false | false | |||
player | country_id | int(11) | false | false | true | false | |||
player | height | int(11) | false | false | false | false | |||
player | birthday | date | false | false | false | false | |||
player | weight | decimal(10,2) | false | false | false | false | |||
player | college_id | int(11) | false | false | false | false | |||
player | current_team_id | int(11) | false | false | false | false | |||
player | current_number | int(11) | false | false | false | false | |||
player | rating | int(11) | false | false | false | false | |||
player | nba_profile | varchar(20) | false | false | false | false | utf8 | utf8_general_ci | |
player | photo_play | varchar(50) | false | false | false | false | utf8 | utf8_general_ci | |
player | position | set('Center','Guard','Forward') | false | false | false | false | utf8 | utf8_general_ci |