연습

테이블 (8)

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) — 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

countries

  • country_id (Key) — char(2) — 기본 키 — NOT NULL
  • region_id (Key2) — nember(3) — 외래 키 → regions.region_id — NOT NULL
  • region_id (Field) — number(3)
  • country_name (Field2) — varchar2(40)

departments

  • department_id (Key) — number(6) — 기본 키 — NOT NULL
  • location_id (Field) — number(5)
  • department_name (Field2) — varchar2(30)
  • manager_id (Field3) — number(6)

employees

  • employee_id (Key) — number(6) — 기본 키 — NOT NULL
  • department_id (Key2) — number(6) — 외래 키 → departments.department_id — NOT NULL
  • job_id (Key3) — varchar2(10) — 외래 키 → jobs.job_id — NOT NULL
  • manager_id (Field) — number(6)
  • department_id (Field2) — number(6)
  • job_id (Field3) — varchar2(10)
  • first_name (Field4) — varchar2(10)
  • last_name (Field5) — varchar2(10)
  • email (Field6) — varchar2(10)
  • phone_number (Field7) — varchar2(10)
  • hire_date (Field8) — DATE
  • salary (Field9) — number(8,2)
  • location_id (Field10) — number(5)
  • commission_pct (Field11) — number(2,2)
  • job_id (Key4) — varchar2(10) — 외래 키 → jobs.job_id — NOT NULL
  • employee_id (Key5) — number(6) — 외래 키 → employees.employee_id — NOT NULL
  • department_id (Key22) — number(6) — 외래 키 → employees.department_id — NOT NULL
  • job_id (Key32) — varchar2(10) — 외래 키 → employees.job_id — NOT NULL

job_history

  • start_date (Key) — date — 기본 키 — NOT NULL
  • employee_id (Key3) — number(6) — 외래 키 → employees.employee_id — NOT NULL
  • department_id (Key22) — number(6) — 외래 키 → employees.department_id — NOT NULL
  • job_id (Key32) — varchar2(10) — 외래 키 → employees.job_id — NOT NULL
  • employee_id (Field) — number(6)
  • department_id (Field2) — number(6)
  • job_id (Field3) — varchar2(10)
  • end_date (Field4) — date
  • job_id (Key2) — varchar2(10) — 외래 키 → jobs.job_id — NOT NULL

jobs

  • job_id (Key) — varchar2(10) — 기본 키 — NOT NULL
  • job_title (Field) — varchar2(35)
  • min_salary (Field2) — number(6)
  • max_salary (Field3) — number(6)

locations

  • location_id (Key) — number(5) — 기본 키 — NOT NULL
  • country_id (Field) — char(2)
  • street_address (Field2) — varchar2(30)
  • postal_code (Field3) — varchar2(10)
  • city (Field4) — varchar2(30)
  • state_province (Field5) — varchar2(30)
  • country_id (Key2) — char(2) — 외래 키 → countries.country_id — NOT NULL
  • region_id (Key22) — nember(3) — 외래 키 → countries.region_id — NOT NULL

regions

  • region_id (Key) — nember(3) — 기본 키 — NOT NULL
  • region_name (Field) — varchar2(25)