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)