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)