편의점_상품_관리
테이블 (7)
CVstore
- CVstore_id — INT(10) — 기본 키 — NOT NULL
- location — INT(5)
- contact — INT(11)
- Branch name — VARCHAR(255)
- HQ_id — INT(10) — 외래 키 → Headquater.HQ_id — NOT NULL
Customer order (Untitled)
Headquater
- HQ_id — INT(10) — 기본 키 — NOT NULL
- location — INT(5)
- contact — INT(11)
Stock_cvstore
- Stock_cvstore — INT(10) — 기본 키 — NOT NULL
- CVstore_id — INT(10) — 외래 키 → CVstore.CVstore_id — NOT NULL
- Name — VARCHAR(255)
- Category — VARCHAR(255)
- Quantity — INT(100)
- Price — INT(100)
- Expiration date — date
- Key — 외래 키 → Customer order.Key — NOT NULL
Stock_total
- Stock_id — INT(10) — 기본 키 — NOT NULL
- Store_or_ware — INT(10)
- Name — VARCHAR(255)
- Category — VARCHAR(255)
- Quantity — INT(100)
- Price — INT(100)
- Expiration date — date
- Stock_cvstore — INT(10) — 외래 키 → Stock_cvstore.Stock_cvstore — NOT NULL
- Stock_warehouse — INT(10) — 외래 키 → Stock_warehouse.Stock_warehouse — NOT NULL
Stock_warehouse
- Stock_warehouse — INT(10) — 기본 키 — NOT NULL
- Warehouse_id — INT(10) — 외래 키 → Warehouse.Warehouse_id — NOT NULL
- Name — VARCHAR(255)
- Category — VARCHAR(255)
- Quantity — INT(100)
- Price — INT(100)
- Expiration date — date
- Key — 외래 키 → Customer order.Key — NOT NULL
Warehouse
- Warehouse_id — INT(10) — 기본 키 — NOT NULL
- HQ_id — INT(10) — 외래 키 → Headquater.HQ_id — NOT NULL
- location — INT(5)
- contact — INT(11)