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