HR
테이블 (7)
Untitled (DEPARTMENTS)
- (DEPARTMENT_ID) — NUMBER(4,0) — 기본 키 — NOT NULL
- (LOCATION_ID) — NUMBER(4,0) — 외래 키 → 지역정보.LOCATION_ID — NOT NULL
- Key (MANAGER_ID) — NUMBER(6,0) — 외래 키 → Untitled.Key
- (DEPARTMENT_NAME) — VARCHAR2(30)
Untitled (EMPLOYEES)
- Key (EMPLOYEE_ID) — NUMBER(6,0) — 기본 키 — NOT NULL
- (DEPARTMENT_ID) — NUMBER(4,0) — 외래 키 → Untitled.DEPARTMENT_ID — NOT NULL
- Key (JOB_ID) — VARCHAR2(10) — 외래 키 → Untitled.Key — NOT NULL
- Field (FIRST_NAME) — VARCHAR2(20)
- Field (LAST_NAME) — VARCHAR2(25)
- Field (EMAIL) — VARCHAR2(25)
- Field (PHONE_NUMBER) — VARCHAR2(20)
- Field (HIRE_DATE) — DATE
- Field (SALARY) — NUMBER(8,2)
- Field (COMMISION_PCT) — NUMBER(2,2)
- Key (MANAGER_ID) — NUMBER(6,0) — 외래 키 → Untitled.Key — NOT NULL
Untitled (JOBS)
- Key (JOB_ID) — VARCHAR2(10) — 기본 키 — NOT NULL
- Field (JOB_TITLE) — VARCHAR2(35)
- Field (MIN_SALARY) — NUMBER(6,0)
- Field (MAX_SALARY) — NUMBER(6,0)
Untitled (JOB_HISTORY)
- Key (EMPLOYEE_ID+ START_DATE) — NUMBER(6,0)+DATE — 기본 키 — NOT NULL
- Key (EMPLOYEE_ID) — NUMBER(6,0) — 외래 키 → Untitled.Key — NOT NULL
- Key (JOB_ID) — VARCHAR2(10) — 외래 키 → Untitled.Key — NOT NULL
- (DEPARTMENT_ID) — NUMBER(4,0) — 외래 키 → Untitled.DEPARTMENT_ID
- Field (START_DATE) — DATE — NOT NULL
- Field (END_DATE) — DATE — NOT NULL
국가정보 (COUNTRIES)
- (COUNTRY_ID) — CHAR(2) — 기본 키 — NOT NULL
- (REGION_ID) — NUMBER — 외래 키 → 대륙정보.REGION_ID — NOT NULL
- (COUNTRY_NAME) — VARCHAR2(40)
대륙정보 (REGIONS)
- (REGION_ID) — NUMBER — 기본 키 — NOT NULL
- (REGION_NAME) — VARCHAR2(25)
지역정보 (LOCATIONS)
- (LOCATION_ID) — NUMBER(4,0) — 기본 키 — NOT NULL
- (COUNTRY_ID) — CHAR(2) — 외래 키 → 국가정보.COUNTRY_ID — NOT NULL
- (STREET_ADDRESS) — VARCHAR2(40)
- (POSTAL_CODE) — VARCHAR2(12)
- (CITY) — VARCHAR2(30)
- (STATE_PROVINCE) — VARCHAR2(25)