-- Table structure for table `et_doc_notification_of_support_status_org`
--

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

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

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

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

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

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

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

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

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

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


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

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

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

INSERT INTO `et_doc_notification_suspend_terminate_support` VALUES
(1,'registration_number 111',1,1,1,1,1,1,1,1,1,1,1,1,1,'dsafdsfdsfsdf','agency_address','responsible','123123123123',1,1,'2024-11-11',1,1,1,'text_others',1,'2024-11-11',1,'2024-11-11',1,1,1,1,2,'2024-11-11',NULL,NULL,1,'2024-10-11 15:41:45',1,8,NULL,NULL),
(2,'registration_number',1,2,3,4,5,6,7,8,9,1,2,3,4,'name_the_institution','agency_address','responsible','0',1,1,'2024-11-11',1,1,1,'text_others',1,'2024-11-11',1,'2024-11-11',1,1,1,1,1,'2024-11-11','2024-10-11 16:07:44',NULL,NULL,'2024-10-11 16:07:44',1,0,NULL,NULL),
(3,'12登-454231',4,2,3,5,5,5,4,3,9,3,0,0,0,'株式会社　入管','東京都新宿区','AADGLKFH;','045-785-1555',1,0,'2025-01-01',1,0,0,'gflahf;à',0,'2025-01-01',1,'2025-01-01',0,0,1,0,1,'2025-01-01','2025-01-01 12:54:40',NULL,151,'2025-01-16 13:01:43',1,12,'123-456','ÔNO COMPANY'),
(4,'679548',1,2,3,0,1,1,1,0,0,0,0,0,1,'株式会社　入管','東京都新宿区西新宿1-2-3','武村由紀子','085-457-4165',1,0,'2025-06-17',1,0,0,'なし',1,'2025-06-17',1,'2025-06-17',1,0,0,0,1,'2025-06-17','2025-06-17 14:47:13',NULL,1,'2025-06-17 14:49:47',1,1,'033-1244','ÔNO COMPANY');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_pregnancy_declaration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `check_1` int(11) DEFAULT NULL,
  `check_2` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `detail_check_1` int(11) DEFAULT NULL,
  `detail_check_2` int(11) DEFAULT NULL,
  `detail_check_3` int(11) DEFAULT NULL,
  `detail_check_4` int(11) DEFAULT NULL,
  `detail_check_5` int(11) DEFAULT NULL,
  `detail_check_6` tinyint(1) DEFAULT NULL,
  `detail_check_7` int(11) DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `return_country_date` date DEFAULT NULL,
  `return_check_1` int(11) DEFAULT NULL,
  `return_month` varchar(8) 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) DEFAULT NULL,
  `sign_submit_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) NOT NULL DEFAULT 0,
  `note` text DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `et_doc_regular_interview_report` VALUES
(1,'トウイ','áđá','2025-01-22','TIEP',NULL,1,'名 代表取締役','ád',NULL,'無し',NULL,'ád',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 03:05:09',NULL,151,'2025-01-23 07:03:04',1,10,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-23','cjgkh',1,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,'NGUYEN VAN SON','島田建工株式会社','2025-04-10','ジェン ティ タン ガー',1,NULL,'代表取締役','無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'無し',NULL,NULL,'2025-04-05 06:34:02',NULL,151,'2025-04-05 06:36:03',2,1,NULL,NULL,NULL,NULL,NULL,'2025-04-10','ジェン ティ タン ガー',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(3,'ｑｑｑ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-07 02:25:02',NULL,151,'2025-04-07 04:21:47',2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(4,'入江　省吾','島田建工株式会社',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-04-07 05:09:54',NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(5,'② その他（2 12 12 12','② その他（3qưe 21','2025-06-01','② その他（3 12',1,1,'② その他（3 12','② その他（3 12','② その他（3  12','② その他（3 12','② その他（3 12','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（4','② その他（3','② その他（5','② その他（6','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（3','② その他（33','② その他（3','② その他（3','② その他（3','② その他（3',1,1,'⑦その他特筆すべき事項','2025-12-12','② 法令違反事実の内容','2025-06-03 01:35:42',NULL,1,'2025-06-16 07:57:39',1,13,'dsfdsf','2025-12-12','通知の相手方：3','2025-12-12','通報先機関','2025-12-12','面談実施者の氏名',1,1,1,1,1,'② その他（3','1','1',1,1,1,'sdfsdf','sdfsdf','fdfsdf'),
(6,'1','2','2025-06-03','3',1,1,'5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','29','21','22','23','24','25','26','27','28','29','30','31','32','33','34','45','36','37','38','39','41','42',1,1,'43','2025-06-03','44','2025-06-03 03:41:39',NULL,NULL,NULL,2,0,'45','2025-06-05','555','2025-06-05','55','2025-06-20','5555',1,1,1,1,1,'40',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL),
(7,'TURNER ELIZABETH','株式会社 入管','2025-06-04','法務 花子',1,1,'主任','□有  ☑無','7','□有  ☑無','9','□有  ☑無','11','☑有  □無','13','□有  ☑無','15','□有  ☑無','17','☑有  □無','19','□有  ☑無','21','□有  ☑無','23','☑有  □無','25','□有  ☑無','27','□有  ☑無','29','□有  □無','31','□有  □無','33','□有  □無','35','□有  □無','37','□有  □無','39','□有  □無','42',1,1,'43','2025-06-04','特定技能所属機関が，居住費の控除額を特定技能外国人との合意なしに 5,000 円から18,000 円に変更した。\r\n特定技能所属機関に対し，特定技能外国人との合意なしに居住費の控除額を変更することは認められないため，元の控除額に戻すように依頼したが，本届出書作成日時点において改善されていない。また，特定技能外国人には労働基準監督署を案内し相談するため同行した。','2025-06-03 20:05:23',NULL,2,'2025-06-03 21:20:41',2,7,'45','2025-06-05','46','2025-06-12','47','2025-06-20','48',NULL,1,1,NULL,1,'40',NULL,'1',1,1,NULL,NULL,NULL,NULL),
(8,'① 特定技能外国人の氏名','② 特定技能所属機関の氏名又は名称','2025-06-04','① 対応者の氏名',1,1,'役職名','有','無し','有','無し','無','無し','無','無し','有','無し','有','無し','無','無し','無','無し','有','無し','有','無し','無','無し','無','無し','有','無し','有','無し','無','無し','無','無し','有','無し','有','無し',1,1,'無し','2025-12-12','無し','2025-06-03 22:27:37',NULL,1,'2025-06-16 08:54:58',1,8,'無し','2025-03-23','無し','2025-06-16','無し','2025-06-16','ABC会社',1,1,1,1,1,'② その他','1','1',1,1,1,'sdfsfd','sdfds','dfsf'),
(9,'1111','222','2025-06-09','333',1,1,'444','555','666','777','888','999','1010','1112','1113','1114','1115','abc','def','ghk','012','123','456','789','1011','1213','1314','1415','1516','1617','1718','1819','2021','2122','2223','2324','2425','2526','2627','2728','2829','3233','3334',1,1,'3536','2025-06-09','3333','2025-06-09 03:17:07',NULL,NULL,NULL,2,0,'333','2025-06-09','333','2025-06-09','3333','2025-06-09','333',NULL,1,1,1,NULL,'3031',NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(10,'1111','2222','2025-06-10','3333',1,1,'4444','無',NULL,'無',NULL,'無',NULL,'無','999','無','11','無','13','無','15','無','18','無','20','無','22','無','34','無','444','無','5555','無','888','無','999','無','22222','無','2222','無','22',1,1,'222','2025-06-10','2222','2025-06-10 00:04:07',NULL,2,'2025-06-10 01:50:32',2,1,'2222','2025-06-10','2222','2025-06-25','2222','2025-06-10','2222',1,1,1,1,NULL,'222',NULL,'1',1,1,NULL,NULL,NULL,NULL),
(11,'111111','222222','2025-06-14','333333',1,1,'4444444','無','5','無','6','無','7','無','8','無','9','無','10','無','11','無','12','無','13','無','14','無','15','無','16','無','17','無','18','無','19','無','20','無','21','無','22',1,1,'abc','2025-06-14','24','2025-06-13 21:25:47',NULL,NULL,'2025-06-13 21:53:50',NULL,3,'25','2025-06-14','26','2025-06-14','29','2025-06-15','30',1,1,1,1,1,'23','1','1',1,1,1,NULL,NULL,NULL),
(12,'NGUYEN VAN　SON','島田建工株式会社',NULL,'大越 花蓮',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(13,'NGUYEN VAN　SON','島田建工株式会社','2025-06-17','大越 花蓮',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(14,'NGUYEN VAN　SON','島田建工株式会社','2025-06-18','大越 花蓮',1,1,'test','有','1','有','2','有','3','有','4','有','5','有','6','有','7','有','8','有','9','有','10','有','11','有','12','有','13','有','14','有','15','有','16','有','17','有','18',1,1,'19','2025-06-18','20',NULL,NULL,2,'2025-06-18 04:37:42',2,1,'21','2025-06-18',NULL,'2025-06-18','24',NULL,NULL,1,1,1,1,1,NULL,'1','1',NULL,NULL,1,'25','23','22'),
(15,'NGUYEN VAN　SON','島田建工株式会社','2025-06-18','大越 花蓮',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(16,'test','test','2025-07-02','test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-06-20 19:30:13',NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL),
(17,'NGUYEN VAN　SON','島田建工株式会社','2025-07-02','大越 花蓮',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_regular_interview_report_supervisors`
--

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

--
-- Dumping data for table `et_doc_regular_interview_report_supervisors`
--

INSERT INTO `et_doc_regular_interview_report_supervisors` VALUES
(1,'トウイ','áđá','2025-01-22','TIEP',NULL,1,'名 代表取締役','ád',NULL,'無し',NULL,'ád',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 03:05:09',NULL,151,'2025-01-23 07:03:04',1,10,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-23','cjgkh',1,1,NULL,1,NULL,NULL,'',NULL,NULL,NULL,NULL),
(2,'トウイ','ABS会社','2025-01-22','TIEP',NULL,NULL,'AAAAAAAAAA','無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,'無し','無し',NULL,'無し',NULL,'無し',NULL,NULL,'無し','無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 07:46:28',NULL,151,'2025-01-23 08:06:50',1,3,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-22','cjgkh',1,1,NULL,1,1,NULL,'',NULL,NULL,NULL,NULL),
(3,'入江　省吾','島田建工株式会社','2025-04-10','ジェン ティ タン ガー',1,NULL,'代表取締役','無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'無し',NULL,NULL,'2025-04-05 06:51:44',NULL,151,'2025-04-05 06:53:02',2,1,NULL,NULL,NULL,NULL,NULL,'2025-04-10','ジェン ティ タン ガー',NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL),
(4,'① 監督者の氏名及び役職 1232','① 監督者の氏名及び役職131231','2025-06-03','① 監督者の氏名及び役職123',1,1,'① 監督者の氏名及び役職123','有','① 監督者の氏名及び役職','有','① 監督者の氏名及び役職','有','① 監督者の氏名及び役職','有','① 監督者の氏名及び役職','無','① 監督者の氏名及び役職','無','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職','① 監督者の氏名及び役職',1,1,'① 監督者の氏名及び役職','2025-12-12','① 監督者の氏名及び役職','2025-06-02 22:20:05',NULL,NULL,'2025-06-03 18:11:33',NULL,10,'① 監督者の氏名及び役職','2025-12-23','① 監督者の氏名及び役職','2025-12-12','① 監督者の氏名及び役職','2025-12-12','① 監督者の氏名及び役職',1,1,1,1,1,'① 監督者の氏名及び役職','1','1',1,1,NULL),
(5,'1','2','2025-06-03','3',NULL,NULL,'4','5','24','6','25','7','26','8','27','9','28','10','29','11','30','12','31','13','32','14','33','15','34','16','35','17','36','18','37','19','38','20','39','21','40','23','41',1,1,'42','2025-06-03','43','2025-06-03 01:39:49',NULL,150,'2025-06-03 01:59:17',2,3,'33','2025-06-03','34','2025-06-03','35','2025-06-03','36',1,1,1,1,NULL,'22','1','1',NULL,NULL,NULL),
(6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2025-06-10 05:32:54',NULL,2,'2025-06-10 05:33:40',2,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(7,'1','2','2025-06-14','3',1,1,'4','無','5','無','6','無','7','無','8','無','9','無','10','無','11','無','12','無','13','無','14','無','15','無','16','無','17','無','18','無','19','無','20','無','21','無','22',1,1,'6','2025-06-14','7','2025-06-14 11:33:13',NULL,2,'2025-06-16 21:04:43',2,2,'8','2025-06-14','9','2025-06-14','3333','2025-06-21','333',NULL,1,1,1,NULL,'test','1','1',1,1,NULL);

--
-- Table structure for table `et_doc_required_docs_accommodation`
--

CREATE TABLE `et_doc_required_docs_accommodation` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT current_timestamp(),
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint(20) NOT NULL,
  `updated_count` int(11) DEFAULT NULL,
  `previously1` varchar(255) DEFAULT NULL,
  `previously8` varchar(255) DEFAULT NULL,
  `previously2` varchar(255) DEFAULT NULL,
  `previously3` varchar(255) DEFAULT NULL,
  `previously4` varchar(255) DEFAULT NULL,
  `previously5` varchar(255) DEFAULT NULL,
  `previously6` varchar(255) DEFAULT NULL,
  `previously7` varchar(255) DEFAULT NULL,
  `either1` varchar(10) DEFAULT NULL,
  `either2` varchar(10) DEFAULT NULL,
  `either3` varchar(10) DEFAULT NULL,
  `either4` varchar(10) DEFAULT NULL,
  `either5` varchar(10) DEFAULT NULL,
  `either6` varchar(10) DEFAULT NULL,
  `either7` varchar(10) DEFAULT NULL,
  `either8` varchar(10) DEFAULT NULL,
  `official1` varchar(10) DEFAULT NULL,
  `official2` varchar(10) DEFAULT NULL,
  `official3` varchar(10) DEFAULT NULL,
  `official4` varchar(10) DEFAULT NULL,
  `official5` varchar(10) DEFAULT NULL,
  `official6` varchar(10) DEFAULT NULL,
  `official7` varchar(10) DEFAULT NULL,
  `official8` varchar(10) DEFAULT NULL,
  `eithe1` varchar(10) DEFAULT NULL,
  `eithe2` varchar(10) DEFAULT NULL,
  `eithe3` varchar(10) DEFAULT NULL,
  `eithe4` varchar(10) DEFAULT NULL,
  `eithe5` varchar(10) DEFAULT NULL,
  `eithe6` varchar(10) DEFAULT NULL,
  `eithe7` varchar(10) DEFAULT NULL,
  `eithe8` varchar(10) DEFAULT NULL,
  `officia1` varchar(10) DEFAULT NULL,
  `officia2` varchar(10) DEFAULT NULL,
  `officia3` varchar(10) DEFAULT NULL,
  `officia4` varchar(10) DEFAULT NULL,
  `officia5` varchar(10) DEFAULT NULL,
  `officia6` varchar(10) DEFAULT NULL,
  `officia7` varchar(10) DEFAULT NULL,
  `officia8` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_required_docs_accommodation`
--

INSERT INTO `et_doc_required_docs_accommodation` VALUES
(1,NULL,NULL,151,'2025-02-04 00:00:00',1,17,'1234','345','345','345','e67','125','345','345','あり','あり','','あり','なし','なし','ari','なし','あり','あり','あり','ari','ải','なし','ari','nai','','','なし','','','','','','なし','なし','なし','nasi','nashi','nái','nasi','0');

--
-- Table structure for table `et_doc_required_documents_fishing_sector`
--

CREATE TABLE `et_doc_required_documents_fishing_sector` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `radio_havenone_1` varchar(5) DEFAULT NULL,
  `past_application` varchar(200) DEFAULT NULL,
  `form_number` varchar(200) DEFAULT NULL,
  `notes` varchar(200) DEFAULT NULL,
  `radio_official_1` varchar(5) DEFAULT NULL,
  `form_number_b` varchar(200) DEFAULT NULL,
  `radio_havenone_b` varchar(5) DEFAULT NULL,
  `past_application_b` varchar(100) DEFAULT NULL,
  `radio_official_b` varchar(5) DEFAULT NULL,
  `form_number_c` varchar(100) DEFAULT NULL,
  `radio_havenone_c` varchar(5) DEFAULT NULL,
  `past_application_c` varchar(100) DEFAULT NULL,
  `radio_official_c` varchar(5) DEFAULT NULL,
  `form_number_d` varchar(100) DEFAULT NULL,
  `radio_havenone_d` varchar(5) DEFAULT NULL,
  `past_application_d` varchar(100) DEFAULT NULL,
  `radio_official_d` varchar(5) DEFAULT NULL,
  `form_number_2` varchar(100) DEFAULT NULL,
  `notes_2` varchar(200) DEFAULT NULL,
  `radio_havenone_2` varchar(5) DEFAULT NULL,
  `past_application_2` varchar(100) DEFAULT NULL,
  `radio_official_2` varchar(5) DEFAULT NULL,
  `notes_3` varchar(200) DEFAULT NULL,
  `radio_havenone_3` varchar(5) DEFAULT NULL,
  `past_application_3` varchar(100) DEFAULT NULL,
  `radio_official_3` varchar(5) DEFAULT NULL,
  `form_number_4` varchar(100) DEFAULT NULL,
  `notes_4` varchar(200) DEFAULT NULL,
  `radio_havenone_4` varchar(5) DEFAULT NULL,
  `past_application_4` varchar(200) DEFAULT NULL,
  `radio_official_4` varchar(5) DEFAULT NULL,
  `notes_5` varchar(200) DEFAULT NULL,
  `radio_havenone_5` varchar(5) DEFAULT NULL,
  `past_application_5` varchar(100) DEFAULT NULL,
  `radio_official_5` varchar(10) DEFAULT NULL,
  `notes_6` varchar(100) DEFAULT NULL,
  `radio_havenone_6` varchar(10) DEFAULT NULL,
  `past_application_6` varchar(100) DEFAULT NULL,
  `radio_official_6` varchar(10) DEFAULT NULL,
  `form_number_7a` varchar(100) DEFAULT NULL,
  `radio_havenone_7a` varchar(10) DEFAULT NULL,
  `past_application_7a` varchar(100) DEFAULT NULL,
  `radio_official_7a` varchar(10) DEFAULT NULL,
  `form_number_7b` varchar(100) DEFAULT NULL,
  `radio_havenone_7b` varchar(10) DEFAULT NULL,
  `past_application_7b` varchar(100) DEFAULT NULL,
  `radio_official_7b` varchar(10) DEFAULT NULL,
  `form_number_7c` varchar(100) DEFAULT NULL,
  `radio_havenone_7c` varchar(10) DEFAULT NULL,
  `past_application_7c` varchar(100) DEFAULT NULL,
  `radio_official_7c` varchar(10) DEFAULT NULL,
  `form_number_8` varchar(100) DEFAULT NULL,
  `radio_havenone_8` varchar(10) DEFAULT NULL,
  `past_application_8` varchar(100) DEFAULT NULL,
  `radio_official_8` varchar(10) DEFAULT NULL,
  `form_number_9` varchar(100) DEFAULT NULL,
  `radio_havenone_9` varchar(10) DEFAULT NULL,
  `past_application_9` varchar(100) DEFAULT NULL,
  `radio_official_9` varchar(10) DEFAULT NULL,
  `form_number_10a` varchar(255) DEFAULT NULL,
  `radio_havenone_10a` varchar(10) DEFAULT NULL,
  `past_application_10a` text DEFAULT NULL,
  `radio_official_10a` varchar(10) DEFAULT NULL,
  `form_number_10b` varchar(255) DEFAULT NULL,
  `radio_havenone_10b` varchar(10) DEFAULT NULL,
  `past_application_10b` text DEFAULT NULL,
  `radio_official_10b` varchar(10) DEFAULT NULL,
  `radio_havenone_11` varchar(10) DEFAULT NULL,
  `past_application_11` text DEFAULT NULL,
  `radio_official_11` varchar(10) DEFAULT NULL,
  `notes_12` text DEFAULT NULL,
  `radio_havenone_12` varchar(10) DEFAULT NULL,
  `past_application_12` text DEFAULT NULL,
  `radio_official_12` varchar(10) DEFAULT NULL,
  `form_number_13a` varchar(255) DEFAULT NULL,
  `radio_havenone_13a` varchar(10) DEFAULT NULL,
  `past_application_13a` text DEFAULT NULL,
  `radio_official_13a` varchar(10) DEFAULT NULL,
  `form_number_13b` varchar(255) DEFAULT NULL,
  `radio_havenone_13b` varchar(10) DEFAULT NULL,
  `past_application_13b` text DEFAULT NULL,
  `radio_official_13b` varchar(10) DEFAULT NULL,
  `form_number_13c` varchar(255) DEFAULT NULL,
  `radio_havenone_13c` varchar(10) DEFAULT NULL,
  `past_application_13c` text DEFAULT NULL,
  `radio_official_13c` varchar(10) DEFAULT NULL,
  `form_number_14a` varchar(255) DEFAULT NULL,
  `radio_havenone_14a` varchar(10) DEFAULT NULL,
  `past_application_14a` text DEFAULT NULL,
  `radio_official_14a` varchar(10) DEFAULT NULL,
  `form_number_14b` varchar(255) DEFAULT NULL,
  `radio_havenone_14b` varchar(10) DEFAULT NULL,
  `past_application_14b` text DEFAULT NULL,
  `radio_official_14b` varchar(10) DEFAULT NULL,
  `form_number_15` varchar(255) DEFAULT NULL,
  `radio_havenone_15` varchar(10) DEFAULT NULL,
  `past_application_15` text DEFAULT NULL,
  `radio_official_15` varchar(10) DEFAULT NULL,
  `form_number_16a` varchar(255) DEFAULT NULL,
  `radio_havenone_16a` varchar(10) DEFAULT NULL,
  `past_application_16a` text DEFAULT NULL,
  `radio_official_16a` varchar(10) DEFAULT NULL,
  `radio_havenone_17` varchar(10) DEFAULT NULL,
  `past_application_17` text DEFAULT NULL,
  `radio_official_17` varchar(10) DEFAULT NULL,
  `is_not_labor_insurance` tinyint(1) DEFAULT NULL,
  `is_not_applicable_7d` tinyint(1) DEFAULT NULL,
  `is_not_labor_insurance_13` tinyint(1) DEFAULT NULL,
  `is_not_applicable_13d` tinyint(1) DEFAULT NULL,
  `radio_havenone_16b` varchar(10) DEFAULT NULL,
  `radio_official_16b` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_required_documents_fishing_sector`
--

INSERT INTO `et_doc_required_documents_fishing_sector` VALUES
(1,NULL,NULL,'2025-05-27 17:16:45',1,'2025-06-07 05:06:11',1,5,'有','aaa','c','fafa','有','aa','有','aa','無','v','無','aa',NULL,'aa','無','aa','無',NULL,'aa','有','aa','有','aa','有','aa','有','aa','aa','有','aa','有',NULL,NULL,NULL,'有',NULL,'有',NULL,NULL,NULL,'無',NULL,'無',NULL,'無',NULL,'有',NULL,'有',NULL,'有','dd','無','ccc','無','ccc','有','cccc','有','BBB','有','aa','無','AAAA','無','aaa','無','無','VVV',NULL,'ccc','有','cc','有','ccc','無','aa','有','cccc','無','ccc','無','aaaaaaaaaaaa','有','ccc','有','VVV','有','BCCCC','有','VV',NULL,'CCCCCCCCC','有','XXX','有','VVV','有','VV','無','DDD',NULL,NULL,'VVVVVV','有',NULL,NULL,NULL,NULL,'無',NULL);

--
-- Table structure for table `et_doc_residence_extension_tokutei2`
--

CREATE TABLE `et_doc_residence_extension_tokutei2` (
  `id_residence_extension_tokutei` bigint(20) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id_residence_extension_tokutei`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_residence_extension_tokutei2`
--

INSERT INTO `et_doc_residence_extension_tokutei2` VALUES
(2),
(3);

--
-- Table structure for table `et_doc_resume_of_support_manager`
--

CREATE TABLE `et_doc_resume_of_support_manager` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) DEFAULT NULL,
  `gender` varchar(20) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `year` text DEFAULT NULL,
  `month` text DEFAULT NULL,
  `highest` text DEFAULT NULL,
  `qualifications_licenses` varchar(255) DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `name_support_person_charge` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `full_name2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_resume_of_support_manager`
--

INSERT INTO `et_doc_resume_of_support_manager` VALUES
(1,'のおか　タロウ','男','1990-10-11','[\"2010\",\"2014\",null,null,null,null,null,null,null,null]','[\"12\",\"10\",null,null,null,null,null,null,null,null]','[\"\\u5927\\u5b66\",\"TTTT\\u5927\\u5b66\\u9662\",null,null,null,null,null,null,null,null]','N3','2024-12-23','takemura',NULL,NULL,'2024-12-23 06:38:27',151,'2025-01-06 02:08:14',1,9,'農園 太郎');

--
-- Table structure for table `et_doc_resume_of_support_staff`
--

CREATE TABLE `et_doc_resume_of_support_staff` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) DEFAULT NULL,
  `gender` varchar(10) DEFAULT NULL,
  `date_of_birth` varchar(50) DEFAULT NULL,
  `year` text DEFAULT NULL,
  `month` text DEFAULT NULL,
  `highest` text DEFAULT NULL,
  `qualifications_licenses` varchar(255) DEFAULT NULL,
  `date_create` varchar(50) DEFAULT NULL,
  `name_support_person_charge` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `full_name2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_resume_of_support_staff`
--

INSERT INTO `et_doc_resume_of_support_staff` VALUES
(1,'農園 太郎','2','1987-08-07',NULL,NULL,NULL,'','2024-12-24','オオノ',NULL,NULL,'2024-12-23 08:57:22',NULL,'2024-12-23 08:57:22',1,0,NULL),
(2,'オオノ','男','2000-02-10','[\"2010\",\"2014\",null,null,null,null,null,null,null,null]','[\"1\",\"2\",null,null,null,null,null,null,null,null]','[\"ABC\\u5927\\u5b66\",\"TTTT\\u5927\\u5b66\\u9662\",null,null,null,null,null,null,null,null]','N3','2025-02-10','takemura',NULL,NULL,'2025-02-10 03:09:30',151,'2025-02-10 03:10:40',1,1,'大野'),
(3,'','','','[null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null]','','','',NULL,NULL,'2025-03-12 08:05:03',NULL,'2025-03-12 08:05:03',1,0,''),
(4,'農園 太郎','男','2025-03-13','[\"2020\",null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null]','[\"ABC\\u5927\\u5b66\",null,null,null,null,null,null,null,null,null]','N3','2025-03-12','オオノ',NULL,NULL,'2025-03-12 08:14:54',151,'2025-03-12 08:59:08',2,1,'大野'),
(5,'大越 花蓮','ggb','2025-06-24','[\"2014\",\"2015\",null,null,null,null,null,\"12\",null,null]','[\"10\",\"12\",null,null,null,null,null,\"112\",null,null]','[\"ABC\\u5927\\u5b66\",\"\\u5927\\u5b66\",null,null,null,null,null,\"mhcvhj\",null,null]','なし','2025-06-24','takemura',NULL,NULL,'2025-06-24 11:44:00',1,'2025-07-08 06:10:37',1,5,'HONG KILDONG');

--
-- Table structure for table `et_doc_returncountry_declaration`
--

CREATE TABLE `et_doc_returncountry_declaration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `reason_type` int(11) DEFAULT NULL COMMENT '1:帰国便都合, 2:技能実習期間の末日が休日である, 3:その他',
  `reason_other_note` varchar(255) DEFAULT NULL,
  `deadline_date` date DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `person_type` int(11) DEFAULT NULL COMMENT ' 1: 監理団体  2:実習実施者',
  `person_name` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_name` varchar(255) DEFAULT NULL,
  `sign_director_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `sending_agency_expenses_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `period_date` date DEFAULT NULL,
  `money` varchar(255) DEFAULT NULL,
  `money_yen` int(11) DEFAULT NULL,
  `pay_method` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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(11) NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sending_agency_name` varchar(255) DEFAULT NULL,
  `sending_agency_number` varchar(255) DEFAULT NULL,
  `sending_agency_number_ref` varchar(255) DEFAULT NULL,
  `created_by_name` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(20) unsigned NOT NULL AUTO_INCREMENT,
  `sending_agency_oath_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `national` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `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(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `director_name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `establish_date` date DEFAULT NULL,
  `business_content` varchar(255) DEFAULT NULL,
  `capital` varchar(255) DEFAULT NULL,
  `capital_yen` int(11) DEFAULT NULL,
  `earning_money` varchar(255) DEFAULT NULL,
  `earning_money_yen` int(11) DEFAULT NULL,
  `staff_number` varchar(255) DEFAULT NULL,
  `leader_name` varchar(255) DEFAULT NULL,
  `jp_name` varchar(255) DEFAULT NULL,
  `jp_address` varchar(255) DEFAULT NULL,
  `jp_postcode` varchar(255) DEFAULT NULL,
  `jp_tel` varchar(255) DEFAULT NULL,
  `jp_director_name` varchar(255) DEFAULT NULL,
  `jp_staff` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_name` varchar(255) DEFAULT NULL,
  `sign_director_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `sendingagency_name` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `director_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `check_1` int(11) DEFAULT NULL,
  `check_2` int(11) 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(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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_skills_transfer_declaration`
--

CREATE TABLE `et_doc_skills_transfer_declaration` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) DEFAULT NULL,
  `gender` tinyint(4) DEFAULT NULL,
  `nationality_region` varchar(255) DEFAULT NULL,
  `acquire_skills` varchar(255) DEFAULT NULL,
  `proficient_skilled` varchar(255) DEFAULT NULL,
  `signature_declarant` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `home_country` varchar(255) DEFAULT NULL,
  `year` varchar(10) NOT NULL,
  `month` varchar(10) NOT NULL,
  `day` varchar(10) NOT NULL,
  `date_of_birth` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_skills_transfer_declaration`
--

INSERT INTO `et_doc_skills_transfer_declaration` VALUES
(1,'オオノ',2,'タイ','社長','社長','あｇｄぁｆがｌｆｇ',NULL,NULL,'2024-12-14 07:20:04',1,'2024-12-14 09:09:50',1,3,'ベトナム','','','',NULL),
(2,'ádasdasd',2,'タイ','社長','社長','AAAAAAAAAAAAAAAA',NULL,NULL,'2024-12-18 06:03:58',151,'2025-02-22 04:47:05',1,2,'タイ','','','',NULL),
(3,'農園 太郎',2,'タイ','社長','社長','AB',NULL,NULL,'2025-04-19 09:01:36',151,'2025-04-19 09:04:05',2,1,'ベトナム','','','',NULL),
(4,'ád',1,'ád','ád','ads','dfsgsdgdf',NULL,NULL,'2025-06-23 04:30:18',1,'2025-07-12 06:51:05',1,2,'ád','2001','12','20','2025-06-23');

--
-- Table structure for table `et_doc_skills_transfer_declaration_vn`
--

CREATE TABLE `et_doc_skills_transfer_declaration_vn` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) DEFAULT NULL,
  `gender` tinyint(4) DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `nationality_region` varchar(255) DEFAULT NULL,
  `acquire_skills` varchar(255) DEFAULT NULL,
  `proficient_skilled` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `signature_declarant` varchar(255) DEFAULT NULL,
  `full_name_vn` varchar(255) DEFAULT NULL,
  `gender_vn` tinyint(4) DEFAULT NULL,
  `date_of_birth_vn` date DEFAULT NULL,
  `nationality_region_vn` varchar(255) DEFAULT NULL,
  `acquire_skills_vn` varchar(255) DEFAULT NULL,
  `proficient_skilled_vn` varchar(255) DEFAULT NULL,
  `date_vn` date DEFAULT NULL,
  `signature_declarant_vn` varchar(255) DEFAULT NULL,
  `home_country_vn` varchar(255) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `home_country` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_skills_transfer_declaration_vn`
--


--
-- Table structure for table `et_doc_specific_skills_affiliation_agency_profile`
--

CREATE TABLE `et_doc_specific_skills_affiliation_agency_profile` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `post` text DEFAULT NULL,
  `previous_year` text DEFAULT NULL,
  `two_years_ago` text DEFAULT NULL,
  `year_before` text DEFAULT NULL,
  `voluntary_leavers1` varchar(255) DEFAULT NULL,
  `voluntary_leavers2` varchar(255) DEFAULT NULL,
  `voluntary_leavers3` varchar(255) DEFAULT NULL,
  `voluntary_leavers4` varchar(255) DEFAULT NULL,
  `involuntary_separatic` varchar(255) DEFAULT NULL,
  `date_f_1` date DEFAULT NULL,
  `date_t_1` date DEFAULT NULL,
  `name_organization` varchar(200) DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `support` tinyint(1) DEFAULT NULL,
  `life` tinyint(1) DEFAULT NULL,
  `regarding` tinyint(1) DEFAULT NULL,
  `others` tinyint(1) DEFAULT NULL,
  `others_txt` varchar(200) DEFAULT NULL,
  `have_none` tinyint(4) DEFAULT NULL,
  `list` tinyint(1) DEFAULT NULL,
  `documents` tinyint(1) DEFAULT NULL,
  `contract` tinyint(1) DEFAULT NULL,
  `others1` tinyint(1) DEFAULT NULL,
  `others1_txt` varchar(200) DEFAULT NULL,
  `date_f_2` date DEFAULT NULL,
  `date_t_2` date DEFAULT NULL,
  `name_organization1` varchar(200) DEFAULT NULL,
  `location1` varchar(200) DEFAULT NULL,
  `support2` tinyint(1) DEFAULT NULL,
  `life2` tinyint(1) DEFAULT NULL,
  `regarding2` tinyint(1) DEFAULT NULL,
  `others2` tinyint(1) DEFAULT NULL,
  `others2_txt` varchar(200) DEFAULT NULL,
  `prove` tinyint(1) DEFAULT NULL,
  `corrective` tinyint(1) DEFAULT NULL,
  `no_corrective` tinyint(1) DEFAULT NULL,
  `full_name1` text DEFAULT NULL,
  `d_p2` text DEFAULT NULL,
  `full_name2` text DEFAULT NULL,
  `d_p1` text DEFAULT NULL,
  `full_name3` text DEFAULT NULL,
  `d_p3` text DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `name_organization_3` varchar(255) DEFAULT NULL,
  `position_name` varchar(255) DEFAULT NULL,
  `namei` text DEFAULT NULL,
  `last_year_ago1` varchar(255) DEFAULT NULL,
  `last_year_ago2` varchar(255) DEFAULT NULL,
  `involuntary_separation1` varchar(255) DEFAULT NULL,
  `involuntary_separation2` varchar(255) DEFAULT NULL,
  `acc1` tinyint(4) DEFAULT NULL,
  `acc2` tinyint(4) DEFAULT NULL,
  `c_w_l` tinyint(4) DEFAULT NULL,
  `c_w_2` tinyint(4) DEFAULT NULL,
  `violation1` tinyint(4) DEFAULT NULL,
  `violation2` tinyint(4) DEFAULT NULL,
  `attached_documents` tinyint(4) DEFAULT NULL,
  `acc3` tinyint(1) DEFAULT NULL,
  `applic1` tinyint(1) DEFAULT NULL,
  `n_a1` tinyint(1) DEFAULT NULL,
  `applic2` tinyint(1) DEFAULT NULL,
  `n_a2` tinyint(1) DEFAULT NULL,
  `job` varchar(255) DEFAULT NULL,
  `have_none2` tinyint(4) DEFAULT NULL,
  `list2` tinyint(4) DEFAULT NULL,
  `documents2` tinyint(4) DEFAULT NULL,
  `contract2` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_specific_skills_affiliation_agency_profile`
--

INSERT INTO `et_doc_specific_skills_affiliation_agency_profile` VALUES
(1,'[\"\\u30aa\\u30aa\\u30ce\",\"\\u306b\\u3085\\u3046\\u304b\\u3093\\u305f\\u308d\\u3046\",\"\\u3055\\u3068\\u3046\",\"\\u30b9\\u30ba\\u30ad\",\"\\u3042\\u304a\\u3084\\u307e\"]','[\"\\u793e\\u9577\",\"\\u8ab2\\u9577\",\"\\u90e8\\u9577\",\"\\u4fc2\\u9577\",\"\\u526f\\u793e\\u9577\"]','[\"160,000,000\\u5186\",\"50,000,000\\u5186\",\"2,000,000\\u5186\",\"6,000,000\\u5186\"]','[\"150,000,000\\u5186\",\"40,000,000\\u5186\",\"10,000,000\\u5186\",\"5,000,000\\u5186\"]','[\"140,000,000\\u5186\",\"30,000,000\\u5186\",\"10,000,000\\u5186\",\"6,000,000\\u5186\"]','10','2','1','3','','2025-01-21','2027-01-20','aoyama会社','千葉',0,0,0,0,'ｇｆぁｆは',1,0,0,0,0,'ｆがｌｈふぁ','2025-01-20','2027-01-20','ふぁｇｆ；あ','２０○○年△△月△△日～２０○○年△△月△△日',0,0,0,0,'ｇｆんふぁ；ｆｊ',0,1,0,'[\"takana\",\"haha\",\"suzuku\"]','[\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u9577\",\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u9577\",\"gsghdsh\"]','[\"take\",\"kna\",\"ttasa\"]','[\"\\u5efa\\u8a2d\\u90e8\\u9580\",\"\\u5916\\u98df\\u90e8\\u9580\",\"\\u5916\\u98df\\u90e8\\u9580\"]','[\"uuu\",\"eee\",\"dffg\"]','[\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u54e1\",\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u54e1\",\"\\u0111gd\"]',NULL,NULL,'2024-12-16 02:36:55',151,'2025-01-21 04:36:40',1,34,'2025-01-14','aoyama会社','THUY','[\"\\u5927\\u91ce\",\"\\u4e39\\u751f\\u8cab\\u592a\\u90ce\",\"\\u4f50\\u85e4\",\"\\u9234\\u6728\",\"\\u9752\\u5c71\"]','1','1','1','１',1,1,0,0,1,0,1,0,0,1,1,0,'',1,1,0,0),
(2,'[\"\\u306b\\u3085\\u3046\\u304b\\u3093 \\u305f\\u308d\\u3046\",\"\\u306b\\u3085\\u3046\\u304b\\u3093 \\u306f\\u306a\\u3053\",null,null,null]','[\"\\u4ee3\\u8868\\u53d6\\u7de0\\u5f79\",\"\\u8ab2\\u9577\",null,null,null]','[\"160,000,000\",\"50,000,000\",\"2,000,000\",\"6,000,000\"]','[\"160,000,000\",\"40,000,000\",\"10,000,000\",\"5,000,000\"]','[\"140,000,000\",\"30,000,000\",\"10,000,000\",\"6,000,000\"]','10','3','1','2','','2025-04-16','2025-04-24','法務株式会社','新宿',1,1,1,1,'',1,1,0,1,1,'adadadad','2025-04-18','2025-04-17','株式会社入管','２０○○年△△月△△日～２０○○年△△月△△日',1,1,1,0,'www',NULL,1,0,'[\"takana\",null,null]','[\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u9577\",null,null]','[\"take\",null,null]','[\"\\u88fd\\u9020\\u90e8\\u9580\",null,null]','[\"uuu\",null,null]','[\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u54e1\",null,null]',NULL,NULL,'2025-04-19 09:26:09',NULL,'2025-04-19 09:26:09',2,0,'2025-04-16','','','[\"\\u5165\\u7ba1 \\u592a\\u90ce\",\"\\u5165\\u7ba1 \\u82b1\\u5b50\",null,null,null]','1','2','1','1',0,0,1,0,0,0,1,1,1,0,1,0,'',1,0,0,0);

--
-- Table structure for table `et_doc_specific_skills_employ_contract`
--

CREATE TABLE `et_doc_specific_skills_employ_contract` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `specific_skills_affiliation_agency` varchar(255) DEFAULT NULL,
  `specified_skilled_foreigners` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `second` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_specific_skills_employ_contract`
--

INSERT INTO `et_doc_specific_skills_employ_contract` VALUES
(1,'dsfsf','sdfsdf','2024-11-11','123','123','2024-10-29 11:53:57',NULL,NULL,'2024-10-29 11:53:57',1,0),
(2,'オオノ会社','タナカ','2024-12-14','ｇふぁｌｈふぁｌｈｆ','ｇｌだｇぁｈｆ','2024-12-14 11:17:42',NULL,NULL,'2024-12-14 11:17:42',1,0),
(3,'オオノ会社','タナカ','2025-02-12','ｇふぁｌｈふぁｌｈｆ','ｇｌだｇぁｈｆ','2024-12-31 16:49:37',NULL,151,'2025-02-22 13:37:14',1,1),
(4,'オオノ会社','タナカ','2025-03-17','株式会社 入管','法務協同組合','2025-03-17 13:03:11',NULL,151,'2025-03-17 13:06:01',2,1),
(5,'田中会社','TRAN　VAN　LAM','2025-04-18','株式会社 入管','法務協同組合','2025-04-19 17:22:00',NULL,NULL,'2025-04-19 17:22:00',2,0),
(6,'オオノ会社','TRAN　VAN　AAAA','2025-06-17','株式会社 入管','法務協同組合','2025-06-17 15:47:42',NULL,NULL,'2025-06-17 15:47:42',1,0);

--
-- Table structure for table `et_doc_specific_skills_employ_contract_indo`
--

CREATE TABLE `et_doc_specific_skills_employ_contract_indo` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `specific_skills_affiliation_agency` varchar(255) DEFAULT NULL,
  `specified_skilled_foreigners` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `second` varchar(255) DEFAULT NULL,
  `specific_skills_affiliation_agency_vn` varchar(255) DEFAULT NULL,
  `specified_skilled_foreigners_vn` varchar(255) DEFAULT NULL,
  `date_vn` date DEFAULT NULL,
  `first_vn` varchar(255) DEFAULT NULL,
  `second_vn` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_specific_skills_employ_contract_indo`
--

INSERT INTO `et_doc_specific_skills_employ_contract_indo` VALUES
(1,'田中会社','TRAN　VAN　LAM','2025-07-09','株式会社 入管','TRAN VAN LAM','CONG TY ONO','TRAN　VAN　LAM','2025-07-09','CONG TY ONO','TRAN　VAN　LAM','2025-07-03 15:07:46',NULL,1,'2025-07-05 16:27:12',1,2);

--
-- Table structure for table `et_doc_specific_skills_employ_contract_vn`
--

CREATE TABLE `et_doc_specific_skills_employ_contract_vn` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `specific_skills_affiliation_agency` varchar(255) DEFAULT NULL,
  `specified_skilled_foreigners` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `second` varchar(255) DEFAULT NULL,
  `specific_skills_affiliation_agency_vn` varchar(255) DEFAULT NULL,
  `specified_skilled_foreigners_vn` varchar(255) DEFAULT NULL,
  `date_vn` date DEFAULT NULL,
  `first_vn` varchar(255) DEFAULT NULL,
  `second_vn` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT current_timestamp(),
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_specific_skills_employ_contract_vn`
--

INSERT INTO `et_doc_specific_skills_employ_contract_vn` VALUES
(5,'オオノ会社','TRAN　VAN　LAM','2025-05-06','オオノ会社','TRAN　VAN　LAM','CONG TY ONO','TRAN　VAN　LAM','2025-05-05','CONG TY ONO','TRAN　VAN　LAM','2025-05-05 12:52:37',NULL,NULL,'2025-05-05 12:52:37',1,0);

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

CREATE TABLE `et_doc_staff_cv` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `staff_incharge_id` int(11) DEFAULT NULL,
  `staff_instructor_gino_id` int(11) DEFAULT NULL,
  `staff_instuctor_life_id` int(11) DEFAULT NULL,
  `staff_furigana` varchar(255) DEFAULT NULL,
  `staff_name` varchar(255) DEFAULT NULL,
  `staff_birthdate` date DEFAULT NULL,
  `staff_national` varchar(255) DEFAULT NULL,
  `staff_degree` varchar(255) DEFAULT NULL,
  `staff_technical_training` varchar(255) DEFAULT NULL,
  `instructor_furigana` varchar(255) DEFAULT NULL,
  `instructor_name` varchar(255) DEFAULT NULL,
  `instructor_birthdate` date DEFAULT NULL,
  `instructor_national` varchar(255) DEFAULT NULL,
  `instructor_degree` varchar(255) DEFAULT NULL,
  `instructor_technical_training` varchar(255) DEFAULT NULL,
  `life_instructor_furigana` varchar(255) DEFAULT NULL,
  `life_instructor_name` varchar(255) DEFAULT NULL,
  `life_instructor_birthdate` date DEFAULT NULL,
  `life_instructor_national` varchar(255) DEFAULT NULL,
  `life_instructor_degree` varchar(255) DEFAULT NULL,
  `life_instructor_technical_training` varchar(255) DEFAULT NULL,
  `applicant_name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `content_technical` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sign_staff_name` varchar(255) DEFAULT NULL,
  `sign_instructor_name` varchar(255) DEFAULT NULL,
  `sign_life_instructor_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint(20) NOT NULL,
  `updated_count` int(11) 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(11) NOT NULL AUTO_INCREMENT,
  `staff_cv_id` bigint(20) NOT NULL,
  `file` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL COMMENT '1 staff, 2 instructor, 3 life_instructor',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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(11) NOT NULL AUTO_INCREMENT,
  `staff_cv_id` bigint(20) NOT NULL,
  `year` varchar(4) DEFAULT NULL,
  `month` varchar(2) DEFAULT NULL,
  `date` int(11) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `type` int(11) NOT NULL COMMENT '1 staff, 2 instructor, 3 life_instructor',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `name_furigana` varchar(255) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL COMMENT '1:male, 2:female',
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `company_postcode` varchar(255) DEFAULT NULL,
  `company_tel` varchar(255) DEFAULT NULL,
  `job_title` varchar(255) DEFAULT NULL,
  `certificate` varchar(255) DEFAULT NULL,
  `job_cv` varchar(255) DEFAULT NULL,
  `job_sermina_cv` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) DEFAULT NULL,
  `sign_creator_title` varchar(255) DEFAULT NULL,
  `sign_creator_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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),
(5,'VO　THI THU THUY','ヴオー',2,'2000-05-20','ベトナム','045641','千葉県船橋市北本町1-12-1-818','045-02455','株式会社ABC','千葉県船橋市北本町1-12-1-818','075111','0455111','代表取締役','無し','大学卒','なし','2025-06-16','入江 省吾','Thuy','Thuy Thuy',NULL,NULL,NULL,1,1,1);

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

CREATE TABLE `et_doc_supervisor_pledge` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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_support_contract`
--

CREATE TABLE `et_doc_support_contract` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `specific_skills_affiliation_agency` varchar(255) DEFAULT NULL,
  `registration_support_organization` varchar(255) DEFAULT NULL,
  `specific_skilled` varchar(255) DEFAULT NULL,
  `date_form` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first` varchar(255) DEFAULT NULL,
  `second` varchar(255) DEFAULT NULL,
  `nominal` text DEFAULT NULL,
  `amount` text DEFAULT NULL,
  `anytime` text DEFAULT NULL,
  `regular` text DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `monthly` varchar(255) DEFAULT NULL,
  `total` varchar(255) DEFAULT NULL,
  `txt_industry` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_support_contract`
--

INSERT INTO `et_doc_support_contract` VALUES
(1,'ádasd','ádasd','ádasd','2024-12-17','2024-12-17','2024-12-17','ádasd','ádasd','[\"\\u00e1dasd\",null,null,null,null,\"\\u00e1das\\u0111\",\"\\u00e1dasd\",null,null,null]','[\"\\u00e1dasd\",null,null,\"\\u00e1dasd\",null,\"\\u00e1dasd\",null,null,null,null]','[null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,\"1\",null,\"1\",null,null,null,null]',NULL,NULL,'2024-12-16 16:35:31',1,'2024-12-16 17:13:52',1,7,'ádafgsfdgdsdfg',NULL,NULL),
(2,'田中会社','株式会社 入管','ＫＯＵ ＯＴＵＨＥＩ','2024-12-04','2026-01-14','2025-01-14','ｇふぁｌｈふぁｌｈｆ','法務協同組合','[\"\\u4e8b\\u524d\\u30ac\\u30a4\\u30c0\\u30f3\\u30b9\\u8cbb\\u7528\",\"\\u51fa\\u5165\\u56fd\\u3059\\u308b\\u969b\\u306e\\u9001\\u8fce\",\"\\u8ee2\\u8077\\u652f\\u63f4\",null,null,null,null,null,null,null]','[\"120000\",\"30000\",\"5000\",null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null]','[null,null,\"1\",null,null,null,null,null,null,null]',NULL,NULL,'2025-01-02 04:55:39',151,'2025-01-14 07:43:26',1,2,'200000','155000',NULL),
(3,'オオノ会社','株式会社 入管','ＫＯＵ ＯＴＵＨＥＩ','2025-03-11','2026-03-10','2025-03-10','ｇふぁｌｈふぁｌｈｆ','法務協同組合','[\"\\u4e8b\\u524d\\u30ac\\u30a4\\u30c0\\u30f3\\u30b9\\u8cbb\\u7528\",\"\\u51fa\\u5165\\u56fd\\u3059\\u308b\\u969b\\u306e\\u9001\\u8fce\",\"\\u8ee2\\u8077\\u652f\\u63f4\",\"aaaa\",\"dfgggg\",\"gsffsfff\",\"ttfggf\",\"hdhdgd\",\"dgdgdg\",\"ssfsffs\"]','[\"3000\",\"30000\",\"5000\",\"5000\",null,\"3000\",\"4000\",\"5000\",\"6000\",\"7000\"]','[\"1\",null,\"1\",\"1\",\"1\",\"1\",null,null,null,null]','[null,null,null,null,null,null,null,\"1\",\"1\",\"1\"]',NULL,NULL,'2025-03-11 08:10:10',151,'2025-03-11 08:45:01',2,5,'200000','68000','外食業');

--
-- Table structure for table `et_doc_support_plan_reference`
--

CREATE TABLE `et_doc_support_plan_reference` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint(20) NOT NULL,
  `updated_count` int(11) DEFAULT NULL,
  `full_name` text DEFAULT NULL,
  `orther` text DEFAULT NULL,
  `gender` varchar(5) DEFAULT NULL,
  `date_target` date DEFAULT NULL,
  `na_re1` text DEFAULT NULL,
  `furigana1` text DEFAULT NULL,
  `name_or_title1` text DEFAULT NULL,
  `code1` text DEFAULT NULL,
  `address1` text DEFAULT NULL,
  `telephone` text DEFAULT NULL,
  `code2` text DEFAULT NULL,
  `address2` text DEFAULT NULL,
  `telephone2` text DEFAULT NULL,
  `furigana2` varchar(50) DEFAULT NULL,
  `name_of_title2` varchar(50) DEFAULT NULL,
  `post1` varchar(50) DEFAULT NULL,
  `providing_support1` varchar(50) DEFAULT NULL,
  `number_of_supporters1` varchar(50) DEFAULT NULL,
  `yes_no1` tinyint(1) DEFAULT NULL,
  `registration_number` varchar(100) DEFAULT NULL,
  `date23` date DEFAULT NULL,
  `date33` date DEFAULT NULL,
  `furigana34` text DEFAULT NULL,
  `name_of_title34` text DEFAULT NULL,
  `code34` text DEFAULT NULL,
  `address34` text DEFAULT NULL,
  `tele_phone34` text DEFAULT NULL,
  `furigana63` text DEFAULT NULL,
  `name_of_title63` text DEFAULT NULL,
  `code73` text DEFAULT NULL,
  `address73` varchar(100) DEFAULT NULL,
  `furigana83` varchar(100) DEFAULT NULL,
  `name_of_title83` varchar(100) DEFAULT NULL,
  `post83` varchar(50) DEFAULT NULL,
  `providing_support83` varchar(100) DEFAULT NULL,
  `number_of_support_providers83` varchar(100) DEFAULT NULL,
  `yes_no83` tinyint(1) DEFAULT NULL,
  `date31` date DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `y_n41` tinyint(1) DEFAULT NULL,
  `full_name41b` varchar(100) DEFAULT NULL,
  `code41a` varchar(100) DEFAULT NULL,
  `address41a` varchar(100) DEFAULT NULL,
  `ck_face` tinyint(1) DEFAULT NULL,
  `ck_eq` tinyint(1) DEFAULT NULL,
  `ck_orther` tinyint(1) DEFAULT NULL,
  `ck413` tinyint(1) DEFAULT NULL,
  `ck14e` tinyint(1) DEFAULT NULL,
  `date413` varchar(100) DEFAULT NULL,
  `date14e` varchar(100) DEFAULT NULL,
  `text_orther` varchar(100) DEFAULT NULL,
  `ck41k` tinyint(1) DEFAULT NULL,
  `ck_14k` tinyint(1) DEFAULT NULL,
  `y_n14` tinyint(1) DEFAULT NULL,
  `affiliation_and_name` varchar(100) DEFAULT NULL,
  `total_time` varchar(50) DEFAULT NULL,
  `ck24` tinyint(1) DEFAULT NULL,
  `date24` varchar(100) DEFAULT NULL,
  `ck_24` tinyint(1) DEFAULT NULL,
  `date_24` varchar(100) DEFAULT NULL,
  `y_n341` tinyint(1) DEFAULT NULL,
  `name341` varchar(100) DEFAULT NULL,
  `code341` varchar(50) DEFAULT NULL,
  `address341` varchar(100) DEFAULT NULL,
  `ck3421` tinyint(1) DEFAULT NULL,
  `txt3421` varchar(100) DEFAULT NULL,
  `ck3422` tinyint(1) DEFAULT NULL,
  `txt3422` varchar(100) DEFAULT NULL,
  `ck24b` tinyint(1) DEFAULT NULL,
  `ck_24b` tinyint(1) DEFAULT NULL,
  `date24_b` varchar(100) DEFAULT NULL,
  `y_n342` tinyint(1) DEFAULT NULL,
  `name342` varchar(100) DEFAULT NULL,
  `code342` varchar(100) DEFAULT NULL,
  `address342` varchar(100) DEFAULT NULL,
  `ck3423` tinyint(1) DEFAULT NULL,
  `txt3423` varchar(100) DEFAULT NULL,
  `ck3424` tinyint(1) DEFAULT NULL,
  `txt3424` varchar(100) DEFAULT NULL,
  `ck_orther1` tinyint(1) DEFAULT NULL,
  `ck_orther2` tinyint(1) DEFAULT NULL,
  `y_n343` tinyint(1) DEFAULT NULL,
  `name343` varchar(100) DEFAULT NULL,
  `code343` varchar(100) DEFAULT NULL,
  `address343` varchar(100) DEFAULT NULL,
  `txt3425s` varchar(100) DEFAULT NULL,
  `affiliation_and_name1` varchar(100) DEFAULT NULL,
  `tele_phone73` varchar(15) DEFAULT NULL,
  `ck_34` tinyint(1) DEFAULT NULL,
  `date_34` varchar(100) DEFAULT NULL,
  `ck34` tinyint(1) DEFAULT NULL,
  `date34` varchar(100) DEFAULT NULL,
  `y_n344` tinyint(1) DEFAULT NULL,
  `name344` varchar(100) DEFAULT NULL,
  `code344` varchar(100) DEFAULT NULL,
  `address344` varchar(100) DEFAULT NULL,
  `ck34b` tinyint(1) DEFAULT NULL,
  `date34b` varchar(100) DEFAULT NULL,
  `ck_34b` tinyint(1) DEFAULT NULL,
  `date_34b` varchar(100) DEFAULT NULL,
  `y_n345` tinyint(1) DEFAULT NULL,
  `name345` varchar(100) DEFAULT NULL,
  `code345` varchar(100) DEFAULT NULL,
  `address345` varchar(100) DEFAULT NULL,
  `ck34c` tinyint(1) DEFAULT NULL,
  `date34c` varchar(100) DEFAULT NULL,
  `ck_34c` tinyint(1) DEFAULT NULL,
  `date_34c` varchar(100) DEFAULT NULL,
  `y_n346` tinyint(1) DEFAULT NULL,
  `name346` varchar(100) DEFAULT NULL,
  `code346` varchar(100) DEFAULT NULL,
  `address346` varchar(100) DEFAULT NULL,
  `ck34corther` tinyint(1) DEFAULT NULL,
  `ck34c_orther` tinyint(1) DEFAULT NULL,
  `y_n347` tinyint(1) DEFAULT NULL,
  `name347` varchar(100) DEFAULT NULL,
  `code347` varchar(100) DEFAULT NULL,
  `address347` varchar(100) DEFAULT NULL,
  `txt3426` varchar(100) DEFAULT NULL,
  `ck34d` tinyint(1) DEFAULT NULL,
  `ck34_d` tinyint(1) DEFAULT NULL,
  `number34d` varchar(100) DEFAULT NULL,
  `ck341d` tinyint(1) DEFAULT NULL,
  `ck342d2` tinyint(1) DEFAULT NULL,
  `ck3a2` tinyint(1) DEFAULT NULL,
  `date_3a2` varchar(100) DEFAULT NULL,
  `ck3_a2` tinyint(1) DEFAULT NULL,
  `date3a2` varchar(100) DEFAULT NULL,
  `y_nc1` tinyint(1) DEFAULT NULL,
  `name34a1` varchar(100) DEFAULT NULL,
  `code34a1` varchar(100) DEFAULT NULL,
  `add34a1` varchar(100) DEFAULT NULL,
  `ck341` tinyint(1) DEFAULT NULL,
  `ck342` tinyint(1) DEFAULT NULL,
  `ck343` tinyint(1) DEFAULT NULL,
  `ck3b2` tinyint(1) DEFAULT NULL,
  `date_3b2` varchar(100) DEFAULT NULL,
  `ck3_b2` tinyint(1) DEFAULT NULL,
  `date3_b2` varchar(100) DEFAULT NULL,
  `y_nc2` tinyint(1) DEFAULT NULL,
  `name34a2` varchar(100) DEFAULT NULL,
  `code34a2` varchar(100) DEFAULT NULL,
  `add34a2` varchar(100) DEFAULT NULL,
  `ck344` tinyint(1) DEFAULT NULL,
  `ck345` tinyint(1) DEFAULT NULL,
  `ck346` tinyint(1) DEFAULT NULL,
  `txt346` varchar(100) DEFAULT NULL,
  `ck3_c2` tinyint(1) DEFAULT NULL,
  `date_c2` varchar(100) DEFAULT NULL,
  `ck3c2` tinyint(1) DEFAULT NULL,
  `datec2` varchar(100) DEFAULT NULL,
  `y_nc3` tinyint(1) DEFAULT NULL,
  `name34a3` varchar(100) DEFAULT NULL,
  `code34a3` varchar(100) DEFAULT NULL,
  `add34a3` varchar(100) DEFAULT NULL,
  `ck347` tinyint(1) DEFAULT NULL,
  `ck348` tinyint(1) DEFAULT NULL,
  `ck349` tinyint(1) DEFAULT NULL,
  `txt349` varchar(100) DEFAULT NULL,
  `ckc2_orther` tinyint(1) DEFAULT NULL,
  `ck2_orther` tinyint(1) DEFAULT NULL,
  `y_nc4` tinyint(1) DEFAULT NULL,
  `name34a4` varchar(100) DEFAULT NULL,
  `code34a4` varchar(100) DEFAULT NULL,
  `add34a4` varchar(100) DEFAULT NULL,
  `txt3450` varchar(100) DEFAULT NULL,
  `ck44a` tinyint(1) DEFAULT NULL,
  `date44a` varchar(100) DEFAULT NULL,
  `ck44_a` tinyint(1) DEFAULT NULL,
  `date_44a` varchar(100) DEFAULT NULL,
  `y_nc5` varchar(1) DEFAULT NULL,
  `code34a5` varchar(100) DEFAULT NULL,
  `add34a5` varchar(100) DEFAULT NULL,
  `ck43c` tinyint(1) DEFAULT NULL,
  `ck43_c` tinyint(1) DEFAULT NULL,
  `ck43_orther` tinyint(1) DEFAULT NULL,
  `ck43orther` tinyint(1) DEFAULT NULL,
  `txt43or` tinyint(1) DEFAULT NULL,
  `code43_orther` varchar(100) DEFAULT NULL,
  `add43_orther` varchar(100) DEFAULT NULL,
  `txt43_orther` varchar(100) DEFAULT NULL,
  `affiliation_and_name44` varchar(100) DEFAULT NULL,
  `number43` varchar(100) DEFAULT NULL,
  `txt343` varchar(100) DEFAULT NULL,
  `affiliation_and_name441` varchar(100) DEFAULT NULL,
  `ck54` tinyint(1) DEFAULT NULL,
  `txt54` varchar(100) DEFAULT NULL,
  `ck54a` tinyint(1) DEFAULT NULL,
  `txt54a` varchar(100) DEFAULT NULL,
  `y_n541` tinyint(1) DEFAULT NULL,
  `name541` varchar(100) DEFAULT NULL,
  `code541` varchar(100) DEFAULT NULL,
  `add541` varchar(100) DEFAULT NULL,
  `ck54b` tinyint(1) DEFAULT NULL,
  `txt54b` varchar(100) DEFAULT NULL,
  `ck54_b` tinyint(1) DEFAULT NULL,
  `txt54_b` varchar(100) DEFAULT NULL,
  `y_n542` tinyint(1) DEFAULT NULL,
  `name542` varchar(100) DEFAULT NULL,
  `code542` varchar(100) DEFAULT NULL,
  `add542` varchar(100) DEFAULT NULL,
  `ck54c` tinyint(1) DEFAULT NULL,
  `txt54c` varchar(100) DEFAULT NULL,
  `ck54_c` tinyint(1) DEFAULT NULL,
  `txt54_c` varchar(100) DEFAULT NULL,
  `y_n543` tinyint(1) DEFAULT NULL,
  `name543` varchar(100) DEFAULT NULL,
  `code543` varchar(100) DEFAULT NULL,
  `add543` varchar(100) DEFAULT NULL,
  `ck544` tinyint(1) DEFAULT NULL,
  `ck544a` tinyint(1) DEFAULT NULL,
  `y_n544` tinyint(1) DEFAULT NULL,
  `name544` varchar(100) DEFAULT NULL,
  `code544` varchar(100) DEFAULT NULL,
  `add544` varchar(100) DEFAULT NULL,
  `txt5444` varchar(100) DEFAULT NULL,
  `ck64a` tinyint(1) DEFAULT NULL,
  `ck64_a` tinyint(1) DEFAULT NULL,
  `y_n641` tinyint(1) DEFAULT NULL,
  `date_64a` varchar(100) DEFAULT NULL,
  `code641` varchar(100) DEFAULT NULL,
  `address641` varchar(100) DEFAULT NULL,
  `ck64_orther` tinyint(1) DEFAULT NULL,
  `ck_64orther` tinyint(1) DEFAULT NULL,
  `y_n642` tinyint(1) DEFAULT NULL,
  `code642` varchar(100) DEFAULT NULL,
  `address642` varchar(100) DEFAULT NULL,
  `n1_1` varchar(20) DEFAULT NULL,
  `n1` varchar(20) DEFAULT NULL,
  `n2_2` varchar(20) DEFAULT NULL,
  `n2` varchar(20) DEFAULT NULL,
  `n3_3` varchar(20) DEFAULT NULL,
  `n3` varchar(20) DEFAULT NULL,
  `n4_4` varchar(20) DEFAULT NULL,
  `n4` varchar(20) DEFAULT NULL,
  `n5_5` varchar(20) DEFAULT NULL,
  `n_5` varchar(20) DEFAULT NULL,
  `n6_6` varchar(20) DEFAULT NULL,
  `n_6` varchar(20) DEFAULT NULL,
  `n7_7` varchar(20) DEFAULT NULL,
  `n_7` varchar(20) DEFAULT NULL,
  `n8_8` varchar(20) DEFAULT NULL,
  `n_8` varchar(20) DEFAULT NULL,
  `ck_64d1` tinyint(1) DEFAULT NULL,
  `ck_64d2` tinyint(1) DEFAULT NULL,
  `txt64d2` varchar(20) DEFAULT NULL,
  `ck_64d3` tinyint(1) DEFAULT NULL,
  `txt64d3` varchar(20) DEFAULT NULL,
  `ck_64d4` tinyint(1) DEFAULT NULL,
  `txt64d4` varchar(20) DEFAULT NULL,
  `ck_64e1` tinyint(1) DEFAULT NULL,
  `ck_64e2` tinyint(1) DEFAULT NULL,
  `txt_64e2` varchar(20) DEFAULT NULL,
  `ck_64e3` tinyint(1) DEFAULT NULL,
  `txt_64e3` varchar(20) DEFAULT NULL,
  `ck_64e4` tinyint(1) DEFAULT NULL,
  `txt_64e4` varchar(20) DEFAULT NULL,
  `txt64e5` varchar(50) DEFAULT NULL,
  `ck64_` tinyint(1) DEFAULT NULL,
  `name641` varchar(100) DEFAULT NULL,
  `ck_74` tinyint(4) DEFAULT NULL,
  `txt_74` text DEFAULT NULL,
  `ck74` tinyint(4) DEFAULT NULL,
  `txt74` text DEFAULT NULL,
  `y_n741` tinyint(4) DEFAULT NULL,
  `name74` text DEFAULT NULL,
  `code741` text DEFAULT NULL,
  `add741` text DEFAULT NULL,
  `ck_orther74` tinyint(4) DEFAULT NULL,
  `ckorther_74` tinyint(4) DEFAULT NULL,
  `y_n742` tinyint(4) DEFAULT NULL,
  `code742` text DEFAULT NULL,
  `add742` text DEFAULT NULL,
  `done_txt` text DEFAULT NULL,
  `ck84` tinyint(4) DEFAULT NULL,
  `txt84` text DEFAULT NULL,
  `ck_84` tinyint(4) DEFAULT NULL,
  `txt_84` text DEFAULT NULL,
  `y_n841` tinyint(4) DEFAULT NULL,
  `name841` text DEFAULT NULL,
  `code841` text DEFAULT NULL,
  `add841` text DEFAULT NULL,
  `ck84_b` tinyint(4) DEFAULT NULL,
  `txt84_b` text DEFAULT NULL,
  `ck_84b` tinyint(4) DEFAULT NULL,
  `txt_84b` text DEFAULT NULL,
  `y_n842` tinyint(4) DEFAULT NULL,
  `name842` text DEFAULT NULL,
  `code842` text DEFAULT NULL,
  `add842` text DEFAULT NULL,
  `ck84_c` tinyint(4) DEFAULT NULL,
  `txt84_c` text DEFAULT NULL,
  `ck_84c` tinyint(4) DEFAULT NULL,
  `txt_84c` text DEFAULT NULL,
  `y_n843` tinyint(4) DEFAULT NULL,
  `name843` text DEFAULT NULL,
  `code843` text DEFAULT NULL,
  `add843` text DEFAULT NULL,
  `ck84_d` tinyint(4) DEFAULT NULL,
  `txt84_d` text DEFAULT NULL,
  `ck_84d` tinyint(4) DEFAULT NULL,
  `txt_84d` text DEFAULT NULL,
  `y_n844` tinyint(4) DEFAULT NULL,
  `name844` text DEFAULT NULL,
  `code844` text DEFAULT NULL,
  `add844` text DEFAULT NULL,
  `ck84_e` tinyint(4) DEFAULT NULL,
  `txt84_e` text DEFAULT NULL,
  `ck_84e` tinyint(4) DEFAULT NULL,
  `txt_84e` text DEFAULT NULL,
  `ck84f` tinyint(1) DEFAULT NULL,
  `txt84f` varchar(50) DEFAULT NULL,
  `ck841f` tinyint(1) DEFAULT NULL,
  `ck84g` tinyint(1) DEFAULT NULL,
  `txt84g` varchar(100) DEFAULT NULL,
  `ck841g` tinyint(1) DEFAULT NULL,
  `txt841g` varchar(50) DEFAULT NULL,
  `y_n84g` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_support_plan_reference`
--

INSERT INTO `et_doc_support_plan_reference` VALUES
(1,NULL,NULL,151,NULL,1,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,NULL,NULL,151,NULL,2,21,'農園 太郎','AAA','男',NULL,'ベトナム','おおの','武村株式会社','124-144','千葉','040-855','24545','千葉','0146215','おおの','AAAAA','社長','2','1',1,'679548','2004-03-25','2025-03-25','ＴＮＡＫ','田中','123-458','千葉','058553','あああああ','AAAAA','11244','GIFU','ぶぶぶ','BBBBB','しゃちょう','３','３',1,'2000-03-26','1994-12-02',2,'あああああ','1111','千葉',1,NULL,1,1,NULL,'実施予定',NULL,'あｈｆｋｌｋ',NULL,1,2,'THUY','３',1,'aaaaa',NULL,NULL,2,NULL,'11111','ABC',1,NULL,1,'NARITA',1,NULL,NULL,NULL,NULL,'1111','ACCVC',1,'HANOI',NULL,NULL,NULL,1,2,NULL,'q1111','ABC',NULL,'インドネシア語','045-789',1,'ｓｄｇｈｈ',NULL,NULL,NULL,'TIEP','1111','CHIBA',1,NULL,NULL,NULL,NULL,'TIEP','1111','ｇｈｊｈｊｋｊｋ',NULL,NULL,NULL,NULL,NULL,'TIEP　あああああああああああああああああああああああああああああああああああ','1111','AAAAA',NULL,1,2,'ああ','1111','ｄｆｊｈｊｊｋ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ｓｈｈｈ',NULL,NULL,NULL,'TIEP','1111','CHIBA',1,NULL,NULL,NULL,NULL,1,'あああああâ',NULL,'TIEP','１１１１','CHIBA',NULL,NULL,NULL,NULL,1,NULL,NULL,'あああああ',NULL,'TIEP','1111','CHIBA',NULL,NULL,NULL,NULL,NULL,1,2,'TIEP','1111','CHIBA',NULL,1,'あああ',NULL,NULL,'2','１１１１１','あああ',1,NULL,1,NULL,2,'１１１１１','AAAAA','あああああ','日本語','３',NULL,'あああああ',1,'あああああ',NULL,'ｖｖｖ',1,'あああああ','115','ああああああ',1,'ｖｖｖ',NULL,'ｖｖｖ',1,'vvvv','115','ああああ',1,'ｃｃｖｃｖ',NULL,'ｖｖｖ',1,'vvvv','115','ああああ',1,NULL,1,'vvvv','115','ああああ','１１１１１',NULL,NULL,NULL,NULL,'１１１１１',NULL,NULL,NULL,NULL,'１１１１１',NULL,'12h30','17h30','12h30','17h30','12h30','17h30','12h30','17h30','12h30','17h30','12h30','123','12h30','17h30','12h30','17h30',1,1,'04588',NULL,'あああ」',NULL,'あああ',1,1,NULL,1,NULL,1,NULL,'VIETNAM',0,NULL,1,'aaa',NULL,NULL,NULL,'aa','111','ee',1,NULL,1,'1111','eeeeeee',NULL,1,NULL,NULL,'aa',1,'aaa','１１１１１','eeeeee1111e',1,'aaa',NULL,NULL,2,'aaa','1111','eeeeeee',1,NULL,1,NULL,NULL,'eeeeeee','1111','eeeeeee',1,NULL,NULL,NULL,NULL,'eeeeeee','1111','eeeeeee',1,NULL,1,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL),
(3,NULL,NULL,151,NULL,2,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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(4,NULL,NULL,151,NULL,2,13,'入江省吾','０','男',NULL,'ベトナム','takemuyra','武村','123-452','千葉県稲毛','040-855-4777','333－0831','千葉aaaaaaaaaa','0146215','おおの','大野','代表取締役','2','1',1,'679548','2021-04-15','2025-04-15','ＴＮＡＫ','田中','123-458','千葉','058553','あおやま','青山','11244','岐阜県','takaka','孝雄','しゃちょう','３','１',1,'2025-04-16','2025-04-02',2,'NGUYEN VAN A','1111','千葉',NULL,1,NULL,1,NULL,'実施予定',NULL,NULL,NULL,1,1,'THUY','３',1,'aaaaa',NULL,NULL,1,'Thuy','11111','ABC',1,NULL,1,'NARITA',1,NULL,NULL,1,NULL,'1111','ACCVC',NULL,'HANOI',1,'未定',1,NULL,NULL,NULL,'1111','ABC',NULL,'インドネシア','045-789-4586',1,'ｓｄｇｈｈ',NULL,NULL,2,'TIEP','1111','CHIBA',1,NULL,NULL,NULL,2,NULL,'1111','ｇｈｊｈｊｋｊｋ',1,NULL,NULL,NULL,1,'TIEP','1111','AAAAA',1,NULL,NULL,NULL,'1111','ｄｆｊｈｊｊｋ',NULL,1,NULL,'3',NULL,NULL,1,'ｓｈｈｈ',NULL,NULL,2,'TIEP','１１１１','AAAAA',NULL,NULL,1,1,NULL,NULL,NULL,2,'TIEP','１１１１','AAAAA',1,NULL,1,'aaaaaaaaaaa',1,NULL,NULL,NULL,2,'TIEP','1111','AAAAA',NULL,NULL,1,'電話',1,NULL,1,'THAI','1111','あああ','あああ',1,NULL,NULL,NULL,'2','１１１１１','wwwwwwwwwwwwwwwwww',NULL,NULL,1,NULL,2,'１１１１１','áああああ','AAAAA','日本語','５','aaaaa','あああああ',1,'AAAAA',NULL,NULL,2,'THAI','11','AAAAA',1,'あああああああああああああ',NULL,NULL,2,'THAI','111111','千葉県',1,'あああああ',NULL,NULL,2,'THAI','111111','千葉県',NULL,1,2,'THAI','111111','千葉県',NULL,NULL,1,1,'AAAAA','111111','千葉県',NULL,1,2,'111111','千葉県','9','18','9','18','9','18','9','18','9','18','9','18','9','18',NULL,'18',1,NULL,'456',NULL,'@',NULL,NULL,1,NULL,'456',NULL,'@',NULL,'aa','INDO',NULL,'THAI',1,'aaaa',NULL,NULL,2,'Tie','1111','hanoi',1,NULL,1,'1111','hanoi',NULL,1,'aa',NULL,NULL,1,'Tiep','111','chi ba',1,'aa',NULL,NULL,NULL,'Tiep','111','chi ba',1,'aa',NULL,NULL,NULL,'Tiep','111','chi ba',1,'aaa',NULL,NULL,NULL,'TIEP','111','chi ba',1,'aaa',NULL,NULL,NULL,NULL,1,1,NULL,1,NULL,2),
(5,NULL,NULL,1,NULL,1,1,'農園 太郎','０','男',NULL,'ベトナム','おおの','武村株式会社','124-144','千葉県稲毛','040-855','24545','千葉','0146215','おおの','AAAAA','社長','2','1',1,'679548','2020-05-10','2025-06-17','ＴＮＡＫ','田中','123-458','千葉','058553','あああああ','AAAAA','11244','GIFU','ぶぶぶ','BBBBB','しゃちょう','３','３',1,'1990-06-17','2025-06-17',2,'あああああ','1111','千葉',1,1,NULL,1,NULL,NULL,NULL,NULL,1,NULL,1,'日本語','３',1,NULL,NULL,NULL,2,'NGUYEN VAN A','11111','ABC',1,'NARITA',1,'NARITA',1,NULL,NULL,2,'NGUYEN VAN A',NULL,NULL,1,'HANOI',1,'AAAAAAAA',NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,'インドネシア語','045-789',NULL,NULL,NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'NGUYEN VAN A',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_support_plan_reference_2`
--

CREATE TABLE `et_doc_support_plan_reference_2` (
  `id_support_plan_reference` bigint(20) DEFAULT NULL,
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name84g` varchar(50) DEFAULT NULL,
  `code84g` varchar(50) DEFAULT NULL,
  `add84g` varchar(50) DEFAULT NULL,
  `ck84gorther` tinyint(1) DEFAULT NULL,
  `ck841gorther` tinyint(1) DEFAULT NULL,
  `y_n84o` tinyint(1) DEFAULT NULL,
  `name84o` varchar(50) DEFAULT NULL,
  `code84o` varchar(50) DEFAULT NULL,
  `add84o` varchar(50) DEFAULT NULL,
  `ck94ab` tinyint(1) DEFAULT NULL,
  `txt94ab` varchar(50) DEFAULT NULL,
  `ck941ab` tinyint(1) DEFAULT NULL,
  `txt941ab` varchar(50) DEFAULT NULL,
  `y_n94ab` tinyint(1) DEFAULT NULL,
  `name941ab` varchar(50) DEFAULT NULL,
  `address941ab` varchar(50) DEFAULT NULL,
  `face94` tinyint(1) DEFAULT NULL,
  `radio94` tinyint(1) DEFAULT NULL,
  `ck94cdo` tinyint(1) DEFAULT NULL,
  `ck941cdo` tinyint(1) DEFAULT NULL,
  `y_n94cdo` tinyint(1) DEFAULT NULL,
  `code94cdo` varchar(50) DEFAULT NULL,
  `add94cdo` varchar(50) DEFAULT NULL,
  `implementation94` varchar(50) DEFAULT NULL,
  `implementation941` varchar(50) DEFAULT NULL,
  `txt841f` varchar(100) DEFAULT NULL,
  `y_n84f` tinyint(1) DEFAULT NULL,
  `name742` varchar(200) DEFAULT NULL,
  `txt64e51` varchar(200) DEFAULT NULL,
  `ck94cd` tinyint(1) DEFAULT NULL,
  `ck941cd` tinyint(1) DEFAULT NULL,
  `txt941cd` varchar(200) DEFAULT NULL,
  `code941ab` varchar(100) DEFAULT NULL,
  `name84f` varchar(200) DEFAULT NULL,
  `code84f` varchar(200) DEFAULT NULL,
  `add84f` varchar(200) DEFAULT NULL,
  `name_specific` varchar(200) NOT NULL,
  `name_person_responsible` varchar(200) DEFAULT NULL,
  `document` varchar(200) DEFAULT NULL,
  `signature` varchar(200) DEFAULT NULL,
  `datesig` date DEFAULT NULL,
  `name941cdo` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_support_plan_reference_2`
--

INSERT INTO `et_doc_support_plan_reference_2` VALUES
(2,2,NULL,'１１１１１',NULL,1,NULL,NULL,NULL,'１１１１１',NULL,1,NULL,NULL,NULL,1,NULL,NULL,1,NULL,1,NULL,1,'１１１１１','aaaaaa',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(3,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL),
(4,4,'TIEP','111','chi ba',1,NULL,2,'TIEP','111','chi ba',1,'22222',NULL,NULL,2,'thuyyy','AAAAA',1,NULL,1,NULL,2,'1111','AAAAAA','INDONESIA','ああああああ',NULL,1,NULL,'THUy CHIBA',NULL,1,'AAAAAAAAAA','1111','TIEP','111','uuuuuuuuuuuuuuuu','BBBBBBBBBBBBBB','CCCCCCCCCCCCCCC','DDDDDDDĐ','田中','2025-04-16','thuyyy');

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

CREATE TABLE `et_doc_teaching_techniques` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `staff_cv_id` int(11) NOT NULL,
  `job_content` varchar(255) DEFAULT NULL,
  `year_experience` int(11) DEFAULT NULL,
  `fulltime` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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_terms_of_employment`
--

CREATE TABLE `et_doc_terms_of_employment` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `year` varchar(10) DEFAULT NULL,
  `month` varchar(10) DEFAULT NULL,
  `day` varchar(10) DEFAULT NULL,
  `recipient_name` varchar(200) DEFAULT NULL,
  `organization_name` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `representative_name` varchar(200) DEFAULT NULL,
  `contract_start_year` varchar(5) DEFAULT NULL,
  `contract_start_month` varchar(5) DEFAULT NULL,
  `contract_start_day` varchar(5) DEFAULT NULL,
  `contract_end_year` varchar(5) DEFAULT NULL,
  `contract_end_month` varchar(5) DEFAULT NULL,
  `contract_end_day` varchar(5) DEFAULT NULL,
  `entry_year` varchar(5) DEFAULT NULL,
  `entry_month` varchar(5) DEFAULT NULL,
  `entry_day` varchar(5) DEFAULT NULL,
  `update_auto` tinyint(1) DEFAULT NULL,
  `update_possible` tinyint(1) DEFAULT NULL,
  `no_update` tinyint(1) DEFAULT NULL,
  `workload_criteria` tinyint(1) DEFAULT NULL,
  `performance_criteria` tinyint(1) DEFAULT NULL,
  `ability_criteria` tinyint(1) DEFAULT NULL,
  `company_status` tinyint(1) DEFAULT NULL,
  `work_progress` tinyint(1) DEFAULT NULL,
  `other_criteria` tinyint(1) DEFAULT NULL,
  `permanent_contract_year` varchar(5) DEFAULT NULL,
  `permanent_contract_month` varchar(5) DEFAULT NULL,
  `permanent_contract_day` varchar(5) DEFAULT NULL,
  `direct_employment` tinyint(1) DEFAULT NULL,
  `direct_office_name` varchar(200) DEFAULT NULL,
  `direct_office_address` varchar(200) DEFAULT NULL,
  `direct_office_contact` varchar(200) DEFAULT NULL,
  `dispatch_employment` tinyint(1) DEFAULT NULL,
  `no_change_possible` tinyint(1) DEFAULT NULL,
  `dispatch_office_name` varchar(200) DEFAULT NULL,
  `dispatch_office_address` varchar(200) DEFAULT NULL,
  `dispatch_office_contact` varchar(200) DEFAULT NULL,
  `field` varchar(100) DEFAULT NULL,
  `work_category` varchar(100) DEFAULT NULL,
  `no_change_possibility` tinyint(1) DEFAULT NULL,
  `change_field` varchar(100) DEFAULT NULL,
  `change_work_category` varchar(100) DEFAULT NULL,
  `start_hour` varchar(10) DEFAULT NULL,
  `start_minute` varchar(10) DEFAULT NULL,
  `end_hour` varchar(10) DEFAULT NULL,
  `end_minute` varchar(10) DEFAULT NULL,
  `working_hours` varchar(10) DEFAULT NULL,
  `working_minutes` varchar(10) DEFAULT NULL,
  `irregular_work_hours` tinyint(1) DEFAULT NULL,
  `unit_work_hours` tinyint(1) DEFAULT NULL,
  `shift_work` tinyint(1) DEFAULT NULL,
  `shift_start_hour` varchar(10) DEFAULT NULL,
  `shift_start_minute` varchar(10) DEFAULT NULL,
  `shift_end_hour` varchar(10) DEFAULT NULL,
  `shift_end_minute` varchar(10) DEFAULT NULL,
  `shift_apply_date` varchar(10) DEFAULT NULL,
  `shift_working_hours` varchar(10) DEFAULT NULL,
  `shift_working_minutes` varchar(10) DEFAULT NULL,
  `shift2_start_hour` varchar(10) DEFAULT NULL,
  `shift2_start_minute` varchar(10) DEFAULT NULL,
  `shift2_end_hour` varchar(10) DEFAULT NULL,
  `shift2_end_minute` varchar(10) DEFAULT NULL,
  `shift2_apply_date` varchar(10) DEFAULT NULL,
  `shift2_working_hours` varchar(10) DEFAULT NULL,
  `shift2_working_minutes` varchar(10) DEFAULT NULL,
  `shift3_start_hour` varchar(10) DEFAULT NULL,
  `shift3_start_minute` varchar(10) DEFAULT NULL,
  `shift3_end_hour` varchar(10) DEFAULT NULL,
  `shift3_end_minute` varchar(10) DEFAULT NULL,
  `shift3_apply_date` varchar(10) DEFAULT NULL,
  `shift3_working_hours` varchar(10) DEFAULT NULL,
  `shift3_working_minutes` varchar(10) DEFAULT NULL,
  `break_time` varchar(10) DEFAULT NULL,
  `break_hours` varchar(10) DEFAULT NULL,
  `break_minutes` varchar(10) DEFAULT NULL,
  `working_days` varchar(10) DEFAULT NULL,
  `working_days_per_week` varchar(10) DEFAULT NULL,
  `working_days_per_year` varchar(10) DEFAULT NULL,
  `prescribed_working_days` varchar(10) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `other_criteria_detail` varchar(100) DEFAULT NULL,
  `irregular_work_hours_detail` varchar(100) DEFAULT NULL,
  `prescribed_working_days_4_1` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_2` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_3` varchar(50) DEFAULT NULL,
  `overtime_available` tinyint(1) DEFAULT NULL,
  `prescribed_working_days_5_1` varchar(100) DEFAULT NULL,
  `regular_holiday_other` varchar(100) DEFAULT NULL,
  `total_holidays` varchar(100) DEFAULT NULL,
  `irregular_holiday_count` varchar(100) DEFAULT NULL,
  `irregular_holiday_other` varchar(100) DEFAULT NULL,
  `paid_leave_days` varchar(100) DEFAULT NULL,
  `paid_leave` tinyint(1) DEFAULT NULL,
  `months_before_leave` varchar(100) DEFAULT NULL,
  `days_of_leave` varchar(100) DEFAULT NULL,
  `other_leave` tinyint(1) DEFAULT NULL,
  `monthly_salary` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount` varchar(100) DEFAULT NULL,
  `daily_salary` tinyint(1) DEFAULT NULL,
  `daily_salary_amount` varchar(100) DEFAULT NULL,
  `hourly_salary` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount` varchar(100) DEFAULT NULL,
  `allowance_1` varchar(100) DEFAULT NULL,
  `allowance_2` varchar(100) DEFAULT NULL,
  `allowance_3` varchar(100) DEFAULT NULL,
  `overtime_rate_within_60` varchar(100) DEFAULT NULL,
  `overtime_rate_over_60` varchar(100) DEFAULT NULL,
  `prescribed_overtime_rate` varchar(100) DEFAULT NULL,
  `statutory_holiday_rate` varchar(100) DEFAULT NULL,
  `non_statutory_holiday_rate` varchar(100) DEFAULT NULL,
  `night_shift_rate` varchar(100) DEFAULT NULL,
  `monthly_checkbox` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_2` tinyint(1) DEFAULT NULL,
  `salary_closing_day` varchar(100) DEFAULT NULL,
  `salary_closing_day_2` varchar(100) DEFAULT NULL,
  `monthly_checkbox_3` tinyint(1) DEFAULT NULL,
  `salary_payment_day` int(100) DEFAULT NULL,
  `monthly_checkbox_4` int(1) DEFAULT NULL,
  `salary_payment_day_2` int(100) DEFAULT NULL,
  `monthly_checkbox_6` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_5` tinyint(1) DEFAULT NULL,
  `has_something` tinyint(1) DEFAULT NULL,
  `has_salary_increase` tinyint(1) DEFAULT NULL,
  `salary_increase_detail` varchar(100) DEFAULT NULL,
  `no_salary_increase` tinyint(1) DEFAULT NULL,
  `has_bonus` tinyint(1) DEFAULT NULL,
  `bonus_detail` varchar(100) DEFAULT NULL,
  `no_bonus` tinyint(1) DEFAULT NULL,
  `has_retirement` tinyint(1) DEFAULT NULL,
  `retirement_detail` varchar(100) DEFAULT NULL,
  `no_retirement` tinyint(1) DEFAULT NULL,
  `has_leave_allowance` tinyint(1) DEFAULT NULL,
  `leave_allowance_rate` varchar(100) DEFAULT NULL,
  `resignation_notice_days` varchar(200) DEFAULT NULL,
  `other_insurance_detail` varchar(200) DEFAULT NULL,
  `welfare_pension` tinyint(1) DEFAULT NULL,
  `health_insurance` tinyint(1) DEFAULT NULL,
  `employment_insurance` tinyint(1) DEFAULT NULL,
  `workers_compensation` tinyint(1) DEFAULT NULL,
  `national_pension` tinyint(1) DEFAULT NULL,
  `national_health` tinyint(1) DEFAULT NULL,
  `other_insurance` tinyint(1) DEFAULT NULL,
  `initial_checkup_year` varchar(50) DEFAULT NULL,
  `initial_checkup_month` varchar(50) DEFAULT NULL,
  `first_checkup_year` varchar(100) DEFAULT NULL,
  `first_checkup_month` varchar(100) DEFAULT NULL,
  `checkup_interval` varchar(100) DEFAULT NULL,
  `department_name` varchar(200) DEFAULT NULL,
  `manager_name` varchar(200) DEFAULT NULL,
  `contact_info` varchar(200) DEFAULT NULL,
  `rules_location` varchar(255) DEFAULT NULL,
  `recipient_signature` varchar(255) DEFAULT NULL,
  `monthly_salary1` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount1` varchar(100) DEFAULT NULL,
  `daily_salary1` tinyint(1) DEFAULT NULL,
  `daily_salary_amount1` varchar(100) DEFAULT NULL,
  `hourly_salary1` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount1` varchar(100) DEFAULT NULL,
  `hourly_rate` varchar(100) DEFAULT NULL,
  `monthly_rate` varchar(100) DEFAULT NULL,
  `allowance_a_name1` varchar(100) DEFAULT NULL,
  `allowance_a_amount` varchar(100) DEFAULT NULL,
  `allowance_a_calc` varchar(100) DEFAULT NULL,
  `allowance_b_name` varchar(100) DEFAULT NULL,
  `allowance_b_amount` varchar(100) DEFAULT NULL,
  `allowance_b_calc` varchar(100) DEFAULT NULL,
  `allowance_c_name` varchar(100) DEFAULT NULL,
  `allowance_c_amount` varchar(100) DEFAULT NULL,
  `allowance_c_calc` varchar(100) DEFAULT NULL,
  `allowance_d_name` varchar(100) DEFAULT NULL,
  `allowance_d_amount` varchar(100) DEFAULT NULL,
  `allowance_d_calc` varchar(100) DEFAULT NULL,
  `fixed_overtime_name` varchar(100) DEFAULT NULL,
  `fixed_overtime_amount` varchar(100) DEFAULT NULL,
  `overtime_hours` varchar(100) DEFAULT NULL,
  `total_payment` varchar(100) DEFAULT NULL,
  `tax_amount` varchar(100) DEFAULT NULL,
  `social_insurance` varchar(100) DEFAULT NULL,
  `employment_insurance1` varchar(100) DEFAULT NULL,
  `food_expense` varchar(100) DEFAULT NULL,
  `housing_expense` varchar(100) DEFAULT NULL,
  `utility_expense` varchar(100) DEFAULT NULL,
  `other_deduction_1_name` varchar(100) DEFAULT NULL,
  `other_deduction_1_amount` varchar(100) DEFAULT NULL,
  `other_deduction_2_name` varchar(100) DEFAULT NULL,
  `other_deduction_2_amount` varchar(100) DEFAULT NULL,
  `other_deduction_3_name` varchar(100) DEFAULT NULL,
  `other_deduction_3_amount` varchar(100) DEFAULT NULL,
  `other_deduction_4_name` varchar(100) DEFAULT NULL,
  `other_deduction_4_amount` varchar(100) DEFAULT NULL,
  `other_deduction_5_name` varchar(100) DEFAULT NULL,
  `other_deduction_5_amount` varchar(100) DEFAULT NULL,
  `total_deduction` varchar(100) DEFAULT NULL,
  `net_payment` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_terms_of_employment`
--

INSERT INTO `et_doc_terms_of_employment` VALUES
(1,NULL,NULL,'2025-05-13 04:16:22',1,'2025-05-13 04:16:22',1,'2025','12','20','Aaaa','ABC会社','千葉県柏市あけぼの5-4-35-102','0567-52-2736','tanakaa','2025','10','11','2026','10','10','2025','10','10',1,1,1,1,1,1,1,1,1,'2025','5','5',1,'ABC会社','ABC会社','ABC会社',1,1,'合同会','合同会','合同会','建設','土木',1,'外食','接客','8','00','17','00','8','00',1,NULL,1,'８','00','17','00','3','8','12','7','30','17','30','3','12','12','12','12','12','12',NULL,'12','12','60','12','60','3','3','120','12',59,'sdgnsdjgn','sgnsldgnsd','12','12','12',1,'23đ','12ccc','1cs','213','ádasd','df12',2,'21sf','123sdf',2,1,'123',1,'123',1,'123','dskfn123','dsn13','sdgkn23','123','123','123','123','123','123',1,1,'20','20',1,15,1,12,1,NULL,2,1,'dsfs',NULL,NULL,'sdfs',1,NULL,'df',1,1,'sdf','dfdsfsd','dsfsdf',1,1,1,1,1,1,1,'df','df','sdf','sdf','sdf','sd','sdf','sdf','sdf','sdf',1,'50000',1,'dsf',1,'dsf',NULL,NULL,NULL,'2000','sdf','sdf','3000','sdf','sdf','sdf','sdf','sdf','sdf','sdf','fsdf','sdfsdf','sdf','sdf','sdf','sdf','dsf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf',NULL);

--
-- Table structure for table `et_doc_terms_of_employment2`
--

CREATE TABLE `et_doc_terms_of_employment2` (
  `id_terms_of_employment_vn` bigint(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_terms_of_employment2`
--

INSERT INTO `et_doc_terms_of_employment2` VALUES
(1);

--
-- Table structure for table `et_doc_terms_of_employment_indo`
--

CREATE TABLE `et_doc_terms_of_employment_indo` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `year` varchar(10) DEFAULT NULL,
  `month` varchar(10) DEFAULT NULL,
  `day` varchar(10) DEFAULT NULL,
  `recipient_name` varchar(200) DEFAULT NULL,
  `organization_name` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `representative_name` varchar(200) DEFAULT NULL,
  `contract_start_year` varchar(5) DEFAULT NULL,
  `contract_start_month` varchar(5) DEFAULT NULL,
  `contract_start_day` varchar(5) DEFAULT NULL,
  `contract_end_year` varchar(5) DEFAULT NULL,
  `contract_end_month` varchar(5) DEFAULT NULL,
  `contract_end_day` varchar(5) DEFAULT NULL,
  `entry_year` varchar(5) DEFAULT NULL,
  `entry_month` varchar(5) DEFAULT NULL,
  `entry_day` varchar(5) DEFAULT NULL,
  `update_auto` tinyint(1) DEFAULT NULL,
  `update_possible` tinyint(1) DEFAULT NULL,
  `no_update` tinyint(1) DEFAULT NULL,
  `workload_criteria` tinyint(1) DEFAULT NULL,
  `performance_criteria` tinyint(1) DEFAULT NULL,
  `ability_criteria` tinyint(1) DEFAULT NULL,
  `company_status` tinyint(1) DEFAULT NULL,
  `work_progress` tinyint(1) DEFAULT NULL,
  `other_criteria` tinyint(1) DEFAULT NULL,
  `permanent_contract_year` varchar(5) DEFAULT NULL,
  `permanent_contract_month` varchar(5) DEFAULT NULL,
  `permanent_contract_day` varchar(5) DEFAULT NULL,
  `direct_employment` tinyint(1) DEFAULT NULL,
  `direct_office_name` varchar(200) DEFAULT NULL,
  `direct_office_address` varchar(200) DEFAULT NULL,
  `direct_office_contact` varchar(200) DEFAULT NULL,
  `dispatch_employment` tinyint(1) DEFAULT NULL,
  `no_change_possible` tinyint(1) DEFAULT NULL,
  `dispatch_office_name` varchar(200) DEFAULT NULL,
  `dispatch_office_address` varchar(200) DEFAULT NULL,
  `dispatch_office_contact` varchar(200) DEFAULT NULL,
  `field` varchar(100) DEFAULT NULL,
  `work_category` varchar(100) DEFAULT NULL,
  `no_change_possibility` tinyint(1) DEFAULT NULL,
  `change_field` varchar(100) DEFAULT NULL,
  `change_work_category` varchar(100) DEFAULT NULL,
  `start_hour` varchar(10) DEFAULT NULL,
  `start_minute` varchar(10) DEFAULT NULL,
  `end_hour` varchar(10) DEFAULT NULL,
  `end_minute` varchar(10) DEFAULT NULL,
  `working_hours` varchar(10) DEFAULT NULL,
  `working_minutes` varchar(10) DEFAULT NULL,
  `irregular_work_hours` tinyint(1) DEFAULT NULL,
  `unit_work_hours` tinyint(1) DEFAULT NULL,
  `shift_work` tinyint(1) DEFAULT NULL,
  `shift_start_hour` varchar(10) DEFAULT NULL,
  `shift_start_minute` varchar(10) DEFAULT NULL,
  `shift_end_hour` varchar(10) DEFAULT NULL,
  `shift_end_minute` varchar(10) DEFAULT NULL,
  `shift_apply_date` varchar(10) DEFAULT NULL,
  `shift_working_hours` varchar(10) DEFAULT NULL,
  `shift_working_minutes` varchar(10) DEFAULT NULL,
  `shift2_start_hour` varchar(10) DEFAULT NULL,
  `shift2_start_minute` varchar(10) DEFAULT NULL,
  `shift2_end_hour` varchar(10) DEFAULT NULL,
  `shift2_end_minute` varchar(10) DEFAULT NULL,
  `shift2_apply_date` varchar(10) DEFAULT NULL,
  `shift2_working_hours` varchar(10) DEFAULT NULL,
  `shift2_working_minutes` varchar(10) DEFAULT NULL,
  `shift3_start_hour` varchar(10) DEFAULT NULL,
  `shift3_start_minute` varchar(10) DEFAULT NULL,
  `shift3_end_hour` varchar(10) DEFAULT NULL,
  `shift3_end_minute` varchar(10) DEFAULT NULL,
  `shift3_apply_date` varchar(10) DEFAULT NULL,
  `shift3_working_hours` varchar(10) DEFAULT NULL,
  `shift3_working_minutes` varchar(10) DEFAULT NULL,
  `break_time` varchar(10) DEFAULT NULL,
  `break_hours` varchar(10) DEFAULT NULL,
  `break_minutes` varchar(10) DEFAULT NULL,
  `working_days` varchar(10) DEFAULT NULL,
  `working_days_per_week` varchar(10) DEFAULT NULL,
  `working_days_per_year` varchar(10) DEFAULT NULL,
  `prescribed_working_days` varchar(10) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `other_criteria_detail` varchar(100) DEFAULT NULL,
  `irregular_work_hours_detail` varchar(100) DEFAULT NULL,
  `prescribed_working_days_4_1` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_2` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_3` varchar(50) DEFAULT NULL,
  `overtime_available` tinyint(1) DEFAULT NULL,
  `prescribed_working_days_5_1` varchar(100) DEFAULT NULL,
  `regular_holiday_other` varchar(100) DEFAULT NULL,
  `total_holidays` varchar(100) DEFAULT NULL,
  `irregular_holiday_count` varchar(100) DEFAULT NULL,
  `irregular_holiday_other` varchar(100) DEFAULT NULL,
  `paid_leave_days` varchar(100) DEFAULT NULL,
  `paid_leave` tinyint(1) DEFAULT NULL,
  `months_before_leave` varchar(100) DEFAULT NULL,
  `days_of_leave` varchar(100) DEFAULT NULL,
  `other_leave` tinyint(1) DEFAULT NULL,
  `monthly_salary` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount` varchar(100) DEFAULT NULL,
  `daily_salary` tinyint(1) DEFAULT NULL,
  `daily_salary_amount` varchar(100) DEFAULT NULL,
  `hourly_salary` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount` varchar(100) DEFAULT NULL,
  `allowance_1` varchar(100) DEFAULT NULL,
  `allowance_2` varchar(100) DEFAULT NULL,
  `allowance_3` varchar(100) DEFAULT NULL,
  `overtime_rate_within_60` varchar(100) DEFAULT NULL,
  `overtime_rate_over_60` varchar(100) DEFAULT NULL,
  `prescribed_overtime_rate` varchar(100) DEFAULT NULL,
  `statutory_holiday_rate` varchar(100) DEFAULT NULL,
  `non_statutory_holiday_rate` varchar(100) DEFAULT NULL,
  `night_shift_rate` varchar(100) DEFAULT NULL,
  `monthly_checkbox` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_2` tinyint(1) DEFAULT NULL,
  `salary_closing_day` varchar(100) DEFAULT NULL,
  `salary_closing_day_2` varchar(100) DEFAULT NULL,
  `monthly_checkbox_3` tinyint(1) DEFAULT NULL,
  `salary_payment_day` int(100) DEFAULT NULL,
  `monthly_checkbox_4` int(1) DEFAULT NULL,
  `salary_payment_day_2` int(100) DEFAULT NULL,
  `monthly_checkbox_6` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_5` tinyint(1) DEFAULT NULL,
  `has_something` tinyint(1) DEFAULT NULL,
  `has_salary_increase` tinyint(1) DEFAULT NULL,
  `salary_increase_detail` varchar(100) DEFAULT NULL,
  `no_salary_increase` tinyint(1) DEFAULT NULL,
  `has_bonus` tinyint(1) DEFAULT NULL,
  `bonus_detail` varchar(100) DEFAULT NULL,
  `no_bonus` tinyint(1) DEFAULT NULL,
  `has_retirement` tinyint(1) DEFAULT NULL,
  `retirement_detail` varchar(100) DEFAULT NULL,
  `no_retirement` tinyint(1) DEFAULT NULL,
  `has_leave_allowance` tinyint(1) DEFAULT NULL,
  `leave_allowance_rate` varchar(100) DEFAULT NULL,
  `resignation_notice_days` varchar(200) DEFAULT NULL,
  `other_insurance_detail` varchar(200) DEFAULT NULL,
  `welfare_pension` tinyint(1) DEFAULT NULL,
  `health_insurance` tinyint(1) DEFAULT NULL,
  `employment_insurance` tinyint(1) DEFAULT NULL,
  `workers_compensation` tinyint(1) DEFAULT NULL,
  `national_pension` tinyint(1) DEFAULT NULL,
  `national_health` tinyint(1) DEFAULT NULL,
  `other_insurance` tinyint(1) DEFAULT NULL,
  `initial_checkup_year` varchar(50) DEFAULT NULL,
  `initial_checkup_month` varchar(50) DEFAULT NULL,
  `first_checkup_year` varchar(100) DEFAULT NULL,
  `first_checkup_month` varchar(100) DEFAULT NULL,
  `checkup_interval` varchar(100) DEFAULT NULL,
  `department_name` varchar(200) DEFAULT NULL,
  `manager_name` varchar(200) DEFAULT NULL,
  `contact_info` varchar(200) DEFAULT NULL,
  `rules_location` varchar(255) DEFAULT NULL,
  `recipient_signature` varchar(255) DEFAULT NULL,
  `monthly_salary1` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount1` varchar(100) DEFAULT NULL,
  `daily_salary1` tinyint(1) DEFAULT NULL,
  `daily_salary_amount1` varchar(100) DEFAULT NULL,
  `hourly_salary1` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount1` varchar(100) DEFAULT NULL,
  `hourly_rate` varchar(100) DEFAULT NULL,
  `monthly_rate` varchar(100) DEFAULT NULL,
  `allowance_a_name1` varchar(100) DEFAULT NULL,
  `allowance_a_amount` varchar(100) DEFAULT NULL,
  `allowance_a_calc` varchar(100) DEFAULT NULL,
  `allowance_b_name` varchar(100) DEFAULT NULL,
  `allowance_b_amount` varchar(100) DEFAULT NULL,
  `allowance_b_calc` varchar(100) DEFAULT NULL,
  `allowance_c_name` varchar(100) DEFAULT NULL,
  `allowance_c_amount` varchar(100) DEFAULT NULL,
  `allowance_c_calc` varchar(100) DEFAULT NULL,
  `allowance_d_name` varchar(100) DEFAULT NULL,
  `allowance_d_amount` varchar(100) DEFAULT NULL,
  `allowance_d_calc` varchar(100) DEFAULT NULL,
  `fixed_overtime_name` varchar(100) DEFAULT NULL,
  `fixed_overtime_amount` varchar(100) DEFAULT NULL,
  `overtime_hours` varchar(100) DEFAULT NULL,
  `total_payment` varchar(100) DEFAULT NULL,
  `tax_amount` varchar(100) DEFAULT NULL,
  `social_insurance` varchar(100) DEFAULT NULL,
  `employment_insurance1` varchar(100) DEFAULT NULL,
  `food_expense` varchar(100) DEFAULT NULL,
  `housing_expense` varchar(100) DEFAULT NULL,
  `utility_expense` varchar(100) DEFAULT NULL,
  `other_deduction_1_name` varchar(100) DEFAULT NULL,
  `other_deduction_1_amount` varchar(100) DEFAULT NULL,
  `other_deduction_2_name` varchar(100) DEFAULT NULL,
  `other_deduction_2_amount` varchar(100) DEFAULT NULL,
  `other_deduction_3_name` varchar(100) DEFAULT NULL,
  `other_deduction_3_amount` varchar(100) DEFAULT NULL,
  `other_deduction_4_name` varchar(100) DEFAULT NULL,
  `other_deduction_4_amount` varchar(100) DEFAULT NULL,
  `other_deduction_5_name` varchar(100) DEFAULT NULL,
  `other_deduction_5_amount` varchar(100) DEFAULT NULL,
  `total_deduction` varchar(100) DEFAULT NULL,
  `net_payment` varchar(100) DEFAULT NULL,
  `year_vn` varchar(10) DEFAULT NULL,
  `month_vn` varchar(10) DEFAULT NULL,
  `day_vn` varchar(10) DEFAULT NULL,
  `recipient_name_vn` varchar(200) DEFAULT NULL,
  `organization_name_vn` varchar(200) DEFAULT NULL,
  `address_vn` varchar(200) DEFAULT NULL,
  `phone_vn` varchar(20) DEFAULT NULL,
  `representative_name_vn` varchar(200) DEFAULT NULL,
  `contract_start_year_vn` varchar(5) DEFAULT NULL,
  `contract_start_month_vn` varchar(5) DEFAULT NULL,
  `contract_start_day_vn` varchar(5) DEFAULT NULL,
  `contract_end_year_vn` varchar(5) DEFAULT NULL,
  `contract_end_month_vn` varchar(5) DEFAULT NULL,
  `contract_end_day_vn` varchar(5) DEFAULT NULL,
  `entry_year_vn` varchar(5) DEFAULT NULL,
  `entry_month_vn` varchar(5) DEFAULT NULL,
  `entry_day_vn` varchar(5) DEFAULT NULL,
  `update_auto_vn` tinyint(1) DEFAULT NULL,
  `update_possible_vn` tinyint(1) DEFAULT NULL,
  `no_update_vn` tinyint(1) DEFAULT NULL,
  `workload_criteria_vn` tinyint(1) DEFAULT NULL,
  `performance_criteria_vn` tinyint(1) DEFAULT NULL,
  `ability_criteria_vn` tinyint(1) DEFAULT NULL,
  `company_status_vn` tinyint(1) DEFAULT NULL,
  `work_progress_vn` tinyint(1) DEFAULT NULL,
  `other_criteria_vn` tinyint(1) DEFAULT NULL,
  `permanent_contract_year_vn` varchar(5) DEFAULT NULL,
  `permanent_contract_month_vn` varchar(5) DEFAULT NULL,
  `permanent_contract_day_vn` varchar(5) DEFAULT NULL,
  `direct_employment_vn` tinyint(1) DEFAULT NULL,
  `direct_office_name_vn` varchar(200) DEFAULT NULL,
  `direct_office_address_vn` varchar(200) DEFAULT NULL,
  `direct_office_contact_vn` varchar(200) DEFAULT NULL,
  `dispatch_employment_vn` tinyint(1) DEFAULT NULL,
  `no_change_possible_vn` tinyint(1) DEFAULT NULL,
  `dispatch_office_name_vn` varchar(200) DEFAULT NULL,
  `dispatch_office_address_vn` varchar(200) DEFAULT NULL,
  `dispatch_office_contact_vn` varchar(200) DEFAULT NULL,
  `field_vn` varchar(100) DEFAULT NULL,
  `work_category_vn` varchar(100) DEFAULT NULL,
  `no_change_possibility_vn` tinyint(1) DEFAULT NULL,
  `change_field_vn` varchar(100) DEFAULT NULL,
  `change_work_category_vn` varchar(100) DEFAULT NULL,
  `start_hour_vn` varchar(10) DEFAULT NULL,
  `start_minute_vn` varchar(10) DEFAULT NULL,
  `end_hour_vn` varchar(10) DEFAULT NULL,
  `end_minute_vn` varchar(10) DEFAULT NULL,
  `working_hours_vn` varchar(10) DEFAULT NULL,
  `working_minutes_vn` varchar(10) DEFAULT NULL,
  `irregular_work_hours_vn` tinyint(1) DEFAULT NULL,
  `unit_work_hours_vn` tinyint(1) DEFAULT NULL,
  `shift_work_vn` tinyint(1) DEFAULT NULL,
  `shift_start_hour_vn` varchar(10) DEFAULT NULL,
  `shift_start_minute_vn` varchar(10) DEFAULT NULL,
  `shift_end_hour_vn` varchar(10) DEFAULT NULL,
  `shift_end_minute_vn` varchar(10) DEFAULT NULL,
  `shift_apply_date_vn` varchar(10) DEFAULT NULL,
  `shift_working_hours_vn` varchar(10) DEFAULT NULL,
  `shift_working_minutes_vn` varchar(10) DEFAULT NULL,
  `shift2_start_hour_vn` varchar(10) DEFAULT NULL,
  `shift2_start_minute_vn` varchar(10) DEFAULT NULL,
  `shift2_end_hour_vn` varchar(10) DEFAULT NULL,
  `shift2_end_minute_vn` varchar(10) DEFAULT NULL,
  `shift2_apply_date_vn` varchar(10) DEFAULT NULL,
  `shift2_working_hours_vn` varchar(10) DEFAULT NULL,
  `shift2_working_minutes_vn` varchar(10) DEFAULT NULL,
  `shift3_start_hour_vn` varchar(10) DEFAULT NULL,
  `shift3_start_minute_vn` varchar(10) DEFAULT NULL,
  `shift3_end_hour_vn` varchar(10) DEFAULT NULL,
  `shift3_end_minute_vn` varchar(10) DEFAULT NULL,
  `shift3_apply_date_vn` varchar(10) DEFAULT NULL,
  `shift3_working_hours_vn` varchar(10) DEFAULT NULL,
  `shift3_working_minutes_vn` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_terms_of_employment_indo`
--

INSERT INTO `et_doc_terms_of_employment_indo` VALUES
(3,NULL,NULL,'2025-07-14 01:05:46',1,'2025-07-14 01:05:46',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,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_terms_of_employment_indo2`
--

CREATE TABLE `et_doc_terms_of_employment_indo2` (
  `id_terms_of_employment_indo` bigint(20) DEFAULT NULL,
  `break_time_vn` varchar(10) DEFAULT NULL,
  `break_hours_vn` varchar(10) DEFAULT NULL,
  `break_minutes_vn` varchar(10) DEFAULT NULL,
  `working_days_vn` varchar(10) DEFAULT NULL,
  `working_days_per_week_vn` varchar(10) DEFAULT NULL,
  `working_days_per_year_vn` varchar(10) DEFAULT NULL,
  `prescribed_working_days_vn` varchar(10) DEFAULT NULL,
  `updated_count_vn` bigint(20) DEFAULT NULL,
  `other_criteria_detail_vn` varchar(100) DEFAULT NULL,
  `irregular_work_hours_detail_vn` varchar(100) DEFAULT NULL,
  `prescribed_working_days_4_1_vn` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_2_vn` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_3_vn` varchar(50) DEFAULT NULL,
  `overtime_available_vn` tinyint(1) DEFAULT NULL,
  `prescribed_working_days_5_1_vn` varchar(100) DEFAULT NULL,
  `regular_holiday_other_vn` varchar(100) DEFAULT NULL,
  `total_holidays_vn` varchar(100) DEFAULT NULL,
  `irregular_holiday_count_vn` varchar(100) DEFAULT NULL,
  `irregular_holiday_other_vn` varchar(100) DEFAULT NULL,
  `paid_leave_days_vn` varchar(100) DEFAULT NULL,
  `paid_leave_vn` tinyint(1) DEFAULT NULL,
  `months_before_leave_vn` varchar(100) DEFAULT NULL,
  `days_of_leave_vn` varchar(100) DEFAULT NULL,
  `other_leave_vn` tinyint(1) DEFAULT NULL,
  `monthly_salary_vn` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount_vn` varchar(100) DEFAULT NULL,
  `daily_salary_vn` tinyint(1) DEFAULT NULL,
  `daily_salary_amount_vn` varchar(100) DEFAULT NULL,
  `hourly_salary_vn` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_1_vn` varchar(100) DEFAULT NULL,
  `allowance_2_vn` varchar(100) DEFAULT NULL,
  `allowance_3_vn` varchar(100) DEFAULT NULL,
  `overtime_rate_within_60_vn` varchar(100) DEFAULT NULL,
  `overtime_rate_over_60_vn` varchar(100) DEFAULT NULL,
  `prescribed_overtime_rate_vn` varchar(100) DEFAULT NULL,
  `statutory_holiday_rate_vn` varchar(100) DEFAULT NULL,
  `non_statutory_holiday_rate_vn` varchar(100) DEFAULT NULL,
  `night_shift_rate_vn` varchar(100) DEFAULT NULL,
  `monthly_checkbox_vn` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_2_vn` tinyint(1) DEFAULT NULL,
  `salary_closing_day_vn` varchar(100) DEFAULT NULL,
  `salary_closing_day_2_vn` varchar(100) DEFAULT NULL,
  `monthly_checkbox_3_vn` tinyint(1) DEFAULT NULL,
  `salary_payment_day_vn` int(100) DEFAULT NULL,
  `monthly_checkbox_4_vn` int(1) DEFAULT NULL,
  `salary_payment_day_2_vn` int(100) DEFAULT NULL,
  `monthly_checkbox_6_vn` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_5_vn` tinyint(1) DEFAULT NULL,
  `has_something_vn` tinyint(1) DEFAULT NULL,
  `has_salary_increase_vn` tinyint(1) DEFAULT NULL,
  `salary_increase_detail_vn` varchar(100) DEFAULT NULL,
  `no_salary_increase_vn` tinyint(1) DEFAULT NULL,
  `has_bonus_vn` tinyint(1) DEFAULT NULL,
  `bonus_detail_vn` varchar(100) DEFAULT NULL,
  `no_bonus_vn` tinyint(1) DEFAULT NULL,
  `has_retirement_vn` tinyint(1) DEFAULT NULL,
  `retirement_detail_vn` varchar(100) DEFAULT NULL,
  `no_retirement_vn` tinyint(1) DEFAULT NULL,
  `has_leave_allowance_vn` tinyint(1) DEFAULT NULL,
  `leave_allowance_rate_vn` varchar(100) DEFAULT NULL,
  `resignation_notice_days_vn` varchar(200) DEFAULT NULL,
  `other_insurance_detail_vn` varchar(200) DEFAULT NULL,
  `welfare_pension_vn` tinyint(1) DEFAULT NULL,
  `health_insurance_vn` tinyint(1) DEFAULT NULL,
  `employment_insurance_vn` tinyint(1) DEFAULT NULL,
  `workers_compensation_vn` tinyint(1) DEFAULT NULL,
  `national_pension_vn` tinyint(1) DEFAULT NULL,
  `national_health_vn` tinyint(1) DEFAULT NULL,
  `other_insurance_vn` tinyint(1) DEFAULT NULL,
  `initial_checkup_year_vn` varchar(50) DEFAULT NULL,
  `initial_checkup_month_vn` varchar(50) DEFAULT NULL,
  `first_checkup_year_vn` varchar(100) DEFAULT NULL,
  `first_checkup_month_vn` varchar(100) DEFAULT NULL,
  `checkup_interval_vn` varchar(100) DEFAULT NULL,
  `department_name_vn` varchar(200) DEFAULT NULL,
  `manager_name_vn` varchar(200) DEFAULT NULL,
  `contact_info_vn` varchar(200) DEFAULT NULL,
  `rules_location_vn` varchar(255) DEFAULT NULL,
  `recipient_signature_vn` varchar(255) DEFAULT NULL,
  `monthly_salary1_vn` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount1_vn` varchar(100) DEFAULT NULL,
  `daily_salary1_vn` tinyint(1) DEFAULT NULL,
  `daily_salary_amount1_vn` varchar(100) DEFAULT NULL,
  `hourly_salary1_vn` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount1_vn` varchar(100) DEFAULT NULL,
  `hourly_rate_vn` varchar(100) DEFAULT NULL,
  `monthly_rate_vn` varchar(100) DEFAULT NULL,
  `allowance_a_name1_vn` varchar(100) DEFAULT NULL,
  `allowance_a_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_a_calc_vn` varchar(100) DEFAULT NULL,
  `allowance_b_name_vn` varchar(100) DEFAULT NULL,
  `allowance_b_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_b_calc_vn` varchar(100) DEFAULT NULL,
  `allowance_c_name_vn` varchar(100) DEFAULT NULL,
  `allowance_c_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_c_calc_vn` varchar(100) DEFAULT NULL,
  `allowance_d_name_vn` varchar(100) DEFAULT NULL,
  `allowance_d_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_d_calc_vn` varchar(100) DEFAULT NULL,
  `fixed_overtime_name_vn` varchar(100) DEFAULT NULL,
  `fixed_overtime_amount_vn` varchar(100) DEFAULT NULL,
  `overtime_hours_vn` varchar(100) DEFAULT NULL,
  `total_payment_vn` varchar(100) DEFAULT NULL,
  `tax_amount_vn` varchar(100) DEFAULT NULL,
  `social_insurance_vn` varchar(100) DEFAULT NULL,
  `employment_insurance1_vn` varchar(100) DEFAULT NULL,
  `food_expense_vn` varchar(100) DEFAULT NULL,
  `housing_expense_vn` varchar(100) DEFAULT NULL,
  `utility_expense_vn` varchar(100) DEFAULT NULL,
  `other_deduction_1_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_1_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_2_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_2_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_3_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_3_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_4_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_4_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_5_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_5_amount_vn` varchar(100) DEFAULT NULL,
  `total_deduction_vn` varchar(100) DEFAULT NULL,
  `net_payment_vn` varchar(100) DEFAULT NULL,
  `renewal_limit` tinyint(1) DEFAULT NULL,
  `renewal_times` varchar(10) DEFAULT NULL,
  `total_period` varchar(10) DEFAULT NULL,
  `renewal_limit_vn` tinyint(1) DEFAULT NULL,
  `renewal_times_vn` varchar(10) DEFAULT NULL,
  `total_period_vn` varchar(10) DEFAULT NULL,
  `employment_condition_change` tinyint(1) DEFAULT NULL,
  `employment_condition_change_vn` tinyint(1) DEFAULT NULL,
  `permanent_contract_day_vn` varchar(10) DEFAULT NULL,
  `permanent_contract_month_vn` varchar(10) DEFAULT NULL,
  `permanent_contract_year_vn` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_terms_of_employment_indo2`
--

INSERT INTO `et_doc_terms_of_employment_indo2` VALUES
(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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,'112','12','12','12','12','12','12',NULL,'ádsdas','xfghfgh','12','12','12',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,2,'12','12',2,'12','12',1,2,'123','123','123'),
(3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `et_doc_terms_of_employment_vn`
--

CREATE TABLE `et_doc_terms_of_employment_vn` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `company_id` bigint(20) DEFAULT NULL,
  `year` varchar(10) DEFAULT NULL,
  `month` varchar(10) DEFAULT NULL,
  `day` varchar(10) DEFAULT NULL,
  `recipient_name` varchar(200) DEFAULT NULL,
  `organization_name` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL,
  `representative_name` varchar(200) DEFAULT NULL,
  `contract_start_year` varchar(5) DEFAULT NULL,
  `contract_start_month` varchar(5) DEFAULT NULL,
  `contract_start_day` varchar(5) DEFAULT NULL,
  `contract_end_year` varchar(5) DEFAULT NULL,
  `contract_end_month` varchar(5) DEFAULT NULL,
  `contract_end_day` varchar(5) DEFAULT NULL,
  `entry_year` varchar(5) DEFAULT NULL,
  `entry_month` varchar(5) DEFAULT NULL,
  `entry_day` varchar(5) DEFAULT NULL,
  `update_auto` tinyint(1) DEFAULT NULL,
  `update_possible` tinyint(1) DEFAULT NULL,
  `no_update` tinyint(1) DEFAULT NULL,
  `workload_criteria` tinyint(1) DEFAULT NULL,
  `performance_criteria` tinyint(1) DEFAULT NULL,
  `ability_criteria` tinyint(1) DEFAULT NULL,
  `company_status` tinyint(1) DEFAULT NULL,
  `work_progress` tinyint(1) DEFAULT NULL,
  `other_criteria` tinyint(1) DEFAULT NULL,
  `permanent_contract_year` varchar(5) DEFAULT NULL,
  `permanent_contract_month` varchar(5) DEFAULT NULL,
  `permanent_contract_day` varchar(5) DEFAULT NULL,
  `direct_employment` tinyint(1) DEFAULT NULL,
  `direct_office_name` varchar(200) DEFAULT NULL,
  `direct_office_address` varchar(200) DEFAULT NULL,
  `direct_office_contact` varchar(200) DEFAULT NULL,
  `dispatch_employment` tinyint(1) DEFAULT NULL,
  `no_change_possible` tinyint(1) DEFAULT NULL,
  `dispatch_office_name` varchar(200) DEFAULT NULL,
  `dispatch_office_address` varchar(200) DEFAULT NULL,
  `dispatch_office_contact` varchar(200) DEFAULT NULL,
  `field` varchar(100) DEFAULT NULL,
  `work_category` varchar(100) DEFAULT NULL,
  `no_change_possibility` tinyint(1) DEFAULT NULL,
  `change_field` varchar(100) DEFAULT NULL,
  `change_work_category` varchar(100) DEFAULT NULL,
  `start_hour` varchar(10) DEFAULT NULL,
  `start_minute` varchar(10) DEFAULT NULL,
  `end_hour` varchar(10) DEFAULT NULL,
  `end_minute` varchar(10) DEFAULT NULL,
  `working_hours` varchar(10) DEFAULT NULL,
  `working_minutes` varchar(10) DEFAULT NULL,
  `irregular_work_hours` tinyint(1) DEFAULT NULL,
  `unit_work_hours` tinyint(1) DEFAULT NULL,
  `shift_work` tinyint(1) DEFAULT NULL,
  `shift_start_hour` varchar(10) DEFAULT NULL,
  `shift_start_minute` varchar(10) DEFAULT NULL,
  `shift_end_hour` varchar(10) DEFAULT NULL,
  `shift_end_minute` varchar(10) DEFAULT NULL,
  `shift_apply_date` varchar(10) DEFAULT NULL,
  `shift_working_hours` varchar(10) DEFAULT NULL,
  `shift_working_minutes` varchar(10) DEFAULT NULL,
  `shift2_start_hour` varchar(10) DEFAULT NULL,
  `shift2_start_minute` varchar(10) DEFAULT NULL,
  `shift2_end_hour` varchar(10) DEFAULT NULL,
  `shift2_end_minute` varchar(10) DEFAULT NULL,
  `shift2_apply_date` varchar(10) DEFAULT NULL,
  `shift2_working_hours` varchar(10) DEFAULT NULL,
  `shift2_working_minutes` varchar(10) DEFAULT NULL,
  `shift3_start_hour` varchar(10) DEFAULT NULL,
  `shift3_start_minute` varchar(10) DEFAULT NULL,
  `shift3_end_hour` varchar(10) DEFAULT NULL,
  `shift3_end_minute` varchar(10) DEFAULT NULL,
  `shift3_apply_date` varchar(10) DEFAULT NULL,
  `shift3_working_hours` varchar(10) DEFAULT NULL,
  `shift3_working_minutes` varchar(10) DEFAULT NULL,
  `break_time` varchar(10) DEFAULT NULL,
  `break_hours` varchar(10) DEFAULT NULL,
  `break_minutes` varchar(10) DEFAULT NULL,
  `working_days` varchar(10) DEFAULT NULL,
  `working_days_per_week` varchar(10) DEFAULT NULL,
  `working_days_per_year` varchar(10) DEFAULT NULL,
  `prescribed_working_days` varchar(10) DEFAULT NULL,
  `updated_count` bigint(20) DEFAULT NULL,
  `other_criteria_detail` varchar(100) DEFAULT NULL,
  `irregular_work_hours_detail` varchar(100) DEFAULT NULL,
  `prescribed_working_days_4_1` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_2` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_3` varchar(50) DEFAULT NULL,
  `overtime_available` tinyint(1) DEFAULT NULL,
  `prescribed_working_days_5_1` varchar(100) DEFAULT NULL,
  `regular_holiday_other` varchar(100) DEFAULT NULL,
  `total_holidays` varchar(100) DEFAULT NULL,
  `irregular_holiday_count` varchar(100) DEFAULT NULL,
  `irregular_holiday_other` varchar(100) DEFAULT NULL,
  `paid_leave_days` varchar(100) DEFAULT NULL,
  `paid_leave` tinyint(1) DEFAULT NULL,
  `months_before_leave` varchar(100) DEFAULT NULL,
  `days_of_leave` varchar(100) DEFAULT NULL,
  `other_leave` tinyint(1) DEFAULT NULL,
  `monthly_salary` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount` varchar(100) DEFAULT NULL,
  `daily_salary` tinyint(1) DEFAULT NULL,
  `daily_salary_amount` varchar(100) DEFAULT NULL,
  `hourly_salary` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount` varchar(100) DEFAULT NULL,
  `allowance_1` varchar(100) DEFAULT NULL,
  `allowance_2` varchar(100) DEFAULT NULL,
  `allowance_3` varchar(100) DEFAULT NULL,
  `overtime_rate_within_60` varchar(100) DEFAULT NULL,
  `overtime_rate_over_60` varchar(100) DEFAULT NULL,
  `prescribed_overtime_rate` varchar(100) DEFAULT NULL,
  `statutory_holiday_rate` varchar(100) DEFAULT NULL,
  `non_statutory_holiday_rate` varchar(100) DEFAULT NULL,
  `night_shift_rate` varchar(100) DEFAULT NULL,
  `monthly_checkbox` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_2` tinyint(1) DEFAULT NULL,
  `salary_closing_day` varchar(100) DEFAULT NULL,
  `salary_closing_day_2` varchar(100) DEFAULT NULL,
  `monthly_checkbox_3` tinyint(1) DEFAULT NULL,
  `salary_payment_day` int(100) DEFAULT NULL,
  `monthly_checkbox_4` int(1) DEFAULT NULL,
  `salary_payment_day_2` int(100) DEFAULT NULL,
  `monthly_checkbox_6` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_5` tinyint(1) DEFAULT NULL,
  `has_something` tinyint(1) DEFAULT NULL,
  `has_salary_increase` tinyint(1) DEFAULT NULL,
  `salary_increase_detail` varchar(100) DEFAULT NULL,
  `no_salary_increase` tinyint(1) DEFAULT NULL,
  `has_bonus` tinyint(1) DEFAULT NULL,
  `bonus_detail` varchar(100) DEFAULT NULL,
  `no_bonus` tinyint(1) DEFAULT NULL,
  `has_retirement` tinyint(1) DEFAULT NULL,
  `retirement_detail` varchar(100) DEFAULT NULL,
  `no_retirement` tinyint(1) DEFAULT NULL,
  `has_leave_allowance` tinyint(1) DEFAULT NULL,
  `leave_allowance_rate` varchar(100) DEFAULT NULL,
  `resignation_notice_days` varchar(200) DEFAULT NULL,
  `other_insurance_detail` varchar(200) DEFAULT NULL,
  `welfare_pension` tinyint(1) DEFAULT NULL,
  `health_insurance` tinyint(1) DEFAULT NULL,
  `employment_insurance` tinyint(1) DEFAULT NULL,
  `workers_compensation` tinyint(1) DEFAULT NULL,
  `national_pension` tinyint(1) DEFAULT NULL,
  `national_health` tinyint(1) DEFAULT NULL,
  `other_insurance` tinyint(1) DEFAULT NULL,
  `initial_checkup_year` varchar(50) DEFAULT NULL,
  `initial_checkup_month` varchar(50) DEFAULT NULL,
  `first_checkup_year` varchar(100) DEFAULT NULL,
  `first_checkup_month` varchar(100) DEFAULT NULL,
  `checkup_interval` varchar(100) DEFAULT NULL,
  `department_name` varchar(200) DEFAULT NULL,
  `manager_name` varchar(200) DEFAULT NULL,
  `contact_info` varchar(200) DEFAULT NULL,
  `rules_location` varchar(255) DEFAULT NULL,
  `recipient_signature` varchar(255) DEFAULT NULL,
  `monthly_salary1` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount1` varchar(100) DEFAULT NULL,
  `daily_salary1` tinyint(1) DEFAULT NULL,
  `daily_salary_amount1` varchar(100) DEFAULT NULL,
  `hourly_salary1` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount1` varchar(100) DEFAULT NULL,
  `hourly_rate` varchar(100) DEFAULT NULL,
  `monthly_rate` varchar(100) DEFAULT NULL,
  `allowance_a_name1` varchar(100) DEFAULT NULL,
  `allowance_a_amount` varchar(100) DEFAULT NULL,
  `allowance_a_calc` varchar(100) DEFAULT NULL,
  `allowance_b_name` varchar(100) DEFAULT NULL,
  `allowance_b_amount` varchar(100) DEFAULT NULL,
  `allowance_b_calc` varchar(100) DEFAULT NULL,
  `allowance_c_name` varchar(100) DEFAULT NULL,
  `allowance_c_amount` varchar(100) DEFAULT NULL,
  `allowance_c_calc` varchar(100) DEFAULT NULL,
  `allowance_d_name` varchar(100) DEFAULT NULL,
  `allowance_d_amount` varchar(100) DEFAULT NULL,
  `allowance_d_calc` varchar(100) DEFAULT NULL,
  `fixed_overtime_name` varchar(100) DEFAULT NULL,
  `fixed_overtime_amount` varchar(100) DEFAULT NULL,
  `overtime_hours` varchar(100) DEFAULT NULL,
  `total_payment` varchar(100) DEFAULT NULL,
  `tax_amount` varchar(100) DEFAULT NULL,
  `social_insurance` varchar(100) DEFAULT NULL,
  `employment_insurance1` varchar(100) DEFAULT NULL,
  `food_expense` varchar(100) DEFAULT NULL,
  `housing_expense` varchar(100) DEFAULT NULL,
  `utility_expense` varchar(100) DEFAULT NULL,
  `other_deduction_1_name` varchar(100) DEFAULT NULL,
  `other_deduction_1_amount` varchar(100) DEFAULT NULL,
  `other_deduction_2_name` varchar(100) DEFAULT NULL,
  `other_deduction_2_amount` varchar(100) DEFAULT NULL,
  `other_deduction_3_name` varchar(100) DEFAULT NULL,
  `other_deduction_3_amount` varchar(100) DEFAULT NULL,
  `other_deduction_4_name` varchar(100) DEFAULT NULL,
  `other_deduction_4_amount` varchar(100) DEFAULT NULL,
  `other_deduction_5_name` varchar(100) DEFAULT NULL,
  `other_deduction_5_amount` varchar(100) DEFAULT NULL,
  `total_deduction` varchar(100) DEFAULT NULL,
  `net_payment` varchar(100) DEFAULT NULL,
  `year_vn` varchar(10) DEFAULT NULL,
  `month_vn` varchar(10) DEFAULT NULL,
  `day_vn` varchar(10) DEFAULT NULL,
  `recipient_name_vn` varchar(200) DEFAULT NULL,
  `organization_name_vn` varchar(200) DEFAULT NULL,
  `address_vn` varchar(200) DEFAULT NULL,
  `phone_vn` varchar(20) DEFAULT NULL,
  `representative_name_vn` varchar(200) DEFAULT NULL,
  `contract_start_year_vn` varchar(5) DEFAULT NULL,
  `contract_start_month_vn` varchar(5) DEFAULT NULL,
  `contract_start_day_vn` varchar(5) DEFAULT NULL,
  `contract_end_year_vn` varchar(5) DEFAULT NULL,
  `contract_end_month_vn` varchar(5) DEFAULT NULL,
  `contract_end_day_vn` varchar(5) DEFAULT NULL,
  `entry_year_vn` varchar(5) DEFAULT NULL,
  `entry_month_vn` varchar(5) DEFAULT NULL,
  `entry_day_vn` varchar(5) DEFAULT NULL,
  `update_auto_vn` tinyint(1) DEFAULT NULL,
  `update_possible_vn` tinyint(1) DEFAULT NULL,
  `no_update_vn` tinyint(1) DEFAULT NULL,
  `workload_criteria_vn` tinyint(1) DEFAULT NULL,
  `performance_criteria_vn` tinyint(1) DEFAULT NULL,
  `ability_criteria_vn` tinyint(1) DEFAULT NULL,
  `company_status_vn` tinyint(1) DEFAULT NULL,
  `work_progress_vn` tinyint(1) DEFAULT NULL,
  `other_criteria_vn` tinyint(1) DEFAULT NULL,
  `permanent_contract_year_vn` varchar(5) DEFAULT NULL,
  `permanent_contract_month_vn` varchar(5) DEFAULT NULL,
  `permanent_contract_day_vn` varchar(5) DEFAULT NULL,
  `direct_employment_vn` tinyint(1) DEFAULT NULL,
  `direct_office_name_vn` varchar(200) DEFAULT NULL,
  `direct_office_address_vn` varchar(200) DEFAULT NULL,
  `direct_office_contact_vn` varchar(200) DEFAULT NULL,
  `dispatch_employment_vn` tinyint(1) DEFAULT NULL,
  `no_change_possible_vn` tinyint(1) DEFAULT NULL,
  `dispatch_office_name_vn` varchar(200) DEFAULT NULL,
  `dispatch_office_address_vn` varchar(200) DEFAULT NULL,
  `dispatch_office_contact_vn` varchar(200) DEFAULT NULL,
  `field_vn` varchar(100) DEFAULT NULL,
  `work_category_vn` varchar(100) DEFAULT NULL,
  `no_change_possibility_vn` tinyint(1) DEFAULT NULL,
  `change_field_vn` varchar(100) DEFAULT NULL,
  `change_work_category_vn` varchar(100) DEFAULT NULL,
  `start_hour_vn` varchar(10) DEFAULT NULL,
  `start_minute_vn` varchar(10) DEFAULT NULL,
  `end_hour_vn` varchar(10) DEFAULT NULL,
  `end_minute_vn` varchar(10) DEFAULT NULL,
  `working_hours_vn` varchar(10) DEFAULT NULL,
  `working_minutes_vn` varchar(10) DEFAULT NULL,
  `irregular_work_hours_vn` tinyint(1) DEFAULT NULL,
  `unit_work_hours_vn` tinyint(1) DEFAULT NULL,
  `shift_work_vn` tinyint(1) DEFAULT NULL,
  `shift_start_hour_vn` varchar(10) DEFAULT NULL,
  `shift_start_minute_vn` varchar(10) DEFAULT NULL,
  `shift_end_hour_vn` varchar(10) DEFAULT NULL,
  `shift_end_minute_vn` varchar(10) DEFAULT NULL,
  `shift_apply_date_vn` varchar(10) DEFAULT NULL,
  `shift_working_hours_vn` varchar(10) DEFAULT NULL,
  `shift_working_minutes_vn` varchar(10) DEFAULT NULL,
  `shift2_start_hour_vn` varchar(10) DEFAULT NULL,
  `shift2_start_minute_vn` varchar(10) DEFAULT NULL,
  `shift2_end_hour_vn` varchar(10) DEFAULT NULL,
  `shift2_end_minute_vn` varchar(10) DEFAULT NULL,
  `shift2_apply_date_vn` varchar(10) DEFAULT NULL,
  `shift2_working_hours_vn` varchar(10) DEFAULT NULL,
  `shift2_working_minutes_vn` varchar(10) DEFAULT NULL,
  `shift3_start_hour_vn` varchar(10) DEFAULT NULL,
  `shift3_start_minute_vn` varchar(10) DEFAULT NULL,
  `shift3_end_hour_vn` varchar(10) DEFAULT NULL,
  `shift3_end_minute_vn` varchar(10) DEFAULT NULL,
  `shift3_apply_date_vn` varchar(10) DEFAULT NULL,
  `shift3_working_hours_vn` varchar(10) DEFAULT NULL,
  `shift3_working_minutes_vn` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_terms_of_employment_vn`
--

INSERT INTO `et_doc_terms_of_employment_vn` VALUES
(1,NULL,NULL,'2025-05-13 04:16:22',1,'2025-05-13 04:16:22',1,'2025','12','20','Aaaa','ABC会社','千葉県柏市あけぼの5-4-35-102','0567-52-2736','tanakaa','2025','10','11','2026','10','10','2025','10','10',1,1,1,1,1,1,1,1,1,'2025','5','5',1,'ABC会社','ABC会社','ABC会社',1,1,'合同会','合同会','合同会','建設','土木',1,'外食','接客','8','00','17','00','8','00',1,NULL,1,'８','00','17','00','3','8','12','7','30','17','30','3','12','12','12','12','12','12',NULL,'12','12','60','12','60','3','3','120','12',59,'sdgnsdjgn','sgnsldgnsd','12','12','12',1,'23đ','12ccc','1cs','213','ádasd','df12',2,'21sf','123sdf',2,1,'123',1,'123',1,'123','dskfn123','dsn13','sdgkn23','123','123','123','123','123','123',1,1,'20','20',1,15,1,12,1,NULL,2,1,'dsfs',NULL,NULL,'sdfs',1,NULL,'df',1,1,'sdf','dfdsfsd','dsfsdf',1,1,1,1,1,1,1,'df','df','sdf','sdf','sdf','sd','sdf','sdf','sdf','sdf',1,'50000',1,'dsf',1,'dsf',NULL,NULL,NULL,'2000','sdf','sdf','3000','sdf','sdf','sdf','sdf','sdf','sdf','sdf','fsdf','sdfsdf','sdf','sdf','sdf','sdf','dsf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf','sdf',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,NULL,NULL,'2025-07-09 03:54:48',1,'2025-07-09 03:54:48',1,'2001','12','12','sdfsdf','sdf','sdf','sdf','sdf','2025','10','11','2026','10','10','2025','10','10',1,1,1,1,NULL,1,1,1,1,'12','12','12',1,'ABC会社','ád','ád',1,1,'合同会','ád','ád','ád','ád',1,'ád','ád','8','00','17','00','8','00',1,NULL,NULL,'８','00','17','00',NULL,'8','12','7','30','17','30',NULL,'12','12','12','12','12','12',NULL,'12','12','60','12','60','12','122','12','12',9,'sdfsdfsdf','sdfsdfsd','12','12','12',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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'12','12','12','sdfdsf','sdf','sdf','sdf','sdfsdf','11','11','11','11','11','11','11','11','11',1,1,NULL,1,1,1,1,1,1,'123','123','123',1,'ádasd','ád','ád',1,1,'sad','ád','ád','ád','ád',1,'ád','ád','8','00','8','99','8','99',1,NULL,NULL,'12','12','12','12',NULL,'12','12','12','12','12','12',NULL,'12','12','12','12','12','12',NULL,'12','12');

--
-- Table structure for table `et_doc_terms_of_employment_vn2`
--

CREATE TABLE `et_doc_terms_of_employment_vn2` (
  `id_terms_of_employment_vn` bigint(20) DEFAULT NULL,
  `break_time_vn` varchar(10) DEFAULT NULL,
  `break_hours_vn` varchar(10) DEFAULT NULL,
  `break_minutes_vn` varchar(10) DEFAULT NULL,
  `working_days_vn` varchar(10) DEFAULT NULL,
  `working_days_per_week_vn` varchar(10) DEFAULT NULL,
  `working_days_per_year_vn` varchar(10) DEFAULT NULL,
  `prescribed_working_days_vn` varchar(10) DEFAULT NULL,
  `updated_count_vn` bigint(20) DEFAULT NULL,
  `other_criteria_detail_vn` varchar(100) DEFAULT NULL,
  `irregular_work_hours_detail_vn` varchar(100) DEFAULT NULL,
  `prescribed_working_days_4_1_vn` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_2_vn` varchar(50) DEFAULT NULL,
  `prescribed_working_days_4_3_vn` varchar(50) DEFAULT NULL,
  `overtime_available_vn` tinyint(1) DEFAULT NULL,
  `prescribed_working_days_5_1_vn` varchar(100) DEFAULT NULL,
  `regular_holiday_other_vn` varchar(100) DEFAULT NULL,
  `total_holidays_vn` varchar(100) DEFAULT NULL,
  `irregular_holiday_count_vn` varchar(100) DEFAULT NULL,
  `irregular_holiday_other_vn` varchar(100) DEFAULT NULL,
  `paid_leave_days_vn` varchar(100) DEFAULT NULL,
  `paid_leave_vn` tinyint(1) DEFAULT NULL,
  `months_before_leave_vn` varchar(100) DEFAULT NULL,
  `days_of_leave_vn` varchar(100) DEFAULT NULL,
  `other_leave_vn` tinyint(1) DEFAULT NULL,
  `monthly_salary_vn` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount_vn` varchar(100) DEFAULT NULL,
  `daily_salary_vn` tinyint(1) DEFAULT NULL,
  `daily_salary_amount_vn` varchar(100) DEFAULT NULL,
  `hourly_salary_vn` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_1_vn` varchar(100) DEFAULT NULL,
  `allowance_2_vn` varchar(100) DEFAULT NULL,
  `allowance_3_vn` varchar(100) DEFAULT NULL,
  `overtime_rate_within_60_vn` varchar(100) DEFAULT NULL,
  `overtime_rate_over_60_vn` varchar(100) DEFAULT NULL,
  `prescribed_overtime_rate_vn` varchar(100) DEFAULT NULL,
  `statutory_holiday_rate_vn` varchar(100) DEFAULT NULL,
  `non_statutory_holiday_rate_vn` varchar(100) DEFAULT NULL,
  `night_shift_rate_vn` varchar(100) DEFAULT NULL,
  `monthly_checkbox_vn` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_2_vn` tinyint(1) DEFAULT NULL,
  `salary_closing_day_vn` varchar(100) DEFAULT NULL,
  `salary_closing_day_2_vn` varchar(100) DEFAULT NULL,
  `monthly_checkbox_3_vn` tinyint(1) DEFAULT NULL,
  `salary_payment_day_vn` int(100) DEFAULT NULL,
  `monthly_checkbox_4_vn` int(1) DEFAULT NULL,
  `salary_payment_day_2_vn` int(100) DEFAULT NULL,
  `monthly_checkbox_6_vn` tinyint(1) DEFAULT NULL,
  `monthly_checkbox_5_vn` tinyint(1) DEFAULT NULL,
  `has_something_vn` tinyint(1) DEFAULT NULL,
  `has_salary_increase_vn` tinyint(1) DEFAULT NULL,
  `salary_increase_detail_vn` varchar(100) DEFAULT NULL,
  `no_salary_increase_vn` tinyint(1) DEFAULT NULL,
  `has_bonus_vn` tinyint(1) DEFAULT NULL,
  `bonus_detail_vn` varchar(100) DEFAULT NULL,
  `no_bonus_vn` tinyint(1) DEFAULT NULL,
  `has_retirement_vn` tinyint(1) DEFAULT NULL,
  `retirement_detail_vn` varchar(100) DEFAULT NULL,
  `no_retirement_vn` tinyint(1) DEFAULT NULL,
  `has_leave_allowance_vn` tinyint(1) DEFAULT NULL,
  `leave_allowance_rate_vn` varchar(100) DEFAULT NULL,
  `resignation_notice_days_vn` varchar(200) DEFAULT NULL,
  `other_insurance_detail_vn` varchar(200) DEFAULT NULL,
  `welfare_pension_vn` tinyint(1) DEFAULT NULL,
  `health_insurance_vn` tinyint(1) DEFAULT NULL,
  `employment_insurance_vn` tinyint(1) DEFAULT NULL,
  `workers_compensation_vn` tinyint(1) DEFAULT NULL,
  `national_pension_vn` tinyint(1) DEFAULT NULL,
  `national_health_vn` tinyint(1) DEFAULT NULL,
  `other_insurance_vn` tinyint(1) DEFAULT NULL,
  `initial_checkup_year_vn` varchar(50) DEFAULT NULL,
  `initial_checkup_month_vn` varchar(50) DEFAULT NULL,
  `first_checkup_year_vn` varchar(100) DEFAULT NULL,
  `first_checkup_month_vn` varchar(100) DEFAULT NULL,
  `checkup_interval_vn` varchar(100) DEFAULT NULL,
  `department_name_vn` varchar(200) DEFAULT NULL,
  `manager_name_vn` varchar(200) DEFAULT NULL,
  `contact_info_vn` varchar(200) DEFAULT NULL,
  `rules_location_vn` varchar(255) DEFAULT NULL,
  `recipient_signature_vn` varchar(255) DEFAULT NULL,
  `monthly_salary1_vn` tinyint(1) DEFAULT NULL,
  `monthly_salary_amount1_vn` varchar(100) DEFAULT NULL,
  `daily_salary1_vn` tinyint(1) DEFAULT NULL,
  `daily_salary_amount1_vn` varchar(100) DEFAULT NULL,
  `hourly_salary1_vn` tinyint(1) DEFAULT NULL,
  `hourly_salary_amount1_vn` varchar(100) DEFAULT NULL,
  `hourly_rate_vn` varchar(100) DEFAULT NULL,
  `monthly_rate_vn` varchar(100) DEFAULT NULL,
  `allowance_a_name1_vn` varchar(100) DEFAULT NULL,
  `allowance_a_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_a_calc_vn` varchar(100) DEFAULT NULL,
  `allowance_b_name_vn` varchar(100) DEFAULT NULL,
  `allowance_b_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_b_calc_vn` varchar(100) DEFAULT NULL,
  `allowance_c_name_vn` varchar(100) DEFAULT NULL,
  `allowance_c_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_c_calc_vn` varchar(100) DEFAULT NULL,
  `allowance_d_name_vn` varchar(100) DEFAULT NULL,
  `allowance_d_amount_vn` varchar(100) DEFAULT NULL,
  `allowance_d_calc_vn` varchar(100) DEFAULT NULL,
  `fixed_overtime_name_vn` varchar(100) DEFAULT NULL,
  `fixed_overtime_amount_vn` varchar(100) DEFAULT NULL,
  `overtime_hours_vn` varchar(100) DEFAULT NULL,
  `total_payment_vn` varchar(100) DEFAULT NULL,
  `tax_amount_vn` varchar(100) DEFAULT NULL,
  `social_insurance_vn` varchar(100) DEFAULT NULL,
  `employment_insurance1_vn` varchar(100) DEFAULT NULL,
  `food_expense_vn` varchar(100) DEFAULT NULL,
  `housing_expense_vn` varchar(100) DEFAULT NULL,
  `utility_expense_vn` varchar(100) DEFAULT NULL,
  `other_deduction_1_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_1_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_2_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_2_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_3_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_3_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_4_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_4_amount_vn` varchar(100) DEFAULT NULL,
  `other_deduction_5_name_vn` varchar(100) DEFAULT NULL,
  `other_deduction_5_amount_vn` varchar(100) DEFAULT NULL,
  `total_deduction_vn` varchar(100) DEFAULT NULL,
  `net_payment_vn` varchar(100) DEFAULT NULL,
  `renewal_limit` tinyint(1) DEFAULT NULL,
  `renewal_times` varchar(10) DEFAULT NULL,
  `total_period` varchar(10) DEFAULT NULL,
  `renewal_limit_vn` tinyint(1) DEFAULT NULL,
  `renewal_times_vn` varchar(10) DEFAULT NULL,
  `total_period_vn` varchar(10) DEFAULT NULL,
  `employment_condition_change` tinyint(1) DEFAULT NULL,
  `employment_condition_change_vn` tinyint(1) DEFAULT NULL,
  `permanent_contract_day_vn` varchar(10) DEFAULT NULL,
  `permanent_contract_month_vn` varchar(10) DEFAULT NULL,
  `permanent_contract_year_vn` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_terms_of_employment_vn2`
--

INSERT INTO `et_doc_terms_of_employment_vn2` VALUES
(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,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(2,'112','12','12','12','12','12','12',NULL,'ádsdas','xfghfgh','12','12','12',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,2,'12','12',2,'12','12',1,2,'123','123','123');

--
-- Table structure for table `et_doc_tokutei_job_form`
--

CREATE TABLE `et_doc_tokutei_job_form` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `company_id` bigint(20) DEFAULT NULL,
  `customer_id` bigint(20) DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_count` bigint(20) DEFAULT NULL,
  `no` varchar(100) DEFAULT NULL,
  `sd_orgz_name` varchar(200) DEFAULT NULL,
  `sch_interview_date` varchar(200) DEFAULT NULL,
  `reg_sp_org_name` varchar(200) DEFAULT NULL,
  `expected_start_date` varchar(200) DEFAULT NULL,
  `job_application` varchar(200) DEFAULT NULL,
  `per` tinyint(1) DEFAULT NULL,
  `zoom` tinyint(1) DEFAULT NULL,
  `doc` tinyint(1) DEFAULT NULL,
  `company_name` varchar(200) DEFAULT NULL,
  `representative` varchar(200) DEFAULT NULL,
  `company_name1` varchar(200) DEFAULT NULL,
  `representative1` varchar(200) DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `tel` varchar(50) DEFAULT NULL,
  `fax` varchar(50) DEFAULT NULL,
  `main_business_activities` varchar(200) DEFAULT NULL,
  `accepted_job_types` varchar(200) DEFAULT NULL,
  `place_of_employment` varchar(200) DEFAULT NULL,
  `main_work_contents` varchar(200) DEFAULT NULL,
  `number` varchar(100) DEFAULT NULL,
  `number1` varchar(100) DEFAULT NULL,
  `contract_period` varchar(200) DEFAULT NULL,
  `required_qualifications` varchar(200) DEFAULT NULL,
  `other_hopes` varchar(200) DEFAULT NULL,
  `salary` varchar(100) DEFAULT NULL,
  `hourly_wage` varchar(100) DEFAULT NULL,
  `tax12` varchar(100) DEFAULT NULL,
  `social_insurance` varchar(100) DEFAULT NULL,
  `housing_fees` varchar(100) DEFAULT NULL,
  `cost` varchar(100) DEFAULT NULL,
  `important_notes` varchar(100) DEFAULT NULL,
  `on_site` varchar(100) DEFAULT NULL,
  `others` varchar(200) DEFAULT NULL,
  `net_amount` varchar(100) DEFAULT NULL,
  `bonus` varchar(100) DEFAULT NULL,
  `salary_increase` varchar(100) DEFAULT NULL,
  `time_f` varchar(50) DEFAULT NULL,
  `time_t` varchar(50) DEFAULT NULL,
  `rest_time` varchar(50) DEFAULT NULL,
  `avrg_overtime_h` varchar(50) DEFAULT NULL,
  `number_holidays_per_year` varchar(50) DEFAULT NULL,
  `annual_working` varchar(50) DEFAULT NULL,
  `time_wk` varchar(50) DEFAULT NULL,
  `others_wk` varchar(100) DEFAULT NULL,
  `important_notes1` text DEFAULT NULL,
  `job_title` varchar(100) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `full_name` varchar(200) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `company_address` varchar(200) DEFAULT NULL,
  `chk_register_shien` tinyint(1) DEFAULT NULL,
  `job_title_furigana` varchar(100) DEFAULT NULL,
  `company_license` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_tokutei_job_form`
--

INSERT INTO `et_doc_tokutei_job_form` VALUES
(1,1,NULL,NULL,'2025-04-22 08:43:07',1,'2025-05-01 08:46:56',21,'123456789-1','LABCO','20230303','株式会社AlphaCep','ádasd','2023年10月10日',1,1,1,NULL,'ぐえん　ヴぁん　あ','株式会社ABC','NGUYEN VAN A','千葉県鎌ケ谷市１－１８－２２スカラビル３F','0474-022-022','03-2222-3333','建設','建設','千葉県鎌ケ谷市１－１８－２２スカラビル３F','建設１２３４５','3','4','期間なし','N4以上','dsmsp','100000','2000','30000','5000','7000','9000','12000','14000','16000','18000','20000','21000','22','14','12:00 ~ 13:00','8','3','100','月',NULL,'あいうえお、かきくけこ','事務','07084848455','NGUYEN THI　THANH XUAN','Sakigaoka 2-24-22',NULL,NULL,NULL,NULL),
(2,2,NULL,NULL,'2025-05-12 19:55:22',150,'2025-05-14 19:56:33',9,'3056',NULL,'2025/5/14','株式会社AlphaCep','2025/5/15','2025/5/16',1,1,1,'ハヤシコウギョウ','ツルイ　ケンシ','合同会社林工業','鶴井 賢司','〒244-0813 神奈川県横浜市戸塚区舞岡町306番地','045-390-0857','045-390-0858','とび・土工工事業\r\n土木工事業\r\n鋼構造物工事業\r\n機械器具設置工事業\r\nその他工事等','土木','関東、※出張あり（例）北海道　3ヶ月','とび工、鍛冶工','2',NULL,'年間','経験がある方','国内で、経験者のみ、特定技能1年未満','2222','2222','111111','22222','33333','44444','444444444444','6666','77777','8888','88','222222','11:00','23:00','12:00~13:00','11','222','333','444','222222','2222','株式会社AlphaCep','0474-022-022','牧子 陽子','千葉県鎌ケ谷市北中沢１－１８－２２スカラビル３F',NULL,NULL,NULL,NULL),
(3,2,NULL,NULL,'2025-05-14 22:25:33',150,'2025-05-14 22:26:57',1,'1',NULL,'3',NULL,'4','2',1,1,1,'5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','-30','31','32','33','34','35','36','37','38',NULL,'39','44','40','42','43','41',NULL,NULL,NULL,NULL),
(4,1,NULL,NULL,'2025-05-15 02:43:39',1,'2025-05-15 02:48:21',2,'123456789-1',NULL,'20230303',NULL,'ádasd','2023年10月10日',1,1,1,'sdfsdf','sdfdsfssdfsd','sdfsdf','sdfsdfsd','sdfsdfsd','sdfdsf','sdfsdfsdf','sdfsdfs','sdfsdf','sdfsdf','sdfsdf','sdfsdf','sdfsdf','sdfsdf','sdfsdf','sdfsdf','10','2000','30','5000','7000','9000','12000','14000','16000','18000','20','21000','22','14','12:00 ~ 13:00','8','3','100',NULL,'90909','kugugug','事務','0582158912','NGUYEN THI　THANH XUAN','岐阜県多治見市希望ヶ丘4-75-3(多治見事務所)　岐阜県羽島郡岐南町平成3丁目166（本所）',NULL,1,NULL,NULL),
(5,2,NULL,NULL,'2025-05-15 04:04:11',150,'2025-05-15 05:33:58',2,'123456789',NULL,'2023年10月10日',NULL,'2023年10月10日','2023年10月10日',1,1,1,NULL,'7','株式会社TMS','立花　和久','茨城県神栖市知手6044','029-9960-470','029-9957-018','仕上げ工・製缶工・配管工 \r\n事業','自動車整備','茨城県神栖市知手6044','仕上げ工・製缶工・配管工  \r\n作業','3',NULL,'１年間、自動更新','N4以上','日本国内のみ','230000','1200','23000','20000','12000','2300','25000','26000','27000','12000','13000','14000','09:00','18:00','12:00～13:00','37','38','1200',NULL,'1200','ベトナム人不可\r\nインドネシア・タイ人などOK','株式会社AlphaCep','0474-022-022','大越 花蓮','千葉県鎌ケ谷市北中沢１－１８－２２スカラビル３Ｆ',NULL,1,NULL,NULL),
(6,2,NULL,150,'2025-05-15 08:33:17',150,'2025-05-15 08:33:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(7,2,NULL,150,'2025-05-15 08:40:45',150,'2025-05-15 08:40:45',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(8,2,NULL,150,'2025-05-15 08:58:27',150,'2025-05-15 08:58:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(9,2,NULL,150,'2025-05-15 19:29:27',150,'2025-05-15 19:29:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(10,2,NULL,150,'2025-05-15 19:41:53',150,'2025-05-15 19:41:53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社東京やまはち産業',NULL,'東京都江戸川区中葛西5-42-3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(11,2,NULL,150,'2025-05-15 21:50:15',150,'2025-05-15 21:50:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(12,2,NULL,150,'2025-05-15 21:56:09',150,'2025-05-16 10:15:11',14,'1234shshhs22222',NULL,'345shhshs',NULL,'Hsbdgshhsh','2025-05-16hdhdhhd',1,1,1,'Gebe','Hshshhs','株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519hshshhs','Gshshhs','カレーハウスCoCo壱番屋の運営hshshhs\r\nNdjsjsj','Yhshhs','Hshshhs','Dbndjhsj\r\nJsjsjjsjjs','1','3','Hshshhs','Bsnhsjjs','Bsbbsjs','2221','2222','22223,k','2224','5','3','7','8','3','10','10','6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(13,2,NULL,150,'2025-05-16 09:33:07',150,'2025-05-16 09:55:10',1,'13',NULL,'22',NULL,'２２２','2025-05-16',NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(14,2,NULL,150,'2025-05-16 12:15:29',150,'2025-05-16 12:15:29',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'京都ケータリング株式会社',NULL,'京都府舞鶴市公文名570-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,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(17,2,NULL,150,'2025-05-17 12:26:21',150,'2025-05-17 13:42:37',2,'17',NULL,'2025-05-17',NULL,'2025-05-17','2025-05-17',1,1,1,'すみともかぶしきかいしゃ','やすい　きゅうじん','住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38','０３－５７９６－７１２５','03-2222-3333','建設施工管理経験','建設','千葉県鎌ケ谷市１－１８－２２スカラビル３F','建設施工管理経験','1','2','期間なし','N4以上','ベトナム・インドネシア','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','11,000円','22:00','13:00','22:00～22:00','22','22','23',NULL,'333','22222','株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,1,NULL,NULL),
(18,NULL,NULL,NULL,'2025-05-19 04:51:26',NULL,'2025-05-21 01:49:34',6,'123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),
(19,2,NULL,150,'2025-05-20 22:02:41',150,'2025-05-20 22:02:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(20,2,NULL,150,'2025-05-21 03:01:22',150,'2025-05-21 03:10:45',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(21,2,NULL,150,'2025-05-21 12:00:17',150,'2025-05-21 12:55:42',2,'22222',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(22,2,NULL,150,'2025-05-21 20:05:04',150,'2025-05-21 20:05:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(23,2,NULL,150,'2025-05-22 12:10:19',150,'2025-05-22 12:10:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(24,2,NULL,150,'2025-05-23 04:29:22',150,'2025-05-23 04:29:22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(25,2,NULL,150,'2025-05-23 20:51:21',150,'2025-05-23 20:51:21',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(26,2,NULL,150,'2025-05-23 20:53:09',150,'2025-05-23 20:53:09',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社安楽亭',NULL,'埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(27,2,NULL,150,'2025-05-23 21:11:49',150,'2025-05-23 21:11:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社安楽亭',NULL,'埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(28,NULL,NULL,150,'2025-05-23 21:17:20',NULL,'2025-05-23 22:05:57',2,NULL,NULL,'adfadfadfadfadfadf',NULL,'ầdfadfdafadfafd','adfadfadfadf',1,1,1,'1đàadfadfadf','2adfasdfasdfads','株式会社安楽亭','3adfadsfadsfadf','埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555','444455555','âfdadfadf','22adfadfa','adfadfad','fadfadf','1','2','fadfadf','đâfda','adfadf','adfadf','adfadf','adfadf','adfadf','fadad','adfadf','àdadf','adfadf','àdadf','đâf','adfadf','adfadf','ầdfdafdadfadf','fadfadfadfafđfđâfadfdafadfad','fafadfdfdfadfadfasdfadfadfdfadf','ầdsfadsdfdafadfdafadfdafdafdadfadfadfadfdasfdaf','ầdfadfdaf','adfadfadfdaf',NULL,'dfadafadfadfadf','dfadfadfadfadfadfadfadfafd','株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'ầdfadf','adfadfadf'),
(29,2,NULL,150,'2025-05-24 01:39:14',150,'2025-05-24 01:39:14',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'京都ケータリング株式会社',NULL,'京都府舞鶴市公文名570-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,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(33,2,NULL,150,'2025-05-24 02:06:37',150,'2025-05-24 02:06:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(34,2,NULL,150,'2025-05-24 02:08:39',150,'2025-05-24 02:08:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(35,2,NULL,150,'2025-05-25 20:37:04',150,'2025-05-25 20:37:04',NULL,'35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(36,2,NULL,150,'2025-05-25 20:42:17',150,'2025-05-25 20:42:17',NULL,'36',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(37,2,NULL,150,'2025-05-25 20:42:48',150,'2025-05-25 20:42:48',NULL,'37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38',NULL,NULL,'建設施工管理経験',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(38,2,NULL,150,'2025-05-25 20:50:11',150,'2025-05-25 20:56:35',1,'3241',NULL,'22222222',NULL,'222222','22222222',1,1,NULL,'3333','3333','住協建設株式会社','安永久人','埼玉県狭山市狭山台4-27-38','3333333333333','444444444444444','建設施工管理経験','2222222222222222','44444444444444','333333333333333','222','222','222222','222222222','2222222222','222','2222222','22222','2222','22222','222','22','2','2','222222','2222222','2222222','22222222','2222','2222222222','2222222222','22222222222222222222222222','2222222222',NULL,'2222222222','2222222222222','株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'222222222222','22222222222'),
(39,2,NULL,150,'2025-05-25 20:57:33',150,'2025-05-25 20:57:33',NULL,'3243',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社安楽亭',NULL,'埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(40,2,NULL,150,'2025-05-26 20:05:19',150,'2025-05-26 20:05:19',NULL,'3247',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社アメリカヤコーポレーション',NULL,'群馬県館林市本町４丁目５番６号',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(41,2,NULL,150,'2025-05-26 20:08:30',150,'2025-05-26 20:08:30',NULL,'3248',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社安楽亭',NULL,'埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(42,2,NULL,150,'2025-05-26 20:51:11',150,'2025-05-26 20:51:11',NULL,'3249',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社安楽亭',NULL,'埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(43,NULL,NULL,150,'2025-05-27 01:02:12',NULL,'2025-05-27 02:19:00',11,'3252',NULL,'１次リモート面接／2次現地面接+WEBテスト',NULL,NULL,NULL,1,1,NULL,'カブシキガイシャアンラクテイ 12312','ヤナギ　セン','株式会社安楽亭123123','柳 先','埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555','048-8590-0560','焼肉を中心とした飲食店のチェーン経営','自動車整備分野','関東、静岡','主に板金塗装','-','-',NULL,'日本語資格必須　N3以上','飲食店での就業経験（アルバイトのみ可）/ 接客販売経験（アルバイトのみ可）','230,000～290,000',NULL,'3,600～5,000','32,200 ～40,650   ■健康保険 11,100～14,000 ■厚生年金 21,100～26,650  ■雇用保険 1,200～2,100','※社宅無し、自分で用意',NULL,NULL,NULL,NULL,'193,000～242,250',NULL,NULL,'シフト制 10：00～26：00／実働8～10時間　（店舗の営業時間に準ずる）',NULL,NULL,'年間休日117日 （月7日以上）',NULL,NULL,NULL,'30時間程度, 3か月間の試用期間については残業は無し','福利厚生について\r\n　　・交通費規定支給、車通勤可（無料駐車場有、ガソリン代規定支給）\r\n　　・社員持株制度、・財形貯蓄、・社員割引（安楽亭直営店舗を20％割引で利用できます）\r\n　　・退職金制度（規定有）、・試用期間3ヶ月（同条件）\r\n　　・屋内の受動喫煙対策：有（禁煙）','株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(44,2,NULL,150,'2025-05-28 19:50:36',150,'2025-05-28 19:53:03',1,'3258',NULL,'5',NULL,'6','2025-05-29',1,1,1,'かぶしきかいしゃ　きむらや１','２','株式会社きむら家３','木村　孝明４','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル５','035-3515-519６','７','カレーハウスCoCo壱番屋の運営８','1','2','3','4','5','6','7','8','1','2','3','4','5','6','7','8','1','2','3','4','5','6','7','8','1','2',NULL,'3','4','株式会社AlphaCep2','047-4022-0225','大越 花蓮6','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F4',NULL,NULL,'1','3'),
(45,2,NULL,150,'2025-05-28 20:03:03',150,'2025-05-28 21:05:24',2,'3260',NULL,'１次　リモート面接　／　2次　現地面接+WEBテスト',NULL,NULL,NULL,NULL,NULL,NULL,'カブシキガイシャアンラクテイ',NULL,'株式会社安楽亭','柳 先','埼玉県さいたま市中央区上落合２丁目３−５ アルーサ北与野Ａ館 Ｂ館４階','048-8590-555','048-8590-0560','焼肉を中心とした飲食店のチェーン経営','外食業','東京・千葉・神奈川・埼玉　※希望があれば相談可','接客・調理','-','-','-','日本語資格必須　N3以上/特定技能資格','飲食店での就業経験（アルバイトのみ可）/ 接客販売経験（アルバイトのみ可）\r\n国籍：どの国籍でも可','230,000～290,000',NULL,'3,600～5,000','32,200 ～40,650　健康保険 11,100～14,000　厚生年金 21,100～26,650　雇用保険 1,200～2,100',NULL,NULL,NULL,NULL,NULL,'193,000～242,250','有り（実績／1.3ヶ月～）年2回','あり　随時（四半期評価による）','シフト制 10：00～26：00／実働8～10時間　（店舗の営業時間に準ずる）',NULL,NULL,'30時間程度, 3か月間の試用期間については残業は無し','年間休日117日 （月7日以上）',NULL,NULL,'実習環境：店舗','福利厚生について\r\n　　・交通費規定支給\r\n　　・車通勤可（無料駐車場有、ガソリン代規定支給）\r\n　　・社員持株制度\r\n　　・財形貯蓄\r\n　　・社員割引（安楽亭直営店舗を20％割引で利用できます）\r\n　　・退職金制度（規定有）\r\n　　・試用期間3ヶ月（同条件）\r\n　　・屋内の受動喫煙対策：有（禁煙）','株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'かぶしきかいしゃ　あるふぁせぷ','24登 -009405'),
(46,2,NULL,150,'2025-05-29 12:03:38',150,'2025-05-29 12:03:38',NULL,'3264',NULL,NULL,NULL,NULL,'2025-05-29 21:03:38',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(47,2,NULL,150,'2025-06-02 07:52:14',150,'2025-06-02 07:52:14',NULL,'3287',NULL,NULL,NULL,NULL,'2025-06-02',NULL,NULL,NULL,NULL,NULL,'京都ケータリング株式会社',NULL,'京都府舞鶴市公文名570-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,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(48,2,NULL,136,'2025-06-02 07:56:15',136,'2025-06-02 08:18:59',1,'3288',NULL,'2024年12月13日',NULL,'2025年7月1日','2024-11-29',NULL,1,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営','株式会社きむら家','東京都渋谷区笹塚1-59-10','カレーハウスＣｏｃｏ壱番屋の店舗スタッフとしての接客や調理の業務','2',NULL,'雇用契約期間定めなし','特になし',NULL,'230000','1320','3900','26000','47500','5000',NULL,NULL,NULL,'146,220',NULL,NULL,'10：00','19：00','60','20',NULL,'265',NULL,'17：00～1：30　夜間勤務有','初期費用については\r\n　・会社が入居時対応\r\n　・初期費用については給与から差し引いて立替\r\nVISAの申請が降りたら対応するとお伝え\r\n予定については\r\n　・初期費用　10万円ぐらい　2年で解約しないなど縛りがある\r\n　・笹塚付近で自転車で通えるところが理想\r\n　　　吉祥寺、武蔵小金井なども理想　\r\n　　　４～５万ぐらいのところ\r\n　　　中には、渋谷区や幡ヶ谷で借りれるところもある','株式会社AlphaCep','047-4022-022','牧子 陽子','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'アルファセプ','24登-009405'),
(49,2,NULL,136,'2025-06-09 03:06:35',136,'2025-06-09 07:50:18',6,'3386',NULL,NULL,NULL,NULL,'2025-06-09',NULL,1,NULL,'ふくしまこうぎょう','こんない　まさのり','福島工業株式会社','近内　正則','千葉県白井市中137-２','047-4922-881',NULL,'鉄骨鉄筋','製造業','千葉県白井市中137-2','鉄骨溶接','２',NULL,NULL,'クレーン　玉掛　溶接','【国内転職】クレーン、玉掛の資格は必須　溶接の資格は必須でなくてもOK\r\n技能実習や特定技能の時、溶接の経験は必須\r\n特定技能の製造の資格のみは面接不可','190000',NULL,NULL,NULL,'10000',NULL,NULL,NULL,'5000','140000',NULL,NULL,'8：00','17：00','12：00～13:00','0',NULL,'277',NULL,NULL,'国籍　インドネシアのみ　9名（特定技能4名在籍）\r\n30代も可\r\n隔週土曜日、日曜、祝日　は　休み\r\n残業はほぼなし、早出無し\r\n勤務は工場のみ\r\n寮費　10000円　特定技能1人一部屋あり（一部共同）\r\n自転車は貸出あり\r\n寮から会社まで20分程度\r\n有給については、夏休みなどの連休と合わせて利用を推奨\r\n毎月給与から1000円旅行代天引き（3年に1回）','株式会社AlphaCep','047-4022-022','牧子 陽子','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'アルファセプ','24登-009405'),
(50,2,NULL,150,'2025-06-13 19:54:51',150,'2025-06-13 19:54:51',NULL,'3412',NULL,NULL,NULL,NULL,'2025-06-14',NULL,NULL,NULL,NULL,NULL,'京都ケータリング株式会社',NULL,'京都府舞鶴市公文名570-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,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(51,2,NULL,150,'2025-06-16 04:42:00',150,'2025-06-16 04:42:00',NULL,'3417',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(52,2,NULL,150,'2025-06-16 11:19:41',150,'2025-06-16 11:19:41',NULL,'3420',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(53,2,NULL,150,'2025-06-16 11:50:17',150,'2025-06-16 11:50:17',NULL,'3423',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(54,2,NULL,150,'2025-06-16 11:53:27',150,'2025-06-16 11:53:27',NULL,'3425',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(55,2,NULL,150,'2025-06-16 11:54:29',150,'2025-06-16 11:54:29',NULL,'3427',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(56,2,NULL,150,'2025-06-16 12:07:35',150,'2025-06-16 12:16:04',1,'3429',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(57,2,NULL,150,'2025-06-16 12:19:18',150,'2025-06-16 12:19:18',NULL,'3431',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(58,2,NULL,150,'2025-06-16 12:25:47',150,'2025-06-16 12:25:47',NULL,'3433',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(59,2,NULL,150,'2025-06-16 12:41:11',150,'2025-06-16 12:41:11',NULL,'3435',NULL,NULL,NULL,NULL,'2025-06-16',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(60,2,NULL,150,'2025-06-17 02:22:03',150,'2025-06-17 02:22:03',NULL,'3440',NULL,NULL,NULL,NULL,'2025-06-17',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(61,2,NULL,150,'2025-06-17 03:20:52',150,'2025-06-17 03:20:52',NULL,'3453',NULL,NULL,NULL,NULL,'2025-06-17',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(62,2,NULL,150,'2025-06-17 08:48:50',150,'2025-06-17 08:52:44',1,'3460',NULL,NULL,NULL,NULL,'2025-06-17',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(63,2,NULL,150,'2025-06-18 04:17:45',150,'2025-06-18 04:17:45',NULL,'3468',NULL,NULL,NULL,NULL,'2025-06-18',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(64,2,NULL,150,'2025-06-18 04:27:44',150,'2025-06-18 04:27:44',NULL,'3470',NULL,NULL,NULL,NULL,'2025-06-18',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(65,2,NULL,136,'2025-06-19 00:57:23',136,'2025-06-19 02:42:15',1,'3477',NULL,NULL,NULL,NULL,'2025-06-19',NULL,1,NULL,'ごうどかいしゃ　はやしこうぎょう','つるい　けんじ','合同会社　林工業','鶴井　賢司','神奈川県横浜市戸塚区舞岡町３０６','090-9381-0009',NULL,'土工工事、グラウト注入工事、足場組立、解体、鉄骨工事、とび工事全般、鍛冶工事','土木・建築','現場による','土木、とび工、鍛冶工','１',NULL,NULL,'特になし','土木・とび工経験者','286000',NULL,'10000','40200','33000','人数で当分',NULL,NULL,NULL,'201100','会社の業績による、昨年度実績無し',NULL,'8：00','17：00','1：00',NULL,NULL,NULL,NULL,'週40時間を超えた場合、残業代が発生',NULL,'株式会社AlphaCep','047-4022-022','牧子 陽子','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'アルファセプ','24登-009405'),
(66,2,NULL,150,'2025-06-19 05:13:15',150,'2025-06-21 03:22:43',1,'3489',NULL,NULL,NULL,NULL,'2025-06-19',NULL,NULL,NULL,'KanGo','（ふりがな）','福島工業株式会社','Nguyen Thanh Luu','千葉県白井市中137-２','047-4922-881',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(67,2,NULL,150,'2025-06-20 20:56:09',150,'2025-06-20 20:56:09',NULL,'3501',NULL,NULL,NULL,NULL,'2025-06-21',NULL,NULL,NULL,'かぶしきかいしゃ　きむらや',NULL,'株式会社きむら家','木村　孝明','東京都渋谷区笹塚１－５９－１０　ＡＣＴＳＯＨＯ京王笹塚ビル','035-3515-519',NULL,'カレーハウスCoCo壱番屋の運営',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','大越 花蓮','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(68,2,NULL,136,'2025-06-09 03:06:35',136,'2025-06-09 07:50:18',6,'3511',NULL,NULL,NULL,NULL,'2025-06-09',NULL,1,NULL,'ふくしまこうぎょう','こんない　まさのり','福島工業株式会社','近内　正則','千葉県白井市中137-２','047-4922-881',NULL,'鉄骨鉄筋','製造業','千葉県白井市中137-2','鉄骨溶接','２',NULL,NULL,'クレーン　玉掛　溶接','【国内転職】クレーン、玉掛の資格は必須　溶接の資格は必須でなくてもOK\r\n技能実習や特定技能の時、溶接の経験は必須\r\n特定技能の製造の資格のみは面接不可','190000',NULL,NULL,NULL,'10000',NULL,NULL,NULL,'5000','140000',NULL,NULL,'8：00','17：00','12：00～13:00','0',NULL,'277',NULL,NULL,'国籍　インドネシアのみ　9名（特定技能4名在籍）\r\n30代も可\r\n隔週土曜日、日曜、祝日　は　休み\r\n残業はほぼなし、早出無し\r\n勤務は工場のみ\r\n寮費　10000円　特定技能1人一部屋あり（一部共同）\r\n自転車は貸出あり\r\n寮から会社まで20分程度\r\n有給については、夏休みなどの連休と合わせて利用を推奨\r\n毎月給与から1000円旅行代天引き（3年に1回）','株式会社AlphaCep','047-4022-022','牧子 陽子','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'アルファセプ','24登-009405'),
(69,2,NULL,136,'2025-07-01 02:42:17',136,'2025-07-01 02:42:17',NULL,'3561',NULL,NULL,NULL,NULL,'2025-07-01',NULL,NULL,NULL,NULL,NULL,'有限会社板倉土木','板倉　孝信','千葉県市川市大野町4-2389-3','047-3385-986','047-3385-827','とび・土工工事業、&nbsp;土木工事業、&nbsp;舗装工事業',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'株式会社AlphaCep','047-4022-022','牧子 陽子','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,NULL,NULL),
(70,2,NULL,136,'2025-07-10 02:38:55',136,'2025-07-10 03:01:18',3,'3607',NULL,NULL,NULL,NULL,'2025-07-10',1,1,NULL,'うえだ',NULL,'上田株式会社',NULL,'栃木県足利市葉鹿町1-30-21','028-4438-918','0284-43-8917','プラスチックを中国・東南アジアへ輸出','製造業','栃木県足利市葉鹿町1丁目30-21','プラスチック成型において、パレット製造、主にフォークリフトを使った作業が多い。細かい作業は少ないです。','2',NULL,NULL,'フォークリフトの資格があれば優遇　資格無くてもOK','日本語があまり話せなくてもOK','250000','1004','5000程度','35000程度','20000','10000',NULL,NULL,NULL,'180000','会社の業績による、昨年度実績無し','要相談','8:00','17:00','1:00','0～2時間','相談可','相談可',NULL,'残業は、繁忙期のみ','・寮は会社の近くにある、自転車で5分、車で2分\r\n・特に休日については、決まっていない、会社と相談して、シフトを決めることが出来る\r\n・面接については、直接面接、ZOOM面接どちらでもOK','株式会社AlphaCep','047-4022-022','牧子 陽子','千葉県鎌ケ谷市北中沢1-18-22スカラビル3F',NULL,NULL,'アルファセプ','24登-009405');

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

CREATE TABLE `et_doc_trainee_consultation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `trainee_consultation_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `trainee_name` varchar(255) DEFAULT NULL,
  `staff_name` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `method_content` varchar(255) DEFAULT NULL,
  `method_date` date DEFAULT NULL,
  `method_staff_name` varchar(255) DEFAULT NULL,
  `leader_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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(20) unsigned NOT NULL AUTO_INCREMENT,
  `national` varchar(255) DEFAULT NULL,
  `jobtype` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `note` text DEFAULT NULL,
  `sign_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint(20) NOT NULL,
  `updated_count` int(11) 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(11) NOT NULL AUTO_INCREMENT,
  `sign_name` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name_leader` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_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(20) NOT NULL AUTO_INCREMENT,
  `doc_trainee_list_id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `note` varchar(255) 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(20) unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) DEFAULT NULL,
  `staff_name` varchar(255) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `number_1` int(11) DEFAULT NULL,
  `number_2` int(11) DEFAULT NULL,
  `number_3` int(11) DEFAULT NULL,
  `number_4` int(11) DEFAULT NULL,
  `number_5` int(11) DEFAULT NULL,
  `number_6` int(11) DEFAULT NULL,
  `number_7` int(11) DEFAULT NULL,
  `number_8` int(11) DEFAULT NULL,
  `number_9` int(11) DEFAULT NULL,
  `number_10` int(11) DEFAULT NULL,
  `number_11` int(11) DEFAULT NULL,
  `number_12` int(11) DEFAULT NULL,
  `number_13` int(11) DEFAULT NULL,
  `number_14` int(11) DEFAULT NULL,
  `number_15` int(11) DEFAULT NULL,
  `number_16` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint(20) NOT NULL,
  `updated_count` int(11) 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(20) unsigned NOT NULL AUTO_INCREMENT,
  `doc_trainee_pledge_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `nationality` varchar(255) 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(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `create_date` date DEFAULT NULL,
  `receipt_number` varchar(255) DEFAULT NULL,
  `customer_director_name` varchar(255) DEFAULT NULL,
  `customer_name_furigana` varchar(255) DEFAULT NULL,
  `customer_postcode` varchar(255) DEFAULT NULL,
  `customer_address` varchar(255) DEFAULT NULL,
  `customer_tel` varchar(255) DEFAULT NULL,
  `customer_director_name_furigana` varchar(255) DEFAULT NULL,
  `customer_company_number` varchar(255) DEFAULT NULL,
  `jobtype_category` varchar(255) DEFAULT NULL,
  `jobtype_name` varchar(255) DEFAULT NULL,
  `work_place_name_furigana` varchar(255) DEFAULT NULL,
  `work_place_name` varchar(255) DEFAULT NULL,
  `work_place_name_address_postcode` varchar(255) DEFAULT NULL,
  `work_place_name_address` varchar(255) DEFAULT NULL,
  `work_place_name_leader_name_furigana` varchar(255) DEFAULT NULL,
  `work_place_name_leader_name` varchar(255) DEFAULT NULL,
  `work_place_name_jobtitle` varchar(255) DEFAULT NULL,
  `training_leader_name_furigana` varchar(255) DEFAULT NULL,
  `training_leader_name` varchar(255) DEFAULT NULL,
  `training_leader_jobtitle` varchar(255) DEFAULT NULL,
  `life_leader_name_furigana` varchar(255) DEFAULT NULL,
  `life_leader_name` varchar(255) DEFAULT NULL,
  `life_leader_jobtitle` varchar(255) DEFAULT NULL,
  `trainee_name_romaji` varchar(255) DEFAULT NULL,
  `trainee_name_kanji` varchar(255) DEFAULT NULL,
  `trainee_nationality` varchar(255) DEFAULT NULL,
  `trainee_birthdate` date DEFAULT NULL,
  `trainee_yearold` int(11) DEFAULT NULL,
  `trainee_sex` int(11) DEFAULT NULL COMMENT '1 男 , 2 女',
  `returncountry_period` varchar(255) DEFAULT NULL,
  `returncountry_period_datefrom` date DEFAULT NULL,
  `returncountry_period_dateto` date DEFAULT NULL,
  `trainee_type` int(11) DEFAULT NULL COMMENT '1 Ａ(第一号企業単独型技能実習); 2 Ｄ(第一号団体監理型技能実習);\r\n3 Ｂ(第二号企業単独型技能実習); 4 Ｅ(第二号団体監理型技能実習);\r\n5 Ｃ(第三号企業単独型技能実習); 6 Ｆ(第三号団体監理型技能実習)',
  `trainee_jobtype_number` varchar(255) DEFAULT NULL,
  `trainee_jobtype_name` varchar(255) DEFAULT NULL,
  `trainee_jobtype_workname` varchar(255) DEFAULT NULL,
  `trainee_jobtype_number_2` varchar(255) DEFAULT NULL,
  `trainee_jobtype_name_2` varchar(255) DEFAULT NULL,
  `trainee_jobtype_workname_2` varchar(255) DEFAULT NULL,
  `trainee_jobtype_other` varchar(255) DEFAULT NULL,
  `training_before_japan` int(11) DEFAULT NULL COMMENT '1:有   2: 無',
  `has_test` int(11) DEFAULT NULL,
  `has_test_name` varchar(255) DEFAULT NULL,
  `has_test_level` varchar(255) DEFAULT NULL,
  `has_evaluate` int(11) DEFAULT NULL,
  `has_evaluate_name` varchar(255) DEFAULT NULL,
  `has_evaluate_level` varchar(255) DEFAULT NULL,
  `has_test_other` int(11) DEFAULT NULL,
  `has_test_content` varchar(255) DEFAULT NULL,
  `has_test_goal` int(11) DEFAULT NULL,
  `has_test_goal_name` varchar(255) DEFAULT NULL,
  `has_test_goal_level` varchar(255) DEFAULT NULL,
  `has_evaluate_goal` int(11) DEFAULT NULL,
  `has_evaluate_goal_name` varchar(255) DEFAULT NULL,
  `has_evaluate_goal_level` varchar(255) DEFAULT NULL,
  `has_test_goal_other` int(11) DEFAULT NULL,
  `has_test_goal_content` varchar(255) DEFAULT NULL,
  `before_step_receipt_number` varchar(255) DEFAULT NULL,
  `extend_period` varchar(255) DEFAULT NULL,
  `extend_period_datefrom` date DEFAULT NULL,
  `extend_period_tofrom` date DEFAULT NULL,
  `extend_period_count_time` int(11) DEFAULT NULL,
  `extend_period_learning_time` time DEFAULT NULL,
  `extend_period_training_time` time DEFAULT NULL,
  `company_license_number` varchar(255) DEFAULT NULL,
  `company_type` int(11) DEFAULT NULL COMMENT '1: 一般監理事業, 2: 特定監理事業',
  `company_name_furigana` varchar(255) DEFAULT NULL,
  `company_postcode` varchar(255) DEFAULT NULL,
  `company_address` varchar(255) DEFAULT NULL,
  `company_tel` varchar(255) DEFAULT NULL,
  `company_director_name` varchar(255) DEFAULT NULL,
  `company_director_name_furigana` varchar(255) DEFAULT NULL,
  `company_leader_name` varchar(255) DEFAULT NULL,
  `company_leader_name_furigana` varchar(255) DEFAULT NULL,
  `company_workplace_name` varchar(255) DEFAULT NULL,
  `company_workplace_name_furigana` varchar(255) DEFAULT NULL,
  `company_workplace_postcode` varchar(255) DEFAULT NULL,
  `company_workplace_address` varchar(255) DEFAULT NULL,
  `plan_created_by_name` varchar(255) DEFAULT NULL,
  `plan_created_by_name_furigana` varchar(255) DEFAULT NULL,
  `sending_agency_name` text DEFAULT NULL,
  `sending_agency_number` text DEFAULT NULL,
  `sending_agency_ref_number` text DEFAULT NULL,
  `salary_type` int(11) DEFAULT NULL COMMENT '1月給, 2 日給, 3 時給',
  `salary_money` int(11) DEFAULT NULL,
  `salary_learning_money` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint(20) NOT NULL,
  `updated_count` int(11) NOT NULL DEFAULT 0,
  `salary_other` int(11) 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(11) DEFAULT NULL,
  `work_week_counttime` int(11) DEFAULT NULL,
  `holiday_note` text DEFAULT NULL,
  `vacation_note` text DEFAULT NULL,
  `dormitory_note` text DEFAULT NULL,
  `meal_money` int(11) DEFAULT NULL,
  `dormitory_money` int(11) DEFAULT NULL,
  `other_money` int(11) DEFAULT NULL,
  `note_contract` text DEFAULT NULL,
  `note_type` int(11) DEFAULT NULL COMMENT '1 有,  0 無',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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),
(3,'2024-12-04','666',NULL,'2024-12-07','555','111','777','888','999','100','222','333','100','111','22',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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(11) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `number` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_name_furigana` varchar(255) DEFAULT NULL,
  `customer_postcode` varchar(255) DEFAULT NULL,
  `customer_address` varchar(255) DEFAULT NULL,
  `customer_tel` varchar(255) DEFAULT NULL,
  `office_branch_name` varchar(255) DEFAULT NULL,
  `office_branch_name_furigana` varchar(255) DEFAULT NULL,
  `office_branch_postcode` varchar(255) DEFAULT NULL,
  `office_branch_address` varchar(255) DEFAULT NULL,
  `office_branch_tel` varchar(255) 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 DEFAULT NULL,
  `improve_content` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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(11) NOT NULL AUTO_INCREMENT,
  `name_furigana` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL COMMENT '1: male, 2:female',
  `birthdate` date DEFAULT NULL,
  `postcode` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `tel` varchar(255) DEFAULT NULL,
  `work_name` varchar(255) DEFAULT NULL,
  `work_postcode` varchar(255) DEFAULT NULL,
  `work_address` varchar(255) DEFAULT NULL,
  `work_tel` varchar(255) DEFAULT NULL,
  `business_title` varchar(255) DEFAULT NULL,
  `certificate` varchar(255) DEFAULT NULL,
  `job_resume` varchar(255) DEFAULT NULL,
  `job_resume_old` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_company_name` varchar(255) DEFAULT NULL,
  `sign_director_name` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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,5);

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

CREATE TABLE `et_doc_training_report_daily` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `month` varchar(8) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `company_name` varchar(255) DEFAULT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_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);

--
-- Table structure for table `et_doc_training_report_daily_detail`
--

CREATE TABLE `et_doc_training_report_daily_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `training_report_daily_id` int(11) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `job_content` varchar(255) DEFAULT NULL,
  `job_content_no` varchar(255) DEFAULT NULL,
  `job_asign_content` varchar(255) DEFAULT NULL,
  `leader_name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_training_report_daily_detail`
--

INSERT INTO `et_doc_training_report_daily_detail` VALUES
(1,1,'2024-07-16','JOB_CONTENT','JOB_CONTENT_NO','JOB_ASIGN_CONTENT','LEADER_NAME'),
(2,2,'2024-09-01','JOB_CONTENT','JOB_CONTENT_NO','JOB_ASIGN_CONTENT','LEADER_NAME');

--
-- Table structure for table `et_doc_training_report_daily_name`
--

CREATE TABLE `et_doc_training_report_daily_name` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `training_report_daily_id` int(11) DEFAULT NULL,
  `no` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_training_report_daily_name`
--

INSERT INTO `et_doc_training_report_daily_name` VALUES
(1,1,1,'NAME','TYPE','2024-07-25','2024-07-10','test'),
(2,2,1,'NAME','TYPE','2024-09-02','2024-09-11','test'),
(3,2,NULL,'test','123','2024-09-12','2024-09-12','123');

--
-- Table structure for table `et_doc_trainning_reason`
--

CREATE TABLE `et_doc_trainning_reason` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `job_type_id` int(11) DEFAULT NULL,
  `test_not_device_note` varchar(255) DEFAULT NULL,
  `reason` text DEFAULT NULL,
  `job_type_id2` int(11) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` int(11) DEFAULT NULL,
  `updated_count` int(11) NOT NULL DEFAULT 0,
  `created_by` varchar(254) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_trainning_reason`
--

INSERT INTO `et_doc_trainning_reason` VALUES
(1,4,'test_not_device','reason REST\r\nTEST \r\nTEST TEST \r\nTEST TEST TEST TEST \r\nTSET TEST TEST TEST TEST\r\nTSET TEST TEST TEST TESTTSET TEST TEST TEST TESTTSET TEST TEST TEST TEST \r\nTSET TEST TEST TEST TEST',6,'TEST',NULL,NULL,NULL,NULL,NULL,0,NULL),
(2,4,'test444','test12345',3,'hi',NULL,NULL,NULL,NULL,NULL,0,'test');

--
-- Table structure for table `et_doc_transfer_declaration`
--

CREATE TABLE `et_doc_transfer_declaration` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `transfer_reason_type` int(11) DEFAULT NULL COMMENT '1:技能実習期間の末日が休日であること   2: その他',
  `transfer_reason_note` varchar(255) DEFAULT NULL,
  `deadline_date` date DEFAULT NULL,
  `transfer_date` date DEFAULT NULL,
  `person_type` int(11) DEFAULT NULL COMMENT ' 1: 監理団体,  2:実習実施者',
  `person_name` varchar(255) DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) DEFAULT NULL,
  `note` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint(20) DEFAULT NULL,
  `updated_at` int(11) DEFAULT NULL,
  `updated_by_id` bigint(20) DEFAULT NULL,
  `company_id` bigint(20) DEFAULT NULL,
  `updated_count` int(11) 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_transfer_declaration`
--

INSERT INTO `et_doc_transfer_declaration` VALUES
(1,1,'Noteｖｚｖｚｘｃｖｚｃｖ','2024-05-30','2024-06-01',1,'ｄｄｓｆさｄｆ','2024-05-31','ええええええ',NULL,NULL,NULL,NULL,1,1,2),
(2,2,'note  test 12345677890','2024-06-21','2024-06-21',2,'test','2024-06-10','DDANG DINH TIEP',NULL,NULL,NULL,NULL,1,1,5),
(3,2,'note nnote','2024-09-01','2024-09-05',1,'test','2024-09-06','sign_name',NULL,NULL,NULL,NULL,1,1,2);

--
