편의점 상품 관리
테이블 (7)
Category (category)
- Category_id (category_id) — INT — 기본 키 — NOT NULL
- Category_name (category_name) — VARCHAR(255)
Category_Product (category_product)
- Category_id (category_id) — INT — 외래 키 → Category.Category_id — NOT NULL
- Supplier_id (supplier_id) — INT — 외래 키 → Product.Supplier_id — NOT NULL
Convenient_Store (convenient_store)
- Region_id (region_id) — INT — 외래 키 → Region.Region_id — NOT NULL
- Address (addresss) — VARCHAR(255)
- Phone (phone) — VARCHAR(255)
Convenient_Store_Product (convenient_store_product)
- Region_id (region_id) — INT — 외래 키 → Convenient_Store.Region_id — NOT NULL
- Supplier_id (supplier_id) — INT — 외래 키 → Product.Supplier_id — NOT NULL
Product (product)
- Supplier_id (supplier_id) — INT — 외래 키 → Supplier.Supplier_id — NOT NULL
- Price (price) — INT
- Quantity (quantity) — INT
- Expiration_date (expiration_date) — TEXT(255)
Region (region)
- Region_id (region_id) — INT — 기본 키 — NOT NULL
- Region_name (region_name) — VARCHAR(255)
Supplier (supplier)
- Supplier_id (supplier_id) — INT — 기본 키 — NOT NULL
- Supplier_name (supplier_name) — VARCHAR(255)
- Supplier_phone (supplier_phone) — VARCHAR(255)
- E-mail (e-mail) — VARCHAR(255)