TEST
Tables (6)
COUNTRY (국가)
- COUNTRY_ID (Primary_Key) — CHAR(2 BYTE) — Primary key
- COUNTRY_NAME (Check) — VARCHAR2(30 BYTE)
DEPARTMENT (부서)
- DEPT_ID (Primary_Key) — CHAR(2 BYTE) — Primary key
- DEPT_NAME (Check) — VARCHAR2(30 BYTE)
- LOCATION_ID (Foreign_Key) — CHAR(2 BYTE) — Foreign key → LOCATION.LOCATION_ID
EMPLOYEE (직원)
- EMP_ID (Primary_Key) — CHAR(3 BYTE) — Primary key
- EMP_NAME (Check/NOTNULL) — VARCHAR2(20 BYTE)
- EMP_NO (Check/NotNull/Unique) — CHAR(14 BYTE)
- EMAIL (Field6) — VARCHAR2(25 BYTE)
- PHONE (Field7) — VARCHAR2(12 BYTE)
- HIRE_DATE (Field8) — .DATE
- JOB_ID (Foreign_Key(FK)) — CHAR(2 BYTE) — Foreign key → JOB.JOB_ID
- SALARY (Field9) — NUMBER
- BONUS_PCT (Field10) — NUMBER
- MARRIAGE (Check) — CHAR(1 BYTE)
- DEPT_ID (Foreign_Key) — CHAR(2 BYTE) — Foreign key → DEPARTMENT.DEPT_ID
- MGR_ID (Foreign_Key_FK) — CHAR(3 BYTE) — Foreign key → EMPLOYEE.EMP_ID
JOB (직급)
- JOB_ID (Primary_Key) — CHAR(2 BYTE) — Primary key
- JOB_NAME (Field2) — VARCHAR2(35 BYTE)
- MIN_SAL (Field3) — NUMBER
- MAX_SAL (Field4) — NUMBER
LOCATION (지역)
- LOCATION_ID (Primary_Key) — CHAR(2 BYTE) — Primary key
- COUNTRY_ID (Foreign_Key) — CHAR(2 BYTE) — Foreign key → COUNTRY.COUNTRY_ID
- LOC_DESCRIBE (Field3) — VARCHAR2(40 BYTE)
SAL_GRADE (급여등급)
- SLEVE (Primary_Key) — CHAR(1 BYTE) — Primary key
- LOWEST (Field2) — NUMBER
- FIGHEST (Field3) — NUMBER