과제(1월16일)
테이블 (4)
DEPARTMENTS
- DEPARTMENT_ID — number(6) — 기본 키 — NOT NULL
- LOCATION_ID — number(5) — 기본 키 — NOT NULL
- employee_id — number(6) — 외래 키 → EMPLOYEES.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID2) — number(6) — 외래 키 → EMPLOYEES.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID2) — number(5) — 외래 키 → EMPLOYEES.LOCATION_ID — NOT NULL
- employee_id (employee_id2) — number(6) — 외래 키 → EMPLOYEES.employee_id — NOT NULL
- EMPLOYEE_ID — NUMBER(6) — 외래 키 → EMPLOYEES.EMPLOYEE_ID — NOT NULL
- START_DATE — DATE — 외래 키 → EMPLOYEES.START_DATE — NOT NULL
- JOB_ID (JOB_ID2) — VARCHAR2(10) — 외래 키 → EMPLOYEES.JOB_ID — NOT NULL
- employee_id (employee_id3) — number(6) — 외래 키 → EMPLOYEES.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID22) — number(6) — 외래 키 → EMPLOYEES.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID22) — number(5) — 외래 키 → EMPLOYEES.LOCATION_ID — NOT NULL
- employee_id (employee_id22) — number(6) — 외래 키 → EMPLOYEES.employee_id — NOT NULL
- DEPARTMENT_NAME — VARCHAR2(30)
- MANAGER_ID — number(6)
EMPLOYEES
- employee_id — number(6) — 기본 키 — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID2) — number(6) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID — number(5) — 외래 키 → DEPARTMENTS.LOCATION_ID — NOT NULL
- employee_id (employee_id2) — number(6) — 외래 키 → DEPARTMENTS.employee_id — NOT NULL
- EMPLOYEE_ID — NUMBER(6) — 외래 키 → JOB_HISTORY.EMPLOYEE_ID — NOT NULL
- START_DATE — DATE — 외래 키 → JOB_HISTORY.START_DATE — NOT NULL
- JOB_ID (JOB_ID2) — VARCHAR2(10) — 외래 키 → JOB_HISTORY.JOB_ID — NOT NULL
- employee_id (employee_id3) — number(6) — 외래 키 → JOB_HISTORY.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID22) — number(6) — 외래 키 → JOB_HISTORY.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID2) — number(5) — 외래 키 → JOB_HISTORY.LOCATION_ID — NOT NULL
- employee_id (employee_id22) — number(6) — 외래 키 → JOB_HISTORY.employee_id — NOT NULL
- MANAGER_ID — number(6)
- DEPARTMENT_ID — number(6)
- JOB_ID — VARCHAR2(10)
- FIRST_NAME — VARCHAR2(20)
- LAST_NAME — VARCHAR2(25)
JOBS
- JOB_ID — VARCHAR2(10) — 기본 키 — NOT NULL
- JOB_TITLE — VARCHAR2(35)
- MIN_SALARY — NUMBER(6)
- MAX_SALARY — NUMBER(6)
- EMPLOYEE_ID — NUMBER(6) — 외래 키 → JOB_HISTORY.EMPLOYEE_ID — NOT NULL
- START_DATE — DATE — 외래 키 → JOB_HISTORY.START_DATE — NOT NULL
- JOB_ID (JOB_ID2) — VARCHAR2(10) — 외래 키 → JOB_HISTORY.JOB_ID — NOT NULL
- DEPARTMENT_ID — number(6) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID — number(5) — 외래 키 → DEPARTMENTS.LOCATION_ID — NOT NULL
- employee_id — number(6) — 외래 키 → DEPARTMENTS.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID2) — number(6) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID2) — number(5) — 외래 키 → DEPARTMENTS.LOCATION_ID — NOT NULL
- employee_id (employee_id2) — number(6) — 외래 키 → DEPARTMENTS.employee_id — NOT NULL
- EMPLOYEE_ID (EMPLOYEE_ID2) — NUMBER(6) — 외래 키 → DEPARTMENTS.EMPLOYEE_ID — NOT NULL
- START_DATE (START_DATE2) — DATE — 외래 키 → DEPARTMENTS.START_DATE — NOT NULL
- JOB_ID (JOB_ID22) — VARCHAR2(10) — 외래 키 → DEPARTMENTS.JOB_ID — NOT NULL
- employee_id (employee_id3) — number(6) — 외래 키 → DEPARTMENTS.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID22) — number(6) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID22) — number(5) — 외래 키 → DEPARTMENTS.LOCATION_ID — NOT NULL
- employee_id (employee_id22) — number(6) — 외래 키 → DEPARTMENTS.employee_id — NOT NULL
JOB_HISTORY
- EMPLOYEE_ID — NUMBER(6) — 기본 키 — NOT NULL
- START_DATE — DATE — 기본 키 — NOT NULL
- JOB_ID (JOB_ID2) — VARCHAR2(10) — 외래 키 → JOBS.JOB_ID — NOT NULL
- employee_id — number(6) — 외래 키 → JOBS.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID2) — number(6) — 외래 키 → JOBS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID2) — number(5) — 외래 키 → JOBS.LOCATION_ID — NOT NULL
- employee_id (employee_id2) — number(6) — 외래 키 → JOBS.employee_id — NOT NULL
- EMPLOYEE_ID (EMPLOYEE_ID2) — NUMBER(6) — 외래 키 → JOBS.EMPLOYEE_ID — NOT NULL
- START_DATE (START_DATE2) — DATE — 외래 키 → JOBS.START_DATE — NOT NULL
- JOB_ID (JOB_ID22) — VARCHAR2(10) — 외래 키 → JOBS.JOB_ID — NOT NULL
- employee_id (employee_id3) — number(6) — 외래 키 → JOBS.employee_id — NOT NULL
- DEPARTMENT_ID (DEPARTMENT_ID22) — number(6) — 외래 키 → JOBS.DEPARTMENT_ID — NOT NULL
- LOCATION_ID (LOCATION_ID22) — number(5) — 외래 키 → JOBS.LOCATION_ID — NOT NULL
- employee_id (employee_id22) — number(6) — 외래 키 → JOBS.employee_id — NOT NULL
- END_DATE (.) — DATE
- JOB_ID — VARCHAR2(10)
- DEPARTMENT_ID — NUMBER(4)