Mart data
Tables (4)
Customer (Untitled)
- customer_id (PK) — VARCHAR(20) — Primary key — NOT NULL
- card_number (Field) — INT
Order (Untitled2)
- order_id (PK) — INT — Primary key — NOT NULL
- customer_id (PK2) — VARCHAR(20) — Foreign key → Customer.customer_id — NOT NULL
- order_date (Field) — TIMESTAMP
Order_detail (Untitled4)
- order_detail_id (PK) — INT — Primary key — NOT NULL
- order_id (PK2) — INT — Foreign key → Order.order_id — NOT NULL
- product_id (PK3) — VARCHAR(20) — Foreign key → Product.product_id — NOT NULL
- quantity (Field) — INT
- total_price (Field2) — INT
Product (Untitled3)
- product_id (PK) — VARCHAR(20) — Primary key — NOT NULL
- product_name (Field) — VARCHAR(20)
- price (Field2) — INT