편의점 상품 관리
테이블 (4)
All_store_info (all_store_info)
- Store_id (store_id) — INT(10) — 기본 키 — NOT NULL
- Store_name (store_name) — CHAR(100)
- City (city) — CHAR(100)
- Phone (phone) — CHAR(20)
- Email (email) — CHAR(30)
- Construct_date (construct_date) — CHAR(20)
- Size — INT(10)
- Address (address) — CHAR(20)
- Store_owner (store_owner) — CHAR(100)
Category (category)
- Category_id (category_id) — INT(10) — 기본 키 — NOT NULL
- Product_id (product_id) — INT(100) — 외래 키 → Product_info.Product_id — NOT NULL
- Store_id (store_id) — INT(10) — 외래 키 → Product_info.Store_id — NOT NULL
- Category (category) — CHAR(100)
Product_info (product_info)
- Product_id (product_id) — INT(100) — 외래 키 → Store_info.Product_id — NOT NULL
- Store_id (store_id) — INT(10) — 외래 키 → Store_info.Store_id — NOT NULL
- Expire_date (expire_date) — CHAR(20)
- Cost (cost) — INT(10)
- Category (category) — CHAR(100)
- Name (name) — CHAR(100)
- Allowed_age (allowed_age) — INT(10)
Store_info (store_info)
- Product_id (product_id) — INT(100) — 기본 키 — NOT NULL
- Store_id (store_id) — INT(10) — 외래 키 → All_store_info.Store_id — NOT NULL
- Store_name — CHAR(100)
- Store_ address (store_ address) — CHAR(20)