LUSH web page motive Project

Tables (11)

Untitled (Categories)

  • Key (category_id) — int — Primary key — NOT NULL
  • Key (main_category_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char
  • Field (image_url) — char
  • Field (description) — char

Untitled (Products)

  • Key (product_id) — int — Primary key — NOT NULL
  • Key (category_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — char
  • Field (thumbnail_image) — char
  • Field (created_at) — datetime

Untitled (Options)

  • Key (option_id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (price) — int
  • Field (size) — int

Untitled (DetailImages)

  • Key (detail_image_id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — char

Untitled (Tags)

  • Key (tag_id) — int — Primary key — NOT NULL
  • Field (name) — char

Untitled (Products_Tags)

  • Key (product_tag_id) — int — Primary key — NOT NULL
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (tag_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (Carts)

  • Key (cart_id) — int — Primary key — NOT NULL
  • Key (option_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Field (quantity) — int

Untitled (Reviews)

  • Key (review_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (product_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — char
  • Field (rating) — int
  • Field (image_url) — char
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (ReviewComments)

  • Key (review_comment_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (review_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Field (content) — char
  • Field (created_at) — datetime
  • Field (updated_at) — datetime

Untitled (ReviewLikes)

  • Key (review_like_id) — int — Primary key — NOT NULL
  • Key (user_id) — int — Foreign key → User.Key — NOT NULL
  • Key (review_id) — int — Foreign key → Untitled.Key — NOT NULL

User (Users)

  • Key (user_id) — int — Primary key — NOT NULL
  • email — char
  • password — char
  • phone_number — char
  • Field (name) — char
  • Field (address) — char