Exe1복습
테이블 (5)
Manufacturers (Untitled2)
- ManufacturerID (Key) — int — 기본 키 — NOT NULL
- ManufacturerName (Field) — char(30)
- ManufacturerADD (Field2) — longtext
- ManufacturerPhone (Field3) — int
- ManufactuerCredit (Field4) — int(1)
- ManufactuerEmail (Field5) — char(30)
Parts (Untitled)
- partID (Key) — int — 기본 키 — NOT NULL
- partDes (Field) — longtext
- price (Field2) — int
- ModelName (Field3) — char(20)
- PartName (Field4) — char(30)
- ManufacturerID (Key2) — int — 외래 키 → Manufacturers.ManufacturerID — NOT NULL
- PartsCategoryID (Key3) — 외래 키 → PartsCategory.PartsCategoryID — NOT NULL
PartsCategory (Untitled5)
- PartsCategoryID (Key) — 기본 키 — NOT NULL
- CategoryName (Field)
ProductPart (Untitled4)
- ProductPartID (Key) — int — 기본 키 — NOT NULL
- productID (Key4) — int — 외래 키 → Products.productID — NOT NULL
- partID (Key2) — int — 외래 키 → Parts.partID — NOT NULL
- Quantity (Field) — int
Products (Untitled3)
- productID (Key) — int — 기본 키 — NOT NULL
- ModelName (Field) — char(20)
- PartName (Field2) — char(20)
- productDes (Field3) — longtext
- price (Field4) — int(10)