Fashion E-Commerce
Tables (15)
cart (Cart Info)
- cart_id (Field) — Primary key
- user_id (_id) — Foreign key → user.user_id
- product_id (_id2) — Foreign key → product.product_id
- quantity (Field4)
- ordered (Field2)
color_list (Color List)
- color_id (Key) — Primary key — NOT NULL
- color (Field)
delivery_information (Delivery Information)
- address_id (Key) — Primary key — NOT NULL
- name (Field3)
- address 1 (Field)
- address 2 (Field4)
- phone_number (Field2)
higher_category (Higher Level Category)
- h_category_id (_id) — Primary key
- h_name (Field)
item_color_table (Item & Color)
- item_color_id (Key) — Primary key — NOT NULL
- product_id (_id) — Foreign key → product.product_id
- color_id (Key2) — Foreign key → color_list.color_id — NOT NULL
item_size_table (Item & Size)
- item_size_id (Key) — Primary key — NOT NULL
- product_id (_id) — Foreign key → product.product_id
- size_id (Key2) — Foreign key → size_list.size_id — NOT NULL
lower_category (Lower Level Category)
- l_category_id (_id) — Primary key
- h_category_id (_id2) — Foreign key → higher_category.h_category_id
- l_name (Field)
order (Order List)
- order_id (Key) — Primary key — NOT NULL
- user_id (key) — Foreign key → user.user_id
- address_id (Key2) — Foreign key → delivery_information.address_id — NOT NULL
order_items (Ordered Items)
- order_items_key (Key) — Primary key — NOT NULL
- order_id (Key2) — Foreign key → order.order_id — NOT NULL
- product_id (_id) — Foreign key → product.product_id
- quantity (Field)
photos (Photos)
- photo_id (Field) — Primary key
- post_id (_id) — Foreign key → post.post_id
- image (Field2)
- created_at (Field3)
- sequence (Field4)
post (Photo Post)
- post_id (key) — Primary key
- user_id (_id2) — Foreign key → user.user_id
- likes (Field3) — int
- created_at (Field5)
- caption (Field)
product (Product Info)
- product_id (_id) — Primary key
- name (Field)
- brand (Field2)
- price (Field4)
- inventroy (Field5)
- l_category_id (_id3) — Foreign key → lower_category.l_category_id
- product_photo (Field3)
size_list (Size List)
- size_id (Key) — Primary key — NOT NULL
- size (Field)
tagged_items (Tagged Items)
- tagged_item_id (Field) — Primary key
- post_id (_id4) — Foreign key → post.post_id
- product_id (_id) — Foreign key → product.product_id
user (User Info)
- user_id (key) — Primary key
- admin (role)
- username (Field)
- password (Field3)
- email (Field2)