편의점
테이블 (4)
Order (order)
- Order Number (order_number) — INT(10) — 기본 키 — NOT NULL
- Product Code (product_code) — INT(10) — 외래 키 → Products.Product Code — NOT NULL
- SupplyCode (supply_code) — INT(10) — 외래 키 → Supply.SupplyCode — NOT NULL
- Count (order_count) — INT(10)
Products (products)
- Product Code (product_code) — INT(10) — 기본 키 — NOT NULL
- Product Name (product_name) — VARCHAR2(100)
- Product Group (product_group) — VARCHAR2(100)
- Sale Place (sale_place) — VARCHAR2(100)
- Expiration Date (ex_date) — DATE
- Stock — INT(10)
Stores (stores)
- Store Code (store code) — INT(10) — 기본 키 — NOT NULL
- Product Code (product_code) — INT(10) — 외래 키 → Products.Product Code — NOT NULL
- Name (name) — VARCHAR2(100)
- Region (region) — VARCHAR2(100)
- Manager (manager) — VARCHAR2(100)
- Price (price) — INT(10)
- Open Date (open_date) — DATE
Supply (supply)
- SupplyCode (supply_code) — INT(10) — 기본 키 — NOT NULL
- name — VARCHAR2(100)
- manager — VARCHAR2(100)