-- Dumping data for table `et_candidate_curriculumvitae`
--

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_comment` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `status` int DEFAULT NULL,
  `date` date DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `table_record_id` int DEFAULT NULL,
  `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `company_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

--
-- Table structure for table `et_comment_file`
--

CREATE TABLE `et_comment_file` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `comment_id` bigint unsigned DEFAULT NULL,
  `file_id` bigint unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_comment_file`
--


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

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

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

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

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

CREATE TABLE `et_doc_application_cancel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `request_date` date DEFAULT NULL,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `cancel_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_cert_application_fee` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created_date` date DEFAULT NULL,
  `money` int DEFAULT NULL,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `check_3` int DEFAULT NULL,
  `check_4` int DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `et_doc_certificate_filelist` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int DEFAULT NULL,
  `trainee_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` int DEFAULT NULL,
  `support_test_type` int DEFAULT NULL,
  `support_test_date` date DEFAULT NULL,
  `number_1` int DEFAULT NULL,
  `number_2` int DEFAULT NULL,
  `number_3` int DEFAULT NULL,
  `number_4` int DEFAULT NULL,
  `number_5` int DEFAULT NULL,
  `number_6` int DEFAULT NULL,
  `number_7` int DEFAULT NULL,
  `number_8` int DEFAULT NULL,
  `number_9` int DEFAULT NULL,
  `number_10` int DEFAULT NULL,
  `number_11` int DEFAULT NULL,
  `number_12` int DEFAULT NULL,
  `number_13` int DEFAULT NULL,
  `number_14` int DEFAULT NULL,
  `number_15` int DEFAULT NULL,
  `number_16` int DEFAULT NULL,
  `number_17` int DEFAULT NULL,
  `number_18` int DEFAULT NULL,
  `number_19` int DEFAULT NULL,
  `number_20` int DEFAULT NULL,
  `number_21` int DEFAULT NULL,
  `number_22` int DEFAULT NULL,
  `number_23` int DEFAULT NULL,
  `number_24` int DEFAULT NULL,
  `number_25` int DEFAULT NULL,
  `number_26` int DEFAULT NULL,
  `number_27` int DEFAULT NULL,
  `number_28` int DEFAULT NULL,
  `number_29` int DEFAULT NULL,
  `number_30` int DEFAULT NULL,
  `number_31` int DEFAULT NULL,
  `number_32` int DEFAULT NULL,
  `number_33` int DEFAULT NULL,
  `number_34` int DEFAULT NULL,
  `number_35` int DEFAULT NULL,
  `number_36` int DEFAULT NULL,
  `number_37` int DEFAULT NULL,
  `number_38` int DEFAULT NULL,
  `number_39` int DEFAULT NULL,
  `number_40` int DEFAULT NULL,
  `number_41` int DEFAULT NULL,
  `number_42` int DEFAULT NULL,
  `number_43` int DEFAULT NULL,
  `number_44` int DEFAULT NULL,
  `number_45` int DEFAULT NULL,
  `number_46` int DEFAULT NULL,
  `number_47` int DEFAULT NULL,
  `number_48` int DEFAULT NULL,
  `number_49` int DEFAULT NULL,
  `number_50` int DEFAULT NULL,
  `number_51` int DEFAULT NULL,
  `number_52` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_certificate_filelist`
--

INSERT INTO `et_doc_certificate_filelist` VALUES (1,'sfg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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);

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

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

--
-- Dumping data for table `et_doc_certificate_residence`
--

INSERT INTO `et_doc_certificate_residence` VALUES (1,'国 籍・地 域','2024-08-14','test',1,'viet name',1,'occupation','home_town','address_japan','tel','cellular_tel','passport_number','2024-01-01',1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,'2024-09-12','port_entry','intended_stay',123,'intended_visa',1,5,'2024-09-06','2024-09-13',1,3,5,'criminal_record','criminal_record_detail',3,5,'2024-09-05','implementing_organization_name','implementing_organization_name','implementing_organization_tel','organization_supervising_name','organization_supervising_address','organization_supervising_tel','applicant_name','relationship_applicant','applicant_address','applicant_tel','applicant_cellular_phone','sign_name','2024-09-14','agent_name','agent_address','agent_organization','agent_tel','certificate_residence.trainee_name','trainee_accreditation_no','2024-09-05',1,1,1,1,1,1,1,'trainee_occupation_chk_1_detail',1,'trainee_occupation_chk_2_detail','2024-09-06','2024-09-26','2024-09-26','2024-09-11','company_place_name','521234455','company_employment_insurance',1,'company_business_type_1_value',1,'company_business_type_multi_value','company_business_address','company_business_tel',10000,'300','2024-09-17','organization_supervising_name2','10023455','1111111122',1,'organization_supervising_business_type_1_value',1,'organization_supervising_business_type_multi_value','organization_supervising_address2','organization_supervising_tel2',1,1,'111111111111','2024-09-20','2024-09-19','2024-09-12','sign_organization_supervising_name','2024-09-13',NULL,NULL,1,NULL,1,12),(2,'ベトナム','1999-02-24','東京株式会社',2,'ベトナム',2,'建設','ハノイ、ベトナム',NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'THUY','1230000','2025-02-23',1,0,0,0,0,0,0,'16',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,0,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,0);

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

CREATE TABLE `et_doc_certification_plan_management` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `check_1_1` tinyint(1) DEFAULT NULL,
  `check_1_2_a` tinyint(1) DEFAULT NULL,
  `check_1_2_b` tinyint(1) DEFAULT NULL,
  `check_1_2_c` tinyint(1) DEFAULT NULL,
  `check_1_3` tinyint(1) DEFAULT NULL,
  `check_1_4` tinyint(1) DEFAULT NULL,
  `check_1_5` tinyint(1) DEFAULT NULL,
  `check_1_6` tinyint(1) DEFAULT NULL,
  `check_2_1` tinyint(1) DEFAULT NULL,
  `check_2_2` tinyint(1) DEFAULT NULL,
  `check_2_3` tinyint(1) DEFAULT NULL,
  `check_2_3_1` tinyint(1) DEFAULT NULL,
  `check_2_3_2` tinyint(1) DEFAULT NULL,
  `check_2_3_3` tinyint(1) DEFAULT NULL,
  `check_2_3_4` tinyint(1) DEFAULT NULL,
  `check_2_3_4_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_supervisor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `et_doc_customer_brief` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_plan_check` int DEFAULT NULL,
  `training_implement_receipt_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `labor_insurance_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `employee_number` varchar(255) DEFAULT NULL,
  `trainee_number_1` int DEFAULT NULL,
  `trainee_number_2` int DEFAULT NULL,
  `trainee_number_3` int DEFAULT NULL,
  `number_1st` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_1st_old` int DEFAULT NULL,
  `number_from1_2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_from1_2_old` int DEFAULT NULL,
  `number_from2_3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `number_from2_3_old` int DEFAULT NULL,
  `number_disappear` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_edu_brief` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `center_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_mail` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `establishment_date` date DEFAULT NULL,
  `center_type` int DEFAULT NULL COMMENT '1: 大学, 2: 高校, 3: 職業訓練校, 4: その他',
  `center_university_dep_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `center_type_other` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `edu_content` varchar(6000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jobtype_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_center_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `et_doc_evaluation_trainee` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthdate` date DEFAULT NULL,
  `trainer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL,
  `national` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `test_date` date DEFAULT NULL,
  `test_result` tinyint(1) DEFAULT NULL COMMENT '1: 合格 ; 0: 不合格',
  `reason_not_test` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_teacher` varchar(6000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_life_coach` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `evaluate_supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `evaluate_trainer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_trainer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_supervisor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  `y` int DEFAULT NULL,
  `pl` text,
  `n_w` text,
  `n_s` text,
  `n_p` text,
  `n_t` text,
  `y1` int DEFAULT NULL,
  `pn_` text,
  `nd_` text,
  `at_` text,
  `na_` text,
  `nt_` text,
  `nwd` varchar(100) DEFAULT NULL,
  `attendance` varchar(100) DEFAULT NULL,
  `ph` varchar(100) DEFAULT NULL,
  `noda` varchar(100) DEFAULT NULL,
  `ptd` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

INSERT INTO `et_doc_evaluation_trainee` VALUES (5,'VO　THI THU THUY','東京都','1987-12-10','有限会社 ○○工業','介護',1,'ベトナム','ABC会社','AAAAA','2024-12-12',0,'入国当初は日本語能力が高くなく、技能実習指導員による指導の理解も思うように進まなかったせいか、やや自信なげな様子で作業して\r\nおり、','入国当初は日本語能力が高くなく、技能実習指導員による指導の理解も思うように進まなかったせいか、やや自信なげな様子で作業して\r\nおり、','入国当初は日本語能力が高くなく、技能実習指導員による指導の理解も思うように進まなかったせいか、やや自信なげな様子で作業して\r\nおり、','入国当初は日本語能力が高くなく、技能実習指導員による指導の理解も思うように進まなかったせいか、やや自信なげな様子で作業して\r\nおり、','入国当初は日本語能力が高くなく、技能実習指導員による指導の理解も思うように進まなかったせいか、やや自信なげな様子で作業して\r\nおり、','2024-12-12','hirosi','yama','SUZUKI','take',NULL,NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,'asdasd','Tokyo出入国在留管理局長','2024-12-12','あんな','介護',1,'中国','ABC会社','AAAAA','2024-12-11',0,'agdlaghfa;ljfa;fj','hfa;fhal;fj;a\'f','daldha;f;af','afga;fha;f','adgaldfha;fa','2024-12-13','有限会社 ○○工業','yama','SUZUKI','take',NULL,NULL,NULL,1,1,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'asdasd','DIRECTORY NAME','2024-12-12','asdasd','asdasd',1,'asdasd','0','介護','2024-12-31',0,'携帯電話を使ったため','良かった','良かった','良かった','良かった','2024-12-31','竹内','武田','竹田','スズキ株式会社',NULL,NULL,NULL,1,1,12,23,'[30,20,20,20,20,20,20,20,20,20,20,20]','[20,20,20,20,20,20,20,20,20,20,20,20]','[67,100,85,100,100,100,100,100,100,100,100,100]','[5,1,1,0,0,0,0,0,0,0,0,0]','[\"5\",null,\"2\",null,null,null,null,null,null,null,null,null]',24,'[20,20,20,20,20,20,20,20,20,20,20,20]','[18,20,20,20,20,20,20,20,20,20,20,20]','[90,100,100,100,100,100,100,100,100,100,100,100]','[1,1,0,0,0,0,0,0,0,0,0,0]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','481','98.163265306122','490','9','490'),(8,'ボチトウトウイ','Tokyo出入国在留管理局長','2000-12-24','有限会社 ○○工業','建設',1,'ベトナム','ABC会社','AAAAA','2024-12-24',0,'adgdfjhkkbgjfh','dfsgdfhfdgh','fhdhcjchdxc','hbchcmvj','fhxdhcgjvbj','2024-12-30','有限会社 ○○工業','yama','SUZUKI','take',NULL,NULL,NULL,151,1,10,23,'[30,20,30,30,30,20,20,25,25,25,25,25]','[20,20,20,20,20,20,20,20,20,20,20,20]','[99,97,100,100,100,100,100,100,100,100,100,100]','[1,2,0,0,0,0,0,0,0,0,0,0]','[\"1\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"]',24,'[20,20,20,20,20,20,20,20,20,20,20,20]','[18,20,20,20,20,20,20,20,20,20,20,20]','[95,100,100,100,100,100,100,100,100,100,100,100]','[2,0,0,0,0,0,0,0,0,0,0,0]','[\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\",\"0\"]','540','99.08','545','5','545');

--
-- Table structure for table `et_doc_exp_remuneration_foreign_workers`
--

CREATE TABLE `et_doc_exp_remuneration_foreign_workers` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name_applicant` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `level_responsibility` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age` int DEFAULT NULL,
  `male_female` tinyint DEFAULT NULL,
  `experience_years` int DEFAULT NULL,
  `monthly_salary` bigint DEFAULT NULL,
  `hourly_salary` bigint DEFAULT NULL,
  `others` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age1` int DEFAULT NULL,
  `male_female1` tinyint DEFAULT NULL,
  `experience_years1` int DEFAULT NULL,
  `monthly_salary1` bigint DEFAULT NULL,
  `hourly_wage` bigint DEFAULT NULL,
  `yes_no` tinyint DEFAULT NULL,
  `monthly_salary2` bigint DEFAULT NULL,
  `hourly_salary2` bigint DEFAULT NULL,
  `reasons` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `others2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `job_description3` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `age3` int DEFAULT NULL,
  `male_female3` tinyint DEFAULT NULL,
  `experience_years3` int DEFAULT NULL,
  `monthly_salary3` bigint DEFAULT NULL,
  `hourly_salary3` bigint DEFAULT NULL,
  `yes_no3` tinyint DEFAULT NULL,
  `monthly_salary4` bigint DEFAULT NULL,
  `hourly_salary4` bigint DEFAULT NULL,
  `reasons3` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `others3` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `responsible_person` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `et_doc_exp_remuneration_foreign_workers`
--

INSERT INTO `et_doc_exp_remuneration_foreign_workers` VALUES (1,'dsfgdsifugsdifu','0',0,0,0,0,0,'0','0',0,0,0,0,0,0,0,0,'0','0','0',0,0,0,0,0,0,0,0,'0','0','2024-10-28','0','0','2024-10-28 02:26:30',NULL,1,'2024-10-28 02:45:16',1,1);

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

CREATE TABLE `et_doc_expenses_paid_trainee` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name_romaji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_receipt_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_sending_agency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_sending_agency_receipt_no` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `trainee_sign_date` date DEFAULT NULL,
  `trainee_sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `et_doc_explanation_during_training` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_romaji` varchar(255) DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_paid_yesno` tinyint(1) DEFAULT NULL,
  `learning_paid_money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learning_paid_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_paid_yesno` tinyint(1) DEFAULT NULL,
  `meal_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_trainer_paid_yesno` tinyint(1) DEFAULT NULL,
  `meal_trainer_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meal_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_paid_yesno` tinyint(1) DEFAULT NULL,
  `house_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_trainer_paid_yesno` tinyint(1) DEFAULT NULL,
  `house_trainer_paid_yes_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_type` tinyint(1) DEFAULT NULL,
  `house_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_size` float DEFAULT NULL,
  `house_number` int DEFAULT NULL,
  `house_oneperson_size` float DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `other_note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `date` date DEFAULT NULL,
  `description_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_relationship` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

--
-- Table structure for table `et_doc_explanation_fees_trainee`
--

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

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

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

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

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

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

INSERT INTO `et_doc_explanation_of_circumstances` VALUES (1,'てゅｙ','あｂｆ；あｈふぁ','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ああｈふぁｆｇｊｓ’ｇｐｈｋｈ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','ｇふぁ；ｌｈｆ’；あｇｆｊ’ｇ￥','082-942-0111','2025-01-16',0,0,1,1,0,0,0,'OOOOOOOO','TTTTTTTT','2025-01-21',NULL,NULL,151,NULL,1,7,'abs会社');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `et_doc_notification_acceptance_activity_status` VALUES (1,'2024','1030001082950','建設分野','しまだ けんこう かぶしきがいしゃ','埼玉県川口市木曽呂１６７番地の３','048－452－8015',1,NULL,1,NULL,NULL,NULL,1,NULL,1,NULL,NULL,1,NULL,1,NULL,NULL,NULL,1,NULL,'ABC会社','上野','058-789-1555','アン','2025-01-01',NULL,NULL,151,NULL,1,21,'島田建工 株式会社','333－0831','[\"1\",null,null,null,null]','[\"0\",null,null]','[\"3\",null,null]','[null,\"1\",null]','[null,null,null]','[null,null,null]','[\"4\",\"1\",null]','4','','30000','1',NULL,NULL,NULL,NULL,NULL,'','入江省吾','代表取締役','048-452-8015',NULL),(2,'2025','01234567890','外食業分野','かぶしきがいしゃ にゅうかん','東京都港区港南５丁目５番３０号','０３５７９６７１２５',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,150,NULL,2,3,'株式会社 入管','１０８８２５５','[null,\"[null,null,null]\",null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','[null,null,null]','1','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,NULL,NULL);

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

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

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

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

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

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

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

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

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

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

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

INSERT INTO `et_doc_notification_resumption_support_services` VALUES (1,'registration_number',1,1,2,2,3,3,4,4,5,5,6,6,7,'name_the_institution','agency_address','responsible','telephone_number','2024-11-11','fsdfsdf','2024-03-12','2024-10-14 12:54:01',NULL,1,'2024-10-14 13:09:30',1,1,NULL),(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),(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);

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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_returncountry_declaration` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reason_type` int DEFAULT NULL COMMENT '1:帰国便都合, 2:技能実習期間の末日が休日である, 3:その他',
  `reason_other_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deadline_date` date DEFAULT NULL,
  `return_date` date DEFAULT NULL,
  `person_type` int DEFAULT NULL COMMENT ' 1: 監理団体  2:実習実施者',
  `person_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_sending_agency_oath` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sending_agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sending_agency_number_ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

CREATE TABLE `et_doc_sending_agency_overview` (
  `id` int NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `establish_date` date DEFAULT NULL,
  `business_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capital_yen` int DEFAULT NULL,
  `earning_money` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `earning_money_yen` int DEFAULT NULL,
  `staff_number` varchar(255) DEFAULT NULL,
  `leader_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jp_staff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_sending_agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

CREATE TABLE `et_doc_similar_job_description` (
  `id` int NOT NULL AUTO_INCREMENT,
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `check_3` tinyint(1) DEFAULT NULL,
  `check_4` tinyint(1) DEFAULT NULL,
  `check_5` tinyint(1) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `et_doc_specific_skills_employ_contract` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `specific_skills_affiliation_agency` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specified_skilled_foreigners` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `second` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 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);

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

CREATE TABLE `et_doc_staff_cv` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `staff_incharge_id` int DEFAULT NULL,
  `staff_instructor_gino_id` int DEFAULT NULL,
  `staff_instuctor_life_id` int DEFAULT NULL,
  `staff_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_birthdate` date DEFAULT NULL,
  `staff_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_technical_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_birthdate` date DEFAULT NULL,
  `instructor_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `instructor_technical_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_furigana` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_birthdate` date DEFAULT NULL,
  `life_instructor_national` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_degree` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `life_instructor_technical_training` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `applicant_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_technical` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `sign_staff_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_life_instructor_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_staff_cv`
--

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_supervisor_cv` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `sex` int DEFAULT NULL COMMENT '1:male, 2:female',
  `birthdate` date DEFAULT NULL,
  `nationality` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_cv` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_sermina_cv` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_creator_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_creator_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

CREATE TABLE `et_doc_support_plan_reference` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` datetime DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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);

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

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

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

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

--
-- Table structure for table `et_doc_terms_of_employment`
--

CREATE TABLE `et_doc_terms_of_employment` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `temple` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_specific_skills_orgzation` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone_number` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `representative` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_from_date_1` date DEFAULT NULL,
  `date_to_date_1` date DEFAULT NULL,
  `intended_date_entry` date DEFAULT NULL,
  `update_auto` tinyint(1) DEFAULT NULL,
  `may_update` tinyint(1) DEFAULT NULL,
  `my_contract` tinyint(1) DEFAULT NULL,
  `work_volume` tinyint(1) DEFAULT NULL,
  `worker_performance` tinyint(1) DEFAULT NULL,
  `worker_perform` tinyint(1) DEFAULT NULL,
  `company_management` tinyint(1) DEFAULT NULL,
  `progress_work` tinyint(1) DEFAULT NULL,
  `others` tinyint(1) DEFAULT NULL,
  `text_others` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `temple_date` date DEFAULT NULL,
  `direct_hire` tinyint(1) DEFAULT NULL,
  `following_system_start_of_work1` time DEFAULT NULL,
  `business_name1` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_address1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `dis_emp` tinyint(1) DEFAULT NULL,
  `no_change1` tinyint(1) DEFAULT NULL,
  `business_name2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_address2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `field1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_differen1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `no_change2` tinyint(1) DEFAULT NULL,
  `field2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `business_differen2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `start_of_work_time` time DEFAULT NULL,
  `end_of_work_time` time DEFAULT NULL,
  `scheduled_working_hours_time` time DEFAULT NULL,
  `variable_working` tinyint(1) DEFAULT NULL,
  `variable_working_text` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `working_hours` tinyint(1) DEFAULT NULL,
  `following_system_end_of_work1` time DEFAULT NULL,
  `effective_date1` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `scheduled_working_hours_day1` time DEFAULT NULL,
  `following_system_start_of_work1_1` time DEFAULT NULL,
  `following_system_end_of_work2` time NOT NULL,
  `effective_date2` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `scheduled_working_hours_day2` time DEFAULT NULL,
  `following_system_start_of_work3` time DEFAULT NULL,
  `following_system_end_of_work3` time DEFAULT NULL,
  `effective_date3` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `scheduled_working_hours_day3` time DEFAULT NULL,
  `break_time_minutes` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `scheduled_working_hours_week` text COLLATE utf8mb4_general_ci,
  `scheduled_working_hours_month` text COLLATE utf8mb4_general_ci,
  `scheduled_working_hours_year` text COLLATE utf8mb4_general_ci,
  `scheduled_working_days_week` text COLLATE utf8mb4_general_ci,
  `overtime_work_available_have_none` tinyint DEFAULT NULL,
  `every_weekday` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `others_regular_day` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total_number_holidays_per_year` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `regular_day_day` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `non_regular_week_month` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `non_regular_others_days` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `annual_paid_leave_day` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `months_have_passed` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `annual_paid_leave_have_none` tinyint DEFAULT NULL,
  `paid_leave` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `unpaid` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_salary1` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `circle1` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_salary2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `circle2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `time_to_give` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `circle3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_excess_hours` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_excess_month` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `over_the_specified_limit` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_holidays` varchar(250) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `holidays` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `late_night` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_day1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_day2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_day3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_day4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `direct_deposit` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `currency_payment` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `deductions_none_have` tinyint DEFAULT NULL,
  `salary_increase_have1` tinyint(1) DEFAULT NULL,
  `amount_etc1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `salary_increase_none1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `salary_increase_have2` tinyint(1) DEFAULT NULL,
  `amount_etc2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `salary_increase_none2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `severance_pay_have1` tinyint(1) DEFAULT NULL,
  `amount_etc3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `salary_increase_none3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `leave_allowance` tinyint(1) DEFAULT NULL,
  `rate` tinyint(1) DEFAULT NULL,
  `employee_pension_insurance` tinyint(1) DEFAULT NULL,
  `health_insurance` tinyint(1) DEFAULT NULL,
  `employment_insurance` tinyint(1) DEFAULT NULL,
  `compensation_insurance` tinyint(1) DEFAULT NULL,
  `national_pension` tinyint(1) DEFAULT NULL,
  `national_health_insurance` tinyint(1) DEFAULT NULL,
  `others9` tinyint(1) DEFAULT NULL,
  `text_others9` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `upon_employment_year` int DEFAULT NULL,
  `upon_employment_month` int DEFAULT NULL,
  `health_check_year` int DEFAULT NULL,
  `health_check_month` int DEFAULT NULL,
  `after_that` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `department_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_position` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_address` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `recipient` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `monthly_salary` tinyint(1) DEFAULT NULL,
  `circle_basic_wage1` int DEFAULT NULL,
  `daily_allowance` tinyint(1) DEFAULT NULL,
  `circle_basic_wage2` int DEFAULT NULL,
  `time_give` tinyint(1) DEFAULT NULL,
  `circle_basic_wage3` int DEFAULT NULL,
  `hourly_rate_wage` int DEFAULT NULL,
  `monthly_amount_wage` int DEFAULT NULL,
  `allowance1_2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `all_circle_1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `calculation_method1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance2_2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `all_circle_2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `calculation_method2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance3_2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `all_circle_3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `calculation_method3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `all_circle_4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `calculation_method4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `allowance5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `all_circle_5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `overtime_allowance` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `for_overtime` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tax` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gold` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_a` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `social_insurance_premiums` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_b` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `employment_insurance_premiums` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_c` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `food_expenses` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_d` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `residence_fee` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_e` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_f_1` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `others_f_1` varchar(150) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_f_2` text COLLATE utf8mb4_general_ci,
  `others_f_2` text COLLATE utf8mb4_general_ci,
  `about_circle_f_3` text COLLATE utf8mb4_general_ci,
  `others_f_3` text COLLATE utf8mb4_general_ci,
  `about_circle_f_4` text COLLATE utf8mb4_general_ci,
  `others_f_4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_f_5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `others_f_5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_f_6` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `amount_deducted` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `about_circle_total` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_title_1` date DEFAULT NULL,
  `temple_2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `namespecific_skill_organization_5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location_5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `telephone_number_5` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `title_and_name` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `direct_hire_5` tinyint(1) DEFAULT NULL,
  `business_name_5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `location_5_1` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `contact_address_5` text COLLATE utf8mb4_general_ci,
  `dispatch_5` tinyint(1) DEFAULT NULL,
  `no_change_5` tinyint(1) DEFAULT NULL,
  `business_name_5_1` text COLLATE utf8mb4_general_ci,
  `location_5_1_2` text COLLATE utf8mb4_general_ci,
  `contact_address_5_1` text COLLATE utf8mb4_general_ci,
  `field_5_1` text COLLATE utf8mb4_general_ci,
  `business_differen_5_1` text COLLATE utf8mb4_general_ci,
  `no_change_possible_5` text COLLATE utf8mb4_general_ci,
  `field_5_2` text COLLATE utf8mb4_general_ci,
  `business_differen_5_2` text COLLATE utf8mb4_general_ci,
  `start_of_work_start1` time DEFAULT NULL,
  `start_of_work_end1` time DEFAULT NULL,
  `scheduled_working_hours_per_day_time` time DEFAULT NULL,
  `variable_working_hours_system` tinyint(1) DEFAULT NULL,
  `variable_working_hours_system_units` text COLLATE utf8mb4_general_ci,
  `as_shift_system` tinyint(1) DEFAULT NULL,
  `start_of_work_as_shift_system1` time DEFAULT NULL,
  `start_of_work_as_shift_system2` time DEFAULT NULL,
  `effective_date_as_shift_system1` time DEFAULT NULL,
  `contact_address_5_1_2` text COLLATE utf8mb4_general_ci,
  `start_of_work_as_shift_system4_1` time DEFAULT NULL,
  `start_of_work_as_shift_system5` time DEFAULT NULL,
  `effective_date_as_shift_system3` time(1) DEFAULT NULL,
  `scheduled_working_as_shift_system3` time DEFAULT NULL,
  `break_time_minutes_1` int DEFAULT NULL,
  `start_of_work_start1_2` time DEFAULT NULL,
  `start_of_work_end1_2` time DEFAULT NULL,
  `scheduled_working_hours_per_day_time_1` time DEFAULT NULL,
  `variable_working_hours_system_1` tinyint(1) DEFAULT NULL,
  `variable_working_hours_system_units_1` text COLLATE utf8mb4_general_ci,
  `as_shift_system_1` tinyint(1) DEFAULT NULL,
  `start_of_work_as_shift_system1_2` text COLLATE utf8mb4_general_ci,
  `start_of_work_as_shift_system2_2` text COLLATE utf8mb4_general_ci,
  `effective_date_as_shift_system1_2` text COLLATE utf8mb4_general_ci,
  `scheduled_working_as_shift_system1` text COLLATE utf8mb4_general_ci,
  `start_of_work_as_shift_system3` text COLLATE utf8mb4_general_ci,
  `start_of_work_as_shift_system4` text COLLATE utf8mb4_general_ci,
  `effective_date_as_shift_system2` text COLLATE utf8mb4_general_ci,
  `scheduled_working_as_shift_system2` text COLLATE utf8mb4_general_ci,
  `scheduled_working_minutes_week` text COLLATE utf8mb4_general_ci,
  `scheduled_working_hours_time_1` text COLLATE utf8mb4_general_ci,
  `scheduled_working_days_1` text COLLATE utf8mb4_general_ci,
  `scheduled_working_days_2` text COLLATE utf8mb4_general_ci,
  `scheduled_working_days_3` text COLLATE utf8mb4_general_ci,
  `work_available_have_none` tinyint DEFAULT NULL,
  `holiday_every_week` text COLLATE utf8mb4_general_ci,
  `holiday_others` text COLLATE utf8mb4_general_ci,
  `total_number_holidays_per_year_1` text COLLATE utf8mb4_general_ci,
  `per_month` int DEFAULT NULL,
  `per_month_others` text COLLATE utf8mb4_general_ci,
  `annual_paid_leave_six_months` text COLLATE utf8mb4_general_ci,
  `six_months_have_none` tinyint DEFAULT NULL,
  `months_have_passed_1` text COLLATE utf8mb4_general_ci,
  `other_holidays_paid_leave` text COLLATE utf8mb4_general_ci,
  `other_holidays_unpaid` text COLLATE utf8mb4_general_ci,
  `basic_wage_monthly_salary` text COLLATE utf8mb4_general_ci,
  `basic_wage_salary` text COLLATE utf8mb4_general_ci,
  `basic_wage_daily_allowance` text COLLATE utf8mb4_general_ci,
  `basic_wage_daily_allowance_salary` text COLLATE utf8mb4_general_ci,
  `basic_wage_time_to_give` text COLLATE utf8mb4_general_ci,
  `various_allowances_1` text COLLATE utf8mb4_general_ci,
  `various_allowances_2` text COLLATE utf8mb4_general_ci,
  `various_allowances_3` text COLLATE utf8mb4_general_ci,
  `legal_excess_60_hours_less` int DEFAULT NULL,
  `legally_exceeded_60_hours_per_month` int DEFAULT NULL,
  `over_the_specified_limit_1` text COLLATE utf8mb4_general_ci,
  `legal_holidays_1` int DEFAULT NULL,
  `non_statutory_holidays` int DEFAULT NULL,
  `late_night_1` int DEFAULT NULL,
  `monthly_wage_deadline_1` tinyint(1) DEFAULT NULL,
  `monthly_wage_day_1` text COLLATE utf8mb4_general_ci,
  `monthly_wage_deadline_2` tinyint(1) DEFAULT NULL,
  `monthly_wage_day_2` text COLLATE utf8mb4_general_ci,
  `monthly_wage_deadline_3` tinyint(1) DEFAULT NULL,
  `monthly_wage_day_3` text COLLATE utf8mb4_general_ci,
  `monthly_wage_deadline_4` tinyint(1) DEFAULT NULL,
  `monthly_wage_day_4` text COLLATE utf8mb4_general_ci,
  `payment_method_direct_deposit` tinyint(1) DEFAULT NULL,
  `payment_method_currency_payment` tinyint(1) DEFAULT NULL,
  `deductions_the_time_have_none` tinyint DEFAULT NULL,
  `salary_increase_have_none` tinyint DEFAULT NULL,
  `amount_etc_1` text COLLATE utf8mb4_general_ci,
  `amount_etc_2` text COLLATE utf8mb4_general_ci,
  `bonus_have_none` tinyint DEFAULT NULL,
  `severance_pay_have_none` tinyint DEFAULT NULL,
  `amount_etc_3` text COLLATE utf8mb4_general_ci,
  `leave_allowance_have` tinyint(1) DEFAULT NULL,
  `leave_allowance_have_text` text COLLATE utf8mb4_general_ci,
  `retir` text COLLATE utf8mb4_general_ci,
  `employee_pension_insurance_1` tinyint(1) DEFAULT NULL,
  `health_insurance_1` tinyint(1) DEFAULT NULL,
  `employment_insurance_1` tinyint(1) DEFAULT NULL,
  `workers_accident_compensation_insurance` tinyint(1) DEFAULT NULL,
  `national_pension_1` tinyint(1) DEFAULT NULL,
  `national_health_insurance_1` tinyint(1) DEFAULT NULL,
  `others_10` tinyint(1) DEFAULT NULL,
  `others_text` text COLLATE utf8mb4_general_ci,
  `at_the_time_of_employment` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `health_check_time` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `conducted_every_after` text COLLATE utf8mb4_general_ci,
  `department_name_9_4` text COLLATE utf8mb4_general_ci,
  `name_position_9_4` text COLLATE utf8mb4_general_ci,
  `contact_address_9_4` text COLLATE utf8mb4_general_ci,
  `work_regulations_9` text COLLATE utf8mb4_general_ci,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `basic_wage_time_to_give_salary` text COLLATE utf8mb4_general_ci,
  `updated_count` bigint DEFAULT NULL,
  `date_title_2` date DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `et_doc_terms_of_employment` VALUES (3,'1','tokyo','3','082942000','代表取締役 入管 太郎','2024-12-14','2027-12-14','2024-12-14',1,0,0,1,0,0,1,0,0,'0','2024-12-14',1,'13:09:59','オオノ','東京','東京都新宿区',0,0,'大阪工場','神奈川','神奈川ABC','たなは','きゅうしゅう',0,'沖縄','たかた','13:09:59','13:09:59','13:09:59',0,'0',0,'13:09:59','0','13:09:59','13:09:59','13:09:59','0','13:09:59','13:09:59','13:09:59','0','13:09:59','0','160735','160','1920','20',0,'2','4','4','2','1','3','1','1',0,'1','2','1','2','3','3','1','3','3','1','4','2','1','0','3','2','1','4','1','5','3','3','1','4','3','2','4',1,1,'3','0',1,'4','0',0,'4','1',1,4,1,0,0,0,0,0,0,'0',3,4,3,4,'5','4','4','5','4',0,43,0,45,NULL,23,18000,5000,'3','3','4','2','3','3','3','5','5','4','3','5','5','4','4','4','33','3','1','1','3','1','3','0','0','5','6','5','4','4','4','5','6','0','0','0','0','0','0','0','0','2024-12-14','0','0','0','0','0',0,'0','0','0',0,0,'0','0',NULL,'0','0','0','0','0',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0','16:52:10','16:52:10','16:52:10.0','16:52:10',0,'13:09:59','13:09:59','13:09:59',0,'0',0,'130959','130959','130959','130959','130959','130959','130959','130959','0','0','0','0','0',0,'0','0','0',0,'0','0',0,'0','0','0','0','0','0','0','0','0','0','0',0,0,'0',0,0,0,0,'0',0,'0',0,'0',0,'0',0,0,0,0,'0','0',0,0,'0',0,'0','0',0,0,0,0,0,0,0,'0','2024-02','2034-02','0','0','0','0','0',NULL,NULL,'2024-12-14 04:53:25',1,'2024-12-14 07:52:10',1,'0',4,NULL),(4,'NGUYEN VAN SON','株式会社 入管','東京都','082-942-000','代表取締役 入管 太郎','2025-04-01','2026-03-30','2025-01-19',1,0,0,1,0,0,1,0,0,'30','2024-12-19',1,'08:00:00','大阪工場 所 在 地 大阪府〇〇市','大阪府','大阪府マツドシ',0,1,'東京工場','東京都','東京新宿','素形材・産業機械','建設',0,'電気電子情報関連製造業','とび','09:00:00','18:00:00','08:00:01',0,'0',0,'17:00:00','２３','08:00:00','08:00:00','17:00:00','20','08:00:00','08:00:00','17:00:00','12','08:00:00','1','1','40','1600','40',1,'2','1','1','2','1','1','3','1',0,'10','休暇','200,000','8000','700,000','20000','2000','1','2000','30000','10000','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1',1,1,'1','0',1,'1','0',0,'1','1',1,1,1,0,0,0,0,0,0,'0',1,1,1,1,'1','1','1','1','1',1,1,0,1,NULL,1,1,1,'1','1','1','1','1','1','1','1','1','1','1','0','1','1','1','1','2','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','1','2025-02-20','1','1','1','1','1',1,'1','1','1',0,0,'1','1',NULL,'1','1','0','1','1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'1','12:56:14','12:56:14','12:56:14.0','12:56:14',1,'11:16:59','11:16:59','11:16:59',1,'1',0,'1','1','1','1','1','1','1','1','1','2024-12-19T13:57','1','1','1',1,'1','1','1',1,'1','1',1,'1','1','1','1','1','1','1','1','1','1','1',1,1,'1',1,1,1,0,'1',0,'1',0,'1',0,'1',1,0,1,1,'1','1',1,1,'1',1,'1','1',1,0,0,0,0,0,0,'0','202520-01','2024-12','1','1','1','1','1',NULL,NULL,'2024-12-19 02:16:59',151,'2025-02-22 03:56:14',1,'1',13,'2024-12-19');

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

CREATE TABLE `et_doc_trainee_consultation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

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

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

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

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

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

--
-- Dumping data for table `et_doc_trainee_declaration`
--

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_trainee_pledge` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `staff_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `number_1` int DEFAULT NULL,
  `number_2` int DEFAULT NULL,
  `number_3` int DEFAULT NULL,
  `number_4` int DEFAULT NULL,
  `number_5` int DEFAULT NULL,
  `number_6` int DEFAULT NULL,
  `number_7` int DEFAULT NULL,
  `number_8` int DEFAULT NULL,
  `number_9` int DEFAULT NULL,
  `number_10` int DEFAULT NULL,
  `number_11` int DEFAULT NULL,
  `number_12` int DEFAULT NULL,
  `number_13` int DEFAULT NULL,
  `number_14` int DEFAULT NULL,
  `number_15` int DEFAULT NULL,
  `number_16` int DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `company_id` bigint NOT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `et_doc_trainee_pledge`
--

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

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

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

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

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

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

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

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

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

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

CREATE TABLE `et_doc_training_implementation_scheduler` (
  `id` int NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

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

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

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

CREATE TABLE `et_doc_training_instructor_resume` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_furigana` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sex` tinyint(1) DEFAULT NULL COMMENT '1: male, 2:female',
  `birthdate` date DEFAULT NULL,
  `postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_postcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `work_tel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `certificate` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_resume` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `job_resume_old` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_date` date DEFAULT NULL,
  `sign_company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sign_director_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `updated_at` int DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `company_id` bigint DEFAULT NULL,
  `updated_count` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
