사원관리
테이블 (6)
COUNTRIES
- COUNTRY_ID — CHAR(2 BYTE) — Primary
- COUNTRY_NAME — VARCHAR2(40 BYTE) — Country
- REGION_ID — NUMBER — 외래 키 → REGIONS.REGION_ID — Region
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) — 외래 키 → JOBS.JOB_ID — 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
JOBS
- JOB_ID — VARCHAR2(10 BYTE) — Primary
- JOB_TITLE — VARCHAR2(35 BYTE) — A
- MIN_SALARY — NUMBER(6,0) — Minimum
- MAX_SALARY — NUMBER(6,0) — Maximum
JOB_HISTORY
- EMPLOYEE_ID — NUMBER(6,0) — 외래 키 → EMPLOYEES.EMPLOYEE_ID — A
- START_DATE — DATE — A
- END_DATE — DATE — Last
- JOB_ID — VARCHAR2(10 BYTE) — 외래 키 → JOBS.JOB_ID — Job
- DEPARTMENT_ID — NUMBER(4,0) — Department
LOCATIONS
- LOCATION_ID — NUMBER(4,0) — Primary
- STREET_ADDRESS — VARCHAR2(40 BYTE) — Street
- POSTAL_CODE — VARCHAR2(12 BYTE) — Postal
- CITY — VARCHAR2(30 BYTE) — A
- STATE_PROVINCE — VARCHAR2(25 BYTE) — State
- COUNTRY_ID — CHAR(2 BYTE) — 외래 키 → COUNTRIES.COUNTRY_ID — Country
REGIONS
- REGION_ID — NUMBER
- REGION_NAME — VARCHAR2(25 BYTE)