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