1차발표
테이블 (8)
COUNTRIES
- COUNTRY_ID — CHAR(2 BYTE) — 기본 키 — NOT NULL
- COUNTRY_NAME — VARCHAR2(40 BYTE)
- REGION_ID — VARCHAR2(40 BYTE) — 외래 키 → REGIONS.REGION_ID — NOT NULL
Copy Of COUNTRIES (JOBS)
- Key (JOB_ID) — NUMBER(4,0) — 기본 키 — NOT NULL
- Field (JOB_TITLE) — NUMBER(4,0)
- Field2 (MIN_SALARY) — VARCHAR2(40 BYTE)
- Field3 (MAX_SALARY) — VARCHAR2(40 BYTE)
Copy Of COUNTRIES2 (EMPLOYEES)
- Key (EMPLOYEE_ID) — NUMBER(4,0) — 기본 키 — NOT NULL
- Field3 (FIRST_NAME) — VARCHAR2(40 BYTE)
- Field (LAST_NAME) — NUMBER(4,0)
- Field2 (EMAIL) — NUMBER(4,0)
- Field4 (PHONE_NUMBER) — VARCHAR2(40 BYTE)
- Field5 (HIRE_DATE) — NUMBER(4,0)
- Field6 (JOB_ID) — NUMBER(4,0)
- Field7 (SALARY) — VARCHAR2(40 BYTE)
- Field8 (COMMISSION_PCT) — VARCHAR2(40 BYTE)
- Key (MANAGER_ID) — VARCHAR2(40 BYTE) — 외래 키 → Copy Of COUNTRIES2.Key — NOT NULL
- DEPARTMENT_ID — VARCHAR2(40 BYTE) — 외래 키 → DEPARTMENTS.DEPARTMENT_ID — NOT NULL
DEPARTMENTS
- DEPARTMENT_ID — NUMBER(4,0) — 기본 키 — NOT NULL
- DEPARTMENT_NAME — NUMBER(4,0)
- MANAGER_ID — VARCHAR2(40 BYTE)
- LOCATION_ID — VARCHAR2(40 BYTE) — 외래 키 → LOCATIONS.LOCATION_ID — NOT NULL
LOCATIONS
- LOCATION_ID — NUMBER(4,0) — 기본 키 — NOT NULL
- STREET_ADDRESS — VARCHAR2(40 BYTE)
- POSTAL_CODE — VARCHAR2(12 BYTE)
- CITY — VARCHAR2(30 BYTE)
- STATE_PROVINCE — VARCHAR2(25 BYTE)
- COUNTRY_ID — VARCHAR2(40 BYTE) — 외래 키 → COUNTRIES.COUNTRY_ID — NOT NULL
REGIONS
- REGION_ID — NUMBER — 기본 키 — NOT NULL
- REGION_NAME — VARCHAR2(40 BYTE)
Untitled (JOB_HISTORY)
- Key (EMPLOYEE_ID) — NUMBER(4,0) — 외래 키 → Copy Of COUNTRIES2.Key — NOT NULL
- Field (START_DATE) — NUMBER(4,0)
- Field2 (END_DATE) — NUMBER(4,0)
- Field3 (JOB_ID) — NUMBER(4,0)
- Field4 (DEPARTMENT_ID) — VARCHAR2(40 BYTE)
- Key (JOB_ID2) — NUMBER(4,0) — 외래 키 → Copy Of COUNTRIES.Key — NOT NULL
Untitled (JOB_GRADES)
- Field2 (LOWEST_SAL) — VARCHAR2(40 BYTE)
- Field3 (HIGHEST_SAL) — VARCHAR2(40 BYTE)
- Field (GRADE_LEVEL) — VARCHAR2(40 BYTE)