MID_60230786_손효주

테이블 (10)

Department

  • dept id (dept_id) — int — 기본 키 — NOT NULL
  • name — varchar
  • floor
  • emp id (emp_id) — int — 외래 키 → employee.emp id — NOT NULL
  • project_id — int — 외래 키 → project.project_id — NOT NULL

Supplier

  • supplier_id — int — 기본 키 — NOT NULL
  • name — varchar
  • credit_rating — int
  • part id (part_id) — int — 외래 키 → part.part id — NOT NULL

dependent

  • dependent id (dependent_id) — int — 기본 키 — NOT NULL
  • emp id (emp_id2) — int — 외래 키 → employee.emp id — NOT NULL
  • gender — varchar
  • emp_id — int
  • name — varchar

employee

  • emp id (emp_id) — int — 기본 키 — NOT NULL
  • name — VARCHAR
  • salary — int
  • city — varchar
  • district — varchar
  • neighborhood — varchar
  • dept_id — int

part

  • part id (part_id) — int — 기본 키 — NOT NULL
  • name — varchar
  • price — int
  • parent_part_id — int
  • part id (part_id2) — int — 외래 키 → part.part id — NOT NULL

project

  • project_id — int — 기본 키 — NOT NULL
  • name — varchar
  • budget — int
  • emp id (emp_id) — int — 외래 키 → employee.emp id — NOT NULL

project_location

  • project_id — int — 기본 키 — NOT NULL
  • location — varchar
  • part id (part_id) — int — 외래 키 → part.part id — NOT NULL

project_manager

  • project_id — int — 기본 키 — NOT NULL
  • emp_id — int
  • start_date — date
  • project_id (project_id2) — int — 외래 키 → project_location.project_id — NOT NULL

supplier_part_project

  • supplier_id — int — 기본 키 — NOT NULL
  • part_id — int
  • project_id — int
  • quantity — int

works_on

  • emp_id — int — 기본 키 — NOT NULL
  • project_id — int
  • role — varchar
  • duration — int