test

Tables (35)

design_widget

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • widget_name — varchar(250)
  • widget_no — int
  • widget_code — varchar(20)
  • custom_class — varchar(50)
  • custom_id — varchar(50)
  • custom_css — longtext
  • custom_js — longtext
  • separated_mobile_option — tinyint(1) — NOT NULL
  • separated_mobile_url — tinyint(1) — NOT NULL
  • separated_mobile_viewport — int — NOT NULL
  • widget_category — varchar(20)
  • widget_location — varchar(50)
  • widget_location_selector — varchar(200)
  • widget_type — varchar(20)

design_widget_common_option

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • font — varchar(200)
  • font_custom — longtext
  • color_theme — varchar(200)
  • color_thumbnail_main — varchar(50)
  • color_thumbnail_price — varchar(50)
  • color_thumbnail_discount — varchar(50)
  • color_thumbnail_benefitPrice — varchar(50)
  • color_list_mainColor — varchar(50)
  • color_list_price — varchar(50)
  • color_list_discount — varchar(50)
  • color_list_benefitPrice — varchar(50)
  • inner_css — longtext
  • inner_js — longtext
  • barCTA_style — varchar(50)
  • barCTA_progressbar — varchar(50)
  • textCTA_animation — varchar(50)
  • textCTA_text — varchar(50)
  • textCTA_freeShipping — int — NOT NULL
  • textCTA_promotionFixed — tinyint(1) — NOT NULL
  • textCTA_promotionFlexible — tinyint(1) — NOT NULL
  • productCTA — tinyint(1) — NOT NULL
  • color_recommendOnly_benefitPrice — varchar(50)
  • color_recommendOnly_discount — varchar(50)
  • color_recommendOnly_main — varchar(50)
  • color_recommendOnly_price — varchar(50)

design_widget_option

  • id — bigint — Primary key — NOT NULL
  • widget_id — bigint — NOT NULL
  • key — varchar(50)
  • value — longtext

design_widget_totalproducts

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • common_style — varchar(50)
  • common_align — varchar(50)
  • use_totalProducts — tinyint(1) — NOT NULL
  • use_totalProducts_text — tinyint(1) — NOT NULL
  • totalProducts_text — varchar(200)
  • totalProducts_autoInstall — varchar(50)
  • totalProducts_customInstall — longtext
  • use_npayPrice — tinyint(1) — NOT NULL
  • use_npayPrice_text — tinyint(1) — NOT NULL
  • npayPrice_text — varchar(200)
  • npayPrice_autoInstall — varchar(50)
  • npayPrice_customInstall — longtext
  • use_npayAlert — tinyint(1) — NOT NULL
  • npayAlert_text — varchar(200)
  • npayAlert_autoInstall — varchar(50)
  • npayAlert_customInstall — longtext

design_widget_upsellorderitems

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • common_expand — tinyint(1) — NOT NULL
  • upsellOrderItems_title — varchar(200)
  • use_orderBasket — tinyint(1) — NOT NULL
  • orderBasket_autoInstall — varchar(50)
  • orderBasket_customInstall — longtext
  • use_orderForm — tinyint(1) — NOT NULL
  • orderForm_autoInstall — varchar(50)
  • orderForm_customInstall — longtext
  • use_orderResult — tinyint(1) — NOT NULL
  • orderResult_autoInstall — varchar(50)
  • orderResult_customInstall — longtext
  • use_mypage — tinyint(1) — NOT NULL
  • mypage_autoInstall — varchar(50)
  • mypage_customInstall — longtext

recommend_recommend_common_category

  • id — bigint — Primary key — NOT NULL
  • is_include — tinyint(1) — NOT NULL
  • create_at — datetime(6) — NOT NULL
  • update_at — datetime(6) — NOT NULL
  • category_id — bigint — NOT NULL
  • shop_id — bigint
  • id2 — bigint — NOT NULL
  • id3 — bigint — NOT NULL

recommend_recommend_common_category_product

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • recommend_common_category_id — bigint — NOT NULL
  • shop_id — bigint
  • is_include — tinyint(1) — NOT NULL
  • id2 — bigint — NOT NULL
  • id3 — bigint — NOT NULL

recommend_recommend_common_option

  • id — bigint — Primary key — NOT NULL
  • use_ai — tinyint(1) — NOT NULL
  • use_min_productStock — tinyint(1) — NOT NULL
  • min_productStock — int — NOT NULL
  • use_max_productLatest — tinyint(1) — NOT NULL
  • max_productLatest — int — NOT NULL
  • use_first_promotionCafe24 — tinyint(1) — NOT NULL
  • min_productPrice — int — NOT NULL
  • shop_id — bigint
  • except_text — longtext
  • limit_orderedProduct — int — NOT NULL
  • use_first_promotionUpsell — tinyint(1) — NOT NULL
  • use_first_relatedCafe24 — tinyint(1) — NOT NULL
  • use_limit_orderedProduct — tinyint(1) — NOT NULL
  • use_min_productPrice — tinyint(1) — NOT NULL
  • except_priceContent — tinyint(1) — NOT NULL
  • except_productDisplay — tinyint(1) — NOT NULL
  • id2 — bigint — NOT NULL

recommend_recommend_common_product

  • id — bigint — Primary key — NOT NULL
  • is_include — tinyint(1) — NOT NULL
  • create_at — datetime(6) — NOT NULL
  • update_at — datetime(6) — NOT NULL
  • product_id — bigint — NOT NULL
  • shop_id — bigint
  • id2 — bigint — NOT NULL
  • id3 — bigint — NOT NULL

recommend_recommend_group

  • id — bigint — Primary key — NOT NULL
  • group_name — varchar(300)
  • group_recommend_way — varchar(300)
  • group_product_count — int — NOT NULL
  • group_sales_volume — int — NOT NULL
  • group_inquiry_count — int — NOT NULL
  • group_recommend_performance — int — NOT NULL
  • group_priority — int — NOT NULL
  • group_two_way_recommend — tinyint(1) — NOT NULL
  • create_at — datetime(6) — NOT NULL
  • update_at — datetime(6) — NOT NULL
  • start_date — datetime(6) — NOT NULL
  • end_date — datetime(6) — NOT NULL
  • shop_id — bigint
  • id2 — bigint — NOT NULL

recommend_recommend_group_category

  • id — bigint — Primary key — NOT NULL
  • is_include — tinyint(1) — NOT NULL
  • is_A_group — tinyint(1) — NOT NULL
  • category_id — bigint — NOT NULL
  • recommend_group_id — bigint — NOT NULL
  • id2 — bigint — NOT NULL
  • id3 — bigint — NOT NULL

recommend_recommend_group_category_product

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • recommend_group_category_id — bigint
  • recommend_group_id — bigint
  • is_A_group — tinyint(1) — NOT NULL
  • is_include — tinyint(1) — NOT NULL
  • id2 — bigint — NOT NULL
  • id3 — bigint — NOT NULL

recommend_recommend_group_product

  • id — bigint — Primary key — NOT NULL
  • is_include — tinyint(1) — NOT NULL
  • is_A_group — tinyint(1) — NOT NULL
  • product_id — bigint — NOT NULL
  • recommend_group_id — bigint — NOT NULL
  • id2 — bigint — NOT NULL
  • id3 — bigint — NOT NULL

shop_category

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • category_no — int — NOT NULL
  • category_name — varchar(100)
  • category_depth — int — NOT NULL
  • parent_category_no — int — NOT NULL
  • display_type — varchar(5)
  • full_category_name — varchar(500)
  • full_category_no — varchar(200)
  • root_category_name — varchar(100)
  • root_category_no — int — NOT NULL
  • sub_category_product_display — tinyint(1) — NOT NULL
  • category_by_product_count — int — NOT NULL
  • recommend_common_exclusion — tinyint(1) — NOT NULL
  • promotion_common_exclusion — tinyint(1) — NOT NULL
  • use_display — tinyint(1) — NOT NULL
  • product_no — longtext
  • upsell_category_code — varchar(100)

shop_initial_complete

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • install_location — tinyint(1) — NOT NULL
  • shop_basic — tinyint(1) — NOT NULL
  • shop_billing — tinyint(1) — NOT NULL
  • send_email — tinyint(1) — NOT NULL

shop_order

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • order_id — varchar(200)
  • order_status — varchar(5)
  • buyer_name — varchar(500)
  • first_order — tinyint(1) — NOT NULL
  • shipping_status — varchar(5)
  • member_id — varchar(500)
  • order_date — datetime(6)
  • order_place_id — varchar(100)
  • app_discount_amount — int — NOT NULL
  • coupon_discount_price — int — NOT NULL
  • coupon_shipping_fee_amount — int — NOT NULL
  • credits_spent_amount — int — NOT NULL
  • market_other_discount_amount — int — NOT NULL
  • membership_discount_amount — int — NOT NULL
  • order_price_amount — int — NOT NULL
  • payment_amount — int — NOT NULL
  • point_incentive_amount — int — NOT NULL
  • points_spent_amount — int — NOT NULL
  • set_product_discount_amount — int — NOT NULL
  • shipping_fee — int — NOT NULL
  • shipping_fee_discount_amount — int — NOT NULL
  • total_amount_due — int — NOT NULL
  • is_upsell — tinyint(1) — NOT NULL
  • upsell_amount — int — NOT NULL
  • payment_date — datetime(6)

shop_order_benefit

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint — NOT NULL
  • order_item_code — varchar(100)
  • benefit_no — varchar(100)
  • benefit_title — varchar(100)
  • benefit_name — varchar(100)
  • benefit_code — varchar(100)
  • benefit_percent — varchar(100)
  • benefit_value — varchar(100)

shop_order_item

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint — NOT NULL
  • order_item_code — varchar(200)
  • request_undone — varchar(100)
  • quantity — int — NOT NULL
  • ordered_date — datetime(6)
  • product_id — bigint
  • option_id — varchar(100)
  • option_price — int — NOT NULL
  • option_value — longtext
  • option_value_default — longtext
  • order_status — varchar(100)
  • product_price — int — NOT NULL
  • variant_code — varchar(100)

shop_order_upsell

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • order_id — bigint — NOT NULL
  • orderId — varchar(200)
  • data — longtext
  • create_at — datetime(6)
  • status — varchar(200)

shop_order_upsellbundle

  • id — bigint — Primary key — NOT NULL
  • order_id — bigint — NOT NULL
  • bundle_type — varchar(100)
  • bundle_name — varchar(100)
  • bundle_id — varchar(100)
  • bundle_no — varchar(100)
  • create_at — datetime(6)

shop_order_upsellbundle_item

  • id — bigint — Primary key — NOT NULL
  • order_upsellBundle_id — bigint — NOT NULL
  • order_item_id — bigint — NOT NULL
  • quantity — int — NOT NULL
  • is_mainItem — tinyint(1) — NOT NULL

shop_ordertemp

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • order_id — bigint — NOT NULL
  • orderTemp_id — varchar(200)
  • create_at — datetime(6) — NOT NULL
  • order_place_id — varchar(200)
  • status — varchar(200)
  • data — longtext
  • order_price_amount — int — NOT NULL
  • upsell_amount — int — NOT NULL
  • is_upsell — tinyint(1) — NOT NULL

shop_ordertemp_bundle

  • id — bigint — Primary key — NOT NULL
  • orderTemp_id — bigint — NOT NULL
  • bundle_type — varchar(100)
  • bundle_name — varchar(100)
  • bundle_id — varchar(100)
  • bundle_no — varchar(100)
  • create_at — datetime(6) — NOT NULL

shop_ordertemp_bundle_item

  • id — bigint — Primary key — NOT NULL
  • orderTemp_bundle_id — bigint — NOT NULL
  • product_id — bigint — NOT NULL
  • quantity — int — NOT NULL
  • is_mainItem — tinyint(1) — NOT NULL
  • option_value — varchar(200)
  • variant_price — int — NOT NULL
  • variant_code — varchar(200)
  • option_code — varchar(200)
  • option_type — varchar(200)

shop_product

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • product_no — int — NOT NULL
  • product_code — varchar(200)
  • product_name — varchar(300)
  • price — int — NOT NULL
  • display — tinyint(1) — NOT NULL
  • selling — tinyint(1) — NOT NULL
  • summary_description — longtext
  • buy_limit_by_product — tinyint(1) — NOT NULL
  • repurchase_restriction — tinyint(1) — NOT NULL
  • single_purchase_restriction — tinyint(1) — NOT NULL
  • buy_unit_type — varchar(5)
  • buy_unit — int — NOT NULL
  • order_quantity_limit_type — varchar(5)
  • minimum_quantity — int — NOT NULL
  • maximum_quantity — int — NOT NULL
  • adult_certification — tinyint(1) — NOT NULL
  • detail_image — longtext
  • list_image — longtext
  • tiny_image — longtext
  • small_image — longtext
  • category_no — longtext
  • has_option — tinyint(1) — NOT NULL
  • use_naverpay — tinyint(1) — NOT NULL
  • naverpay_type — varchar(5)
  • created_date — datetime(6) — NOT NULL
  • update_date — datetime(6) — NOT NULL
  • sold_out — tinyint(1) — NOT NULL
  • mobile_discount_price — int — NOT NULL
  • exposure_group_list — longtext
  • use_kakaopay — tinyint(1) — NOT NULL
  • description — longtext
  • mobile_description — longtext
  • separated_mobile_description — tinyint(1) — NOT NULL
  • simple_description — longtext
  • option_type — varchar(5)
  • option_list_type — varchar(5)
  • option_preset_code — varchar(10)
  • select_one_by_option — tinyint(1) — NOT NULL
  • option_preset_name — longtext
  • use_additional_option — tinyint(1) — NOT NULL
  • use_attached_file_option — tinyint(1) — NOT NULL
  • sale_upsell_30day — int — NOT NULL
  • sale_upsell — int — NOT NULL
  • sale_total_30day — int — NOT NULL
  • sale_total — int — NOT NULL
  • inquiry_count — int — NOT NULL
  • recommend_group_count — int — NOT NULL
  • recommend_common_exclusion — tinyint(1) — NOT NULL
  • promotion_common_exclusion — tinyint(1) — NOT NULL
  • pc_discount_price — int — NOT NULL
  • price_content — varchar(200)
  • retail_price — int — NOT NULL
  • max_discount — varchar(100)
  • basic_discount — varchar(100)

shop_product_option

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • option_name — varchar(500)
  • required_option — tinyint(1) — NOT NULL
  • is_basic_option — tinyint(1) — NOT NULL
  • is_additional_option — tinyint(1) — NOT NULL
  • is_attached_file_option — tinyint(1) — NOT NULL
  • option_display_type — varchar(5)
  • option_code — varchar(500)

shop_product_option_value

  • id — bigint — Primary key — NOT NULL
  • product_option_id — bigint — NOT NULL
  • option_image_file — longtext
  • option_link_image — longtext
  • option_color — varchar(10)
  • option_text — longtext
  • value_no — int — NOT NULL
  • additional_amount — int — NOT NULL
  • option_display_type — varchar(5)
  • additional_option_text_length — int — NOT NULL
  • size_limit — int — NOT NULL

shop_product_variants

  • id — bigint — Primary key — NOT NULL
  • product_id — bigint — NOT NULL
  • variant_code — varchar(50)
  • custom_variant_code — varchar(50)
  • display — tinyint(1) — NOT NULL
  • selling — tinyint(1) — NOT NULL
  • additional_amount — int — NOT NULL
  • use_inventory — tinyint(1) — NOT NULL
  • important_inventory — varchar(10)
  • inventory_control_type — varchar(10)
  • display_soldout — tinyint(1) — NOT NULL
  • quantity — int — NOT NULL
  • safety_inventory — int — NOT NULL
  • options — longtext

shop_shop

  • id — bigint — Primary key — NOT NULL
  • token_cafe24_id — bigint — NOT NULL
  • mall_id — varchar(200)
  • shop_no — varchar(200)
  • update_order — datetime(6)
  • update_product — datetime(6)
  • password — varchar(200)
  • user_id — varchar(200)

shop_shop_basic

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • shop_name — varchar(100)
  • manager_name — varchar(100)
  • manager_phone — varchar(100)
  • manager_email — varchar(100)
  • manager_phone_auth — tinyint(1) — NOT NULL

shop_shop_billing

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • business_type — varchar(100)
  • card_number — varchar(100)
  • card_expirationDate — varchar(10)
  • birthDate — varchar(100)
  • card_password — varchar(10)
  • customer_uid — varchar(200)

shop_shop_etc

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • inflow_path — varchar(100)
  • company_size — varchar(100)
  • writer_position — varchar(100)

shop_token_cafe24

  • id — bigint — Primary key — NOT NULL
  • access_token — varchar(500)
  • expires_at — datetime(6)
  • issued_at — datetime(6)
  • refresh_token — varchar(500)
  • scopes — varchar(1000)
  • mall_id — varchar(200)

shop_upper_lower_category

  • id — bigint — Primary key — NOT NULL
  • lower_category_id — bigint — NOT NULL
  • upper_category_id — bigint — NOT NULL

shop_widget_install_location

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — NOT NULL
  • inform_update — longtext
  • widget_orderBasket — varchar(500)
  • widget_orderForm — varchar(500)
  • widget_productDetail — varchar(500)
  • widget_productDetail_autoInstall — varchar(500)