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