
--
-- Table structure for table `foreign_institution_certificate_detail`
--

CREATE TABLE `foreign_institution_certificate_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `foreign_institution_certificate_id` int NOT NULL,
  `name_romaji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_kanji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dep_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dep_type` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `foreign_institution_certificate_detail`
--

INSERT INTO `foreign_institution_certificate_detail` VALUES (1,1,'romaji','name_kanji','COMPANY_NAME','DEP_NAME',1),(2,1,'Day la moi them','ko du du lieu','Oke roi','Them cai nua',2),(3,2,'romaji','kanji','COMPANY_NAME','DEP_NAME',1),(4,2,'test1','','','',NULL),(7,3,'1','name_kanji','COMPANY_NAME','DEP_NAME',1),(8,3,'2','name2','COMPANY_NAME 2','DEP_NAME 2',2);

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint unsigned NOT NULL,
  `reserved_at` int unsigned DEFAULT NULL,
  `available_at` int unsigned NOT NULL,
  `created_at` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB AUTO_INCREMENT=131 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `kumiai_expense_management_detail`
--

CREATE TABLE `kumiai_expense_management_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `kumiai_expense_management_id` int NOT NULL,
  `date` date DEFAULT NULL,
  `company_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `expense_type` tinyint(1) DEFAULT NULL,
  `expense_type_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `money` int DEFAULT NULL,
  `note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `kumiai_expense_management_detail`
--

INSERT INTO `kumiai_expense_management_detail` VALUES (1,1,'2024-07-19','COMPANY1',2,'2',4,'12'),(2,1,'2024-07-28','COMPANY2',2,'2',5,'34'),(3,2,'2024-09-02','COMPANY_NAME',2,'EXPENSE_TYPE_NOTE',1000,'test'),(4,2,'2024-09-03','test',1,'test2',2000,'test234');

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2019_12_14_000001_create_personal_access_tokens_table',1),(2,'2023_12_09_102138_create_em_function_table',1),(3,'2023_12_09_102256_create_em_function_category_table',1),(4,'2023_12_09_103348_create_em_code_table',1),(5,'2023_12_09_103948_create_em_user_table',1),(6,'2023_12_09_104148_create_em_customer_table',1),(7,'2023_12_09_105542_create_em_customer_office',1),(8,'2023_12_09_110217_create_em_customer_staff',1),(9,'2023_12_09_110503_create_em_sending_agency_table',1),(10,'2023_12_09_110625_create_em_training_facility_table',1),(11,'2023_12_09_110754_create_em_trainee_table',1),(12,'2023_12_09_111250_create_em_trainee_relative_table',1),(13,'2023_12_09_111512_create_m_company_table',1),(14,'2023_12_09_111940_create_m_company_office',1),(15,'2023_12_09_112139_create_m_company_staff',1),(16,'2023_12_09_112325_create_em_stay_facility',1),(17,'2023_12_09_112359_create_em_nationality',1),(18,'2023_12_09_112427_create_m_native_language',1),(19,'2023_12_09_112508_create_et_working_hour',1),(20,'2023_12_09_112646_create_em_flowgroup',1),(21,'2023_12_09_112834_create_et_workflow',1),(22,'2023_12_09_113002_create_et_work',1),(23,'2023_12_09_113059_create_project',1),(24,'2023_12_09_113136_create_project_work',1),(25,'2023_12_09_113221_create_project_work_task',1),(26,'2023_12_09_113345_create_project_work_task_file',1),(27,'2023_12_09_113415_create_project_trainee',1),(28,'2023_12_09_113453_create_project_trainee_contract',1),(29,'2023_12_09_114701_create_project_document',1),(30,'2023_12_09_114802_create_project_document_attribute',1),(31,'2023_12_09_114908_create_document_template',1),(32,'2023_12_09_114957_create_document_attribute',1),(33,'2023_12_09_115043_create_audit_report',1),(34,'2023_12_09_115118_create_visit_guidance_record',1),(35,'2023_12_09_115224_create_visit_guidance_record_detail',1),(36,'2023_12_09_104148_create_em_customer1_table',2),(37,'2023_12_09_104148_create_em_customer2_table',3);

--
-- Table structure for table `outsidecountry_paid_trainee_costname`
--

CREATE TABLE `outsidecountry_paid_trainee_costname` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `expenses_paid_trainee_id` int DEFAULT NULL,
  `sending_agency_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `money` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `outsidecountry_paid_trainee_costname`
--

INSERT INTO `outsidecountry_paid_trainee_costname` VALUES (1,1,'監理団体の名称','監理団体の名称監理団体の名称','2024-07-24',10000),(2,2,'1','test','2024-09-16',1000),(3,2,'2','test','2024-09-17',134);

--
-- Table structure for table `pledge_officers_specific_skills_affiliation_organizations`
--

CREATE TABLE `pledge_officers_specific_skills_affiliation_organizations` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name_of_fficer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `name_skills_organization` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `responsible` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `customer_id` bigint DEFAULT NULL,
  `created_by_id` bigint DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `name_fficer` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pledge_officers_specific_skills_affiliation_organizations`
--

INSERT INTO `pledge_officers_specific_skills_affiliation_organizations` VALUES (1,'[\"\\u30bf\\u30ed\\u30a6\",\"\\u30aa\\u30aa\\u30ce\",\"\\u30bf\\u30b1\\u30e0\\u30e9\",null,null,null,null,null]','ABC会社','2024-03-12','鈴木部長',NULL,NULL,'2024-12-24 03:07:23',151,'2024-12-24 03:27:10',1,2,'[\"\\u592a\\u90ce\",\"\\u5927\\u91ce\",\"\\u6b66\\u6751\",null,null,null,null,null]');

--
-- Table structure for table `power_attorney_detail`
--

CREATE TABLE `power_attorney_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `no` int DEFAULT NULL,
  `power_attorney_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,
  `birthdate` date DEFAULT NULL,
  `sex` int DEFAULT NULL COMMENT '1: male, 2: female',
  `check_1` int DEFAULT NULL,
  `check_2` int DEFAULT NULL,
  `check_3` int DEFAULT NULL,
  `check_4` int DEFAULT NULL,
  `check_5` int DEFAULT NULL,
  `check_6` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `power_attorney_detail`
--

INSERT INTO `power_attorney_detail` VALUES (1,1,1,'test1','NATIONALITY','2024-07-04',2,1,0,1,0,0,0),(3,2,1,'test2','',NULL,1,0,0,0,0,0,0),(4,3,1,'test3','',NULL,1,1,1,1,1,0,0),(5,1,2,'Nguyen duc tap','nation','2024-07-07',1,1,1,0,0,0,0);

--
-- Table structure for table `pre_entry_training_scheduler_detail1`
--

CREATE TABLE `pre_entry_training_scheduler_detail1` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pre_entry_training_scheduler_id` int DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ext_teacher` tinyint(1) DEFAULT NULL,
  `school_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learn_from` date DEFAULT NULL,
  `learn_to` date DEFAULT NULL,
  `learn_time` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pre_entry_training_scheduler_detail1`
--

INSERT INTO `pre_entry_training_scheduler_detail1` VALUES (1,1,'Content 1','Name 1',1,'123 Address 1','2024-07-01','2024-07-05',11),(2,2,'test1','school name',1,'test','2024-07-09','2024-07-09',8),(3,2,'test2','school name  2',NULL,'test 2','2024-07-10','2024-07-11',16),(4,3,'content1','school1',1,'address','2024-07-30','2024-07-30',8),(7,4,'content1','school name',1,'test','2024-09-06','2024-09-05',9);

--
-- Table structure for table `pre_entry_training_scheduler_detail2`
--

CREATE TABLE `pre_entry_training_scheduler_detail2` (
  `id` int NOT NULL AUTO_INCREMENT,
  `pre_entry_training_scheduler_id` int DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_type` tinyint(1) DEFAULT NULL,
  `school_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learn_from` date DEFAULT NULL,
  `learn_to` date DEFAULT NULL,
  `learn_time` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pre_entry_training_scheduler_detail2`
--

INSERT INTO `pre_entry_training_scheduler_detail2` VALUES (1,1,'Content','Name nef',1,'addl ress njes','2024-07-01','2024-07-05',22),(2,2,'test 1','test 2',1,'address','2024-07-10','2024-07-10',8),(3,2,'test3','test4',NULL,'','2024-07-13','2024-07-14',16),(4,3,'content1','school 1',1,'SCHOOL_ADDRESS','2024-07-30','2024-07-30',8),(7,4,'test 1','test 2',1,'address','2024-09-09','2024-09-09',123),(8,4,'test3','',NULL,'',NULL,NULL,4);

--
-- Table structure for table `project_training_gino`
--

CREATE TABLE `project_training_gino` (
  `project_training_gino_id` int NOT NULL AUTO_INCREMENT,
  `project_id` int NOT NULL,
  `company_id` int NOT NULL,
  `job_type` int DEFAULT NULL,
  `job_name` int DEFAULT NULL,
  `trainee_type` int DEFAULT NULL,
  `training_gino_date_to` date DEFAULT NULL,
  `training_gino_date_from` date DEFAULT NULL,
  `training_jp_date_from` date DEFAULT NULL,
  `training_jp_date_to` date DEFAULT NULL,
  `training_stop_date_from` date DEFAULT NULL,
  `trainig_stop_date_to` date DEFAULT NULL,
  `trainng_day_mon` tinyint(1) DEFAULT NULL,
  `training_day_tue` tinyint(1) DEFAULT NULL,
  `training_day_web` tinyint(1) DEFAULT NULL,
  `training_day_thur` tinyint(1) DEFAULT NULL,
  `training_day_fri` tinyint(1) DEFAULT NULL,
  `training_day_sat` tinyint(1) DEFAULT NULL,
  `training_day_sun` tinyint(1) DEFAULT NULL,
  `training_day_holiday` tinyint(1) DEFAULT NULL,
  `training_offday_month1` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month2` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month3` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month4` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month5` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month6` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month7` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month8` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month9` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month10` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month11` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month12` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_required_percent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_main_percent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_other_percent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `textbook_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `machine_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_note` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`project_training_gino_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `project_training_gino`
--


--
-- Table structure for table `project_training_gino_detail`
--

CREATE TABLE `project_training_gino_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_training_id` int NOT NULL,
  `work_type` int DEFAULT NULL,
  `work_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month7` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month8` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month9` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month10` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month11` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month12` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `updated_at` datetime NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `project_training_gino_detail`
--


--
-- Table structure for table `similar_job_description_name`
--

CREATE TABLE `similar_job_description_name` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_romaji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_kanji` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `similar_job_description_id` bigint NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `similar_job_description_name`
--


--
-- Table structure for table `supervisor_cv_detail`
--

CREATE TABLE `supervisor_cv_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `supervisor_cv_id` int NOT NULL,
  `month` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `supervisor_cv_detail`
--

INSERT INTO `supervisor_cv_detail` VALUES (1,1,'2024-07-04','test 1'),(2,1,'2024-06-03','test2'),(3,2,'2024-07-09','test 1'),(4,2,'2024-07-02','test 2'),(5,3,'2024-08','test'),(7,4,'2024-09','100'),(8,4,'2024-10','test');

--
-- Table structure for table `training_implementation_scheduler_detail`
--

CREATE TABLE `training_implementation_scheduler_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_implementation_scheduler_id` int DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `school_type` tinyint(1) DEFAULT NULL,
  `school_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `learn_from` date DEFAULT NULL,
  `learn_to` date DEFAULT NULL,
  `learn_time` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `training_implementation_scheduler_detail`
--

INSERT INTO `training_implementation_scheduler_detail` VALUES (1,2,'CONTENT 1','SCHOOL_NAME',1,'SCHOOL_ADDRESS','2024-07-01','2024-07-08',8),(2,1,'入国前講習の内容は本表に記載せず、参考様式第１－２９号「入国前講習実施（予定）表に関する申請者等','school name',1,'123 hha','2024-07-16','2024-07-17',4),(3,1,'test','',NULL,'','2024-07-18',NULL,NULL),(4,1,'test 123','t',2,'','2024-07-11','2024-07-18',2),(7,3,'CONTENT 1','SCHOOL_NAME',1,'SCHOOL_ADDRESS','2024-09-18','2024-09-18',123),(8,3,'content 2','SCHOOL_ADDRESS 2',2,'112','2024-09-12','2024-09-12',1);

--
-- Table structure for table `training_instructor_resume_detail`
--

CREATE TABLE `training_instructor_resume_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `training_instructor_resume_id` int NOT NULL,
  `year` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `month` varchar(2) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `training_instructor_resume_detail`
--

INSERT INTO `training_instructor_resume_detail` VALUES (1,1,'2000','01','test 1'),(2,1,'2010','02','test2'),(3,1,'2015','03',''),(6,2,'2000','21','');


