사원관리

테이블 (6)

COUNTRIES

  • COUNTRY_ID — CHAR(2 BYTE) — Primary
  • COUNTRY_NAME — VARCHAR2(40 BYTE) — Country
  • REGION_ID — NUMBER — 외래 키 → REGIONS.REGION_ID — Region

EMPLOYEES

  • EMPLOYEE_ID — NUMBER(6,0) — Primary
  • FIRST_NAME — VARCHAR2(20 BYTE) — First
  • LAST_NAME — VARCHAR2(25 BYTE) — Last
  • EMAIL — VARCHAR2(25 BYTE) — Email
  • PHONE_NUMBER — VARCHAR2(20 BYTE) — Phone
  • HIRE_DATE — DATE — Date
  • JOB_ID — VARCHAR2(10 BYTE) — 외래 키 → JOBS.JOB_ID — Current
  • SALARY — NUMBER(8,2) — Monthly
  • COMMISSION_PCT — NUMBER(2,2) — Commission
  • MANAGER_ID — NUMBER(6,0) — 외래 키 → EMPLOYEES.EMPLOYEE_ID — Manager
  • DEPARTMENT_ID — NUMBER(4,0) — Department

JOBS

  • JOB_ID — VARCHAR2(10 BYTE) — Primary
  • JOB_TITLE — VARCHAR2(35 BYTE) — A
  • MIN_SALARY — NUMBER(6,0) — Minimum
  • MAX_SALARY — NUMBER(6,0) — Maximum

JOB_HISTORY

  • EMPLOYEE_ID — NUMBER(6,0) — 외래 키 → EMPLOYEES.EMPLOYEE_ID — A
  • START_DATE — DATE — A
  • END_DATE — DATE — Last
  • JOB_ID — VARCHAR2(10 BYTE) — 외래 키 → JOBS.JOB_ID — Job
  • DEPARTMENT_ID — NUMBER(4,0) — Department

LOCATIONS

  • LOCATION_ID — NUMBER(4,0) — Primary
  • STREET_ADDRESS — VARCHAR2(40 BYTE) — Street
  • POSTAL_CODE — VARCHAR2(12 BYTE) — Postal
  • CITY — VARCHAR2(30 BYTE) — A
  • STATE_PROVINCE — VARCHAR2(25 BYTE) — State
  • COUNTRY_ID — CHAR(2 BYTE) — 외래 키 → COUNTRIES.COUNTRY_ID — Country

REGIONS

  • REGION_ID — NUMBER
  • REGION_NAME — VARCHAR2(25 BYTE)