과제(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)