sql

Tables (6)

cart_items

  • id — BIGINT
  • cart_id — BIGINT
  • product_id — BIGINT
  • quantity — INT
  • created_at — TIMESTAMP

carts

  • id — BIGINT
  • user_id — BIGINT
  • updated_at — TIMESTAMP

orders

  • id — BIGINT
  • user_id — BIGINT
  • order_no — VARCHAR(100)
  • total_amount — DECIMAL(15,2)
  • status — VARCHAR(50

product_images

  • id — BIGINT
  • product_id — BIGINT
  • image_url — VARCHAR(500)
  • is_thumbnail — BOOLEAN
  • ord — INT

products

  • id — BIGINT
  • name — VARCHAR(255)
  • category — VARCHAR(50)
  • carat — VARCHAR(50)
  • price — DECIMAL(15,2)
  • description — TEXT
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

users

  • id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • company_name — VARCHAR(255)
  • business_number — VARCHAR(255)
  • country — VARCHAR(255)
  • address — TEXT
  • role — VARCHAR(50)
  • status — VARCHAR(50)
  • created_at — TIMESTAMP