JOLSE MEXICO

Tables (8)

cart (Untitled)

  • cart_id (Key) — INT(11) — Primary key — NOT NULL
  • uuid (Field) — VARCHAR(70)
  • item_id (Field2) — INT(11)
  • qty (Field3) — INT(4)
  • saved_date (Field4) — VARCHAR(40)
  • order_date (Field5) — VARCHAR(40)
  • cart_status (Field6) — INT(2)

order (Untitled3)

  • order_id (Key) — INT(11) — Primary key — NOT NULL
  • order_reg_id (주문번호) — VARVCHAR(30) — Primary key — NOT NULL
  • preorder_id (Key4) — INT(11) — Foreign key → preorder.preorder_id — NOT NULL
  • uuid (Field) — VARVHAR(70)
  • item_id (Field4) — INT(11)
  • item_name (Field5) — VARCHAR(400)
  • item_price (Field2) — DECIMAL(4,2)]
  • item_option_id (Field3) — INT(11)
  • item_option_name (Field6) — VARCHAR(40)
  • qty (Field7) — INT(4)
  • payment_id (Field8) — VARCHAR(40)
  • payment_method (Field16) — VARCHAR(30)
  • paid_status (Field18) — VARCHAR(4)
  • order_date (Field11) — VARCHAR(40)
  • delivery_status (배송상태(준비중,발송,도착)) — VARCHAR(20)
  • Field9

order_detail (Untitled4)

  • order_detail_id (Key) — INT(11) — Primary key — NOT NULL
  • order_id (Field) — INT(11)
  • order_reg_id (Field2) — VARCHAR(30)
  • order_date (Field3) — VARCHAR(30)
  • item_id (Field4) — INT(11)
  • item_name (Field5) — VARCHAR(400)
  • item_price (Field6) — DECIMAL(4,2)
  • qty (Field7) — INT(4)
  • item_option_id (Field8) — INT(11)
  • item_option_name (Field9) — VARCHAR(40)
  • shipping_method (Field10) — VARCHAR(20)
  • shipping_fee (Field11) — DECIMAL(4,2)
  • shipping_status (Field12) — VARCHAR(30)
  • item_status (Field13) — VARCHAR(30)
  • spent_coupon_id (Field14) — INT(11)
  • spent_coupon_name (Field15) — VARCAHR(30)
  • spent_coupon_amount (Field16) — DECIMAL(4,2)
  • spent_member_point (Field17) — DECIMAL(4,2)
  • item_total_amount (Field18) — DECIMAL(4,2)
  • payment_id (Field19) — VARCHAR(40)
  • payment_method (Field20) — VARCHAR(40)
  • payment_amount (Field27) — DECIMAL(4,2)
  • payment_time (Field28) — VARCHAR(40)
  • ship_info_id (Field21) — INT(11)
  • buyer_name (Field22) — VARCHAR(40)
  • buyer_address (Field23) — VARCHAR(200)
  • buyer_phone (Field24) — VARCHAR(13)
  • buyer_email (Field25) — VARCHAR(200)
  • receiver (Field26) — VARCHAR(40)
  • reciever_address (Field29) — VARCHAR(40)
  • Field30
  • order_id (Key2) — INT(11) — Foreign key → order.order_id — NOT NULL
  • order_reg_id (주문번호) — VARVCHAR(30) — Foreign key → order.order_reg_id — NOT NULL
  • preorder_id (Key4) — INT(11) — Foreign key → order.preorder_id — NOT NULL

preorder (Untitled2)

  • preorder_id (Key) — INT(11) — Primary key — NOT NULL
  • cart_id (Key2) — INT(11) — Foreign key → cart.cart_id — NOT NULL
  • uuid (Field2) — VARCHAR(40)
  • item_id (Field3) — INT(11)
  • qty (Field4) — INT(4)
  • paid_status (Field5) — VARCHAR(30)

promotion (Untitled6)

  • promotion_Id (Key) — INT(11) — Primary key — NOT NULL
  • promotion_name (Field) — VARCHAR(400
  • promotion_rate (Field2) — DECIMAL(2,1)
  • member_level (Field3) — VARCHAR(40)
  • start_time (Field4) — DATE
  • end_time (Field5) — DATE
  • category_id (Field6) — INT(11)
  • item_id (Field7) — INT(11)
  • sku (Field8) — VARCHAR(40)
  • brand_id (Field9) — INT(11_
  • status (Field10) — VARVHAR(10)

review (Untitled7)

  • review_id (Key) — INT(11) — Primary key — NOT NULL
  • item_id (Field) — INT(11)
  • uuid (Field2) — VARCHAR(70)
  • credit (Field3) — VARCHAR(10)
  • rate (Field4) — TINYINT(2)
  • title (Field5) — VARCHAR(100)
  • text (Field6) — TEXT
  • option_status (Field7) — TINYINT(2)

review_img (Untitled8)

  • review_img_id (Key) — INT(11) — Primary key — NOT NULL
  • review_id (Key2) — INT(11) — Foreign key → review.review_id — NOT NULL
  • item_id (Field) — varchar(70)
  • url(파일명) (Field2) — VARCHAR(1000)

wish (Untitled5)

  • wish_id (Key) — INT(11) — Primary key — NOT NULL
  • item_id (Field) — INT(11)
  • option_id (Field2) — INT(11)
  • uuid (Field3) — VARCHAR(70)
  • saved_date (Field4) — VARCHAR(30)