test

Tables (4)

Customer

  • Key — Primary key — NOT NULL
  • customer_id — INT
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100)
  • phone — VARCHAR(20)
  • created_at — DATETIME

Order_Item

  • order_item_id — INT
  • order_id — INT — Foreign key → Orders.order_id
  • product_id — INT — Foreign key → Product.product_id
  • order_price — INT
  • quantity — INT
  • Key — Foreign key → Orders.Key — NOT NULL

Orders

  • order_id — INT
  • customer_id — INT — Foreign key → Customer.customer_id
  • order_date — DATETIME
  • total_amount — INT
  • Key — Foreign key → Customer.Key — NOT NULL

Product

  • product_id — INT
  • product_name — VARCHAR(100) — NOT NULL
  • price — INT — NOT NULL
  • stock_quantity — INT