편의점상품관리
테이블 (3)
Product (Untitled2)
- Product_id (product_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(255)
- Price (price) — INT
- Expiration Date (expiration_date) — DATETIME
- Manufacturing Date (Manu_date) — DATETIME
branch (Untitled)
- Branch_id (branch_id) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR
- Address (address) — VARCHAR
- Monthly Sales (monthly_sales) — INT
stock (Untitled3)
- Branch_id (branch_id) — INT — 외래 키 → branch.Branch_id — NOT NULL
- Product_id (product_id) — INT — 외래 키 → Product.Product_id — NOT NULL