gj
Tables (4)
physical_info
- measure_date — DATE — Primary key — NOT NULL
- player_id — INTEGER — Foreign key — NOT NULL
- height — DECIMAL(5,2) — NOT NULL
- weight — DECIMAL(5,2) — NOT NULL
player
- 선수 번호 (player_id) — INTEGER — Primary key — NOT NULL
- team_id — INTEGER — Foreign key — NOT NULL
- player_name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
region
- region_id — INTEGER — Primary key — NOT NULL
- region_name — VARCHAR(50) — NOT NULL
team
- team_id (Key) — Primary key — NOT NULL
- region_id — INTEGER — Foreign key → region.region_id — NOT NULL
- team_name — VARCHAR(100) — NOT NULL
- mascot — VARCHAR(100) — NOT NULL