CREATE TABLE `Eoc`(`ecc_id` int NOT NULL AUTO_INCREMENT, `b1` int NULL, `b2` int NULL, `b3` int NULL, `age` varchar(3) NULL, `option5` varchar(255) NULL, `zip1` varchar(3) NULL, `zip2` varchar(4) NULL, `address1` varchar(32) NULL, `address2` varchar(32) NULL, `address3` varchar(32) NULL, `output_address2` varchar(255) NULL, PRIMARY KEY (`ecc_id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_copy`(`ecc_id` int NOT NULL AUTO_INCREMENT, `b1` int NULL, `b2` int NULL, `b3` int NULL, `age` varchar(3) NULL, `option5` varchar(255) NULL, `zip1` varchar(3) NULL, `zip2` varchar(4) NULL, `address1` varchar(255) NULL, `address2` varchar(255) NULL, `address3` varchar(255) NULL, `output_address2` varchar(255) NULL, PRIMARY KEY (`ecc_id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_estimate`(`id` int NOT NULL AUTO_INCREMENT, `sex` varchar(255) NULL, `tel` varchar(255) NULL, `mail` varchar(255) NULL, `contact` varchar(255) NULL, `device` varchar(255) NULL, `url` mediumtext NULL, `date` datetime NULL, `img_1` mediumtext NULL, `img_2` mediumtext NULL, `img_3` mediumtext NULL, `img_4` mediumtext NULL, `img_5` mediumtext NULL, `img_6` mediumtext NULL, `img_7` mediumtext NULL, `img_8` mediumtext NULL, `img_9` mediumtext NULL, `img_10` mediumtext NULL, `details` mediumtext NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `cv_site` varchar(255) NULL, `category` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_estimate_images`(`image_id` int NOT NULL AUTO_INCREMENT, `send_id` varchar(255) NOT NULL, `image_name` varchar(8) NULL, `image_url` varchar(82) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `upload_text` varchar(1000) NULL, PRIMARY KEY (`image_id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_estimate_test`(`id` int NOT NULL AUTO_INCREMENT, `tel` varchar(255) NULL, `mail` varchar(255) NULL, `contact` varchar(255) NULL, `device` varchar(255) NULL, `url` mediumtext NULL, `date` datetime NULL, `product_shape` varchar(255) NULL, `ingot_grade` varchar(255) NULL, `total_weight` varchar(255) NULL, `jewelry_type` varchar(255) NULL, `jewelry_weight` varchar(255) NULL, `Meredia_weight` varchar(255) NULL, `identification_authority_name` varchar(255) NULL, `details` mediumtext NULL, `cv_site` varchar(255) NULL, `category` varchar(255) NULL, `send_id` varchar(255) NULL, `dia_shape` varchar(255) NULL, `dia_carat_weight` varchar(255) NULL, `white_dia_color` varchar(255) NULL, `color_dia_intensity` varchar(255) NULL, `color_dia_color_overtone` varchar(255) NULL, `dia_clarity` varchar(255) NULL, `dia_cut_grade` varchar(255) NULL, `dia_polish` varchar(255) NULL, `dia_symmetry` varchar(255) NULL, `dia_fluorescence_intensity` varchar(255) NULL, `dia_fluorescence_color` varchar(255) NULL, `dia_buy_price` varchar(255) NULL, `dia_labo_name` varchar(255) NULL, `brand_name` varchar(255) NULL, `brand_item` varchar(255) NULL, `brand_model` varchar(255) NULL, `brand_condition` varchar(255) NULL, `brand_shop_name` varchar(45) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `bikou` varchar(1000) NULL, `diamond_jewelry_brand_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_estimate_test_images`(`image_id` int NOT NULL AUTO_INCREMENT, `send_id` varchar(255) NOT NULL, `image_name` varchar(8) NOT NULL, `image_url` varchar(82) NOT NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `upload_text` varchar(1000) NULL, PRIMARY KEY (`image_id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_estimate_v2`(`id` int NOT NULL AUTO_INCREMENT, `tel` varchar(255) NULL, `mail` varchar(255) NULL, `contact` varchar(255) NULL, `device` varchar(255) NULL, `url` mediumtext NULL, `date` datetime NULL, `product_shape` varchar(255) NULL, `ingot_grade` varchar(255) NULL, `total_weight` varchar(255) NULL, `jewelry_type` varchar(255) NULL, `jewelry_weight` varchar(255) NULL, `Meredia_weight` varchar(255) NULL, `identification_authority_name` varchar(255) NULL, `details` mediumtext NULL, `cv_site` varchar(255) NULL, `category` varchar(255) NULL, `send_id` varchar(255) NULL, `dia_shape` varchar(255) NULL, `dia_carat_weight` varchar(255) NULL, `white_dia_color` varchar(255) NULL, `color_dia_intensity` varchar(255) NULL, `color_dia_color_overtone` varchar(255) NULL, `dia_clarity` varchar(255) NULL, `dia_cut_grade` varchar(255) NULL, `dia_polish` varchar(255) NULL, `dia_symmetry` varchar(255) NULL, `dia_fluorescence_intensity` varchar(255) NULL, `dia_fluorescence_color` varchar(255) NULL, `dia_buy_price` varchar(255) NULL, `dia_labo_name` varchar(255) NULL, `brand_name` varchar(255) NULL, `brand_item` varchar(255) NULL, `brand_model` varchar(255) NULL, `brand_condition` varchar(255) NULL, `brand_shop_name` varchar(45) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `bikou` varchar(1000) NULL, `diamond_jewelry_brand_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_estimate_v3`(`id` int NOT NULL AUTO_INCREMENT, `tel` varchar(255) NULL, `mail` varchar(255) NULL, `contact` varchar(255) NULL, `device` varchar(255) NULL, `url` mediumtext NULL, `date` datetime NULL, `cv_site` varchar(255) NULL, `send_id` varchar(255) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `bikou` varchar(1000) NULL, `cv_time` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_guestquestion`(`id` int NOT NULL AUTO_INCREMENT, `site-reflect` int NULL DEFAULT 0, `timestamp` datetime NULL, `service-name` varchar(255) NULL, `service-name-text` mediumtext NULL, `service-story` varchar(255) NULL, `service-story-text` mediumtext NULL, `service-satisfied` varchar(255) NULL, `sold-this-time` varchar(255) NULL, `cancel-reason` varchar(255) NULL, `cancel-reason-text` mediumtext NULL, `other-reason-text` mediumtext NULL, `how-much-cheap` varchar(255) NULL, `how-much-cheap-text` mediumtext NULL, `dissatisfied-reason-text` mediumtext NULL, `service-speed` varchar(255) NULL, `service-speed-text` mediumtext NULL, `service-description` varchar(255) NULL, `service-description-text` mediumtext NULL, `site-level` varchar(255) NULL, `site-level-text` mediumtext NULL, `choice-reason-text` mediumtext NULL, `search-keyword` mediumtext NULL, `search-keyword-text` mediumtext NULL, `search-engine` varchar(255) NULL, `search-engine-text` mediumtext NULL, `search-medium` varchar(255) NULL, `search-medium-text` mediumtext NULL, `freely-write-text` mediumtext NULL, `a-word-text` mediumtext NULL, `customer-sex` varchar(255) NULL, `customer-age` varchar(255) NULL, `customer-address` varchar(255) NULL, `mail-or-tel-text` mediumtext NULL, `domain` varchar(100) NULL, `device` varchar(50) NULL, `voice_sub_id` int NULL, `updated_at` datetime NULL, `eva_id` int NULL, `ecc_id` int NULL, `fav_count` int NULL DEFAULT 0, `comment_agree` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_guestquestion_posts`(`id` int NOT NULL AUTO_INCREMENT, `Eoc_guestquestion_id` int NULL, `user_id` int NULL, `lounge_user_id` int NULL, `text` mediumtext NULL, `updated_at` datetime NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_id_file`(`id` int NOT NULL AUTO_INCREMENT, `Eoc_login_id` int NULL, `google_id` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_login`(`id` int NOT NULL AUTO_INCREMENT, `line_id` varchar(255) NULL, `ecc_id` int NULL, `displayName` varchar(255) NULL, `photoURL` varchar(255) NULL, `phoneNumber` int NULL, `email` varchar(255) NULL, `emailVerfied` tinyint NULL, `update_at` datetime NULL, `create_at` datetime NULL, `firebase_id` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_mitsumori`(`id` int NOT NULL AUTO_INCREMENT, `shape` varchar(100) NULL, `grade` varchar(100) NULL, `all_weight` varchar(100) NULL, `stone_type` varchar(100) NULL, `stone_weight` varchar(100) NULL, `aside_stone_weight` varchar(100) NULL, `have_labo_note` varchar(100) NULL, `labo_name` varchar(100) NULL, `buy_time` varchar(100) NULL, `buy_price` varchar(100) NULL, `jewelry_brand_name` varchar(100) NULL, `bikou` mediumtext NULL, `dia_shape` varchar(100) NULL, `dia_carat` varchar(100) NULL, `dia_color_select` varchar(50) NULL, `dia_color` varchar(100) NULL, `dia_intensity` varchar(100) NULL, `dia_overtone` varchar(100) NULL, `dia_clarity` varchar(100) NULL, `dia_cut_grade` varchar(100) NULL, `dia_polish` varchar(100) NULL, `dia_symmetry` varchar(100) NULL, `dia_fluorescence_intensity` varchar(100) NULL, `dia_fluorescence_color` varchar(100) NULL, `dia_buy_time` varchar(100) NULL, `dia_buy_price` varchar(100) NULL, `dia_have_labo_note` varchar(100) NULL, `dia_labo_name` varchar(100) NULL, `dia_brand_name` varchar(100) NULL, `dia_bikou` mediumtext NULL, `brand_name` varchar(100) NULL, `brand_item_name` varchar(100) NULL, `brand_kataban` varchar(100) NULL, `brand_condition` varchar(100) NULL, `brand_buy_time` varchar(100) NULL, `brand_buy_time_memo` mediumtext NULL, `brand_buy_price` varchar(100) NULL, `brand_buy_shop` varchar(100) NULL, `brand_buy_shop_memo` mediumtext NULL, `brand_bikou` mediumtext NULL, `user_sex` varchar(100) NULL, `user_tel` varchar(100) NULL, `user_mail` varchar(255) NULL, `user_renraku_houhou` varchar(100) NULL, `user_kit_kibou` varchar(100) NULL, `user_img_url` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_refining`(`id` int NOT NULL AUTO_INCREMENT, `number_of_times` mediumtext NULL, `service_selection` mediumtext NULL, `reservation_time` mediumtext NULL, `ingot_type_and_details` mediumtext NULL, `gold_1kg` mediumtext NULL, `gold_500g` mediumtext NULL, `platinum_1kg` mediumtext NULL, `platinum_500g` mediumtext NULL, `plan` mediumtext NULL, `plan__2` mediumtext NULL, `plan__3` mediumtext NULL, `split_cost` mediumtext NULL, `delivery_time` mediumtext NULL, `kit_details` mediumtext NULL, `rebuilding` mediumtext NULL, `simulation` mediumtext NULL, `user_name` mediumtext NULL, `user_name_kana` mediumtext NULL, `user_yuubinn` mediumtext NULL, `user_todou` mediumtext NULL, `user_sikutyouson` mediumtext NULL, `user_banti` mediumtext NULL, `user_mansion` mediumtext NULL, `deliver_confirm` mediumtext NULL, `user_tel` mediumtext NULL, `user_mail` mediumtext NULL, `domain_type` mediumtext NULL, `E-mail` mediumtext NULL, `financial_institution_name` mediumtext NULL, `financial_institution_code` mediumtext NULL, `branch_name` mediumtext NULL, `branch_code` mediumtext NULL, `branch_name_yuucho` mediumtext NULL, `kigou_yuucho` mediumtext NULL, `account_type` mediumtext NULL, `account_number` mediumtext NULL, `nominee` mediumtext NULL, `tel_mail_fax` mediumtext NULL, `fax_number` mediumtext NULL, `final_1` mediumtext NULL, `final_2` mediumtext NULL, `confirmation` mediumtext NULL, `bikou` mediumtext NULL, `questionnaire_1` mediumtext NULL, `questionnaire_2` mediumtext NULL, `questionnaire_3` mediumtext NULL, `questionnaire_1_text` mediumtext NULL, `questionnaire_2_text` mediumtext NULL, `questionnaire_3_text` mediumtext NULL, `created_at` datetime NULL, `updated_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_refining_bk_240315`(`id` int NOT NULL AUTO_INCREMENT, `number_of_times` mediumtext NULL, `service_selection` mediumtext NULL, `reservation_time` mediumtext NULL, `ingot_type_and_details` mediumtext NULL, `gold_1kg` mediumtext NULL, `gold_500g` mediumtext NULL, `platinum_1kg` mediumtext NULL, `platinum_500g` mediumtext NULL, `plan` mediumtext NULL, `plan__2` mediumtext NULL, `plan__3` mediumtext NULL, `split_cost` mediumtext NULL, `delivery_time` mediumtext NULL, `kit_details` mediumtext NULL, `rebuilding` mediumtext NULL, `simulation` mediumtext NULL, `user_name` mediumtext NULL, `user_name_kana` mediumtext NULL, `user_yuubinn` mediumtext NULL, `user_todou` mediumtext NULL, `user_sikutyouson` mediumtext NULL, `user_banti` mediumtext NULL, `user_mansion` mediumtext NULL, `deliver_confirm` mediumtext NULL, `user_tel` mediumtext NULL, `user_mail` mediumtext NULL, `domain_type` mediumtext NULL, `E-mail` mediumtext NULL, `financial_institution_name` mediumtext NULL, `financial_institution_code` mediumtext NULL, `branch_name` mediumtext NULL, `branch_code` mediumtext NULL, `branch_name_yuucho` mediumtext NULL, `kigou_yuucho` mediumtext NULL, `account_type` mediumtext NULL, `account_number` mediumtext NULL, `nominee` mediumtext NULL, `tel_mail_fax` mediumtext NULL, `fax_number` mediumtext NULL, `final_1` mediumtext NULL, `final_2` mediumtext NULL, `confirmation` mediumtext NULL, `bikou` mediumtext NULL, `questionnaire_1` mediumtext NULL, `questionnaire_2` mediumtext NULL, `questionnaire_3` mediumtext NULL, `questionnaire_1_text` mediumtext NULL, `questionnaire_2_text` mediumtext NULL, `questionnaire_3_text` mediumtext NULL, `created_at` datetime NULL, `updated_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_refining_v1`(`id` int NOT NULL AUTO_INCREMENT, `angouka_mailaddress` varchar(100) NULL, `service_selection` mediumtext NULL, `sale_advance_input` mediumtext NULL, `deliveryservice` mediumtext NULL, `totalTransferAmount` mediumtext NULL, `usage` mediumtext NULL, `rebuilding` mediumtext NULL, `name` mediumtext NULL, `kana` mediumtext NULL, `phone_number` mediumtext NULL, `email` mediumtext NULL, `contact_method` mediumtext NULL, `user_yuubinn` mediumtext NULL, `user_todou` mediumtext NULL, `user_sikutyouson` mediumtext NULL, `user_banti` mediumtext NULL, `user_building` mediumtext NULL, `is_applicant` mediumtext NULL, `same_address` mediumtext NULL, `content_inquiry` mediumtext NULL, `questionnaire_1` mediumtext NULL, `questionnaire_2` mediumtext NULL, `questionnaire_3` mediumtext NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `ingot_details` mediumtext NULL, `saleRebuildingPrice` mediumtext NULL, `selected_sale_g` mediumtext NULL, `status` varchar(255) NULL, `ecc_id` bigint(20) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_takuhai`(`id` int NOT NULL AUTO_INCREMENT, `brand_confirm` varchar(100) NULL, `number_of_times` varchar(100) NULL, `type_selection` varchar(100) NULL, `reuse_box` varchar(100) NULL, `kit_detail` mediumtext NULL, `date_select` varchar(100) NULL, `time_select` varchar(100) NULL, `date_select_hidden` varchar(100) NULL, `time_select_hidden` varchar(100) NULL, `speed_box` varchar(100) NULL, `date_and_time` varchar(100) NULL, `date_and_time_hidden` varchar(100) NULL, `user_name` varchar(100) NULL, `user_name_kana` varchar(100) NULL, `user_tel` varchar(100) NULL, `user_mail` varchar(255) NULL, `user_yuubinn` varchar(50) NULL, `user_todou` varchar(100) NULL, `user_sikutyouson` mediumtext NULL, `user_banti` mediumtext NULL, `tel_mail_line` varchar(100) NULL, `bikou` mediumtext NULL, `insurance_speed` varchar(100) NULL, `insurance` varchar(100) NULL, `insurance_kingaku` varchar(200) NULL, `mail_magazin` varchar(100) NULL, `anke_1` mediumtext NULL, `anke_2` mediumtext NULL, `anke_3` mediumtext NULL, `mail_text` mediumtext NULL, `REMOTE_HOST` varchar(100) NULL, `REMOTE_ADDR` varchar(100) NULL, `USER_AGENT` mediumtext NULL, `HTTP_REFERER` varchar(100) NULL, `key_code` varchar(100) NULL, `cv_site` varchar(50) NULL, `cv_device` varchar(50) NULL, `cv_page` varchar(100) NULL, `cv_time` datetime NULL, `user_id` int NULL, `mailingkit_id` int NULL, `line_satei` varchar(255) NULL, `kit_denpyou` int NULL, `kit_huutou` int NULL, `kit_S` int NULL, `kit_M` int NULL, `kit_L` int NULL, `updated_at` datetime NULL, `created_at` datetime NULL, `service_users_id` int NULL, `contract_at` date NULL, `ad_param` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_takuhai_copy1`(`id` int NOT NULL AUTO_INCREMENT, `brand_confirm` varchar(100) NULL, `number_of_times` varchar(100) NULL, `type_selection` varchar(100) NULL, `reuse_box` varchar(100) NULL, `kit_detail` mediumtext NULL, `date_select` varchar(100) NULL, `time_select` varchar(100) NULL, `date_select_hidden` varchar(100) NULL, `time_select_hidden` varchar(100) NULL, `speed_box` varchar(100) NULL, `date_and_time` varchar(100) NULL, `date_and_time_hidden` varchar(100) NULL, `user_name` varchar(100) NULL, `user_name_kana` varchar(100) NULL, `user_tel` varchar(100) NULL, `user_mail` varchar(255) NULL, `user_yuubinn` varchar(50) NULL, `user_todou` varchar(100) NULL, `user_sikutyouson` mediumtext NULL, `user_banti` mediumtext NULL, `tel_mail_line` varchar(100) NULL, `bikou` mediumtext NULL, `insurance_speed` varchar(100) NULL, `insurance` varchar(100) NULL, `insurance_kingaku` varchar(200) NULL, `mail_magazin` varchar(100) NULL, `anke_1` mediumtext NULL, `anke_2` mediumtext NULL, `anke_3` mediumtext NULL, `mail_text` mediumtext NULL, `REMOTE_HOST` varchar(100) NULL, `REMOTE_ADDR` varchar(100) NULL, `USER_AGENT` mediumtext NULL, `HTTP_REFERER` varchar(100) NULL, `key_code` varchar(100) NULL, `cv_site` varchar(50) NULL, `cv_device` varchar(50) NULL, `cv_page` varchar(100) NULL, `cv_time` datetime NULL, `user_id` int NULL, `mailingkit_id` int NULL, `line_satei` varchar(255) NULL, `kit_denpyou` int NULL, `kit_huutou` int NULL, `kit_S` int NULL, `kit_M` int NULL, `kit_L` int NULL, `updated_at` datetime NULL, `created_at` datetime NULL, `service_users_id` int NULL, `contract_at` date NULL, `ad_param` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `Eoc_takuhai_satei_tokens`(`id` int NOT NULL AUTO_INCREMENT, `Eoc_takuhai_id` bigint(20) NOT NULL, `token` varchar(255) NOT NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `limit_at` datetime NULL, `is_responsed` tinyint NULL DEFAULT 0, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `PMT_EV001`(`APP_STATUS` varchar(10) NOT NULL, `ROW` int NOT NULL, `APP_UID` int NOT NULL AUTO_INCREMENT, `DA_SEQ` varchar(32) NULL, `DA_MANAGEMENTNO` varchar(32) NULL, `DA_BUYER` varchar(32) NULL, `DA_RESPONSIBLE` varchar(32) NULL, `DA_THESPECIFICATIONSSETTINGSUN` varchar(32) NULL, `DA_WEIGHT` decimal(11,3) NULL, `DA_THESPECIFICATIONSLOSSES` varchar(32) NULL, `DA_PER_CARAT` varchar(32) NULL, `APP_NUMBER` int NOT NULL, `DA_SHAPE` varchar(32) NULL, `DA_SELFGRES` varchar(32) NULL, `DA_ORIGINALGRADEMLIKENED` varchar(32) NULL, `DA_SUGARCANE` varchar(32) NULL, `DA_PERCENT` varchar(32) NULL, `DA_STATUS` varchar(32) NULL, `DA_COLOR` varchar(32) NULL, `DA_CLARITY` varchar(32) NULL, `DA_CUT` varchar(32) NULL, `DA_FLUO` varchar(32) NULL, `DA_WIDE` varchar(32) NULL, `DA_HIGH` varchar(32) NULL, `DA_DEPTH` varchar(32) NULL, `DA_APPRAISER` varchar(32) NULL, `DA_RATE` varchar(32) NULL, `DA_UNITPRICE` varchar(32) NULL, `DA_YOURNAME` varchar(32) NULL, `DA_PAYOUTOTHER` double NULL, `DA_RAPA` varchar(32) NULL, `DA_COMMENTSANDTOTAL` varchar(32) NULL, `DA_REGISTEREDPERSON` varchar(32) NULL, `DA_GROSSPROFIT` varchar(32) NULL, `DA_INTEREST_1` varchar(32) NULL, `DA_REGISTRATIONDATE` varchar(32) NULL, `DA_UPDATEDBY` varchar(32) NULL, `DA_UPDATEDDATE` varchar(32) NULL, `DA_COMPLETECHANGEDATE` varchar(32) NULL, `DA_FRAPA` varchar(32) NULL, `DA_RAPAB` varchar(50) NULL, `DA_UNIT_PRICE_UNPLUG` varchar(50) NULL, `DA_STATUS_2` varchar(255) NULL, `DA_MEMO` mediumtext NULL, `DA_INTENSITY` varchar(50) NULL, `DA_OVERTONE` varchar(50) NULL, `DA_INTENSITY_FLUO` varchar(50) NULL, `DA_COLOR_FLUO` varchar(50) NULL, `DA_POLISH` varchar(100) NULL, `DA_SYMMETRY` varchar(100) NULL, `DA_no` varchar(100) NULL, `status` int NULL, `INSI_waname` varchar(255) NULL, `OVTO_waname` varchar(255) NULL, PRIMARY KEY (`APP_UID`))CHARACTER SET utf8;
CREATE TABLE `_DIA_DA_APPRAISER`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` varchar(255) NULL, `parent` int NULL, `wa_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_DIA_DA_CLARITY`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `parent` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_DIA_DA_COLOR`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `parent` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_DIA_DA_CUT`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `parent` int NULL, `wa_name` varchar(255) NULL, `description` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_DIA_DA_FLUO`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `parent` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_brand`(`id` int NOT NULL, `name` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `_chigin_type`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_condition`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_condition_type`(`condition_id` int NOT NULL AUTO_INCREMENT, `category_id` int NULL, `condition_name` mediumtext NULL, PRIMARY KEY (`condition_id`))CHARACTER SET utf8;
CREATE TABLE `_goods_status`(`goods_id` int NOT NULL AUTO_INCREMENT, `goods_status` varchar(255) NULL, PRIMARY KEY (`goods_id`))CHARACTER SET utf8;
CREATE TABLE `_goods_status2`(`goods_id` int NOT NULL, `goods_status` varchar(255) NULL, `id` int NOT NULL AUTO_INCREMENT, `status_id` int NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_mail_check_type`(`mail_check_id` int NOT NULL AUTO_INCREMENT, `mail_check_name` varchar(32) NULL, PRIMARY KEY (`mail_check_id`))CHARACTER SET utf8;
CREATE TABLE `_mst_condition`(`id` int NOT NULL AUTO_INCREMENT, `condition_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_news_category`(`id` int NOT NULL AUTO_INCREMENT, `news_name` varchar(32) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_page_category`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(32) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_page_name`(`id` int NOT NULL AUTO_INCREMENT, `page_id` varchar(32) NULL, `page_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_pref`(`id` int NOT NULL AUTO_INCREMENT, `data` varchar(100) NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `_sex`(`sex_id` int NOT NULL AUTO_INCREMENT, `sex_name` varchar(12) NULL, `sex_ini` varchar(12) NULL, PRIMARY KEY (`sex_id`))CHARACTER SET utf8;
CREATE TABLE `_yes_no`(`id` int NOT NULL AUTO_INCREMENT, `data` varchar(3) NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `ages`(`age_id` int NOT NULL AUTO_INCREMENT, `age_name` varchar(50) NULL, PRIMARY KEY (`age_id`))CHARACTER SET utf8;
CREATE TABLE `articles`(`article_id` int NOT NULL AUTO_INCREMENT, `article_title` varchar(50) NULL, `category_id` int NULL, `article_desc` mediumtext NULL, `date_add` datetime NULL, `date_end` datetime NULL, PRIMARY KEY (`article_id`))CHARACTER SET utf8;
CREATE TABLE `auctions`(`id` int NOT NULL AUTO_INCREMENT, `bod_id` varchar(32) NULL, `product_id` int NULL, `store_product_id` varchar(32) NULL, `Control_Number` varchar(32) NULL, `Categories` varchar(32) NULL, `Title` varchar(32) NULL, `Description` mediumtext NULL, `Description_for_mobile_version` varchar(8) NULL, `Items_in_the_store_for_the_search_keyword` varchar(255) NULL, `Starting_price` int NULL, `Qty` varchar(4) NULL, `Limited_number_of_bids` varchar(4) NULL, `Period` varchar(32) NULL, `End_time` varchar(32) NULL, `State_of_the_original_shipment` varchar(32) NULL, `Shipment_of_the_original_city` varchar(255) NULL, `Expense` varchar(255) NULL, `Upfront_payment_deferred_payment` varchar(255) NULL, `Navigation_Settings_payment_bid` varchar(255) NULL, `Product_status` varchar(255) NULL, `Note:_Product_status` varchar(255) NULL, `Returns_whether_or_not` varchar(255) NULL, `Note_whether_the_return` varchar(255) NULL, `Image_1` varchar(255) NULL, `Image_1_Comments` varchar(255) NULL, `Image_2` varchar(255) NULL, `Image_2_comments` varchar(255) NULL, `Image_3` varchar(255) NULL, `Image_3_comments` varchar(255) NULL, `Lowest_rating` varchar(255) NULL, `Automatic_extension` varchar(255) NULL, `Early_termination` varchar(255) NULL, `Price_summary` varchar(255) NULL, `Price_negotiation` varchar(255) NULL, `Auto_Relist_Item` varchar(255) NULL, `Lowest_winning_bid` varchar(255) NULL, `Auction_Spotlight` varchar(255) NULL, `Bold_text` varchar(255) NULL, `Background_color` varchar(255) NULL, `Sutoahottookushon` varchar(255) NULL, `Prominent_icon` varchar(255) NULL, `Icon_Gifts` varchar(255) NULL, `Yahoo_point_options` varchar(255) NULL, `Afirieitoopushon` varchar(255) NULL, `Package_size` varchar(255) NULL, `Weight_of_luggage` varchar(255) NULL, `FUN_BOON` varchar(255) NULL, `delvery_1` varchar(255) NULL, `delivery_link_1` varchar(255) NULL, `delivery_methods_1` varchar(255) NULL, `delivery_2` varchar(255) NULL, `delivery_link_2` varchar(255) NULL, `delivery_methods_2` varchar(255) NULL, `image_amount` int NULL, `delivery_3` varchar(255) NULL, `delivery_link_3` varchar(255) NULL, `delivery_methods_3` varchar(255) NULL, `delivery_4` varchar(255) NULL, `delivery_link_4` varchar(255) NULL, `delivery_methods_4` varchar(255) NULL, `delivery_5` varchar(255) NULL, `delivery_link_5` varchar(255) NULL, `delivery_methods_5` varchar(255) NULL, `delivery_6` varchar(255) NULL, `delivery_link_6` varchar(255) NULL, `delivery_methods_6` varchar(255) NULL, `delivery_7` varchar(255) NULL, `delivery_link_7` varchar(255) NULL, `delivery_methods_7` varchar(255) NULL, `delivery_8` varchar(255) NULL, `delivery_link_8` varchar(255) NULL, `delivery_methods_8` varchar(255) NULL, `delivery_9` varchar(255) NULL, `delivery_link_9` varchar(255) NULL, `delivery_methods_9` varchar(255) NULL, `delivery_10` varchar(255) NULL, `delivery_link_10` varchar(255) NULL, `delivery_methods_10` varchar(255) NULL, `Image_1_Comments1` varchar(255) NULL, `amount_of_image` int NULL, `International_shipping` varchar(255) NULL, `International shipping` int NULL, `raku_cont_col` varchar(12) NOT NULL DEFAULT 'n', `raku_goods_name` varchar(255) NOT NULL, `raku_tag` varchar(32) NULL, `raku_price` int NOT NULL, `raku_dir` varchar(255) NULL DEFAULT '558899', `rak_pc_catch` varchar(32) NULL, `rak_moobile` varchar(32) NULL, `raku_shouhinjyouhou_layout` tinyint NULL, `raku_tax` tinyint NULL, `raku_send_price` tinyint NULL, `raku_kobetu_souryou` varchar(32) NULL, `raku_souryou_kubun1` tinyint NULL, `raku_souryou_kubun2` tinyint NULL, `raku_daibiki` tinyint NULL, `raku_souko_sitei` varchar(32) NULL, `raku_layout` varchar(32) NULL, `raku_chuumon_btn` tinyint NULL, `raku_siryou_seikyuu` tinyint NULL, `raku_shouhin_toiawase` tinyint NULL, `raku_sainyuuka_osirase` tinyint NULL, `raku_mobile_disp` tinyint NULL, `raku_nosi_taiou` tinyint NULL, `raku_pc_shouhin_setumei` mediumtext NULL, `raku_mobile_setumei` mediumtext NULL, `raku_pcyou_hanbai_setumei` varchar(255) NULL, `raku_douga` varchar(32) NULL, `raku_hanbai_sitei_kikan` varchar(255) NULL, `raku_chuumon_uketukesuu` varchar(32) NULL, `raku_zaiko_tipe` varchar(32) NULL, `raku_zaiko_suu` varchar(32) NULL, `raku_zaiko_suu_hyouji` varchar(32) NULL, `raku_kumoku_kobetu_zaiko` varchar(32) NULL, `raku_koumoku_sentaku_tate` tinyint NULL, `koumoku_sentaku_kobetu_sikii` tinyint NULL, `raku__yamiichi_pass` varchar(32) NULL, `raku_catalog` varchar(32) NULL, `raku_zaiko_modosi` tinyint NULL, `raku_zaiko_kire` tinyint NULL, `raku_zaiko_ari` varchar(32) NULL, `raku_zaiko_kire_nouki` varchar(32) NULL, `raku_point` varchar(32) NULL, `raku_point_bairitu_tekiyo` varchar(255) NULL, `raku_header_footer` varchar(32) NULL, `raku_hyouji_koumoku_narabi` varchar(32) NULL, `raku_kyoutuu_setumei` varchar(255) NULL, `raku_medama` varchar(255) NULL, `raku_kyoutuu_setumei_dai` varchar(255) NULL, `raku_review` tinyint NULL, `raku_asuraku_haisou` varchar(255) NULL, `_raku_kaigai_haisou` tinyint NULL, `raku_saizu_hyou_link` varchar(255) NULL, `raku_image1` mediumtext NULL, `raku_image2` varchar(70) NULL, `raku_image3` varchar(70) NULL, `raku_hyoujisaki_category` varchar(32) NULL, `raku_search` varchar(32) NULL, `raku_koumoku_sentaku_yoko` varchar(32) NULL, `raku_hyouji_kakaku` int NULL, `raku_shouhin_bangou` varchar(32) NULL, `rakuten.raku_cont_col` varchar(32) NULL, `raku_hyouji_big` varchar(32) NULL, `raku_hyouji_mid` varchar(32) NULL, `raku_hyouji_small` varchar(32) NULL, `raku_hyouji_det1` varchar(32) NULL, `raku_hyouji_det2` varchar(32) NULL, `raku_hyouji_det3` varchar(32) NULL, `raku_yuusendo` varchar(32) NULL DEFAULT '999999999', `raku_zaiko_makimodosi` int NULL, `raku_one_page_fukusuu_housiki` int NULL, `raku_zakiko_kirejino_chuumon` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `box`(`box_id` int NOT NULL AUTO_INCREMENT, `box_pass` varchar(64) NULL, `box_name` varchar(32) NULL, `box_name_jp` mediumtext NULL, `created_at` datetime NULL, `created_by` varchar(11) NULL, `zip` mediumtext NULL, `zip_status` int NULL, `zip_name` mediumtext NULL, `box_csv_template_id` int NULL, `updated_at` datetime NULL, `rakuten_cabinet_name` varchar(256) NULL, `rakuup` int NULL, `yup` int NULL, `raku_image_name` varchar(255) NULL, `csv` mediumtext NULL, `up` int NULL, `box_id_new` int NULL, `satuei_sha` int NULL, `satuei_jikan` datetime NULL, `kakou_sha` int NULL, `kakou_jikan` datetime NULL, `konpou_sha` int NULL, `konpou_Jikan` datetime NULL, `link1` varchar(50) NULL, `zip_create` int NULL, `updated_by` int NULL, `count` int NULL, `zip_flag` int NULL, PRIMARY KEY (`box_id`))CHARACTER SET utf8;
CREATE TABLE `box_for_result`(`box_id` int NOT NULL AUTO_INCREMENT, `box_name` varchar(32) NULL, `zip` mediumtext NULL, `raku_image_name` varchar(255) NULL, PRIMARY KEY (`box_id`))CHARACTER SET utf8;
CREATE TABLE `brakai_kensaku`(`id` int NOT NULL AUTO_INCREMENT, `date` datetime NULL, `search_contents` mediumtext NULL, `page` varchar(100) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `brand_page_purchase_results`(`id` int NOT NULL AUTO_INCREMENT, `brand_page_setting_id` bigint(20) NOT NULL, `title` varchar(255) NULL, `min_price` varchar(255) NULL, `max_price` varchar(1000) NULL, `image_url` varchar(1000) NULL, `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `created_by` int NULL, `updated_at` datetime NULL DEFAULT '0000-00-00 00:00:00', `updated_by` int NULL, `kataban` varchar(255) NULL, `list_price` varchar(255) NULL, `camp_price` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `brand_page_settings`(`id` int NOT NULL AUTO_INCREMENT, `brand_id` bigint(20) NOT NULL, `page_item_name` varchar(255) NOT NULL, `page_item_name_en` varchar(255) NOT NULL, `top_text` varchar(1000) NOT NULL, `top_text_sp` varchar(1000) NOT NULL, `h1_size` varchar(10) NOT NULL, `content_second_word` varchar(255) NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_by` int NOT NULL, `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_by` int NOT NULL, `url` varchar(255) NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `brand_price`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(100) NULL, `line_category` varchar(100) NULL, `line` varchar(100) NULL, `item_name` varchar(255) NULL, `kataban` varchar(100) NULL, `list_price` int NULL, `width` int NULL, `height` int NULL, `depth` int NULL, `color` varchar(100) NULL, `brand_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `colorstone_settings`(`id` int NOT NULL AUTO_INCREMENT, `colorstone_id` bigint(20) NOT NULL, `url` varchar(255) NOT NULL, `page_item_name` varchar(255) NOT NULL, `page_item_name_en` varchar(255) NOT NULL, `color_content` varchar(1000) NOT NULL, `transparency_content` varchar(1000) NOT NULL, `shine_content` varchar(1000) NOT NULL, `process_content` varchar(1000) NOT NULL, `effects_powers_content` varchar(1000) NOT NULL, `areas_content` varchar(1000) NOT NULL, `characteristics_content` varchar(1000) NOT NULL, `historical_content` varchar(1000) NOT NULL, `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `created_by` int NOT NULL, `updated_at` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updated_by` int NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `contents_group`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `contents_group_details`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `contents_group_id` int NULL, `brand_id` int NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `freee_saisanhyou_fix_results`(`id` int NULL, `department_id` int NULL, `uriage` int NULL, `genka` int NULL, `keihi` int NULL, `total_works` int NULL, `year_month` varchar(6) NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL)CHARACTER SET utf8;
CREATE TABLE `goldcoin`(`id` int NOT NULL AUTO_INCREMENT, `region` int NULL, `country_name` int NULL, `material` int NULL, `reference_quality` int NULL, `quality` varchar(255) NULL, `coin_name` varchar(255) NULL, `surface` varchar(255) NULL, `back_side` varchar(255) NULL, `remarks` mediumtext NULL, `related_word` mediumtext NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `goldcoin_details`(`id` int NOT NULL AUTO_INCREMENT, `face_value` varchar(255) NULL, `face_value_number` decimal(11,2) NULL, `face_value_unit` int NULL, `ounce` varchar(255) NULL, `diameter_mm` varchar(255) NULL, `total_weight` varchar(255) NULL, `total_weight_for_calc` varchar(255) NULL, `manufacturing_number` int NULL, `selling_price` varchar(255) NULL, `selling_price_unit` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `goldcoin_id` int NULL, `region_id` int NULL, `start_year` varchar(255) NULL, `year_remark` varchar(255) NULL, `end_year` varchar(255) NULL, `material_URL_1` mediumtext NULL, `material_URL_2` mediumtext NULL, `surface_image_URL` mediumtext NULL, `back_side_image_URL` mediumtext NULL, `use_back_img` tinyint NULL, `popular_coin_price_sort` int NULL, `search_result_sort` int NULL, `display_list_sort` int NULL, `coefficient` decimal(5,4) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `goldcoin_mint`(`id` int NOT NULL AUTO_INCREMENT, `mint` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `goldcoin_id` int NULL, `country_name_id` int NULL, `goldcoin_details_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `info`(`id` int NOT NULL AUTO_INCREMENT, `sex` varchar(50) NULL, `todou` varchar(255) NULL, `tel` varchar(255) NULL, `mail` varchar(255) NULL, `contact` varchar(50) NULL, `text` mediumtext NULL, `created_at` datetime NULL, `image` varchar(255) NULL, `domain` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `information`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(255) NULL, `title` varchar(255) NULL, `text` mediumtext NULL, `kin_flag` tinyint NULL, `bra_flag` tinyint NULL, `dia_flag` tinyint NULL, `open_flag` tinyint NULL, `open_date` datetime NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `url` mediumtext NULL, `url_bra` mediumtext NULL, `url_dia` mediumtext NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `inport`(`name` varchar(255) NULL, `model_num` varchar(255) NULL, `fabric` varchar(255) NULL, `fabric_num` varchar(255) NULL, `color` varchar(255) NULL, `color_num` varchar(255) NULL, `ref_list_price` varchar(255) NULL, `size` varchar(255) NULL, `ref_purchace_price` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `interview`(`interview_id` int NOT NULL AUTO_INCREMENT, `title` mediumtext NULL, `description` mediumtext NULL, `url` mediumtext NULL, `h1` mediumtext NULL, `h1_text` mediumtext NULL, `h1_img_url` mediumtext NULL, `thumbnail_img_url` mediumtext NULL, `customer_img_url` mediumtext NULL, `customer_name` mediumtext NULL, `open_at` datetime NULL, `is_open` tinyint NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `interviewer_comment` mediumtext NULL, `interviewer_comment_by` int NULL, `customer_comment` mediumtext NULL, `writer_comment` mediumtext NULL, `writer_comment_by` int NULL, `video_url` mediumtext NULL, `custom_page_url` mediumtext NULL, `sp_h1_img_url` mediumtext NULL, PRIMARY KEY (`interview_id`))CHARACTER SET utf8;
CREATE TABLE `interview_contents`(`interview_content_id` int NOT NULL AUTO_INCREMENT, `interview_section_id` bigint(20) NULL, `comment_by` int NULL, `comment_img_url_id` int NULL, `custom_comment_img_url` mediumtext NULL, `comment_text` mediumtext NULL, `sort` int NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`interview_content_id`))CHARACTER SET utf8;
CREATE TABLE `interview_sections`(`interview_section_id` int NOT NULL AUTO_INCREMENT, `interview_id` bigint(20) NULL, `h2` mediumtext NULL, `h2_for_index` mediumtext NULL, `h2_for_pagelink` mediumtext NULL, `sort` int NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`interview_section_id`))CHARACTER SET utf8;
CREATE TABLE `kagoya_audit`(`id` int NOT NULL AUTO_INCREMENT, `datetime` datetime NOT NULL, `ip` varchar(40) NOT NULL, `user` varchar(300) NULL, `table` varchar(300) NULL, `action` varchar(250) NOT NULL, `description` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `kagoya_result`(`product_id` int NOT NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_status` int NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `price_for_site_flag` tinyint NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `ecc_id` int NULL, `price` int NULL, `cost` int NULL, `identification_cost` int NULL, `other_cost` int NULL)CHARACTER SET utf8;
CREATE TABLE `kagoya_result_img`(`product_id` int NOT NULL, `imgpass` mediumtext NULL, PRIMARY KEY (`product_id`))CHARACTER SET utf8;
CREATE TABLE `kagoya_result_original`(`product_id` int NOT NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_status` int NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `price_for_site_flag` tinyint NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL)CHARACTER SET utf8;
CREATE TABLE `kagoya_result_out`(`product_id` int NOT NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_status` int NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `price_for_site_flag` tinyint NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL)CHARACTER SET utf8;
CREATE TABLE `kagoya_uggroups`(`GroupID` int NOT NULL AUTO_INCREMENT, `Label` varchar(300) NULL, PRIMARY KEY (`GroupID`))CHARACTER SET utf8;
CREATE TABLE `kagoya_ugmembers`(`UserName` varchar(300) NOT NULL, `GroupID` int NOT NULL, PRIMARY KEY (`UserName`(50),`GroupID`))CHARACTER SET utf8;
CREATE TABLE `kagoya_ugrights`(`TableName` varchar(300) NOT NULL, `GroupID` int NOT NULL, `AccessMask` varchar(10) NULL, PRIMARY KEY (`TableName`(50),`GroupID`))CHARACTER SET utf8;
CREATE TABLE `line_Eoc_relationships`(`id` int NOT NULL AUTO_INCREMENT, `ecc_id` int NULL, `line_id` varchar(255) NULL, `created_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` datetime NULL, `login_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mail_magazine_cancel`(`id` int NOT NULL AUTO_INCREMENT, `mailaddress` mediumtext NULL, `send_mail_id` bigint(20) NULL, `requested_at` datetime NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `is_finished` tinyint NULL DEFAULT 0, `finished_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mail_magazine_open_logs`(`id` int NOT NULL AUTO_INCREMENT, `send_mail_id` int NULL, `mailaddress` varchar(255) NULL, `opened_at` datetime NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `user_agent` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mailsystem_send_schedule`(`id` int NOT NULL AUTO_INCREMENT, `tpl` int NULL, `ecc_id` varchar(30) NULL, `from_addr` varchar(100) NULL, `to_addr` varchar(100) NULL, `subject_pc` varchar(255) NULL, `str_header` mediumtext NULL, `str_pc` mediumtext NULL, `str2_pc` mediumtext NULL, `str3_pc` mediumtext NULL, `send_date` date NULL, `regist_date` datetime NULL, `send_flag` int NULL DEFAULT 0, `send_kind` varchar(10) NULL, `sateinin` varchar(10) NULL, `money` varchar(10) NULL, `regist_customer` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `market_product_img`(`market_product_id` bigint(20) NOT NULL, `imgpass` mediumtext NULL, `product_id` int NULL, PRIMARY KEY (`market_product_id`))CHARACTER SET utf8;
CREATE TABLE `market_product_performance_original`(`id` int NOT NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `ichiba_melee_gai` int NULL, `Apparaiser` int NULL, `zeinuki` int NULL, `nyuukin_price` int NULL, `ichiba_lot_pieces` int NULL, `avg` varchar(255) NULL, `comment` mediumtext NULL, `syuppinsya` varchar(255) NULL, `DA_YOURNAME` varchar(255) NULL, `ichiba_img` mediumtext NULL, `charagai` int NULL, `price_without_tax` int NULL, `price` int NULL, `sagaku` int NULL, `arari` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `resize_flg` tinyint NULL, `title_for_site` mediumtext NULL, `relation_id` int NULL, `voice_sub_id` int NULL, `is_ok` tinyint NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `display_buy_data` date NULL, `product_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `market_product_result`(`id` int NOT NULL, `product_id` int NULL, `voice_sub_id` int NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `Apparaiser` int NULL, `comment` mediumtext NULL, `ichiba_img` mediumtext NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `title_for_site` mediumtext NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `display_buy_data` date NULL, `product_num` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `members`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `email` varchar(255) NULL, `contact_email` varchar(255) NULL, `input_email` varchar(255) NULL, `password` varchar(255) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `confirmed` int NULL DEFAULT 0, `remember_token` varchar(255) NULL, `token_time` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `members_comment`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(255) NULL, `item_id` int NULL, `to_id` varchar(255) NULL, `to_comment_id` int NULL, `comment` mediumtext NULL, `user_id` int NULL, `flag` tinyint NULL DEFAULT 0, `update_at` datetime NULL, `lounge_id` int NULL, `to_lounge` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `members_deleted`(`id` int NULL, `name` varchar(255) NULL, `email` varchar(255) NULL, `contact_email` varchar(255) NULL, `input_email` varchar(255) NULL, `password` varchar(255) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `confirmed` int NULL DEFAULT 0, `remember_token` varchar(255) NULL, `token_time` datetime NULL)CHARACTER SET utf8;
CREATE TABLE `members_favorite`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(255) NULL, `item_id` int NULL, `user_id` int NULL, `tokumei_id` varchar(200) NULL, `flag` tinyint NULL DEFAULT 1, `update_at` datetime NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `members_password_resets`(`email` varchar(255) NOT NULL, `token` varchar(255) NULL, `created_at` datetime NULL)CHARACTER SET utf8;
CREATE TABLE `members_tokumei`(`id` varchar(200) NOT NULL, `created_at` datetime NULL, `updated_at` datetime NULL, `last_access` datetime NULL, PRIMARY KEY (`id`(50)))CHARACTER SET utf8;
CREATE TABLE `migrations`(`id` int NOT NULL AUTO_INCREMENT, `migration` varchar(255) NOT NULL, `batch` int NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_Appraiser`(`id` int NOT NULL AUTO_INCREMENT, `val` varchar(150) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` varchar(100) NULL, `create_at` datetime NULL, `create_by` varchar(100) NULL, `english_name` varchar(150) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_DA_POLISH`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `full_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_DA_SYMMETRY`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `full_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_Eoc_address`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `todou` varchar(255) NULL, `top_image` mediumtext NULL, `episode` mediumtext NULL, `create_at` datetime NULL, `create_by` bigint(11) NULL, `update_at` datetime NULL, `update_by` bigint(11) NULL, `top_image_sp` mediumtext NULL, `top_image_txt` mediumtext NULL, `todou_en` varchar(255) NULL, `name_en` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_Eoc_address_copy1`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `todou` varchar(255) NULL, `top_image` mediumtext NULL, `episode` mediumtext NULL, `create_at` datetime NULL, `create_by` bigint(11) NULL, `update_at` datetime NULL, `update_by` bigint(11) NULL, `top_image_sp` mediumtext NULL, `top_image_txt` mediumtext NULL, `todou_en` varchar(255) NULL, `name_en` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_Intensity`(`ID0` int NOT NULL AUTO_INCREMENT, `Name` varchar(50) NULL, `Sort` int NULL, PRIMARY KEY (`ID0`))CHARACTER SET utf8;
CREATE TABLE `mst_Ring_size`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` varchar(100) NULL, `create_at` datetime NULL, `create_by` varchar(100) NULL, `yahoo_junle` varchar(128) NULL, `category_id` int NULL, `sub_category_id1` int NULL, `ws_output` varchar(100) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_Setting`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` varchar(100) NULL, `create_at` datetime NULL, `create_by` varchar(100) NULL, `yahoo_junle` varchar(128) NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(150) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brakai_column_category_data`(`id` int NOT NULL AUTO_INCREMENT, `category_name` varchar(255) NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brakai_column_data`(`id` int NOT NULL AUTO_INCREMENT, `release_flag` tinyint NOT NULL DEFAULT 0, `brand` varchar(60) NOT NULL, `directory_name` varchar(180) NOT NULL, `label` varchar(255) NOT NULL, `title` varchar(180) NOT NULL, `description` varchar(600) NOT NULL, `h1_ttl` varchar(180) NOT NULL, `h1_ttl_sp` varchar(180) NOT NULL, `h1_text` mediumtext NOT NULL, `h1_text_sp` mediumtext NOT NULL, `date` varchar(30) NOT NULL, `open_date` varchar(30) NOT NULL, `last_edit` varchar(30) NOT NULL, `link` varchar(100) NOT NULL, `eye_catch_img` varchar(200) NOT NULL, `eye_catch_alt` mediumtext NULL, `kiji_sum` int NOT NULL DEFAULT 1, `main_ttl_1` mediumtext NULL, `main_ttl_sp_1` mediumtext NULL, `main_text_1_type` varchar(60) NULL, `main_text_1` mediumtext NULL, `main_text_sp_1` mediumtext NULL, `main_img_1` varchar(200) NULL, `main_ttl_2` mediumtext NULL, `main_ttl_sp_2` mediumtext NULL, `main_text_2_type` varchar(60) NULL, `main_text_2` mediumtext NULL, `main_text_sp_2` mediumtext NULL, `main_img_2` varchar(200) NULL, `main_ttl_3` mediumtext NULL, `main_ttl_sp_3` mediumtext NULL, `main_text_3_type` varchar(60) NULL, `main_text_3` mediumtext NULL, `main_text_sp_3` mediumtext NULL, `main_img_3` varchar(200) NULL, `main_ttl_4` mediumtext NULL, `main_ttl_sp_4` mediumtext NULL, `main_text_4_type` varchar(60) NULL, `main_text_4` mediumtext NULL, `main_text_sp_4` mediumtext NULL, `main_img_4` varchar(200) NULL, `main_ttl_5` mediumtext NULL, `main_ttl_sp_5` mediumtext NULL, `main_text_5_type` varchar(60) NULL, `main_text_5` mediumtext NULL, `main_text_sp_5` mediumtext NULL, `main_img_5` varchar(200) NULL, `main_ttl_6` mediumtext NULL, `main_ttl_sp_6` mediumtext NULL, `main_text_6_type` varchar(60) NULL, `main_text_6` mediumtext NULL, `main_text_sp_6` mediumtext NULL, `main_img_6` varchar(200) NULL, `main_ttl_7` mediumtext NULL, `main_ttl_sp_7` mediumtext NULL, `main_text_7_type` varchar(60) NULL, `main_text_7` mediumtext NULL, `main_text_sp_7` mediumtext NULL, `main_img_7` varchar(200) NULL, `main_ttl_8` mediumtext NULL, `main_ttl_sp_8` mediumtext NULL, `main_text_8_type` varchar(60) NULL, `main_text_8` mediumtext NULL, `main_text_sp_8` mediumtext NULL, `main_img_8` varchar(200) NULL, `main_ttl_9` mediumtext NULL, `main_ttl_sp_9` mediumtext NULL, `main_text_9_type` varchar(60) NULL, `main_text_9` mediumtext NULL, `main_text_sp_9` mediumtext NULL, `main_img_9` varchar(200) NULL, `main_ttl_10` mediumtext NULL, `main_ttl_sp_10` mediumtext NULL, `main_text_10_type` varchar(60) NULL, `main_text_10` mediumtext NULL, `main_text_sp_10` mediumtext NULL, `main_img_10` varchar(200) NULL, `main_ttl_11` mediumtext NULL, `main_ttl_sp_11` mediumtext NULL, `main_text_11_type` varchar(60) NULL, `main_text_11` mediumtext NULL, `main_text_sp_11` mediumtext NULL, `main_img_11` varchar(200) NULL, `main_ttl_12` mediumtext NULL, `main_ttl_sp_12` mediumtext NULL, `main_text_12_type` varchar(60) NULL, `main_text_12` mediumtext NULL, `main_text_sp_12` mediumtext NULL, `main_img_12` varchar(200) NULL, `main_ttl_13` mediumtext NULL, `main_ttl_sp_13` mediumtext NULL, `main_text_13_type` varchar(60) NULL, `main_text_13` mediumtext NULL, `main_text_sp_13` mediumtext NULL, `main_img_13` varchar(200) NULL, `main_ttl_14` mediumtext NULL, `main_ttl_sp_14` mediumtext NULL, `main_text_14_type` varchar(60) NULL, `main_text_14` mediumtext NULL, `main_text_sp_14` mediumtext NULL, `main_img_14` varchar(200) NULL, `main_ttl_15` mediumtext NULL, `main_ttl_sp_15` mediumtext NULL, `main_text_15_type` varchar(60) NULL, `main_text_15` mediumtext NULL, `main_text_sp_15` mediumtext NULL, `main_img_15` varchar(200) NULL, `main_ttl_16` mediumtext NULL, `main_ttl_sp_16` mediumtext NULL, `main_text_16_type` varchar(60) NULL, `main_text_16` mediumtext NULL, `main_text_sp_16` mediumtext NULL, `main_img_16` varchar(200) NULL, `main_ttl_17` mediumtext NULL, `main_ttl_sp_17` mediumtext NULL, `main_text_17_type` varchar(60) NULL, `main_text_17` mediumtext NULL, `main_text_sp_17` mediumtext NULL, `main_img_17` varchar(200) NULL, `main_ttl_18` mediumtext NULL, `main_ttl_sp_18` mediumtext NULL, `main_text_18_type` varchar(60) NULL, `main_text_18` mediumtext NULL, `main_text_sp_18` mediumtext NULL, `main_img_18` varchar(200) NULL, `main_ttl_19` mediumtext NULL, `main_ttl_sp_19` mediumtext NULL, `main_text_19_type` varchar(60) NULL, `main_text_19` mediumtext NULL, `main_text_sp_19` mediumtext NULL, `main_img_19` varchar(200) NULL, `main_ttl_20` mediumtext NULL, `main_ttl_sp_20` mediumtext NULL, `main_text_20_type` varchar(60) NULL, `main_text_20` mediumtext NULL, `main_text_sp_20` mediumtext NULL, `main_img_20` varchar(200) NULL, `column_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brakai_column_label_data`(`id` int NOT NULL AUTO_INCREMENT, `label_name` varchar(60) NULL, `label_i` varchar(255) NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brakai_column_layout`(`id` int NOT NULL AUTO_INCREMENT, `type` mediumtext NULL, `mamo` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brakai_column_list`(`id` int NOT NULL AUTO_INCREMENT, `release_flag` int NOT NULL, `brand_name` varchar(255) NULL, `directory_name` varchar(255) NULL, `label` mediumtext NULL, `title` varchar(255) NULL, `description` mediumtext NULL, `h1` varchar(255) NULL, `open_date` datetime NULL, `created_at` datetime NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `page_path` varchar(255) NULL, `eye_catch_img` varchar(255) NULL, `kiji_sum` int NULL, `pankuzu1` varchar(255) NULL, `pankuzu2` varchar(255) NULL, `pankuzu3` varchar(255) NULL, `pankuzu4` varchar(255) NULL, `pankuzu1_url` varchar(255) NULL, `pankuzu2_url` varchar(255) NULL, `pankuzu3_url` varchar(255) NULL, `pankuzu4_url` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brand`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `eng_name` varchar(255) NULL, `goods_id` int NULL, `japananese_name` varchar(255) NULL, `english_name` varchar(255) NULL, `tag` varchar(255) NULL, `tage` varchar(255) NULL, `seach_j` varchar(255) NULL, `seach_e` varchar(255) NULL, `mst_band_title` varchar(255) NULL, `register_at` datetime NULL, `update_at` datetime NULL, `register_by` int NULL, `update_by` int NULL, `preview` int NULL, `app_name` varchar(255) NULL, `bag` varchar(255) NULL, `wallet` varchar(255) NULL, `accessories` varchar(255) NULL, `catch` varchar(255) NULL, `shoes` varchar(255) NULL, `outer` varchar(255) NULL, `tops` varchar(255) NULL, `camisole` varchar(255) NULL, `bottoms` varchar(255) NULL, `underwear` varchar(255) NULL, `Legwear` varchar(255) NULL, `hat` varchar(255) NULL, `other` varchar(255) NULL, `kids` varchar(255) NULL, `cosmetics` varchar(255) NULL, `gold` varchar(255) NULL, `tableware` varchar(255) NULL, `umbrella` varchar(255) NULL, `season` varchar(255) NULL, `new` varchar(255) NULL, `kyouka` varchar(50) NULL, `timest` datetime NULL, `luxury` varchar(50) NULL, `brand_details` mediumtext NULL, `create_by` varchar(50) NULL, `create_at` datetime NULL, `expensive` mediumtext NULL, `rakutag_id` int NULL, `wasabi_name` varchar(255) NULL, `gray_but_want_to_buy` varchar(50) NULL, `tag_img` mediumtext NULL, `satei_memo` mediumtext NULL, `url` mediumtext NULL, `bullion_dealer` tinyint NULL, `ranking_id` varchar(255) NULL, `is_satei_group` tinyint NULL, `is_satei_group_jewelry` tinyint NULL, `is_purchase_D` tinyint NULL, `is_purchase_J` tinyint NULL, `is_purchase_K` tinyint NULL, `is_purchase_B` tinyint NULL, `is_purchase_W` tinyint NULL, `is_japanese_artist` tinyint NULL, `is_all_gray` tinyint NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brand2`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `eng_name` varchar(255) NULL, `goods_id` int NULL, `japananese_name` varchar(255) NULL, `english_name` varchar(255) NULL, `tag` varchar(255) NULL, `tage` varchar(255) NULL, `seach_j` varchar(255) NULL, `seach_e` varchar(255) NULL, `mst_band_title` varchar(255) NULL, `register_at` datetime NULL, `update_at` datetime NULL, `register_by` int NULL, `update_by` int NULL, `preview` int NULL, `app_name` varchar(255) NULL, `bag` varchar(255) NULL, `wallet` varchar(255) NULL, `accessories` varchar(255) NULL, `catch` varchar(255) NULL, `shoes` varchar(255) NULL, `outer` varchar(255) NULL, `tops` varchar(255) NULL, `camisole` varchar(255) NULL, `bottoms` varchar(255) NULL, `underwear` varchar(255) NULL, `Legwear` varchar(255) NULL, `hat` varchar(255) NULL, `other` varchar(255) NULL, `kids` varchar(255) NULL, `cosmetics` varchar(255) NULL, `gold` varchar(255) NULL, `tableware` varchar(255) NULL, `umbrella` varchar(255) NULL, `season` varchar(255) NULL, `new` varchar(255) NULL, `kyouka` varchar(50) NULL, `timest` datetime NULL, `luxury` varchar(50) NULL, `brand_details` mediumtext NULL, `create_by` varchar(50) NULL, `create_at` datetime NULL, `expensive` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brand_break20221223`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `eng_name` varchar(255) NULL, `goods_id` int NULL, `japananese_name` varchar(255) NULL, `english_name` varchar(255) NULL, `tag` varchar(255) NULL, `tage` varchar(255) NULL, `seach_j` varchar(255) NULL, `seach_e` varchar(255) NULL, `mst_band_title` varchar(255) NULL, `register_at` datetime NULL, `update_at` datetime NULL, `register_by` int NULL, `update_by` int NULL, `preview` int NULL, `app_name` varchar(255) NULL, `bag` varchar(255) NULL, `wallet` varchar(255) NULL, `accessories` varchar(255) NULL, `watch` varchar(255) NULL, `shoes` varchar(255) NULL, `outer` varchar(255) NULL, `tops` varchar(255) NULL, `camisole` varchar(255) NULL, `bottoms` varchar(255) NULL, `underwear` varchar(255) NULL, `Legwear` varchar(255) NULL, `hat` varchar(255) NULL, `other` varchar(255) NULL, `kids` varchar(255) NULL, `cosmetics` varchar(255) NULL, `gold` varchar(255) NULL, `tableware` varchar(255) NULL, `umbrella` varchar(255) NULL, `season` varchar(255) NULL, `new` varchar(255) NULL, `kyouka` varchar(50) NULL, `timest` datetime NULL, `luxury` varchar(50) NULL, `brand_details` mediumtext NULL, `create_by` varchar(50) NULL, `create_at` datetime NULL, `expensive` mediumtext NULL, `rakutag_id` int NULL, `wasabi_name` varchar(255) NULL, `gray_but_want_to_buy` varchar(50) NULL, `tag_img` mediumtext NULL, `satei_memo` mediumtext NULL, `url` mediumtext NULL, `bullion_dealer` tinyint NULL, `ranking_id` varchar(255) NULL, `is_satei_group` tinyint NULL, `is_satei_group_jewelry` tinyint NULL, `is_purchase_D` tinyint NULL, `is_purchase_J` tinyint NULL, `is_purchase_K` tinyint NULL, `is_purchase_B` tinyint NULL, `is_purchase_W` tinyint NULL, `is_japanese_artist` tinyint NULL, `is_all_gray` tinyint NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_brand_include_result`(`id` int NOT NULL AUTO_INCREMENT, `target_pass` varchar(255) NULL, `s_brand` bigint(20) NULL, `s_category` int NULL, `free_word` varchar(255) NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_breast`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_buy_campaign`(`page_id` int NOT NULL AUTO_INCREMENT, `campaign_name` varchar(150) NOT NULL, `description` mediumtext NULL, `top_txt` mediumtext NULL, `mousikomi_startDate` date NULL, `mousikomi_lastDate` date NULL, `touchaku_startDate` date NULL, `touchaku_lastDate` date NULL, `camp_id` varchar(150) NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, `event` tinyint NULL, `h1_img` mediumtext NULL, PRIMARY KEY (`page_id`))CHARACTER SET utf8;
CREATE TABLE `mst_buy_campaign_content`(`id` int NOT NULL AUTO_INCREMENT, `camptop_img` varchar(150) NULL, `datail_img` varchar(150) NULL, `camp_category` int NULL, `camp_ttl` varchar(150) NULL, `camp_txt` mediumtext NULL, `result_box_id` varchar(150) NULL, `page1_ttl` varchar(150) NULL, `page1_url` varchar(150) NULL, `page2_ttl` varchar(150) NULL, `page2_url` varchar(150) NULL, `page3_ttl` varchar(150) NULL, `page3_url` varchar(150) NULL, `page4_ttl` varchar(150) NULL, `page4_url` varchar(150) NULL, `page5_ttl` varchar(150) NULL, `page5_url` varchar(150) NULL, `layout_pattern` int NULL DEFAULT 1, `sp_layout_pattern` int NULL DEFAULT 4, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, `page_id` int NULL, `sort` int NULL, `rate` int NULL, `backgroundcolor` varchar(50) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_buy_campaign_layout`(`layout_id` int NOT NULL AUTO_INCREMENT, `layout` mediumtext NULL, `memo` mediumtext NULL, `path` mediumtext NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, `layout_name` varchar(255) NULL, `wp_pass` mediumtext NULL, PRIMARY KEY (`layout_id`))CHARACTER SET utf8;
CREATE TABLE `mst_buy_campaign_target`(`id` int NOT NULL AUTO_INCREMENT, `content_id` int NULL, `product_num` int NULL, `category_id` int NULL, `sub_category_id` int NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_buy_result`(`result_id` int NOT NULL AUTO_INCREMENT, `result_ttl` varchar(255) NULL, `result_img_seq` varchar(150) NULL, `result_img_url` varchar(150) NULL, `list_price` varchar(150) NULL, `camp_price` varchar(150) NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, `campaign_id` int NULL, `sort` int NULL, PRIMARY KEY (`result_id`))CHARACTER SET utf8;
CREATE TABLE `mst_category_label_data`(`id` int NOT NULL AUTO_INCREMENT, `label_data` varchar(60) NOT NULL, `gold` tinyint NOT NULL DEFAULT 0, `platinum` tinyint NULL DEFAULT 0, `colorstone` tinyint NOT NULL DEFAULT 0, `diamond` tinyint NOT NULL DEFAULT 0, `brand` tinyint NOT NULL DEFAULT 0, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_chain_type`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_cloth`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_collar_neck_line`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_color_fluo`(`Id` int NOT NULL AUTO_INCREMENT, `Name` varchar(50) NULL, `sort` int NULL, PRIMARY KEY (`Id`))CHARACTER SET utf8;
CREATE TABLE `mst_colorstone`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `update_at` datetime NULL, `sort` int NULL, `img_url` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_column_data`(`id` int NOT NULL AUTO_INCREMENT, `release_flag` tinyint NOT NULL DEFAULT 0, `big_category` varchar(60) NOT NULL, `directory_name` varchar(180) NOT NULL, `category_label` mediumtext NOT NULL, `title` varchar(180) NOT NULL, `description` varchar(600) NOT NULL, `h1` varchar(180) NOT NULL, `h1_sp` varchar(180) NOT NULL, `h1_text` mediumtext NOT NULL, `h1_text_sp` mediumtext NOT NULL, `date` varchar(30) NOT NULL, `open_date` varchar(30) NOT NULL, `last_edit` varchar(30) NOT NULL, `link` varchar(100) NOT NULL, `eye_catch_img` varchar(200) NOT NULL, `eye_catch_alt` mediumtext NULL, `kiji_sum` int NOT NULL DEFAULT 1, `main_ttl_1` mediumtext NULL, `main_ttl_sp_1` mediumtext NULL, `main_text_1_type` varchar(60) NULL, `main_text_1` mediumtext NULL, `main_text_sp_1` mediumtext NULL, `main_img_1` varchar(100) NULL, `main_ttl_2` mediumtext NULL, `main_ttl_sp_2` mediumtext NULL, `main_text_2_type` varchar(60) NULL, `main_text_2` mediumtext NULL, `main_text_sp_2` mediumtext NULL, `main_img_2` varchar(100) NULL, `main_ttl_3` mediumtext NULL, `main_ttl_sp_3` mediumtext NULL, `main_text_3_type` varchar(60) NULL, `main_text_3` mediumtext NULL, `main_text_sp_3` mediumtext NULL, `main_img_3` varchar(100) NULL, `main_ttl_4` mediumtext NULL, `main_ttl_sp_4` mediumtext NULL, `main_text_4_type` varchar(60) NULL, `main_text_4` mediumtext NULL, `main_text_sp_4` mediumtext NULL, `main_img_4` varchar(100) NULL, `main_ttl_5` mediumtext NULL, `main_ttl_sp_5` mediumtext NULL, `main_text_5_type` varchar(60) NULL, `main_text_5` mediumtext NULL, `main_text_sp_5` mediumtext NULL, `main_img_5` varchar(100) NULL, `main_ttl_6` mediumtext NULL, `main_ttl_sp_6` mediumtext NULL, `main_text_6_type` varchar(60) NULL, `main_text_6` mediumtext NULL, `main_text_sp_6` mediumtext NULL, `main_img_6` varchar(100) NULL, `main_ttl_7` mediumtext NULL, `main_ttl_sp_7` mediumtext NULL, `main_text_7_type` varchar(60) NULL, `main_text_7` mediumtext NULL, `main_text_sp_7` mediumtext NULL, `main_img_7` varchar(100) NULL, `main_ttl_8` mediumtext NULL, `main_ttl_sp_8` mediumtext NULL, `main_text_8_type` varchar(60) NULL, `main_text_8` mediumtext NULL, `main_text_sp_8` mediumtext NULL, `main_img_8` varchar(100) NULL, `main_ttl_9` mediumtext NULL, `main_ttl_sp_9` mediumtext NULL, `main_text_9_type` varchar(60) NULL, `main_text_9` mediumtext NULL, `main_text_sp_9` mediumtext NULL, `main_img_9` varchar(100) NULL, `main_ttl_10` mediumtext NULL, `main_ttl_sp_10` mediumtext NULL, `main_text_10_type` varchar(60) NULL, `main_text_10` mediumtext NULL, `main_text_sp_10` mediumtext NULL, `main_img_10` varchar(100) NULL, `main_ttl_11` mediumtext NULL, `main_ttl_sp_11` mediumtext NULL, `main_text_11_type` varchar(60) NULL, `main_text_11` mediumtext NULL, `main_text_sp_11` mediumtext NULL, `main_img_11` varchar(100) NULL, `main_ttl_12` mediumtext NULL, `main_ttl_sp_12` mediumtext NULL, `main_text_12_type` varchar(60) NULL, `main_text_12` mediumtext NULL, `main_text_sp_12` mediumtext NULL, `main_img_12` varchar(100) NULL, `main_ttl_13` mediumtext NULL, `main_ttl_sp_13` mediumtext NULL, `main_text_13_type` varchar(60) NULL, `main_text_13` mediumtext NULL, `main_text_sp_13` mediumtext NULL, `main_img_13` varchar(100) NULL, `main_ttl_14` mediumtext NULL, `main_ttl_sp_14` mediumtext NULL, `main_text_14_type` varchar(60) NULL, `main_text_14` mediumtext NULL, `main_text_sp_14` mediumtext NULL, `main_img_14` varchar(100) NULL, `main_ttl_15` mediumtext NULL, `main_ttl_sp_15` mediumtext NULL, `main_text_15_type` varchar(60) NULL, `main_text_15` mediumtext NULL, `main_text_sp_15` mediumtext NULL, `main_img_15` varchar(100) NULL, `main_ttl_16` mediumtext NULL, `main_ttl_sp_16` mediumtext NULL, `main_text_16_type` varchar(60) NULL, `main_text_16` mediumtext NULL, `main_text_sp_16` mediumtext NULL, `main_img_16` varchar(100) NULL, `main_ttl_17` mediumtext NULL, `main_ttl_sp_17` mediumtext NULL, `main_text_17_type` varchar(60) NULL, `main_text_17` mediumtext NULL, `main_text_sp_17` mediumtext NULL, `main_img_17` varchar(100) NULL, `main_ttl_18` mediumtext NULL, `main_ttl_sp_18` mediumtext NULL, `main_text_18_type` varchar(60) NULL, `main_text_18` mediumtext NULL, `main_text_sp_18` mediumtext NULL, `main_img_18` varchar(100) NULL, `main_ttl_19` mediumtext NULL, `main_ttl_sp_19` mediumtext NULL, `main_text_19_type` varchar(60) NULL, `main_text_19` mediumtext NULL, `main_text_sp_19` mediumtext NULL, `main_img_19` varchar(100) NULL, `main_ttl_20` mediumtext NULL, `main_ttl_sp_20` mediumtext NULL, `main_text_20_type` varchar(60) NULL, `main_text_20` mediumtext NULL, `main_text_sp_20` mediumtext NULL, `main_img_20` varchar(100) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_column_label_data`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `column_id` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_country_name`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `region_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_cutting_style`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_designer`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_dia`(`id` int NOT NULL AUTO_INCREMENT, `dia_id` int NULL, `dia_remark` varchar(255) NULL, `_chigin_type_id` int NULL, `gold_property_list` mediumtext NULL, `store_categories_list` mediumtext NULL, `store_sub_categories_list` mediumtext NULL, `img_url` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_effect`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_gold_property`(`id` int NOT NULL AUTO_INCREMENT, `val` varchar(32) NULL, `sort` int NULL, `update_by` varchar(100) NULL, `update_at` datetime NULL, `created_by` varchar(100) NULL, `created_at` datetime NULL, `create_at` datetime NULL, `mypage_flag` tinyint NULL DEFAULT 1, `mst_dia_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_gold_property_copy`(`id` int NOT NULL AUTO_INCREMENT, `val` varchar(32) NULL, `sort` int NULL, `update_by` varchar(100) NULL, `update_at` datetime NULL, `created_by` varchar(100) NULL, `created_at` datetime NULL, `create_at` datetime NULL, `mypage_flag` tinyint NULL DEFAULT 1, `mst_dia_id` int NULL, `parent_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_gold_property_parents`(`id` int NOT NULL AUTO_INCREMENT, `val` varchar(32) NULL, `display_name` varchar(255) NULL, `sort` int NULL, `table` varchar(255) NULL, `reference_id` int NULL, `update_by` varchar(100) NULL, `update_at` datetime NULL, `create_by` varchar(100) NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_hahakai`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_handle`(`id` int NOT NULL AUTO_INCREMENT, `data` varchar(50) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` varchar(100) NULL, `create_at` datetime NULL, `create_by` varchar(100) NULL, `category_id` varchar(50) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_heel`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_inpagelink`(`id` int NOT NULL AUTO_INCREMENT, `url` varchar(255) NULL, `j_text` mediumtext NULL, `update_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_interview_users`(`mst_interview_user_id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`mst_interview_user_id`))CHARACTER SET utf8;
CREATE TABLE `mst_interview_users_img`(`id` int NOT NULL AUTO_INCREMENT, `mst_interview_user_id` int NULL, `img_name` varchar(255) NULL, `img_url` mediumtext NULL, `sort` int NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_item`(`id` int NOT NULL, `name` varchar(255) NOT NULL, `yahoo_junle` varchar(128) NOT NULL, `line_category` varchar(50) NOT NULL, `category_id` int NOT NULL, `sub_category_id1` int NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_item_group`(`id` int NOT NULL AUTO_INCREMENT, `yahoo_junle` int NULL, `name` varchar(255) NULL, `item_name` mediumtext NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_item_group_child`(`id` int NOT NULL AUTO_INCREMENT, `group_id` int NULL, `item_name` varchar(255) NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_item_name`(`id` int NOT NULL, `name` varchar(150) NOT NULL, `yahoo_junle` varchar(128) NOT NULL, `category_id` int NOT NULL, `sub_category_id1` int NOT NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_material`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_mint`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `country_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_motif`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` varchar(100) NULL, `create_at` datetime NULL, `create_by` varchar(100) NULL, `yahoo_junle` varchar(128) NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(150) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_number_of_stones`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_overtone`(`Id` int NOT NULL AUTO_INCREMENT, `Name` varchar(50) NULL, `sort` int NULL, PRIMARY KEY (`Id`))CHARACTER SET utf8;
CREATE TABLE `mst_post_category`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(255) NULL, `brand_id` int NULL, `name` varchar(255) NULL, `item_id` int NULL, `url` mediumtext NULL, `forward_match` tinyint NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_post_category_parent`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_price_unit`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `country_id` int NULL, `region_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_processing`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(150) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` varchar(100) NULL, `create_at` datetime NULL, `create_by` varchar(100) NULL, `yahoo_junle` varchar(128) NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(150) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_producing_area`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_quality`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_region`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_result_category`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `updated_at` datetime NULL, `updatad_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_result_group`(`id` int NOT NULL AUTO_INCREMENT, `category_id` int NULL, `name` varchar(255) NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_result_group_rule`(`id` int NOT NULL AUTO_INCREMENT, `group_id` int NULL, `gold_property` varchar(255) NULL, `category_id` int NULL, `sub_category_id` int NULL, `product_num` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_resultlist_category`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `update_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_resultlist_item`(`id` int NOT NULL AUTO_INCREMENT, `category_id` int NULL, `value` varchar(150) NULL, `name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_revoco_category`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(255) NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_saisun_item`(`id` varchar(255) NOT NULL, `category_id` mediumtext NULL, `sub_category_id1` mediumtext NULL, `name` varchar(255) NULL, `data_unit` varchar(100) NULL, `input_type` varchar(50) NULL, `select_list` mediumtext NULL, `line_break` varchar(100) NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `data_title` varchar(255) NULL, `sort` int NULL, `data_category_title` varchar(100) NULL, `memo` mediumtext NULL, PRIMARY KEY (`id`(50)))CHARACTER SET utf8;
CREATE TABLE `mst_search_category`(`id` int NOT NULL AUTO_INCREMENT, `search_name` varchar(255) NULL, `get_parameter` varchar(255) NULL, `table` varchar(255) NULL, `column_name` varchar(255) NULL, `value` varchar(255) NULL, `updated_at` datetime NULL, `created_at` datetime NULL, `search_text` mediumtext NULL, `mst_search_category_group_id` int NULL, `is_hidden` tinyint NULL, `count_products` int NULL, `product_num` int NULL, `category_id` int NULL, `wordnet` mediumtext NULL, `search_text_kana` mediumtext NULL, `search_text_romaji` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_search_category_group`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `table_name` varchar(255) NULL, `kinkai_sort` int NULL, `icon_html` mediumtext NULL, `is_hidden` tinyint NULL DEFAULT 0, `brakai_sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_sell_campaign`(`id` int NOT NULL AUTO_INCREMENT, `inSession` int NOT NULL, `mall_name` varchar(100) NULL, `folderName` varchar(150) NOT NULL, `campaign_name` mediumtext NULL, `camp_startDate` datetime NULL, `camp_lastDate` datetime NULL, `h1_sub` mediumtext NULL, `top_txt` mediumtext NULL, `coupon_name` varchar(150) NULL, `coupon_id` varchar(150) NULL, `content1_ttl` mediumtext NULL, `content1_sub` mediumtext NULL, `content1` mediumtext NULL, `content1_row` int NULL, `content1_column` int NULL, `content2_ttl` mediumtext NULL, `content2_sub` mediumtext NULL, `content2` mediumtext NULL, `content2_row` int NULL, `content2_column` int NULL, `content3_ttl` mediumtext NULL, `content3_sub` mediumtext NULL, `content3` mediumtext NULL, `content3_row` int NULL, `content3_column` int NULL, `search_box1_on` varchar(255) NULL, `search_box1_title` mediumtext NULL, `search_box1_word` mediumtext NULL, `search_box1_row` int NULL, `search_box1_column` int NULL, `search_box2_on` varchar(255) NULL, `search_box2_title` mediumtext NULL, `search_box2_word` mediumtext NULL, `search_box2_row` int NULL, `search_box2_column` int NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, `top_img` varchar(255) NULL, `left_img` varchar(255) NULL, `right_img` varchar(255) NULL, `fixed_img` varchar(255) NULL, `ad_cost` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_sell_coupon`(`id` int NOT NULL AUTO_INCREMENT, `mall_name` varchar(150) NULL, `startDate` datetime NULL, `lastDate` datetime NULL, `url` varchar(255) NULL, `img` varchar(255) NULL, `ttl` varchar(150) NULL, `update_by` int NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `create_by` int NULL, `create_at` datetime NULL, `coupon_id` int NULL, `rule` mediumtext NULL, `sort` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_sell_coupon_main`(`id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) NULL, `start_date` datetime NULL, `last_date` datetime NULL, `raku_url` varchar(255) NULL, `main_img` varchar(255) NULL, `banner_img` varchar(255) NULL, `right_img` varchar(255) NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `flag` varchar(1) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_shape`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `english_name` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_side_gem`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_silhouette`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_sitemap_categories`(`id` int NOT NULL, `name` varchar(255) NULL, `sort` int NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `is_hidden` tinyint NULL DEFAULT 0, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_sitemap_categories_aaaa`(`id` int NOT NULL, `name` varchar(255) NULL, `title` varchar(255) NULL, `sort` int NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_sleeve`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_structured_markup_for_faq`(`id` int NOT NULL AUTO_INCREMENT, `question` mediumtext NULL, `answer` mediumtext NULL, `created_by` int NULL, `created_at` datetime NULL, `updated_by` int NULL, `updated_at` datetime NULL, `display_url` varchar(255) NULL, `sort` int NULL, `url_hierarchy` int NULL, `exclustion_url` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_todoufuken`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_toe`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `line_category` varchar(100) NULL, `yahoo_junle` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `mst_toiawase_details`(`id` int NOT NULL AUTO_INCREMENT, `template` varchar(500) NULL, `sort` int NULL, `subject` varchar(45) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `page_index`(`url` varchar(255) NOT NULL, `index` mediumtext NULL, `update_at` datetime NULL, `create_at` datetime NULL, PRIMARY KEY (`url`(50)))CHARACTER SET utf8;
CREATE TABLE `post`(`id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) NULL, `text` mediumtext NULL, `open_flag` tinyint NULL, `open_date` datetime NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `url` mediumtext NULL, `category` varchar(255) NULL, `sub_category` varchar(255) NULL, `category_url` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `price_comparison`(`price_comparison_id` int NOT NULL AUTO_INCREMENT, `brand_id` bigint(20) NULL, `create_at` datetime NULL, `create_by` int NULL, `update_at` datetime NULL, `update_by` int NULL, `is_publish` tinyint NULL DEFAULT 0, PRIMARY KEY (`price_comparison_id`))CHARACTER SET utf8;
CREATE TABLE `price_comparison_item`(`id` int NOT NULL AUTO_INCREMENT, `price_comparison_id` bigint(20) NULL, `sort` int NULL, `result_id` int NULL, `create_at` datetime NULL, `create_by` int NULL, `update_at` datetime NULL, `update_by` int NULL, `title` mediumtext NULL, `purchase_type` varchar(255) NULL, `purchase_area` varchar(255) NULL, `price_A` int NULL, `price_B` int NULL, `display_price` int NULL, `img_pass` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `product_ranking_for_brand`(`brand_id` int NOT NULL, `brand_name` varchar(255) NULL, `product_id` int NULL, `nyuukin_price` int NULL)CHARACTER SET utf8;
CREATE TABLE `products_detail`(`product_id` int NOT NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `×_d` mediumtext NULL, `yuki_take` mediumtext NULL, `wrist_flat_2` mediumtext NULL, `width_foot_width` mediumtext NULL, `width` mediumtext NULL, `width_rubber_expansion_select` mediumtext NULL, `weight` mediumtext NULL, `weight_2_catch_included` mediumtext NULL, `waist_rubber_expansion_select` mediumtext NULL, `width_of_a_garment` mediumtext NULL, `west_min` mediumtext NULL, `total_length` mediumtext NULL, `upper_and_lower_specification` mediumtext NULL, `up_to_around_the_arm` mediumtext NULL, `top_h` mediumtext NULL, `top_w` mediumtext NULL, `total_depth` mediumtext NULL, `yoko_width` mediumtext NULL, `the_thickness_select` mediumtext NULL, `tops_size` mediumtext NULL, `the_number_of_interval` mediumtext NULL, `tops` mediumtext NULL, `temple` mediumtext NULL, `strap_full_length` mediumtext NULL, `waterproof` mediumtext NULL, `storm` mediumtext NULL, `symmetry` mediumtext NULL, `stiletto` mediumtext NULL, `sleeve_length` mediumtext NULL, `specification` mediumtext NULL, `size_w` mediumtext NULL, `size_w_mm` mediumtext NULL, `size_including_notation` mediumtext NULL, `size_h_wcm` mediumtext NULL, `table_size` mediumtext NULL, `slit_the_entire_length` mediumtext NULL, `size_d_mm` mediumtext NULL, `top_d` mediumtext NULL, `shoulder___cm` mediumtext NULL, `size_h_mm` mediumtext NULL, `shoulder_straps_full-length` mediumtext NULL, `shoulder_width` mediumtext NULL, `shoulder_cm` mediumtext NULL, `shoulder_min` mediumtext NULL, `sense_of_sheer_select` mediumtext NULL, `shape_select` mediumtext NULL, `saliva` mediumtext NULL, `season_select` mediumtext NULL, `rise` mediumtext NULL, `rubber_expansion_select` mediumtext NULL, `ribs` mediumtext NULL, `size` mediumtext NULL, `removable_select` mediumtext NULL, `size_h` mediumtext NULL, `regulation_select` mediumtext NULL, `remove_select` mediumtext NULL, `size_d` mediumtext NULL, `rear_length` mediumtext NULL, `remainder_piece_width` mediumtext NULL, `pocket` mediumtext NULL, `polish` mediumtext NULL, `pavilion_depth` mediumtext NULL, `partition_select` mediumtext NULL, `parent_stone_size_h_w_visible_dimension` mediumtext NULL, `parent_stone` mediumtext NULL, `outsole` mediumtext NULL, `outside_zipper_pocket` mediumtext NULL, `outside_select` mediumtext NULL, `outside_purses` mediumtext NULL, `outside_pocket_count_3` mediumtext NULL, `outside_pocket_count_2` mediumtext NULL, `outside_pocket_count_1` mediumtext NULL, `outside_pocket_3` mediumtext NULL, `outside_pocket_2` mediumtext NULL, `piece` mediumtext NULL, `outside_pocket_1` mediumtext NULL, `outside_insert_the_card` mediumtext NULL, `regulation` mediumtext NULL, `outside_card_pocket` mediumtext NULL, `outer_width_of_a_garment` mediumtext NULL, `outer_total_length` mediumtext NULL, `possession_cm` mediumtext NULL, `outer_sleeve_length` mediumtext NULL, `outer_shoulder_width` mediumtext NULL, `outer_pocket` mediumtext NULL, `ring_width` mediumtext NULL, `outer_yuki_take` mediumtext NULL, `outer_length` mediumtext NULL, `otherwise` mediumtext NULL, `outer` mediumtext NULL, `outer_detachable_way` mediumtext NULL, `outside_free_pocket` mediumtext NULL, `outer_mark_size` mediumtext NULL, `open_pocket` mediumtext NULL, `open_and_close_select` mediumtext NULL, `motif_w` mediumtext NULL, `movement_select` mediumtext NULL, `motif_top_h` mediumtext NULL, `opening_and_closing_2_select` mediumtext NULL, `motif_d` mediumtext NULL, `mno_manganese` mediumtext NULL, `min_arm_around` mediumtext NULL, `middle_finger_full-length` mediumtext NULL, `maximum_west` mediumtext NULL, `maximum_shoulder` mediumtext NULL, `mark_size_by_gou` mediumtext NULL, `mark_size` mediumtext NULL, `motif_top_w` mediumtext NULL, `lower_half_length` mediumtext NULL, `magnet_pocket` mediumtext NULL, `lining_select` mediumtext NULL, `lining_measurements_select` mediumtext NULL, `liner_removable_select` mediumtext NULL, `less_number_of_frames` mediumtext NULL, `lens_w` mediumtext NULL, `nose_width` mediumtext NULL, `open_and_close` mediumtext NULL, `loading...` mediumtext NULL, `large_sword` mediumtext NULL, `motif_h` mediumtext NULL, `key_hook_total_length` mediumtext NULL, `keeling_overall_length` mediumtext NULL, `jacket` mediumtext NULL, `length_until_switching` mediumtext NULL, `in_connection_with_the_sale_of_ph_only` mediumtext NULL, `internal_capacity` mediumtext NULL, `lens_h` mediumtext NULL, `insole_select` mediumtext NULL, `insole` mediumtext NULL, `inside_wallet` mediumtext NULL, `length` mediumtext NULL, `inside_select` mediumtext NULL, `inside_pocket_count_3` mediumtext NULL, `inside_pocket_count_2` mediumtext NULL, `inside_pocket_count_1` mediumtext NULL, `inside_pocket_4` mediumtext NULL, `inside_pocket_3` mediumtext NULL, `interior_zip_pocket` mediumtext NULL, `inside_pocket_2` mediumtext NULL, `inside_pocket_count_4` mediumtext NULL, `inside_key_ring` mediumtext NULL, `inside_key_hook` mediumtext NULL, `inside_coin_purse` mediumtext NULL, `inside_card_pocket` mediumtext NULL, `inside_pen_holder` mediumtext NULL, `insert_the_card` mediumtext NULL, `internal_capacity_gram` mediumtext NULL, `inner_width_of_a_garment` mediumtext NULL, `inside_pocket_1` mediumtext NULL, `inner_sleeve_length` mediumtext NULL, `inner_shoulder_width` mediumtext NULL, `inner_shoulder_straps_full-length` mediumtext NULL, `interval` mediumtext NULL, `inseam` mediumtext NULL, `inner_removable_select` mediumtext NULL, `inner_pocket` mediumtext NULL, `inner_yuki_take` mediumtext NULL, `inner_length` mediumtext NULL, `inner_mark_size` mediumtext NULL, `inner_detachable_way` mediumtext NULL, `inner_hip_circumference` mediumtext NULL, `inner_around_the_waist` mediumtext NULL, `how_to_open_and_close_select` mediumtext NULL, `inner_total_length` mediumtext NULL, `hole_regulation` mediumtext NULL, `hip_circumference_lining_measurements_select` mediumtext NULL, `inner_regulation_select` mediumtext NULL, `height_including_heel` mediumtext NULL, `hip_circumference_rubber_expansion_select` mediumtext NULL, `heel` mediumtext NULL, `hip_circumference_15cm_under_the_waist` mediumtext NULL, `gross_weight` mediumtext NULL, `handle` mediumtext NULL, `full_length` mediumtext NULL, `hip_circumference` mediumtext NULL, `frontage_diameter` mediumtext NULL, `height` mediumtext NULL, `free_inner_pocket` mediumtext NULL, `fringe_full_length` mediumtext NULL, `food_detachable_select` mediumtext NULL, `front_front` mediumtext NULL, `flat_diameter_2` mediumtext NULL, `fur_detachable_select` mediumtext NULL, `during_deployment_diameter` mediumtext NULL, `inner_select` mediumtext NULL, `elasticity_select` mediumtext NULL, `discrimination_institution_name` mediumtext NULL, `fluorescent` mediumtext NULL, `dress` mediumtext NULL, `diameter` mediumtext NULL, `frame_plus-piece_pull_select` mediumtext NULL, `details2_select` mediumtext NULL, `details1_select` mediumtext NULL, `cut` mediumtext NULL, `cushioning_select` mediumtext NULL, `cuo_body` mediumtext NULL, `color` mediumtext NULL, `clarity` mediumtext NULL, `chain_width` mediumtext NULL, `chain_type_select` mediumtext NULL, `chain_full-length` mediumtext NULL, `case_w` mediumtext NULL, `case_h` mediumtext NULL, `carat_some_grams` mediumtext NULL, `detachable_way_select` mediumtext NULL, `by_adding-piece_pull_in_with_frame` mediumtext NULL, `button` mediumtext NULL, `buckle_w` mediumtext NULL, `depth` mediumtext NULL, `buckle_select` mediumtext NULL, `calf_width` mediumtext NULL, `bottoms` mediumtext NULL, `cutting_style_select` mediumtext NULL, `bottom-bis` mediumtext NULL, `detachable_way` mediumtext NULL, `buckle_h` mediumtext NULL, `belt_width` mediumtext NULL, `belt_/_breath_width` mediumtext NULL, `before_length` mediumtext NULL, `average` mediumtext NULL, `attached_to_the_re-size` mediumtext NULL, `bone_this` mediumtext NULL, `aside_stone_size_approximately` mediumtext NULL, `around_the_waist_minimum` mediumtext NULL, `around_the_waist_maximum` mediumtext NULL, `around_the_waist` mediumtext NULL, `around_the_tube` mediumtext NULL, `around_the_thigh` mediumtext NULL, `around_the_hem` mediumtext NULL, `aside_stone` mediumtext NULL, `belt_full-length` mediumtext NULL, `appraisal_judgment_document_select` mediumtext NULL, `adjustment_method_select` mediumtext NULL, `adjuster_select` mediumtext NULL, `actual_size_wide_only` mediumtext NULL, `around_the_head` mediumtext NULL, `between_the_screw` mediumtext NULL, `bottoms_size` mediumtext NULL, `actual_size` mediumtext NULL, `accessories_w` mediumtext NULL, `alteration_select` mediumtext NULL, `actual_size_by_gou` mediumtext NULL, `accessories_d` mediumtext NULL, `accessories_h` mediumtext NULL, `situkan` mediumtext NULL, `asikubi` mediumtext NULL, `taiousaizu` mediumtext NULL, `renzu` mediumtext NULL, `youto` mediumtext NULL, `posuto` mediumtext NULL, `nekkuresu` mediumtext NULL, `santi` mediumtext NULL, `treatment` mediumtext NULL, `koutaku` mediumtext NULL, `outside_pocket_count_4` mediumtext NULL, `outside_pocket_4` mediumtext NULL, `sodebotan` mediumtext NULL, `raina` mediumtext NULL, `fasuna` mediumtext NULL, `kuriapoketto` mediumtext NULL, `size_d_mm1` mediumtext NULL, `size_h_mm1` mediumtext NULL, `size_w_mm1` mediumtext NULL, `batikann` mediumtext NULL, `buroti` mediumtext NULL, `details3_select` mediumtext NULL, `size_w_mm2` mediumtext NULL, `size_h_mm2` mediumtext NULL, `size_d_mm2` mediumtext NULL, `koukokubunnseki` mediumtext NULL, `seizou` mediumtext NULL, `meka` mediumtext NULL, `syouhinnkubunn` mediumtext NULL, `inner_sou_take` mediumtext NULL, PRIMARY KEY (`product_id`))CHARACTER SET utf8;
CREATE TABLE `purchased_result`(`id` int NOT NULL AUTO_INCREMENT, `product_id` int NOT NULL, `market_product_id` int NULL, `voice_sub_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_status` int NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `price_for_site_flag` tinyint NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `ecc_id` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `ichiba_meeting_month` varchar(100) NULL, `ichiba_meeting_name` varchar(100) NULL, `market_product_comment` mediumtext NULL, `ichiba_detail` varchar(255) NULL, `price_for_site_market_product` int NULL, `title_for_site` varchar(255) NULL, `front_hidden_flg` varchar(30) NULL, `price` int NULL, `cost` int NULL, `identification_cost` int NULL, `other_cost` int NULL, `purchase_category` varchar(50) NULL, `DA_WEIGHT` varchar(255) NULL, `DA_PER_CARAT` varchar(255) NULL, `DA_SHAPE` varchar(255) NULL, `DA_INTENSITY` varchar(255) NULL, `DA_OVERTONE` varchar(255) NULL, `DA_COLOR` varchar(255) NULL, `DA_CLARITY` varchar(255) NULL, `DA_CUT` varchar(255) NULL, `DA_POLISH` varchar(255) NULL, `DA_SYMMETRY` varchar(255) NULL, `DA_FLUO` varchar(255) NULL, `DA_COLOR_FLUO` varchar(255) NULL, `DA_WIDE` varchar(255) NULL, `DA_HIGH` varchar(255) NULL, `DA_DEPTH` varchar(255) NULL, `DA_APPRAISER` varchar(255) NULL, `DA_FRAPA` varchar(255) NULL, `DA_RATE` varchar(255) NULL, `DA_no` varchar(255) NULL, `DA_INSI_waname` varchar(255) NULL, `DA_OVTO_waname` varchar(255) NULL, `satei_by` int NULL, `Eoc_takuhai_id` int NULL, `Eoc_unfinished_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `quotation_list_for_chanel`(`id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) NULL, `model_num` varchar(255) NULL, `fabric` varchar(255) NULL, `fabric_num` varchar(255) NULL, `color` varchar(255) NULL, `color_num` varchar(255) NULL, `ref_list_price` int NULL, `size` varchar(255) NULL, `ref_purchace_price` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `rakuten_shouhin`(`product_id` int NOT NULL DEFAULT 0, `yahoo_sinaban` varchar(100) NULL, `itemUrl` varchar(100) NULL, `itemName` varchar(200) NULL, `itemPrice` varchar(100) NULL, `startDate` date NULL, `imageUrl` varchar(100) NULL, `category_id` int NULL, `sub_category_id1` int NULL, `product_num` int NULL, `yahoo_junle` varchar(255) NULL, `pctxtDate` date NULL, `inventoryCount` int NULL, PRIMARY KEY (`product_id`))CHARACTER SET utf8;
CREATE TABLE `rs_PMT_EV001_for_search`(`APP_UID` int NOT NULL, `APP_NUMBER` varchar(255) NULL, `APP_STATUS` varchar(255) NULL, `ROW` varchar(255) NULL, `DA_SEQ` int NULL, `DA_MANAGEMENTNO` varchar(255) NULL, `DA_BUYER` varchar(255) NULL, `DA_RESPONSIBLE` varchar(255) NULL, `DA_THESPECIFICATIONSSETTINGSUN` datetime NULL, `DA_WEIGHT` varchar(255) NULL, `DA_THESPECIFICATIONSLOSSES` int NULL, `DA_PER_CARAT` varchar(255) NULL, `DA_SHAPE` varchar(255) NULL, `DA_SELFGRES` varchar(255) NULL, `DA_ORIGINALGRADEMLIKENED` varchar(255) NULL, `DA_SUGARCANE` varchar(255) NULL, `DA_PERCENT` varchar(255) NULL, `DA_STATUS` varchar(255) NULL, `DA_COLOR` varchar(255) NULL, `COLOR_sort` varchar(255) NULL, `DA_CLARITY` varchar(255) NULL, `CLARITY_sort` varchar(255) NULL, `DA_CUT` varchar(255) NULL, `CUT_sort` varchar(255) NULL, `DA_FLUO` varchar(255) NULL, `DA_WIDE` varchar(255) NULL, `DA_HIGH` varchar(255) NULL, `DA_DEPTH` varchar(255) NULL, `DA_APPRAISER` varchar(255) NULL, `DA_RATE` varchar(255) NULL, `DA_UNITPRICE` varchar(255) NULL, `DA_YOURNAME` varchar(255) NULL, `DA_PAYOUTOTHER` int NULL, `DA_RAPA` varchar(255) NULL, `DA_COMMENTSANDTOTAL` varchar(255) NULL, `DA_REGISTEREDPERSON` varchar(255) NULL, `DA_GROSSPROFIT` varchar(255) NULL, `DA_INTEREST_1` varchar(255) NULL, `DA_REGISTRATIONDATE` varchar(255) NULL, `DA_UPDATEDBY` varchar(255) NULL, `DA_UPDATEDDATE` varchar(255) NULL, `DA_COMPLETECHANGEDATE` varchar(255) NULL, `DA_FRAPA` int NULL, `DA_RAPAB` varchar(255) NULL, `DA_UNIT_PRICE_UNPLUG` varchar(255) NULL, `DA_STATUS_2` varchar(255) NULL, `DA_MEMO` varchar(255) NULL, `DA_INTENSITY` varchar(255) NULL, `DA_OVERTONE` varchar(255) NULL, `DA_INTENSITY_FLUO` varchar(255) NULL, `DA_COLOR_FLUO` varchar(255) NULL, `DA_POLISH` varchar(255) NULL, `DA_SYMMETRY` varchar(255) NULL, `DA_no` varchar(255) NULL, `status` int NULL, `kaitoribi` varchar(255) NULL, `kaitoribi_bi` varchar(255) NULL, `floor_weight` varchar(255) NULL, PRIMARY KEY (`APP_UID`))CHARACTER SET utf8;
CREATE TABLE `rs_bvlgari_price_gold_category_id`(`category_id` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_bvlgari_price_line_category_id`(`line` varchar(255) NULL, `category_id` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_cartier_price_category_id`(`category_id` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_cartier_price_gold_category_id`(`category_id` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_cartier_price_line`(`line` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_cartier_price_line_category_id`(`line` varchar(255) NULL, `category_id` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_cartier_price_line_category_id_nodia`(`line` varchar(255) NULL, `category_id` varchar(255) NULL, `mon` varchar(255) NULL, `count` varchar(255) NULL, `ave` varchar(255) NULL, `min` varchar(255) NULL, `max` varchar(255) NULL, `sum` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_chat`(`DATE_FORMAT(end_timestamp,"%Y-%m-%d")` varchar(255) NULL, `COUNT(chat_id)` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_chats`(`DATE_FORMAT(end_timestamp,"%Y-%m-%d")` varchar(255) NULL, `COUNT(chat_id)` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_chats_by_month`(`DATE_FORMAT(end_timestamp,"%Y-%m")` varchar(255) NULL, `COUNT(chat_id)` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_goldcoin`(`id` int NULL, `face_value` varchar(255) NULL, `face_value_number` varchar(255) NULL, `face_value_unit` int NULL, `ounce` varchar(255) NULL, `diameter_mm` varchar(255) NULL, `total_weight` varchar(255) NULL, `total_weight_for_calc` varchar(255) NULL, `manufacturing_number` varchar(255) NULL, `selling_price` varchar(255) NULL, `selling_price_unit` varchar(255) NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `goldcoin_id` int NULL, `region_id` int NULL, `start_year` varchar(255) NULL, `year_remark` varchar(255) NULL, `end_year` varchar(255) NULL, `material_URL_1` mediumtext NULL, `material_URL_2` mediumtext NULL, `surface_image_URL` mediumtext NULL, `back_side_image_URL` mediumtext NULL, `use_back_img` tinyint NULL, `popular_coin_price_sort` int NULL, `search_result_sort` int NULL, `display_list_sort` int NULL, `coefficient` varchar(255) NULL, `related_gold_coin_id` int NULL, `country_name` int NULL, `coin_name` mediumtext NULL, `material` int NULL, `quality` varchar(255) NULL, `reference_quality` int NULL, `surface` mediumtext NULL, `back_side` mediumtext NULL, `remarks` mediumtext NULL, `related_word` mediumtext NULL, `display_country_name` mediumtext NULL)CHARACTER SET utf8;
CREATE TABLE `rs_kagoya_instead_img`(`product_id` int NULL, `imgpass` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `rs_kagoya_result`(`product_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` mediumtext NULL, `yahoo_sankou_uwadai` mediumtext NULL, `yahoo_kataban` mediumtext NULL, `yahoo_condition2` mediumtext NULL, `yahoo_fuzokuhin` mediumtext NULL, `yahoo_sinaban` mediumtext NULL, `yahoo_sex` mediumtext NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` mediumtext NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` mediumtext NULL, `gold_property` mediumtext NULL, `ichiba_title` mediumtext NULL, `accessories` mediumtext NULL, `priority` mediumtext NULL, `A_storage` mediumtext NULL, `line` mediumtext NULL, `item_name` mediumtext NULL, `handle` mediumtext NULL, `serial_number` mediumtext NULL, `stamp` mediumtext NULL, `motif` mediumtext NULL, `Setting` mediumtext NULL, `processing` mediumtext NULL, `Sleeve_Length` mediumtext NULL, `length` mediumtext NULL, `Ring_size` mediumtext NULL, `price_for_site` mediumtext NULL, `raku_title` mediumtext NULL, `saisun_start` datetime NULL, `season` mediumtext NULL, `title` mediumtext NULL, `yahoo_title` mediumtext NULL, `yahoo_color` mediumtext NULL, `Gram` mediumtext NULL, `unit` mediumtext NULL, `Parent_stone` mediumtext NULL, `producing_area` mediumtext NULL, `hahakai` mediumtext NULL, `effect` mediumtext NULL, `shape` mediumtext NULL, `cutting_style` mediumtext NULL, `Aside_stone` mediumtext NULL, `number_of_stones` mediumtext NULL, `yahoo_size` mediumtext NULL, `ecc_address1` mediumtext NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` mediumtext NULL, `PMT_EV001_DA_WEIGHT` mediumtext NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` mediumtext NULL, `PMT_EV001_DA_INTENSITY` mediumtext NULL, `PMT_EV001_DA_OVERTONE` mediumtext NULL, `PMT_EV001_DA_COLOR` mediumtext NULL, `PMT_EV001_DA_CLARITY` mediumtext NULL, `PMT_EV001_DA_CUT` mediumtext NULL, `PMT_EV001_DA_POLISH` mediumtext NULL, `PMT_EV001_DA_SYMMETRY` mediumtext NULL, `PMT_EV001_DA_FLUO` mediumtext NULL, `PMT_EV001_DA_COLOR_FLUO` mediumtext NULL, `PMT_EV001_DA_WIDE` mediumtext NULL, `PMT_EV001_DA_HIGH` mediumtext NULL, `PMT_EV001_DA_DEPTH` mediumtext NULL, `PMT_EV001_DA_APPRAISER` mediumtext NULL, `PMT_EV001_DA_FRAPA` mediumtext NULL, `PMT_EV001_DA_RATE` mediumtext NULL, `PMT_EV001_DA_PAYOUTOTHER` mediumtext NULL, `PMT_EV001_DA_MANAGEMENTNO` mediumtext NULL, `PMT_EV001_DA_STATUS` mediumtext NULL, `PMT_EV001_DA_SEQ` mediumtext NULL, `PMT_EV001_INSI_waname` mediumtext NULL, `PMT_EV001_OVTO_waname` mediumtext NULL, `PMT_EV001_status` int NULL, `designer` mediumtext NULL, `collar_neck_line` mediumtext NULL, `breast` mediumtext NULL, `silhouette` mediumtext NULL, `sleeve` mediumtext NULL, `toe` mediumtext NULL, `heel` mediumtext NULL, `shape_supplement` mediumtext NULL, `side_gem` mediumtext NULL, `product_style` mediumtext NULL, `cloth` mediumtext NULL, `amount` mediumtext NULL, `chain_type` mediumtext NULL, `satei_month` datetime NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `ecc_id` int NULL)CHARACTER SET utf8;
CREATE TABLE `rs_kagoya_result_original`(`product_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` mediumtext NULL, `yahoo_sankou_uwadai` mediumtext NULL, `yahoo_kataban` mediumtext NULL, `yahoo_condition2` mediumtext NULL, `yahoo_fuzokuhin` mediumtext NULL, `yahoo_sinaban` mediumtext NULL, `yahoo_sex` mediumtext NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` mediumtext NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` mediumtext NULL, `gold_property` mediumtext NULL, `ichiba_title` mediumtext NULL, `accessories` mediumtext NULL, `priority` mediumtext NULL, `A_storage` mediumtext NULL, `line` mediumtext NULL, `item_name` mediumtext NULL, `handle` mediumtext NULL, `serial_number` mediumtext NULL, `stamp` mediumtext NULL, `motif` mediumtext NULL, `Setting` mediumtext NULL, `processing` mediumtext NULL, `Sleeve_Length` mediumtext NULL, `length` mediumtext NULL, `Ring_size` mediumtext NULL, `price_for_site` mediumtext NULL, `raku_title` mediumtext NULL, `saisun_start` datetime NULL, `season` mediumtext NULL, `title` mediumtext NULL, `yahoo_title` mediumtext NULL, `yahoo_color` mediumtext NULL, `Gram` mediumtext NULL, `unit` mediumtext NULL, `Parent_stone` mediumtext NULL, `producing_area` mediumtext NULL, `hahakai` mediumtext NULL, `effect` mediumtext NULL, `shape` mediumtext NULL, `cutting_style` mediumtext NULL, `Aside_stone` mediumtext NULL, `number_of_stones` mediumtext NULL, `yahoo_size` mediumtext NULL, `ecc_address1` mediumtext NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` mediumtext NULL, `PMT_EV001_DA_WEIGHT` mediumtext NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` mediumtext NULL, `PMT_EV001_DA_INTENSITY` mediumtext NULL, `PMT_EV001_DA_OVERTONE` mediumtext NULL, `PMT_EV001_DA_COLOR` mediumtext NULL, `PMT_EV001_DA_CLARITY` mediumtext NULL, `PMT_EV001_DA_CUT` mediumtext NULL, `PMT_EV001_DA_POLISH` mediumtext NULL, `PMT_EV001_DA_SYMMETRY` mediumtext NULL, `PMT_EV001_DA_FLUO` mediumtext NULL, `PMT_EV001_DA_COLOR_FLUO` mediumtext NULL, `PMT_EV001_DA_WIDE` mediumtext NULL, `PMT_EV001_DA_HIGH` mediumtext NULL, `PMT_EV001_DA_DEPTH` mediumtext NULL, `PMT_EV001_DA_APPRAISER` mediumtext NULL, `PMT_EV001_DA_FRAPA` mediumtext NULL, `PMT_EV001_DA_RATE` mediumtext NULL, `PMT_EV001_DA_PAYOUTOTHER` mediumtext NULL, `PMT_EV001_DA_MANAGEMENTNO` mediumtext NULL, `PMT_EV001_DA_STATUS` mediumtext NULL, `PMT_EV001_DA_SEQ` mediumtext NULL, `PMT_EV001_INSI_waname` mediumtext NULL, `PMT_EV001_OVTO_waname` mediumtext NULL, `PMT_EV001_status` int NULL, `designer` mediumtext NULL, `collar_neck_line` mediumtext NULL, `breast` mediumtext NULL, `silhouette` mediumtext NULL, `sleeve` mediumtext NULL, `toe` mediumtext NULL, `heel` mediumtext NULL, `shape_supplement` mediumtext NULL, `side_gem` mediumtext NULL, `product_style` mediumtext NULL, `cloth` mediumtext NULL, `amount` mediumtext NULL, `chain_type` mediumtext NULL, `satei_month` datetime NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL)CHARACTER SET utf8;
CREATE TABLE `rs_kagoya_result_out`(`product_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` mediumtext NULL, `yahoo_sankou_uwadai` mediumtext NULL, `yahoo_kataban` mediumtext NULL, `yahoo_condition2` mediumtext NULL, `yahoo_fuzokuhin` mediumtext NULL, `yahoo_sinaban` mediumtext NULL, `yahoo_sex` mediumtext NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` mediumtext NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` mediumtext NULL, `gold_property` mediumtext NULL, `ichiba_title` mediumtext NULL, `accessories` mediumtext NULL, `priority` mediumtext NULL, `A_storage` mediumtext NULL, `line` mediumtext NULL, `item_name` mediumtext NULL, `handle` mediumtext NULL, `serial_number` mediumtext NULL, `stamp` mediumtext NULL, `motif` mediumtext NULL, `Setting` mediumtext NULL, `processing` mediumtext NULL, `Sleeve_Length` mediumtext NULL, `length` mediumtext NULL, `Ring_size` mediumtext NULL, `price_for_site` mediumtext NULL, `raku_title` mediumtext NULL, `saisun_start` datetime NULL, `season` mediumtext NULL, `title` mediumtext NULL, `yahoo_title` mediumtext NULL, `yahoo_color` mediumtext NULL, `Gram` mediumtext NULL, `unit` mediumtext NULL, `Parent_stone` mediumtext NULL, `producing_area` mediumtext NULL, `hahakai` mediumtext NULL, `effect` mediumtext NULL, `shape` mediumtext NULL, `cutting_style` mediumtext NULL, `Aside_stone` mediumtext NULL, `number_of_stones` mediumtext NULL, `yahoo_size` mediumtext NULL, `ecc_address1` mediumtext NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` mediumtext NULL, `PMT_EV001_DA_WEIGHT` mediumtext NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` mediumtext NULL, `PMT_EV001_DA_INTENSITY` mediumtext NULL, `PMT_EV001_DA_OVERTONE` mediumtext NULL, `PMT_EV001_DA_COLOR` mediumtext NULL, `PMT_EV001_DA_CLARITY` mediumtext NULL, `PMT_EV001_DA_CUT` mediumtext NULL, `PMT_EV001_DA_POLISH` mediumtext NULL, `PMT_EV001_DA_SYMMETRY` mediumtext NULL, `PMT_EV001_DA_FLUO` mediumtext NULL, `PMT_EV001_DA_COLOR_FLUO` mediumtext NULL, `PMT_EV001_DA_WIDE` mediumtext NULL, `PMT_EV001_DA_HIGH` mediumtext NULL, `PMT_EV001_DA_DEPTH` mediumtext NULL, `PMT_EV001_DA_APPRAISER` mediumtext NULL, `PMT_EV001_DA_FRAPA` mediumtext NULL, `PMT_EV001_DA_RATE` mediumtext NULL, `PMT_EV001_DA_PAYOUTOTHER` mediumtext NULL, `PMT_EV001_DA_MANAGEMENTNO` mediumtext NULL, `PMT_EV001_DA_STATUS` mediumtext NULL, `PMT_EV001_DA_SEQ` mediumtext NULL, `PMT_EV001_INSI_waname` mediumtext NULL, `PMT_EV001_OVTO_waname` mediumtext NULL, `PMT_EV001_status` int NULL, `designer` mediumtext NULL, `collar_neck_line` mediumtext NULL, `breast` mediumtext NULL, `silhouette` mediumtext NULL, `sleeve` mediumtext NULL, `toe` mediumtext NULL, `heel` mediumtext NULL, `shape_supplement` mediumtext NULL, `side_gem` mediumtext NULL, `product_style` mediumtext NULL, `cloth` mediumtext NULL, `amount` mediumtext NULL, `chain_type` mediumtext NULL, `satei_month` datetime NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL)CHARACTER SET utf8;
CREATE TABLE `rs_market_product_performance_original`(`id` int NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `ichiba_melee_gai` int NULL, `Apparaiser` int NULL, `zeinuki` int NULL, `nyuukin_price` int NULL, `ichiba_lot_pieces` int NULL, `avg` varchar(255) NULL, `comment` mediumtext NULL, `syuppinsya` varchar(255) NULL, `DA_YOURNAME` varchar(255) NULL, `ichiba_img` mediumtext NULL, `charagai` int NULL, `price_without_tax` int NULL, `price` int NULL, `sagaku` int NULL, `arari` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `resize_flg` tinyint NULL, `title_for_site` mediumtext NULL, `relation_id` int NULL, `voice_sub_id` int NULL, `is_ok` tinyint NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `display_buy_data` date NULL, `satei_month` date NULL, `voice_date` date NULL, `product_num` mediumtext NULL)CHARACTER SET utf8;
CREATE TABLE `rs_market_product_result`(`id` int NOT NULL, `product_id` int NULL, `voice_sub_id` int NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `Apparaiser` int NULL, `comment` mediumtext NULL, `ichiba_img` mediumtext NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `title_for_site` mediumtext NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `satei_month` date NULL, `product_num` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `rs_mst_country_name_join_coin`(`id` int NULL, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `region_id` int NULL)CHARACTER SET utf8;
CREATE TABLE `rs_post_for_search`(`id` int NULL, `title` mediumtext NULL, `text` mediumtext NULL, `open_flag` tinyint NULL, `open_date` datetime NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `url` mediumtext NULL, `category` int NULL, `sub_category` int NULL, `category_url` mediumtext NULL, `display_url` mediumtext NULL, `item_id` int NULL, `forward_match` int NULL)CHARACTER SET utf8;
CREATE TABLE `rs_purchased_result`(`id` int NOT NULL, `product_id` int NULL, `market_product_id` int NULL, `ecc_id` int NULL, `voice_sub_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `colorstone_id` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` mediumtext NULL, `yahoo_sankou_uwadai` mediumtext NULL, `yahoo_kataban` mediumtext NULL, `yahoo_condition2` mediumtext NULL, `yahoo_fuzokuhin` mediumtext NULL, `yahoo_sinaban` mediumtext NULL, `yahoo_sex` mediumtext NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` mediumtext NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` mediumtext NULL, `gold_property` mediumtext NULL, `ichiba_title` mediumtext NULL, `accessories` mediumtext NULL, `priority` mediumtext NULL, `A_storage` mediumtext NULL, `line` mediumtext NULL, `item_name` mediumtext NULL, `handle` mediumtext NULL, `serial_number` mediumtext NULL, `stamp` mediumtext NULL, `motif` mediumtext NULL, `Setting` mediumtext NULL, `processing` mediumtext NULL, `Sleeve_Length` mediumtext NULL, `length` mediumtext NULL, `Ring_size` mediumtext NULL, `price_for_site` mediumtext NULL, `raku_title` mediumtext NULL, `saisun_start` datetime NULL, `season` mediumtext NULL, `title` mediumtext NULL, `yahoo_title` mediumtext NULL, `yahoo_color` mediumtext NULL, `Gram` mediumtext NULL, `unit` mediumtext NULL, `Parent_stone` mediumtext NULL, `producing_area` mediumtext NULL, `hahakai` mediumtext NULL, `effect` mediumtext NULL, `shape` mediumtext NULL, `cutting_style` mediumtext NULL, `Aside_stone` mediumtext NULL, `number_of_stones` mediumtext NULL, `yahoo_size` mediumtext NULL, `ecc_address1` mediumtext NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` mediumtext NULL, `PMT_EV001_DA_WEIGHT` mediumtext NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` mediumtext NULL, `PMT_EV001_DA_INTENSITY` mediumtext NULL, `PMT_EV001_DA_OVERTONE` mediumtext NULL, `PMT_EV001_DA_COLOR` mediumtext NULL, `PMT_EV001_DA_CLARITY` mediumtext NULL, `PMT_EV001_DA_CUT` mediumtext NULL, `PMT_EV001_DA_POLISH` mediumtext NULL, `PMT_EV001_DA_SYMMETRY` mediumtext NULL, `PMT_EV001_DA_FLUO` mediumtext NULL, `PMT_EV001_DA_COLOR_FLUO` mediumtext NULL, `PMT_EV001_DA_WIDE` mediumtext NULL, `PMT_EV001_DA_HIGH` mediumtext NULL, `PMT_EV001_DA_DEPTH` mediumtext NULL, `PMT_EV001_DA_APPRAISER` mediumtext NULL, `PMT_EV001_DA_FRAPA` mediumtext NULL, `PMT_EV001_DA_RATE` mediumtext NULL, `PMT_EV001_DA_PAYOUTOTHER` mediumtext NULL, `PMT_EV001_DA_MANAGEMENTNO` mediumtext NULL, `PMT_EV001_DA_STATUS` mediumtext NULL, `PMT_EV001_DA_SEQ` mediumtext NULL, `PMT_EV001_INSI_waname` mediumtext NULL, `PMT_EV001_OVTO_waname` mediumtext NULL, `PMT_EV001_status` int NULL, `market_product_color_quality` int NULL, `market_product_defect_quality` int NULL, `market_product_ichiba_detail` mediumtext NULL, `market_product_comment` mediumtext NULL, `market_product_price_for_site` int NULL, `market_product_title_for_site` varchar(255) NULL, `designer` mediumtext NULL, `collar_neck_line` mediumtext NULL, `breast` mediumtext NULL, `silhouette` mediumtext NULL, `sleeve` mediumtext NULL, `toe` mediumtext NULL, `heel` mediumtext NULL, `shape_supplement` mediumtext NULL, `side_gem` mediumtext NULL, `product_style` mediumtext NULL, `cloth` mediumtext NULL, `amount` mediumtext NULL, `chain_type` mediumtext NULL, `satei_month` datetime NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `front_hidden_flg` varchar(30) NULL, `price` int NULL, `cost` int NULL, `identification_cost` int NULL, `other_cost` int NULL, `purchase_category` varchar(50) NULL, `DA_WEIGHT` varchar(255) NULL, `DA_PER_CARAT` varchar(255) NULL, `DA_SHAPE` varchar(255) NULL, `DA_INTENSITY` varchar(255) NULL, `DA_OVERTONE` varchar(255) NULL, `DA_COLOR` varchar(255) NULL, `DA_CLARITY` varchar(255) NULL, `DA_CUT` varchar(255) NULL, `DA_POLISH` varchar(255) NULL, `DA_SYMMETRY` varchar(255) NULL, `DA_FLUO` varchar(255) NULL, `DA_COLOR_FLUO` varchar(255) NULL, `DA_WIDE` varchar(255) NULL, `DA_HIGH` varchar(255) NULL, `DA_DEPTH` varchar(255) NULL, `DA_APPRAISER` varchar(255) NULL, `DA_FRAPA` varchar(255) NULL, `DA_RATE` varchar(255) NULL, `DA_no` varchar(255) NULL, `DA_INSI_waname` varchar(255) NULL, `DA_OVTO_waname` varchar(255) NULL, `satei_by` int NULL, `Eoc_takuhai_id` int NULL, `Eoc_unfinished_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `rs_purchased_result_storage_paths`(`id` int NOT NULL AUTO_INCREMENT, `product_id` int NULL, `image_number` int NULL, `storage_path` mediumtext NULL, `created_at` datetime NULL, `updated_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `sagawa_api_result_codes`(`id` int NOT NULL AUTO_INCREMENT, `sagawa_api_result_id` bigint(20) NULL, `result_code` varchar(255) NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `sagawa_api_results`(`sagawa_api_result_id` int NOT NULL AUTO_INCREMENT, `request_xml` mediumtext NULL, `response_xml` mediumtext NULL, `send_at` datetime NULL, `resultCode` varchar(255) NULL, `userManageNumber` varchar(255) NULL, `depotCode` varchar(255) NULL, `depotName` varchar(255) NULL, `depotTel` varchar(255) NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`sagawa_api_result_id`))CHARACTER SET utf8;
CREATE TABLE `search_category`(`id` int NOT NULL AUTO_INCREMENT, `created_at` datetime NULL, `updated_at` datetime NULL, `title` varchar(255) NULL, `count` int NULL, `column_name` varchar(255) NULL, `value` varchar(255) NULL, `master_table` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `sessions`(`id` varchar(255) NOT NULL, `user_id` int NULL, `ip_address` varchar(45) NULL, `user_agent` mediumtext NULL, `payload` mediumtext NOT NULL, `last_activity` int NOT NULL, PRIMARY KEY (`id`(50)))CHARACTER SET utf8;
CREATE TABLE `sheets_api`(`id` int NOT NULL AUTO_INCREMENT, `sheet_id` varchar(200) NULL, `sheet_name` varchar(50) NULL, `column` varchar(50) NULL, `row` int NULL, `data` varchar(255) NULL, `date` date NULL, `updated_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `shop_front_details`(`shop_front_id` int NOT NULL AUTO_INCREMENT, `send_id` varchar(45) NULL, `ecc_id` int NULL, `is_own` tinyint NULL, `iddocment_category` varchar(50) NULL, `is_confirm_pp` tinyint NULL, `is_first` tinyint NULL, `before_two_years` tinyint NULL, `lastname` varchar(255) NULL, `firstname` varchar(255) NULL, `furigana_lastname` varchar(255) NULL, `furigana_firstname` varchar(255) NULL, `gender` varchar(10) NULL, `birthday` date NULL, `prefecture` varchar(10) NULL, `city` varchar(255) NULL, `town` varchar(255) NULL, `building_types` varchar(255) NULL, `dwelling_types` varchar(255) NULL, `tel` varchar(50) NULL, `email` varchar(255) NULL, `job_category` varchar(255) NULL, `job_category_freetext` varchar(255) NULL, `campaign` varchar(255) NULL, `taransaction_result` varchar(50) NULL, `trading` varchar(50) NULL, `is_confirm_rules` tinyint NULL, `signature_image_path` varchar(255) NULL, `iddocment_image_path` varchar(2000) NULL, `products_image_path` varchar(2000) NULL, `send_at` datetime NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `is_img_confirmed_products` tinyint NULL, `is_img_confirmed_iddocument` tinyint NULL, `has_changed_profile` tinyint NULL, `yubinnumber` varchar(50) NULL, `is_required_privacy_info` tinyint NULL, `deal_type` varchar(255) NULL, `purpose` varchar(255) NULL, `below_address` varchar(255) NULL, `privacy_info_validation` varchar(255) NULL, `image_confirmed_at` datetime NULL DEFAULT '0000-00-00 00:00:00', `is_exists_mypage_id` tinyint NULL DEFAULT 0, `customer_id` bigint(20) NULL, `is_not_owner_text` varchar(500) NULL, `token` varchar(36) NULL, `token_limit` datetime NULL, `mail_check_type` int NULL, PRIMARY KEY (`shop_front_id`))CHARACTER SET utf8;
CREATE TABLE `shop_front_download_tokens`(`id` int NOT NULL AUTO_INCREMENT, `ecc_id` int NULL, `token` varchar(50) NULL, `limit_at` datetime NULL, `created_at` datetime NULL, `updated_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `shop_front_seiren_details`(`shop_front_seiren_id` int NOT NULL AUTO_INCREMENT, `ecc_id` int NULL, `customer_id` bigint(20) NULL, `google_drive_id` varchar(1000) NULL, `updated_at` datetime NULL, `created_at` datetime NULL, PRIMARY KEY (`shop_front_seiren_id`))CHARACTER SET utf8;
CREATE TABLE `shouhin_for_pricelist`(`product_id` int NOT NULL DEFAULT 0, `category_id` int NULL, `product_num` int NULL, `satei_hi` datetime NULL, `gold_property` varchar(200) NULL, `line` varchar(255) NULL, `item_name` varchar(255) NULL, `saisun_start` datetime NULL, `price` int NULL, `Parent_stone` varchar(20) NULL, `sub_category_id1` int NULL, PRIMARY KEY (`product_id`))CHARACTER SET utf8;
CREATE TABLE `sitemaps`(`id` int NOT NULL AUTO_INCREMENT, `domain` varchar(255) NULL, `category_id` int NULL, `post_id` int NULL, `page_title` varchar(255) NULL, `url` varchar(255) NULL, `sort` int NULL, `page_created_at` datetime NULL, `page_updated_at` datetime NULL, `created_at` datetime NULL, `created_by` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `is_not_delete` tinyint NULL DEFAULT 0, `wp_categories` varchar(255) NULL, `all_site_check` varchar(255) NULL, `is_hidden` tinyint NULL DEFAULT 0, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `stackdriver_alert_log`(`id` int NOT NULL AUTO_INCREMENT, `date` datetime NULL, `update_at` datetime NULL, `value` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `store_categories`(`category_id` int NOT NULL AUTO_INCREMENT, `category_name` varchar(50) NOT NULL, `category_initial` varchar(2) NULL, `sort` int NULL, `store_editorial_products` varchar(255) NULL, `category_is_active` varchar(255) NULL, `condition_tmp_id` int NULL, `saisun_tmpl` mediumtext NULL, `created_at` datetime NULL, `created_by` varchar(50) NULL, `updated_at` datetime NULL, `updated_by` varchar(50) NULL, `output_template` mediumtext NULL, `jewelry_flag` tinyint NULL, `sales_category` int NULL, `is_purchase_D` tinyint NULL, `is_purchase_K` tinyint NULL, `is_purchase_J` tinyint NULL, `is_purchase_B` tinyint NULL, `is_purchase_H` tinyint NULL, `is_purchase_W` tinyint NULL, PRIMARY KEY (`category_id`))CHARACTER SET utf8;
CREATE TABLE `store_sub_categories`(`id` int NOT NULL AUTO_INCREMENT, `category_id` int NULL, `name` varchar(32) NULL, `template_id` int NULL, `initial_name` varchar(32) NULL, `view1` int NULL, `view2` int NULL, `view3` int NULL, `size1` int NULL, `size2` int NULL, `size3` int NULL, `size4` int NULL, `size5` int NULL, `size6` mediumtext NULL, `sort` int NULL DEFAULT 100, `brawseid` varchar(100) NULL, `brandnode` varchar(100) NULL, `brandidwomen` varchar(100) NULL, `condition_id` int NULL, `condition_tmp` int NULL, `rakuten_koumoku` mediumtext NULL, `saisun_priority_check` int NULL, `condition_details` mediumtext NULL, `updated_at` datetime NULL, `updated_by` varchar(50) NULL, `created_at` datetime NULL, `created_by` varchar(50) NULL, `output_template` mediumtext NULL, `saisun_model_id` int NULL, `related_words` mediumtext NULL, `hansokuhi_flag` tinyint NULL, `category_class` int NULL, `sales_category` int NULL, `colorstone_id` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `toiawase`(`id` int NOT NULL AUTO_INCREMENT, `created_at` datetime NULL, `updated_at` datetime NULL, `mail` varchar(70) NULL, `exsample` varchar(45) NULL, `text` mediumtext NULL, `ip` varchar(65) NULL, `cv_site` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `toiawase_files`(`id` int NOT NULL AUTO_INCREMENT, `created_at` datetime NULL, `updated_at` datetime NULL, `name` varchar(60) NULL, `toiawase_id` int NULL, `path` varchar(100) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `ubuy_audit`(`id` int NOT NULL AUTO_INCREMENT, `datetime` datetime NOT NULL, `ip` varchar(40) NOT NULL, `user` varchar(300) NULL, `table` varchar(300) NULL, `action` varchar(250) NOT NULL, `description` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `ubuy_uggroups`(`GroupID` int NOT NULL AUTO_INCREMENT, `Label` varchar(300) NULL, PRIMARY KEY (`GroupID`))CHARACTER SET utf8;
CREATE TABLE `ubuy_ugmembers`(`UserName` varchar(300) NOT NULL, `GroupID` int NOT NULL, PRIMARY KEY (`UserName`(50),`GroupID`))CHARACTER SET utf8;
CREATE TABLE `ubuy_ugrights`(`TableName` varchar(300) NOT NULL, `GroupID` int NOT NULL, `AccessMask` varchar(10) NULL, PRIMARY KEY (`TableName`(50),`GroupID`))CHARACTER SET utf8;
CREATE TABLE `user_search_data`(`id` int NOT NULL AUTO_INCREMENT, `category` varchar(100) NULL, `value` varchar(255) NULL, `created_at` datetime NULL, `updated_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `users`(`ID` int NOT NULL AUTO_INCREMENT, `username` varchar(255) NULL, `password` varchar(255) NULL, `email` varchar(255) NULL, `fullname` varchar(255) NULL, `groupid` varchar(255) NULL, `active` int NULL, `user_id` int NULL, `income_id` int NULL, PRIMARY KEY (`ID`))CHARACTER SET utf8;
CREATE TABLE `video_staffs`(`id` int NOT NULL AUTO_INCREMENT, `video_id` bigint(20) NULL, `sfaff_id` int NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `videos`(`video_id` int NOT NULL AUTO_INCREMENT, `title` mediumtext NULL, `description` mediumtext NULL, `YouTube_url` mediumtext NULL, `thumbnail_img_url` mediumtext NULL, `open_at` datetime NULL, `is_open` tinyint NULL, `updated_by` int NULL, `updated_at` datetime NULL, `created_by` int NULL, `created_at` datetime NULL, PRIMARY KEY (`video_id`))CHARACTER SET utf8;
CREATE TABLE `voice_mst`(`id` int NOT NULL, `voice_image` mediumtext NULL, `date` varchar(255) NULL, `zip_name` varchar(255) NULL, `goods_name` varchar(255) NULL, `cal_price` varchar(255) NULL, `brand` varchar(255) NULL, `hinmoku` varchar(255) NULL, `page_category` varchar(255) NULL, `page_num` varchar(32) NULL, `url` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `voice_sub`(`id` int NOT NULL AUTO_INCREMENT, `voice_id` int NULL, `subject` mediumtext NULL, `link` varchar(255) NULL, `date` varchar(255) NULL, `zip_name` varchar(255) NULL, `goods_name` varchar(255) NULL, `cal_price` varchar(255) NULL, `goods_category` varchar(255) NULL, `brand` varchar(255) NULL, `brand_category` varchar(255) NULL, `hinmoku` varchar(255) NULL, `page_category` varchar(255) NULL, `page_num` varchar(32) NULL, `page_master` varchar(32) NULL, `page_regist` int NULL, `detail` mediumtext NULL, `seq` varchar(255) NULL, `preview_dia` int NULL, `preview_kin` int NULL, `preview_brand` int NULL, `preview_dia_tegami` int NULL, `preveiw_kin_tegami` int NULL, `preview_kin_brand` int NULL, `dia_jisseki_id` mediumtext NULL, `did_grade` mediumtext NULL, `dia_kanteisho` mediumtext NULL, `dia_okyakusama_shousai` mediumtext NULL, `dia_otorihiki_keiai` mediumtext NULL, `dia_souhyou` mediumtext NULL, `category_1` int NULL, `category_2` varchar(11) NULL, `category_21` int NULL, `category_22` int NULL, `category_31` int NULL, `category_32` int NULL, `img_pass` mediumtext NULL, `href_pass` mediumtext NULL, `file_size` int NULL, `updated_at` datetime NULL, `voice_date` datetime NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `webreport_admin`(`id` int NOT NULL AUTO_INCREMENT, `tablename` varchar(300) NULL, `db_type` varchar(10) NULL, `group_name` varchar(300) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `webreport_sql`(`id` int NOT NULL AUTO_INCREMENT, `sqlname` varchar(100) NULL, `sqlcontent` mediumtext NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `webreport_style`(`report_style_id` int NOT NULL AUTO_INCREMENT, `type` varchar(6) NOT NULL, `field` int NOT NULL, `group` int NOT NULL, `style_str` mediumtext NOT NULL, `uniq` int NULL, `repname` varchar(255) NOT NULL, `styletype` varchar(40) NOT NULL, PRIMARY KEY (`report_style_id`))CHARACTER SET utf8;
CREATE TABLE `webreports`(`rpt_id` int NOT NULL AUTO_INCREMENT, `rpt_name` varchar(100) NOT NULL, `rpt_title` varchar(200) NULL, `rpt_cdate` datetime NOT NULL, `rpt_mdate` datetime NULL, `rpt_content` mediumtext NOT NULL, `rpt_owner` varchar(100) NOT NULL, `rpt_status` varchar(10) NOT NULL DEFAULT 'public', `rpt_type` varchar(10) NOT NULL, PRIMARY KEY (`rpt_id`))CHARACTER SET utf8;
CREATE TABLE `zendesk__data`(`chat_id` int NOT NULL AUTO_INCREMENT, `comment` mediumtext NULL, `triggered_response` varchar(255) NULL, `rating` varchar(255) NULL, `duration` int NULL, `agent_names` mediumtext NULL, `department_name` varchar(255) NULL, `id` varchar(255) NULL, `end_timestamp` datetime NULL, `referrer_search_terms` varchar(255) NULL, `referrer_search_engine` varchar(100) NULL, `missed` varchar(255) NULL, `agent_ids` mediumtext NULL, `type` varchar(255) NULL, `department_id` int NULL, `triggered` varchar(50) NULL, `timestamp` datetime NULL, `response_time_max` varchar(255) NULL, `response_time_avg` varchar(255) NULL, `response_time_first` varchar(255) NULL, `count_visitor` int NULL, `count_agent` int NULL, `count_total` int NULL, `zendesk_ticket_id` varchar(255) NULL, `started_by` varchar(100) NULL, `unread` varchar(100) NULL, `visitor` mediumtext NULL, `session` mediumtext NULL, `tags` mediumtext NULL, `conversions` mediumtext NULL, `updated_at` datetime NULL, `open_flag` tinyint NULL DEFAULT 0, `title` varchar(255) NULL, `category` varchar(255) NULL, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_by` int NULL, `hash_tag` mediumtext NULL, `check_flag` tinyint NULL, `best_answer` mediumtext NULL, PRIMARY KEY (`chat_id`))CHARACTER SET utf8;
CREATE TABLE `zendesk_agent`(`id` int NOT NULL AUTO_INCREMENT, `agent_names` varchar(255) NULL, `agent_ids` varchar(255) NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `zendesk_chats`(`id` int NOT NULL AUTO_INCREMENT, `chat_id` int NOT NULL, `name` varchar(255) NULL, `timestamp` datetime NULL, `department_name` varchar(255) NULL, `type` varchar(255) NULL, `channel` varchar(255) NULL, `department_id` int NULL, `sender_type` varchar(255) NULL, `msg` mediumtext NULL, `options` varchar(255) NULL, `attachment_mime_type` varchar(255) NULL, `attachment_name` varchar(255) NULL, `attachment_url` mediumtext NULL, `attachment_size` int NULL, `attachment_type` varchar(255) NULL, `chat_number` int NULL, `open_flag` tinyint NULL DEFAULT 0, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_by` int NULL, `error_flag` tinyint NULL DEFAULT 0, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `zendesk_chats_copy1`(`id` int NOT NULL AUTO_INCREMENT, `chat_id` int NOT NULL, `name` varchar(255) NULL, `timestamp` datetime NULL, `department_name` varchar(255) NULL, `type` varchar(255) NULL, `channel` varchar(255) NULL, `department_id` int NULL, `sender_type` varchar(255) NULL, `msg` mediumtext NULL, `options` varchar(255) NULL, `attachment_mime_type` varchar(255) NULL, `attachment_name` varchar(255) NULL, `attachment_url` mediumtext NULL, `attachment_size` int NULL, `attachment_type` varchar(255) NULL, `chat_number` int NULL, `open_flag` tinyint NULL DEFAULT 0, `update_at` datetime NULL DEFAULT CURRENT_TIMESTAMP, `update_by` int NULL, `error_flag` tinyint NULL DEFAULT 0, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `zendesk_tag`(`id` int NOT NULL AUTO_INCREMENT, `tag` varchar(255) NULL, `sort` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `zendesk_webpaths`(`id` int NOT NULL AUTO_INCREMENT, `chat_id` int NOT NULL, `timestamp` datetime NULL, `title` mediumtext NULL, `from` varchar(255) NULL, `to` varchar(255) NULL, `path_number` int NULL, PRIMARY KEY (`id`))CHARACTER SET utf8;
CREATE TABLE `vw_PMT_EV001_for_search`(`APP_UID` int NOT NULL DEFAULT 0, `APP_NUMBER` int NOT NULL, `APP_STATUS` varchar(10) NOT NULL, `ROW` int NOT NULL, `DA_SEQ` varchar(32) NULL, `DA_MANAGEMENTNO` varchar(32) NULL, `DA_BUYER` varchar(32) NULL, `DA_RESPONSIBLE` varchar(32) NULL, `DA_THESPECIFICATIONSSETTINGSUN` varchar(32) NULL, `DA_WEIGHT` decimal(11,3) NULL, `DA_THESPECIFICATIONSLOSSES` varchar(32) NULL, `DA_PER_CARAT` varchar(32) NULL, `DA_SHAPE` varchar(32) NULL, `DA_SELFGRES` varchar(32) NULL, `DA_ORIGINALGRADEMLIKENED` varchar(32) NULL, `DA_SUGARCANE` varchar(32) NULL, `DA_PERCENT` varchar(32) NULL, `DA_STATUS` varchar(32) NULL, `DA_COLOR` varchar(32) NULL, `COLOR_sort` bigint(11) NULL, `DA_CLARITY` varchar(32) NULL, `CLARITY_sort` bigint(11) NULL, `DA_CUT` varchar(32) NULL, `CUT_sort` bigint(11) NULL, `DA_FLUO` varchar(32) NULL, `DA_WIDE` varchar(32) NULL, `DA_HIGH` varchar(32) NULL, `DA_DEPTH` varchar(32) NULL, `DA_APPRAISER` varchar(32) NULL, `DA_RATE` varchar(32) NULL, `DA_UNITPRICE` varchar(32) NULL, `DA_YOURNAME` varchar(32) NULL, `DA_PAYOUTOTHER` double NULL, `DA_RAPA` varchar(32) NULL, `DA_COMMENTSANDTOTAL` varchar(32) NULL, `DA_REGISTEREDPERSON` varchar(32) NULL, `DA_GROSSPROFIT` varchar(32) NULL, `DA_INTEREST_1` varchar(32) NULL, `DA_REGISTRATIONDATE` varchar(32) NULL, `DA_UPDATEDBY` varchar(32) NULL, `DA_UPDATEDDATE` varchar(32) NULL, `DA_COMPLETECHANGEDATE` varchar(32) NULL, `DA_FRAPA` varchar(32) NULL, `DA_RAPAB` varchar(50) NULL, `DA_UNIT_PRICE_UNPLUG` varchar(50) NULL, `DA_STATUS_2` varchar(255) NULL, `DA_MEMO` mediumtext NULL, `DA_INTENSITY` varchar(50) NULL, `DA_OVERTONE` varchar(50) NULL, `DA_INTENSITY_FLUO` varchar(50) NULL, `DA_COLOR_FLUO` varchar(50) NULL, `DA_POLISH` varchar(100) NULL, `DA_SYMMETRY` varchar(100) NULL, `DA_no` varchar(100) NULL, `status` int NULL, `kaitoribi` varchar(7) NULL, `kaitoribi_bi` varchar(10) NULL, `floor_weight` decimal(17,4) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_bvlgari_price_gold_category_id`(`category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_bvlgari_price_line_category_id`(`line` varchar(255) NULL, `category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_cartier_price_category_id`(`category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_cartier_price_gold_category_id`(`category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_cartier_price_line`(`line` varchar(255) NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_cartier_price_line_category_id`(`line` varchar(255) NULL, `category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_cartier_price_line_category_id_nodia`(`line` varchar(255) NULL, `category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `min` bigint(13) NULL, `max` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_chat`(`DATE_FORMAT(end_timestamp,"%Y-%m-%d")` varchar(10) NULL, `COUNT(chat_id)` bigint(21) NOT NULL DEFAULT 0)CHARACTER SET utf8;
CREATE TABLE `vw_chats`(`DATE_FORMAT(end_timestamp,"%Y-%m-%d")` varchar(10) NULL, `COUNT(chat_id)` bigint(21) NOT NULL DEFAULT 0)CHARACTER SET utf8;
CREATE TABLE `vw_chats_by_month`(`DATE_FORMAT(end_timestamp,"%Y-%m")` varchar(7) NULL, `COUNT(chat_id)` bigint(21) NOT NULL DEFAULT 0)CHARACTER SET utf8;
CREATE TABLE `vw_goldcoin`(`id` int NOT NULL DEFAULT 0, `face_value` varchar(255) NULL, `face_value_number` decimal(11,2) NULL, `face_value_unit` int NULL, `ounce` varchar(255) NULL, `diameter_mm` varchar(255) NULL, `total_weight` varchar(255) NULL, `total_weight_for_calc` varchar(255) NULL, `manufacturing_number` int NULL, `selling_price` varchar(255) NULL, `selling_price_unit` int NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `goldcoin_id` int NULL, `region_id` int NULL, `start_year` varchar(255) NULL, `year_remark` varchar(255) NULL, `end_year` varchar(255) NULL, `material_URL_1` mediumtext NULL, `material_URL_2` mediumtext NULL, `surface_image_URL` mediumtext NULL, `back_side_image_URL` mediumtext NULL, `use_back_img` tinyint NULL, `popular_coin_price_sort` int NULL, `search_result_sort` int NULL, `display_list_sort` int NULL, `coefficient` decimal(5,4) NULL, `related_gold_coin_id` int NULL DEFAULT 0, `country_name` int NULL, `coin_name` varchar(255) NULL, `material` int NULL, `quality` varchar(255) NULL, `reference_quality` int NULL, `surface` varchar(255) NULL, `back_side` varchar(255) NULL, `remarks` mediumtext NULL, `related_word` mediumtext NULL, `display_country_name` varchar(255) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_kagoya_result`(`product_id` int NOT NULL, `ecc_id` int NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `PMT_EV001_status` int NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `satei_month` varchar(24) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_kagoya_result_bk`(`product_id` int NOT NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `satei_month` varchar(7) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_kagoya_result_bk0622`(`product_id` int NOT NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `PMT_EV001_status` int NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `satei_month` varchar(24) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_kagoya_result_copy0622`(`product_id` int NOT NULL, `ecc_id` int NULL, `category_id` int NULL DEFAULT 999, `sub_category_id1` int NULL DEFAULT 999, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `PMT_EV001_status` int NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `satei_month` varchar(24) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_market_product_performance_original`(`id` int NOT NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `sub_category_id1` int NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `ichiba_melee_gai` int NULL, `Apparaiser` int NULL, `zeinuki` int NULL, `nyuukin_price` int NULL, `ichiba_lot_pieces` int NULL, `avg` varchar(255) NULL, `comment` mediumtext NULL, `syuppinsya` varchar(255) NULL, `DA_YOURNAME` varchar(255) NULL, `ichiba_img` mediumtext NULL, `charagai` int NULL, `price_without_tax` int NULL, `price` int NULL, `sagaku` int NULL, `arari` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `resize_flg` tinyint NULL, `title_for_site` mediumtext NULL, `relation_id` int NULL, `voice_sub_id` int NULL, `is_ok` tinyint NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `satei_month` datetime NULL, `display_buy_data` date NULL, `voice_date` datetime NULL)CHARACTER SET utf8;
CREATE TABLE `vw_market_product_performance_original_copy`(`id` int NOT NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `sub_category_id1` varchar(255) NOT NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `ichiba_melee_gai` int NULL, `Apparaiser` int NULL, `zeinuki` int NULL, `nyuukin_price` int NULL, `ichiba_lot_pieces` int NULL, `avg` varchar(255) NULL, `comment` mediumtext NULL, `syuppinsya` varchar(255) NULL, `DA_YOURNAME` varchar(255) NULL, `ichiba_img` mediumtext NULL, `charagai` int NULL, `price_without_tax` int NULL, `price` int NULL, `sagaku` int NULL, `arari` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `resize_flg` tinyint NULL, `title_for_site` mediumtext NULL, `relation_id` int NULL, `voice_sub_id` int NULL, `is_ok` tinyint NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `satei_month` datetime NULL, `display_buy_data` date NULL, `voice_date` datetime NULL)CHARACTER SET utf8;
CREATE TABLE `vw_market_product_result`(`id` int NOT NULL, `product_id` int NULL, `ichiba_meeting_month` varchar(255) NULL, `ichiba_meeting_name` varchar(255) NULL, `sub_category_id1` int NULL, `colorstone_id` int NULL, `shape` int NULL, `color_quality` int NULL, `defect_quality` int NULL, `category_id` int NULL, `ichiba_detail` mediumtext NULL, `gold_property` varchar(255) NULL, `price_per_gram` int NULL, `Gram` decimal(10,3) NULL, `Parent_stone` varchar(255) NULL, `Aside_stone` varchar(255) NULL, `Apparaiser` int NULL, `comment` mediumtext NULL, `ichiba_img` mediumtext NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `price_for_site` int NULL, `title_for_site` mediumtext NULL, `voice_sub_id` int NULL, `front_hidden_flg` varchar(255) NULL DEFAULT 'False', `product_num` int NULL, `satei_month` datetime NULL)CHARACTER SET utf8;
CREATE TABLE `vw_mst_country_name_join_coin`(`id` int NOT NULL DEFAULT 0, `name` varchar(255) NULL, `english_name` varchar(255) NULL, `sort` int NULL, `update_by` int NULL, `update_at` datetime NULL, `create_by` int NULL, `create_at` datetime NULL, `region_id` int NULL)CHARACTER SET utf8;
CREATE TABLE `vw_mst_result_group_rule`(`id` int NOT NULL DEFAULT 0, `group_id` int NULL, `gold_property` varchar(255) NULL, `category_id` int NULL, `sub_category_id` int NULL, `product_num` int NULL, `updated_at` datetime NULL, `updated_by` int NULL, `created_at` datetime NULL, `created_by` int NULL, `colorstone_id` int NULL)CHARACTER SET utf8;
CREATE TABLE `vw_post_for_search`(`id` int NOT NULL DEFAULT 0, `title` varchar(255) NULL, `text` mediumtext NULL, `open_flag` tinyint NULL, `open_date` datetime NULL, `update_at` datetime NULL, `update_by` int NULL, `create_at` datetime NULL, `create_by` int NULL, `url` mediumtext NULL, `category` varchar(255) NULL, `sub_category` varchar(255) NULL, `category_url` varchar(255) NULL, `display_url` mediumtext NULL, `item_id` int NULL, `forward_match` tinyint NULL)CHARACTER SET utf8;
CREATE TABLE `vw_purchased_result`(`id` int NOT NULL DEFAULT 0, `product_id` int NOT NULL, `market_product_id` int NULL, `ecc_id` int NULL, `voice_sub_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `PMT_EV001_status` int NULL, `market_product_color_quality` int NULL, `market_product_defect_quality` int NULL, `market_product_ichiba_detail` varchar(255) NULL, `market_product_comment` mediumtext NULL, `market_product_price_for_site` int NULL, `market_product_title_for_site` varchar(255) NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `front_hidden_flg` varchar(30) NULL, `price` int NULL, `cost` int NULL, `purchase_category` varchar(50) NULL, `identification_cost` int NULL, `other_cost` int NULL, `DA_WEIGHT` varchar(255) NULL, `DA_PER_CARAT` varchar(255) NULL, `DA_SHAPE` varchar(255) NULL, `DA_INTENSITY` varchar(255) NULL, `DA_OVERTONE` varchar(255) NULL, `DA_COLOR` varchar(255) NULL, `DA_CLARITY` varchar(255) NULL, `DA_CUT` varchar(255) NULL, `DA_POLISH` varchar(255) NULL, `DA_SYMMETRY` varchar(255) NULL, `DA_FLUO` varchar(255) NULL, `DA_COLOR_FLUO` varchar(255) NULL, `DA_WIDE` varchar(255) NULL, `DA_HIGH` varchar(255) NULL, `DA_DEPTH` varchar(255) NULL, `DA_APPRAISER` varchar(255) NULL, `DA_FRAPA` varchar(255) NULL, `DA_RATE` varchar(255) NULL, `DA_no` varchar(255) NULL, `DA_INSI_waname` varchar(255) NULL, `satei_by` int NULL, `Eoc_takuhai_id` int NULL, `Eoc_unfinished_id` int NULL, `DA_OVTO_waname` varchar(255) NULL, `satei_month` varchar(24) NULL, `colorstone_id` int NULL)CHARACTER SET utf8;
CREATE TABLE `vw_purchased_result_bk20220313`(`id` int NOT NULL DEFAULT 0, `product_id` int NOT NULL, `market_product_id` int NULL, `ecc_id` int NULL, `voice_sub_id` int NULL, `category_id` int NULL, `sub_category_id1` int NULL, `status` int NULL, `product_num` int NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` int NULL, `box_id` int NULL, `nyuukin_at` datetime NULL, `nyuukin_price` int NULL, `timesta` datetime NULL, `kanryou_henbi` datetime NULL, `satei_hi` datetime NULL, `sabun_date` int NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` datetime NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `PMT_EV001_APP_UID` int NULL, `PMT_EV001_DA_THESPECIFICATIONSSETTINGSUN` varchar(100) NULL, `PMT_EV001_DA_WEIGHT` varchar(100) NULL, `PMT_EV001_DA_THESPECIFICATIONSLOSSES` varchar(100) NULL, `PMT_EV001_DA_INTENSITY` varchar(100) NULL, `PMT_EV001_DA_OVERTONE` varchar(100) NULL, `PMT_EV001_DA_COLOR` varchar(100) NULL, `PMT_EV001_DA_CLARITY` varchar(100) NULL, `PMT_EV001_DA_CUT` varchar(100) NULL, `PMT_EV001_DA_POLISH` varchar(100) NULL, `PMT_EV001_DA_SYMMETRY` varchar(100) NULL, `PMT_EV001_DA_FLUO` varchar(100) NULL, `PMT_EV001_DA_COLOR_FLUO` varchar(100) NULL, `PMT_EV001_DA_WIDE` varchar(100) NULL, `PMT_EV001_DA_HIGH` varchar(100) NULL, `PMT_EV001_DA_DEPTH` varchar(100) NULL, `PMT_EV001_DA_APPRAISER` varchar(100) NULL, `PMT_EV001_DA_FRAPA` varchar(100) NULL, `PMT_EV001_DA_RATE` varchar(100) NULL, `PMT_EV001_DA_PAYOUTOTHER` varchar(100) NULL, `PMT_EV001_DA_MANAGEMENTNO` varchar(100) NULL, `PMT_EV001_DA_STATUS` varchar(100) NULL, `PMT_EV001_DA_SEQ` varchar(100) NULL, `PMT_EV001_INSI_waname` varchar(255) NULL, `PMT_EV001_OVTO_waname` varchar(255) NULL, `PMT_EV001_status` int NULL, `market_product_color_quality` int NULL, `market_product_defect_quality` int NULL, `market_product_ichiba_detail` varchar(255) NULL, `market_product_comment` mediumtext NULL, `market_product_price_for_site` int NULL, `market_product_title_for_site` varchar(255) NULL, `designer` varchar(255) NULL, `collar_neck_line` varchar(255) NULL, `breast` varchar(150) NULL, `silhouette` varchar(150) NULL, `sleeve` varchar(150) NULL, `toe` varchar(150) NULL, `heel` varchar(150) NULL, `shape_supplement` varchar(150) NULL, `side_gem` varchar(150) NULL, `product_style` varchar(150) NULL, `cloth` varchar(150) NULL, `amount` varchar(150) NULL, `chain_type` varchar(150) NULL, `price_per_gram` decimal(11,0) NULL, `price_per_parent_stone` int NULL, `price_per_aside_stone` int NULL, `front_hidden_flg` varchar(30) NULL, `price` int NULL, `cost` int NULL, `purchase_category` varchar(50) NULL, `identification_cost` int NULL, `other_cost` int NULL, `DA_WEIGHT` varchar(255) NULL, `DA_PER_CARAT` varchar(255) NULL, `DA_SHAPE` varchar(255) NULL, `DA_INTENSITY` varchar(255) NULL, `DA_OVERTONE` varchar(255) NULL, `DA_COLOR` varchar(255) NULL, `DA_CLARITY` varchar(255) NULL, `DA_CUT` varchar(255) NULL, `DA_POLISH` varchar(255) NULL, `DA_SYMMETRY` varchar(255) NULL, `DA_FLUO` varchar(255) NULL, `DA_COLOR_FLUO` varchar(255) NULL, `DA_WIDE` varchar(255) NULL, `DA_HIGH` varchar(255) NULL, `DA_DEPTH` varchar(255) NULL, `DA_APPRAISER` varchar(255) NULL, `DA_FRAPA` varchar(255) NULL, `DA_RATE` varchar(255) NULL, `DA_no` varchar(255) NULL, `DA_INSI_waname` varchar(255) NULL, `DA_OVTO_waname` varchar(255) NULL, `satei_month` varchar(24) NULL, `colorstone_id` int NULL)CHARACTER SET utf8;
CREATE TABLE `vw_purchased_result_replace20221221`(`now()` datetime NOT NULL DEFAULT '0000-00-00 00:00:00')CHARACTER SET utf8;
CREATE TABLE `vw_result_on_dia`(`product_id` varchar(11) NOT NULL, `category_id` varchar(11) NULL, `sub_category_id1` varchar(12) NULL, `status` varchar(11) NULL, `product_num` varchar(12) NULL, `yahoo_junle` varchar(128) NULL, `yahoo_sankou_uwadai` varchar(128) NULL, `yahoo_kataban` varchar(129) NULL, `yahoo_condition2` varchar(50) NULL, `yahoo_fuzokuhin` varchar(255) NULL, `yahoo_sinaban` varchar(11) NULL, `yahoo_sex` varchar(11) NULL, `box_id` varchar(11) NULL, `nyuukin_at` varchar(19) NULL, `nyuukin_price` varchar(12) NULL, `timesta` varchar(19) NULL, `kanryou_henbi` varchar(19) NULL, `satei_hi` varchar(19) NULL, `sabun_date` varchar(11) NULL, `gold_property` varchar(150) NOT NULL, `ichiba_title` varchar(100) NULL, `accessories` varchar(20) NULL, `priority` varchar(4) NULL, `A_storage` varchar(10) NULL, `line` varchar(50) NULL, `item_name` varchar(50) NULL, `handle` varchar(50) NULL, `serial_number` varchar(150) NULL, `stamp` varchar(150) NULL, `motif` varchar(150) NULL, `Setting` varchar(150) NULL, `processing` varchar(150) NULL, `Sleeve_Length` varchar(150) NULL, `length` varchar(150) NULL, `Ring_size` varchar(150) NULL, `price_for_site` varchar(50) NULL, `raku_title` varchar(255) NULL, `saisun_start` varchar(19) NULL, `season` varchar(100) NULL, `title` varchar(255) NULL, `yahoo_title` varchar(255) NULL, `yahoo_color` mediumtext NULL, `Gram` varchar(20) NULL, `unit` varchar(50) NULL, `Parent_stone` varchar(20) NULL, `producing_area` varchar(150) NULL, `hahakai` varchar(150) NULL, `effect` varchar(150) NULL, `shape` varchar(150) NULL, `cutting_style` varchar(150) NULL, `Aside_stone` varchar(20) NULL, `number_of_stones` varchar(150) NULL, `yahoo_size` mediumtext NULL, `ecc_address1` varchar(100) NULL, `satei_month` varchar(7) NULL, `APP_UID` varchar(11) NOT NULL, `APP_NUMBER` varchar(11) NOT NULL, `APP_STATUS` varchar(10) NOT NULL, `ROW` varchar(11) NOT NULL, `DA_SEQ` varchar(32) NULL, `DA_MANAGEMENTNO` varchar(32) NULL, `DA_BUYER` varchar(32) NULL, `DA_RESPONSIBLE` varchar(32) NULL, `DA_THESPECIFICATIONSSETTINGSUN` varchar(32) NULL, `DA_WEIGHT` varchar(13) NULL, `DA_THESPECIFICATIONSLOSSES` varchar(32) NULL, `DA_PER_CARAT` varchar(32) NULL, `DA_SHAPE` varchar(32) NULL, `DA_SELFGRES` varchar(32) NULL, `DA_ORIGINALGRADEMLIKENED` varchar(32) NULL, `DA_SUGARCANE` varchar(32) NULL, `DA_PERCENT` varchar(32) NULL, `DA_STATUS` varchar(32) NULL, `DA_COLOR` varchar(32) NULL, `DA_CLARITY` varchar(32) NULL, `DA_CUT` varchar(32) NULL, `DA_FLUO` varchar(32) NULL, `DA_WIDE` varchar(32) NULL, `DA_HIGH` varchar(32) NULL, `DA_DEPTH` varchar(32) NULL, `DA_APPRAISER` varchar(32) NULL, `DA_RATE` varchar(32) NULL, `DA_UNITPRICE` varchar(32) NULL, `DA_YOURNAME` varchar(32) NULL, `DA_PAYOUTOTHER` varchar(12) NULL, `DA_RAPA` varchar(32) NULL, `DA_COMMENTSANDTOTAL` varchar(32) NULL, `DA_REGISTEREDPERSON` varchar(32) NULL, `DA_GROSSPROFIT` varchar(32) NULL, `DA_INTEREST_1` varchar(32) NULL, `DA_REGISTRATIONDATE` varchar(32) NULL, `DA_UPDATEDBY` varchar(32) NULL, `DA_UPDATEDDATE` varchar(32) NULL, `DA_COMPLETECHANGEDATE` varchar(32) NULL, `DA_FRAPA` varchar(32) NULL, `DA_RAPAB` varchar(50) NULL, `DA_UNIT_PRICE_UNPLUG` varchar(50) NULL, `DA_STATUS_2` varchar(255) NULL, `DA_MEMO` mediumtext NULL, `DA_INTENSITY` varchar(50) NULL, `DA_OVERTONE` varchar(50) NULL, `DA_INTENSITY_FLUO` varchar(50) NULL, `DA_COLOR_FLUO` varchar(50) NULL, `DA_POLISH` varchar(100) NULL, `DA_SYMMETRY` varchar(100) NULL, `DA_no` varchar(100) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_tiffany_price`(`line` varchar(255) NULL, `gold_property` varchar(200) NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_tiffany_price_DBY`(`line` varchar(255) NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_tiffany_price_gold`(`gold_property` varchar(200) NULL, `category_id` int NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_tiffany_price_stone_ring`(`Parent_stone` double NULL, `mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
CREATE TABLE `vw_tiffany_price_stone_ring_03over`(`mon` varchar(7) NULL, `count` bigint(21) NOT NULL DEFAULT 0, `ave` bigint(13) NULL, `sum` decimal(32,0) NULL)CHARACTER SET utf8;
