조직트리거

테이블 (5)

BELONG

  • Key (TEAM_SN) — 외래 키 → TEAM.Key — NOT NULL
  • Key (EMP_NUM) — NUMBER — 외래 키 → EMPLOYEE.Key — NOT NULL
  • Field (BELONG_DT)

DEPARTMENT (Department)

  • Key (DEPART_SN) — NUMBER — 기본 키 — NOT NULL
  • Key (BUSINESS_SN) — NUMBER — 외래 키 → business_department.Key — NOT NULL
  • Field (DEPART_NAME) — VARCHAR2

EMPLOYEE

  • Key (EMP_NUM) — NUMBER — 기본 키 — NOT NULL
  • Field (EMP_POSITION) — VARCHAR2(20)
  • Field (EMP_NAME)

TEAM

  • Key (TEAM_SN) — 기본 키 — NOT NULL
  • Field (TEAM_NAME) — VARCHAR2(30)
  • Key (DEPART_SN) — NUMBER — 외래 키 → DEPARTMENT.Key — NOT NULL
  • Key (BUSINESS_SN) — NUMBER — 외래 키 → DEPARTMENT.Key — NOT NULL

business_department

  • Key (BUSINESS_SN) — NUMBER — 기본 키 — NOT NULL
  • Field (BUSINESS_NAME) — VARCHAR2(10)