Database_Design

Tables (5)

Categories

  • category_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(30)
  • description — VARCHAR(50)

Order_Items

  • order_item_id — INTEGER — Primary key — NOT NULL
  • quantity — INTEGER
  • price — INTEGER
  • product_id — INTEGER — Foreign key → Products.product_id — NOT NULL
  • order_id — INTEGER — Foreign key → Orders.order_id — NOT NULL

Orders

  • order_id — INTEGER — Primary key — NOT NULL
  • order_date — DATETIME
  • total_amount — INTEGER
  • user_id — INTEGER — Foreign key → Users.user_id — NOT NULL

Products

  • product_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(30)
  • price — INTEGER
  • stock_quantity — INTEGER
  • category_id — INTEGER — Foreign key → Categories.category_id — NOT NULL

Users

  • user_id — INTEGER — Primary key — NOT NULL
  • name — VARCHAR(30)
  • email — VARCHAR(50)
  • phone_number — VARCHAR(20)