1004
Tables (4)
Copy Of Untitled (생산과정)
- Field (usage per piece) — int
- Key (partQuantity) — int — NOT NULL
- Key (partID) — int — Foreign key → Untitled.Key — NOT NULL
- Key (productID) — int — Foreign key → Untitled.Key — NOT NULL
Untitled (PRODUCT)
- Key (productID) — int — Primary key — NOT NULL
- Field (prodName) — char(15)
- Field (porPrice) — char(10)
- Field (proDescription) — text
Untitled (SUPPLIER)
- Key (ssn) — char(15) — Primary key — NOT NULL
- Field (supName) — char(20)
- Field (supAdd) — text
- Field (supPhone) — int
- Field
Untitled (PART)
- Key (partID) — int — Primary key — NOT NULL
- Field (partinfo) — text
- Field (partPrice) — int
- Key (ssn) — char(15) — Foreign key → Untitled.Key — NOT NULL