Mart data
Tables (3)
Order (order)
- ID — INT — Primary key — NOT NULL
- (order_id (FK)) — INT — NOT NULL
- (order_datetime) — DATETIME
- (product_id (FK)) — INT
- (quantity) — INT
- (total_price) — INT
payment
- key (order_id) — INT — Primary key — NOT NULL
- total_number (pay_type) — VARCHAR(20)
- total_price (card_company) — VARCHAR(10)
- Field (is_Installment) — BOOL
- Field2 (Installment_month) — INT
product
- ID (product_id) — INT — Primary key — NOT NULL
- total_number — VARCHAR(20)
- total_price — INT