-- Table structure for table `et_doc_explanation_fees_trainee`
--

CREATE TABLE `et_doc_explanation_fees_trainee` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary_month` int DEFAULT NULL,
  `salary_time` int DEFAULT NULL,
  `salary_month_1st` int DEFAULT NULL,
  `salary_time_1st` int DEFAULT NULL,
  `salary_month_2rd` int DEFAULT NULL,
  `salary_time_2rd` int DEFAULT NULL,
  `other_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `other_trainee_yesno` tinyint(1) DEFAULT NULL,
  `japanese_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `japanese_yearold` int DEFAULT NULL,
  `japanese_experience_year` float DEFAULT NULL,
  `japanese_salary_month` int DEFAULT NULL,
  `japanese_salary_time` int DEFAULT NULL,
  `same_salary_japanese` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary_rule_yesno` tinyint(1) DEFAULT NULL,
  `salary_rule_yes_month_money` int DEFAULT NULL,
  `salary_rule_no_time_money` int DEFAULT NULL,
  `japanese_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_job_yesno` int DEFAULT NULL,
  `same_level_japanese_jobname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_japanese_yearold` int DEFAULT NULL,
  `same_level_japanese_experience` float DEFAULT NULL,
  `same_level_japanese_month_money` int DEFAULT NULL,
  `same_level_japanese_time_money` int DEFAULT NULL,
  `same_level_japanese_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_japanese_salary_yesno` tinyint(1) DEFAULT NULL,
  `same_level_japanese_salary_yes_month_money` int DEFAULT NULL,
  `same_level_japanese_salary_yes_time_money` int DEFAULT NULL,
  `same_level_japanese_salary_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_no_salary_yesno` tinyint(1) DEFAULT NULL,
  `same_level_no_salary_jobname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_no_salary_yearold` int DEFAULT NULL,
  `same_level_no_salary_experience` float DEFAULT NULL,
  `same_level_no_salary_month_money` int DEFAULT NULL,
  `same_level_no_salary_time_money` int DEFAULT NULL,
  `same_level_no_salary_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_levele_no_salary_rule_yesno` tinyint(1) DEFAULT NULL,
  `same_levele_no_salary_rule_yes_month_money` int DEFAULT NULL,
  `same_levele_no_salary_rule_yes_time_money` int DEFAULT NULL,
  `same_levele_no_salary_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_allowance_yesno` tinyint(1) DEFAULT NULL,
  `learning_allowance_yes_money` int DEFAULT NULL,
  `learning_allowance_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_allowance_yesno` tinyint(1) DEFAULT NULL,
  `meal_allowance_yes_money` int DEFAULT NULL,
  `meal_allowance_trainee_self_yesno` tinyint(1) DEFAULT NULL,
  `meal_allowance_trainee_self_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_allowance_trainee_self_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_allowance_yesno` tinyint(1) DEFAULT NULL,
  `learning_house_allowance_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_allowance_trainee_self_yesno` tinyint(1) DEFAULT NULL,
  `learning_house_allowance_trainee_self_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_type` tinyint(1) DEFAULT NULL,
  `learning_house_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_size` float DEFAULT NULL,
  `learning_house_person_number` int DEFAULT NULL,
  `learning_house_oneperson_size` float DEFAULT NULL,
  `learning_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check1` tinyint(1) DEFAULT NULL,
  `house_check2` tinyint(1) DEFAULT NULL,
  `house_check3` tinyint(1) DEFAULT NULL,
  `house_check4` tinyint(1) DEFAULT NULL,
  `house_check5` tinyint(1) DEFAULT NULL,
  `house_check6` tinyint(1) DEFAULT NULL,
  `house_check7` tinyint(1) DEFAULT NULL,
  `house_check8` tinyint(1) DEFAULT NULL,
  `house_check9` tinyint(1) DEFAULT NULL,
  `house_check1_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check2_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check3_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check4_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check5_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check6_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check7_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check8_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check9_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `salary_month_money` int DEFAULT NULL,
  `meal_month_money` int DEFAULT NULL,
  `meal_month_money_yesno` tinyint(1) DEFAULT NULL,
  `meal_month_money_furniture_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_money_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_money` int DEFAULT NULL,
  `house_type` tinyint(1) DEFAULT NULL,
  `house_money_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_1_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_1_money` int DEFAULT NULL,
  `other_money_trainee_regular_2_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_2_money` int DEFAULT NULL,
  `other_money_trainee_regular_3_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_3_money` int DEFAULT NULL,
  `other_money_trainee_regular_wifi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `other_money_trainee_yesno` int DEFAULT NULL,
  `water_electric_collect_yesno` int DEFAULT NULL,
  `water_electric_money` int DEFAULT NULL,
  `other_money` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_explanation_fees_trainee`
--

INSERT INTO `et_doc_explanation_fees_trainee` VALUES (2,'customer_name','job_name',1000,800,1111,500,2222,600,'salary_month_1st',1,'salary_month_1st',8,5,1000,900,'same_salary_japanese',1,1000,200,'japanese_other',0,'same_level_japanese_jobname',1,5,200,300,'same_level_japanese_reason',0,100,150,'same_level_japanese_salary_other',0,'same_level_no_salary_jobname',18,180,250,240,'same_level_no_salary_reason',1,300,360,'same_levele_no_salary_note',0,800,'learning_allowance_note',0,900,0,'meal_allowance_trainee_self_yes_note','meal_allowance_trainee_self_note',0,'learning_house_allowance_yes_note',1,'learning_house_allowance_trainee_self_yes_note',1,'learning_house_name','learning_house_address','learning_house_postcode','learning_house_tel',300,100,10,'learning_note',1,0,1,0,0,1,0,1,0,'house_check1_note','house_check2_note','house_check3_note','house_check4_note','house_check5_note','house_check6_note','house_check7_note','house_check8_note','house_check9_note','sign_customer_name','sign_name',10000,280,1,'meal_month_money_furniture_note','meal_money_description',270,1,'house_money_description','other_money_trainee_regular_1_name',100,'other_money_trainee_regular_2_name',110,'other_money_trainee_regular_3_name',120,'other_money_trainee_regular_wifi','200',NULL,NULL,NULL,NULL,NULL,0,0,1,320,160),(3,'Nguyen A','job_name',1000,800,1111,500,2222,600,'test',1,'salary_month_1st',1,2,3,900,'same_salary_japanese',1,1000,200,'test',1,'same_level_japanese_jobname',1,23,12345,88,'test',1,334,555,'test',1,'test',1000,1000,1000,10000,'test',1,33,22,'test',1,800,'test123',0,10000000,1,'test','test2',1,'test3',0,'test4',1,'test5','learning_house_address','learning_house_postcode','learning_house_tel',NULL,1113,220,'test',0,0,0,0,1,0,1,1,1,'test1','test1','test1','test1','test1','test1','test1','test1','test1','sign_customer_name','sign_name',44,66,0,'test1','test15',88,1,'house_money_description','other_money_trainee_regular_1_name',100,'other_money_trainee_regular_2_name',110,'other_money_trainee_regular_3_name',120,'other_money_trainee_regular_wifi','other_money_trainee_regular_money',NULL,NULL,NULL,NULL,NULL,0,0,0,320,160);

--
-- Table structure for table `et_doc_explanation_of_circumstances`
--

CREATE TABLE `et_doc_explanation_of_circumstances` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `specified_skilled_foreigners` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `convenience_institution` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `convenience_foreign_national` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responses_after_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responses_after_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responses_after_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responses_after_4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responses_after_5` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responses_after_6` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `contact_details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `planned_return` date DEFAULT NULL,
  `whether_guidance_1` tinyint DEFAULT NULL,
  `whether_guidance_2` tinyint DEFAULT NULL,
  `whether_guidance_3` tinyint DEFAULT NULL,
  `whether_guidance_4` tinyint DEFAULT NULL,
  `whether_guidance_5` tinyint DEFAULT NULL,
  `whether_guidance_6` tinyint DEFAULT NULL,
  `whether_guidance_7` tinyint DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `contact_details2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_explanation_of_circumstances`
--

INSERT INTO `et_doc_explanation_of_circumstances` VALUES (1,'てゅｙ','あｂｆ；あｈふぁ','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ああｈふぁｆｇｊｓ’ｇｐｈｋｈ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','082-942-0111','2025-01-16',0,0,1,1,0,0,0,'OOOOOOOO','TTTTTTTT','2025-01-21',NULL,NULL,151,NULL,1,7,'abs会社'),(2,'タナカ','ああああああ','ああああ','ｂｂｂｂｂ','CCCCC','dddddđ','あああああ','あｇｆｈｊ','ｄｊｋｋ','082-942-0111','2025-03-11',0,0,0,0,0,0,0,'入江省吾','TONY','2025-03-10',NULL,NULL,NULL,NULL,2,0,'abs会社');

--
-- Table structure for table `et_doc_explanation_of_collection_costs`
--

CREATE TABLE `et_doc_explanation_of_collection_costs` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `budget_estimate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `whether_or_expenses` tinyint DEFAULT NULL,
  `fees_collected_expenses` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_details_ingredients` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount_equivalent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `whether_or_housing` tinyint DEFAULT NULL,
  `per_month` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_details` tinyint DEFAULT NULL,
  `amount_equivalent1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `whether_utility` tinyint DEFAULT NULL,
  `per_month_approx` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `other_specific_skilled` tinyint DEFAULT NULL,
  `detail1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `detail2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `detail3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `per_month_app1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `per_month_app2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `per_month_app3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_benefits_specific` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `an_explanation_expenses` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `name_specific_skills_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_explanation_of_collection_costs`
--

INSERT INTO `et_doc_explanation_of_collection_costs` VALUES (1,'ljgoufoasuda',0,NULL,'0','0',0,'0',0,'0',0,'0',0,'0','0','0','0','0','0','0','0','2024-12-01','0','0',NULL,NULL,'2024-12-01 09:32:38',NULL,'2024-12-01 09:32:38',1,0),(2,'18,500円（１か月当たり）',1,'10,000','社員食堂において食事を提供','社員食堂では全従業員に対して昼食時に１食５００円で食事を提供して おり、１か月の出勤日数（平均約２０日間）×５００円＝１０，０００ 円の上記食費は適正である。',1,'9,000',1,'25,500,000円（建設費用）÷２０年（耐用年数）÷１２か月 ÷１名（特定技能外国人の入居人数）≒106,250円 上記を踏まえ、本物件の居住費は適正である。',1,'3,000',1,'通信','0','0','1,500','0','0','社宅においてインターネットを使用可能。','社宅におけるインターネット通信費として月額約3,000 円が発生 しており、上記通信費は適正である（半額は会社負担。）。','2024-12-14','ABC会社','オオノ',NULL,NULL,'2024-12-14 06:50:56',1,'2024-12-16 00:34:42',1,7),(3,'18,500',2,'10,000','社員食堂において食事を提供 ádasdasdasd','社員食堂では全従業員に対して昼食時に１食５００円で食事を提供して おり、１か月の出勤日数（平均約２０日間）×５００円＝１０，０００ 円の上記食費は適正である。',1,'9,000',1,'25,500,000円（建設費用）÷２０年（耐用年数）÷１２か月 ÷１名（特定技能外国人の入居人数）≒106,250円 上記を踏まえ、本物件の居住費は適正である。',1,'3,000',1,'通信','0','0','3000','0','0','社宅においてインターネットを使用可能。','社宅におけるインターネット通信費として月額約3,000 円が発生 しており、上記通信費は適正である（半額は会社負担。）。','2024-12-18','ABC会社','オオノ',NULL,NULL,'2024-12-18 02:39:22',151,'2025-02-22 04:42:53',1,4),(4,'18,500',1,'10,000','社員食堂において食事を提供','社員食堂では全従業員に対して昼食時に１食５００円で食事を提供して おり、１か月の出勤日数（平均約２０日間）×５００円＝１０，０００ 円の上記食費は適正である。',2,'0',1,'25,500,000円（建設費用）÷２０年（耐用年数）÷１２か月 ÷１名（特定技能外国人の入居人数）≒106,250円 上記を踏まえ、本物件の居住費は適正である。',2,'3,000',1,'通信','0','0','0','0','0','社宅においてインターネットを使用可能。','社宅におけるインターネット通信費として月額約3,000 円が発生 しており、上記通信費は適正である（半額は会社負担。）。','2025-04-17','田中会社','田中',NULL,NULL,'2025-04-19 08:40:09',151,'2025-04-19 08:57:25',2,1);

--
-- Table structure for table `et_doc_explanation_of_employment_history`
--

CREATE TABLE `et_doc_explanation_of_employment_history` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `specified_skilled_foreigners` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `yes_or_no` tinyint DEFAULT NULL,
  `nb1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nb2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nb3` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_nb` date DEFAULT NULL,
  `paid` tinyint(1) DEFAULT NULL,
  `free` tinyint(1) DEFAULT NULL,
  `name_employment_agency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nominal1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nominal2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `yes_or_no2` tinyint DEFAULT NULL,
  `name_or_title` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tn1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tn2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tn3` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_seeker_amount1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_seeker_nominal1` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_seeker_amount2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_seeker_nominal2` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `yes_or_no3` tinyint DEFAULT NULL,
  `cd_date` date DEFAULT NULL,
  `name_specific_skills_organization` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_person_responsible_preparation` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_payment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `nominal4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `payment_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `payment_amount` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `total_payment` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signature_applicant` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pn1` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pn2` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pn3` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code_bd` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `payment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `payment_all` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_explanation_of_employment_history`
--

INSERT INTO `et_doc_explanation_of_employment_history` VALUES (1,'タナカ',2,'1','0','0','2024-12-19',1,0,'takada','200000','事前ガイダンス費用','15000','gdalda',2,'adasfsfg','adad','sadaf','082','942','0000','2000','4444','3333','Adsđf',1,'2024-12-19','ABC会社','太郎','[\"agshfg\",\"\\u00e0gshfj\",\"gdjhfj\",\"\\u00e1dh\",\"\\u00e1hjg\"]','[\"\\u00e1dhj\",\"\\u00e0dggj\",\"\\u00e0dfghj\",\"adsfht\",\"\\u1ea1hjff\"]','[\"2024-12-18\",\"2024-12-12\",\"2024-12-18\",\"2024-12-19\",\"2024-12-19\"]','[\"\\uff08\\u4e88\\u5b9a\\uff09200000\",\"\\uff08\\u4e88\\u5b9a\\uff09200000\",\"\\uff08\\u4e88\\u5b9a\\uff09200000\",\"\\uff08\\u4e88\\u5b9a\\uff09200000\",\"\\uff08\\u4e88\\u5b9a\\uff09200000\"]','（予定）200000','AAAAAAAA',NULL,NULL,'2024-12-19 06:21:58',151,'2025-02-22 05:17:37',1,14,'千葉県柏市あけぼの5-4-35-102','082','000','0111','300-3111','[\"200000\",\"11000\",\"20000\",\"20000\",\"20000\"]','20000');

--
-- Table structure for table `et_doc_explanation_support_contract_reg_support_org`
--

CREATE TABLE `et_doc_explanation_support_contract_reg_support_org` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `applicant` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contracting_party` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contract_date` date DEFAULT NULL,
  `applicable` tinyint(1) DEFAULT NULL,
  `commission_fee` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_form` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `name_specific_organition` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `n_deng` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_explanation_support_contract_reg_support_org`
--

INSERT INTO `et_doc_explanation_support_contract_reg_support_org` VALUES (1,'大野','武村','1574','2024-12-25',0,'200000','2024-12-25','2024-12-25','2024-12-25','ABC株式会社','武村由紀子',NULL,NULL,'2024-12-25 06:20:48',151,'2024-12-25 07:29:03',1,3,'20');

--
-- Table structure for table `et_doc_ext_audit_report`
--

CREATE TABLE `et_doc_ext_audit_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_ceo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_ceo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_date` date DEFAULT NULL,
  `audit_creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_creator_support1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_creator_support2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `report_audit_type` tinyint(1) DEFAULT NULL,
  `payslip_audit_type` tinyint(1) DEFAULT NULL,
  `audit_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_evaluate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_1_type` tinyint(1) DEFAULT NULL,
  `audit_result_1_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_2_type` tinyint(1) DEFAULT NULL,
  `audit_result_2_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_3_type` tinyint(1) DEFAULT NULL,
  `audit_result_3_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_4_type` tinyint(1) DEFAULT NULL,
  `audit_result_4_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_5_type` tinyint(1) DEFAULT NULL,
  `audit_result_5_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_6_type` tinyint(1) DEFAULT NULL,
  `audit_result_6_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_7_type` tinyint(1) DEFAULT NULL,
  `audit_result_7_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_8_type` tinyint(1) DEFAULT NULL,
  `audit_result_8_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_9_type` tinyint(1) DEFAULT NULL,
  `audit_result_9_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_10_type` tinyint DEFAULT NULL,
  `audit_result_10_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_11_type` tinyint DEFAULT NULL,
  `audit_result_11_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_12_type` tinyint DEFAULT NULL,
  `audit_result_12_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_13_type` tinyint DEFAULT NULL,
  `audit_result_13_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_14_type` tinyint DEFAULT NULL,
  `audit_result_14_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_15_type` tinyint DEFAULT NULL,
  `audit_result_15_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_16_type` tinyint DEFAULT NULL,
  `audit_result_16_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_17_type` tinyint DEFAULT NULL,
  `audit_result_17_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_18_type` tinyint DEFAULT NULL,
  `audit_result_18_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_19_type` tinyint(1) DEFAULT NULL,
  `audit_result_19_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_20_type` tinyint(1) DEFAULT NULL,
  `audit_result_20_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_21_type` tinyint(1) DEFAULT NULL,
  `audit_result_21_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_22_type` tinyint(1) DEFAULT NULL,
  `audit_result_22_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_23_type` tinyint(1) DEFAULT NULL,
  `audit_result_23_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_24_type` tinyint(1) DEFAULT NULL,
  `audit_result_24_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_25_type` tinyint(1) DEFAULT NULL,
  `audit_result_25_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_26_type` tinyint(1) DEFAULT NULL,
  `audit_result_26_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_27_type` tinyint(1) DEFAULT NULL,
  `audit_result_27_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_28_type` int DEFAULT NULL,
  `audit_result_28_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_29_type` tinyint(1) DEFAULT NULL,
  `audit_result_29_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_30_type` tinyint(1) DEFAULT NULL,
  `audit_result_30_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_31_type` tinyint(1) DEFAULT NULL,
  `audit_result_31_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_32_type` tinyint(1) DEFAULT NULL,
  `audit_result_32_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_33_type` tinyint(1) DEFAULT NULL,
  `audit_result_33_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_34_type` tinyint(1) DEFAULT NULL,
  `audit_result_34_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_35_type` tinyint(1) DEFAULT NULL,
  `audit_result_35_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_ext_audit_report`
--

INSERT INTO `et_doc_ext_audit_report` VALUES (1,'2024-07-22','customer_director_name','creator_name','customer_name','customer_postcode','customer_address','0123456789','customer_ceo_name','branch_name','branch_postcode','branch_address','branch_tel','branch_ceo_name','2024-07-24','audit_creator_name','audit_creator_support1','audit_creator_support2',0,0,'audit_result','audit_evaluate','audit_note',0,'note1',1,'note2',0,'note3',0,'audit_result_4_note',1,'note5',0,'note6',NULL,'note7',0,'note8',0,'note9',1,'note10',1,'note11',0,'note12',0,'note13',0,'note14',1,'note15',0,'note16',0,'note17',1,'note18',0,'note19',0,'audit_result_20_type',0,'note21',1,'audit_result_22',0,'note23',0,'note24',1,'note25',0,'note26',0,'note27',1,'note28',1,'note29',1,'note30',1,'note31',1,'note32',0,'note33',1,'note34',0,'note35','test1\r\ntest 2','note 1\r\nnote2',NULL,NULL,NULL,1,1,6),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'note1\r\nnote2','test\r\ntest123',NULL,NULL,NULL,NULL,1,0),(3,'2024-12-14','55555555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'888888',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1);

--
-- Table structure for table `et_doc_ext_audit_report_accompany`
--

CREATE TABLE `et_doc_ext_audit_report_accompany` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_ceo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_ceo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_date` date DEFAULT NULL,
  `audit_creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_creator_support1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_creator_support2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_branch_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_branch_trainning_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_type_5` tinyint(1) DEFAULT NULL,
  `check_type_6` tinyint(1) DEFAULT NULL,
  `check_type_7` tinyint(1) DEFAULT NULL,
  `check_type_8` tinyint(1) DEFAULT NULL,
  `check_type_9` tinyint(1) DEFAULT NULL,
  `evaluate_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_ext_audit_report_accompany`
--

INSERT INTO `et_doc_ext_audit_report_accompany` VALUES (1,'2024-07-18','customer_director_name','creator_name','customer_name','321 ― 2341','customer_address','321 ― 3213 ― 2132','customer_ceo_name','branch_name','321 ― 3213','branch_address','213 ― 2132 ― 1321','branch_ceo_name','2024-07-18','audit_creator_name','audit_creator_support1','audit_creator_support2','company_name','321 ― 3213','company_address','231 ― 2132 ― 1321','company_branch_address','company_branch_trainning_address','home_address',2,2,1,2,2,'evaluate_content','note',NULL,NULL,NULL,NULL,NULL,0),(2,'2024-08-05','customer_director_name','creator_name','customer_name','111 ― 2222','customer_address','111 ― 2222 ― 9999','customer_ceo_name','branch_name','111 ― 2222','branch_address 123456','111 ― 2222 ― 1111','branch_ceo_name','2024-08-06','audit_creator_name','audit_creator_support1','audit_creator_support2','company_name','112 ― 1111','company_address','888 ― 8888 ― 8888','company_branch_address','company_branch_trainning_address','home_address',2,2,1,1,1,'test\r\ntest1\r\ntest2','note1\r\nnote2\r\n11',NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_ext_auditor_brief`
--

CREATE TABLE `et_doc_ext_auditor_brief` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_leader_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_leader_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_name_furigang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_experience_cv` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_semina_cv` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_relationship` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_ext_auditor_brief`
--

INSERT INTO `et_doc_ext_auditor_brief` VALUES (1,'company_name','company_name_furigana','company_postcode','company_address','company_tel','company_leader_name','company_leader_furigana','company_leader_title','person_name','person_name_furigang','person_postcode','person_address','person_tel','person_national','person_title','person_certificate','training_experience_cv','training_semina_cv','applicant_relationship','2024-07-02','sign_name','test123',NULL,NULL,NULL,1,1,1),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,7);

--
-- Table structure for table `et_doc_ext_auditor_pledge`
--

CREATE TABLE `et_doc_ext_auditor_pledge` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_ext_auditor_pledge`
--

INSERT INTO `et_doc_ext_auditor_pledge` VALUES (1,'2024-07-25','sign_name','customer_name',NULL,NULL,NULL,NULL,NULL,0),(2,'2024-08-13','sign_name','監理団体',NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_ext_officer_confirm`
--

CREATE TABLE `et_doc_ext_officer_confirm` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_ceo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `branch_ceo_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_date` date DEFAULT NULL,
  `audit_creator_support1` tinyint(1) DEFAULT NULL,
  `audit_creator_support2` tinyint(1) DEFAULT NULL,
  `audit_evaluate` date DEFAULT NULL,
  `audit_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_1_type` tinyint(1) DEFAULT NULL,
  `audit_result_1_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_2_type` tinyint(1) DEFAULT NULL,
  `audit_result_2_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_3_type` tinyint(1) DEFAULT NULL,
  `audit_result_3_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_4_type` tinyint(1) DEFAULT NULL,
  `audit_result_4_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_5_type` tinyint(1) DEFAULT NULL,
  `audit_result_5_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_6_type` tinyint(1) DEFAULT NULL,
  `audit_result_6_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_7_type` tinyint(1) DEFAULT NULL,
  `audit_result_7_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_8_type` tinyint(1) DEFAULT NULL,
  `audit_result_8_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_9_type` tinyint(1) DEFAULT NULL,
  `audit_result_9_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_10_type` tinyint DEFAULT NULL,
  `audit_result_10_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_11_type` tinyint DEFAULT NULL,
  `audit_result_11_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_12_type` tinyint DEFAULT NULL,
  `audit_result_12_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_13_type` tinyint DEFAULT NULL,
  `audit_result_13_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_14_type` tinyint DEFAULT NULL,
  `audit_result_14_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_15_type` tinyint DEFAULT NULL,
  `audit_result_15_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_16_type` tinyint DEFAULT NULL,
  `audit_result_16_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_17_type` tinyint DEFAULT NULL,
  `audit_result_17_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_18_type` tinyint DEFAULT NULL,
  `audit_result_18_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_19_type` tinyint(1) DEFAULT NULL,
  `audit_result_19_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_20_type` tinyint(1) DEFAULT NULL,
  `audit_result_20_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_21_type` tinyint(1) DEFAULT NULL,
  `audit_result_21_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_22_type` tinyint(1) DEFAULT NULL,
  `audit_result_22_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_23_type` tinyint(1) DEFAULT NULL,
  `audit_result_23_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_24_type` tinyint(1) DEFAULT NULL,
  `audit_result_24_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_25_type` tinyint(1) DEFAULT NULL,
  `audit_result_25_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_26_type` tinyint(1) DEFAULT NULL,
  `audit_result_26_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_27_type` tinyint(1) DEFAULT NULL,
  `audit_result_27_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_28_type` int DEFAULT NULL,
  `audit_result_28_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_29_type` tinyint(1) DEFAULT NULL,
  `audit_result_29_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_30_type` tinyint(1) DEFAULT NULL,
  `audit_result_30_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_31_type` tinyint(1) DEFAULT NULL,
  `audit_result_31_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_32_type` tinyint(1) DEFAULT NULL,
  `audit_result_32_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_33_type` tinyint(1) DEFAULT NULL,
  `audit_result_33_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_34_type` tinyint(1) DEFAULT NULL,
  `audit_result_34_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `audit_result_35_type` tinyint(1) DEFAULT NULL,
  `audit_result_35_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_ext_officer_confirm`
--


--
-- Table structure for table `et_doc_ext_officer_pledge`
--

CREATE TABLE `et_doc_ext_officer_pledge` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_ext_officer_pledge`
--

INSERT INTO `et_doc_ext_officer_pledge` VALUES (1,'2024-07-09','sign_name','director_name',NULL,NULL,NULL,NULL,NULL,0),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_file`
--

CREATE TABLE `et_doc_file` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `file_name` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fileable_type` varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `item_id` bigint unsigned DEFAULT NULL,
  `url` varchar(500) CHARACTER SET utf8mb3 COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `file_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_unicode_ci;

--
-- Dumping data for table `et_doc_file`
--

INSERT INTO `et_doc_file` VALUES (1,'1','App\\Models\\MInvoice',1,'1',1),(2,'2','App\\Models\\MInvoice',1,'1',2),(3,NULL,'App\\Models\\MInvoice',2,NULL,2);

--
-- Table structure for table `et_doc_foreign_institution_certificate`
--

CREATE TABLE `et_doc_foreign_institution_certificate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_trainging_1` tinyint(1) DEFAULT NULL,
  `check_trainging_2` tinyint(1) DEFAULT NULL,
  `check_trainging_3` tinyint(1) DEFAULT NULL,
  `check_training_3_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_finish_1` tinyint(1) DEFAULT NULL,
  `check_finish_1_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_finish_1_dep_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_finish_1_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_finish_2` tinyint(1) DEFAULT NULL,
  `check_finish_3` tinyint(1) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_foreign_institution_certificate`
--

INSERT INTO `et_doc_foreign_institution_certificate` VALUES (3,1,1,1,'備考',1,'事業所','部署','check_finish_1_job_name',1,1,'2024-09-11','test','test123',NULL,NULL,NULL,1,1,3);

--
-- Table structure for table `et_doc_handlinginfo_agreement`
--

CREATE TABLE `et_doc_handlinginfo_agreement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_handlinginfo_agreement`
--

INSERT INTO `et_doc_handlinginfo_agreement` VALUES (1,'2024-06-21','NGUYEN thi anh nguyet',NULL,NULL,NULL,NULL,1,1,3),(2,'2024-09-10','sign_name',NULL,NULL,NULL,NULL,1,1,2);

--
-- Table structure for table `et_doc_hiring_request_form`
--

CREATE TABLE `et_doc_hiring_request_form` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `furigana1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel_business` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `furigana2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `representative_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `furigana5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `furigana3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `furigana4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accepted_job_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `receiving_operation_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `male` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `female` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `age` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `up_to_age` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `count` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `un` tinyint(1) DEFAULT NULL,
  `ma` tinyint(1) DEFAULT NULL,
  `do` tinyint(1) DEFAULT NULL,
  `ju` tinyint(1) DEFAULT NULL,
  `hi` tinyint(1) DEFAULT NULL,
  `col` tinyint(1) DEFAULT NULL,
  `no` tinyint(1) DEFAULT NULL,
  `have` tinyint(1) DEFAULT NULL,
  `none` tinyint(1) DEFAULT NULL,
  `dont` tinyint(1) DEFAULT NULL,
  `height` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `weight` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vision` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vietnam` tinyint(1) DEFAULT NULL,
  `philippines` tinyint(1) DEFAULT NULL,
  `indonesia` tinyint(1) DEFAULT NULL,
  `others` tinyint(1) DEFAULT NULL,
  `txt_others` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `acc` tinyint(1) DEFAULT NULL,
  `ent` tinyint(1) DEFAULT NULL,
  `sky` tinyint(1) DEFAULT NULL,
  `doc` tinyint(1) DEFAULT NULL,
  `other_requests` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mon` tinyint(1) DEFAULT NULL,
  `mont` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hour` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dai` tinyint(1) DEFAULT NULL,
  `daiyen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thou_sys` tinyint(1) DEFAULT NULL,
  `thou_yen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month_yen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dormitory_fee` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `actu` tinyint(1) DEFAULT NULL,
  `actu_yen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fix` tinyint(1) DEFAULT NULL,
  `fix_yen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `heal` tinyint(1) DEFAULT NULL,
  `employ` tinyint(1) DEFAULT NULL,
  `social_insurance` tinyint(1) DEFAULT NULL,
  `nation` tinyint(1) DEFAULT NULL,
  `pension` tinyint(1) DEFAULT NULL,
  `workers` tinyint(1) DEFAULT NULL,
  `surance` tinyint(1) DEFAULT NULL,
  `application_insurance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `income_tax` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deduction` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `project` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `net_amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yen_hour` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `about` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hours_month` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `monthly` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `closing_date` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_month` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cash` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_transfer` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hour_f` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `point_f` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hour_t` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `point_t` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `point1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `break_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_working` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `annual_holidays` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `corporate_calendar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reiwa_date` date DEFAULT NULL,
  `residence` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `buss_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `representative` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `point2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_important_points` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employees` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_insurance` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fax_business` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `hourly` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_hiring_request_form`
--

INSERT INTO `et_doc_hiring_request_form` VALUES (1,NULL,NULL,NULL,151,1,25,'おおの','大野','0854444','おおの','大野','おおの','大野','トウキョウ','tokyo','たなか','田中','あbs会社','なかななｋ','1','1','30','40','2',1,1,1,1,1,1,1,1,1,1,'160','60','AA',1,1,1,1,'thai',1,1,1,1,'ahadhf',1,'20000','1000',1,'10000',1,'1300','30000','30000',1,'2000',1,'20000',1,1,1,1,1,NULL,1,'ádasd','1','20000','2000','3000','1500','12','10','200000','25','25','1','','9','00','17','00','8','00','170','60','170','50','220','0006-02-01','tokyou','ABC','takana','035488','00','nashi','20000','20000','05755','1000');

--
-- Table structure for table `et_doc_intention_agreement`
--

CREATE TABLE `et_doc_intention_agreement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `deadline_date` date DEFAULT NULL,
  `returncountry_date` date DEFAULT NULL,
  `reason_otherlang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reason_jp` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `person_type` int DEFAULT NULL COMMENT '1:監理団体,  2:実習実施者',
  `person_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_intention_agreement`
--

INSERT INTO `et_doc_intention_agreement` VALUES (1,'2024-06-20','2024-06-21','dsa','dsa',2,'dsa','2024-06-22','dsadsa','dsa',NULL,NULL,NULL,NULL,NULL,NULL,0),(2,NULL,NULL,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_job_change_support_report`
--

CREATE TABLE `et_doc_job_change_support_report` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `name_support` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_specific` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_staff` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reasons_implementing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_txt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `residence_card_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality_region` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `date2` date DEFAULT NULL,
  `air` tinyint(1) DEFAULT NULL,
  `sup` tinyint(1) DEFAULT NULL,
  `correspondence_results` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `responder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_job_change_support_report`
--

INSERT INTO `et_doc_job_change_support_report` VALUES (1,NULL,NULL,'2025-03-29 08:01:30',151,'2025-03-29 08:01:30',2,7,'入管 太郎','株式会社 入管','あああああああああああああ','○○公共職業安定所、ハローワーク○○ 等',NULL,'AB12340078CD','茨城県土浦市板谷4丁目714－47','033-1244','040-855','タイ','男','TURNER ELIZABETH','2000-03-26','2025-03-27','2025-03-13',2,1,'ハローワークから紹介された株式会社○○へ転職が決まった。','TANAKA','085-457-4165');

--
-- Table structure for table `et_doc_kumiai_change_info_application`
--

CREATE TABLE `et_doc_kumiai_change_info_application` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `permission_date` date DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `condition_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `condition_type_3_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_type_jobtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_type_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_type_2_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `reason_type_jobtype_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_kumiai_change_info_application`
--

INSERT INTO `et_doc_kumiai_change_info_application` VALUES (1,'2024-07-08','name','321321','2024-07-09','customer_name','customer_name_furigana','321 ― 3213','customer_address','321 ― 3213 ― 2132','3','condition_type_3_note','1','果 樹','耕種農業','test','note',NULL,NULL,NULL,NULL,NULL,0,4),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1',NULL,'2','果 樹','耕種農業',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,4);

--
-- Table structure for table `et_doc_kumiai_expense_management`
--

CREATE TABLE `et_doc_kumiai_expense_management` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `shoukai_1_bank_in` int DEFAULT NULL,
  `shoukai_1_bank_out` int DEFAULT NULL,
  `shoukai_2_bank_in` int DEFAULT NULL,
  `shoukai_2_bank_out` int DEFAULT NULL,
  `shoukai_3_bank_in` int DEFAULT NULL,
  `shoukai_3_bank_out` int DEFAULT NULL,
  `shoukai_4_bank_in` int DEFAULT NULL,
  `shoukai_4_bank_out` int DEFAULT NULL,
  `semina_1_bank_in` int DEFAULT NULL,
  `semina_1_bank_out` int DEFAULT NULL,
  `semina_2_bank_in` int DEFAULT NULL,
  `semina_2_bank_out` int DEFAULT NULL,
  `semina_3_bank_in` int DEFAULT NULL,
  `semina_3_bank_out` int DEFAULT NULL,
  `semina_4_bank_in` int DEFAULT NULL,
  `semina_4_bank_out` int DEFAULT NULL,
  `auth_1_bank_in` int DEFAULT NULL,
  `auth_1_bank_out` int DEFAULT NULL,
  `auth_2_bank_in` int DEFAULT NULL,
  `auth_2_bank_out` int DEFAULT NULL,
  `auth_3_bank_in` int DEFAULT NULL,
  `auth_3_bank_out` int DEFAULT NULL,
  `other_1_bank_in` int DEFAULT NULL,
  `other_1_bank_out` int DEFAULT NULL,
  `other_2_bank_in` int DEFAULT NULL,
  `other_2_bank_out` int DEFAULT NULL,
  `other_3_bank_in` int DEFAULT NULL,
  `other_3_bank_out` int DEFAULT NULL,
  `other_4_bank_in` int DEFAULT NULL,
  `other_4_bank_out` int DEFAULT NULL,
  `other_5_bank_in` int DEFAULT NULL,
  `other_5_bank_out` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_kumiai_expense_management`
--

INSERT INTO `et_doc_kumiai_expense_management` VALUES (1,'2024-07-17','2024-07-17',1,1,2,2,3,3,4,4,1,1,2,2,3,3,4,4,1,1,2,2,3,NULL,11,11,12,2,3,3,244,4,5,5,NULL,NULL,NULL,1,1,1),(2,'2024-09-01','2024-09-02',1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,NULL,NULL,NULL,1,1,5);

--
-- Table structure for table `et_doc_kumiai_jobtype_scope`
--

CREATE TABLE `et_doc_kumiai_jobtype_scope` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_1_1_1` tinyint(1) DEFAULT NULL,
  `check_1_1_2` tinyint(1) DEFAULT NULL,
  `check_1_1_3` tinyint(1) DEFAULT NULL,
  `check_1_2_1` tinyint(1) DEFAULT NULL,
  `check_1_2_2` tinyint(1) DEFAULT NULL,
  `check_1_2_3` tinyint(1) DEFAULT NULL,
  `check_2_1_1` tinyint(1) DEFAULT NULL,
  `check_2_1_2` tinyint DEFAULT NULL,
  `check_2_1_3` tinyint DEFAULT NULL,
  `check_2_1_4` tinyint DEFAULT NULL,
  `check_2_1_5` tinyint DEFAULT NULL,
  `check_2_1_6` tinyint DEFAULT NULL,
  `check_2_1_7` tinyint DEFAULT NULL,
  `check_2_1_8` tinyint DEFAULT NULL,
  `check_2_1_9` tinyint DEFAULT NULL,
  `check_2_2_1` tinyint DEFAULT NULL,
  `check_3_1_1` tinyint DEFAULT NULL,
  `check_3_1_2` tinyint DEFAULT NULL,
  `check_3_2_1` tinyint DEFAULT NULL,
  `check_3_2_2` tinyint DEFAULT NULL,
  `check_3_3_1` tinyint DEFAULT NULL,
  `check_3_4_1` tinyint DEFAULT NULL,
  `check_3_5_1` tinyint DEFAULT NULL,
  `check_3_6_1` tinyint DEFAULT NULL,
  `check_3_7_1` tinyint DEFAULT NULL,
  `check_3_8_1` tinyint DEFAULT NULL,
  `check_3_9_1` tinyint DEFAULT NULL,
  `check_3_9_2` tinyint(1) DEFAULT NULL,
  `check_3_10_1` tinyint(1) DEFAULT NULL,
  `check_3_11_1` tinyint(1) DEFAULT NULL,
  `check_3_12_1` tinyint(1) DEFAULT NULL,
  `check_3_13_1` tinyint(1) DEFAULT NULL,
  `check_3_13_2` tinyint(1) DEFAULT NULL,
  `check_3_14_1` tinyint(1) DEFAULT NULL,
  `check_3_15_1` tinyint(1) DEFAULT NULL,
  `check_3_15_2` tinyint(1) DEFAULT NULL,
  `check_3_15_3` tinyint(1) DEFAULT NULL,
  `check_3_15_4` tinyint(1) DEFAULT NULL,
  `check_3_15_5` tinyint(1) DEFAULT NULL,
  `check_3_16_1` tinyint(1) DEFAULT NULL,
  `check_3_17_1` tinyint(1) DEFAULT NULL,
  `check_3_18_1` tinyint(1) DEFAULT NULL,
  `check_3_19_1` tinyint(1) DEFAULT NULL,
  `check_3_20_1` tinyint(1) DEFAULT NULL,
  `check_3_21_1` tinyint(1) DEFAULT NULL,
  `check_3_21_2` tinyint(1) DEFAULT NULL,
  `check_3_21_3` tinyint(1) DEFAULT NULL,
  `check_3_21_4` tinyint(1) DEFAULT NULL,
  `check_3_22_1` tinyint(1) DEFAULT NULL,
  `check_4_1_1` tinyint(1) DEFAULT NULL,
  `check_4_2_1` tinyint(1) DEFAULT NULL,
  `check_4_3_1` tinyint(1) DEFAULT NULL,
  `check_4_3_2` tinyint(1) DEFAULT NULL,
  `check_4_3_3` tinyint(1) DEFAULT NULL,
  `check_4_3_4` tinyint(1) DEFAULT NULL,
  `check_4_4_1` tinyint(1) DEFAULT NULL,
  `check_4_4_2` tinyint(1) DEFAULT NULL,
  `check_4_4_3` tinyint(1) DEFAULT NULL,
  `check_4_4_4` tinyint(1) DEFAULT NULL,
  `check_4_4_5` tinyint(1) DEFAULT NULL,
  `check_4_5_1` tinyint(1) DEFAULT NULL,
  `check_4_6_1` tinyint(1) DEFAULT NULL,
  `check_4_7_1` tinyint(1) DEFAULT NULL,
  `check_4_8_1` tinyint(1) DEFAULT NULL,
  `check_4_9_1` tinyint(1) DEFAULT NULL,
  `check_4_10_1` tinyint(1) DEFAULT NULL,
  `check_4_11_1` tinyint(1) DEFAULT NULL,
  `check_5_1_1` tinyint(1) DEFAULT NULL,
  `check_5_1_2` tinyint(1) DEFAULT NULL,
  `check_5_1_3` tinyint(1) DEFAULT NULL,
  `check_5_1_4` tinyint(1) DEFAULT NULL,
  `check_5_2_1` tinyint(1) DEFAULT NULL,
  `check_5_2_2` tinyint(1) DEFAULT NULL,
  `check_5_2_3` tinyint(1) DEFAULT NULL,
  `check_5_3_1` tinyint(1) DEFAULT NULL,
  `check_5_3_2` tinyint(1) DEFAULT NULL,
  `check_5_4_1` tinyint(1) DEFAULT NULL,
  `check_5_4_2` tinyint(1) DEFAULT NULL,
  `check_5_5_1` tinyint(1) DEFAULT NULL,
  `check_5_6_1` tinyint(1) DEFAULT NULL,
  `check_5_7_1` tinyint(1) DEFAULT NULL,
  `check_5_8_1` tinyint(1) DEFAULT NULL,
  `check_5_9_1` tinyint(1) DEFAULT NULL,
  `check_5_10_1` tinyint(1) DEFAULT NULL,
  `check_5_10_2` tinyint(1) DEFAULT NULL,
  `check_5_10_3` tinyint(1) DEFAULT NULL,
  `check_5_11_1` tinyint(1) DEFAULT NULL,
  `check_5_12_1` tinyint(1) DEFAULT NULL,
  `check_5_13_1` tinyint(1) DEFAULT NULL,
  `check_6_1_1` tinyint(1) DEFAULT NULL,
  `check_6_1_2` tinyint(1) DEFAULT NULL,
  `check_6_2_1` tinyint(1) DEFAULT NULL,
  `check_6_2_2` tinyint(1) DEFAULT NULL,
  `check_6_3_1` tinyint(1) DEFAULT NULL,
  `check_6_3_2` tinyint(1) DEFAULT NULL,
  `check_6_4_1` tinyint(1) DEFAULT NULL,
  `check_6_4_2` tinyint(1) DEFAULT NULL,
  `check_6_4_3` tinyint(1) DEFAULT NULL,
  `check_6_4_4` tinyint(1) DEFAULT NULL,
  `check_6_5_1` tinyint(1) DEFAULT NULL,
  `check_6_6_1` tinyint(1) DEFAULT NULL,
  `check_6_7_1` tinyint(1) DEFAULT NULL,
  `check_6_8_1` tinyint(1) DEFAULT NULL,
  `check_6_8_2` tinyint(1) DEFAULT NULL,
  `check_6_9_1` tinyint(1) DEFAULT NULL,
  `check_6_10_1` tinyint(1) DEFAULT NULL,
  `check_6_10_2` tinyint(1) DEFAULT NULL,
  `check_6_10_3` tinyint(1) DEFAULT NULL,
  `check_6_11_1` tinyint(1) DEFAULT NULL,
  `check_6_12_1` tinyint(1) DEFAULT NULL,
  `check_6_13_1` tinyint(1) DEFAULT NULL,
  `check_6_14_1` tinyint(1) DEFAULT NULL,
  `check_6_14_2` tinyint(1) DEFAULT NULL,
  `check_6_14_3` tinyint(1) DEFAULT NULL,
  `check_6_14_4` tinyint(1) DEFAULT NULL,
  `check_6_14_5` tinyint(1) DEFAULT NULL,
  `check_6_15_1` tinyint(1) DEFAULT NULL,
  `check_6_15_2` tinyint(1) DEFAULT NULL,
  `check_6_16_1` tinyint(1) DEFAULT NULL,
  `check_6_16_2` tinyint(1) DEFAULT NULL,
  `check_6_17_1` tinyint(1) DEFAULT NULL,
  `check_6_17_2` tinyint(1) DEFAULT NULL,
  `check_6_17_3` tinyint(1) DEFAULT NULL,
  `check_7_1_1` tinyint(1) DEFAULT NULL,
  `check_7_2_1` tinyint(1) DEFAULT NULL,
  `check_7_2_2` tinyint(1) DEFAULT NULL,
  `check_7_3_1` tinyint(1) DEFAULT NULL,
  `check_7_4_1` tinyint(1) DEFAULT NULL,
  `check_7_4_2` tinyint(1) DEFAULT NULL,
  `check_7_4_3` tinyint(1) DEFAULT NULL,
  `check_7_4_4` tinyint(1) DEFAULT NULL,
  `check_7_5_1` tinyint(1) DEFAULT NULL,
  `check_7_6_1` tinyint(1) DEFAULT NULL,
  `check_7_6_2` tinyint(1) DEFAULT NULL,
  `check_7_6_3` tinyint(1) DEFAULT NULL,
  `check_7_6_4` tinyint(1) DEFAULT NULL,
  `check_7_7_1` tinyint(1) DEFAULT NULL,
  `check_7_7_2` tinyint(1) DEFAULT NULL,
  `check_7_8_1` tinyint(1) DEFAULT NULL,
  `check_7_9_1` tinyint(1) DEFAULT NULL,
  `check_7_9_2` tinyint(1) DEFAULT NULL,
  `check_7_9_3` tinyint(1) DEFAULT NULL,
  `check_7_9_4` tinyint(1) DEFAULT NULL,
  `check_7_10_1` tinyint(1) DEFAULT NULL,
  `check_7_10_2` tinyint(1) DEFAULT NULL,
  `check_7_10_3` tinyint(1) DEFAULT NULL,
  `check_7_11_1` tinyint(1) DEFAULT NULL,
  `check_7_12_1` tinyint(1) DEFAULT NULL,
  `check_7_13_1` tinyint(1) DEFAULT NULL,
  `check_7_14_1` tinyint(1) DEFAULT NULL,
  `check_7_15_1` tinyint(1) DEFAULT NULL,
  `check_7_16_1` tinyint(1) DEFAULT NULL,
  `check_7_17_1` tinyint(1) DEFAULT NULL,
  `check_7_18_1` tinyint(1) DEFAULT NULL,
  `check_7_19_1` tinyint(1) DEFAULT NULL,
  `check_7_19_2` tinyint(1) DEFAULT NULL,
  `check_7_19_3` tinyint(1) DEFAULT NULL,
  `check_7_19_4` tinyint(1) DEFAULT NULL,
  `check_7_20_1` tinyint(1) DEFAULT NULL,
  `check_7_20_2` tinyint(1) DEFAULT NULL,
  `check_7_21_1` tinyint(1) DEFAULT NULL,
  `check_99_1_1` tinyint(1) DEFAULT NULL,
  `check_99_1_2` tinyint(1) DEFAULT NULL,
  `check_99_1_3` tinyint(1) DEFAULT NULL,
  `check_99_2_1` tinyint(1) DEFAULT NULL,
  `check_9_9` tinyint(1) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_kumiai_jobtype_scope`
--

INSERT INTO `et_doc_kumiai_jobtype_scope` VALUES (1,1,2,2,1,1,2,1,1,2,2,1,2,1,2,1,2,1,1,2,1,1,2,2,1,2,2,2,2,2,1,2,1,2,1,2,1,2,1,2,2,1,1,2,1,2,1,2,1,2,2,2,2,2,2,2,1,2,1,2,2,2,2,1,2,1,2,2,2,2,1,2,1,2,1,2,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,2,2,2,2,2,1,2,2,2,2,2,2,1,2,2,2,2,1,2,2,2,1,2,2,1,2,2,2,2,1,'2024-07-11','sign_customer_name','sign_director_name',NULL,NULL,NULL,NULL,NULL,0),(2,2,1,1,1,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,1,1,'2024-09-10','test1','testt',NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_kumiai_sendingagency_pledge`
--

CREATE TABLE `et_doc_kumiai_sendingagency_pledge` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_kumiai_sendingagency_pledge`
--

INSERT INTO `et_doc_kumiai_sendingagency_pledge` VALUES (1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,3);

--
-- Table structure for table `et_doc_list_eligible_support_type1`
--

CREATE TABLE `et_doc_list_eligible_support_type1` (
  `name_registration` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_specific_skills` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `ge` text COLLATE utf8mb4_unicode_ci,
  `nr` text COLLATE utf8mb4_unicode_ci,
  `date_birth` text COLLATE utf8mb4_unicode_ci,
  `rcn` text COLLATE utf8mb4_unicode_ci,
  `imple` text COLLATE utf8mb4_unicode_ci,
  `pro` text COLLATE utf8mb4_unicode_ci,
  `no_pro` text COLLATE utf8mb4_unicode_ci,
  `code` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `telephone` text COLLATE utf8mb4_unicode_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_list_eligible_support_type1`
--

INSERT INTO `et_doc_list_eligible_support_type1` VALUES ('ABC会社','田中株式会社','[\"NGUYEN  VANA\",\"\\u5165\\u7ba1 \\u592a\\u90ce\",\"\\u4f50\\u85e4\",\"\\u6b66\\u6751\",null,null,null,null,null,null,null,null,null,null]','[\"\\u5973\",\"\\u7537\",\"\\u5973\",\"\\u5973\",null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null]','[\"2000-01-30\",\"1999-01-02\",\"2010-01-28\",\"2000-01-29\",null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",\"ABC123AAA\",\"ABC3333AAA\",\"ABC3333AAA\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"124144\",\"24545\",\"458-7856\",\"122222\",null,null,null,null,null,null,null,null,null,null]','[\"CHIBA\",\"\\u6771\\u4eac\",\"chiba\",\"chiba\",null,null,null,null,null,null,null,null,null,null]','[\"0829420111\",\"0146215\",\"2314525\",\"1224563\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-01-30 08:28:06',151,'2025-01-30 08:28:06',1,2,1),('株式会社ＡｌｐｈａＣｅｐ','島田建工株式会社','[\"NGUYEN VAN SON\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u7537\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1991-09-22\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"SA92594647ED\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"333-0834\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u57fc\\u7389\\u770c\\u5ddd\\u53e3\\u5e02\\u5927\\u5b57\\u5b89\\u884c\\u9818\\u6839\\u5cb8905\\u756a\\u5730\\u3000\\u30d3\\u30ec\\u30c3\\u30b8\\u30cf\\u30a6\\u30b9\\u6839\\u5cb8\\uff11\\u53f7\\u68df107\\u53f7\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"070-8957-5611\",null,null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-03 10:11:29',151,'2025-04-03 10:11:29',2,2,2);

--
-- Table structure for table `et_doc_list_of_accepted_to_residents`
--

CREATE TABLE `et_doc_list_of_accepted_to_residents` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name_specific_skills_organization` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `female_male` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `dateb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `n_r` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `r_c_n` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `f_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `t_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `have_none` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_list_of_accepted_to_residents`
--

INSERT INTO `et_doc_list_of_accepted_to_residents` VALUES (1,'2024-12-03','0','0','[\"asdasdas\",\"asdasdad\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"2\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2024-11-11\",\"2024-11-11\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"asdasd123\",\"asdasd\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"sdfsdfsdf\",\"asdasdas\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2024-01-11\",null,null,null,null,\"0020-03-12\",null,null,null,null,null,null,null,null,null]','[\"2024-11-11\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"2\",null,null,null,\"2\",null,null,null,null,null,null,null,null,null]',NULL,NULL,'2024-12-03 03:06:25',1,'2024-12-03 03:06:25',1,5),(2,'2024-12-18','ONO','take','[\"\\u7530\\u4e2d\",\"\\u30aa\\u30aa\\u30ce\",\"\\u9234\\u6728\",\"TAKAI\",\"SUNI\",\"SONU\",\"TAKEI\",null,null,null,null,null,null,null,null]','[\"\\u7537\\u6027\",\"\\u7537\\u6027\",\"\\u5973\\u6027\",\"\\u7537\\u6027\",\"\\u7537\\u6027\",\"\\u5973\\u6027\",\"\\u7537\\u6027\",null,null,null,null,null,null,null,null]','[\"1985-10-01\",\"1998-01-13\",\"1986-01-02\",\"1998-01-14\",\"1998-01-08\",\"1989-01-16\",\"1990-01-09\",null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u65e5\\u672c\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",null,null,null,null,null,null,null,null]','[\"AB12345678CD\",\"Akafglakhgfla23\",\"A75354240AD\",\"A75354240EA\",\"A75354240EN\",\"A75354240OK\",\"A7535424KB\",null,null,null,null,null,null,null,null]','[\"2024-12-03\",\"2025-01-07\",\"2025-01-07\",\"2025-01-05\",\"2025-01-02\",\"2025-01-02\",\"2025-01-21\",null,null,null,null,null,null,null,null]','[\"2024-12-31\",\"2025-01-15\",\"2025-01-24\",\"2028-01-31\",\"2029-01-28\",\"2030-01-08\",\"2030-01-22\",null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"1\",\"2\",\"2\",\"1\",\"2\",null,null,null,null,null,null,null,null]',NULL,NULL,'2024-12-18 06:45:12',151,'2024-12-18 06:45:12',1,13),(3,'2025-03-11','島田建工 株式会社','オオノ','[\"\\u5165\\u7ba1 \\u82b1\\u5b50\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u7537\\u6027\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2000-03-11\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"AB12345678CD\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2000-03-10\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2025-03-10\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-03-11 09:38:50',NULL,'2025-03-11 09:38:50',2,0);

--
-- Table structure for table `et_doc_list_people_eligible_support_type1`
--

CREATE TABLE `et_doc_list_people_eligible_support_type1` (
  `name_specific_skills` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` text COLLATE utf8mb4_unicode_ci,
  `ge` text COLLATE utf8mb4_unicode_ci,
  `nr` text COLLATE utf8mb4_unicode_ci,
  `date_birth` text COLLATE utf8mb4_unicode_ci,
  `rcn` text COLLATE utf8mb4_unicode_ci,
  `imple` text COLLATE utf8mb4_unicode_ci,
  `pro` text COLLATE utf8mb4_unicode_ci,
  `no_pro` text COLLATE utf8mb4_unicode_ci,
  `code` text COLLATE utf8mb4_unicode_ci,
  `address` text COLLATE utf8mb4_unicode_ci,
  `telephone` text COLLATE utf8mb4_unicode_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_list_people_eligible_support_type1`
--

INSERT INTO `et_doc_list_people_eligible_support_type1` VALUES ('田中株式会社','[\"NGUYEN  VANA\",\"\\u5165\\u7ba1 \\u592a\\u90ce\",\"\\u4f50\\u85e4\",\"\\u6b66\\u6751\",null,null,null,null,null,null,null,null,null,null]','[\"\\u5973\",\"\\u7537\",\"\\u5973\",\"\\u5973\",null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null]','[\"2000-01-30\",\"1999-01-02\",\"2010-01-28\",\"2000-01-29\",null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",\"ABC123AAA\",\"ABC3333AAA\",\"ABC3333AAA\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"124144\",\"24545\",\"458-7856\",\"122222\",null,null,null,null,null,null,null,null,null,null]','[\"CHIBA\",\"\\u6771\\u4eac\",\"chiba\",\"chiba\",null,null,null,null,null,null,null,null,null,null]','[\"0829420111\",\"0146215\",\"2314525\",\"1224563\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-01-30 08:28:06',151,'2025-01-30 08:28:06',1,2,1),(NULL,'[\"\\u5165\\u7ba1 \\u82b1\\u5b50\",\"\\u5165\\u7ba1 \\u592a\\u90ce\",\"\\u9234\\u6728\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5973\",\"\\u7537\",\"\\u5973\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null]','[\"2001-02-04\",\"2000-02-11\",\"2022-02-18\",null,null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",\"ABC123AAA\",\"ABC3333AAA\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"124144\",\"456-7593\",\"458-7856\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u6771\\u4eac\",\"\\u5343\\u8449\",\"chiba\",null,null,null,null,null,null,null,null,null,null,null]','[\"AAAAA\",\"0146215\",\"2314525\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-02-04 16:09:41',151,'2025-02-04 16:09:41',1,2,2),('Karen Okoshi','[\"Karen Okoshi\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"Sakigaoka 2-24-22\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"07084848455\",null,null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-03-29 10:55:36',NULL,'2025-03-29 10:55:36',2,0,3);

--
-- Table structure for table `et_doc_list_received_life_consultation_services`
--

CREATE TABLE `et_doc_list_received_life_consultation_services` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name_specific_skills_organization` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `responsible_person` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `female_male` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `dateb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `n_r` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `r_c_n` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `f_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `t_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `have_none` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_list_received_life_consultation_services`
--

INSERT INTO `et_doc_list_received_life_consultation_services` VALUES (1,'2024-12-03','0','0','[\"asdasdas\",\"asdasdad\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"2\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2024-11-11\",\"2024-11-11\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"asdasd123\",\"asdasd\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"sdfsdfsdf\",\"asdasdas\",null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2024-01-11\",null,null,null,null,\"0020-03-12\",null,null,null,null,null,null,null,null,null]','[\"2024-11-11\",null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"2\",null,null,null,\"2\",null,null,null,null,null,null,null,null,null]',NULL,NULL,'2024-12-03 03:06:25',1,'2024-12-03 03:06:25',1,5),(2,'2025-01-03','nipon akabane 株式会社','áđâsd','[\"\\u5165\\u7ba1 \\u82b1\\u5b50\",\"\\u30aa\\u30aa\\u30ce\",\"SUGITA\",\"\\u6b66\\u6751\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5973\\u6027\",\"\\u7537\\u6027\",\"\\u7537\\u6027\",\"\\u5973\\u6027\",null,null,null,null,null,null,null,null,null,null,null]','[\"1990-12-18\",\"1978-01-14\",\"2000-01-23\",\"1990-02-11\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u65e5\\u672c\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",null,null,null,null,null,null,null,null,null,null,null]','[\"AB12345678CD\",\"AB1537737CD\",\"A75354240AD\",\"A75354240EA\",null,null,null,null,null,null,null,null,null,null,null]','[\"2025-01-01\",\"2025-01-13\",\"2025-01-30\",\"2025-02-05\",null,null,null,null,null,null,null,null,null,null,null]','[\"2028-08-23\",\"2028-01-05\",\"2027-01-23\",\"2025-07-22\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u3042\\u3070\\u4f1a\\u793e\",\"OKE\\u4f1a\\u793e\",\"\\u6634\\u4f1a\\u793e\",null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2024-12-18 08:04:57',151,'2024-12-18 08:04:57',1,13);

--
-- Table structure for table `et_doc_minister_statement_reasons`
--

CREATE TABLE `et_doc_minister_statement_reasons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_1` int DEFAULT NULL,
  `check_1_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `check_2` int DEFAULT NULL,
  `check_2_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `check_3` tinyint(1) DEFAULT NULL,
  `check_3_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_minister_statement_reasons`
--

INSERT INTO `et_doc_minister_statement_reasons` VALUES (1,'name',1,'これはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわを\r\nこれはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。\r\nこれはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。\r\nこれはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。',0,'これはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。',0,'これはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。',NULL,NULL,NULL,NULL,NULL,0),(2,NULL,0,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_multiple_job_reasons`
--

CREATE TABLE `et_doc_multiple_job_reasons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_job_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_job_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `second_job_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `second_job_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `second_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `third_job_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `third_job_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `third_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reason_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `main_job_type_id` bigint DEFAULT NULL,
  `second_job_type_id` bigint DEFAULT NULL,
  `third_job_type_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_multiple_job_reasons`
--

INSERT INTO `et_doc_multiple_job_reasons` VALUES (1,'name','2','耕種農業','施設園芸','4','耕種農業','果 樹','20','養殖業','ほたてがい・まがき養殖','これはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。 これはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。\r\nこれはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。\r\nこれはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。\r\nこれはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。','これはテスト用のランダムな日本語の文字列です。意味は特にありませんが、文字数を確認するために使用できます。あいうえおかきくけこさしすせそたちつてとなにぬねのはひふへほまみむめもやゆよらりるれろわをん。',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(2,NULL,NULL,'耕種農業','畑作・野菜',NULL,'漁船漁業','かつお一本釣り漁業',NULL,'漁船漁業','ひき網漁業',NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_notification_acceptance_activity_status`
--

CREATE TABLE `et_doc_notification_acceptance_activity_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quarter` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `corporate_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified_skilled_foreign_1` int DEFAULT NULL,
  `specified_skilled_foreign_2` int DEFAULT NULL,
  `specified_skilled_foreign_3` int DEFAULT NULL,
  `specified_skilled_foreign_4` int DEFAULT NULL,
  `specified_skilled_foreign_5` int DEFAULT NULL,
  `specified_skilled_foreign_6` int DEFAULT NULL,
  `application_worker_1` int DEFAULT NULL,
  `application_worker_2` int DEFAULT NULL,
  `regarding_social_insurance_1` int DEFAULT NULL,
  `regarding_social_insurance_2` int DEFAULT NULL,
  `regarding_social_insurance_3` int DEFAULT NULL,
  `social_insurance_premium_1` int DEFAULT NULL,
  `social_insurance_premium_2` int DEFAULT NULL,
  `tax_payment_status_1` int DEFAULT NULL,
  `tax_payment_status_2` int DEFAULT NULL,
  `tax_payment_status_3` int DEFAULT NULL,
  `tax_payment_status_4` int DEFAULT NULL,
  `safety_health_status_1` int DEFAULT NULL,
  `safety_health_status_2` int DEFAULT NULL,
  `name_specific_skills_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_create_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `spec` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `spec_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `empl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `foreign` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `enga` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `same` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `those` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `any_format` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `costs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `expenses` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `share` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `people` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `other_eligibility_matters` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `office` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cell_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_acceptance_activity_status`
--

INSERT INTO `et_doc_notification_acceptance_activity_status` VALUES (1,'2024','1030001082950','建設分野','しまだ けんこう かぶしきがいしゃ','埼玉県川口市木曽呂１６７番地の３','048－452－8015',1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,'ABC会社','上野','058-789-1555','アン','2025-01-01',NULL,NULL,151,NULL,1,21,'島田建工 株式会社','333－0831','[\"1\",null,null,null,null]','[\"0\",null,null]','[\"3\",null,null]','[null,\"1\",null]','[null,null,null]','[null,null,null]','[\"4\",\"1\",null]','4','','30000','1',NULL,NULL,NULL,NULL,NULL,'','入江省吾','代表取締役','048-452-8015',NULL),(2,'2025','01234567890','外食業分野','かぶしきがいしゃ にゅうかん','東京都港区港南５丁目５番３０号','０３５７９６７１２５',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,150,NULL,2,3,'株式会社 入管','１０８８２５５','[null,\"[null,null,null]\",null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','1','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),(3,'2024','1204530000001','建設分野','nakano','大阪府新宿区３－１０－６','082-9420000',NULL,NULL,1,NULL,NULL,NULL,1,NULL,NULL,1,NULL,NULL,1,NULL,NULL,1,NULL,1,NULL,'TANAKA会社','入江 省吾','0826464','入江 省吾','2025-03-12',NULL,NULL,151,NULL,2,6,'入管 太郎','033-1244','[\"1\",\"2\",null,null,null]','[\"0\",null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','4','','10000','1','3000','3000','1','1','10','','オオノ','代表取締役 takao','０３－５７９６－７１２５','０９０－１２３４－５６７８'),(4,'2025','7040002032551','建設分野','ゆうげんがいしゃ　いたくらどぼく','千葉県市川市柏井町２ー６８０−５','047-338-5986',1,NULL,NULL,NULL,NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,1,NULL,1,NULL,1,NULL,'有限会社　板倉土木','板倉 信広','047-338-5986',NULL,'2025-04-07',NULL,NULL,151,NULL,2,6,'有限会社　板倉土木','272 - 0802','[\"2\",null,null,null,null]','[\"0\",null,null]','[\"2\",null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[\"4\",null,null]','1','','20000','2',NULL,NULL,NULL,NULL,NULL,'','板倉 信広','代表取締役','047-338-5986',NULL),(5,'2024',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,NULL,'[null,null,null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),(6,'1','1','1','1','1','1',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0,'1','1','[\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\"]','[\"1\",\"1\",null]','1','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),(7,'2025',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,NULL,'[null,null,null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),(8,'2025','hjfj',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,151,NULL,2,2,NULL,NULL,'[null,null,null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','khgkkd','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),(9,'2025','7040002032551','建設分野','ゆうげんがいしゃ　いたくらどぼく','千葉県市川市柏井町2-680-5','047-338-5986',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,'有限会社　板倉土木','板倉 信広','047-338-5986',NULL,'2025-04-08',NULL,NULL,151,NULL,2,2,'有限会社　板倉土木','272-0802','[\"2\",null,null,null,null]','[\"0\",null,null]','[\"2\",null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','１','','20000','2',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),(10,'2024','0123456789012','外食業分野','かぶしきがいしゃ にゅうかん','東京都港区港南５丁目５番３０号','０３５７９６７１２５',1,NULL,NULL,1,NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,1,NULL,1,NULL,1,NULL,'株式会社 入管','入管 太郎','０３－５７９６－７１２５','入管 太郎','2021-04-01',NULL,NULL,150,NULL,2,63,'株式会社 入管','１０８８２５５','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"6\",\"7\",\"8\"]','[\"11\",\"12\",\"13\"]','[\"15\",\"16\",\"17\"]','[\"19\",\"20\",\"21\"]','[\"23\",\"24\",\"25\"]','[\"27\",\"28\",null]','1','','300000','3','120000','22000','1','1','0','','入管 太郎','代表取締役','０３５７９６７１２５','０９０１２３４５６７８'),(11,'2024','1234567891234','外食業分野','かぶしきがいしゃ にゅうかん','東京都港区港南５丁目５番３０号','０３－５７９６－７１２５',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'株式会社 入管','入管 太郎','０３－５７９６－７１２５',NULL,NULL,NULL,NULL,NULL,NULL,2,0,'株式会社 入管','１０８－８２５５','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"6\",\"7\",\"8\"]','[\"11\",\"12\",\"13\"]','[\"15\",\"16\",\"17\"]','[\"19\",\"20\",\"21\"]','[\"23\",\"24\",\"25\"]','[\"27\",\"28\",null]','1','','10000','1','20000','30000','4','5','6','','入管 太郎','代表取締役','０３－５７９６－７１２５','０９０－１２３４－５６７８'),(12,'2025','0123456789123','外食業分野','かぶしきがいしゃ にゅうかん','東京都港区港南５丁目５番３０号','０３－５７９６－７１２５',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'株式会社 入管','入管 太郎','０３－５７９６－７１２５',NULL,NULL,NULL,NULL,NULL,NULL,2,0,'株式会社 入管','１０８－８２５５','[\"1\",\"2\",\"3\",\"4\",\"5\"]','[\"6\",\"7\",\"8\"]','[\"11\",\"12\",\"13\"]','[\"15\",\"16\",\"17\"]','[\"19\",\"20\",\"21\"]','[\"23\",\"24\",\"25\"]','[\"27\",\"28\",null]','1','','10000','2','30000','40000','5','6','7','','入管 太郎','代表取締役','０３－５７９６－７１２５','０９０－１２３４－５６７８'),(13,'2025','1204530000001','建設分野','ABCKCOMPANY','大阪府新宿区３－１０－６','082-9420000',1,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,'ABC会社','入江 省吾','08294322','入江 省吾','2025-04-23',NULL,NULL,151,NULL,2,1,'島田建工 株式会社','033-1244','[\"1\",null,null,null,null]','[\"2\",null,null]','[\"\\uff13\",null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[\"\\uff14\",null,null]','1','','30000','1','3000','3000','1','1','10','','農園 太郎','代表取締役','048-452-8015','０９０－１２３４－５６７８'),(14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,151,NULL,2,2,NULL,NULL,'[\"12\",\"12\",\"12\",\"12\",\"12\"]','[\"12\",\"12\",\"12\"]','[\"12\",\"12\",\"12\"]','[\"12\",\"12\",\"12\"]','[\"12\",\"12\",\"12\"]','[\"12\",\"12\",\"12\"]','[\"12\",\"12\",null]',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_notification_activity_status`
--

CREATE TABLE `et_doc_notification_activity_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quarter` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `corporate_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_field` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified_skilled_foreign_1` int DEFAULT NULL,
  `specified_skilled_foreign_2` int DEFAULT NULL,
  `specified_skilled_foreign_3` int DEFAULT NULL,
  `specified_skilled_foreign_4` int DEFAULT NULL,
  `specified_skilled_foreign_5` int DEFAULT NULL,
  `specified_skilled_foreign_6` int DEFAULT NULL,
  `application_worker_1` int DEFAULT NULL,
  `application_worker_2` int DEFAULT NULL,
  `regarding_social_insurance_1` int DEFAULT NULL,
  `regarding_social_insurance_2` int DEFAULT NULL,
  `regarding_social_insurance_3` int DEFAULT NULL,
  `social_insurance_premium_1` int DEFAULT NULL,
  `social_insurance_premium_2` int DEFAULT NULL,
  `tax_payment_status_1` int DEFAULT NULL,
  `tax_payment_status_2` int DEFAULT NULL,
  `tax_payment_status_3` int DEFAULT NULL,
  `tax_payment_status_4` int DEFAULT NULL,
  `safety_health_status_1` int DEFAULT NULL,
  `safety_health_status_2` int DEFAULT NULL,
  `name_specific_skills_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_create_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `spec` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `spec2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `empl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `foreign` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `enga` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `same` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `those` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `any_format` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `costs` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `expenses` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `share` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `people` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `other_eligibility_matters` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `full_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_title` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `office` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cell_phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_activity_status`
--

INSERT INTO `et_doc_notification_activity_status` VALUES (1,'2024','1030001082950','建設分野','しまだ けんこう かぶしきがいしゃ','埼玉県川口市木曽呂１６７番地の３','048－452－8015',1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,'島田建工 株式会社','入江省吾','058-789-1555','入江省吾','2025-01-14',NULL,NULL,151,NULL,1,26,'島田建工 株式会社','333－0831','[\"1\",\"0\",null,null,null]','[\"0\",null,null]','[\"3\",null,null]','[null,\"1\",null]','[null,null,null]','[null,null,null]','[\"4\",\"1\",null]','4','','30000','1','3000','3000','1','1','0','','入江省吾','代表取締役','048-452-8015','０９０－１２３４－５６７８');

--
-- Table structure for table `et_doc_notification_change_employment_contract`
--

CREATE TABLE `et_doc_notification_change_employment_contract` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_change` date DEFAULT NULL,
  `employment_contract_period` tinyint DEFAULT NULL,
  `place_of_employment` tinyint DEFAULT NULL,
  `content_of_work` tinyint DEFAULT NULL,
  `working_hours_etc` tinyint DEFAULT NULL,
  `holiday` tinyint DEFAULT NULL,
  `vacation` tinyint DEFAULT NULL,
  `wages` tinyint DEFAULT NULL,
  `retirement_related_matters` tinyint DEFAULT NULL,
  `other` tinyint DEFAULT NULL,
  `legal_person_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_of_the_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int DEFAULT NULL,
  `gt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code1` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_change_employment_contract`
--

INSERT INTO `et_doc_notification_change_employment_contract` VALUES (2,'VO THI THU THUY','1987-11-20','ベトナム','東京都千代田区霞が関１丁目１番１号　霞ヶ関ハイツ２０２号','AB12345678CD','介護','身体介護等','2024-11-20',1,0,0,0,0,0,1,0,0,'1234567891234','株式会社ABC','東京都新宿区西新宿1-2-3','武村由紀子','08294322','アン','2024-11-20','2024-11-20 00:00:00',NULL,1,'2024-11-26 00:00:00',1,3,NULL,NULL,NULL),(3,'VO THI THU THUY','1987-12-30','ベトナム','東京都千代田区霞が関１丁目１番１号　霞ヶ関ハイツ２０２号','AB12340078CD','介護','身体介護等','2025-01-01',1,0,0,0,0,0,0,0,0,'4578434000012','株式会社ABC','東京都新宿区西新宿1-2-3','武村由紀子','08294322','アン','2025-01-09','2024-12-30 00:00:00',NULL,151,'2025-01-11 00:00:00',1,6,'女','124144','24545'),(4,'VO THI THU THUY','2025-02-01','ベトナム','東京都千代田区霞が関１丁目１番１号　霞ヶ関ハイツ２０２号','A12425366770','外食業','接客','2025-01-29',1,0,0,0,0,0,0,0,0,'1204012210012','ABC会社','千葉県','武村由紀子','08524544','nakano','2025-01-30','2025-02-01 00:00:00',NULL,151,'2025-02-01 00:00:00',1,5,'female','123456','123456');

--
-- Table structure for table `et_doc_notification_change_register_information`
--

CREATE TABLE `et_doc_notification_change_register_information` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `registration_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_person_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_of_the_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reason_for_filing` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `A_changes_B_changes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previous_content_C_change` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `later_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_change` date DEFAULT NULL,
  `signature_the_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_of_filing` date DEFAULT NULL,
  `contact_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `c_changes` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_change_register_information`
--

INSERT INTO `et_doc_notification_change_register_information` VALUES (2,'registration_number','legal_person_number',NULL,'name_of_the_institution','agency_address',NULL,'A_changes_B_changes','previous_content_C_change',NULL,'2024-10-06','signature_the_person','2024-10-06','contact_name','telephone_number','c_changes',NULL,NULL,NULL,NULL,1,0,NULL),(3,'registration_number','legal_person_number',NULL,'name_of_the_institution','agency_address',NULL,'A_changes_B_changes','previous_content_C_change',NULL,'2024-10-06','signature_the_person','2024-10-06','contact_name','telephone_number','c_changes',NULL,NULL,NULL,NULL,1,0,NULL),(4,'19登-○○○○','1234567890123',NULL,'法務協同組合','○○県○○市○○町2－2',NULL,'氏名又は名称，住所，代表者の氏名，支援を行う事務所 支援業務の内容及びその実施方法，支援業務を開始する予定年月日，対応可能言語','入管協同組合',NULL,'2025-01-01','法務　花子','2025-01-01','法務　次郎','085-457-4165','（氏名又は名称）法務協同組合 （住所）〒111-1111　○○県○○市○○町2-2　23-4567-8901 （代表者の氏名）法務　花子 　（支援を行う事務所）①〒111-1111　○○県○○市○○町3-3 　　　　　　　　　　　　　 ②〒111-1111　○○県○○市○○町4-4（※事務所を追加した場合） （支援業務の内容及びその実施方法）△△△△△の支援について追加 　（支援業務を開始する予定年月日）20×△年×△月×△日 　（対応可能言語）英語，中国語，ベトナム語，スペイン語，ポルトガル語',NULL,NULL,151,NULL,1,8,'１１１－１１１１'),(5,'AAAAAAAAAAA','4578434000012',NULL,'株式会社ABC','東京都新宿区西新宿1-2-3',NULL,'gflasfhg;àh','gf;oafh;à',NULL,'2025-01-08','tanaka','2025-01-01','suzuki','toyota','fsafgpasoufpa',NULL,NULL,NULL,NULL,1,0,NULL),(6,'1897','1234567891234',NULL,'株式会社ABC','東京都新宿区西新宿1-2-3',NULL,'氏名又は名称，住所，代表者の氏名，支援を行う事務所 支援業務の内容及びその実施方法，支援業務を開始する予定年月日，対応可能言語','入管協同組合',NULL,'2025-02-05','法務　花子','2025-02-06','高橋','111789010000','任意的支援実施予定なし',NULL,NULL,NULL,NULL,1,0,'0058'),(7,'1897','1234567891234',NULL,'株式会社ABC','0',NULL,'0','0',NULL,'2025-02-25','0','2025-02-25','0','0','0',NULL,NULL,NULL,NULL,1,0,NULL),(8,'679548','4578434000012',NULL,'株式会社ABC','東京都新宿区西新宿1-2-3',NULL,'氏名又は名称，住所，代表者の氏名，支援を行う事務所 支援業務の内容及びその実施方法，支援業務を開始する予定年月日，対応可能言語','入管協同組合',NULL,'2025-03-10','法務　花子','2025-03-10','suzuki','012-345-678','任意的支援実施予定なし',NULL,NULL,151,NULL,2,1,'033-1244');

--
-- Table structure for table `et_doc_notification_change_support`
--

CREATE TABLE `et_doc_notification_change_support` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_change` date DEFAULT NULL,
  `employment_contract_period` tinyint DEFAULT NULL,
  `place_of_employment` tinyint DEFAULT NULL,
  `content_of_work` tinyint DEFAULT NULL,
  `working_hours_etc` tinyint DEFAULT NULL,
  `holiday` tinyint DEFAULT NULL,
  `vacation` tinyint DEFAULT NULL,
  `wages` tinyint DEFAULT NULL,
  `retirement_related_matters` tinyint DEFAULT NULL,
  `other` tinyint DEFAULT NULL,
  `legal_person_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_of_the_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_change_support`
--

INSERT INTO `et_doc_notification_change_support` VALUES (2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(3,'nguyen van a','1985-05-08','ベトナム','ホーチミン市','123456789','農業','豚','2024-12-12',1,1,1,1,1,1,1,1,1,'123456789','株式会社あいうえお','千葉県鎌ヶ谷市北中沢','おおこし花蓮','141256357895','大越カレン','2024-12-24',NULL,NULL,NULL,NULL,1,0),(4,'ádasdasd','1990-01-02','ベトナム','東京都千代田区霞が関１丁目１番１号　霞ヶ関ハイツ２０２号','AB452476CD','介護','身体介護等','2025-01-02',1,0,0,0,0,0,0,0,0,'4578434000012','株式会社ABC','東京都新宿区西新宿1-2-3','武村由紀子','058-789-1555','ＴＡＮＡＫＡ','2025-01-02',NULL,NULL,151,NULL,1,3);

--
-- Table structure for table `et_doc_notification_change_support_contract`
--

CREATE TABLE `et_doc_notification_change_support_contract` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_change` date DEFAULT NULL,
  `commission_fee` tinyint DEFAULT NULL,
  `commission_fee_before` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `commission_fee_after` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contract_period` tinyint DEFAULT NULL,
  `contract_period_before` date DEFAULT NULL,
  `contract_period_after` date DEFAULT NULL,
  `change_matter_other` tinyint DEFAULT NULL,
  `change_matter_other_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_person_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `registration_support_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `registration_support_persion_number` int DEFAULT NULL,
  `registration_support_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `registration_support_agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_change_support_contract`
--


--
-- Table structure for table `et_doc_notification_difficulties_acceptance`
--

CREATE TABLE `et_doc_notification_difficulties_acceptance` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills_organization` tinyint DEFAULT NULL,
  `foreigners_circumstances` tinyint DEFAULT NULL,
  `class_reason_1` tinyint DEFAULT NULL,
  `class_reason_2` tinyint DEFAULT NULL,
  `class_reason_3` tinyint DEFAULT NULL,
  `class_reason_other` tinyint DEFAULT NULL,
  `class_reason_date_occurrence` date DEFAULT NULL,
  `overview_case` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cause_1` tinyint DEFAULT NULL,
  `cause_2` tinyint DEFAULT NULL,
  `cause_3` tinyint DEFAULT NULL,
  `cause_4` tinyint DEFAULT NULL,
  `cause_5` tinyint DEFAULT NULL,
  `cause_other` tinyint DEFAULT NULL,
  `date_occurrence` date DEFAULT NULL,
  `overview_case_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `skilled_foreign_workers_1` tinyint DEFAULT NULL,
  `skilled_foreign_workers_2` tinyint DEFAULT NULL,
  `intention_continue_activities_1` tinyint DEFAULT NULL,
  `intention_continue_activities_2` tinyint DEFAULT NULL,
  `intention_continue_activities_3` tinyint DEFAULT NULL,
  `intention_continue_activities_4` tinyint DEFAULT NULL,
  `intention_continue_activities_5` tinyint DEFAULT NULL,
  `intention_continue_activities_other` tinyint DEFAULT NULL,
  `measures_1` tinyint DEFAULT NULL,
  `measures_2` tinyint DEFAULT NULL,
  `measures_3` tinyint DEFAULT NULL,
  `measures_4` tinyint DEFAULT NULL,
  `measures_other` tinyint DEFAULT NULL,
  `notification_agency_person_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_difficulties_acceptance`
--


--
-- Table structure for table `et_doc_notification_illegal_grossly`
--

CREATE TABLE `et_doc_notification_illegal_grossly` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_discovered` date DEFAULT NULL,
  `date_fraud_occurred` date DEFAULT NULL,
  `type_fraud_1` tinyint DEFAULT NULL,
  `type_fraud_2` tinyint DEFAULT NULL,
  `type_fraud_3` tinyint DEFAULT NULL,
  `type_fraud_4` tinyint DEFAULT NULL,
  `type_fraud_5` tinyint DEFAULT NULL,
  `type_fraud_6` tinyint DEFAULT NULL,
  `type_fraud_7` tinyint DEFAULT NULL,
  `type_fraud_8` tinyint DEFAULT NULL,
  `type_fraud_9` tinyint DEFAULT NULL,
  `type_fraud_10` tinyint DEFAULT NULL,
  `type_fraud_11` tinyint DEFAULT NULL,
  `type_fraud_12` tinyint DEFAULT NULL,
  `beginning_1` tinyint DEFAULT NULL,
  `beginning_2` tinyint DEFAULT NULL,
  `beginning_3` tinyint DEFAULT NULL,
  `beginning_4` tinyint DEFAULT NULL,
  `specific_details_misconduct` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `corresponde_category_1` tinyint DEFAULT NULL,
  `corresponde_category_2` tinyint DEFAULT NULL,
  `response_results` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_person_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `gt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_illegal_grossly`
--

INSERT INTO `et_doc_notification_illegal_grossly` VALUES (1,'VO THI THU THUY','1989-12-23','ベトナム','クアンナム','AB452476CD00','農業','木を込みます','2024-12-30','2024-12-30',1,0,0,0,0,0,0,0,0,1,1,0,0,0,0,0,'２０１９年１０月分の給与が未払い',1,0,'１２月○日に１０月分給与全額を対象者名義の口座に振り込んだ','2548100012351','ABC株式会社','東京都新宿区西新宿1-3-5','鈴木','080-345-2154','tânka','2024-12-17',NULL,NULL,151,NULL,1,5,'女','124-144','456-7593');

--
-- Table structure for table `et_doc_notification_of_acceptance_and_activity_status`
--

CREATE TABLE `et_doc_notification_of_acceptance_and_activity_status` (
  `fn` text COLLATE utf8mb4_unicode_ci,
  `nr` text COLLATE utf8mb4_unicode_ci,
  `date` text COLLATE utf8mb4_unicode_ci,
  `m` text COLLATE utf8mb4_unicode_ci,
  `f` text COLLATE utf8mb4_unicode_ci,
  `rcn` text COLLATE utf8mb4_unicode_ci,
  `co` text COLLATE utf8mb4_unicode_ci,
  `adr` text COLLATE utf8mb4_unicode_ci,
  `c` text COLLATE utf8mb4_unicode_ci,
  `n` text COLLATE utf8mb4_unicode_ci,
  `a` text COLLATE utf8mb4_unicode_ci,
  `b` text COLLATE utf8mb4_unicode_ci,
  `d` text COLLATE utf8mb4_unicode_ci,
  `e` text COLLATE utf8mb4_unicode_ci,
  `apa` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `ada` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `tapa` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `npaa` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `lda` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `a1` text COLLATE utf8mb4_unicode_ci,
  `b1` text COLLATE utf8mb4_unicode_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint NOT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  `apb` text COLLATE utf8mb4_unicode_ci,
  `adb` text COLLATE utf8mb4_unicode_ci,
  `tapb` text COLLATE utf8mb4_unicode_ci,
  `npab` text COLLATE utf8mb4_unicode_ci,
  `ldb` text COLLATE utf8mb4_unicode_ci,
  `ldc` text COLLATE utf8mb4_unicode_ci,
  `npac` text COLLATE utf8mb4_unicode_ci,
  `tapc` text COLLATE utf8mb4_unicode_ci,
  `adc` text COLLATE utf8mb4_unicode_ci,
  `apc` text COLLATE utf8mb4_unicode_ci,
  `ldd` text COLLATE utf8mb4_unicode_ci,
  `npad` text COLLATE utf8mb4_unicode_ci,
  `tapd` text COLLATE utf8mb4_unicode_ci,
  `add` text COLLATE utf8mb4_unicode_ci,
  `apd` text COLLATE utf8mb4_unicode_ci,
  `name_specific_skills` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_notification_of_acceptance_and_activity_status`
--

INSERT INTO `et_doc_notification_of_acceptance_and_activity_status` VALUES ('[\"VO THI THU THUY \\u00e1\",\"\\u7530\\u4e2d\",\"shdj\",\"gdggdfh\",null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"dgdghg\",null,null,null,null,null,null,null,null]','[\"2000\\u5e747\\u670817\\u65e5\",\"2000\\u5e741\\u670812\\u65e5\",\"\\uff12\\uff10\\uff10\\uff11\\u5e74\\uff11\\u6708\\uff12\\uff10\\u65e5\",\"\\uff12\\uff10\\uff10\\uff10\\u5e74\\uff11\\u6708\\uff17\\u65e5\",null,null,null,null,null,null,null,null]','[null,\"1\",null,\"1\",null,null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,null,null,null,null,null,null,null,null]','[\"ABC123456782\",\"ABC12345ASAD\",\"AVJDGKA1435665\",\"\\uff44\\uff4a\\uff48\\uff46\\uff4b\\uff47\",null,null,null,null,null,null,null,null]','[\"123\",\"123-456\",\"123455\",\"134\",null,null,null,null,null,null,null,null]','[\"456\",\"\\u6771\\u4eac\\u90fd\",\"chiba\",\"\\u57fc\\u7389\\u770c\",null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,\"1\",null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",\"1\"]','[null,\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"2\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"2\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-01-28 04:48:00',151,'2025-01-30 05:43:52',1,5,1,'[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"3\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"4\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"5\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]',NULL),('[\"\\u00e1\\u0111\\u00e1\",\"AAA\",null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",null,null,null,null,null,null,null,null,null,null]','[\"2000\\u5e741\\u67083\\u65e5\",\"2001\\u5e741\\u670810\\u65e5\",null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",\"ABC123AAA\",null,null,null,null,null,null,null,null,null,null]','[\"123-458\",\"245-458\",null,null,null,null,null,null,null,null,null,null]','[\"tokyo\",\"\\u5343\\u8449\\u770c\",null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,\"1\",null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"4\",null,null,null,null,null,null,null,null,null,null]','[\"20\",\"20\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"200000\",null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"30000\",null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-02-04 15:28:57',151,'2025-02-04 16:01:56',1,3,2,'[\"2\",\"5\",null,null,null,null,null,null,null,null,null,null]','[\"25\",\"25\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"300000\",null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"20000\",null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"10000\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"500000\",null,null,null,null,null,null,null,null,null,null]','[\"23\",\"23\",null,null,null,null,null,null,null,null,null,null]','[\"3\",\"6\",null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"600000\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"10000000\",null,null,null,null,null,null,null,null,null,null]','[\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\"]','[\"411111111111111111\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\"]',NULL),('[\"THUY\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null]','[\"2000\\u5e743\\u670815\\u65e5\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",null,null,null,null,null,null,null,null,null,null,null]','[\"123-458\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5343\\u8449\\u770c\\u7a32\\u6bdb\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"3\",null,null,null,null,null,null,null,null,null,null,null]','[\"10\",null,null,null,null,null,null,null,null,null,null,null]','[\"300000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20000\",null,null,null,null,null,null,null,null,null,null,null]','[\"10000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-03-20 05:16:55',151,'2025-03-20 05:25:04',2,1,3,'[\"\\uff14\",null,null,null,null,null,null,null,null,null,null,null]','[\"10\",null,null,null,null,null,null,null,null,null,null,null]','[\"300000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20000\",null,null,null,null,null,null,null,null,null,null,null]','[\"30000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20000\",null,null,null,null,null,null,null,null,null,null,null]','[\"300000\",null,null,null,null,null,null,null,null,null,null,null]','[\"10\",null,null,null,null,null,null,null,null,null,null,null]','[\"5\",null,null,null,null,null,null,null,null,null,null,null]','[\"60000\",null,null,null,null,null,null,null,null,null,null,null]','[\"60000\",null,null,null,null,null,null,null,null,null,null,null]','[\"900000\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,NULL),('[\"NGUYEN VAN\\u3000SON\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-04 02:08:02',NULL,'2025-04-04 02:08:02',2,0,4,'[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,NULL),('[\"NGUYEN VAN GIAP\",\"NGUYEN VAN VUONG\",null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null]','[\"1994\\u5e7408\\u670805\\u65e5\",\"1996\\u5e7411\\u670806\\u65e5\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"UH00149188EA\",\"SA29079917ER\",null,null,null,null,null,null,null,null,null,null]','[\"272-0816\",\"272-0816\",null,null,null,null,null,null,null,null,null,null]','[\"\\u5343\\u8449\\u770c\\u5e02\\u5ddd\\u5e02\\u672c\\u5317\\u65b93\\u4e01\\u76ee9\\u756a4\\u53f7\\uff08\\u30bf\\u30a6\\u30f3\\u30cf\\u30a6\\u30b9\\u5e02\\u5dddA\\u30fc12\\uff09\",\"\\u5343\\u8449\\u770c\\u5e02\\u5ddd\\u5e02\\u672c\\u5317\\u65b93\\u4e01\\u76ee9\\u756a4\\u53f7\\uff08\\u30bf\\u30a6\\u30f3\\u30cf\\u30a6\\u30b9\\u5e02\\u5dddA\\u30fc12\\uff09\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,\"1\",\"1\"]','[null,null,null,null,null,null,null,null,null,null,\"1\",\"1\"]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"22\",\"20\",null,null,null,null,null,null,null,null,null,null]','[\"390,000\",\"303,375\",null,null,null,null,null,null,null,null,null,null]','[\"308,680\",\"220,704\",null,null,null,null,null,null,null,null,null,null]','[\"81,320\",\"82,671\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-04 07:41:19',151,'2025-04-05 08:56:59',2,9,5,'[\"2\",\"2\",null,null,null,null,null,null,null,null,null,null]','[\"21\",\"0\",null,null,null,null,null,null,null,null,null,null]','[\"414,670\",\"0\",null,null,null,null,null,null,null,null,null,null]','[\"327,021\",\"-81,933\",null,null,null,null,null,null,null,null,null,null]','[\"87,649\",\"81,933\",null,null,null,null,null,null,null,null,null,null]','[\"88,214\",\"76,147\",null,null,null,null,null,null,null,null,null,null]','[\"309,788\",\"44,791\",null,null,null,null,null,null,null,null,null,null]','[\"398,002\",\"120,938\",null,null,null,null,null,null,null,null,null,null]','[\"22.5\",\"8.5\",null,null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",null,null,null,null,null,null,null,null,null,null]','[\"257,183\",\"240,751\",null,null,null,null,null,null,null,null,null,null]','[\"945,489\",\"183,562\",null,null,null,null,null,null,null,null,null,null]','[\"1,202,672\",\"424,313\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'有限会社 板倉土木'),('[\"NGUYEN VAN SON\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null]','[\"1991\\u5e749\\u670822\\u65e5\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"SA92594647ED\",null,null,null,null,null,null,null,null,null,null,null]','[\"333-0834\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u57fc\\u7389\\u770c\\u5ddd\\u53e3\\u5e02\\u5927\\u5b57 \\u5b89\\u884c\\u9818\\u6839\\u5cb8905\\u756a\\u5730 \\u30d3\\u30ec\\u30c3\\u30b8\\u30cf\\u30a6\\u30b9\\u6839\\u5cb81\\u53f7\\u68df 107\\u53f7\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"12\",null,null,null,null,null,null,null,null,null,null,null]','[\"15\",null,null,null,null,null,null,null,null,null,null,null]','[\"300,000\",null,null,null,null,null,null,null,null,null,null,null]','[\"244,270\",null,null,null,null,null,null,null,null,null,null,null]','[\"55,730\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-07 00:53:52',NULL,'2025-04-07 00:53:52',2,0,6,'[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"15\",null,null,null,null,null,null,null,null,null,null,null]','[\"300,000\",null,null,null,null,null,null,null,null,null,null,null]','[\"244,270\",null,null,null,null,null,null,null,null,null,null,null]','[\"55,730\",null,null,null,null,null,null,null,null,null,null,null]','[\"55,730\",null,null,null,null,null,null,null,null,null,null,null]','[\"244,270\",null,null,null,null,null,null,null,null,null,null,null]','[\"300,000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20\",null,null,null,null,null,null,null,null,null,null,null]','[\"2\",null,null,null,null,null,null,null,null,null,null,null]','[\"167,190\",null,null,null,null,null,null,null,null,null,null,null]','[\"732,810\",null,null,null,null,null,null,null,null,null,null,null]','[\"900,000\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'島田建工株式会社'),('[\"KOU OTSUHEI\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2\",null,null,null,null,null,null,null,null,null,null,null]','[\"2021\\u5e7412\\u670831\\u65e5\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"AB12345678CD\",null,null,null,null,null,null,null,null,null,null,null]','[\"999-9999\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11 \\u6cd5\\u52d9\\u7701\\u30d3\\u30eb\\u30c7\\u30a3\\u30f3\\u30b0999\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"10\",null,null,null,null,null,null,null,null,null,null,null]','[\"21\",null,null,null,null,null,null,null,null,null,null,null]','[\"123\",null,null,null,null,null,null,null,null,null,null,null]','[\"111\",null,null,null,null,null,null,null,null,null,null,null]','[\"777\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-11 06:01:44',1,'2025-04-11 07:21:07',1,3,7,'[\"11\",null,null,null,null,null,null,null,null,null,null,null]','[\"22\",null,null,null,null,null,null,null,null,null,null,null]','[\"456\",null,null,null,null,null,null,null,null,null,null,null]','[\"222\",null,null,null,null,null,null,null,null,null,null,null]','[\"888\",null,null,null,null,null,null,null,null,null,null,null]','[\"999\",null,null,null,null,null,null,null,null,null,null,null]','[\"333\",null,null,null,null,null,null,null,null,null,null,null]','[\"789\",null,null,null,null,null,null,null,null,null,null,null]','[\"2\",null,null,null,null,null,null,null,null,null,null,null]','[\"12\",null,null,null,null,null,null,null,null,null,null,null]','[\"722,591\",null,null,null,null,null,null,null,null,null,null,null]','[\"92,591\",null,null,null,null,null,null,null,null,null,null,null]','[\"572,591\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'株式会社　入管'),('[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-12 03:42:47',151,'2025-04-13 15:50:13',2,1,8,'[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,NULL),('[\"KOU OTSUHEI\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2\",null,null,null,null,null,null,null,null,null,null,null]','[\"2021\\u5e7412\\u670831\\u65e5\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"AB12345678CD\",null,null,null,null,null,null,null,null,null,null,null]','[\"999-9999\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11 \\u6cd5\\u52d9\\u7701\\u30d3\\u30eb\\u30c7\\u30a3\\u30f3\\u30b0999\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"4\",null,null,null,null,null,null,null,null,null,null,null]','[\"10000\",null,null,null,null,null,null,null,null,null,null,null]','[\"50000\",null,null,null,null,null,null,null,null,null,null,null]','[\"90000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-19 07:53:51',NULL,'2025-04-19 07:53:51',2,0,9,'[\"2\",null,null,null,null,null,null,null,null,null,null,null]','[\"5\",null,null,null,null,null,null,null,null,null,null,null]','[\"20000\",null,null,null,null,null,null,null,null,null,null,null]','[\"60000\",null,null,null,null,null,null,null,null,null,null,null]','[\"11000\",null,null,null,null,null,null,null,null,null,null,null]','[\"12000\",null,null,null,null,null,null,null,null,null,null,null]','[\"70000\",null,null,null,null,null,null,null,null,null,null,null]','[\"30000\",null,null,null,null,null,null,null,null,null,null,null]','[\"6\",null,null,null,null,null,null,null,null,null,null,null]','[\"3\",null,null,null,null,null,null,null,null,null,null,null]','[\"13000\",null,null,null,null,null,null,null,null,null,null,null]','[\"80000\",null,null,null,null,null,null,null,null,null,null,null]','[\"40000\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'株式会社　入管'),('[\"KOU OTSUHEI 1\",\"KOU OTSUHEI 2\",\"KOU OTSUHEI 3\",\"KOU OTSUHEI 4\",\"KOU OTSUHEI 5\",\"KOU OTSUHEI 6\",\"KOU OTSUHEI 7\",\"KOU OTSUHEI 8\",\"KOU OTSUHEI  9\",\"KOU OTSUHEI 1\",\"KOU OTSUHEI 2\",\"KOU OTSUHEI 3\"]','[\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 1\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 2\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 3\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 4\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 5\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 6\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 7\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 8\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 9\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 1\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2\",\"\\u30a4\\u30f3\\u30c9\\u30cd\\u30b7\\u30a2 3\"]','[\"2021\\u5e7412\\u670831\\u65e5\",\"2021\\u5e7412\\u670802\\u65e5\",\"2021\\u5e7412\\u670803\\u65e5\",\"2021\\u5e7412\\u670804\\u65e5\",\"2021\\u5e7412\\u670805\\u65e5\",\"2021\\u5e7412\\u670806\\u65e5\",\"2021\\u5e7412\\u670807\\u65e5\",\"2021\\u5e7412\\u670808\\u65e5\",\"2021\\u5e7412\\u670831\\u65e5\",\"2021\\u5e7412\\u670811\\u65e5\",\"2021\\u5e7412\\u670831\\u65e5\",\"2021\\u5e7412\\u670833\\u65e5\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"AB12345678CD\",\"AB12345678CD-2\",\"AB12345678CD-3\",\"AB12345678CD-4\",\"AB12345678CD-5\",\"AB12345678CD-6\",\"AB12345678CD-7\",\"AB12345678CD-8\",\"AB12345678CD-9\",\"AB12345678CD-10\",\"AB12345678CD-12\",\"AB12345678CD-13\"]','[\"999-9999\",\"222-2222\",\"999-9999\",\"999-4444\",\"999-5555\",\"999-6666\",\"999-7777\",\"999-8888\",\"999-9999\",\"999-1010\",\"999-9999\",\"999-9999\"]','[\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d2\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d3\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d4\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d5\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d6\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d7\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff110\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11\",\"\\u6771\\u4eac\\u90fd\\u5343\\u4ee3\\u7530\\u533a\\u971e\\u304c\\u95a2\\uff11 \\uff0d\\uff11\\uff0d\\uff11\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",null,\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",null,\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\",\"1\"]','[\"1\",\"21\",\"33\",\"41\",\"51\",\"61\",\"71\",\"81\",\"91\",\"10\",\"12\",\"11\"]','[\"4\",\"24\",\"36\",\"44\",\"54\",\"64\",\"74\",\"84\",\"94\",\"13\",\"15\",\"14\"]','[\"70,000\",\"27000\",\"39000\",\"47000\",\"58000\",\"67000\",\"77\",\"87\",\"97000\",\"16000\",\"18\",\"17\"]','[\"120,000\",\"210000\",\"34000\",\"42000\",\"53000\",\"62000\",\"72\",\"82\",\"92000\",\"11000\",\"13\",\"21\"]','[\"160,000\",\"250000\",\"38000\",\"46000\",\"57000\",\"66000\",\"76\",\"86\",\"96000\",\"15000\",\"17\",\"25\"]','[\"1\",\"1\",null,null,null,\"1\",\"1\",\"1\",null,null,null,null]','[\"1\",\"1\",null,null,null,\"1\",\"1\",\"1\",null,null,null,null]',NULL,NULL,'2025-04-19 13:07:51',150,'2025-04-20 04:37:20',2,10,10,'[\"2\",\"22\",\"34\",\"42\",\"52\",\"62\",\"72\",\"82\",\"92\",\"11\",\"13\",\"12\"]','[\"5\",\"25\",\"37\",\"45\",\"55\",\"65\",\"75\",\"85\",\"95\",\"14\",\"16\",\"15\"]','[\"80,000\",\"28000\",\"31000\",\"48000\",\"59000\",\"68000\",\"78\",\"88\",\"98000\",\"17000\",\"19\",\"18\"]','[\"130,000\",\"220000\",\"35000\",\"43000\",\"54000\",\"63000\",\"73\",\"83\",\"93000\",\"12000\",\"14\",\"22\"]','[\"170,000\",\"260000\",\"39000\",\"47000\",\"58000\",\"67000\",\"77\",\"87\",\"97000\",\"16000\",\"18\",\"26\"]','[\"180,000\",\"270000\",\"40000\",\"48000\",\"59000\",\"68000\",\"78\",\"88\",\"98000\",\"17000\",\"19\",\"27\"]','[\"140,000\",\"230000\",\"36000\",\"44000\",\"55000\",\"64000\",\"74\",\"84\",\"94000\",\"13000\",\"15\",\"23\"]','[\"90,000\",\"29000\",\"32000\",\"49000\",\"51000\",\"69000\",\"79\",\"89\",\"99000\",\"18000\",\"11\",\"19\"]','[\"6\",\"26\",\"38\",\"46\",\"56\",\"66\",\"76\",\"86\",\"96\",\"15\",\"17\",\"16\"]','[\"3\",\"23\",\"35\",\"43\",\"53\",\"63\",\"73\",\"83\",\"93\",\"12\",\"14\",\"13\"]','[\"190,000\",\"280000\",\"41000\",\"49000\",\"51000\",\"69000\",\"79\",\"89\",\"99000\",\"18000\",\"11\",\"28\"]','[\"150,000\",\"240000\",\"37000\",\"45000\",\"56000\",\"65000\",\"75\",\"85\",\"95000\",\"14000\",\"16\",\"24\"]','[\"110,000\",\"20000\",\"33000\",\"41000\",\"52000\",\"61000\",\"71\",\"81\",\"91000\",\"19000\",\"12\",\"20\"]',NULL,NULL,'株式会社　入管'),('[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-20 01:31:33',NULL,'2025-04-20 01:31:33',1,0,11,'[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,NULL),('[\"TIEP\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null]','[\"2020\\u5e743\\u67083\\u65e5\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"SA92594647ED\",null,null,null,null,null,null,null,null,null,null,null]','[\"12345\",null,null,null,null,null,null,null,null,null,null,null]','[\"CHIABA\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\uff11\",null,null,null,null,null,null,null,null,null,null,null]','[\"20\",null,null,null,null,null,null,null,null,null,null,null]','[\"450000\",null,null,null,null,null,null,null,null,null,null,null]','[\"200000\",null,null,null,null,null,null,null,null,null,null,null]','[\"30000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-22 01:14:55',NULL,'2025-04-22 01:14:55',2,0,12,'[\"2\",null,null,null,null,null,null,null,null,null,null,null]','[\"20\",null,null,null,null,null,null,null,null,null,null,null]','[\"450000\",null,null,null,null,null,null,null,null,null,null,null]','[\"200000\",null,null,null,null,null,null,null,null,null,null,null]','[\"30000\",null,null,null,null,null,null,null,null,null,null,null]','[\"30000\",null,null,null,null,null,null,null,null,null,null,null]','[\"200000\",null,null,null,null,null,null,null,null,null,null,null]','[\"450000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\uff13\",null,null,null,null,null,null,null,null,null,null,null]','[\"90000\",null,null,null,null,null,null,null,null,null,null,null]','[\"600000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1350000\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'田中株式会社'),('[\"TIEP\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null,null]','[\"2000\\u5e742\\u67081\\u65e5\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"SA92594647ED\",null,null,null,null,null,null,null,null,null,null,null]','[\"12345\",null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5343\\u8449\\u770c\\u9752\\u7530\\u4e2d\\u304b\\u304b\\u304b\\u304b\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\\u3042\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"30\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",null,null,null,null,null,null,null,null,null,null,null]','[\"2000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-04-22 02:13:25',151,'2025-04-22 05:45:02',2,5,13,'[\"2\",null,null,null,null,null,null,null,null,null,null,null]','[\"20\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",null,null,null,null,null,null,null,null,null,null,null]','[\"2000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1000\",null,null,null,null,null,null,null,null,null,null,null]','[\"2000\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",null,null,null,null,null,null,null,null,null,null,null]','[\"20\",null,null,null,null,null,null,null,null,null,null,null]','[\"3\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",null,null,null,null,null,null,null,null,null,null,null]','[\"6000\",null,null,null,null,null,null,null,null,null,null,null]','[\"9000\",null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'ABC 会社'),('[\"SON\",\"THUY\",\"HAI\",null,\"THUY\",null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null]','[\"2010\\u5e74\",\"2000\\u5e741\\u67081\\u65e5\",\"1998\\/12\\/20\",null,\"2000\",null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,\"1\",null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null]','[\"SA92594647ED\",\"ABC1233333AAA\",\"ABC3333AAA\",null,\"EA15467\",null,null,null,null,null,null,null]','[\"11111\",\"111\\uff0d1254\",\"144-1522\",null,\"120-452\",null,null,null,null,null,null,null]','[\"\\u5343\\u8449\",\"\\u6771\\u4eac\\u90fd\\u65b0\\u5bbf\\u533a\\u6771\\u65b0\\u5bbf3\\u4e01\\u76ee\\uff11\\uff0d\\uff13\",\"CHIBA\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",\"1\",\"1\",null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,\"1\",null,null,null,null,null,\"1\",null]','[null,\"1\",null,\"1\",null,null,null,null,null,null,null,\"1\"]','[\"1\",null,\"1\",null,\"1\",null,null,null,null,null,null,null]','[null,\"1\",null,\"1\",null,null,null,null,null,null,null,null]','[\"1\",\"4\",\"5\",\"1\",\"\\uff13\",null,null,null,null,null,null,null]','[\"20\",\"20\",\"15\",\"27\",\"15\",null,null,null,null,null,null,null]','[\"200\",\"300\",\"200\",\"10\",\"200\",null,null,null,null,null,null,null]','[\"300\",\"100\",\"100\",\"20\",\"30\",null,null,null,null,null,null,null]','[\"100\",\"200\",\"200\",\"20\",\"12\",null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-05-01 09:16:05',1,'2025-05-05 03:46:19',1,4,14,'[\"2\",\"5\",\"6\",\"2\",\"4\",null,null,null,null,null,null,null]','[\"20\",\"20\",\"15\",\"20\",\"15\",null,null,null,null,null,null,null]','[\"200\",\"400\",\"300\",\"20\",\"300\",null,null,null,null,null,null,null]','[\"300\",\"100\",\"300\",\"30\",\"40\",null,null,null,null,null,null,null]','[\"100\",\"300\",\"100\",\"30\",\"12\",null,null,null,null,null,null,null]','[\"100\",\"400\",\"300\",\"50\",\"12\",null,null,null,null,null,null,null]','[\"300\",\"100\",\"200\",\"50\",\"10\",null,null,null,null,null,null,null]','[\"200\",\"500\",\"400\",\"30\",\"500\",null,null,null,null,null,null,null]','[\"20\",\"20\",\"15\",\"20\",\"15\",null,null,null,null,null,null,null]','[\"3\",\"6\",\"7\",\"3\",\"5\",null,null,null,null,null,null,null]','[\"300\",\"9000\",\"600\",\"100\",\"36\",null,null,null,null,null,null,null]','[\"900\",\"300\",\"600\",\"100\",\"80\",null,null,null,null,null,null,null]','[\"600\",\"1200\",\"900\",\"60\",\"1000\",null,null,null,null,null,null,null]',NULL,NULL,'田中株式会社');

--
-- Table structure for table `et_doc_notification_of_support_contract`
--

CREATE TABLE `et_doc_notification_of_support_contract` (
  `corporate_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_institution` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institution_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rea` text COLLATE utf8mb4_unicode_ci,
  `notification_date` text COLLATE utf8mb4_unicode_ci,
  `content` text COLLATE utf8mb4_unicode_ci,
  `chan` text COLLATE utf8mb4_unicode_ci,
  `new_content` text COLLATE utf8mb4_unicode_ci,
  `big` text COLLATE utf8mb4_unicode_ci,
  `small` text COLLATE utf8mb4_unicode_ci,
  `other` text COLLATE utf8mb4_unicode_ci,
  `name` text COLLATE utf8mb4_unicode_ci,
  `gender` text COLLATE utf8mb4_unicode_ci,
  `nr` text COLLATE utf8mb4_unicode_ci,
  `persons_date` text COLLATE utf8mb4_unicode_ci,
  `post_code` text COLLATE utf8mb4_unicode_ci,
  `prefec` text COLLATE utf8mb4_unicode_ci,
  `muni` text COLLATE utf8mb4_unicode_ci,
  `street` text COLLATE utf8mb4_unicode_ci,
  `resi` text COLLATE utf8mb4_unicode_ci,
  `specific` text COLLATE utf8mb4_unicode_ci,
  `business` text COLLATE utf8mb4_unicode_ci,
  `regis` text COLLATE utf8mb4_unicode_ci,
  `corpo` text COLLATE utf8mb4_unicode_ci,
  `name_of` text COLLATE utf8mb4_unicode_ci,
  `post_codeb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `prefecture` text COLLATE utf8mb4_unicode_ci,
  `palities` text COLLATE utf8mb4_unicode_ci,
  `streetb` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_notification_of_support_contract`
--

INSERT INTO `et_doc_notification_of_support_contract` VALUES ('20登124','ABC株式会社','東京都','[\"\\u3042\\u3042\\u3042\\u3042\",null,null,null,null]','[\"2020-03-10\",null,null,null,null]','[\"\\u6280\\u80fd\\u3055\\u3093\\u306e\\u652f\\u63f4\",null,null,null,null]','[\"\\uff42\\uff42\\uff42\\uff42\\uff42\",null,null,null,null]','[\"\\u6280\\u80fd\\u3055\\u3093\\u306e\\u751f\\u6d3b\\u3092\\u652f\\u63f4\\u3059\\u308b\",null,null,null,null]','[\"CCCCC\",null,null,null,null]','[\"ddddd\",null,null,null,null]','[\"\\u7121\\u3057\",null,null,null,null]','[\"\\u5165\\u7ba1 \\u82b1\\u5b50\",null,null,null,null]','[null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null]','[\"2000-03-12\",null,null,null,null]','[\"123001\",null,null,null,null]','[\"\\u6771\\u4eac\\u90fd\",null,null,null,null]','[\"\\u65b0\\u5bbf\\u533a\",null,null,null,null]','[\"\\uff13\\uff0d\\uff12\\uff0d\\uff11\",null,null,null,null]','[\"EA124570100\",null,null,null,null]','[\"\\u5916\\u98df\\u696d\",null,null,null,null]','[\"\\u98f2\\u98df\\u5e97\\u30b5\\u30fc\\u30d3\\u30b9\",null,null,null,null]','[\"234to0099\",null,null,null,null]','[\"12460000000\",null,null,null,null]','[\"\\u682a\\u5f0f\\u4f1a\\u793eABC\",null,null,null,null]','[null,null,null,null,null]','[\"\\u6771\\u4eac\\u90fd\",null,null,null,null]','[\"\\u65b0\\u5bbf\\u533a\",null,null,null,null]','[null,null,null,null,null]',NULL,NULL,'2025-03-03 02:06:04',151,'2025-03-03 02:06:04',2,1,1),('1235786455230','ABC株式会社','CHIBA','[\"\\u652f\\u63f4\\u59d4\\u8a17\\u5951\\u7d04\\u306e\\u5909\\u66f4\",\"\\u652f\\u63f4\\u59d4\\u8a17\\u5951\\u7d04\\u306e\\u7d42\\u4e86\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1990-03-04\",\"2000-03-04\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"bfalfh;alfj;gf\",\"\\uff46\\uff53\\uff47\\uff48\\uff47\\uff47\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"01.\\u59d4\\u8a17\\u3059\\u308b\\u652f\\u63f4\\u696d\\u52d9\",\"03.\\u8cbb\\u7528\\u306e\\u8ca0\\u62c5\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u6280\\u80fd\\u3055\\u3093\\u306e\\u751f\\u6d3b\\u652f\\u63f4\",\"\\uff47\\uff53\\uff47\\uff47\\uff48\\uff48\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u59d4\\u8a17\\u5951\\u7d04\\u306e\\u7d42\\u671f\\u5230\\u6765\",\"\\u7279\\u5b9a\\u6280\\u80fd\\u6240\\u5c5e\\u6a5f\\u95a2\\u306e\\u90fd\\u5408\\u306b\\u3088\\u308b\\u7d42\\u4e86\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"06.\\u5951\\u7d04\\u9055\\u53cd\",\"08.\\u305d\\u306e\\u4ed6\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u6280\\u80fd\\u3055\\u3093\",\"\\uff48\\uff46\\uff4a\\uff46\\uff4a\\uff4a\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"nakano\",\"\\u3044\\u3044\\u3044\\u3044\\u3044\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5973\",\"\\u7537\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2001-03-04\",\"2000-03-03\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1110022\",\"123789\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"tokyo\",\"\\u5343\\u8449\\u770c\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"shinjuku\",\"\\u308f\\u3089\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"3-4-5\",\"5-7-8\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"SA425555\",\"EA4555133\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5916\\u98df\\u696d\",\"\\u5efa\\u8a2d\\u696d\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u98f2\\u98df\\u5e97\",\"\\u3068\\u3073\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\uff11\\uff10\\u767b\\u30fc2022\",\"32547855\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"1200000230\",\"154100005\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30a2\\u30d0\\u30bf\\u30fc\\u682a\\u5f0f\\u4f1a\\u793e\",\"\\u305f\\u305f\\u682a\\u5f0f\\u4f1a\\u793e\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"120001\",\"1254788\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u5c90\\u961c\\u770c\",\"\\u540d\\u53e4\\u5c4b\\u5e02\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"\\u30c6\\u30e9\\u30b9\",\"\\u305f\\u305f\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2\\uff0d3\\uff0d1\",\"4-8-9\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-03-03 09:05:00',151,'2025-03-03 09:05:00',2,10,2),(NULL,NULL,NULL,'[\"\\u652f\\u63f4\\u59d4\\u8a17\\u5951\\u7d04\\u306e\\u7de0\\u7d50\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"2025-03-04\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"01.\\u59d4\\u8a17\\u3059\\u308b\\u652f\\u63f4\\u696d\\u52d9\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"asdasd\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[\"asdasdasd\",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-03-04 02:33:25',1,'2025-03-04 02:33:25',1,2,3);

--
-- Table structure for table `et_doc_notification_of_support_status`
--

CREATE TABLE `et_doc_notification_of_support_status` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `n1` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n2` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n3` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n4` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n5` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n6` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n7` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n8` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n9` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n10` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n11` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n12` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `n13` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone1` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills1` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills2` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills3` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills4` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills5` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills6` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills7` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills8` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills9` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills10` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills11` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills12` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skills13` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_title1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone11` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `foreign_ationals1` tinyint(1) DEFAULT NULL,
  `foreign_ationals2` tinyint(1) DEFAULT NULL,
  `date_occurred` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `details_violation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responses_violations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number_missing_category` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number_missing_category1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number_missing_foreign` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number_missing_technical` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `other_matters_organizations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_registration_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_person_creating_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signature_person_notification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `other_matters_date` date DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `g2` tinyint DEFAULT NULL,
  `card_number3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g4` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g5` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g6` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g7` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g8` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g9` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g10` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g11` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g12` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g13` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `g14` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code1` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code2` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `year_1` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `no` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `period_notification` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `full_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `g` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `company_date` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `nr` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `card_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `place_residence` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `implemented` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `problematic` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `no_problem` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `regis_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tl` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `codes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_of_support_status`
--

INSERT INTO `et_doc_notification_of_support_status` VALUES (1,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0',0,0,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','2024-10-22','2024-10-22 18:14:33',NULL,NULL,'2024-10-22 18:14:33',1,0,0,'0','0','0','0','0','0','0','0','0','0','0','0',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'1','1','8','1','0','0','2','2','3','3','1','1','1','ONOOOO','東京都','3456647','1','1','4','0','0','3','4','2','1','1','1','1','1','TAKEMURA','千葉県','524355665',1,0,'ｇふぃあｇふぉあｈｆ','ｆｓｇｓｇｓｇ','ｆｓｇｓｇ','','中野','','たなか','','大岡','','武村','AAA株式会社','BBBB株式会社','CCCC株式会社','DDD株式会社','スズキ','2025-01-20','2025-01-01 11:50:27',NULL,151,'2025-01-01 11:50:27',1,32,2,'0','0','0','0','0','0','0','0','0','0','0','0','123-456','123-456','大野','','1','2025','たけむら','[\"\\u5927\\u91ce\",\"THUY\",\"TIEP\",null,null]','[null,\"2\",\"1\",null,null]','[\"2020-01-15\",null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u4e2d\\u56fd\",\"\\u97d3\\u56fd\",null,null]','[\"SA1234BBBB\",\"SA1234BBBB\",\"SA1234BBBB\",null,null]','[\"\\u5343\\u8449\",\"\\u6771\\u4eac\",\"AAAAA\",null,null]','[\"1\",null,\"1\",null,null]','[\"1\",\"1\",null,null,null]','[null,null,null,null,null]','12登576392',NULL,NULL),(3,'1','4','2','0','0','0','0','0','0','0','0','0','0','株式会社 入管','東京都港区港南５丁目５番３０号','23','1','3','0','0','0','0','0','0','0','4','6','7','6','株式会社 入管','入管 太郎','522',1,0,'àgf','0gdsgdg','0gsgsgg','sgfsg','sgsgs','gsg','gsgs','gsg','gssgs','gss','sggs','ghsg','田中株式会社','ｇｈふぉあｓｈふ’àáá','085-457-4165','suzuki','2025-01-01','2025-01-01 12:43:59',NULL,151,'2025-01-01 12:43:59',1,1,1,'0','0','0','0','0','0','0','0','0','0','0','0',NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'1','0','0','0','1','1','1','1','1','1','0','0','0','株式会社 入管','大阪府新宿区３－１０－６','','','','','','','','','','','','','','','','','',0,0,'','','','','','','','','','','','','','','','','2025-02-26','2025-02-26 15:16:16',NULL,151,'2025-02-26 15:16:16',1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'123','','4','2011年ー2020年','','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','12登576392',NULL,NULL),(5,'7','0','4','0','0','0','1','1','1','7','6','1','8','かぶしきがいしゃアルファセプ','千葉県鎌ケ谷市北中沢1-18-22 スカラビル３F','0474-022-022','1','0','3','0','0','0','1','0','8','2','9','5','0','しまだけんこう　かぶしきがいしゃ','埼玉県川口市木曽呂１６７番地の３','048-452-8015',1,0,'無し','無し','無し','','0','','0','','0','','0','無し','株式会社ＡｌｐｈａＣｅｐ','ジェンティタンガー','0474-022-022','','2025-04-07','2025-04-03 15:23:50',NULL,151,'2025-04-03 15:23:50',2,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'273-0111','333－0831','株式会社ＡｌｐｈａＣｅｐ','','1','2025','島田建工株式会社','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','[null,null,null,null,null]','２４登－００９４０５','[null,null,null,null,null]','[null,null,null,null,null]');

--
-- Table structure for table `et_doc_notification_of_support_status_org`
--

CREATE TABLE `et_doc_notification_of_support_status_org` (
  `period` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id` bigint NOT NULL AUTO_INCREMENT,
  `no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n1` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n2` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n3` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n4` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n5` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n6` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n7` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n8` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n9` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n10` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n11` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n12` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `n13` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(30) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ckbox1` tinyint DEFAULT NULL,
  `ckbox2` tinyint DEFAULT NULL,
  `name_specific` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone_number` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signature_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_notification_of_support_status_org`
--

INSERT INTO `et_doc_notification_of_support_status_org` VALUES ('２０２１年',1,'4','1','0','1','0','0','0','1','1','1','1','1','1','2','なかの','中野','123456','千葉県船橋市','082-00-123',1,NULL,'ABCkabu','tnaaka','023-45221','入管 太郎','2025-03-04',NULL,NULL,'2025-03-04 14:16:29',151,'2025-03-04 14:16:29',2,2);

--
-- Table structure for table `et_doc_notification_of_termination_conclusion`
--

CREATE TABLE `et_doc_notification_of_termination_conclusion` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `termination_of_specific_skill` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `conclusion_of_new` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `termination_date` date DEFAULT NULL,
  `employment_contract_end` tinyint DEFAULT NULL,
  `termination_circumstances` tinyint DEFAULT NULL,
  `management_reasons` tinyint DEFAULT NULL,
  `non_compliance_standards` tinyint DEFAULT NULL,
  `death` tinyint DEFAULT NULL,
  `termination_circumstances_other` tinyint DEFAULT NULL,
  `termination_foreigner_circumstances` tinyint DEFAULT NULL,
  `die` tinyint DEFAULT NULL,
  `illness_injury` tinyint DEFAULT NULL,
  `missing` tinyint DEFAULT NULL,
  `severe_dismissal` tinyint DEFAULT NULL,
  `personal_resignation` tinyint DEFAULT NULL,
  `termination_foreigner_circumstances_other` tinyint DEFAULT NULL,
  `entrustment_contract_end` date DEFAULT NULL,
  `registration_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_person_number` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_conclusion` date DEFAULT NULL,
  `notifi_agency_legal_num` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notifi_agency_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notifi_agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notifi_agency_responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notifi_agency_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `gt` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `code3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_orther` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_orther_for` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `text_orther_termination` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_of_termination_conclusion`
--

INSERT INTO `et_doc_notification_of_termination_conclusion` VALUES (2,'sdfsdfasdf','2024-11-27','vietnam','test','1111111','adsf','asd','1','1','2024-11-05',1,1,1,1,1,1,1,1,1,1,1,1,1,'2024-11-29','daf','123','dfads','asdf','2024-11-25','122','asdf','adf','ad','df','adf','2024-11-15',NULL,NULL,NULL,1,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'VO THI THU THUY','1980-12-30','ベトナム','東京都千代田区霞が関１丁目１番１号　霞ヶ関ハイツ２０２号','AB452476CD','農業','木を込みます','1','0','2024-12-29',1,0,0,0,0,0,0,0,0,0,0,0,0,'2024-12-30','679548','1467783574610','ABC株式会社','東京都新宿区西新宿1-2-3','2024-12-17','1465560832500','AKKH株式会社','東京都新宿区西新宿4-5-6','オオノ','045-210-000','アン','2024-12-30',NULL,NULL,NULL,151,1,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'VO THI THU THUY','1991-01-22','ベトナム','東京都千代田区霞が関１丁目１番１号　霞ヶ関ハイツ２０２号','AB12345678CD','介護','身体介護等','1','0','2025-01-20',0,0,1,0,0,0,0,0,1,0,0,0,0,NULL,'12登-454231','4578434000012','ABC株式会社','○○県○○市○○町2－2','2025-01-20','1350000013401','AKKH株式会社','東京都新宿区西新宿4-5-6','オオノ','045-210-000','入江 省吾','2025-01-21',NULL,NULL,NULL,151,1,13,'女','123-452','456-7593','458-7856','あｈｆｋｌｋ','2027-02-07','adsgdhdhjh');

--
-- Table structure for table `et_doc_notification_resumption_support_services`
--

CREATE TABLE `et_doc_notification_resumption_support_services` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `registration_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_person_number_1` int DEFAULT NULL,
  `legal_person_number_2` int DEFAULT NULL,
  `legal_person_number_3` int DEFAULT NULL,
  `legal_person_number_4` int DEFAULT NULL,
  `legal_person_number_5` int DEFAULT NULL,
  `legal_person_number_6` int DEFAULT NULL,
  `legal_person_number_7` int DEFAULT NULL,
  `legal_person_number_8` int DEFAULT NULL,
  `legal_person_number_9` int DEFAULT NULL,
  `legal_person_number_10` int DEFAULT NULL,
  `legal_person_number_11` int DEFAULT NULL,
  `legal_person_number_12` int DEFAULT NULL,
  `legal_person_number_13` int DEFAULT NULL,
  `name_the_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `planned_date` date DEFAULT NULL,
  `signature_person` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `signature_person_date` date DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_specific` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_person_responsible` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `document` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `datesig` date DEFAULT NULL,
  `signature` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_resumption_support_services`
--

INSERT INTO `et_doc_notification_resumption_support_services` VALUES (1,'registration_number',1,1,2,2,3,3,4,4,5,5,6,6,7,'name_the_institution','agency_address','responsible','telephone_number','2024-11-11','fsdfsdf','2024-03-12','2024-10-14 12:54:01',NULL,1,'2024-10-14 13:09:30',1,1,NULL,NULL,NULL,NULL,NULL,NULL),(2,'011',3,3,3,1,1,2,2,1,1,1,1,1,1,'BBBBB','tokyou','Ạdlaghdfad','111789010000','2024-11-22','1','2024-11-22','2024-11-22 12:07:15',NULL,1,'2024-11-22 12:07:15',1,6,NULL,NULL,NULL,NULL,NULL,NULL),(3,'12登-454231',9,1,3,4,1,0,0,7,8,4,7,7,7,'オオノ','tokyou','dâf','085-457-4165','2025-01-01','oooka','2025-01-01','2025-01-01 12:56:10',NULL,151,'2025-01-01 12:56:10',1,4,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_notification_support_implementation_status`
--

CREATE TABLE `et_doc_notification_support_implementation_status` (
  `id` int NOT NULL AUTO_INCREMENT,
  `corporate_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `accommodation_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skilled_foreign_nationals_1` int DEFAULT NULL,
  `specific_skilled_foreign_nationals_2` int DEFAULT NULL,
  `name_specific_skills_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_create_document` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_support_implementation_status`
--


--
-- Table structure for table `et_doc_notification_suspend_terminate_support`
--

CREATE TABLE `et_doc_notification_suspend_terminate_support` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `registration_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_person_number_1` int NOT NULL,
  `legal_person_number_2` int NOT NULL,
  `legal_person_number_3` int NOT NULL,
  `legal_person_number_4` int NOT NULL,
  `legal_person_number_5` int NOT NULL,
  `legal_person_number_6` int NOT NULL,
  `legal_person_number_7` int NOT NULL,
  `legal_person_number_8` int NOT NULL,
  `legal_person_number_9` int NOT NULL,
  `legal_person_number_10` int NOT NULL,
  `legal_person_number_11` int NOT NULL,
  `legal_person_number_12` int NOT NULL,
  `legal_person_number_13` int NOT NULL,
  `name_the_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `suspen_sionsupport_services` tinyint DEFAULT NULL,
  `abolition_support_services` tinyint DEFAULT NULL,
  `suspension` date DEFAULT NULL,
  `business_reasons` tinyint DEFAULT NULL,
  `business_downsizing` tinyint DEFAULT NULL,
  `others` tinyint DEFAULT NULL,
  `text_others` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reopening` tinyint DEFAULT NULL,
  `reopenin_date` date DEFAULT NULL,
  `date_abolition` tinyint DEFAULT NULL,
  `date_abolition_date` date DEFAULT NULL,
  `bankruptcy` tinyint DEFAULT NULL,
  `death` tinyint DEFAULT NULL,
  `business_downsizing1` tinyint DEFAULT NULL,
  `other_business_reasons` tinyint DEFAULT NULL,
  `yes_or_no` tinyint DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_ct` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_suspend_terminate_support`
--

INSERT INTO `et_doc_notification_suspend_terminate_support` VALUES (1,'registration_number 111',1,1,1,1,1,1,1,1,1,1,1,1,1,'dsafdsfdsfsdf','agency_address','responsible','123123123123',1,1,'2024-11-11',1,1,1,'text_others',1,'2024-11-11',1,'2024-11-11',1,1,1,1,2,'2024-11-11',NULL,NULL,1,'2024-10-11 15:41:45',1,8,NULL,NULL),(2,'registration_number',1,2,3,4,5,6,7,8,9,1,2,3,4,'name_the_institution','agency_address','responsible','0',1,1,'2024-11-11',1,1,1,'text_others',1,'2024-11-11',1,'2024-11-11',1,1,1,1,1,'2024-11-11','2024-10-11 16:07:44',NULL,NULL,'2024-10-11 16:07:44',1,0,NULL,NULL),(3,'12登-454231',4,2,3,5,5,5,4,3,9,3,0,0,0,'株式会社　入管','東京都新宿区','AADGLKFH;','045-785-1555',1,0,'2025-01-01',1,0,0,'gflahf;à',0,'2025-01-01',1,'2025-01-01',0,0,1,0,1,'2025-01-01','2025-01-01 12:54:40',NULL,151,'2025-01-16 13:01:43',1,12,'123-456','ÔNO COMPANY');

--
-- Table structure for table `et_doc_notification_termination_support_contract`
--

CREATE TABLE `et_doc_notification_termination_support_contract` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `fullname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_card_number` int DEFAULT NULL,
  `specific_industry_sector` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_segmentation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `termination_support_contract` tinyint DEFAULT NULL,
  `conclusion_support_contract` tinyint DEFAULT NULL,
  `termination_conclusion_support_contract` tinyint DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `reason_big_categories_1` tinyint DEFAULT NULL,
  `reason_big_categories_2` tinyint DEFAULT NULL,
  `reason_big_categories_3` tinyint DEFAULT NULL,
  `reason_small_classification_1` tinyint DEFAULT NULL,
  `reason_small_classification_2` tinyint DEFAULT NULL,
  `reason_small_classification_3` tinyint DEFAULT NULL,
  `reason_small_classification_4` tinyint DEFAULT NULL,
  `reason_small_classification_other` tinyint DEFAULT NULL,
  `date_conclusion` date DEFAULT NULL,
  `conclusion_contract_person_number` int DEFAULT NULL,
  `conclusion_contract_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `conclusion_contract_agency_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_persion_number` int DEFAULT NULL,
  `notification_agency_name_institution` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_name_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `notification_agency_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_notification_termination_support_contract`
--

INSERT INTO `et_doc_notification_termination_support_contract` VALUES (1,'fullname','1992-12-22','Viet nam','residence',NULL,NULL,NULL,0,0,0,'2024-09-23',0,1,1,0,0,0,0,0,'2024-09-22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,2);

--
-- Table structure for table `et_doc_otherwork_reason`
--

CREATE TABLE `et_doc_otherwork_reason` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_director` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason_required_work` tinyint(1) NOT NULL DEFAULT '0',
  `reason_required_work_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reason_performance_work` tinyint(1) NOT NULL DEFAULT '0',
  `reason_performance_work_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `reason_otherwork` tinyint(1) NOT NULL DEFAULT '0',
  `reason_otherwork_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_otherwork_reason`
--

INSERT INTO `et_doc_otherwork_reason` VALUES (1,'2024-06-21','customer_name 123','customer_director 123123',1,'ádasdaasd asdasdasd ádasd',1,'ádasdasdasd ádasd',1,'ádasda',NULL,NULL,NULL,NULL,1,1,2),(2,'2024-09-01','customer_name','customer_director',1,'test\r\ntest3',1,'1\r\n2',1,'1111\r\n222',NULL,NULL,NULL,NULL,1,1,3);

--
-- Table structure for table `et_doc_payment_certificate`
--

CREATE TABLE `et_doc_payment_certificate` (
  `id` int NOT NULL AUTO_INCREMENT,
  `month` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_date` date DEFAULT NULL,
  `to_date` date DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zairyu_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `money` int DEFAULT NULL,
  `cash_money` int DEFAULT NULL,
  `pay_date` date DEFAULT NULL,
  `sign_date1` date DEFAULT NULL,
  `sign_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_company_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_company_payer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date2` date DEFAULT NULL,
  `trainee_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_payment_certificate`
--

INSERT INTO `et_doc_payment_certificate` VALUES (1,'2024-07','2024-07-01','2024-07-31','name',1,'2024-07-08','nationality','zairyu_number',1000,10000,'2024-07-22','2024-07-25','sign_company_name','sign_company_director_name','sign_company_payer_name','2024-07-25','trainee_name',NULL,NULL,NULL,1,1,1),(2,'2024-08','2024-08-02','2024-08-02','TEST',1,'2024-08-02','nationality',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,4);

--
-- Table structure for table `et_doc_power_attorney`
--

CREATE TABLE `et_doc_power_attorney` (
  `id` int NOT NULL AUTO_INCREMENT,
  `person_1_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_1_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_1_tell` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_1_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_1_leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `person_2_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_2_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_2_tell` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_2_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `person_2_leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_power_attorney`
--

INSERT INTO `et_doc_power_attorney` VALUES (1,'12345','tesst','0123456789','name','person_1_leader_name','afasdf asdfa','test','content 3','2024-07-02','12345678','123456789','test','name 111','leader 111',NULL,NULL,NULL,1,1,15),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1);

--
-- Table structure for table `et_doc_pre_entry_training_scheduler`
--

CREATE TABLE `et_doc_pre_entry_training_scheduler` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_pre_entry_training_scheduler`
--

INSERT INTO `et_doc_pre_entry_training_scheduler` VALUES (1,'2024-07-05','NGUYEN DUC TAP','NGUYEN VAN A','CUSTOME NAME',NULL,NULL,NULL,NULL,1,0),(2,'2024-07-09','sign_name','sign_creator_name','sign_customer_name',NULL,NULL,NULL,1,1,2),(3,'2024-07-30','sign_name','sign_creator_name','sign_customer_name',NULL,NULL,NULL,NULL,1,0),(4,'2024-09-09','sign_name','sign_creator_name','sign_customer_name',NULL,NULL,NULL,1,1,4);

--
-- Table structure for table `et_doc_pregnancy_declaration`
--

CREATE TABLE `et_doc_pregnancy_declaration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `detail_check_1` int DEFAULT NULL,
  `detail_check_2` int DEFAULT NULL,
  `detail_check_3` int DEFAULT NULL,
  `detail_check_4` int DEFAULT NULL,
  `detail_check_5` int DEFAULT NULL,
  `detail_check_6` tinyint(1) DEFAULT NULL,
  `detail_check_7` int DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `return_country_date` date DEFAULT NULL,
  `return_check_1` int DEFAULT NULL,
  `return_month` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `return_check_2` tinyint(1) DEFAULT NULL,
  `return_check_3` tinyint(1) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_submit_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_pregnancy_declaration`
--

INSERT INTO `et_doc_pregnancy_declaration` VALUES (1,1,0,'name test',1,0,0,1,1,1,1,'2024-07-04','2024-07-04',1,'2024-06',1,0,'2024-07-10','sign_name','sign_submit_name',NULL,NULL,NULL,NULL,NULL,0,'note'),(2,0,0,NULL,0,0,0,0,0,0,0,NULL,NULL,0,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL);

--
-- Table structure for table `et_doc_prepare_institution_pledge`
--

CREATE TABLE `et_doc_prepare_institution_pledge` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `establistment_date` date DEFAULT NULL,
  `trainee_relationship_type` int DEFAULT NULL COMMENT '1: 入国前講習の実施に関与する者, 2: その他',
  `trainee_relationship_type_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_prepare_institution_pledge`
--

INSERT INTO `et_doc_prepare_institution_pledge` VALUES (1,'test name','director_name','prepare_institution_pledge address','0123456789','test2gmail.com','2024-06-03',1,'trainee relationship type other','job','2024-06-03','sign_name','sign_director_name',NULL,NULL,NULL,NULL,1,1,2),(2,'longnh','dsa','abcsda','1234123412','admin@gmail.com','2024-06-29',1,'dsadsadsadsa','1','2024-06-26','sign name','dsadsa',NULL,NULL,NULL,NULL,1,1,3),(5,'TEST','director_name','address','tel','test@gmail.com.vn','2024-09-01',2,'trainee_relationship_type_other','job_name','2024-09-05','sign_name','sign_director_name',NULL,NULL,NULL,NULL,1,1,5);

--
-- Table structure for table `et_doc_reasons_non_implementation_support`
--

CREATE TABLE `et_doc_reasons_non_implementation_support` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gender` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `nationality_region` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `residence_card_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `air` tinyint DEFAULT NULL,
  `sup` tinyint DEFAULT NULL,
  `lif` tinyint DEFAULT NULL,
  `acc` tinyint DEFAULT NULL,
  `pro` tinyint DEFAULT NULL,
  `res` tinyint DEFAULT NULL,
  `prom` tinyint DEFAULT NULL,
  `job` tinyint DEFAULT NULL,
  `reg` tinyint DEFAULT NULL,
  `other` tinyint DEFAULT NULL,
  `other_txt` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reasons_implementing` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support_staff` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_specific` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_support` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_reasons_non_implementation_support`
--

INSERT INTO `et_doc_reasons_non_implementation_support` VALUES (1,NULL,NULL,'2025-03-29 09:17:39',151,'2025-03-29 09:17:39',2,4,'TURNER ELIZABETH','男','1990-03-11','タイ','033-1244','千葉県柏市あけぼの5-4-35-102','AB12345678CD',NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,'あああああああああああ','あああああああああああ','あああああああああああああ','あああああああああああああ','たなか','123123123','343242934239842342');

--
-- Table structure for table `et_doc_recomend_trainee`
--

CREATE TABLE `et_doc_recomend_trainee` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `sending_agency_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `customer_id` int DEFAULT NULL,
  `start_month` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_type_id` int DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `coulcity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coulcity_staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_recomend_trainee`
--

INSERT INTO `et_doc_recomend_trainee` VALUES (1,NULL,1,2,'2024-07',3,'2024-06-21','test ád','Nguyen Duc Tap',NULL,NULL,NULL,NULL,NULL,0),(2,'sending_agency_name',1,NULL,'2024-08',5,'2024-08-05','test','coulcity_staff_name',NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_recomend_trainee_listname`
--

CREATE TABLE `et_doc_recomend_trainee_listname` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `recomend_trainee_id` bigint NOT NULL,
  `trainee_id` bigint NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_recomend_trainee_listname`
--

INSERT INTO `et_doc_recomend_trainee_listname` VALUES (3,1,4,'2024-06-27 20:14:14','2024-06-27 20:14:14'),(4,1,18,'2024-06-27 20:14:14','2024-06-27 20:14:14'),(5,1,11,'2024-06-27 20:14:14','2024-06-27 20:14:14'),(6,1,18,'2024-06-27 20:14:14','2024-06-27 20:14:14'),(7,1,74,'2024-06-27 20:14:14','2024-06-27 20:14:14'),(8,2,79,'2024-08-05 16:09:52','2024-08-05 16:09:52'),(9,2,143,'2024-08-05 16:10:58','2024-08-05 16:10:58'),(10,2,74,'2024-08-05 16:10:58','2024-08-05 16:10:58'),(11,2,75,'2024-08-05 16:10:58','2024-08-05 16:10:58');

--
-- Table structure for table `et_doc_regular_interview_report`
--

CREATE TABLE `et_doc_regular_interview_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_specific_skilled` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `skills_organization` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `interview` date DEFAULT NULL,
  `name_responder` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `support1` tinyint(1) DEFAULT NULL,
  `support2` tinyint(1) DEFAULT NULL,
  `job_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence7` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem7` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence8` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem8` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence9` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem9` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence10` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem10` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence11` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem11` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence12` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem12` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence13` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem13` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence14` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem14` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence15` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem15` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence16` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem16` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence17` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem17` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `presence18` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `problem18` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `yes` tinyint(1) DEFAULT NULL,
  `none` tinyint(1) DEFAULT NULL,
  `other` text COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `guided` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no` date DEFAULT NULL,
  `recipient` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `rep` date DEFAULT NULL,
  `reporting_agency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date1` date DEFAULT NULL,
  `name_person` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notified` tinyint(1) DEFAULT NULL,
  `unfinished` tinyint(1) DEFAULT NULL,
  `already1` tinyint(1) DEFAULT NULL,
  `no1` tinyint(1) DEFAULT NULL,
  `already` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_regular_interview_report`
--

INSERT INTO `et_doc_regular_interview_report` VALUES (1,'トウイ','áđá','2025-01-22','TIEP',NULL,1,'名 代表取締役','ád',NULL,'無し',NULL,'ád',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 03:05:09',NULL,151,'2025-01-23 07:03:04',1,10,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-23','cjgkh',1,1,NULL,1,NULL),(2,'NGUYEN VAN SON','島田建工株式会社','2025-04-10','ジェン ティ タン ガー',1,NULL,'代表取締役','無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'無し',NULL,NULL,'2025-04-05 06:34:02',NULL,151,'2025-04-05 06:36:03',2,1,NULL,NULL,NULL,NULL,NULL,'2025-04-10','ジェン ティ タン ガー',NULL,NULL,NULL,NULL,NULL),(3,'ｑｑｑ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-07 02:25:02',NULL,151,'2025-04-07 04:21:47',2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'入江　省吾','島田建工株式会社',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-07 05:09:54',NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
