new

Tables (7)

countries (나라)

  • country_id — CHAR(2) — Primary key — NOT NULL
  • country_name — VARCHAR(40)
  • region_id — INT — Foreign key → regions.region_id — NOT NULL

departments (부서)

  • department_id — INT — Primary key — NOT NULL
  • department_name — VARCHAR(30) — NOT NULL
  • manager_id — INT — Foreign key → employees.employee_id
  • location_id — INT — Foreign key → locations.location_id — NOT NULL

employees (직원)

  • employee_id — INT — Primary key — NOT NULL
  • first_name — VARCHAR(20)
  • last_name — VARCHAR(25) — NOT NULL
  • email — VARCHAR(25) — NOT NULL
  • phone_number — VARCHAR(20)
  • hire_date — DATE — NOT NULL
  • job_id — VARCHAR(10) — Foreign key → jobs.job_id — NOT NULL
  • salary — DECIMAL(8, 2) — NOT NULL
  • commission_pct — DECIMAL(2, 2)
  • manager_id (employee_id2) — INT — Foreign key → employees.employee_id — NOT NULL
  • department_id — INT — Foreign key → departments.department_id — NOT NULL

job_history

  • employee_id — INT — Foreign key → employees.employee_id — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • job_id — VARCHAR(10) — Foreign key → jobs.job_id — NOT NULL
  • department_id — INT — Foreign key → departments.department_id — NOT NULL

jobs (직업)

  • job_id — VARCHAR(10) — Primary key — NOT NULL
  • job_title — VARCHAR(35) — NOT NULL
  • min_salary — DECIMAL(8, 0)
  • max_salary — DECIMAL(8, 0)

locations (장소)

  • location_id — INT — Primary key — NOT NULL
  • street_address — VARCHAR(40)
  • postal_code — VARCHAR(12)
  • city — VARCHAR(30) — NOT NULL
  • state_province — VARCHAR(25)
  • country_id — CHAR(2) — Foreign key → countries.country_id — NOT NULL

regions (지역)

  • region_id — INT — Primary key — NOT NULL
  • region_name — VARCHAR(25)