연습
테이블 (8)
EMPLOYEES
- EMPLOYEE_ID — NUMBER(6,0) — Primary
- FIRST_NAME — VARCHAR2(20 BYTE) — First
- LAST_NAME — VARCHAR2(25 BYTE) — Last
- EMAIL — VARCHAR2(25 BYTE) — Email
- PHONE_NUMBER — VARCHAR2(20 BYTE) — Phone
- HIRE_DATE — DATE — Date
- JOB_ID — VARCHAR2(10 BYTE) — Current
- SALARY — NUMBER(8,2) — Monthly
- COMMISSION_PCT — NUMBER(2,2) — Commission
- MANAGER_ID — NUMBER(6,0) — 외래 키 → EMPLOYEES.EMPLOYEE_ID — Manager
- DEPARTMENT_ID — NUMBER(4,0) — Department
countries
- country_id (Key) — char(2) — 기본 키 — NOT NULL
- region_id (Key2) — nember(3) — 외래 키 → regions.region_id — NOT NULL
- region_id (Field) — number(3)
- country_name (Field2) — varchar2(40)
departments
- department_id (Key) — number(6) — 기본 키 — NOT NULL
- location_id (Field) — number(5)
- department_name (Field2) — varchar2(30)
- manager_id (Field3) — number(6)
employees
- employee_id (Key) — number(6) — 기본 키 — NOT NULL
- department_id (Key2) — number(6) — 외래 키 → departments.department_id — NOT NULL
- job_id (Key3) — varchar2(10) — 외래 키 → jobs.job_id — NOT NULL
- manager_id (Field) — number(6)
- department_id (Field2) — number(6)
- job_id (Field3) — varchar2(10)
- first_name (Field4) — varchar2(10)
- last_name (Field5) — varchar2(10)
- email (Field6) — varchar2(10)
- phone_number (Field7) — varchar2(10)
- hire_date (Field8) — DATE
- salary (Field9) — number(8,2)
- location_id (Field10) — number(5)
- commission_pct (Field11) — number(2,2)
- job_id (Key4) — varchar2(10) — 외래 키 → jobs.job_id — NOT NULL
- employee_id (Key5) — number(6) — 외래 키 → employees.employee_id — NOT NULL
- department_id (Key22) — number(6) — 외래 키 → employees.department_id — NOT NULL
- job_id (Key32) — varchar2(10) — 외래 키 → employees.job_id — NOT NULL
job_history
- start_date (Key) — date — 기본 키 — NOT NULL
- employee_id (Key3) — number(6) — 외래 키 → employees.employee_id — NOT NULL
- department_id (Key22) — number(6) — 외래 키 → employees.department_id — NOT NULL
- job_id (Key32) — varchar2(10) — 외래 키 → employees.job_id — NOT NULL
- employee_id (Field) — number(6)
- department_id (Field2) — number(6)
- job_id (Field3) — varchar2(10)
- end_date (Field4) — date
- job_id (Key2) — varchar2(10) — 외래 키 → jobs.job_id — NOT NULL
jobs
- job_id (Key) — varchar2(10) — 기본 키 — NOT NULL
- job_title (Field) — varchar2(35)
- min_salary (Field2) — number(6)
- max_salary (Field3) — number(6)
locations
- location_id (Key) — number(5) — 기본 키 — NOT NULL
- country_id (Field) — char(2)
- street_address (Field2) — varchar2(30)
- postal_code (Field3) — varchar2(10)
- city (Field4) — varchar2(30)
- state_province (Field5) — varchar2(30)
- country_id (Key2) — char(2) — 외래 키 → countries.country_id — NOT NULL
- region_id (Key22) — nember(3) — 외래 키 → countries.region_id — NOT NULL
regions
- region_id (Key) — nember(3) — 기본 키 — NOT NULL
- region_name (Field) — varchar2(25)