(49,'832ec53c-30e0-4c8d-b777-4e134b59fdde','database','default','{\"uuid\":\"832ec53c-30e0-4c8d-b777-4e134b59fdde\",\"displayName\":\"App\\\\Jobs\\\\SendEmailTemplatePO\",\"job\":\"Illuminate\\\\Queue\\\\CallQueuedHandler@call\",\"maxTries\":null,\"maxExceptions\":null,\"failOnTimeout\":false,\"backoff\":null,\"timeout\":null,\"retryUntil\":null,\"data\":{\"commandName\":\"App\\\\Jobs\\\\SendEmailTemplatePO\",\"command\":\"O:28:\\\"App\\\\Jobs\\\\SendEmailTemplatePO\\\":2:{s:7:\\\"\\u0000*\\u0000data\\\";a:5:{s:5:\\\"title\\\";s:56:\\\"【DOMOTECH】 技能さんID登録完了のお知らせ\\\";s:9:\\\"mail_from\\\";N;s:7:\\\"mail_to\\\";s:22:\\\"support@alphacep.co.jp\\\";s:7:\\\"mail_cc\\\";N;s:4:\\\"body\\\";s:1482:\\\"[customer_name]<br \\/>\\r\\nご担当様<br \\/>\\r\\n<br \\/>\\r\\n「技能さん」の利用申し込みが完了しましたので、お知らせいたします。<br \\/>\\r\\n<br \\/>\\r\\n下記URLよりご利用ください。<br \\/>\\r\\n<br \\/>\\r\\n=========================================<br \\/>\\r\\nhttp:\\/\\/dev-abc.erpcpanel.com<br \\/>\\r\\nユーザID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;admin<br \\/>\\r\\n仮パスワード&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BHD38C<br \\/>\\r\\n=========================================<br \\/>\\r\\n<br \\/>\\r\\n上記仮パスワードを入力・ログインいただいた後、新たなパスワードの設定をお願いします。<br \\/>\\r\\n<br \\/>\\r\\n<br \\/>\\r\\nお困りの点がありましたら、お気軽にご相談ください。<br \\/>\\r\\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━<br \\/>\\r\\n発行：株式会社DOMOTECH<br \\/>\\r\\n〒273-0111 千葉県鎌ケ谷市北中沢１－１８－２２スカラビル３F<br \\/>\\r\\nメール info@domotech.com<br \\/>\\r\\nウェブサイト&nbsp;https:\\/\\/domotech.com<br \\/>\\r\\n───────────────────────────────────<br \\/>\\r\\n◆このメールに掲載された記事を許可なく転載する事を禁じます。<br \\/>\\r\\nCopyright (c) DOMOTECH Co., Ltd. All rights reserved.<br \\/>\\r\\n━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━\\\";}s:5:\\\"delay\\\";O:25:\\\"Illuminate\\\\Support\\\\Carbon\\\":3:{s:4:\\\"date\\\";s:26:\\\"2024-09-18 13:03:46.627633\\\";s:13:\\\"timezone_type\\\";i:3;s:8:\\\"timezone\\\";s:10:\\\"Asia\\/Tokyo\\\";}}\"}}','ErrorException: Attempt to read property \"company_id\" on null in /home/erpcpanel/public_html/dev.erpcpanel.com/app/Providers/AppServiceProvider.php:29\nStack trace:\n#0 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Foundation/Bootstrap/HandleExceptions.php(255): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->handleError(2, \'Attempt to read...\', \'/home/erpcpanel...\', 29)\n#1 /home/erpcpanel/public_html/dev.erpcpanel.com/app/Providers/AppServiceProvider.php(29): Illuminate\\Foundation\\Bootstrap\\HandleExceptions->Illuminate\\Foundation\\Bootstrap\\{closure}(2, \'Attempt to read...\', \'/home/erpcpanel...\', 29)\n#2 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php(162): App\\Providers\\AppServiceProvider->App\\Providers\\{closure}(Object(Illuminate\\View\\View))\n#3 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(455): Illuminate\\View\\Factory->Illuminate\\View\\Concerns\\{closure}(\'composing: mail...\', Array)\n#4 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(286): Illuminate\\Events\\Dispatcher->Illuminate\\Events\\{closure}(\'composing: mail...\', Array)\n#5 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Events/Dispatcher.php(266): Illuminate\\Events\\Dispatcher->invokeListeners(\'composing: mail...\', Array, false)\n#6 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php(177): Illuminate\\Events\\Dispatcher->dispatch(\'composing: mail...\', Array)\n#7 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/View/View.php(188): Illuminate\\View\\Factory->callComposer(Object(Illuminate\\View\\View))\n#8 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/View/View.php(159): Illuminate\\View\\View->renderContents()\n#9 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(433): Illuminate\\View\\View->render()\n#10 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(408): Illuminate\\Mail\\Mailer->renderView(\'mail.mail-templ...\', Array)\n#11 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(320): Illuminate\\Mail\\Mailer->addContent(Object(Illuminate\\Mail\\Message), \'mail.mail-templ...\', NULL, NULL, Array)\n#12 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailable.php(205): Illuminate\\Mail\\Mailer->send(\'mail.mail-templ...\', Array, Object(Closure))\n#13 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Support/Traits/Localizable.php(19): Illuminate\\Mail\\Mailable->Illuminate\\Mail\\{closure}()\n#14 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailable.php(198): Illuminate\\Mail\\Mailable->withLocale(NULL, Object(Closure))\n#15 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(357): Illuminate\\Mail\\Mailable->send(Object(Illuminate\\Mail\\Mailer))\n#16 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/Mailer.php(301): Illuminate\\Mail\\Mailer->sendMailable(Object(App\\Mail\\MailTemplatePo))\n#17 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Mail/PendingMail.php(124): Illuminate\\Mail\\Mailer->send(Object(App\\Mail\\MailTemplatePo))\n#18 /home/erpcpanel/public_html/dev.erpcpanel.com/app/Jobs/SendEmailTemplatePO.php(36): Illuminate\\Mail\\PendingMail->send(Object(App\\Mail\\MailTemplatePo))\n#19 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): App\\Jobs\\SendEmailTemplatePO->handle()\n#20 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#21 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#22 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#23 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#24 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(128): Illuminate\\Container\\Container->call(Array)\n#25 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Bus\\Dispatcher->Illuminate\\Bus\\{closure}(Object(App\\Jobs\\SendEmailTemplatePO))\n#26 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SendEmailTemplatePO))\n#27 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Bus/Dispatcher.php(132): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#28 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(123): Illuminate\\Bus\\Dispatcher->dispatchNow(Object(App\\Jobs\\SendEmailTemplatePO), false)\n#29 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(144): Illuminate\\Queue\\CallQueuedHandler->Illuminate\\Queue\\{closure}(Object(App\\Jobs\\SendEmailTemplatePO))\n#30 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(119): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(App\\Jobs\\SendEmailTemplatePO))\n#31 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(122): Illuminate\\Pipeline\\Pipeline->then(Object(Closure))\n#32 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/CallQueuedHandler.php(70): Illuminate\\Queue\\CallQueuedHandler->dispatchThroughMiddleware(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(App\\Jobs\\SendEmailTemplatePO))\n#33 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/Jobs/Job.php(102): Illuminate\\Queue\\CallQueuedHandler->call(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Array)\n#34 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(439): Illuminate\\Queue\\Jobs\\Job->fire()\n#35 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(389): Illuminate\\Queue\\Worker->process(\'database\', Object(Illuminate\\Queue\\Jobs\\DatabaseJob), Object(Illuminate\\Queue\\WorkerOptions))\n#36 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/Worker.php(176): Illuminate\\Queue\\Worker->runJob(Object(Illuminate\\Queue\\Jobs\\DatabaseJob), \'database\', Object(Illuminate\\Queue\\WorkerOptions))\n#37 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(137): Illuminate\\Queue\\Worker->daemon(\'database\', \'default\', Object(Illuminate\\Queue\\WorkerOptions))\n#38 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Queue/Console/WorkCommand.php(120): Illuminate\\Queue\\Console\\WorkCommand->runWorker(\'database\', \'default\')\n#39 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(36): Illuminate\\Queue\\Console\\WorkCommand->handle()\n#40 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/Util.php(41): Illuminate\\Container\\BoundMethod::Illuminate\\Container\\{closure}()\n#41 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(93): Illuminate\\Container\\Util::unwrapIfClosure(Object(Closure))\n#42 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/BoundMethod.php(35): Illuminate\\Container\\BoundMethod::callBoundMethod(Object(Illuminate\\Foundation\\Application), Array, Object(Closure))\n#43 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Container/Container.php(662): Illuminate\\Container\\BoundMethod::call(Object(Illuminate\\Foundation\\Application), Array, Array, NULL)\n#44 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Console/Command.php(211): Illuminate\\Container\\Container->call(Array)\n#45 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/symfony/console/Command/Command.php(326): Illuminate\\Console\\Command->execute(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#46 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Console/Command.php(180): Symfony\\Component\\Console\\Command\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Illuminate\\Console\\OutputStyle))\n#47 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/symfony/console/Application.php(1096): Illuminate\\Console\\Command->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#48 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/symfony/console/Application.php(324): Symfony\\Component\\Console\\Application->doRunCommand(Object(Illuminate\\Queue\\Console\\WorkCommand), Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#49 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/symfony/console/Application.php(175): Symfony\\Component\\Console\\Application->doRun(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#50 /home/erpcpanel/public_html/dev.erpcpanel.com/vendor/laravel/framework/src/Illuminate/Foundation/Console/Kernel.php(201): Symfony\\Component\\Console\\Application->run(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#51 /home/erpcpanel/public_html/dev.erpcpanel.com/artisan(35): Illuminate\\Foundation\\Console\\Kernel->handle(Object(Symfony\\Component\\Console\\Input\\ArgvInput), Object(Symfony\\Component\\Console\\Output\\ConsoleOutput))\n#52 {main}','2024-09-18 04:04:02');

--
-- 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_0900_ai_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) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext 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=130 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_0900_ai_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_0900_ai_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 `list_of_accepted_to_residents`
--

CREATE TABLE `list_of_accepted_to_residents` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name_specific_skills_organization` text COLLATE utf8mb4_general_ci,
  `responsible_person` text COLLATE utf8mb4_general_ci,
  `name` text COLLATE utf8mb4_general_ci,
  `female_male` text COLLATE utf8mb4_general_ci,
  `dateb` text COLLATE utf8mb4_general_ci,
  `n_r` text COLLATE utf8mb4_general_ci,
  `r_c_n` text COLLATE utf8mb4_general_ci,
  `f_date` text COLLATE utf8mb4_general_ci,
  `t_date` text COLLATE utf8mb4_general_ci,
  `have_none` 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,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `list_of_accepted_to_residents`
--

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

--
-- Table structure for table `list_of_people_eligible_for_support_for_type_1`
--

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

--
-- Dumping data for table `list_of_people_eligible_for_support_for_type_1`
--

INSERT INTO `list_of_people_eligible_for_support_for_type_1` VALUES ('ABC会社','田中株式会社','[\"NGUYEN  VANA\",\"\\u5165\\u7ba1 \\u592a\\u90ce\",\"\\u4f50\\u85e4\",\"\\u6b66\\u6751\",null,null,null,null,null,null,null,null,null,null]','[\"\\u5973\",\"\\u7537\",\"\\u5973\",\"\\u5973\",null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",null,null,null,null,null,null,null,null,null,null]','[\"2000-01-30\",\"1999-01-02\",\"2010-01-28\",\"2000-01-29\",null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",\"ABC123AAA\",\"ABC3333AAA\",\"ABC3333AAA\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null,null,null]','[null,null,\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"124144\",\"24545\",\"458-7856\",\"122222\",null,null,null,null,null,null,null,null,null,null]','[\"CHIBA\",\"\\u6771\\u4eac\",\"chiba\",\"chiba\",null,null,null,null,null,null,null,null,null,null]','[\"0829420111\",\"0146215\",\"2314525\",\"1224563\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-01-30 08:28:06',151,'2025-01-30 08:28:06',1,2,1);

--
-- Table structure for table `list_people_eligible_support_type_1_specific`
--

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

--
-- Dumping data for table `list_people_eligible_support_type_1_specific`
--

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

--
-- Table structure for table `list_received_life_consultation_services`
--

CREATE TABLE `list_received_life_consultation_services` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `name_specific_skills_organization` text COLLATE utf8mb4_general_ci,
  `responsible_person` text COLLATE utf8mb4_general_ci,
  `name` text COLLATE utf8mb4_general_ci,
  `female_male` text COLLATE utf8mb4_general_ci,
  `dateb` text COLLATE utf8mb4_general_ci,
  `n_r` text COLLATE utf8mb4_general_ci,
  `r_c_n` text COLLATE utf8mb4_general_ci,
  `f_date` text COLLATE utf8mb4_general_ci,
  `t_date` text COLLATE utf8mb4_general_ci,
  `have_none` 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,
  `updated_count` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `list_received_life_consultation_services`
--

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

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

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) 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 `notification_of_acceptance_and_activity_status`
--

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

--
-- Dumping data for table `notification_of_acceptance_and_activity_status`
--

INSERT INTO `notification_of_acceptance_and_activity_status` VALUES ('[\"VO THI THU THUY \\u00e1\",\"\\u7530\\u4e2d\",\"shdj\",\"gdggdfh\",null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"dgdghg\",null,null,null,null,null,null,null,null]','[\"2000\\u5e747\\u670817\\u65e5\",\"2000\\u5e741\\u670812\\u65e5\",\"\\uff12\\uff10\\uff10\\uff11\\u5e74\\uff11\\u6708\\uff12\\uff10\\u65e5\",\"\\uff12\\uff10\\uff10\\uff10\\u5e74\\uff11\\u6708\\uff17\\u65e5\",null,null,null,null,null,null,null,null]','[null,\"1\",null,\"1\",null,null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,null,null,null,null,null,null,null,null]','[\"ABC123456782\",\"ABC12345ASAD\",\"AVJDGKA1435665\",\"\\uff44\\uff4a\\uff48\\uff46\\uff4b\\uff47\",null,null,null,null,null,null,null,null]','[\"123\",\"123-456\",\"123455\",\"134\",null,null,null,null,null,null,null,null]','[\"456\",\"\\u6771\\u4eac\\u90fd\",\"chiba\",\"\\u57fc\\u7389\\u770c\",null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,\"1\",null]','[\"1\",null,null,null,null,null,null,null,null,null,\"1\",\"1\"]','[null,\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"2\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"2\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",null,\"1\",null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-01-28 04:48:00',151,'2025-01-30 05:43:52',1,5,1,'[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"3\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"2\",\"2\",\"2\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"4\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"3\",\"3\",\"3\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"5\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]','[\"4\",\"4\",\"4\",null,null,null,null,null,null,null,null,null]'),('[\"\\u00e1\\u0111\\u00e1\",\"AAA\",null,null,null,null,null,null,null,null,null,null]','[\"\\u30d9\\u30c8\\u30ca\\u30e0\",\"\\u30cd\\u30d1\\u30fc\\u30eb\",null,null,null,null,null,null,null,null,null,null]','[\"2000\\u5e741\\u67083\\u65e5\",\"2001\\u5e741\\u670810\\u65e5\",null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[\"AB125415544a\",\"ABC123AAA\",null,null,null,null,null,null,null,null,null,null]','[\"123-458\",\"245-458\",null,null,null,null,null,null,null,null,null,null]','[\"tokyo\",\"\\u5343\\u8449\\u770c\",null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,\"1\",null,null,null,null,null,null,null,null,\"1\",null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null,null,null]','[\"1\",\"4\",null,null,null,null,null,null,null,null,null,null]','[\"20\",\"20\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"200000\",null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"30000\",null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,null,null,null,null,null,null,null,null,null]','[null,null,null,null,null,null,null,null,null,null,null,null]',NULL,NULL,'2025-02-04 15:28:57',151,'2025-02-04 16:01:56',1,3,2,'[\"2\",\"5\",null,null,null,null,null,null,null,null,null,null]','[\"25\",\"25\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"300000\",null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"20000\",null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"10000\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"500000\",null,null,null,null,null,null,null,null,null,null]','[\"23\",\"23\",null,null,null,null,null,null,null,null,null,null]','[\"3\",\"6\",null,null,null,null,null,null,null,null,null,null]','[\"5000\",null,null,null,null,null,null,null,null,null,null,null]','[\"3000\",\"600000\",null,null,null,null,null,null,null,null,null,null]','[\"200000\",\"10000000\",null,null,null,null,null,null,null,null,null,null]','[\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\"]','[\"411111111111111111\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\",\"2055555555555555555555555\"]');

--
-- Table structure for table `notification_suspensiontermination_support_services`
--

CREATE TABLE `notification_suspensiontermination_support_services` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `registration_number` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `legal_person_number_1` int NOT NULL,
  `legal_person_number_2` int NOT NULL,
  `legal_person_number_3` int NOT NULL,
  `legal_person_number_4` int NOT NULL,
  `legal_person_number_5` int NOT NULL,
  `legal_person_number_6` int NOT NULL,
  `legal_person_number_7` int NOT NULL,
  `legal_person_number_8` int NOT NULL,
  `legal_person_number_9` int NOT NULL,
  `legal_person_number_10` int NOT NULL,
  `legal_person_number_11` int NOT NULL,
  `legal_person_number_12` int NOT NULL,
  `legal_person_number_13` int NOT NULL,
  `name_the_institution` varchar(255) 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,
  `suspen_sionsupport_services` tinyint DEFAULT NULL,
  `abolition_support_services` tinyint DEFAULT NULL,
  `suspension` date DEFAULT NULL,
  `business_reasons` tinyint DEFAULT NULL,
  `business_downsizing` tinyint DEFAULT NULL,
  `others` tinyint DEFAULT NULL,
  `text_others` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `reopening` tinyint DEFAULT NULL,
  `reopenin_date` date DEFAULT NULL,
  `date_abolition` tinyint DEFAULT NULL,
  `date_abolition_date` date DEFAULT NULL,
  `bankruptcy` tinyint DEFAULT NULL,
  `death` tinyint DEFAULT NULL,
  `business_downsizing1` tinyint DEFAULT NULL,
  `other_business_reasons` tinyint DEFAULT NULL,
  `yes_or_no` tinyint DEFAULT NULL,
  `creation_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by_id` bigint DEFAULT NULL,
  `updated_by_id` bigint DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `company_id` bigint DEFAULT NULL,
  `updated_count` bigint DEFAULT NULL,
  `code` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name_ct` 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 `notification_suspensiontermination_support_services`
--

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

--
-- Table structure for table `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_0900_ai_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 COLLATE utf8mb4_general_ci,
  `name_skills_organization` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `responsible` varchar(255) 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 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_0900_ai_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_0900_ai_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_0900_ai_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) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month2` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month3` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month4` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month5` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month6` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month7` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month8` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month9` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month10` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month11` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `training_offday_month12` varchar(100) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_required_percent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_main_percent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_other_percent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `textbook_note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `product_note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `machine_note` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `work_note` varchar(255) 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) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month3` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month4` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month5` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month6` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month7` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month9` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month10` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month11` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `month12` varchar(255) 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 `regular_interview_report`
--

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

--
-- Dumping data for table `regular_interview_report`
--

INSERT INTO `regular_interview_report` VALUES (1,'トウイ','áđá','2025-01-22','TIEP',NULL,1,'名 代表取締役','ád',NULL,'無し',NULL,'ád',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 03:05:09',NULL,151,'2025-01-23 07:03:04',1,10,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-23','cjgkh',1,1,NULL,1,NULL);

--
-- Table structure for table `regular_interview_report_for_supervisors`
--

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

--
-- Dumping data for table `regular_interview_report_for_supervisors`
--

INSERT INTO `regular_interview_report_for_supervisors` VALUES (1,'トウイ','áđá','2025-01-22','TIEP',NULL,1,'名 代表取締役','ád',NULL,'無し',NULL,'ád',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 03:05:09',NULL,151,'2025-01-23 07:03:04',1,10,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-23','cjgkh',1,1,NULL,1,NULL),(2,'トウイ','ABS会社','2025-01-22','TIEP',NULL,NULL,'AAAAAAAAAA','無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,'無し',NULL,NULL,'無し','無し',NULL,'無し',NULL,'無し',NULL,NULL,'無し','無し',NULL,'無し',NULL,'無し',NULL,NULL,1,'あｂC kaisya','2025-01-23','dhfjjg','2025-01-23 07:46:28',NULL,151,'2025-01-23 08:06:50',1,3,'afsaddfgfg','2025-01-23','gsgdg','2025-01-23','gsgdsgg','2025-01-22','cjgkh',1,1,NULL,1,1);

--
-- Table structure for table `required_documents_accommodation_sector`
--

CREATE TABLE `required_documents_accommodation_sector` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `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,
  `previously1` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously8` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously2` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously3` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously4` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously5` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously6` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `previously7` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either1` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either2` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either3` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either4` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either5` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either6` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either7` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `either8` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official1` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official2` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official3` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official4` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official5` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official6` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official7` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `official8` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe1` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe2` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe3` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe4` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe5` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe6` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe7` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `eithe8` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia1` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia2` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia3` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia4` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia5` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia6` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia7` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `officia8` varchar(10) 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 `required_documents_accommodation_sector`
--

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

--
-- Table structure for table `resume_of_support_manager`
--

CREATE TABLE `resume_of_support_manager` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `year` text COLLATE utf8mb4_general_ci,
  `month` text COLLATE utf8mb4_general_ci,
  `highest` text COLLATE utf8mb4_general_ci,
  `qualifications_licenses` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `name_support_person_charge` varchar(255) 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,
  `full_name2` 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 `resume_of_support_manager`
--

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

--
-- Table structure for table `resume_of_support_staff`
--

CREATE TABLE `resume_of_support_staff` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `year` text COLLATE utf8mb4_general_ci,
  `month` text COLLATE utf8mb4_general_ci,
  `highest` text COLLATE utf8mb4_general_ci,
  `qualifications_licenses` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_create` date DEFAULT NULL,
  `name_support_person_charge` varchar(255) 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,
  `full_name2` varchar(255) 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 `resume_of_support_staff`
--

INSERT INTO `resume_of_support_staff` VALUES (1,'農園 太郎','2','1987-08-07',NULL,NULL,NULL,'','2024-12-24','オオノ',NULL,NULL,'2024-12-23 08:57:22',NULL,'2024-12-23 08:57:22',1,0,NULL),(2,'オオノ','男','2000-02-10','[\"2010\",\"2014\",null,null,null,null,null,null,null,null]','[\"1\",\"2\",null,null,null,null,null,null,null,null]','[\"ABC\\u5927\\u5b66\",\"TTTT\\u5927\\u5b66\\u9662\",null,null,null,null,null,null,null,null]','N3','2025-02-10','takemura',NULL,NULL,'2025-02-10 03:09:30',151,'2025-02-10 03:10:40',1,1,'大野');

--
-- 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_0900_ai_ci;

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


--
-- Table structure for table `skills_transfer_declaration`
--

CREATE TABLE `skills_transfer_declaration` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `full_name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `gender` tinyint DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `nationality_region` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `acquire_skills` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `proficient_skilled` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date` date DEFAULT NULL,
  `signature_declarant` varchar(255) 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,
  `home_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `skills_transfer_declaration`
--

INSERT INTO `skills_transfer_declaration` VALUES (1,'オオノ',2,'1985-11-20','タイ','社長','社長','2024-12-13','あｇｄぁｆがｌｆｇ',NULL,NULL,'2024-12-14 07:20:04',1,'2024-12-14 09:09:50',1,3,'ベトナム'),(2,'ádasdasd',2,'1985-12-12','タイ','社長','社長','2024-12-18','AAAAAAAAAAAAAAAA',NULL,NULL,'2024-12-18 06:03:58',151,'2025-02-22 04:47:05',1,2,'タイ');

--
-- Table structure for table `specific_skills_affiliation_agency_profile`
--

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

--
-- Dumping data for table `specific_skills_affiliation_agency_profile`
--

INSERT INTO `specific_skills_affiliation_agency_profile` VALUES (1,'[\"\\u30aa\\u30aa\\u30ce\",\"\\u306b\\u3085\\u3046\\u304b\\u3093\\u305f\\u308d\\u3046\",\"\\u3055\\u3068\\u3046\",\"\\u30b9\\u30ba\\u30ad\",\"\\u3042\\u304a\\u3084\\u307e\"]','[\"\\u793e\\u9577\",\"\\u8ab2\\u9577\",\"\\u90e8\\u9577\",\"\\u4fc2\\u9577\",\"\\u526f\\u793e\\u9577\"]','[\"160,000,000\\u5186\",\"50,000,000\\u5186\",\"2,000,000\\u5186\",\"6,000,000\\u5186\"]','[\"150,000,000\\u5186\",\"40,000,000\\u5186\",\"10,000,000\\u5186\",\"5,000,000\\u5186\"]','[\"140,000,000\\u5186\",\"30,000,000\\u5186\",\"10,000,000\\u5186\",\"6,000,000\\u5186\"]','10','2','1','3','','2025-01-21','2027-01-20','aoyama会社','千葉',0,0,0,0,'ｇｆぁｆは',1,0,0,0,0,'ｆがｌｈふぁ','2025-01-20','2027-01-20','ふぁｇｆ；あ','２０○○年△△月△△日～２０○○年△△月△△日',0,0,0,0,'ｇｆんふぁ；ｆｊ',0,1,0,'[\"takana\",\"haha\",\"suzuku\"]','[\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u9577\",\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u9577\",\"gsghdsh\"]','[\"take\",\"kna\",\"ttasa\"]','[\"\\u5efa\\u8a2d\\u90e8\\u9580\",\"\\u5916\\u98df\\u90e8\\u9580\",\"\\u5916\\u98df\\u90e8\\u9580\"]','[\"uuu\",\"eee\",\"dffg\"]','[\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u54e1\",\"\\u7dcf\\u52d9\\u90e8\\u9580\\u30fb\\u4fc2\\u54e1\",\"\\u0111gd\"]',NULL,NULL,'2024-12-16 02:36:55',151,'2025-01-21 04:36:40',1,34,'2025-01-14','aoyama会社','THUY','[\"\\u5927\\u91ce\",\"\\u4e39\\u751f\\u8cab\\u592a\\u90ce\",\"\\u4f50\\u85e4\",\"\\u9234\\u6728\",\"\\u9752\\u5c71\"]','1','1','1','１',1,1,0,0,1,0,1,0,0,1,1,0,'',1,1,0,0);

--
-- 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 `support_contract`
--

CREATE TABLE `support_contract` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `specific_skills_affiliation_agency` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `registration_support_organization` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `specific_skilled` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `date_form` date DEFAULT NULL,
  `date_to` date DEFAULT NULL,
  `date` date DEFAULT NULL,
  `first` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `second` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `nominal` text COLLATE utf8mb4_general_ci,
  `amount` text COLLATE utf8mb4_general_ci,
  `anytime` text COLLATE utf8mb4_general_ci,
  `regular` 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,
  `updated_count` bigint DEFAULT NULL,
  `monthly` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total` varchar(255) 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 `support_contract`
--

INSERT INTO `support_contract` VALUES (1,'ádasd','ádasd','ádasd','2024-12-17','2024-12-17','2024-12-17','ádasd','ádasd','[\"\\u00e1dasd\",null,null,null,null,\"\\u00e1das\\u0111\",\"\\u00e1dasd\",null,null,null]','[\"\\u00e1dasd\",null,null,\"\\u00e1dasd\",null,\"\\u00e1dasd\",null,null,null,null]','[null,null,null,null,null,null,null,null,null,null]','[\"1\",null,null,\"1\",null,\"1\",null,null,null,null]',NULL,NULL,'2024-12-16 16:35:31',1,'2024-12-16 17:13:52',1,7,'ádafgsfdgdsdfg',NULL),(2,'田中会社','株式会社 入管','ＫＯＵ ＯＴＵＨＥＩ','2024-12-04','2026-01-14','2025-01-14','ｇふぁｌｈふぁｌｈｆ','法務協同組合','[\"\\u4e8b\\u524d\\u30ac\\u30a4\\u30c0\\u30f3\\u30b9\\u8cbb\\u7528\",\"\\u51fa\\u5165\\u56fd\\u3059\\u308b\\u969b\\u306e\\u9001\\u8fce\",\"\\u8ee2\\u8077\\u652f\\u63f4\",null,null,null,null,null,null,null]','[\"120000\",\"30000\",\"5000\",null,null,null,null,null,null,null]','[\"1\",\"1\",null,null,null,null,null,null,null,null]','[null,null,\"1\",null,null,null,null,null,null,null]',NULL,NULL,'2025-01-02 04:55:39',151,'2025-01-14 07:43:26',1,2,'200000','155000');

--
-- 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_0900_ai_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_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_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','');


