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