ERD Exercise1
Tables (5)
CATEGORY (Untitled4)
- cateNum (Key) — char(30) — Primary key — NOT NULL
- name (Field) — char(100)
- description (Field2) — text
PART (Untitled3)
- partID (Key) — integer — Primary key — NOT NULL
- name (Field) — char(20)
- modelNumber (Field2) — char(30)
- description (Field3) — text
- price (Field4) — integer
- suplierID (Key2) — integer(10) — Foreign key → SUPPLIER.suplierID — NOT NULL
- cateNum (Key3) — char(30) — Foreign key → CATEGORY.cateNum — NOT NULL
PRODUCT (Untitled2)
- modelNumber (Key) — char(30) — Primary key — NOT NULL
- name (Field) — char(30)
- description (Field2) — text
- price (Field3) — integer
PRODUCT_PART (Untitled5)
- modelNumber (Key) — char(30) — Foreign key → PRODUCT.modelNumber — NOT NULL
- partID (Key2) — integer — Foreign key → PART.partID — NOT NULL
- quantity (Field) — integer(10)
SUPPLIER (Untitled)
- suplierID (Key) — integer(10) — Primary key — NOT NULL
- name (Field) — char(30)
- phone (Field2) — char(30)
- email (Field3) — email
- address (Field4) — char(50)
- description (Field5) — text
- grade (Field6) — integer(1)