2024.04. ex1
Tables (5)
Parts
- Key (Pa ID) — char(20) — Primary key — NOT NULL
- Field (descrition) — text
- Field (name) — char(20)
- Field (model number) — char(30)
- Key (sup ID) — int(20) — Foreign key → Supplier.Key — NOT NULL
- Key (CateID) — int(5) — Foreign key → Untitled.Key — NOT NULL
Product
- Key (pro ID) — char(10) — Primary key — NOT NULL
- Field (descrition) — text
- Field (price) — int(20)
- Field (proname) — char(20)
Supplier
- Key (sup ID) — int(20) — Primary key — NOT NULL
- Field (name) — char(20)
- Field (add) — char(10)
- Field (Phone) — char(11)
- Field (email) — email
- Field (descrition) — text
Untitled (Category)
- Key (CateID) — int(5) — Primary key — NOT NULL
- Field (CateName) — Char(20)
- Field (Descrition) — text
Untitled4 (Product Parts)
- Key (Pa ID) — char(20) — Foreign key → Parts.Key — NOT NULL
- Key (pro ID) — char(10) — Foreign key → Product.Key — NOT NULL
- Field (quantity) — int(3)