편의점
테이블 (7)
Customer
- customer_id — INT
- loyalty_id — VARCHAR(30)
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- email — VARCHAR(100)
Inventory
- store_id — INT — 기본 키 — NOT NULL
- product_upc — VARCHAR(20) — 기본 키 — NOT NULL
- quantity — INT — NOT NULL
- reorder_threshold — INT
- reorder_quantity — INT
Product
- upc — VARCHAR(20)
- vendor_id — INT — NOT NULL
- brand — VARCHAR(100) — NOT NULL
- package_type — VARCHAR(50)
- size — VARCHAR(50)
- price — DECIMAL(10,2) — NOT NULL
Sale_Item
- transaction_id — INT — 기본 키 — NOT NULL
- product_upc — VARCHAR(20) — 기본 키 — NOT NULL
- quantity — INT — NOT NULL
- item_price — DECIMAL(10,2) — NOT NULL
Sales_Transaction
- transaction_id — INT
- store_id — INT — NOT NULL
- customer_id — INT
- transaction_datetime — DATETIME — NOT NULL
- payment_method — VARCHAR(50)
- total_amount — DECIMAL(10,2) — NOT NULL
Store
- store_id — INT
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255)
- open_time — TIME
- close_time — TIME
- is_24_hours — BOOLEAN — NOT NULL
Vendor
- vendor_id — INT
- name — VARCHAR(100) — NOT NULL
- contact_name — VARCHAR(100)
- contact_phone — VARCHAR(20)
- contact_email — VARCHAR(100)