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