molly

Tables (7)

Brand

  • brand_id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

Category

  • category_id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT

Order

  • order_id — INT — Primary key
  • user_id — INT
  • order_date — TIMESTAMP
  • total_amount — DECIMAL(10, 2) — NOT NULL
  • status — VARCHAR(50)
  • shipping_address — VARCHAR(255)

Order_Item

  • order_item_id — INT — Primary key
  • order_id — INT
  • product_id — INT
  • quantity — INT — NOT NULL
  • price — DECIMAL(10, 2) — NOT NULL

Product

  • product_id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • price — DECIMAL(10, 2) — NOT NULL
  • stock — INT — NOT NULL
  • category_id — INT
  • brand_id — INT
  • created_at — TIMESTAMP

Review

  • review_id — INT — Primary key
  • user_id — INT
  • product_id — INT
  • rating — INT
  • comment — TEXT — EX
  • created_at — TIMESTAMP

User

  • user_id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)
  • created_at — TIMESTAMP