조직트리거
테이블 (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)