dept
Tables (6)
DEPT (Untitled)
- deptno (부서번호) — 10 — Primary key — NOT NULL
- dname (부서명) — 50
- loc (주소) — 50
EMP (Untitled2)
- ename (직원명) — 50 — Primary key — NOT NULL
- deptno (부서번호) — 10 — Foreign key → DEPT.deptno — NOT NULL
- job (직업) — 50
- mgr (매니저) — 50
- hiredate (고용일) — 50
- sal (연봉) — 10
- comm (보너스) — 10
PLAYER_ID (Untitled4)
- player_name (선수명) — Primary key — NOT NULL
- region_name (지역명) — 10 — Foreign key → TEAM.region_name — NOT NULL
- stadium_name (Key) — Foreign key → TEAM.stadium_name — NOT NULL
- team_id (Field)
- e_player_name (Field2)
SCHEDULE (Untitled6)
- gubun (Key) — Primary key — NOT NULL
- stadium_name (Key2) — Foreign key → STADIUM.stadium_name — NOT NULL
- hometeam_id (Field)
- awayteam_id (Field2)
STADIUM (Untitled5)
- stadium_name (Key) — Primary key — NOT NULL
- hometeam_id (Field)
- seat_count (Field2)
TEAM (Untitled3)
- region_name (지역명) — 10 — Primary key — NOT NULL
- stadium_name (Key) — Foreign key → STADIUM.stadium_name — NOT NULL
- team_name (팀명) — 10
- e_team_name (영문팀명) — 10
- orig_yyyy (Field)
- stadium_id (Field2)