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