2025.05.10 | DB

Tables (3)

HEALTH_INFO (신체정보)

  • HEALTH_INFO_SNLO (신체정보일련번호) — NUMBER — Primary key — NOT NULL
  • SLNO (선수번호) — NUMBER — Foreign key → PLAYER.SLNO — NOT NULL
  • BODY_HEIGHT (키) — NUMBER
  • WEIGTH (몸무게) — NUMBER
  • AGE (나이) — NUMBER

PLAYER (농구선수)

  • SLNO (선수일련번호) — NUMBER — Primary key — NOT NULL
  • TEAM_SLNO (팀일련번호) — NUMBER — Foreign key → TEAM.TEAM_SLNO — NOT NULL
  • PLAYER_NM (선수명) — VARCHAR(60)

TEAM (농구팀)

  • TEAM_SLNO (팀일련번호) — NUMBER — Primary key — NOT NULL
  • TEAM_NM (팀이름) — VARCHAR(100)
  • ADDRESS (주소) — VARCHAR(300)
  • MASCOT (마스코트) — VARCHAR(100)