과제
테이블 (5)
Part (part)
- Part ID(PK) (part ID(PK)) — INT (Primary Key) — 기본 키 — NOT NULL
- Description (description) — VARCHAR(255)
Product (product)
- Product ID (product ID) — INT (Primary Key) — 기본 키 — NOT NULL
- Number (number) — VARCHAR(50)
- Description (description) — VARCHAR(255)
- Price (price) — DECIMAL(10,2)
Productpart (productPart)
- ProductPart ID (productpart ID) — INT (Primary Key) — 기본 키 — NOT NULL
- Product ID (product ID) — INT (Primary Key) — 외래 키 → Product.Product ID — NOT NULL
- Part ID(PK) (part ID(PK)) — INT (Primary Key) — 외래 키 → Part.Part ID(PK) — NOT NULL
- Quantity (quantity) — INT (Primary Key)
Supplier (supplier)
- Supplier ID (supplier ID) — INT (Primary Key) — 기본 키 — NOT NULL
- Name (name) — VARCHAR(100)
- Address (address) — VARCHAR(255)
- Phone (phone) — VARCHAR(15)
SupplierPart (supplierpart)
- SupplierPartID (supplierpartID) — INT (Primary Key) — 기본 키 — NOT NULL
- Supplier ID (supplier ID) — INT (Primary Key) — 외래 키 → Supplier.Supplier ID — NOT NULL
- Part ID(PK) (part ID(PK)) — INT (Primary Key) — 외래 키 → Part.Part ID(PK) — NOT NULL