prac1

Tables (3)

player

  • playerNo — int(30) — Primary key
  • teamCode (teamCode2) — varchar(30) — Foreign key → team.teamCode
  • playerName — varchar(50)
  • playerHeight — varchar(50)
  • playerBirth — varchar(50)
  • playerWeight — varchar(50)
  • playerPosition — varchar(20)
  • playerBackNo — int(4)
  • playerGoal — int(4)

team

  • teamCode — varchar(30) — Primary key
  • teamName — varchar(50)
  • teamCoach — varchar(50)
  • teamLoc — varchar(50)
  • teamyear — varchar(10)

user

  • userId — varchar(30) — Primary key
  • userPassword — varchar(30) — NOT NULL
  • userName — varchar(10) — NOT NULL
  • userGender — varchar(5)
  • 여) — )
  • userBirth — date
  • userPhone — varchar(30) — NOT NULL