축구

테이블 (4)

PLAYER

  • PLAYER_ID — CHAR(7) — 기본 키 — NOT NULL
  • STADIUM_ID — CHAR(3) — 외래 키 → SCHEDULE.STADIUM_ID — NOT NULL
  • SCHE_DATE — CHAR(8) — 외래 키 → SCHEDULE.SCHE_DATE — NOT NULL
  • PLAYER_NAME — VARCHAR2(20) — NOT NULL
  • TEAM_ID — CHAR(3) — NOT NULL
  • E_PLAYER_NAME — VARCHAR2(40)
  • NICKNAME — VARCHAR2(30)
  • JOIN_YYYY — CHAR(4)
  • POSITION — VARCHAR2(10)
  • BACK_NO — NUMBER(2)
  • NATION — VARCHAR2(20)
  • BIRTH_DATE — DATE
  • SOLAR — CHAR(1)
  • HEIGHT — NUMBER(3)
  • WEIGHT — NUMBER(3)

SCHEDULE

  • STADIUM_ID — CHAR(3) — 기본 키 — NOT NULL
  • SCHE_DATE — CHAR(8) — 기본 키 — NOT NULL
  • GUBUN — CHAR(1) — NOT NULL
  • HOMETEAM_ID — CHAR(3) — NOT NULL
  • AWAYTEAM_ID — CHAR(3) — NOT NULL
  • HOME_SCORE — NUMBER(2)
  • AWAY_SCORE — NUMBER(2)
  • STADIUM_ID (STADIUM_ID2) — CHAR(3) — 외래 키 → STADIUM.STADIUM_ID — NOT NULL

STADIUM

  • STADIUM_ID — CHAR(3) — 기본 키 — NOT NULL
  • STADIUM_NAME — VARCHAR2(40) — NOT NULL
  • HOMETEAM_ID — CHAR(3)
  • SEAT_COUNT — NUMBER
  • ADDRESS — VARCHAR2(60)
  • DDD — VARCHAR2(3)
  • TEL — VARCHAR2(10)

TEAM

  • TEAM_ID — CHAR(3) — 기본 키 — NOT NULL
  • REGION_NAME — VARCHAR2(8) — NOT NULL
  • TEAM_NAME — VARCHAR2(40) — NOT NULL
  • E_TEAM_NAME — VARCHAR2(50)
  • ORIG_YYYY — CHAR(4)
  • STADIUM_ID — CHAR(3) — NOT NULL
  • ZIP_CODE1 — CHAR(3)
  • ZIP_CODE2 — CHAR(3)
  • ADDRESS — VARCHAR2(80)
  • DDD — VARCHAR2(3)
  • TEL — VARCHAR2(10)
  • FAX — VARCHAR2(10)
  • HOMEPAGE — VARCHAR2(50)
  • OWNER — VARCHAR2(10)
  • STADIUM_ID (STADIUM_ID2) — CHAR(3) — 외래 키 → STADIUM.STADIUM_ID — NOT NULL