HW1(2017310367)
Tables (5)
CATEGORY (Untitled5)
- catID (Key) — char(10) — Primary key — NOT NULL
- name (Field) — char(20)
- description (Field2) — text
PART (Untitled2)
- partID (Key) — char(30) — Primary key — NOT NULL
- partName (Field) — char(30)
- description (Field2) — text
- price (Field3) — int(10)
- supID (Key2) — char(30) — Foreign key → SUPPLIER.supID — NOT NULL
- catID (Key3) — char(10) — Foreign key → CATEGORY.catID — NOT NULL
PRODUCT_PART (Untitled3)
- proID (Key) — char30 — Foreign key → PROJECT.proID — NOT NULL
- partID (Key2) — char(30) — Foreign key → PART.partID — NOT NULL
- quantity (Field) — int(10)
PROJECT (Untitled)
- proID (Key) — char30 — Primary key — NOT NULL
- proName (Field) — char(30)
- category (Field2) — char(30)
- description (Field3) — text
- price (Field4) — int(10)
- releasedDate (Field5) — date
SUPPLIER (Untitled4)
- supID (Key) — char(30) — Primary key — NOT NULL
- supName (Field) — char(30)
- phone (Field2) — char(12)
- email (Field3) — char(30)
- fax (Field4) — char(30)
- grade (Field5) — text
- description (Field6) — text