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