rocket-market

Tables (8)

cart

  • cart_id — INT
  • user_id — INT
  • created_at — TIMESTAMP

cart_items

  • cart_item_id — INT
  • cart_id — INT
  • product_id — INT
  • quantity — INT — NOT NULL

categories

  • category_id — INT
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT

order_items

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

orders

  • order_id — INT
  • user_id — INT
  • total_price — DECIMAL(10, 2) — NOT NULL
  • order_date — TIMESTAMP
  • status — VARCHAR(50)

products

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

shipping

  • shipping_id — INT
  • order_id — INT
  • tracking_number — VARCHAR(100)
  • status — VARCHAR(50)
  • estimated_delivery_date — DATE

users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP