DATE MODEL REAL

Tables (6)

MATCH (TBB)

  • MATCH_ID (경기ID) — VARCHAR2 — Primary key — NOT NULL
  • HSCORE (홈팀점수) — NUMBER — NOT NULL
  • ASCORE (어웨이팀점수) — NUMBER — NOT NULL
  • MATCH_DATE (경기날짜) — DATE — NOT NULL
  • TEAM_ID (팀ID) — VARCHAR2 — Foreign key → TEAM.TEAM_ID — NOT NULL
  • HTEAM_ID (Field) — VARCHAR2 — NOT NULL
  • ATEAM_ID (Field2) — VARCHAR2 — NOT NULL

PLAYER (PALYER)

  • PL_ID (선수ID) — VARCHAR2(3) — Primary key — NOT NULL
  • POS_ID (포지션ID) — CH(2) — Foreign key → POSITION.POS_ID — NOT NULL
  • PL_NAME (선수이름) — VARCHAR2(20) — NOT NULL
  • PL_NUM (등번호) — CHAR(2)
  • GOAL (골 기록) — NUMBER
  • BONUS (득점수당) — NUMBER

PLAYER (TB)

  • PL_ID (선수ID) — VARCHAR2 — Primary key — NOT NULL
  • PL_NAME (선수이름) — VARCHAR2 — NOT NULL
  • POSITION (포지션) — CHAR — NOT NULL
  • BACK_NUM (등번호) — NUMBER — NOT NULL
  • TEAM_ID (팀ID) — VARCHAR2 — Foreign key → TEAM.TEAM_ID — NOT NULL

POSITION

  • POS_ID (포지션ID) — CH(2) — Primary key — NOT NULL
  • POSITION (포지션) — VARCHAR2(35)

RECODE (T)

  • RECODE_ID (기록ID) — VARCHAR2 — Primary key — NOT NULL
  • PLAY_TIME (출전시간) — NUMBER — NOT NULL
  • GOAL (득점) — NUMBER — NOT NULL
  • MATCH_ID (경기ID) — VARCHAR2 — Foreign key → MATCH.MATCH_ID — NOT NULL
  • PL_ID (선수ID) — VARCHAR2 — Foreign key → PLAYER.PL_ID — NOT NULL

TEAM (TABLE)

  • TEAM_ID (팀ID) — VARCHAR2 — Primary key — NOT NULL
  • TEAM_NAME (팀이름) — VARCHAR2 — NOT NULL
  • LOCATION (연고지) — VARCHAR2 — NOT NULL
  • MANAGER (감독) — VARCHAR2 — NOT NULL