mis-60244147-LYU XUDONG
Tables (10)
Department (Untitled8)
- dept_id (pk) — Primary key — NOT NULL
- emp_id (pk2) — Foreign key → employee.emp_id — NOT NULL
- dept_id (fk) — Foreign key → employee.dept_id — NOT NULL
- name (Field)
- floor (Field2)
Dependent (Untitled2)
- dep_id (pk) — Primary key — NOT NULL
- emp_id (pk2) — Foreign key → employee.emp_id — NOT NULL
- dept_id (fk) — Foreign key → employee.dept_id — NOT NULL
- name (Field)
- gender (Field2)
- emp_id (Field3)
Project_Location (Untitled6)
- proj_id (pk) — Primary key — NOT NULL
- proj_id (fk) — Primary key — NOT NULL
- location (pk2) — Primary key — NOT NULL
- location (Field2)
Supplier (Untitled9)
- supplier_id (pk) — Primary key — NOT NULL
- name (Field)
- credit_rating (Field2)
Supplies (Untitled10)
- supplier_id (pk) — Primary key — NOT NULL
- part_id (pk2) — Primary key — NOT NULL
- proj_id (pk3) — Primary key — NOT NULL
- supplier_id (fk) — Primary key — NOT NULL
- part_id (fk2) — Primary key — NOT NULL
- proj_id (Key6) — Primary key — NOT NULL
- part_id (Key) — Foreign key → part.part_id — NOT NULL
- proj_id (pk4) — Foreign key → part.proj_id — NOT NULL
- emp_id (pk22) — Foreign key → part.emp_id — NOT NULL
- dept_id (fk3) — Foreign key → part.dept_id — NOT NULL
- proj_id (pk32) — Foreign key → part.proj_id — NOT NULL
- proj_id (fk22) — Foreign key → part.proj_id — NOT NULL
- location (pk222) — Foreign key → part.location — NOT NULL
- supplier_id (pk5) — Foreign key → Supplier.supplier_id — NOT NULL
- supplier_id (pk52) — Foreign key → part.supplier_id — NOT NULL
- supplier_id (pk42) — Foreign key → part.supplier_id — NOT NULL
- quantity (Field4)
Works_on (Untitled4)
- emp_id (pk) — Primary key — NOT NULL
- emp_id (fk) — Primary key — NOT NULL
- proj_id (fk2) — Primary key — NOT NULL
- proj_id (pk2) — Primary key — NOT NULL
- role (Field3)
- duration (Field4)
employee (Untitled)
- emp_id (pk) — Primary key — NOT NULL
- dept_id (fk) — Primary key — NOT NULL
- name (Field)
- position (Field2)
- salary (Field3)
- city (Field4)
- district (Field5)
- neighborhood (Field6)
manages (Untitled7)
- proj_id (pk) — Primary key — NOT NULL
- emp_id (fk) — Primary key — NOT NULL
- dept_id (pk2) — Foreign key → Department.dept_id — NOT NULL
- emp_id (pk22) — Foreign key → Department.emp_id — NOT NULL
- dept_id (fk2) — Foreign key → Department.dept_id — NOT NULL
- start_date (Field2)
part (Untitled5)
- part_id (Key) — Primary key — NOT NULL
- proj_id (pk) — Foreign key → project.proj_id — NOT NULL
- emp_id (pk2) — Foreign key → project.emp_id — NOT NULL
- dept_id (fk) — Foreign key → project.dept_id — NOT NULL
- proj_id (pk3) — Foreign key → project.proj_id — NOT NULL
- proj_id (fk2) — Foreign key → project.proj_id — NOT NULL
- location (pk22) — Foreign key → project.location — NOT NULL
- supplier_id (pk5) — Foreign key → Supplier.supplier_id — NOT NULL
- supplier_id (pk42) — Foreign key → project.supplier_id — NOT NULL
- name (Field)
- price (Field2)
- part_id (Field3)
- sub_part_id (Field4)
- part_id (Key2) — Foreign key → part.part_id — NOT NULL
- proj_id (pk4) — Foreign key → part.proj_id — NOT NULL
- emp_id (pk23) — Foreign key → part.emp_id — NOT NULL
- dept_id (fk3) — Foreign key → part.dept_id — NOT NULL
- proj_id (pk32) — Foreign key → part.proj_id — NOT NULL
- proj_id (fk22) — Foreign key → part.proj_id — NOT NULL
- location (pk222) — Foreign key → part.location — NOT NULL
- supplier_id (pk52) — Foreign key → part.supplier_id — NOT NULL
project (Untitled3)
- proj_id (pk) — Primary key — NOT NULL
- emp_id (pk2) — Foreign key → employee.emp_id — NOT NULL
- dept_id (fk) — Foreign key → employee.dept_id — NOT NULL
- proj_id (pk3) — Foreign key → Project_Location.proj_id — NOT NULL
- proj_id (fk2) — Foreign key → Project_Location.proj_id — NOT NULL
- location (pk22) — Foreign key → Project_Location.location — NOT NULL
- supplier_id (pk4) — Foreign key → Supplier.supplier_id — NOT NULL
- name (Field)
- budget (Field2)