Shopi-fy
abb.: shopify

NAME TABLE `tbl_brand`
  `brand_id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `brand_name`          


NAME TABLE `tbl_category` 
  `cat_id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `cat_name`          

NAME TABLE `tbl_customer` (
  `id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `username`          ,
  `mobaile_number`          ,
  `address`          ,
  `email`          ,
  `password`          


NAME TABLE  `tbl_customer_order` (
  `id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `product_name` 
  `product_img`          ,
  `product_id`         ,
  `quantity`         ,
  `price`         ,
  `total_price`         ,
  `customer_id`         ,
  `final_order`          DEFAULT 0,
  `delivery_status`          DEFAULT 0,
  `seen_unseen`          DEFAULT 0,
  `time` datetime           DEFAULT current_timestamp(),
  `confirmOrder`          DEFAULT 1,
  `payment_methood`          DEFAULT 1,
  `payment_status`          DEFAULT 0

NAME TABLE `tbl_message` (
  `id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `sender_id`         ,
  `sender_name`          ,
  `message` varchar(10000)          ,
  `status`          DEFAULT 0

NAME TABLE `tbl_product` (
  `p_id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `cat_id`         ,
  `p_brand`          ,
  `p_title`          ,
  `p_img`          ,
  `p_details`          ,
  `P_stock`         ,
  `p_model`          ,
  `price`          ,
  `features1`          ,
  `features2`          ,
  `features3`          ,
  `features4`          ,
  `processor`          ,
  `display`          ,
  `memory`          ,
  `storage`          ,
  `graphics`          ,
  `chipset`          ,
  `operating_System`          ,
  `battery`          ,
  `adapter`          ,
  `audio`          



NAME TABLE `tbl_user` (
  `id`         , AUTO_INCREMENT, AUTO_INCREMENT=9;
  `name`          ,
  `type`          ,
  `password`          ,
  `addedBy`