dept
Tables (6)
DEPT (Untitled)
- DEPTNO (부서번호) — 10 — Primary key — NOT NULL
- DNAME (부서명) — 50
- LOC (지역) — 50
EMP (Untitled2)
- EMPNO (사원번호) — 10 — Primary key — NOT NULL
- DEPTNO (부서번호) — 10 — Foreign key → DEPT.DEPTNO — NOT NULL
- ENAME (사원명) — 50
- JOB (직종) — 50
- MGR (상사) — 10
- HIRDATE (고용일) — 10
- SAL (급여) — 10
- COMM (보너스) — 10
PLAYER (Untitled4)
- PLAYERID (선수번호) — 10 — Primary key — NOT NULL
- TEAMID (팀번호2) — 10 — Foreign key → TEAM.TEAMID — NOT NULL
- STADIUMID (구장번호) — 10 — Foreign key → TEAM.STADIUMID — NOT NULL
- TEAM_ID (팀번호) — 10
- E_PLAYER_NAME (Field) — 30
SCHEDULE (Untitled6)
- SCHEDATE (날짜) — 10 — Primary key — NOT NULL
- STADIUMID (구장번호2) — 10 — Foreign key → STADIUM.STADIUMID — NOT NULL
- GUBUN (Field) — 10
- HOMETEAMID (홈구장번호) — 10
STADIUM (Untitled5)
- STADIUMID (구장번호) — 10 — Primary key — NOT NULL
- HOMETEAM_ID (홈구장번호) — 10
TEAM (Untitled3)
- TEAMID (팀번호) — 10 — Primary key — NOT NULL
- STADIUMID (구장번호) — 10 — Foreign key → STADIUM.STADIUMID — NOT NULL
- REGION_NAME (연고지) — 30
- TEAM_NAME (팀명) — 30
- E_TEAM_NAME (Field) — 30
- ORIGYYYY (창단년도) — 10
- STADIUM_ID (구단번호) — 10