-- Table structure for table `em_sending_agency_trainee`
--

CREATE TABLE `em_sending_agency_trainee` (
  `sending_agency_trainee_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sending_agency_id` bigint NOT NULL,
  `trainee_id` bigint NOT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` int NOT NULL,
  PRIMARY KEY (`sending_agency_trainee_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_sending_agency_trainee`
--

INSERT INTO `em_sending_agency_trainee` VALUES (1,8,1,1,'2024-08-09 21:28:00',NULL,'2024-08-09 21:28:00',1),(2,1,3,1,'2024-08-19 12:21:14',NULL,'2024-08-19 12:21:14',1),(3,1,4,1,'2024-08-19 22:11:33',NULL,'2024-08-19 22:11:33',1),(4,1,5,1,'2024-08-19 22:15:22',NULL,'2024-08-19 22:15:22',1);

--
-- Table structure for table `em_stay_facility`
--

CREATE TABLE `em_stay_facility` (
  `stay_facility_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stay_facility_form_div` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stay_facility_form_detail` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contributor_div` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contributor_name` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_area` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_number` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_density` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_charge_detail` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_note` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`stay_facility_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_stay_facility`
--

INSERT INTO `em_stay_facility` VALUES (1,'stay 12','02','stay 12','01','stay 12','1231231231','stay 12','stay 1','stay 12','stay 1','stay 12','stay 1','stay 12','stay 1',1,'2023-12-29 13:50:07',1,'2023-12-29 13:55:46',1,1),(2,'stay2','02','stay2','02','stay2','stay2','stay2stay2','stay2','stay2','stay2','stay2','stay2','stay2','stay2',1,'2023-12-29 13:51:55',NULL,'2023-12-29 13:51:55',NULL,1);

--
-- Table structure for table `em_trainee_contract`
--

CREATE TABLE `em_trainee_contract` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` int DEFAULT NULL,
  `trainee_id` int DEFAULT NULL,
  `period_from_date` date DEFAULT NULL,
  `period_to_date` date DEFAULT NULL,
  `entry_date` date DEFAULT NULL,
  `contract_update_type` int DEFAULT NULL,
  `contract_noupdate_type` int DEFAULT NULL,
  `contract_maxupdate_type` int DEFAULT NULL,
  `contract_maxupdate_count` int DEFAULT NULL,
  `contract_maxupdate_year` int DEFAULT NULL,
  `work_place_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_begintime` time DEFAULT NULL,
  `work_endtime` time DEFAULT NULL,
  `work_oneday_time` time DEFAULT NULL,
  `flextime_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `changetime_begin_time_1` time DEFAULT NULL,
  `changetime_end_time_1` time DEFAULT NULL,
  `changetime_date_valid_1` date DEFAULT NULL,
  `changetime_onedate_1` time DEFAULT NULL,
  `changetime_begin_time_2` time DEFAULT NULL,
  `changetime_end_time_2` time DEFAULT NULL,
  `changetime_date_valid_2` date DEFAULT NULL,
  `changetime_onedate_2` time DEFAULT NULL,
  `changetime_begin_time_3` time DEFAULT NULL,
  `changetime_end_time_3` time DEFAULT NULL,
  `changetime_date_valid_3` date DEFAULT NULL,
  `changetime_onedate_3` time DEFAULT NULL,
  `breaktime` int DEFAULT NULL,
  `work_hours_per_month` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_hours_per_year` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_days_1_year` smallint DEFAULT NULL,
  `work_days_2_year` smallint DEFAULT NULL,
  `work_days_3_year` smallint DEFAULT NULL,
  `overtime_type` int DEFAULT NULL,
  `postcode` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transition_occupation_id1` int DEFAULT NULL,
  `transition_occupation_id2` int DEFAULT NULL,
  `transition_occupation_id3` int DEFAULT NULL,
  `other_transition_occupation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_entry_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_entry_date` date DEFAULT NULL,
  `entry_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no3_entry_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `no3_entry_date` date DEFAULT NULL,
  `schedule_return_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schedule_return_from_date` date DEFAULT NULL,
  `schedule_return_to_date` date DEFAULT NULL,
  `pre_entry_training` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_entry_training_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_entry_training_from_date` date DEFAULT NULL,
  `post_entry_training_from_to` date DEFAULT NULL,
  `training_no1_certification_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no1_certification_date` date DEFAULT NULL,
  `training_no1_certification_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no1_practition_date_div` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no1_practition_from_date` date DEFAULT NULL,
  `training_no1_practition_to_date` date DEFAULT NULL,
  `training_no1_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `training_no2_certification_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no2_certification_date` date DEFAULT NULL,
  `training_no2_certification_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no2_practition_date_div` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no2_practition_from_date` date DEFAULT NULL,
  `training_no2_practition_to_date` date DEFAULT NULL,
  `training_no2_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `training_no3_certification_date_div` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no3_certification_date` date DEFAULT NULL,
  `training_no3_certification_number` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no3_practition_date_div` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no3_practition_from_date` date DEFAULT NULL,
  `training_no3_practition_to_date` date DEFAULT NULL,
  `training_no3_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `fixed_term_employment_contract` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employment_contract_from_date` date DEFAULT NULL,
  `employment_contract_from_to` date DEFAULT NULL,
  `work_hours_div` date DEFAULT NULL,
  `work_days_4_year` smallint DEFAULT NULL,
  `work_days_5_year` smallint DEFAULT NULL,
  `holiday_days` smallint DEFAULT NULL,
  `work_hours_per_day` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_hours_per_week` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_hours_per_week_decimal_notation` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_hours_per_month_decimal_notation` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_hours_per_year_decimal_notation` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `post_entry_training_hours` smallint DEFAULT NULL,
  `training_no1_hours` double(8,2) DEFAULT NULL,
  `training_no2_hours` double(8,2) DEFAULT NULL,
  `training_no3_hours` double(8,2) DEFAULT NULL,
  `training_span_period` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_no1_basic_salary_for_month` decimal(10,0) DEFAULT NULL,
  `training_no1_basic_salary_for_day` decimal(10,0) DEFAULT NULL,
  `training_no1_basic_salary_for_hour` decimal(10,0) DEFAULT NULL,
  `training_no2_basic_salary_for_month` decimal(10,0) DEFAULT NULL,
  `training_no2_basic_salary_for_day` decimal(10,0) DEFAULT NULL,
  `training_no2_basic_salary_for_hour` decimal(10,0) DEFAULT NULL,
  `training_no3_basic_salary_for_month` decimal(10,0) DEFAULT NULL,
  `training_no3_basic_salary_for_day` decimal(10,0) DEFAULT NULL,
  `training_no3_basic_salary_for_hour` decimal(10,0) DEFAULT NULL,
  `comuting_allowance` decimal(10,0) DEFAULT NULL,
  `approx_amount` decimal(10,0) DEFAULT NULL,
  `food_expense_div` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `food_expense_amount` decimal(10,0) DEFAULT NULL,
  `house_expense_amount` decimal(10,0) DEFAULT NULL,
  `accommodation_type` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `light_heat_fee_div` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `light_heat_fee` decimal(10,0) DEFAULT NULL,
  `other_amount` decimal(10,0) DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `contract_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `airport_date_sche` date DEFAULT NULL,
  `contract_period_note_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contract_period_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contract_period_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_note_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_content_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_content_lang2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_content_note_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_time_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fixtime_begin_time_am` date DEFAULT NULL,
  `fixtime_end_time_am` date DEFAULT NULL,
  `fixtime_lunch_begin_time` date DEFAULT NULL,
  `fixtime_lunch_end_time` date DEFAULT NULL,
  `fixtime_begin_time_pm` date DEFAULT NULL,
  `fixtime_end_time_pm` date DEFAULT NULL,
  `fixtime_break1_begin_time` date DEFAULT NULL,
  `fixtime_break1_end_time` date DEFAULT NULL,
  `fixtime_break2_begin_time` date DEFAULT NULL,
  `fixtime_break2_end_time` date DEFAULT NULL,
  `flextime_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `train_planing_beshi` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companybook_no_from_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companybook_no_from_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companybook_no_to_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companybook_no_from_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `companybook_no_to_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `workpartern_time_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `workpatern_time_note_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `workpartern_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `general_break_day_0` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `break_day_year_sum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_break_day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_break_day_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `break_day_note_pdf` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `break_day_note_pdf_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_leaveoff_type` int DEFAULT NULL,
  `other_leaveoff_sum_day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_leaveoff_breakday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_leaveoff_breakday_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leaveoff_day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `6leaveoff_day_sum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paided_leaveoff_day` int DEFAULT NULL,
  `is_have_6_leaveoff_month_sum` int DEFAULT NULL,
  `paid_breakoff_day_sum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid_breakoff_day_sum_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nopaid_breakoff_day_sum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nopaid_breakoff_day_sum_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `breakoff_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_policy_from_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_inputform` int DEFAULT NULL,
  `inputform_id` int DEFAULT NULL,
  `company_policy_to_1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_policy_from_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_policy_to_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_policy_from_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_policy_to_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `company_policy_from_4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `company_policy_to_4` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `breakoff_contract_note_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `breakoff_contract_note_pdf_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `work_begin_date` date DEFAULT NULL,
  `work_end_date` date DEFAULT NULL,
  `leaveoff_day_sum_year_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `leaveoff_day_sum_year_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `leaveoff_day_sum_year_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `salary_type` int DEFAULT NULL,
  `salary_type_day_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `salary_type_hour_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `supply_meal_type` int DEFAULT NULL,
  `supply_meal_method` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `actual_supply_meal_method` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `supply_house_type` int DEFAULT NULL,
  `actual_supply_house` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `supply_utility_cost_type` int DEFAULT NULL,
  `supply_utility_cost_value` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_type` int DEFAULT NULL,
  `regular_cost_value_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_month_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_real_type_1` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_month_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_real_type_2` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_month_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_real_type_3` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `regular_cost_value_note` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `other_regular_cost_value_note` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_before_day` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_company_policy_from_1` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_company_policy_to_1` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_company_policy_from_2` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_company_policy_to_2` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_company_policy_note_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `retire_company_policy_note_lang` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `other_retire_koseinenkin_type` int DEFAULT NULL,
  `other_retire_kokuminnenkin_type` int DEFAULT NULL,
  `other_retire_kenkohoken_type` int DEFAULT NULL,
  `other_retire_kokuminkenkohoken_type` int DEFAULT NULL,
  `other_retire_koyohoken_type` int DEFAULT NULL,
  `other_retire_kasaihoken_type` int DEFAULT NULL,
  `other_retire_other_type` int DEFAULT NULL,
  `other_retire_other_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employ_kenkoshindan_year` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employ_kenkoshindan_month` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `first_kenkoshindan_year` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `next_kenkoshindan_year` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employ_kenkoshindan_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `employ_kenkoshindan_note_pdf` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_trainee_contract`
--

INSERT INTO `em_trainee_contract` VALUES (1,NULL,1,'2024-08-20','2024-08-21','2024-08-12',1,3,1,444,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,1,'2024-08-19 21:23:55',NULL,'2024-08-19 21:23:55',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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 `em_trainee_edu_level`
--

CREATE TABLE `em_trainee_edu_level` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trainee_id` int DEFAULT NULL,
  `edu_level_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `edu_level_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `edu_level_note` varchar(255) 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 `em_trainee_edu_level`
--

INSERT INTO `em_trainee_edu_level` VALUES (2,1,'2021','2022','鎌ヶ谷中学校','2024-07-31 11:12:18','2024-07-31 11:12:18',NULL),(3,1,'2004','2005','あいうえお','2024-07-31 11:15:52','2024-07-31 11:15:52',NULL);

--
-- Table structure for table `em_trainee_exam`
--

CREATE TABLE `em_trainee_exam` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trainee_id` bigint NOT NULL,
  `exam_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `exam_company` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `result` int DEFAULT NULL,
  `noexam_reason` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `em_trainee_exam`
--


--
-- Table structure for table `em_trainee_healthcheck`
--

CREATE TABLE `em_trainee_healthcheck` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trainee_id` int NOT NULL,
  `status` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `re_check_date` date DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `em_trainee_healthcheck`
--


--
-- Table structure for table `em_trainee_passport`
--

CREATE TABLE `em_trainee_passport` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` int DEFAULT NULL,
  `trainee_id` bigint DEFAULT NULL,
  `file_id` int DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_trainee_passport`
--

INSERT INTO `em_trainee_passport` VALUES (1,1,1,1356,'33333','2024-07-11','2024-07-18',NULL,NULL,'2024-07-26 02:10:20',NULL,'2024-07-26 02:10:20',1);

--
-- Table structure for table `em_trainee_trainingstatus`
--

CREATE TABLE `em_trainee_trainingstatus` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trainee_id` int NOT NULL,
  `month` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `workdaycount_planning` int DEFAULT NULL,
  `workdaycount` int DEFAULT NULL,
  `workdaypercent` int DEFAULT NULL,
  `leavedaycount` int DEFAULT NULL,
  `paidleavedaycount` int DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `em_trainee_trainingstatus`
--


--
-- Table structure for table `em_trainee_visitreport`
--

CREATE TABLE `em_trainee_visitreport` (
  `trainee_visitreport_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `trainee_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `month_number` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `plan_progress_1` int DEFAULT NULL,
  `plan_progress_2` int DEFAULT NULL,
  `plan_progress_3` int DEFAULT NULL,
  `progress_1` int DEFAULT NULL,
  `progress_2` int DEFAULT NULL,
  `progress_3` int DEFAULT NULL,
  `life_status_1` int DEFAULT NULL,
  `life_status_2` int DEFAULT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`trainee_visitreport_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_trainee_visitreport`
--

INSERT INTO `em_trainee_visitreport` VALUES (1,3,NULL,'2024-04-09 08:03:28',NULL,'2024-04-09 08:03:28',1,123123,'2024-04-09',1,2,2,3,3,3,2,2,'123');

--
-- Table structure for table `em_trainee_work`
--

CREATE TABLE `em_trainee_work` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trainee_id` int NOT NULL,
  `work_history_from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_history_to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `em_trainee_work`
--

INSERT INTO `em_trainee_work` VALUES (7,1,'2004','2005','株式会社あいえお','事務総務','2024-07-31 11:16:53','2024-07-31 11:16:53'),(8,1,'2005','2007','株式会社あいうえお','そうざい製造','2024-08-18 07:06:16','2024-08-18 07:06:16');

--
-- Table structure for table `em_trainee_work_gino`
--

CREATE TABLE `em_trainee_work_gino` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `trainee_id` bigint NOT NULL,
  `year` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_job_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `em_trainee_work_gino`
--

INSERT INTO `em_trainee_work_gino` VALUES (1,1,'2022','飲食','あぢいう\r\nかっくけこ','2024-08-03 05:42:35','2024-08-03 05:42:35');

--
-- Table structure for table `em_trainee_zairyucard`
--

CREATE TABLE `em_trainee_zairyucard` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` int DEFAULT NULL,
  `trainee_id` bigint DEFAULT NULL,
  `file_id` int DEFAULT NULL,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `residence_type` int DEFAULT NULL,
  `expiration_period` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expiration_date` date DEFAULT NULL,
  `permit_date` date DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `is_visa_failed` tinyint(1) DEFAULT NULL,
  `visa_failed_note` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_trainee_zairyucard`
--

INSERT INTO `em_trainee_zairyucard` VALUES (1,1,1,1304,'A11111333',1,'3','2024-07-20','2024-07-25','2024-08-07',NULL,NULL,'2024-07-20 02:29:48',NULL,'2024-07-20 02:29:48',1,NULL,NULL),(2,0,1,1641,'33333',1,'3333','2024-08-15','2024-08-15','2024-09-04',NULL,NULL,'2024-08-02 21:15:02',NULL,'2024-08-02 21:15:02',1,NULL,NULL),(3,0,1,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,'2024-08-17 22:22:38',NULL,'2024-08-17 22:22:38',1,1,'đafsad\r\ndddrrr\r\ndàdfdfd');

--
-- Table structure for table `em_training_facility`
--

CREATE TABLE `em_training_facility` (
  `training_facility_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address2` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `food_expense_payment` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `food_expense_payment_detail` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `food_expense_trainee_charge` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `food_expense_trainee_charge_detail` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `food_expense_comment` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_cost_payment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_cost_payment_detail` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_cost_trainee_charge` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_cost_trainee_charge_detail` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_form` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_form_detail` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_tel` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_postcode` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_address1` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_address2` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_area` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_person` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_place_room_area` varchar(254) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `phone` varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_on` date DEFAULT NULL,
  `status` tinyint DEFAULT NULL,
  PRIMARY KEY (`training_facility_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_training_facility`
--

INSERT INTO `em_training_facility` VALUES (1,'test12123123','test13','test14','test15','test16','0','test17','0','test12','test13','0','test14','0','test15','99','test12','test14','test13','test15','test16','test18','test17','test19','test111',1,'2023-12-20 16:48:06',1,'2024-02-23 13:50:15',1,NULL,NULL,NULL,NULL),(2,'facility1','facility1','facility1','facility1','facility1','1','facility1','1','facility1','facility1','1','facility1','1','facility1','01',NULL,'facility1','facility1','facility1','facility1','facility1','facility1','facility1','facility1',1,'2023-12-20 18:05:05',1,'2023-12-20 18:05:05',1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `em_workflow_template`
--

CREATE TABLE `em_workflow_template` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_workflow_template`
--

INSERT INTO `em_workflow_template` VALUES (1,'321321421421',1,'2024-08-28 23:41:14',NULL,'2024-08-28 23:41:14',NULL,1),(2,'dsa',1,'2024-08-29 00:02:51',NULL,'2024-08-29 00:02:51',NULL,1);

--
-- Table structure for table `em_workflow_template_state`
--

CREATE TABLE `em_workflow_template_state` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `workflow_template_id` bigint DEFAULT NULL,
  `sort_order` tinyint DEFAULT NULL,
  `pre_state_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `label` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `next_state_id` int DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `updated_count` int DEFAULT NULL,
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `em_workflow_template_state`
--

INSERT INTO `em_workflow_template_state` VALUES (1,1,1,NULL,'state 1',NULL,NULL,1,'2024-08-29 14:44:34',1,'2024-08-29 16:52:19',8,1),(2,1,3,NULL,'state2',NULL,NULL,1,'2024-08-29 14:48:38',1,'2024-08-29 16:52:19',8,1),(3,1,5,NULL,'state_4',NULL,NULL,1,'2024-08-29 15:01:47',1,'2024-08-29 16:36:38',5,1),(4,1,2,NULL,'state_3',NULL,NULL,1,'2024-08-29 15:01:53',1,'2024-08-29 16:52:19',6,1),(6,1,4,NULL,'sata5',NULL,NULL,1,'2024-08-29 15:08:40',1,'2024-08-29 16:45:47',7,1);

--
-- Table structure for table `et_audit_report`
--

CREATE TABLE `et_audit_report` (
  `audit_report_id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_id` bigint DEFAULT NULL,
  `customer_office_id` bigint DEFAULT NULL,
  `audit_date` date DEFAULT NULL,
  `last_audit_date` date DEFAULT NULL,
  `next_audit_date` date DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`audit_report_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_audit_report`
--

INSERT INTO `et_audit_report` VALUES (1,1,1,'2023-12-30','2023-12-30','2023-12-21',1,'2023-12-24 12:13:42',1,'2023-12-24 12:24:21',2,1),(2,5,7,'2023-12-28','2024-01-03','2023-12-25',1,'2023-12-29 17:38:06',1,'2023-12-29 17:42:59',1,1),(3,4,6,'2023-12-29','2023-12-31','2023-12-30',1,'2023-12-29 17:44:41',NULL,'2023-12-29 17:44:41',NULL,1);

--
-- Table structure for table `et_bookmark`
--

CREATE TABLE `et_bookmark` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `company_id` int NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_bookmark`
--

INSERT INTO `et_bookmark` VALUES (14,'ダッシュボード','Dashboard','/dashboard','<svg xmlns=\"http://www.w3.org/2000/svg\" class=\"side-menu__icon\" viewBox=\"0 0 24 24\"><path fill=\"currentColor\" d=\"M21 16V4H3v12zm0-14a2 2 0 0 1 2 2v12a2 2 0 0 1-2 2h-7v2h2v2H8v-2h2v-2H3a2 2 0 0 1-2-2V4c0-1.11.89-2 2-2zM5 6h9v5H5zm10 0h4v2h-4zm4 3v5h-4V9zM5 12h4v2H5zm5 0h4v2h-4z\"></path></svg>','2024-08-30 23:24:18','2024-08-30 23:24:18',1,1);

--
-- Table structure for table `et_candidate`
--

CREATE TABLE `et_candidate` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_kana` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `gender` int DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `academic_background` int DEFAULT NULL,
  `body_height` int DEFAULT NULL,
  `body_weight` int DEFAULT NULL,
  `marital_relationship` int DEFAULT NULL,
  `status` int NOT NULL,
  `cv_file_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_count` int DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `is_copy` int DEFAULT NULL,
  `copy_from_id` int DEFAULT NULL,
  `candidate_curriculumvitae_id` bigint DEFAULT NULL,
  `trainee_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_candidate`
--


--
-- Table structure for table `et_candidate_curriculumvitae`
--

CREATE TABLE `et_candidate_curriculumvitae` (
  `candidate_curriculumvitae_id` bigint NOT NULL AUTO_INCREMENT,
  `candidate_id` bigint DEFAULT NULL,
  `academic_level` int DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `edu_level_from1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `edu_level_to1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `edu_level_note1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_worked_2go` int DEFAULT NULL,
  `worked_2go_date_from` date DEFAULT NULL,
  `worked_2go_date_to` date DEFAULT NULL,
  `work_history_from1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_history_to1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_company_name1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_job_name1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_worked_construct` int DEFAULT NULL,
  `worked_construct_date_from` date DEFAULT NULL,
  `worked_construct_date_to` date DEFAULT NULL,
  `jobtype_name1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `jobtype_experience_year1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `jobtype_note_year1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `jobtype_name2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `jobtype_experience_year2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `jobtype_note_year2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lang_level_japanese` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lang_level_english` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lang_level_other` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_experience_place` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_expericene_year` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `visit_japan_history` int DEFAULT NULL,
  `visit_japan_history_fromdate` date DEFAULT NULL,
  `visit_japan_history_todate` date DEFAULT NULL,
  `visit_japan_history_visaname` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ginojishuse` int DEFAULT NULL,
  `ginojishusei_other` int DEFAULT NULL,
  `work_as_ginojishusei` int DEFAULT NULL,
  `work_as_ginojishusei_fromdate` date DEFAULT NULL,
  `work_as_ginojishusei_todate` date DEFAULT NULL,
  `work_as_ginojishusei_type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_visa_failed` int DEFAULT NULL,
  `visa_failed_reason` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `visit_japan_other` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `is_work_as_nurse` int DEFAULT NULL,
  `work_as_nurse_fromdate` date DEFAULT NULL,
  `work_as_nurse_todate` date DEFAULT NULL,
  `is_inputform` int DEFAULT NULL,
  `inputform_id` bigint DEFAULT NULL,
  PRIMARY KEY (`candidate_curriculumvitae_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_candidate_curriculumvitae`
--

INSERT INTO `et_candidate_curriculumvitae` VALUES (33,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,0,'2024-08-21','2024-08-21',NULL,NULL,NULL,NULL,0,'2024-08-13','2024-08-13','asadsd','asdasd','asdasd','asdasd','asdasd','asdasd','asdasd','asdasd','adasda','asdasd','adasdasd',0,'2024-08-20','2024-08-21','asdasd',1,1,1,'2024-08-21','2024-08-21','asdasdas',1,'asdasdasd','uyuuu',0,'2024-08-21','2024-08-20',NULL,NULL),(34,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,1,'2024-09-01','2024-09-02',NULL,NULL,NULL,NULL,0,'2024-09-09','2024-09-10','test','5','test123456','1111','10','2222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_candidate_curriculumvitae_edu_lever`
--

CREATE TABLE `et_candidate_curriculumvitae_edu_lever` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_candidate_curriculumvitae_id` int DEFAULT NULL,
  `edu_level_from1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `edu_level_to1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `edu_level_note1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_candidate_curriculumvitae_edu_lever`
--

INSERT INTO `et_candidate_curriculumvitae_edu_lever` VALUES (1,14,'test','0','3','2024-04-18 00:20:58','2024-04-18 00:57:09'),(3,8,'zcxzc','zxczxc','zxczxc','2024-04-18 09:04:15','2024-04-18 09:04:40'),(4,8,'zxczxc','xczc','zczcx','2024-04-18 09:04:15','2024-04-18 09:04:40'),(5,8,'zxcz','zxcxzc','zxczxc','2024-04-18 09:04:40','2024-04-18 09:04:40');

--
-- Table structure for table `et_candidate_curriculumvitae_work`
--

CREATE TABLE `et_candidate_curriculumvitae_work` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_candidate_curriculumvitae_id` int NOT NULL,
  `work_history_from1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_history_to1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_company_name1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_job_name1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_candidate_curriculumvitae_work`
--

INSERT INTO `et_candidate_curriculumvitae_work` VALUES (4,8,'xzczxc','zxczxc','xczxc','xczxc','2024-04-18 09:04:15','2024-04-18 09:04:40'),(5,8,'zxczc','zxczx','zxczxc','zxczc','2024-04-18 09:04:15','2024-04-18 09:04:40'),(6,8,'xzczxc','zxc','zxc','zxczx','2024-04-18 09:04:15','2024-04-18 09:04:40');

--
-- Table structure for table `et_comment`
--

CREATE TABLE `et_comment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `table_record_id` int DEFAULT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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',
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_comment`
--

INSERT INTO `et_comment` VALUES (1,NULL,'2024-04-24','rasdasd','asdasdasd',71,'et_project','2024-04-23 23:11:17',1,'2024-04-23 23:11:17',NULL,0,1);

--
-- Table structure for table `et_doc_agreement_certificate`
--

CREATE TABLE `et_doc_agreement_certificate` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contract_date` date DEFAULT NULL,
  `edu_month_count` int DEFAULT NULL,
  `edu_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobtype_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `implementer_type` json DEFAULT NULL COMMENT '1: 教育機関   2:実習実施者   3:管理団体    4:外国の送出機関',
  `content_category` json DEFAULT NULL,
  `content_category_note` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `worker_type` int DEFAULT NULL,
  `worker_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,
  `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,
  `company_id` int DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_agreement_certificate`
--

INSERT INTO `et_doc_agreement_certificate` VALUES (1,'123','TRAN PHU HA DONG HA NOI','0867634618','sda@gmail.com','Dang Tiep','center_address','center_tel','center_mail','2024-06-20',10,'edu_content','code_name','code_name','code_name','code_name','2','4','ádasd','2024-06-12',1,'worker_name ádasd','director_name',NULL,NULL,NULL,NULL,1,1,6),(3,'test','test2','1111111111','test2gmail.com','center_name','center_address','center_tel','test2gmail.com','2024-09-02',123,'edu_content','code_name','trst','work_name','other_note','2','4','test note','2024-09-10',1,'worker_name','test3',NULL,NULL,NULL,NULL,1,1,2);

--
-- Table structure for table `et_doc_application_cancel`
--

CREATE TABLE `et_doc_application_cancel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `cancel_reason` 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_0900_ai_ci;

--
-- Dumping data for table `et_doc_application_cancel`
--

INSERT INTO `et_doc_application_cancel` VALUES (1,'2024-07-02','test1','tesst','2024-07-14',0,1,'cancel_reason',NULL,NULL,NULL,1,1,6),(2,'2024-07-10','company_name','company_name','2024-07-17',1,0,'cancel_reason',NULL,NULL,NULL,NULL,1,0),(3,'2024-09-01','test','company_name','2024-09-02',1,1,'cancel_reason',NULL,NULL,NULL,1,1,3);

--
-- Table structure for table `et_doc_apply_trainee_list`
--

CREATE TABLE `et_doc_apply_trainee_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_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` timestamp NULL 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_0900_ai_ci;

--
-- Dumping data for table `et_doc_apply_trainee_list`
--

INSERT INTO `et_doc_apply_trainee_list` VALUES (1,'customer',NULL,NULL,NULL,NULL,NULL,NULL,0),(2,'customer_name',NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_apply_trainee_list_namelist`
--

CREATE TABLE `et_doc_apply_trainee_list_namelist` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `apply_trainee_list_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `sex` int DEFAULT NULL COMMENT '1: 男, 2:女',
  `trainning_type` int DEFAULT NULL COMMENT '1: 第１号企業単独型技能実習;  \r\n2:第２号企業単独型技能実習;  3: 第３号企業単独型技能実習;  4:第１号団体監理型技能実習;  5:第２号団体監理型技能実習;  6:第３号団体監理型技能実習',
  `updated_at` datetime DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_apply_trainee_list_namelist`
--

INSERT INTO `et_doc_apply_trainee_list_namelist` VALUES (1,2,'trainee1','nation1','2024-06-17',1,4,'2024-08-08 23:28:37','2024-06-24 06:14:19'),(2,2,'trainee2','nation2','2024-06-25',0,3,'2024-08-08 23:28:37','2024-06-24 06:14:19'),(3,2,'trainee3','natio3','2024-06-04',1,2,'2024-08-08 23:28:37','2024-06-24 06:17:01'),(4,2,'4','4',NULL,0,1,'2024-08-08 23:28:37','2024-06-25 21:43:18'),(5,2,'5','5',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(6,2,'6','6',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(7,2,'7','7',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(8,2,'8','8',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(9,2,'9','9',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(10,2,'11','11',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(11,2,'12','12',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(12,2,'13','13',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(13,2,'14','14',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(14,2,'15','15',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 02:43:16'),(31,2,'15','15',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 04:02:55'),(32,2,'16','16',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 04:02:55'),(33,2,'17','17',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 04:02:55'),(34,2,'18','18',NULL,1,1,'2024-08-08 23:28:37','2024-06-26 04:02:55'),(35,2,'35','35',NULL,1,1,'2024-08-13 12:29:32','2024-08-13 12:29:32'),(36,2,'356','36',NULL,1,1,'2024-08-13 12:29:32','2024-08-13 12:29:32'),(37,2,'37','37',NULL,1,1,'2024-08-13 12:29:32','2024-08-13 12:29:32'),(38,2,'38','38',NULL,1,1,'2024-08-13 12:29:32','2024-08-13 12:29:32'),(39,2,'39','39',NULL,1,1,'2024-08-13 12:29:32','2024-08-13 12:29:32'),(40,2,'40','321',NULL,1,1,'2024-08-13 12:29:32','2024-08-13 12:29:32'),(41,2,'dsa','dsa',NULL,1,1,'2024-08-13 12:29:59','2024-08-13 12:29:59'),(42,2,'231','111',NULL,1,1,'2024-08-13 12:29:59','2024-08-13 12:29:59'),(43,2,'321','321',NULL,1,1,'2024-08-13 12:29:59','2024-08-13 12:29:59');

--
-- Table structure for table `et_doc_audit_implementation_overview`
--

CREATE TABLE `et_doc_audit_implementation_overview` (
  `id` int NOT NULL AUTO_INCREMENT,
  `type_1_1` tinyint(1) DEFAULT NULL,
  `type_content_1_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_1_2` tinyint(1) DEFAULT NULL,
  `type_content_1_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_1_3` tinyint(1) DEFAULT NULL,
  `type_content_1_3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_1_4` tinyint(1) DEFAULT NULL,
  `type_content_1_4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_1_5` tinyint(1) DEFAULT NULL,
  `type_content_1_5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_1_6` tinyint(1) DEFAULT NULL,
  `type_content_1_6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_1` tinyint(1) DEFAULT NULL,
  `type_content_2_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_2` tinyint(1) DEFAULT NULL,
  `type_content_2_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_3` tinyint(1) DEFAULT NULL,
  `type_content_2_3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_4` tinyint(1) DEFAULT NULL,
  `type_content_2_4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_5` tinyint(1) DEFAULT NULL,
  `type_content_2_5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_6` tinyint(1) DEFAULT NULL,
  `type_content_2_6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_7` tinyint(1) DEFAULT NULL,
  `type_content_2_7` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_8` tinyint(1) DEFAULT NULL,
  `type_content_2_8` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_9` tinyint(1) DEFAULT NULL,
  `type_content_2_9` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_10` tinyint(1) DEFAULT NULL,
  `type_content_2_10` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_11` tinyint(1) DEFAULT NULL,
  `type_content_2_11` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_12` tinyint(1) DEFAULT NULL,
  `type_content_2_12` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_13` tinyint(1) DEFAULT NULL,
  `type_content_2_13` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_14` tinyint(1) DEFAULT NULL,
  `type_content_2_14` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_15` tinyint(1) DEFAULT NULL,
  `type_content_2_15` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_16` tinyint(1) DEFAULT NULL,
  `type_content_2_16` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_17` tinyint(1) DEFAULT NULL,
  `type_content_2_17` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_18` tinyint(1) DEFAULT NULL,
  `type_content_2_18` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_19` tinyint(1) DEFAULT NULL,
  `type_content_2_19` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_20` tinyint(1) DEFAULT NULL,
  `type_content_2_20` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_21` tinyint(1) DEFAULT NULL,
  `type_content_2_21` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_2_22` tinyint(1) DEFAULT NULL,
  `type_content_2_22` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_1` tinyint(1) DEFAULT NULL,
  `type_content_3_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_2` tinyint(1) DEFAULT NULL,
  `type_content_3_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_3` tinyint(1) DEFAULT NULL,
  `type_content_3_3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_4` tinyint(1) DEFAULT NULL,
  `type_content_3_4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_5` tinyint(1) DEFAULT NULL,
  `type_content_3_5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_6` tinyint(1) DEFAULT NULL,
  `type_content_3_6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_7` tinyint(1) DEFAULT NULL,
  `type_content_3_7` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_8` tinyint(1) DEFAULT NULL,
  `type_content_3_8` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_9` tinyint(1) DEFAULT NULL,
  `type_content_3_9` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_10` tinyint(1) DEFAULT NULL,
  `type_content_3_10` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_11` tinyint(1) DEFAULT NULL,
  `type_content_3_11` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_12` tinyint(1) DEFAULT NULL,
  `type_content_3_12` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_13` tinyint(1) DEFAULT NULL,
  `type_content_3_13` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_14` tinyint(1) DEFAULT NULL,
  `type_content_3_14` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_15` tinyint(1) DEFAULT NULL,
  `type_content_3_15` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_16` tinyint(1) DEFAULT NULL,
  `type_content_3_16` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_17` tinyint(1) DEFAULT NULL,
  `type_content_3_17` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_3_18` tinyint(1) DEFAULT NULL,
  `type_content_3_18` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_1` tinyint(1) DEFAULT NULL,
  `type_content_4_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_2` tinyint(1) DEFAULT NULL,
  `type_content_4_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_3` tinyint(1) DEFAULT NULL,
  `type_content_4_3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_4` tinyint(1) DEFAULT NULL,
  `type_content_4_4` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_5` tinyint(1) DEFAULT NULL,
  `type_content_4_5` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_6` tinyint(1) DEFAULT NULL,
  `type_content_4_6` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_7` tinyint(1) DEFAULT NULL,
  `type_content_4_7` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_8` tinyint(1) DEFAULT NULL,
  `type_content_4_8` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_9` tinyint(1) DEFAULT NULL,
  `type_content_4_9` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_10` tinyint(1) DEFAULT NULL,
  `type_content_4_10` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_11` tinyint(1) DEFAULT NULL,
  `type_content_4_11` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_12` tinyint(1) DEFAULT NULL,
  `type_content_4_12` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_13` tinyint(1) DEFAULT NULL,
  `type_content_4_13` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_14` tinyint(1) DEFAULT NULL,
  `type_content_4_14` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_15` tinyint(1) DEFAULT NULL,
  `type_content_4_15` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type_4_16` tinyint(1) DEFAULT NULL,
  `type_content_4_16` text COLLATE utf8mb4_unicode_ci,
  `type_4_17` tinyint(1) DEFAULT NULL,
  `type_content_4_17` text COLLATE utf8mb4_unicode_ci,
  `type_4_18` tinyint(1) DEFAULT NULL,
  `type_content_4_18` text COLLATE utf8mb4_unicode_ci,
  `type_4_19` tinyint(1) DEFAULT NULL,
  `type_content_4_19` text COLLATE utf8mb4_unicode_ci,
  `type_4_20` tinyint(1) DEFAULT NULL,
  `type_content_4_20` text COLLATE utf8mb4_unicode_ci,
  `type_4_21` tinyint(1) DEFAULT NULL,
  `type_content_4_21` text COLLATE utf8mb4_unicode_ci,
  `type_4_22` tinyint(1) DEFAULT NULL,
  `type_content_4_22` text COLLATE utf8mb4_unicode_ci,
  `type_5_1` tinyint(1) DEFAULT NULL,
  `type_content_5_1` text COLLATE utf8mb4_unicode_ci,
  `type_5_2` tinyint(1) DEFAULT NULL,
  `type_content_5_2` text COLLATE utf8mb4_unicode_ci,
  `type_5_3` tinyint(1) DEFAULT NULL,
  `type_content_5_3` text COLLATE utf8mb4_unicode_ci,
  `content_6` text COLLATE utf8mb4_unicode_ci,
  `content_7` text COLLATE utf8mb4_unicode_ci,
  `sign_date` date DEFAULT NULL,
  `sign_name` text 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_audit_implementation_overview`
--

INSERT INTO `et_doc_audit_implementation_overview` VALUES (1,1,'type_content_1_1',2,'type_content_1_2',2,'type_content_1_3',2,'type_content_1_4',1,'type_content_1_5',1,'type_content_1_6',1,'type_content_2_1',2,'type_content_2_2',1,'type_content_2_3',1,'type_content_2_4',1,'type_content_2_5',1,'type_content_2_6',1,'type_content_2_7',1,'type_content_2_8',2,'type_content_2_9',2,'type_content_2_10',1,'type_content_2_11',1,'type_content_2_12',1,'type_content_2_13',1,'type_content_2_14',1,'type_content_2_15',1,'type_content_2_16',1,'type_content_2_17',1,'type_content_2_18',1,'type_content_2_19',1,'type_content_2_20',1,'type_content_2_21',1,'type_content_2_22',1,'type_content_3_1',1,'type_content_3_2',1,'type_content_3_3',1,'type_content_3_4',1,'type_content_3_5',1,'type_content_3_6',1,'type_content_3_7',1,'type_content_3_8',1,'type_content_3_9',1,'type_content_3_10',1,'type_content_3_11',1,'type_content_3_12',1,'type_content_3_13',1,'type_content_3_14',1,'type_content_3_15',1,'type_content_3_16',1,'type_content_3_17',NULL,NULL,1,'type_content_4_1',1,'type_content_4_2',1,'type_content_4_3',1,'type_content_4_4',1,'type_content_4_5',1,'type_content_4_6',1,'type_content_4_7',1,'type_content_4_8',1,'type_content_4_9',1,'type_content_4_10',1,'type_content_4_11',1,'type_content_4_12',1,'type_content_4_13',1,'type_content_4_14',1,'type_content_4_15',1,'type_content_4_16',1,'type_content_4_17',1,'type_content_4_18',1,'type_content_4_19',1,'type_content_4_20',1,'type_content_4_21',NULL,NULL,1,'type_content_5_1',1,'type_content_5_2',NULL,NULL,'content_6','content_7','2024-07-31','sign_name',NULL,NULL,NULL,NULL,NULL,0),(2,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(3,1,'1',1,'213',1,'4',1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,2,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',NULL,NULL,1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',1,'test',NULL,NULL,1,'test',1,'test',NULL,NULL,'test\r\ntest1','test2\r\ntest3','2024-09-09','note',NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_cert_application_fee`
--

CREATE TABLE `et_doc_cert_application_fee` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created_date` date DEFAULT NULL,
  `money` int DEFAULT NULL,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `check_3` int DEFAULT NULL,
  `check_4` int DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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,
  `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=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_cert_application_fee`
--

INSERT INTO `et_doc_cert_application_fee` VALUES (1,NULL,1,1,1,1,1,'nationality','name','sign_name','sign_creator_name',NULL,NULL,NULL,NULL,NULL,0),(2,'2024-07-19',100000,1,1,0,0,'nationality','name','sign_name','sign_creator_name',NULL,NULL,NULL,NULL,NULL,0),(3,NULL,NULL,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_certificate_filelist`
--

CREATE TABLE `et_doc_certificate_filelist` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `trainee_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` int DEFAULT NULL,
  `support_test_type` int DEFAULT NULL,
  `support_test_date` date DEFAULT NULL,
  `number_1` int DEFAULT NULL,
  `number_2` int DEFAULT NULL,
  `number_3` int DEFAULT NULL,
  `number_4` int DEFAULT NULL,
  `number_5` int DEFAULT NULL,
  `number_6` int DEFAULT NULL,
  `number_7` int DEFAULT NULL,
  `number_8` int DEFAULT NULL,
  `number_9` int DEFAULT NULL,
  `number_10` int DEFAULT NULL,
  `number_11` int DEFAULT NULL,
  `number_12` int DEFAULT NULL,
  `number_13` int DEFAULT NULL,
  `number_14` int DEFAULT NULL,
  `number_15` int DEFAULT NULL,
  `number_16` int DEFAULT NULL,
  `number_17` int DEFAULT NULL,
  `number_18` int DEFAULT NULL,
  `number_19` int DEFAULT NULL,
  `number_20` int DEFAULT NULL,
  `number_21` int DEFAULT NULL,
  `number_22` int DEFAULT NULL,
  `number_23` int DEFAULT NULL,
  `number_24` int DEFAULT NULL,
  `number_25` int DEFAULT NULL,
  `number_26` int DEFAULT NULL,
  `number_27` int DEFAULT NULL,
  `number_28` int DEFAULT NULL,
  `number_29` int DEFAULT NULL,
  `number_30` int DEFAULT NULL,
  `number_31` int DEFAULT NULL,
  `number_32` int DEFAULT NULL,
  `number_33` int DEFAULT NULL,
  `number_34` int DEFAULT NULL,
  `number_35` int DEFAULT NULL,
  `number_36` int DEFAULT NULL,
  `number_37` int DEFAULT NULL,
  `number_38` int DEFAULT NULL,
  `number_39` int DEFAULT NULL,
  `number_40` int DEFAULT NULL,
  `number_41` int DEFAULT NULL,
  `number_42` int DEFAULT NULL,
  `number_43` int DEFAULT NULL,
  `number_44` int DEFAULT NULL,
  `number_45` int DEFAULT NULL,
  `number_46` int DEFAULT NULL,
  `number_47` int DEFAULT NULL,
  `number_48` int DEFAULT NULL,
  `number_49` int DEFAULT NULL,
  `number_50` int DEFAULT NULL,
  `number_51` int DEFAULT NULL,
  `number_52` int DEFAULT NULL,
  `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 NOT 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_certificate_filelist`
--


--
-- Table structure for table `et_doc_certificate_residence`
--

CREATE TABLE `et_doc_certificate_residence` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `place_of_birth` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `marital_status` tinyint(1) DEFAULT NULL,
  `occupation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `home_town` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_japan` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cellular_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport_date_expiration` date DEFAULT NULL,
  `chk_professor` tinyint(1) DEFAULT NULL,
  `chk_Instructor` tinyint(1) DEFAULT NULL,
  `chk_Artist` tinyint(1) DEFAULT NULL,
  `chk_Cultural` tinyint(1) DEFAULT NULL,
  `chk_Religious` tinyint(1) DEFAULT NULL,
  `chk_Journalist` tinyint(1) DEFAULT NULL,
  `chk_Transferee` tinyint(1) DEFAULT NULL,
  `chk_Researcher_Transferee` tinyint(1) DEFAULT NULL,
  `chk_Business` tinyint(1) DEFAULT NULL,
  `chk_Researcher` tinyint(1) DEFAULT NULL,
  `chk_Engineer` tinyint(1) DEFAULT NULL,
  `chk_Nursing` tinyint(1) DEFAULT NULL,
  `chk_Skilled_Labor` tinyint(1) DEFAULT NULL,
  `chk_Designated_IT` tinyint(1) DEFAULT NULL,
  `chk_Designated_Graduate` tinyint(1) DEFAULT NULL,
  `chk_Specified_1` tinyint(1) DEFAULT NULL,
  `chk_Specified_2` tinyint(1) DEFAULT NULL,
  `chk_Entertainer` tinyint(1) DEFAULT NULL,
  `chk_Student` tinyint(1) DEFAULT NULL,
  `chk_Trainee` tinyint(1) DEFAULT NULL,
  `chk_Technical_1` tinyint(1) DEFAULT NULL,
  `chk_Technical_2` tinyint DEFAULT NULL,
  `chk_Technical_3` tinyint(1) DEFAULT NULL,
  `chk_Dependent` tinyint(1) DEFAULT NULL,
  `chk_Dependent_family` tinyint(1) DEFAULT NULL,
  `chk_Dependent_epa` tinyint(1) DEFAULT NULL,
  `chk_Dependent_university` tinyint(1) DEFAULT NULL,
  `chk_Spouse_japanese` tinyint(1) DEFAULT NULL,
  `chk_Spouse_permanent` tinyint(1) DEFAULT NULL,
  `chk_long_term` tinyint(1) DEFAULT NULL,
  `chk_highly_skilled` tinyint(1) DEFAULT NULL,
  `chk_Highly_professional` tinyint(1) DEFAULT NULL,
  `chk_Highly_professional_2` tinyint DEFAULT NULL,
  `chk_others` tinyint DEFAULT NULL,
  `date_entry` date DEFAULT NULL,
  `port_entry` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `intended_stay` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `accompanying_persons` tinyint(1) DEFAULT NULL,
  `intended_visa` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `past_japan_entry` tinyint(1) DEFAULT NULL,
  `past_japan_entry_times` int DEFAULT NULL,
  `past_japan_entry_date_from` date DEFAULT NULL,
  `past_japan_entry_date_to` date DEFAULT NULL,
  `past_eligibility` tinyint(1) DEFAULT NULL,
  `past_eligibility_times` int DEFAULT NULL,
  `past_eligibility_ng_times` int DEFAULT NULL,
  `criminal_record` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `criminal_record_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `departure_order` tinyint(1) DEFAULT NULL,
  `departure_order_times` int DEFAULT NULL,
  `departure_order_date` date DEFAULT NULL,
  `implementing_organization_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `implementing_organization_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `implementing_organization_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `relationship_applicant` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_cellular_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `agent_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `agent_tel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_accreditation_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_accreditation_date` date DEFAULT NULL,
  `trainee_chk_1` tinyint(1) DEFAULT NULL,
  `trainee_chk_2` tinyint(1) DEFAULT NULL,
  `trainee_chk_3` tinyint(1) DEFAULT NULL,
  `trainee_chk_4` tinyint(1) DEFAULT NULL,
  `trainee_chk_5` tinyint(1) DEFAULT NULL,
  `trainee_chk_6` tinyint(1) DEFAULT NULL,
  `trainee_occupation_chk_1` tinyint(1) DEFAULT NULL,
  `trainee_occupation_chk_1_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_occupation_chk_2` tinyint(1) DEFAULT NULL,
  `trainee_occupation_chk_2_detail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_from_date` date DEFAULT NULL,
  `training_from_to` date DEFAULT NULL,
  `return_from_date` date DEFAULT NULL,
  `return_from_to` date DEFAULT NULL,
  `company_place_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_employment_insurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_business_type_1` tinyint(1) DEFAULT NULL,
  `company_business_type_1_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_business_type_multi` tinyint(1) DEFAULT NULL,
  `company_business_type_multi_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_business_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_business_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_staff_number` int DEFAULT NULL,
  `notification_number_acceptance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notification_number_acceptance_date` date DEFAULT NULL,
  `organization_supervising_name2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_business_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_employment_insurance` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_business_type_1` tinyint(1) DEFAULT NULL,
  `organization_supervising_business_type_1_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_business_type_multi` tinyint(1) DEFAULT NULL,
  `organization_supervising_business_type_multi_value` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_address2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_tel2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_type_1` tinyint(1) DEFAULT NULL,
  `organization_supervising_type_2` tinyint(1) DEFAULT NULL,
  `organization_supervising_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `organization_supervising_license_date` date DEFAULT NULL,
  `organization_supervising_license_date_from` date DEFAULT NULL,
  `organization_supervising_license_date_to` date DEFAULT NULL,
  `sign_organization_supervising_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_organization_supervising_date` date DEFAULT NULL,
  `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 NOT 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_certificate_residence`
--

INSERT INTO `et_doc_certificate_residence` VALUES (1,'国 籍・地 域','2024-08-14','test',1,'viet name',1,'occupation','home_town','address_japan','tel','cellular_tel','passport_number','2024-01-01',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,'2024-09-12','port_entry','intended_stay',123,'intended_visa',1,5,'2024-09-06','2024-09-13',1,3,5,'criminal_record','criminal_record_detail',3,5,'2024-09-05','implementing_organization_name','implementing_organization_name','implementing_organization_tel','organization_supervising_name','organization_supervising_address','organization_supervising_tel','applicant_name','relationship_applicant','applicant_address','applicant_tel','applicant_cellular_phone','sign_name','2024-09-14','agent_name','agent_address','agent_organization','agent_tel','certificate_residence.trainee_name','trainee_accreditation_no','2024-09-05',1,1,1,1,1,1,1,'trainee_occupation_chk_1_detail',1,'trainee_occupation_chk_2_detail','2024-09-06','2024-09-26','2024-09-26','2024-09-11','company_place_name','5','company_employment_insurance',1,'company_business_type_1_value',1,'company_business_type_multi_value','company_business_address','company_business_tel',10000,'300','2024-09-17','organization_supervising_name2','100','1111111122',1,'organization_supervising_business_type_1_value',1,'organization_supervising_business_type_multi_value','organization_supervising_address2','organization_supervising_tel2',1,1,'111111111111','2024-09-20','2024-09-19','2024-09-12','sign_organization_supervising_name','2024-09-13',NULL,NULL,1,NULL,1,10);

--
-- Table structure for table `et_doc_certification_plan_management`
--

CREATE TABLE `et_doc_certification_plan_management` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_1_1` tinyint(1) DEFAULT NULL,
  `check_1_2_a` tinyint(1) DEFAULT NULL,
  `check_1_2_b` tinyint(1) DEFAULT NULL,
  `check_1_2_c` tinyint(1) DEFAULT NULL,
  `check_1_3` tinyint(1) DEFAULT NULL,
  `check_1_4` tinyint(1) DEFAULT NULL,
  `check_1_5` tinyint(1) DEFAULT NULL,
  `check_1_6` tinyint(1) DEFAULT NULL,
  `check_2_1` tinyint(1) DEFAULT NULL,
  `check_2_2` tinyint(1) DEFAULT NULL,
  `check_2_3` tinyint(1) DEFAULT NULL,
  `check_2_3_1` tinyint(1) DEFAULT NULL,
  `check_2_3_2` tinyint(1) DEFAULT NULL,
  `check_2_3_3` tinyint(1) DEFAULT NULL,
  `check_2_3_4` tinyint(1) DEFAULT NULL,
  `check_2_3_4_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` 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_supervisor_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_certification_plan_management`
--

INSERT INTO `et_doc_certification_plan_management` VALUES (1,'2024','01',2,2,2,1,2,2,2,2,2,2,1,1,1,1,1,'check_2_3_4_content','certification_plan_management note','2024-07-09','sign_name','sign_supervisor_name',NULL,NULL,NULL,1,1,2),(2,'2024','01',1,2,1,2,2,1,2,1,1,1,1,1,1,1,1,'test12345','test1\r\ntest2\r\ntest3','2024-09-15','hi','test1245',NULL,NULL,NULL,1,1,1);

--
-- Table structure for table `et_doc_customer_brief`
--

CREATE TABLE `et_doc_customer_brief` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_plan_check` int DEFAULT NULL,
  `training_implement_receipt_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `labor_insurance_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_number` varchar(255) DEFAULT NULL,
  `trainee_number_1` int DEFAULT NULL,
  `trainee_number_2` int DEFAULT NULL,
  `trainee_number_3` int DEFAULT NULL,
  `number_1st` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_1st_old` int DEFAULT NULL,
  `number_from1_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_from1_2_old` int DEFAULT NULL,
  `number_from2_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_from2_3_old` int DEFAULT NULL,
  `number_disappear` 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` timestamp NULL 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=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_customer_brief`
--

INSERT INTO `et_doc_customer_brief` VALUES (1,NULL,'training_implement_receipt_number','labor_insurance_number','name_furigana','name','employee_number',NULL,NULL,NULL,'number_1st',10,'number_2st',15,'number_3st',18,'number_disappear','note \r\nnote 1 \r\ntest \r\ntest3\r\ntest 4',NULL,NULL,NULL,NULL,NULL,0),(2,NULL,'123456789','AA-11-BB22-C-2222','きこう　かぶしきがいしゃ','機構　株式会社','120',NULL,NULL,NULL,'1',10,'2',2,'3',3,'2','test',NULL,NULL,NULL,NULL,NULL,0),(3,NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0),(4,NULL,'1','労働保険番号','ふりがな','氏名又は名称',NULL,NULL,NULL,NULL,'25',1,'10',3,'5',8,'行方不明年月日','test1\r\ntest2',NULL,NULL,NULL,NULL,NULL,0),(5,NULL,'実習実施者届出受理番号','労働保険番号','ふりがな','氏名又は名称','100',NULL,NULL,NULL,'3',1,'2',2,'3',2,'5','test\r\ntest1\r\ntest3',NULL,NULL,NULL,NULL,NULL,0),(6,1,NULL,NULL,NULL,'有限会社種市水耕農場',NULL,NULL,NULL,NULL,'0',NULL,'0',NULL,'0',NULL,NULL,NULL,'2024-08-14 17:38:03',NULL,'2024-08-14 17:38:03',NULL,1,0),(7,1,'2222222','222222','あいうえおかきくけこ','山重建設工業株式会社_test','2222',NULL,NULL,NULL,'1',NULL,'2',NULL,'3',NULL,'4<br />\r\n5<br />\r\n6<br />\r\n&nbsp;','あいうえお<br />\r\nかきくけこ<br />\r\nさしすせそ','2024-08-16 21:53:32',NULL,'2024-08-16 21:53:32',NULL,1,0);

--
-- Table structure for table `et_doc_director_pledge`
--

CREATE TABLE `et_doc_director_pledge` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_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,
  `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_0900_ai_ci;

--
-- Dumping data for table `et_doc_director_pledge`
--

INSERT INTO `et_doc_director_pledge` VALUES (1,'2024-06-03','test1','test2',NULL,NULL,NULL,NULL,NULL,NULL,0),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_director_pledge_listname`
--

CREATE TABLE `et_doc_director_pledge_listname` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `director_pledge_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_director_pledge_listname`
--

INSERT INTO `et_doc_director_pledge_listname` VALUES (1,2,'a','アルゼンチン',NULL,NULL),(2,2,'1','',NULL,NULL),(3,2,'2','',NULL,NULL),(4,2,'3','',NULL,NULL),(5,2,'4','',NULL,NULL),(6,2,'5','',NULL,NULL);

--
-- Table structure for table `et_doc_edu_brief`
--

CREATE TABLE `et_doc_edu_brief` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `center_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,
  `center_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `establishment_date` date DEFAULT NULL,
  `center_type` int DEFAULT NULL COMMENT '1: 大学, 2: 高校, 3: 職業訓練校, 4: その他',
  `center_university_dep_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_type_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `edu_content` varchar(6000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobtype_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_center_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,
  `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,
  `company_id` int DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_edu_brief`
--

INSERT INTO `et_doc_edu_brief` VALUES (2,'123','director_name','center address','0123456789','test2gmail.com','2024-06-03',1,'test name','center other','edu content 123','job content','2024-06-03','test','test',NULL,NULL,NULL,NULL,1,1,1),(3,'center_name','director_name','center_address','center_tel','test2gmail.com','2024-10-01',3,'test name','center other','test\r\ntest133','job content','2024-09-02','sign_center_name','sign_director_name',NULL,NULL,NULL,NULL,1,1,2);

--
-- Table structure for table `et_doc_evaluation_trainee`
--

CREATE TABLE `et_doc_evaluation_trainee` (
  `id` bigint 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,
  `birthdate` date DEFAULT NULL,
  `trainer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `national` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test_date` date DEFAULT NULL,
  `test_result` tinyint(1) DEFAULT NULL COMMENT '1: 合格 ; 0: 不合格',
  `reason_not_test` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_teacher` varchar(6000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_life_coach` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_trainer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_trainer` 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,
  `sign_supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_organization` 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` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_evaluation_trainee`
--

INSERT INTO `et_doc_evaluation_trainee` VALUES (1,'allaskdasdiai','hasdhahsd','2024-09-10','asdhashdhashda','u7273y2y3',0,'Quốc tịch/khu vực','Tổ chức giám sát','test','2024-09-07',0,'test','ok','ok','ok','ok','2024-09-10','Người thực hiện đào tạo','Giám đốc đào tạo kỹ thuật','Người giám sát','Tổ chức giám sát',NULL,NULL,NULL,1,1,8);

--
-- Table structure for table `et_doc_expenses_paid_trainee`
--

CREATE TABLE `et_doc_expenses_paid_trainee` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name_romaji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_receipt_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_sending_agency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_sending_agency_receipt_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_sign_date` date DEFAULT NULL,
  `trainee_sign_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_expenses_paid_trainee`
--

INSERT INTO `et_doc_expenses_paid_trainee` VALUES (1,'施者の氏名又は名称','名目','12322345678','345123','名目氏名氏名氏名氏名氏名','監理団体の名称監理団体の名称監理団体の名称監理団体の名称','2024-07-15','監理団体の名称監理団体の名称','12334567','123456','2024-07-25','監理団体の名称','note note',NULL,NULL,NULL,1,3),(2,'name_romaji','TEST','12345999999999','21223345','222222222222','8888888888888888888','2024-09-08','9999','99878765','12567','2024-09-16','trainee_sign_name','test1234',NULL,NULL,NULL,1,5);

--
-- Table structure for table `et_doc_explanation_during_training`
--

CREATE TABLE `et_doc_explanation_during_training` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_romaji` varchar(255) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_paid_yesno` tinyint(1) DEFAULT NULL,
  `learning_paid_money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_paid_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_paid_yesno` tinyint(1) DEFAULT NULL,
  `meal_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_trainer_paid_yesno` tinyint(1) DEFAULT NULL,
  `meal_trainer_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_paid_yesno` tinyint(1) DEFAULT NULL,
  `house_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_trainer_paid_yesno` tinyint(1) DEFAULT NULL,
  `house_trainer_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_type` tinyint(1) DEFAULT NULL,
  `house_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_size` float DEFAULT NULL,
  `house_number` int DEFAULT NULL,
  `house_oneperson_size` float DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `description_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_relationship` 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,
  `sign_date` date 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_0900_ai_ci;

--
-- Dumping data for table `et_doc_explanation_during_training`
--

INSERT INTO `et_doc_explanation_during_training` VALUES (1,NULL,'name',NULL,'learning_paid_money','learning_paid_note',1,'meal_paid_yes_note',1,'meal_trainer_paid_yes_note','meal_note',1,'house_paid_yes_note',0,'house_trainer_paid_yes_note',1,'house_name','house_address',NULL,NULL,1000,3,100,'note trainee_declaration trainee_declaration trainee_declaration trainee_declaration trainee_declaration','other_note','2024-07-09','description_name','description_relationship','sign_name',NULL,'2024-01-03',NULL,NULL,NULL,1,0),(2,NULL,'name',NULL,'1000','learning_paid_note',1,'meal_paid_yes_note',0,'explanation_during_training.meal_trainer_paid_yes_note','meal_note',1,'house_paid_yes_note',1,'house_trainer_paid_yes_note',1,'house_name','house_address',NULL,NULL,100,10,100,'test','other_note','2024-07-16','description_name','description_relationship','sign_name',NULL,NULL,NULL,NULL,1,1,1),(3,NULL,'name',NULL,'1,000円','note',1,'note2',1,'note3','note4',1,'house_paid_yes_note',1,'house_trainer_paid_yes_note',3,'house_name','house_address','6777sg','0989888998',10,10,100,'note123','other_note','2024-07-30','description_name','description_relationship','sign_name',NULL,'2024-07-30',NULL,NULL,1,1,3);

--
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_name` varchar(255) 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 COLLATE utf8mb4_unicode_ci,
  `other_trainee_yesno` tinyint(1) DEFAULT NULL,
  `japanese_job_name` varchar(255) 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) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_job_yesno` int DEFAULT NULL,
  `same_level_japanese_jobname` varchar(255) 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) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `same_level_no_salary_yesno` tinyint(1) DEFAULT NULL,
  `same_level_no_salary_jobname` varchar(255) 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) 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) 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) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_allowance_trainee_self_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_allowance_yesno` tinyint(1) DEFAULT NULL,
  `learning_house_allowance_yes_note` varchar(255) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_type` tinyint(1) DEFAULT NULL,
  `learning_house_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_postcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_house_tel` varchar(255) 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) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check2_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check3_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check4_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check5_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check6_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check7_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check8_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_check9_note` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_customer_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_name` varchar(255) 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_money_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_money` int DEFAULT NULL,
  `house_type` tinyint(1) DEFAULT NULL,
  `house_money_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_1_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_1_money` int DEFAULT NULL,
  `other_money_trainee_regular_2_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_2_money` int DEFAULT NULL,
  `other_money_trainee_regular_3_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_3_money` int DEFAULT NULL,
  `other_money_trainee_regular_wifi` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_money_trainee_regular_money` varchar(255) 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_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_0900_ai_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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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);

--
-- 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_0900_ai_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) DEFAULT NULL,
  `person_title` varchar(255) 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_0900_ai_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_0900_ai_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_0900_ai_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_0900_ai_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_0900_ai_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) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `fileable_type` varchar(255) COLLATE utf8mb3_unicode_ci DEFAULT NULL,
  `item_id` bigint unsigned DEFAULT NULL,
  `url` varchar(500) 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_0900_ai_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_0900_ai_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,
  `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_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_fax` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_staff_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sale_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_type_name` int DEFAULT NULL,
  `receiving_operation_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_men` int DEFAULT NULL,
  `number_women` int DEFAULT NULL,
  `number` int DEFAULT NULL,
  `cond_marriage` tinyint DEFAULT NULL,
  `cond_academic` tinyint(1) DEFAULT NULL,
  `cond_experience` tinyint DEFAULT NULL,
  `cond_nationality` tinyint(1) DEFAULT NULL,
  `national_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `cond_yearold` int DEFAULT NULL,
  `cond_lang` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cond_height` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cond_weight` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cond_eyesight` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cond_select_method` tinyint(1) DEFAULT NULL,
  `hiring_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `allowance_onemonthcourse` int DEFAULT NULL,
  `salary_month_type` tinyint DEFAULT NULL,
  `salary_month_value` int DEFAULT NULL,
  `salary_month_hour_value` tinyint DEFAULT NULL,
  `salary_day_type` int DEFAULT NULL,
  `salary_day_value` tinyint DEFAULT NULL,
  `salary_day_hour_value` int DEFAULT NULL,
  `salary_hour_type` tinyint DEFAULT NULL,
  `salary_hour_value` int DEFAULT NULL,
  `salary_hour_month_value` int DEFAULT NULL,
  `allowance_dormitory` int DEFAULT NULL,
  `allowance_electric_actual_type` tinyint(1) DEFAULT NULL,
  `allowance_electric_actual_value` int DEFAULT NULL,
  `allowance_electric_fix_type` tinyint(1) DEFAULT NULL,
  `allowance_electric_fix_value` int DEFAULT NULL,
  `insurance_health_type` tinyint(1) DEFAULT NULL,
  `insurance_welfare_type` tinyint(1) DEFAULT NULL,
  `insurance_city_health_type` tinyint(1) DEFAULT NULL,
  `insurance_city_welfare_type` tinyint(1) DEFAULT NULL,
  `insurance_other_type` tinyint(1) DEFAULT NULL,
  `insurance_other_note` varchar(255) DEFAULT NULL,
  `insurance_health_value` int DEFAULT NULL,
  `insurance_welfare_value` int DEFAULT NULL,
  `insurance_employment_value` int DEFAULT NULL,
  `insurance_employment_type` tinyint DEFAULT NULL,
  `income_tax_type` tinyint DEFAULT NULL,
  `income_tax_value` int DEFAULT NULL,
  `tax_other_value` int DEFAULT NULL,
  `deduction_value` int DEFAULT NULL,
  `return_value` int DEFAULT NULL,
  `overtime_hour_value` int DEFAULT NULL,
  `overtime_hour_count` varchar(255) DEFAULT NULL,
  `payroll_deadline_day` varchar(255) DEFAULT NULL,
  `pay_day_type` tinyint(1) DEFAULT NULL,
  `pay_day` tinyint DEFAULT NULL,
  `pay_method` tinyint(1) DEFAULT NULL,
  `work_time_begin` time DEFAULT NULL,
  `work_time_end` time DEFAULT NULL,
  `work_leave_time` time DEFAULT NULL,
  `work_oneday_timecount` int DEFAULT NULL,
  `work_oneyear_timecount` varchar(255) DEFAULT NULL,
  `work_oneyear_daycount` int DEFAULT NULL,
  `work_oneyear_leavedaycount` int DEFAULT NULL,
  `work_leaveday` tinyint(1) DEFAULT NULL,
  `other_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `recruiter_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `representative_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `recruiter_tel` varchar(255) 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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


--
-- 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_0900_ai_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_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_0900_ai_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_0900_ai_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,4);

--
-- 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) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) 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_0900_ai_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_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_0900_ai_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_0900_ai_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_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_0900_ai_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) 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_0900_ai_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_0900_ai_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_0900_ai_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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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) 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_0900_ai_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_recomend_trainee`
--

CREATE TABLE `et_doc_recomend_trainee` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `sending_agency_name` varchar(255) 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_0900_ai_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_0900_ai_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_returncountry_declaration`
--

CREATE TABLE `et_doc_returncountry_declaration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reason_type` int DEFAULT NULL COMMENT '1:帰国便都合, 2:技能実習期間の末日が休日である, 3:その他',
  `reason_other_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deadline_date` date DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `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,
  `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_0900_ai_ci;

--
-- Dumping data for table `et_doc_returncountry_declaration`
--

INSERT INTO `et_doc_returncountry_declaration` VALUES (1,2,NULL,'2024-06-19','2024-06-21',1,'dsa222','2024-06-27','dsa',NULL,NULL,NULL,NULL,NULL,NULL,0),(2,3,'reason_other_note','2024-08-08','2024-08-15',2,'person_name','2024-08-14','sign_name',NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_sending_agency_expenses`
--

CREATE TABLE `et_doc_sending_agency_expenses` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_sending_agency_expenses`
--

INSERT INTO `et_doc_sending_agency_expenses` VALUES (1,'2024-07-02','sign_sending_agency_name','sign_director_name',NULL,NULL,NULL,1,1,6);

--
-- Table structure for table `et_doc_sending_agency_expenses_detail`
--

CREATE TABLE `et_doc_sending_agency_expenses_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sending_agency_expenses_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `period_date` date DEFAULT NULL,
  `money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `money_yen` int DEFAULT NULL,
  `pay_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_sending_agency_expenses_detail`
--

INSERT INTO `et_doc_sending_agency_expenses_detail` VALUES (1,1,'NAME','2024-07-09','205700',205700,'online'),(2,1,'name 2','2024-07-10','100000',100000,''),(3,1,'test 3',NULL,'30000',400000,'');

--
-- Table structure for table `et_doc_sending_agency_oath`
--

CREATE TABLE `et_doc_sending_agency_oath` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sending_agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_number_ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_sending_agency_oath`
--

INSERT INTO `et_doc_sending_agency_oath` VALUES (1,'12345','test1','2024-06-03','testdsyhtft','12345','sending_agency_number_ref','test',NULL,NULL,NULL,NULL,NULL,1,0),(2,'申請者（実習実施者）','監理団体の名称','2024-08-05','1234567','111112222','2222','333333333',NULL,NULL,NULL,NULL,NULL,1,0);

--
-- Table structure for table `et_doc_sending_agency_oath_listname`
--

CREATE TABLE `et_doc_sending_agency_oath_listname` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `sending_agency_oath_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_sending_agency_oath_listname`
--

INSERT INTO `et_doc_sending_agency_oath_listname` VALUES (103,1,'ddd','オーストラリア人',NULL,NULL,NULL),(104,1,'tap tast','チリ人',NULL,NULL,NULL),(105,1,'abc','中国人',NULL,NULL,NULL),(106,1,'abc','バングラデシュ人',NULL,NULL,NULL),(107,1,'test 1','',NULL,NULL,NULL),(108,1,'2','',NULL,NULL,NULL),(109,1,'test3','',NULL,NULL,NULL),(110,1,'test 4','',NULL,NULL,NULL),(111,2,'test','アルバニア','',NULL,NULL),(113,2,'test1','コロンビア','',NULL,NULL);

--
-- Table structure for table `et_doc_sending_agency_overview`
--

CREATE TABLE `et_doc_sending_agency_overview` (
  `id` int NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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,
  `establish_date` date DEFAULT NULL,
  `business_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital_yen` int DEFAULT NULL,
  `earning_money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `earning_money_yen` int DEFAULT NULL,
  `staff_number` varchar(255) DEFAULT NULL,
  `leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_staff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_sending_agency_overview`
--

INSERT INTO `et_doc_sending_agency_overview` VALUES (1,'number','name','director_name','address','tel','email','2024-07-03','business_content','business_content',1232,'1232',1232,'231321','leader_name','jp_name',NULL,'jp_postcode','23132111','jp_director_name','jp_staff','2024-07-03','sign_sending_agency_name','sign_director_name',NULL,NULL,NULL,NULL,NULL,0),(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,0);

--
-- Table structure for table `et_doc_sendingagency_recommendation`
--

CREATE TABLE `et_doc_sendingagency_recommendation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sendingagency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `company_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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_sendingagency_recommendation`
--

INSERT INTO `et_doc_sendingagency_recommendation` VALUES (1,'sendingagency_name','2024-07-10','company_name','director_name',NULL,NULL,NULL,NULL,1,0),(2,'sendingagency_name','2024-07-16','company_name','director_name',NULL,NULL,NULL,NULL,1,0),(3,'sendingagency_name','2024-08-13','company_name','test',NULL,NULL,NULL,NULL,1,0),(4,'sendingagency_name','2024-09-02','test1','test2',NULL,NULL,NULL,NULL,1,0);

--
-- Table structure for table `et_doc_similar_job_description`
--

CREATE TABLE `et_doc_similar_job_description` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `check_3` tinyint(1) DEFAULT NULL,
  `check_4` tinyint(1) DEFAULT NULL,
  `check_5` tinyint(1) 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_0900_ai_ci;

--
-- Dumping data for table `et_doc_similar_job_description`
--

INSERT INTO `et_doc_similar_job_description` VALUES (1,1,0,1,0,1,NULL,NULL,NULL,NULL,NULL,0),(2,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_staff_cv`
--

CREATE TABLE `et_doc_staff_cv` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staff_incharge_id` int DEFAULT NULL,
  `staff_instructor_gino_id` int DEFAULT NULL,
  `staff_instuctor_life_id` int DEFAULT NULL,
  `staff_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_birthdate` date DEFAULT NULL,
  `staff_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_technical_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_birthdate` date DEFAULT NULL,
  `instructor_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_technical_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_birthdate` date DEFAULT NULL,
  `life_instructor_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_technical_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_technical` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sign_staff_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_life_instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 NOT 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_staff_cv`
--

INSERT INTO `et_doc_staff_cv` VALUES (1,NULL,NULL,NULL,'staff_furigana','staff_name','2024-07-01','staff_national','staff_degree','staff_technical_training','instructor_furigana 2','instructor_name 2','2024-07-04','instructor_national 2','instructor_degree 2','instructor_technical_training 2','life_instructor_furigana 3','life_instructor_name 3','2024-07-05','life_instructor_national 3','life_instructor_degree 3','life_instructor_technical_training 3','applicant_name 3','address 3','content_technical 3','2024-07-06','sign_staff_name 3','sign_instructor_name 3','sign_life_instructor_name 3',NULL,NULL,1,NULL,1,3),(2,NULL,NULL,NULL,'staff_furigana','staff_name','2024-08-02','staff_national','staff_degree','staff_technical_training','instructor_furigana','instructor_name','2024-08-02','instructor_national','instructor_degree','instructor_technical_training','life_instructor_furigana','life_instructor_name','2024-08-08','life_instructor_national','life_instructor_degree','life_instructor_technical_training 3','applicant_name 3','address 3','content_technical 3','2024-08-12','sign_staff_name 3','sign_instructor_name 3','sign_life_instructor_name 3',NULL,NULL,1,NULL,1,6),(3,NULL,NULL,NULL,'staff_furigana','a','2024-09-10','as','ss','sa','123','12','2024-09-11','国籍','資格・免許','技能実習に係る講習の受講歴','ふりがな',NULL,'2024-08-12','国籍（国又は地域）','資格・免許','技能実習に係る講習の受講歴','applicant_name','address','content_technical','2024-09-10','技能実習責任者の氏名','技能実習指導員の氏名','技能実習指導員の氏名',NULL,NULL,1,NULL,1,3);

--
-- Table structure for table `et_doc_staff_cv_filelist`
--

CREATE TABLE `et_doc_staff_cv_filelist` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_cv_id` bigint NOT NULL,
  `file` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL COMMENT '1 staff, 2 instructor, 3 life_instructor',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_staff_cv_filelist`
--

INSERT INTO `et_doc_staff_cv_filelist` VALUES (1,1,'storage/app/public/et_document/doc_staff_cv/reform.png',NULL,1),(2,1,'storage/app/public/et_document/doc_staff_cv/kumiai_jobtype_scope.pdf',NULL,2),(3,1,'storage/app/public/et_document/doc_staff_cv/kokokuhi.png',NULL,3),(4,1,'storage/app/public/et_document/doc_staff_cv/reform.png',NULL,1),(5,1,'storage/app/public/et_document/doc_staff_cv/kumiai_jobtype_scope.pdf',NULL,2),(6,1,'storage/app/public/et_document/doc_staff_cv/kokokuhi.png',NULL,3),(7,1,'storage/app/public/et_document/doc_staff_cv/reform.png',NULL,1),(8,1,'storage/app/public/et_document/doc_staff_cv/kumiai_jobtype_scope.pdf',NULL,2),(9,1,'storage/app/public/et_document/doc_staff_cv/kokokuhi.png',NULL,3),(10,1,'storage/app/public/et_document/doc_staff_cv/doc_staff_cv (1).pdf',NULL,1),(11,2,'storage/app/public/et_document/doc_staff_cv/pic_point_01.png',NULL,1),(12,2,'storage/app/public/et_document/doc_staff_cv/pic_point_03.png',NULL,3),(13,2,'storage/app/public/et_document/doc_staff_cv/checklist.png',NULL,1);

--
-- Table structure for table `et_doc_staff_job_history`
--

CREATE TABLE `et_doc_staff_job_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_cv_id` bigint NOT NULL,
  `year` varchar(4) DEFAULT NULL,
  `month` varchar(2) DEFAULT NULL,
  `date` int DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL COMMENT '1 staff, 2 instructor, 3 life_instructor',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_staff_job_history`
--

INSERT INTO `et_doc_staff_job_history` VALUES (1,3,'2000','01',1,'test',1),(5,3,'2000','03',1,'life',3),(7,3,'2023','01',2,'test 123',2),(8,3,'2024','01',1,'life2',3),(9,3,'2024','01',2,'life3',3),(16,3,'2001','02',4,'test1',1),(17,3,'2000','03',5,'test2',1),(18,3,'2000','03',3,'test 1234',2);

--
-- Table structure for table `et_doc_supervisor_cv`
--

CREATE TABLE `et_doc_supervisor_cv` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sex` int DEFAULT NULL COMMENT '1:male, 2:female',
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` 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,
  `company_name` 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_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_cv` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_sermina_cv` 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_title` 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=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_supervisor_cv`
--

INSERT INTO `et_doc_supervisor_cv` VALUES (1,'name','name',2,'2024-07-04','test','0999','test address','0123456789','company_name','company_address','postcode','tel','job','certificate','job_cv','cv','2024-07-09','sign_name','sign_name 2','sign_name 3',NULL,NULL,NULL,1,1,1),(2,'name','name_furigana',2,'2024-07-09','nationality','postcode','address','tel','company_name','company_address','company_postcode','company_tel','job_title','certificate','job_cv','job_sermina_cv','2024-07-10','sign_name','sign_creator_title','sign_creator_name',NULL,NULL,NULL,NULL,1,0),(3,'name','name_furigana',1,'2020-01-01','nationality',NULL,NULL,NULL,'company_name','company_address',NULL,NULL,NULL,NULL,NULL,NULL,'2024-08-12','sign_name','sign_creator_title','sign_creator_name',NULL,NULL,NULL,1,1,3),(4,'test','1asdf',1,'2024-09-10','国籍（国又は地域）','12445','住所','電話','勤務先','勤務先住所','郵便番号','電話','役職名','資格・免許','技能実習に係る監理・指導等の経歴','技能実習に係る講習の受講歴','2024-09-11','申請者の名称','作成責任者 役職','作成責任者 氏名',NULL,NULL,NULL,1,1,3);

--
-- Table structure for table `et_doc_supervisor_pledge`
--

CREATE TABLE `et_doc_supervisor_pledge` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` 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,
  `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_0900_ai_ci;

--
-- Dumping data for table `et_doc_supervisor_pledge`
--

INSERT INTO `et_doc_supervisor_pledge` VALUES (1,'name','address','2024-07-12','sign_name',NULL,NULL,NULL,NULL,NULL,NULL,0),(2,'test','teset123','2024-09-11','hi',NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_teaching_techniques`
--

CREATE TABLE `et_doc_teaching_techniques` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_cv_id` int NOT NULL,
  `job_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `year_experience` int DEFAULT NULL,
  `fulltime` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_teaching_techniques`
--

INSERT INTO `et_doc_teaching_techniques` VALUES (1,1,'job_content 2',3,0),(2,2,'job_content',3,1),(3,3,'job_content',2,0);

--
-- Table structure for table `et_doc_technical_intern_training`
--

CREATE TABLE `et_doc_technical_intern_training` (
  `id` int NOT NULL AUTO_INCREMENT,
  `evaluation_trainee_id` int DEFAULT NULL,
  `year` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_day` int DEFAULT NULL,
  `number_workday` int DEFAULT NULL,
  `number_absent` int DEFAULT NULL,
  `number_paid_holiday` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_technical_intern_training`
--

INSERT INTO `et_doc_technical_intern_training` VALUES (1,1,'2024-09','2024-09',1000,1,100,20),(2,1,NULL,NULL,100,10,20,30),(3,1,NULL,NULL,100,20,30,40);

--
-- Table structure for table `et_doc_trainee_consultation`
--

CREATE TABLE `et_doc_trainee_consultation` (
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_trainee_consultation`
--

INSERT INTO `et_doc_trainee_consultation` VALUES (1,NULL,NULL,NULL,1,1,4);

--
-- Table structure for table `et_doc_trainee_consultation_detail`
--

CREATE TABLE `et_doc_trainee_consultation_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `trainee_consultation_id` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `trainee_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `method_date` date DEFAULT NULL,
  `method_staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_trainee_consultation_detail`
--

INSERT INTO `et_doc_trainee_consultation_detail` VALUES (1,1,'2024-07-10','Nguyen A','STAFF NAME','CONTENT','METHOD CONTENT','2024-07-17','METHOD STAFF NAME','LEADER NAME'),(2,1,'2024-07-20','Nguyen B','STAFF NAME2','CONTENT2','METHOD CONTENT2','2024-07-19','METHOD TAFF NAME2','LEADER NAME2'),(3,1,NULL,'c',NULL,'',NULL,NULL,NULL,NULL),(4,1,NULL,'d',NULL,'',NULL,NULL,NULL,NULL),(5,1,NULL,'e',NULL,'',NULL,NULL,NULL,NULL),(6,1,NULL,'f',NULL,'',NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_trainee_declaration`
--

CREATE TABLE `et_doc_trainee_declaration` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobtype` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sign_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `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 NOT 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_trainee_declaration`
--

INSERT INTO `et_doc_trainee_declaration` VALUES (1,'national','jobtype','2024-06-21','note note','NGUYEN DUC TAP',NULL,NULL,1,NULL,1,12),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,3);

--
-- Table structure for table `et_doc_trainee_list`
--

CREATE TABLE `et_doc_trainee_list` (
  `id` int NOT NULL AUTO_INCREMENT,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name_leader` 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=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_trainee_list`
--

INSERT INTO `et_doc_trainee_list` VALUES (123,'sign_name','2024-08-24','12345678',NULL,NULL,NULL,1,1,3);

--
-- Table structure for table `et_doc_trainee_list_name`
--

CREATE TABLE `et_doc_trainee_list_name` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `doc_trainee_list_id` bigint NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_trainee_list_name`
--

INSERT INTO `et_doc_trainee_list_name` VALUES (2,123,'test','1','2024-08-20','2024-08-14','8');

--
-- Table structure for table `et_doc_trainee_pledge`
--

CREATE TABLE `et_doc_trainee_pledge` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `number_1` int DEFAULT NULL,
  `number_2` int DEFAULT NULL,
  `number_3` int DEFAULT NULL,
  `number_4` int DEFAULT NULL,
  `number_5` int DEFAULT NULL,
  `number_6` int DEFAULT NULL,
  `number_7` int DEFAULT NULL,
  `number_8` int DEFAULT NULL,
  `number_9` int DEFAULT NULL,
  `number_10` int DEFAULT NULL,
  `number_11` int DEFAULT NULL,
  `number_12` int DEFAULT NULL,
  `number_13` int DEFAULT NULL,
  `number_14` int DEFAULT NULL,
  `number_15` int DEFAULT NULL,
  `number_16` int DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 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 NOT 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_trainee_pledge`
--

INSERT INTO `et_doc_trainee_pledge` VALUES (1,'2','1','2024-05-31',1,1,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(2,'2','1','2024-07-10',1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0),(3,'test','test 2','2024-07-19',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0),(4,'test','staff_name','2024-07-31',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,NULL,NULL,NULL,NULL,NULL,1,0),(5,'株式会社AlphaCep','大越 花蓮','2024-08-08',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,1,0);

--
-- Table structure for table `et_doc_trainee_pledge_listname`
--

CREATE TABLE `et_doc_trainee_pledge_listname` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `doc_trainee_pledge_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_trainee_pledge_listname`
--

INSERT INTO `et_doc_trainee_pledge_listname` VALUES (2,5,'nguyen van a','アルジェリア',NULL,NULL),(3,5,'nguyen van b','アルジェリア',NULL,NULL),(4,5,'nguyen van c','アルジェリア',NULL,NULL),(5,5,'nguyen van d','オーストラリア',NULL,NULL),(6,5,'nguyen van e','カンボジア',NULL,NULL),(7,5,'大越 花蓮','ブラジル',NULL,NULL),(8,4,'test1','アルゼンチン',NULL,NULL),(9,4,'test2','中国',NULL,NULL),(10,4,'test3','オーストラリア',NULL,NULL),(11,4,'test4','コロンビア',NULL,NULL),(12,4,'test5','中国',NULL,NULL);

--
-- Table structure for table `et_doc_training_certification`
--

CREATE TABLE `et_doc_training_certification` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `receipt_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_director_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,
  `customer_director_name_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_company_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobtype_category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobtype_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name_address_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name_leader_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name_leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_place_name_jobtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_leader_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_leader_jobtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_leader_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_leader_jobtitle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_name_romaji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_name_kanji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_birthdate` date DEFAULT NULL,
  `trainee_yearold` int DEFAULT NULL,
  `trainee_sex` int DEFAULT NULL COMMENT '1 男 , 2 女',
  `returncountry_period` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `returncountry_period_datefrom` date DEFAULT NULL,
  `returncountry_period_dateto` date DEFAULT NULL,
  `trainee_type` int DEFAULT NULL COMMENT '1 Ａ(第一号企業単独型技能実習); 2 Ｄ(第一号団体監理型技能実習);\r\n3 Ｂ(第二号企業単独型技能実習); 4 Ｅ(第二号団体監理型技能実習);\r\n5 Ｃ(第三号企業単独型技能実習); 6 Ｆ(第三号団体監理型技能実習)',
  `trainee_jobtype_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_jobtype_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_jobtype_workname` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_jobtype_number_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_jobtype_name_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_jobtype_workname_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_jobtype_other` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `training_before_japan` int DEFAULT NULL COMMENT '1:有   2: 無',
  `has_test` int DEFAULT NULL,
  `has_test_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_test_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_evaluate` int DEFAULT NULL,
  `has_evaluate_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_evaluate_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_test_other` int DEFAULT NULL,
  `has_test_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_test_goal` int DEFAULT NULL,
  `has_test_goal_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_test_goal_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_evaluate_goal` int DEFAULT NULL,
  `has_evaluate_goal_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_evaluate_goal_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `has_test_goal_other` int DEFAULT NULL,
  `has_test_goal_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `before_step_receipt_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extend_period` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `extend_period_datefrom` date DEFAULT NULL,
  `extend_period_tofrom` date DEFAULT NULL,
  `extend_period_count_time` int DEFAULT NULL,
  `extend_period_learning_time` time DEFAULT NULL,
  `extend_period_training_time` time DEFAULT NULL,
  `company_license_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_type` int DEFAULT NULL COMMENT '1: 一般監理事業, 2: 特定監理事業',
  `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_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_director_name_furigana` 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_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_workplace_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_workplace_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_workplace_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_workplace_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_created_by_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plan_created_by_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_name` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sending_agency_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `sending_agency_ref_number` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `salary_type` int DEFAULT NULL COMMENT '1月給, 2 日給, 3 時給',
  `salary_money` int DEFAULT NULL,
  `salary_learning_money` int DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 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 NOT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `salary_other` int DEFAULT NULL,
  `work_contract_period_type` tinyint(1) DEFAULT NULL COMMENT '1 有,  0 無',
  `work_contract_period_datefrom` date DEFAULT NULL,
  `work_contract_period_dateto` date DEFAULT NULL,
  `work_time_begin` time DEFAULT NULL,
  `work_time_end` time DEFAULT NULL,
  `work_breakoff_begin` time DEFAULT NULL,
  `work_breakoff_end` time DEFAULT NULL,
  `work_year_counttime` int DEFAULT NULL,
  `work_week_counttime` int DEFAULT NULL,
  `holiday_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `vacation_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `dormitory_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `meal_money` int DEFAULT NULL,
  `dormitory_money` int DEFAULT NULL,
  `other_money` int DEFAULT NULL,
  `note_contract` text COLLATE utf8mb4_unicode_ci,
  `note_type` int DEFAULT NULL COMMENT '1 有,  0 無',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_training_certification`
--

INSERT INTO `et_doc_training_certification` VALUES (1,'2024-06-16','test',NULL,'2024-06-18','123456','tst','test','test','test','test','tes','tes','test','trst','test',NULL,NULL,NULL,NULL,NULL,NULL,'1342',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(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,NULL,NULL,NULL,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_training_certification_cancel_report`
--

CREATE TABLE `et_doc_training_certification_cancel_report` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `number` 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_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,
  `office_branch_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_branch_name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_branch_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_branch_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `office_branch_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_1` tinyint(1) DEFAULT NULL,
  `check_2` tinyint(1) DEFAULT NULL,
  `check_3` tinyint(1) DEFAULT NULL,
  `check_4` tinyint(1) DEFAULT NULL,
  `check_5` tinyint(1) DEFAULT NULL,
  `check_6` tinyint(1) DEFAULT NULL,
  `check_7` tinyint(1) DEFAULT NULL,
  `real_content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `improve_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_training_certification_cancel_report`
--

INSERT INTO `et_doc_training_certification_cancel_report` VALUES (1,'2024-07-09','name','34324342','customer_name','customer_name_furigana','232 ― 1321','customer_address','321 ― 3213 ― 2132','office_branch_name','office_branch_name_furigana','232 ― 4532','office_branch_address','432 ― 4324 ― 1114',1,1,0,1,0,1,1,'real_content','improve_content',NULL,NULL,NULL,NULL,NULL,0),(2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `et_doc_training_implementation_scheduler`
--

CREATE TABLE `et_doc_training_implementation_scheduler` (
  `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',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `et_doc_training_implementation_scheduler`
--

INSERT INTO `et_doc_training_implementation_scheduler` VALUES (1,NULL,NULL,NULL,1,1,8),(2,NULL,NULL,NULL,1,1,2),(3,NULL,NULL,NULL,1,1,2);

--
-- Table structure for table `et_doc_training_instructor_resume`
--

CREATE TABLE `et_doc_training_instructor_resume` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL COMMENT '1: male, 2:female',
  `birthdate` date DEFAULT NULL,
  `postcode` 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,
  `work_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_resume` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_resume_old` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_company_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_0900_ai_ci;

--
-- Dumping data for table `et_doc_training_instructor_resume`
--

INSERT INTO `et_doc_training_instructor_resume` VALUES (1,NULL,NULL,2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,2),(2,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,4);

--
-- Table structure for table `et_doc_training_report_daily`
--

CREATE TABLE `et_doc_training_report_daily` (
  `id` int NOT NULL AUTO_INCREMENT,
  `month` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `company_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,
  `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_0900_ai_ci;

--
-- Dumping data for table `et_doc_training_report_daily`
--

INSERT INTO `et_doc_training_report_daily` VALUES (1,'2024-07','2024-07-16','company_name','customer_name','note',NULL,NULL,NULL,NULL,1,0),(2,'2024-09','2024-09-01','company_name','customer_name','note trainee_declaration trainee_declaration trainee_declaration trainee_declaration trainee_declaration',NULL,NULL,NULL,NULL,1,0);

--
