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