ERD

Tables (9)

categories

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — text
  • icon_image — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

contacts

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • message — longtext — NOT NULL
  • status — enum('new','read','replied') — NOT NULL
  • created_at — timestamp

favorites

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • product_id — bigint(20) — NOT NULL
  • created_at — timestamp

order_details

  • id — bigint(20) — Primary key — NOT NULL
  • order_id — bigint(20) — NOT NULL
  • product_id — bigint(20) — NOT NULL
  • quantity — int(11) — NOT NULL
  • price — decimal(10,2) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

orders

  • id — bigint(20) — Primary key — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • total_price — decimal(10,2) — NOT NULL
  • status — varchar(255) — NOT NULL
  • payment_method — varchar(255) — NOT NULL
  • shipping_address — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL
  • note — text
  • created_at — timestamp
  • updated_at — timestamp

products

  • id — bigint(20) — Primary key — NOT NULL
  • category_id — bigint(20) — NOT NULL
  • name — varchar(255) — NOT NULL
  • description — text
  • price — decimal(10,2) — NOT NULL
  • discounted_price — decimal(10,2)
  • quantity — int(11) — NOT NULL
  • has_promotion — tinyint(1) — NOT NULL
  • discount_percentage — int(11)
  • unit — varchar(255) — NOT NULL
  • origin — varchar(255)
  • image — varchar(255)
  • created_at — timestamp
  • updated_at — timestamp

promotions

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • type — enum('category','product') — NOT NULL
  • discount_type — enum('percentage','fixed') — NOT NULL
  • discount_value — decimal(10,2) — NOT NULL
  • start_date — datetime — NOT NULL
  • end_date — datetime — NOT NULL
  • category_id — bigint(20)
  • product_id — bigint(20)
  • is_active — tinyint(1) — NOT NULL
  • created_at — timestamp

reviews

  • id — bigint(20) — Primary key — NOT NULL
  • product_id — bigint(20) — NOT NULL
  • user_id — bigint(20) — NOT NULL
  • rating — int(11) — NOT NULL
  • comment — text — ext DEFAULT NUL
  • created_at — timestamp

users

  • id — bigint(20) — Primary key — NOT NULL
  • name — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • is_admin — tinyint(1) — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp