Exercise1
Tables (6)
DEPARTMENT (COMPANY)
- modelNO (model number) — char(5) — Primary key — NOT NULL
- Key — Primary key — NOT NULL
- Field (number) — char(5)
PRODUCER
- modelNO (proID) — char(5) — Primary key — NOT NULL
- name (proName) — char(20)
- address — char(40)
- call (phone) — char(11)
PRODUCT
- number (proID) — char(5) — Primary key — NOT NULL
- explain — text
- price — char(10)
- Field (proName) — char(30)
- Field
Untitled (PROPART)
- Key — Primary key — NOT NULL
- Key (partID) — char(5) — Foreign key → WORSON.Key — NOT NULL
- number (proID) — char(5) — Foreign key → PRODUCT.number — NOT NULL
- Field2 (qty) — char(5)
Untitled (CATEGORY)
- Key (catID) — Primary key — NOT NULL
- Field
- Field2
WORSON (PART)
- Key (partID) — char(5) — Primary key — NOT NULL
- Field (direction) — text
- modelNO (model number) — char(5) — Foreign key → PRODUCER.modelNO — NOT NULL