Mart
Tables (5)
Card (카드 정보)
- Key (purchase ID) — INT — Foreign key → Purchase.Key — NOT NULL
- Field (card ID) — INT
Customer (고객)
- Key (customer ID) — INT — Foreign key → Purchase.Key — NOT NULL
- Field (customer_name) — VARCHAR
Mart (마트)
- Key2 (mart ID) — INT — Foreign key → Purchase.Key — NOT NULL
- Field2 (mart_name) — VARCHAR
- Field3 (adress) — VARCHAR
Purchase (구매)
- Key (mart ID) — INT — Primary key — NOT NULL
- Key (purchase ID) — INT — Primary key — NOT NULL
- Key (customer ID) — INT — Primary key — NOT NULL
- Field (order_time) — DATETIME
- Field2 (amount) — INT
- Field3 (payment) — FLOAT
- Field (method) — VARCHAR
Purchase_Product (구매 제품)
- Key (purchase ID) — INT — Foreign key → Purchase.Key — NOT NULL
- Field (product_name) — VARCHAR
- Field2 (price) — FLOAT
- Field (quantity) — INT