과제
테이블 (7)
LOCATIONS (Untitled3)
- location_id (Key) — 기본 키 — NOT NULL
- country_id (Key3) — 외래 키 → 컨트리(COUNTRIES).country_id — NOT NULL
- street_address (Field)
- postal_code (Field2)
- city (Field3)
- state_province (Field4)
디파트먼트(DEPARTMENTS) (Untitled4)
- department_id (Key) — 기본 키 — NOT NULL
- department_name (Field)
- manager_id (Field2)
- location_id (Key2) — 외래 키 → LOCATIONS.location_id — NOT NULL
- country_id (Key3) — 외래 키 → LOCATIONS.country_id — NOT NULL
리전(REGIONS) (Untitled)
- region_id (Key) — 기본 키 — NOT NULL
- region_name (Field)
임플로이(EMPLOYEES) (Untitled5)
- employee_id (Key) — 기본 키 — NOT NULL
- manager_id (Field7) — 기본 키
- job_id (Field9) — 기본 키
- name (Field)
- email (Field2)
- tel (Field3)
- hire_date (Field4)
- sal (Field5)
- bonus (Field6)
- dept_id (Field8)
잡스(JOBS) (Untitled6)
- job_id (Field9) — 기본 키
- job_id (Field92) — 외래 키 → 임플로이(EMPLOYEES).job_id
- JOB_TITLE (Field)
- MIN_SALARY (Field2)
- MAX_SALARY (Field3)
잡히스토리(JOB_HISTORY) (Untitled7)
- job_id (Field9) — 기본 키
- start_date (Field)
- end_date (Field2)
- department_id (Field4)
- job_id (Field92) — 외래 키 → 임플로이(EMPLOYEES).job_id
컨트리(COUNTRIES) (Untitled2)
- country_id (Key) — 기본 키 — NOT NULL
- country_name (Field)
- region_id (Key2) — 외래 키 → 리전(REGIONS).region_id — NOT NULL