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)