Table NameNameData TypePrimary KeyUniqueRequiredAutoincrementCharsetCollationComment
playeridint(11)truefalsetruetrue
playerfirst_namevarchar(50)falsefalsetruefalseutf8utf8_general_ci
playerlast_namevarchar(50)falsefalsetruefalseutf8utf8_general_ci
playerphotolongblobfalsefalsefalsefalse
playercareer_start_yearint(11)falsefalsetruefalse
playercareer_end_yearint(11)falsefalsefalsefalse
playercountry_idint(11)falsefalsetruefalse
playerheightint(11)falsefalsefalsefalse
playerbirthdaydatefalsefalsefalsefalse
playerweightdecimal(10,2)falsefalsefalsefalse
playercollege_idint(11)falsefalsefalsefalse
playercurrent_team_idint(11)falsefalsefalsefalse
playercurrent_numberint(11)falsefalsefalsefalse
playerratingint(11)falsefalsefalsefalse
playernba_profilevarchar(20)falsefalsefalsefalseutf8utf8_general_ci
playerphoto_playvarchar(50)falsefalsefalsefalseutf8utf8_general_ci
playerpositionset('Center','Guard','Forward')falsefalsefalsefalseutf8utf8_general_ci