250507 연습문제(1)
테이블 (4)
Part (PART)
- partId — int(10) — 기본 키 — NOT NULL
- partName — char(10)
- partDescription — char(30)
- partLocation — char(20)
- supplierId (producerId) — int(6) — 외래 키 → Supplier.supplierId — NOT NULL
Product (PRODUCT)
- productId — int(10) — 기본 키 — NOT NULL
- productName — char(10)
- productDescription — char(30)
- productPrice — int(10)
Supplier (PODUCER)
- supplierId (producerId) — int(6) — 기본 키 — NOT NULL
- supplierName (producerName) — char(10)
- supplierAddress (producerAddress) — char(30)
- supplierPhone (producerPhone) — int(11)
- Field (producerEmail) — email
Untitled (PRODUCT_PART)
- partId — int(10) — 외래 키 → Part.partId — NOT NULL
- productId — int(10) — 외래 키 → Product.productId — NOT NULL
- Field (quantity) — int(10)