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