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