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)