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)