hr
테이블 (8)
COUNTRIES
- Key3 (COUNTRY_ID) — CHAR(2) — 기본 키 — NOT NULL
- Field (COUNTRY_NAME) — VARCHAR2(40)
- Key (REGION_ID) — NUMBER — 외래 키 → REGIONS.Key — NOT NULL
DEPARTMENTS
- Key (DEPARTMENT_ID) — NUMBER(4) — 기본 키 — NOT NULL
- Field (DEPARTMENT_NAME) — VARCHAR2(30) — NOT NULL
- Key (MANAGER_ID) — NUMBER(6) — 외래 키 → 직원.Key
- Key (LOCATION_ID) — NUMBER(4) — 외래 키 → LOCATIONS.Key
JOBS
- Key (JOB_ID) — VARCHAR2(10) — 기본 키 — NOT NULL
- Field (JOB_TITLE) — VARCHAR2(35) — NOT NULL
- Field2 (MIN_SALARY) — NUMBER(6)
- Field3 (MAX_SALARY) — NUMBER(6)
JOB_GRADES
- Field (GRADE_LEVEL) — VARCHAR2(3)
- Field2 (LOWEST_SAL) — NUMBER
- Field3 (HIGHEST_SAL) — NUMBER
JOB_HISTORY
- Key (EMPLOYEE_ID) — NUMBER(6) — 외래 키 → 직원.Key — NOT NULL
- Field (START_DATE) — DATE — NOT NULL
- Field2 (END_DATE) — DATE — NOT NULL
- Key (JOB_ID) — VARCHAR2(10) — 외래 키 → JOBS.Key — NOT NULL
- Key (DEPARTMENT_ID) — NUMBER(4) — 외래 키 → DEPARTMENTS.Key — NOT NULL
LOCATIONS
- Key (LOCATION_ID) — NUMBER(4) — 기본 키 — NOT NULL
- Field (STREET_ADDRESS) — VARCHAR2(40)
- Field2 (POSTAL_CODE) — VARCHAR2(12)
- Field3 (CITY) — VARCHAR2(30)
- Field (STATE_PROVINCE) — VARCHAR2(25) — NOT NULL
- Field
- Key3 (COUNTRY_ID) — CHAR(2) — 외래 키 → COUNTRIES.Key3 — NOT NULL
REGIONS
- Key (REGION_ID) — NUMBER — 기본 키 — NOT NULL
- Field (REGION_NAME) — VARCHAR2(25)
직원 (EMPLOYEES)
- Key (EMPLOYEE_ID) — NUMBER(6) — 기본 키 — NOT NULL
- Field (FIRST_NAME) — VARCHAR2(20)
- Field2 (LAST_NAME) — VARCHAR2(25) — NOT NULL
- Field3 (EMAIL) — VARCHAR2(25) — NOT NULL
- Field4 (PHONE_NUMBER) — VARCHAR2(20)
- Field5 (HIRE_DATE) — DATE — NOT NULL
- Key (JOB_ID) — VARCHAR2(10) — 외래 키 → JOBS.Key — NOT NULL
- Field (SALARY) — NUMBER(8,2)
- Field2 (COMMISSION_PCT) — NUMBER(2,2)
- Key (MANAGER_ID) — NUMBER(6) — 외래 키 → 직원.Key
- Key (DEPARTMENT_ID) — NUMBER(4) — 외래 키 → DEPARTMENTS.Key