Exercise1-배미연
테이블 (4)
Part (Untitled2)
- PartId (Key) — char(4) — 기본 키 — NOT NULL
- PartName (Field) — char(10)
- Description (Field2) — longtext
- Price (Field3) — int
- Field4
- SupplierId (Key2) — char(4) — 외래 키 → Supplier.SupplierId — NOT NULL
Product (Untitled)
- ProductId (Key) — char(4) — 기본 키 — NOT NULL
- ProductName (Field) — char(10)
- ProductPrice (Field2) — char(10)
- ReleaseDate (Field3) — date
Product_Part (Untitled4)
- PartId (Key2) — char(4) — 외래 키 → Part.PartId — NOT NULL
- ProductId (Key3) — char(4) — 외래 키 → Product.ProductId — NOT NULL
- PartId (Field) — char(4)
- Quantity (Field2) — int(8)
Supplier (Untitled3)
- SupplierId (Key) — char(4) — 기본 키 — NOT NULL
- SupplierName (Field) — char(10)
- address (Field2) — char(30)
- email (Field3) — char(30)
- Phone (Field4) — char(10)