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