(39744,'2023-05-10 (Wed) 18:50:51','+09:00','2023-05-10 09:50:51','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39745,'2023-05-10 (Wed) 18:51:29','+09:00','2023-05-10 09:51:29','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_worker&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=5&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_worker&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39746,'2023-05-10 (Wed) 18:51:33','+09:00','2023-05-10 09:51:33','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_worker&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_insurance&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39747,'2023-05-10 (Wed) 18:51:35','+09:00','2023-05-10 09:51:35','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_worker&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_insurance&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39748,'2023-05-10 (Wed) 18:52:04','+09:00','2023-05-10 09:52:04','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_insurance&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_insurance&cmd=edit&layout=y&order_field=id&order_updown=ASC&limit=100&offset=0'),(39749,'2023-05-10 (Wed) 18:56:35','+09:00','2023-05-10 09:56:35','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39750,'2023-05-10 (Wed) 18:56:40','+09:00','2023-05-10 09:56:40','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39751,'2023-05-10 (Wed) 18:56:43','+09:00','2023-05-10 09:56:43','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?query_this=%3Fdatabase%3Dhas_beta%26table%3Dtext_salary%26cmd%3Dedit%26layout%3Dy%26order_field%3Did%26order_updown%3DDESC%26limit%3D100%26offset%3D0&database=has_beta&table=text_salary&exe=text_delete&edit_id=482'),(39752,'2023-05-10 (Wed) 18:56:43','+09:00','2023-05-10 09:56:43','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39753,'2023-05-10 (Wed) 18:56:50','+09:00','2023-05-10 09:56:50','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39754,'2023-05-10 (Wed) 20:36:25','+09:00','2023-05-10 11:36:25','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39755,'2023-05-10 (Wed) 20:36:34','+09:00','2023-05-10 11:36:34','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39756,'2023-05-10 (Wed) 20:36:38','+09:00','2023-05-10 11:36:38','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_salary&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39757,'2023-05-10 (Wed) 20:37:45','+09:00','2023-05-10 11:37:45','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39758,'2023-05-10 (Wed) 20:38:04','+09:00','2023-05-10 11:38:04','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39759,'2023-05-10 (Wed) 20:38:14','+09:00','2023-05-10 11:38:14','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39760,'2023-05-10 (Wed) 20:38:42','+09:00','2023-05-10 11:38:42','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39761,'2023-05-10 (Wed) 20:39:51','+09:00','2023-05-10 11:39:51','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39762,'2023-05-10 (Wed) 20:40:24','+09:00','2023-05-10 11:40:24','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39763,'2023-05-10 (Wed) 20:41:11','+09:00','2023-05-10 11:41:11','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_shift&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_tax&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39764,'2023-05-10 (Wed) 20:41:14','+09:00','2023-05-10 11:41:14','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_tax&cmd=edit&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_tax&cmd=search&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0'),(39765,'2023-05-10 (Wed) 20:41:17','+09:00','2023-05-10 11:41:17','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?database=has_beta&table=text_tax&cmd=search&layout=y&order_field=id&order_updown=DESC&limit=100&offset=0','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?'),(39766,'2023-05-10 (Wed) 20:41:23','+09:00','2023-05-10 11:41:23','Asia/Tokyo','','192.168.1.143','143.1.168.192.in-addr.arpa	name = w.w.\n143.1.168.192.in-addr.arpa	name = test.\n143.1.168.192.in-addr.arpa	name = v.v.\n143.1.168.192.in-addr.arpa	name = homepage.\n143.1.168.192.in-addr.arpa	name = test.homepage.\n','http://w.w/DATABASE/data6/?','/var/www/DATABASE/data6/index.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://w.w/DATABASE/data6?database=has_beta&table=text_tax&cmd=search&layout=y&order_field=id&order_updown=ASC&limit=5&offset=0'),(39767,'2023-05-10 (Wed) 20:46:44','+09:00','2023-05-10 11:46:44','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5'),(39768,'2023-05-10 (Wed) 20:52:34','+09:00','2023-05-10 11:52:34','Asia/Tokyo','','210.132.160.161','fpd284a0a1.ap.nuro.jp\n','http://i0you.com/local2/has_gamma_core.php?database=has_beta&subj=worker&menu=search&offset=&auto_number=KO000185&exe=write&subj=worker&menu=search','/var/www/DATABASE/data6/local2/has_alpha_core.php','en-US,en;q=0.5','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/112.0','http://i0you.com/local2/has_alpha_core.php?id_group=10&year=2023&month=5');

--
-- Table structure for table `text_company`
--

CREATE TABLE `text_company` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `kana` varchar(255) DEFAULT NULL,
  `person` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `service` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_company`
--

INSERT INTO `text_company` VALUES (3,2970,14,'川崎検査クリニック','カワサキケンサクリニック','内山　正一郎','福岡市早良区百道1-1','092-841-2131','病院業務'),(4,2982,14,'セブンイレブン',NULL,'東田　桜子','東京都千代田区二番町8番地8 二番町ガーデンビル','03-6238-3711','コンビニエンスストア業務');

--
-- Table structure for table `text_daily`
--

CREATE TABLE `text_daily` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_worker` int DEFAULT NULL,
  `id_job` int DEFAULT NULL,
  `start` timestamp NULL DEFAULT NULL,
  `finish` timestamp NULL DEFAULT NULL,
  `hourly` smallint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_daily`
--


--
-- Table structure for table `text_dakoku`
--

CREATE TABLE `text_dakoku` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_shift` int DEFAULT NULL,
  `id_job` int DEFAULT NULL,
  `id_worker` int DEFAULT NULL,
  `start` timestamp NULL DEFAULT NULL,
  `finish` timestamp NULL DEFAULT NULL,
  `hourly` smallint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=615 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_dakoku`
--

INSERT INTO `text_dakoku` VALUES (552,37710,2,530,1,206,'2023-05-08 11:00:00','2023-05-08 11:00:00',1500),(554,37748,2,533,1,206,'2023-05-02 23:00:00','2023-05-03 00:00:00',1500),(557,38050,5,522,2,168,'2023-05-09 00:25:00','2023-05-09 00:38:00',1250),(558,38054,5,504,17,156,'2023-05-09 00:30:00','2023-05-09 00:52:00',1012),(559,38134,5,503,17,156,'2023-05-08 00:00:00','2023-05-08 04:00:00',1012),(560,38134,5,503,17,156,'2023-05-08 05:00:00','2023-05-08 09:00:00',1012),(561,38150,5,521,2,168,'2023-05-08 00:00:00','2023-05-08 05:00:00',1250),(562,38308,5,551,10,193,'2023-05-09 01:00:00','2023-05-09 05:00:00',1000),(563,38318,5,540,10,159,'2023-05-08 22:26:00','2023-05-09 01:50:00',1000),(565,38348,5,541,10,161,'2023-05-09 01:50:00','2023-05-09 01:50:00',1000),(567,38371,5,552,27,191,'2023-05-09 01:52:00','2023-05-09 06:00:00',1100),(570,38424,5,531,17,206,'2023-05-08 12:30:00','2023-05-08 13:00:00',1012),(574,38431,5,542,1,206,'2023-05-09 15:00:00','2023-05-09 15:00:00',1500),(576,38440,5,543,1,206,'2023-05-10 00:00:00','2023-05-10 04:00:00',1500),(577,38440,5,543,1,206,'2023-05-10 05:00:00','2023-05-10 11:00:00',1500),(580,38496,5,544,1,206,'2023-05-11 00:00:00','2023-05-11 04:00:00',1500),(581,38496,5,544,1,206,'2023-05-11 05:00:00','2023-05-11 11:00:00',1500),(584,38524,5,534,1,206,'2023-05-09 02:00:00','2023-05-09 06:00:00',1500),(585,38524,5,534,1,206,'2023-05-09 07:00:00','2023-05-09 09:00:00',1500),(603,39025,5,552,27,208,'2023-05-09 06:00:00','2023-05-09 06:00:00',0),(605,39041,5,522,2,208,'2023-05-09 08:30:00','2023-05-09 08:30:00',0),(606,39047,5,540,10,208,'2023-05-09 13:00:00','2023-05-09 13:00:00',0),(607,39061,5,540,10,208,'2023-05-09 13:00:00','2023-05-09 13:00:00',0),(608,39084,5,522,2,208,'2023-05-09 08:30:00','2023-05-09 08:30:00',0),(610,39179,2,534,1,208,'2023-05-09 09:00:00','2023-05-09 09:00:00',1500),(611,39209,2,572,1,208,'2023-05-09 09:00:00','2023-05-09 09:00:00',1500),(612,39212,2,573,1,208,'2023-05-09 09:00:00','2023-05-09 09:00:00',1500),(613,39276,2,575,17,197,'2023-05-09 14:00:00','2023-05-09 14:00:00',1012),(614,39289,2,576,17,177,'2023-05-09 14:00:00','2023-05-09 14:00:00',1012);

--
-- Table structure for table `text_group`
--

CREATE TABLE `text_group` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `code` char(10) DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `place` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_group`
--

INSERT INTO `text_group` VALUES (1,7914,1,'HA','博多エリア','博多','なし',''),(2,7967,1,'KU','久留米エリア','久留米','なし',''),(10,13497,1,'KO','小倉エリア','小倉','なし',''),(11,13841,1,'SA','佐賀エリア','佐賀','',''),(12,13843,1,'OG','小郡エリア','小郡','',''),(13,13845,1,'II','飯塚エリア','飯塚','',''),(14,13847,1,'TO','鳥栖エリア 車工場','鳥栖','',''),(15,13849,1,'AS','朝倉エリア','朝倉','',''),(16,13851,1,'IT','糸島エリア','糸島','',''),(18,22941,5,'HA0001','鳥栖エリア プラスチック工場','博多区','',''),(19,23214,5,'Ha','博多','博多','',''),(20,23216,5,'','','','',''),(21,24301,6,'','Cake factory','Hakata','Making delicious cakes','(N/A)'),(22,24935,5,'KG','古賀エリア','福岡県','N/A','N/A'),(23,24948,5,'II','飯塚エリア','福岡県','N/A','N/A'),(24,24960,5,'IT','糸島エリア','福江岡県','N/A','N/A'),(25,24968,5,'IT','糸島エリア','前原','N/A','N/A'),(26,24974,5,'OG','小郡エリア','小郡','N/A','N/A'),(27,24997,5,'KO','小倉エリア','小倉','N/A','N/A'),(28,25082,5,'','博多エリア','','',''),(29,25608,2,'','','','',''),(30,25612,2,'','','','','');

--
-- Table structure for table `text_insurance`
--

CREATE TABLE `text_insurance` (
  `id` int NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `todoufuken` char(10) DEFAULT NULL,
  `rate` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=174 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_insurance`
--

INSERT INTO `text_insurance` VALUES (111,1,1,'北海道',10.29),(112,1,1,'青森県',9.79),(113,1,1,'岩手県',9.77),(114,1,1,'宮城県',10.05),(115,1,1,'秋田県',9.86),(116,1,1,'山形県',9.98),(117,1,1,'福島県',9.53),(118,1,1,'茨城県',9.73),(119,1,1,'栃木県',9.96),(120,1,1,'群馬県',9.76),(121,1,1,'埼玉県',9.82),(122,1,1,'千葉県',9.87),(123,1,1,'東京都',10),(124,1,1,'神奈川県',10.02),(125,1,1,'新潟県',9.33),(126,1,1,'富山県',9.57),(127,1,1,'石川県',9.66),(128,1,1,'福井県',9.91),(129,1,1,'山梨県',9.67),(130,1,1,'長野県',9.49),(131,1,1,'岐阜県',9.8),(132,1,1,'静岡県',9.75),(133,1,1,'愛知県',10.01),(134,1,1,'三重県',9.81),(135,1,1,'滋賀県',9.73),(136,1,1,'京都府',10.09),(137,1,1,'大阪府',10.29),(138,1,1,'兵庫県',10.17),(139,1,1,'奈良県',10.14),(140,1,1,'和歌山県',9.94),(141,1,1,'鳥取県',9.82),(142,1,1,'島根県',10.26),(143,1,1,'岡山県',10.07),(144,1,1,'広島県',9.92),(145,1,1,'山口県',9.96),(146,1,1,'徳島県',10.25),(147,1,1,'香川県',10.23),(148,1,1,'愛媛県',10.01),(149,1,1,'高知県',10.1),(150,1,1,'福岡県',10.36),(151,1,1,'佐賀県',10.51),(152,1,1,'長崎県',10.21),(153,1,1,'熊本県',10.32),(154,1,1,'大分県',10.2),(155,1,1,'宮崎県',9.76),(156,1,1,'鹿児島県',10.26),(157,1,1,'沖縄県',9.89);

--
-- Table structure for table `text_job`
--

CREATE TABLE `text_job` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_company` int DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `place` varchar(255) DEFAULT NULL,
  `station` varchar(255) DEFAULT NULL,
  `hourly` smallint DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_job`
--

INSERT INTO `text_job` VALUES (1,3121,14,NULL,'PCR受付・案内業務・検体の配送','赤坂駅前PCR検査センター','福岡市中央区赤坂1-9-2','福岡市営地下鉄　赤坂駅',1500,'オープニング'),(2,6726,1,NULL,'別件','別件内容','病院','久留米支部',1250,'なし'),(8,14019,1,0,'いろは病院','予防接種','福岡','なし',1350,'（なし）'),(10,19730,1,0,'スーパー','キャッシャー','福岡市内','博多区',1000,'なし'),(11,24315,6,0,'Making cakes','Making cakes','Hakata','Hakata station',1000,'na'),(17,24906,5,0,'介護','アシスタント介護','博多','N/A',1012,'N/A'),(20,25012,5,0,'セブン','コンビニ','久留米','',1000,''),(24,25218,5,0,'工場　（佐川）','','全エリア','',1000,''),(25,25393,5,0,'車部品　（トヨタ）','','全エリア','',1500,''),(26,25395,5,0,'倉庫作業','Warehouse Work','全エリア','N/A',1050,'N/A'),(27,25479,5,0,'冷凍食品工場','Frozen Food Factory','全エリア','N/A',1100,'N/A'),(28,25483,5,0,'工場 (包装）','Packaging','全エリア','N/A',1000,'N/A'),(29,25489,5,0,'介護 (シンフォニア）','Caregiver','全エリア','N/A',1200,'N/A'),(30,25491,5,0,'工場 (弁当）','Making Bento','全エリア','N/A',1000,'N/A'),(31,26050,5,0,'清掃','Building Cleaning','朝倉','N/A',1000,'N/A');

--
-- Table structure for table `text_salary`
--

CREATE TABLE `text_salary` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_worker` int DEFAULT NULL,
  `year` year DEFAULT NULL,
  `month` tinyint DEFAULT NULL,
  `age_end_of_month` tinyint DEFAULT NULL,
  `visa` varchar(32) DEFAULT NULL,
  `family` tinyint DEFAULT NULL,
  `todoufuken` char(10) DEFAULT NULL,
  `rate_kenkou` float DEFAULT NULL,
  `rate_kouseinenkin` float DEFAULT NULL,
  `rate_koyou` float DEFAULT NULL,
  `rate_rousai` float DEFAULT NULL,
  `rate_kaigo` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=484 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_salary`
--

INSERT INTO `text_salary` VALUES (18,7180,1,120,2022,12,39,'Japanese_national_dependent',0,NULL,10.21,18.3,0.5,NULL,NULL),(21,7801,1,119,2023,1,46,NULL,NULL,NULL,10.25,18.3,0.5,0.3,NULL),(25,15286,1,120,2023,1,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(32,15641,1,120,2021,5,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(34,15649,1,120,2021,2,37,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(35,15692,1,120,2023,2,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(36,15755,1,1,2023,2,42,'Japanese_national_dependent',1,'東京都',9.81,18.3,0.5,0.3,1.64),(37,15857,1,120,2022,2,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(38,15908,1,120,2022,4,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(39,15942,1,120,2022,5,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(40,15942,1,120,2022,6,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(41,15942,1,120,2022,7,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(42,15942,1,120,2022,8,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(43,15942,1,120,2022,9,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(44,15942,1,120,2022,10,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(45,15942,1,120,2022,11,39,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(46,16040,1,120,2021,4,37,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(47,16040,1,120,2021,6,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(48,16040,1,120,2021,7,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(49,16040,1,120,2021,8,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(50,16040,1,120,2021,9,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(51,16040,1,120,2021,10,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(52,16040,1,120,2021,11,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(53,16040,1,120,2021,12,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(54,16040,1,120,2022,1,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(55,16040,1,120,2022,3,38,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(56,16089,1,120,2021,1,37,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(58,16568,1,115,2023,1,46,'',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(59,17157,1,115,2023,2,46,'',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(62,18637,1,120,2022,13,38,'student_visa',1,'福岡県',10.21,18.3,0.5,0.3,0),(63,18805,1,120,2023,13,39,'student_visa',1,'福岡県',10.21,18.3,0.5,0.3,0),(70,18843,1,115,2022,10,45,'',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(71,18843,1,115,2022,11,45,'',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(72,18843,1,115,2022,12,46,'Japanese_national',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(73,19455,1,115,2022,2,45,'Japanese_national',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(74,19474,1,132,2023,2,35,'',2,'福岡県',10.21,18.3,0.5,0.3,0),(75,19474,1,145,2023,2,26,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(76,19476,1,146,2023,2,22,'Japanese_national',0,'福岡市早良区百道',9.81,18.3,0.5,0.3,0),(77,19476,1,150,2023,2,42,'Japanese_national',0,'福岡県',9.81,18.3,0.5,0.3,1.64),(78,19476,1,151,2023,2,26,'Japanese_national',2,'福岡市早良区百道',9.81,18.3,0.5,0.3,0),(79,19481,1,132,2022,2,34,'',2,'福岡県',10.21,18.3,0.5,0.3,0),(80,19481,1,145,2022,2,25,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(81,19488,1,132,2023,1,35,'',2,'福岡県',10.21,18.3,0.5,0.3,0),(82,19488,1,145,2023,1,26,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(83,19514,1,115,2023,13,46,'Japanese_national',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(84,19781,1,153,2023,2,25,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,0),(85,19782,1,155,2023,2,30,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(86,20888,2,124,2023,2,31,'',2,'秋田県',10.27,18.3,0.5,0.3,0),(87,21361,2,132,2022,12,35,'',2,'福岡県',10.21,18.3,0.5,0.3,0),(88,21361,2,145,2022,12,26,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(89,21926,1,115,2023,3,46,'Japanese_national_dependent',2,'岡山県',10.25,18.3,0.5,0.3,1.64),(90,21926,1,120,2023,3,39,'Japanese_national_dependent',1,'福岡県',10.21,18.3,0.5,0.3,0),(91,21926,1,132,2023,3,35,'',2,'福岡県',10.21,18.3,0.5,0.3,0),(92,21926,1,145,2023,3,27,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(93,21927,1,1,2023,3,42,'Japanese_national_dependent',1,'東京都',9.81,18.3,0.5,0.3,1.64),(97,22769,1,146,2023,3,23,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(98,22769,1,150,2023,3,42,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,1.64),(99,22769,1,151,2023,3,26,'Japanese_national',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(100,22946,5,156,2023,3,25,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(101,23453,2,156,2023,2,24,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(102,23853,2,146,2023,1,22,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(103,23853,2,150,2023,1,42,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,1.64),(104,23853,2,151,2023,1,26,'Japanese_national',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(105,23853,2,156,2023,1,24,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(106,24257,6,153,2023,3,25,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(108,24395,6,132,2022,1,34,'',2,'福岡県',10.21,18.3,0.5,0.3,0),(109,24395,6,145,2022,1,25,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(110,24395,6,146,2022,1,21,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(111,24395,6,150,2022,1,41,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,1.64),(112,24395,6,151,2022,1,25,'Japanese_national',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(113,24395,6,156,2022,1,23,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(114,24397,6,153,2022,1,24,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(115,24410,6,153,2023,1,25,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(116,24602,5,160,2023,3,25,'Japanese_national',0,'',-1,18.3,0.5,0.3,0),(117,24614,5,157,2023,3,25,'Japanese_national',0,'',-1,18.3,0.5,0.3,0),(118,24959,5,129,2023,3,24,'',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(119,24959,5,138,2023,3,32,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(120,24959,5,143,2023,3,26,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(121,24959,5,147,2023,3,25,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,0),(122,24959,5,148,2023,3,25,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,0),(123,24959,5,149,2023,3,25,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,0),(124,24959,5,154,2023,3,31,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(125,25115,5,163,2023,3,30,'student_visa',0,'',-1,18.3,0.5,0.3,0),(126,25118,5,164,2023,3,29,'spouse_visa',0,'',-1,18.3,0.5,0.3,0),(127,25120,2,158,2023,3,25,'',0,'',-1,18.3,0.5,0.3,0),(128,25120,2,159,2023,3,21,'student_visa',0,'',-1,18.3,0.5,0.3,0),(129,25120,2,161,2023,3,20,'student_visa',0,'',-1,18.3,0.5,0.3,0),(130,25120,2,162,2023,3,31,'Japanese_national_dependent',3,'',-1,18.3,0.5,0.3,0),(131,25120,2,165,2023,3,27,'student_visa',0,'',-1,18.3,0.5,0.3,0),(132,25137,2,166,2023,3,36,'spouse_visa',0,'',-1,18.3,0.5,0.3,0),(133,25185,5,167,2023,3,30,'',0,'',-1,18.3,0.5,0.3,0),(134,25185,5,169,2023,3,31,'long_term_visa',0,'',-1,18.3,0.5,0.3,0),(135,25588,2,168,2023,3,29,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(136,25588,2,170,2023,3,24,'long_term_visa',0,'',-1,18.3,0.5,0.3,0),(137,25588,2,171,2023,3,42,'student_visa',0,'',-1,18.3,0.5,0.3,1.64),(138,25588,2,177,2023,3,25,'student_visa',0,'',-1,18.3,0.5,0.3,0),(139,25588,2,179,2023,3,24,'student_visa',0,'',-1,18.3,0.5,0.3,0),(140,25588,2,181,2023,3,20,'student_visa',0,'',-1,18.3,0.5,0.3,0),(141,25588,2,182,2023,3,21,'student_visa',0,'',-1,18.3,0.5,0.3,0),(142,25588,2,183,2023,3,24,'student_visa',0,'',-1,18.3,0.5,0.3,0),(143,25676,5,1,2023,13,42,'Japanese_national_dependent',1,'東京都',9.81,18.3,0.5,0.3,1.64),(144,26026,5,188,2023,3,23,'student_visa',0,'',-1,18.3,0.5,0.3,0),(145,26054,5,189,2023,3,34,'student_visa',0,'',-1,18.3,0.5,0.3,0),(146,26110,5,189,2023,13,34,'student_visa',0,'',-1,18.3,0.5,0.3,0),(147,26126,5,155,2023,3,31,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(148,26126,5,190,2023,3,23,'student_visa',0,'',-1,18.3,0.5,0.3,0),(149,26162,2,187,2023,3,23,'student_visa',0,'',-1,18.3,0.5,0.3,0),(150,26324,5,173,2023,3,29,'student_visa',0,'',-1,18.3,0.5,0.3,0),(151,26324,5,174,2023,3,21,'long_term_visa',0,'',-1,18.3,0.5,0.3,0),(152,26324,5,175,2023,3,21,'student_visa',0,'',-1,18.3,0.5,0.3,0),(153,26324,5,176,2023,3,22,'student_visa',0,'',-1,18.3,0.5,0.3,0),(154,26324,5,178,2023,3,30,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(155,26359,5,195,2023,3,25,'student_visa',0,'',-1,18.3,0.5,0.3,0),(156,27044,2,191,2023,3,22,'student_visa',0,'',-1,18.3,0.5,0.3,0),(157,27044,2,192,2023,3,10,'student_visa',0,'',-1,18.3,0.5,0.3,0),(158,27044,2,193,2023,3,23,'student_visa',0,'',-1,18.3,0.5,0.3,0),(159,27044,2,197,2023,3,22,'student_visa',0,'',-1,18.3,0.5,0.3,0),(160,28175,2,1,2023,4,42,'Japanese_national_dependent',1,'東京都',9.81,18.3,0.5,0.3,1.64),(161,28705,2,120,2023,4,39,'student_visa',1,'福岡県',10.21,18.3,0.5,0.3,0),(163,29566,5,132,2023,4,35,'Japanese_national',2,'福岡県',10.21,18.3,0.5,0.3,0),(164,29566,5,145,2023,4,27,'Japanese_national',1,'東京都',9.81,18.3,0.5,0.3,0),(165,29566,5,146,2023,4,23,'student_visa',0,'福岡県',10.21,18.3,0.5,0.3,0),(166,29566,5,150,2023,4,42,'Japanese_national',0,'福岡県',10.21,18.3,0.5,0.3,1.64),(167,29566,5,151,2023,4,27,'Japanese_national',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(168,29566,5,156,2023,4,25,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(169,29566,5,158,2023,4,25,'',0,'',-1,18.3,0.5,0.3,0),(170,29566,5,159,2023,4,21,'student_visa',0,'',-1,18.3,0.5,0.3,0),(171,29566,5,161,2023,4,20,'student_visa',0,'',-1,18.3,0.5,0.3,0),(172,29566,5,162,2023,4,31,'Japanese_national_dependent',3,'',-1,18.3,0.5,0.3,0),(173,29566,5,165,2023,4,27,'student_visa',0,'',-1,18.3,0.5,0.3,0),(174,29566,5,166,2023,4,36,'spouse_visa',0,'',-1,18.3,0.5,0.3,0),(175,29566,5,168,2023,4,29,'Japanese_national_dependent',0,'',-1,18.3,0.5,0.3,0),(176,29566,5,170,2023,4,24,'long_term_visa',0,'',-1,18.3,0.5,0.3,0),(177,29566,5,171,2023,4,42,'student_visa',0,'',-1,18.3,0.5,0.3,1.64),(178,29566,5,177,2023,4,25,'student_visa',0,'',-1,18.3,0.5,0.3,0),(179,29566,5,179,2023,4,24,'student_visa',0,'',-1,18.3,0.5,0.3,0),(180,29566,5,181,2023,4,20,'student_visa',0,'',-1,18.3,0.5,0.3,0),(181,29566,5,182,2023,4,21,'student_visa',0,'',-1,18.3,0.5,0.3,0),(182,29566,5,183,2023,4,24,'student_visa',0,'',-1,18.3,0.5,0.3,0),(183,29566,5,187,2023,4,23,'student_visa',0,'',-1,18.3,0.5,0.3,0),(184,29566,5,191,2023,4,22,'student_visa',0,'',-1,18.3,0.5,0.3,0),(185,29566,5,192,2023,4,10,'student_visa',0,'',-1,18.3,0.5,0.3,0),(186,29566,5,193,2023,4,23,'student_visa',0,'',-1,18.3,0.5,0.3,0),(187,29566,5,197,2023,4,22,'student_visa',0,'',-1,18.3,0.5,0.3,0),(188,30325,2,133,2023,4,30,'',1,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(189,30333,2,133,2023,2,30,'Japanese_national_dependent',1,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(190,30335,2,133,2023,3,30,'Japanese_national_dependent',1,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(191,30458,2,119,2023,4,32,'Japanese_national_dependent',1,'東京都',9.81,18.3,0.5,0.3,0),(192,30504,2,115,2023,4,46,'Japanese_national_dependent',3,'岡山県',10.07,18.3,0.5,0.3,1.64),(193,30726,5,114,2023,2,42,'',0,'東京都',10,18.3,0.5,0.3,1.64),(194,30727,5,114,2023,1,42,'',0,'東京都',10,18.3,0.5,0.3,1.64),(195,30728,5,2,2023,1,31,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(196,30729,5,2,2023,2,32,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(197,30731,5,143,2023,2,26,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(198,30732,5,160,2023,2,24,'Japanese_national',0,'',-1,18.3,0.5,0.3,0),(199,30733,5,160,2023,1,24,'Japanese_national',0,'',-1,18.3,0.5,0.3,0),(200,31155,2,112,2023,3,44,'',0,'北海道',-1,18.3,0.5,0.3,1.64),(201,31199,2,112,2023,2,44,'Japanese_national_dependent',0,'北海道',-1,18.3,0.5,0.3,1.64),(202,31359,2,112,2023,1,44,'Japanese_national_dependent',0,'北海道',-1,18.3,0.5,0.3,1.64),(203,31409,2,112,2023,4,44,'Japanese_national',0,'北海道',-1,18.3,0.5,0.3,1.64),(204,32210,2,112,2023,13,44,'Japanese_national',1,'北海道',-1,18.3,0.5,0.3,1.64),(205,32234,2,112,2023,14,-128,'Japanese_national',1,'北海道',-1,18.3,0.5,0.3,0),(206,32281,2,112,2023,0,-128,'Japanese_national',1,'北海道',-1,18.3,0.5,0.3,0),(207,32741,2,115,2022,1,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(209,32906,2,115,2022,3,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(210,32969,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(211,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(212,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(213,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(214,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(215,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(216,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(217,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(218,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(219,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(220,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(221,32998,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(222,32998,2,115,2022,0,46,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(223,32999,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(224,32999,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(225,32999,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(226,32999,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(227,32999,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(228,32999,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(229,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(230,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(231,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(232,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(233,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(234,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(235,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(236,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(237,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(238,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(239,33000,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(240,33000,2,115,2022,0,46,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(241,33001,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(242,33001,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(243,33001,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(244,33001,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(245,33001,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(246,33001,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(247,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(248,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(249,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(250,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(251,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(252,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(253,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(254,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(255,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(256,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(257,33004,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(258,33004,2,115,2022,0,46,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(259,33005,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(260,33005,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(261,33005,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(262,33005,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(263,33005,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(264,33005,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(265,33006,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(266,33006,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(267,33006,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(268,33006,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(269,33006,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(270,33006,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(271,33008,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(272,33008,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(273,33008,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(274,33008,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(275,33008,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(276,33008,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(277,33010,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(278,33010,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(279,33010,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(280,33010,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(281,33010,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(282,33010,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(283,33012,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(284,33012,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(285,33012,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(286,33012,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(287,33012,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(288,33012,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(289,33028,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(290,33028,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(291,33028,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(292,33028,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(293,33028,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(294,33028,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(295,33029,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(296,33029,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(297,33029,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(298,33029,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(299,33029,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(300,33029,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(301,33030,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(302,33030,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(303,33030,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(304,33030,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(305,33030,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(306,33030,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(307,33031,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(308,33031,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(309,33031,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(310,33031,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(311,33031,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(312,33031,2,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(313,33034,2,158,2023,1,24,'',0,'',0,18.3,0.5,0.3,0),(314,33034,2,159,2023,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(315,33034,2,161,2023,1,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(316,33034,2,162,2023,1,31,'Japanese_national_dependent',3,'',0,18.3,0.5,0.3,0),(317,33034,2,165,2023,1,27,'student_visa',0,'',0,18.3,0.5,0.3,0),(318,33034,2,166,2023,1,36,'spouse_visa',0,'',0,18.3,0.5,0.3,0),(319,33034,2,168,2023,1,29,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(320,33034,2,170,2023,1,24,'long_term_visa',0,'',0,18.3,0.5,0.3,0),(321,33034,2,171,2023,1,42,'student_visa',0,'',0,18.3,0.5,0.3,1.64),(322,33034,2,177,2023,1,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(323,33034,2,179,2023,1,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(324,33034,2,181,2023,1,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(325,33034,2,182,2023,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(326,33034,2,183,2023,1,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(327,33034,2,187,2023,1,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(328,33034,2,191,2023,1,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(329,33034,2,192,2023,1,10,'student_visa',0,'',0,18.3,0.5,0.3,0),(330,33034,2,193,2023,1,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(331,33034,2,197,2023,1,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(332,33066,2,158,2023,2,24,'',0,'',0,18.3,0.5,0.3,0),(333,33066,2,159,2023,2,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(334,33066,2,161,2023,2,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(335,33066,2,162,2023,2,31,'Japanese_national_dependent',3,'',0,18.3,0.5,0.3,0),(336,33066,2,165,2023,2,27,'student_visa',0,'',0,18.3,0.5,0.3,0),(337,33066,2,166,2023,2,36,'spouse_visa',0,'',0,18.3,0.5,0.3,0),(338,33066,2,168,2023,2,29,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(339,33066,2,170,2023,2,24,'long_term_visa',0,'',0,18.3,0.5,0.3,0),(340,33066,2,171,2023,2,42,'student_visa',0,'',0,18.3,0.5,0.3,1.64),(341,33066,2,177,2023,2,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(342,33066,2,179,2023,2,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(343,33066,2,181,2023,2,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(344,33066,2,182,2023,2,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(345,33066,2,183,2023,2,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(346,33066,2,187,2023,2,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(347,33066,2,191,2023,2,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(348,33066,2,192,2023,2,10,'student_visa',0,'',0,18.3,0.5,0.3,0),(349,33066,2,193,2023,2,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(350,33066,2,197,2023,2,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(351,33147,5,115,2023,0,-128,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,0),(352,33246,2,119,2023,3,32,'Japanese_national_dependent',1,'東京都',-1,18.3,0.5,0.3,0),(353,33260,2,129,2023,1,23,'',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(354,33260,2,138,2023,1,32,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(355,33260,2,143,2023,1,26,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(356,33260,2,147,2023,1,25,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,0),(357,33260,2,148,2023,1,25,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,0),(358,33260,2,149,2023,1,25,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,0),(359,33260,2,154,2023,1,30,'student_visa',0,'福岡県',-1,18.3,0.5,0.3,0),(360,33260,2,173,2023,1,29,'student_visa',0,'',0,18.3,0.5,0.3,0),(361,33260,2,174,2023,1,21,'long_term_visa',0,'',0,18.3,0.5,0.3,0),(362,33260,2,175,2023,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(363,33260,2,176,2023,1,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(364,33260,2,178,2023,1,29,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(365,33260,2,195,2023,1,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(366,33260,2,200,2023,1,37,'permanent_resident_visa',0,'',0,18.3,0.5,0.3,0),(367,33261,2,184,2023,1,22,'',0,'',0,18.3,0.5,0.3,0),(368,33261,2,185,2023,1,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(369,33261,2,196,2023,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(370,33261,2,198,2023,1,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(371,33284,2,119,2022,1,31,'Japanese_national_dependent',1,'東京都',-1,18.3,0.5,0.3,0),(372,33284,2,158,2022,1,23,'',0,'',0,18.3,0.5,0.3,0),(373,33284,2,159,2022,1,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(374,33284,2,161,2022,1,19,'student_visa',0,'',0,18.3,0.5,0.3,0),(375,33284,2,162,2022,1,30,'Japanese_national_dependent',3,'',0,18.3,0.5,0.3,0),(376,33284,2,165,2022,1,26,'student_visa',0,'',0,18.3,0.5,0.3,0),(377,33284,2,166,2022,1,35,'spouse_visa',0,'',0,18.3,0.5,0.3,0),(378,33284,2,168,2022,1,28,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(379,33284,2,170,2022,1,23,'long_term_visa',0,'',0,18.3,0.5,0.3,0),(380,33284,2,171,2022,1,41,'student_visa',0,'',0,18.3,0.5,0.3,1.64),(381,33284,2,177,2022,1,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(382,33284,2,179,2022,1,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(383,33284,2,181,2022,1,19,'student_visa',0,'',0,18.3,0.5,0.3,0),(384,33284,2,182,2022,1,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(385,33284,2,183,2022,1,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(386,33284,2,187,2022,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(387,33284,2,191,2022,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(388,33284,2,192,2022,1,9,'student_visa',0,'',0,18.3,0.5,0.3,0),(389,33284,2,193,2022,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(390,33284,2,197,2022,1,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(391,33577,5,1,2023,5,42,'Japanese_national_dependent',1,'東京都',-1,18.3,0.5,0.3,1.64),(392,33578,5,112,2023,5,44,'Japanese_national',1,'北海道',-1,18.3,0.5,0.3,1.64),(393,33578,5,115,2023,5,46,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(394,33578,5,119,2023,5,32,'Japanese_national_dependent',1,'東京都',-1,18.3,0.5,0.3,0),(395,33578,5,120,2023,5,40,'student_visa',1,'福岡県',-1,18.3,0.5,0.3,1.64),(396,33578,5,132,2023,5,35,'Japanese_national',2,'福岡県',-1,18.3,0.5,0.3,0),(397,33578,5,145,2023,5,27,'Japanese_national',1,'東京都',-1,18.3,0.5,0.3,0),(398,33578,5,146,2023,5,23,'student_visa',0,'福岡県',-1,18.3,0.5,0.3,0),(399,33578,5,150,2023,5,42,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,1.64),(400,33578,5,151,2023,5,27,'Japanese_national',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(401,33578,5,156,2023,5,25,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(402,33578,5,158,2023,5,25,'',0,'',0,18.3,0.5,0.3,0),(403,33578,5,159,2023,5,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(404,33578,5,161,2023,5,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(405,33578,5,162,2023,5,32,'Japanese_national_dependent',3,'',0,18.3,0.5,0.3,0),(406,33578,5,165,2023,5,28,'student_visa',0,'',0,18.3,0.5,0.3,0),(407,33578,5,166,2023,5,36,'spouse_visa',0,'',0,18.3,0.5,0.3,0),(408,33578,5,168,2023,5,29,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(409,33578,5,170,2023,5,24,'long_term_visa',0,'',0,18.3,0.5,0.3,0),(410,33578,5,171,2023,5,42,'student_visa',0,'',0,18.3,0.5,0.3,1.64),(411,33578,5,177,2023,5,25,'student_visa',0,'',0,18.3,0.5,0.3,0),(412,33578,5,179,2023,5,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(413,33578,5,181,2023,5,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(414,33578,5,182,2023,5,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(415,33578,5,183,2023,5,24,'student_visa',0,'',0,18.3,0.5,0.3,0),(416,33578,5,187,2023,5,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(417,33578,5,191,2023,5,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(418,33578,5,192,2023,5,10,'student_visa',0,'',0,18.3,0.5,0.3,0),(419,33578,5,193,2023,5,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(420,33578,5,197,2023,5,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(421,34866,2,143,2023,5,27,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(422,34892,2,153,2023,5,25,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(423,34898,2,129,2023,5,24,'Japanese_national_dependent',2,'福岡市早良区百道',-1,18.3,0.5,0.3,0),(424,34898,2,138,2023,5,32,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(425,34898,2,147,2023,5,25,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,0),(426,34898,2,148,2023,5,25,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,0),(427,34898,2,149,2023,5,25,'Japanese_national',0,'福岡県',-1,18.3,0.5,0.3,0),(428,34898,2,154,2023,5,31,'student_visa',0,'福岡県',-1,18.3,0.5,0.3,0),(429,34898,2,173,2023,5,29,'student_visa',0,'',0,18.3,0.5,0.3,0),(430,34898,2,174,2023,5,21,'long_term_visa',0,'',0,18.3,0.5,0.3,0),(431,34898,2,175,2023,5,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(432,34898,2,176,2023,5,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(433,34898,2,178,2023,5,30,'Japanese_national_dependent',0,'',0,18.3,0.5,0.3,0),(434,34898,2,195,2023,5,25,'student_visa',0,'',0,18.3,0.5,0.3,0),(435,34898,2,200,2023,5,38,'permanent_resident_visa',0,'',0,18.3,0.5,0.3,0),(436,36516,5,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(437,36516,5,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(438,36516,5,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(439,36516,5,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(440,36516,5,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(441,36516,5,115,2022,0,45,'Japanese_national_dependent',3,'岡山県',-1,18.3,0.5,0.3,1.64),(442,37159,2,118,2023,5,82,'Japanese_national',2,'福岡県福岡市早良区百',-1,18.3,0,0.3,0),(443,37162,2,2,2023,5,32,'Japanese_national',0,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(444,37163,2,133,2023,5,30,'Japanese_national_dependent',1,'福岡県福岡市早良区百',-1,18.3,0.5,0.3,0),(445,37412,2,155,2023,5,31,'student_visa',0,'福岡県',-1,18.3,0.5,0.3,0),(446,37659,2,206,2023,5,43,'Japanese_national',0,'',0,18.3,0.5,0.3,1.64),(447,37752,2,206,2023,0,43,'Japanese_national',0,'',0,18.3,0.5,0.3,1.64),(448,37752,2,206,2023,0,43,'Japanese_national',0,'',0,18.3,0.5,0.3,1.64),(449,37752,2,206,2023,0,43,'Japanese_national',0,'',0,18.3,0.5,0.3,1.64),(450,37752,2,206,2023,0,43,'Japanese_national',0,'',0,18.3,0.5,0.3,1.64),(451,37904,5,206,2023,3,43,'Japanese_national',0,'',0,18.3,0.5,0.3,1.64),(452,38021,5,184,2023,3,22,'',0,'',0,18.3,0.5,0.3,0),(453,38021,5,185,2023,3,20,'student_visa',0,'',0,18.3,0.5,0.3,0),(454,38021,5,196,2023,3,21,'student_visa',0,'',0,18.3,0.5,0.3,0),(455,38021,5,198,2023,3,25,'student_visa',0,'',0,18.3,0.5,0.3,0),(456,38537,2,208,2023,5,26,'Japanese_national',0,'',0,18.3,0.5,0.3,0),(457,39474,5,188,2023,5,23,'student_visa',0,'',0,18.3,0.5,0.3,0),(458,39474,5,209,2023,5,19,'student_visa',1,'',0,18.3,0.5,0.3,0),(459,39485,5,210,2023,5,20,'student_visa',1,'',0,18.3,0.5,0.3,0),(460,39517,5,211,2023,5,26,'student_visa',1,'',0,18.3,0.5,0.3,0),(461,39521,5,212,2023,5,20,'student_visa',1,'',0,18.3,0.5,0.3,0),(462,39525,5,213,2023,5,21,'student_visa',1,'',0,18.3,0.5,0.3,0),(463,39535,5,209,2023,3,19,'student_visa',1,'静岡県',-1,18.3,0.5,0.3,0),(464,39535,5,210,2023,3,20,'student_visa',1,'静岡県',-1,18.3,0.5,0.3,0),(465,39535,5,211,2023,3,26,'student_visa',1,'',0,18.3,0.5,0.3,0),(466,39535,5,212,2023,3,20,'student_visa',1,'',0,18.3,0.5,0.3,0),(467,39535,5,213,2023,3,21,'student_visa',1,'',0,18.3,0.5,0.3,0),(468,39549,5,216,2023,5,36,'student_visa',1,'',0,18.3,0.5,0.3,0),(469,39553,5,217,2023,5,29,'student_visa',1,'',0,18.3,0.5,0.3,0),(470,39571,5,218,2023,5,29,'student_visa',1,'',0,18.3,0.5,0.3,0),(471,39575,5,219,2023,5,37,'student_visa',1,'',0,18.3,0.5,0.3,0),(472,39590,5,222,2023,5,36,'student_visa',1,'',0,18.3,0.5,0.3,0),(473,39675,2,214,2023,5,39,'student_visa',1,'',0,18.3,0.5,0.3,0),(474,39675,2,215,2023,5,39,'student_visa',1,'',0,18.3,0.5,0.3,0),(475,39675,2,220,2023,5,34,'student_visa',1,'',0,18.3,0.5,0.3,0),(476,39675,2,223,2023,5,26,'student_visa',1,'',0,18.3,0.5,0.3,0),(477,39675,2,224,2023,5,26,'student_visa',1,'',0,18.3,0.5,0.3,0),(479,39714,2,196,2023,5,22,'student_visa',0,'',0,18.3,0.5,0.3,0),(480,39714,2,198,2023,5,25,'student_visa',0,'',0,18.3,0.5,0.3,0),(483,39753,2,185,2023,5,20,'student_visa',0,'福岡県',10.36,18.3,0.5,0.3,0);

--
-- Table structure for table `text_shift`
--

CREATE TABLE `text_shift` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_job` int DEFAULT NULL,
  `id_worker` int DEFAULT NULL,
  `start` timestamp NULL DEFAULT NULL,
  `finish` timestamp NULL DEFAULT NULL,
  `hourly` smallint DEFAULT NULL,
  `presence` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=578 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_shift`
--

INSERT INTO `text_shift` VALUES (485,37428,5,17,156,'2023-08-08 01:00:00','2023-08-08 11:00:00',1012,''),(486,37431,5,17,156,'2023-08-09 00:00:00','2023-08-09 09:00:00',1012,''),(487,37438,5,17,156,'2023-08-10 00:00:00','2023-08-10 09:00:00',1012,''),(488,37441,5,17,156,'2023-08-11 00:00:00','2023-08-11 09:00:00',1012,''),(489,37444,5,17,156,'2023-08-12 00:00:00','2023-08-12 09:00:00',1012,''),(490,37447,5,17,156,'2023-08-15 00:00:00','2023-08-15 09:00:00',1012,''),(491,37450,5,17,156,'2023-08-16 00:00:00','2023-08-16 09:00:00',1012,''),(492,37453,5,17,156,'2023-08-17 00:00:00','2023-08-17 09:00:00',1012,''),(493,37456,5,17,156,'2023-08-18 00:00:00','2023-08-18 09:00:00',1012,''),(494,37459,5,17,156,'2023-08-19 00:00:00','2023-08-19 09:00:00',1012,''),(495,37462,5,17,156,'2023-08-22 00:00:00','2023-08-22 09:00:00',1012,''),(496,37465,5,17,156,'2023-08-23 00:00:00','2023-08-23 09:00:00',1012,''),(497,37468,5,17,156,'2023-08-24 00:00:00','2023-08-24 09:00:00',1012,''),(498,37471,5,17,156,'2023-08-25 00:00:00','2023-08-25 09:00:00',1012,''),(499,37474,5,17,156,'2023-08-26 00:00:00','2023-08-26 09:00:00',1012,''),(500,37477,5,17,156,'2023-08-29 00:00:00','2023-08-29 09:00:00',1012,''),(501,37480,5,17,156,'2023-08-30 00:00:00','2023-08-30 09:00:00',1012,''),(502,37483,5,17,156,'2023-08-31 00:00:00','2023-08-31 09:00:00',1012,''),(503,37487,5,17,156,'2023-05-08 00:00:00','2023-05-08 09:00:00',1012,''),(504,37490,5,17,156,'2023-05-09 00:00:00','2023-05-09 09:00:00',1012,''),(505,37493,5,17,156,'2023-05-10 00:00:00','2023-05-10 09:00:00',1012,''),(506,37496,5,17,156,'2023-05-11 00:00:00','2023-05-11 09:00:00',1012,''),(507,37499,5,17,156,'2023-05-12 00:00:00','2023-05-12 09:00:00',1012,''),(508,37502,5,17,156,'2023-05-15 00:00:00','2023-05-15 09:00:00',1012,''),(509,37505,5,17,156,'2023-05-16 00:00:00','2023-05-16 09:00:00',1012,''),(510,37508,5,17,156,'2023-05-17 00:00:00','2023-05-17 09:00:00',1012,''),(511,37511,5,17,156,'2023-05-18 00:00:00','2023-05-18 09:00:00',1012,''),(512,37514,5,17,156,'2023-05-19 00:00:00','2023-05-19 09:00:00',1012,''),(513,37517,5,17,156,'2023-05-22 00:00:00','2023-05-22 09:00:00',1012,''),(514,37520,5,17,156,'2023-05-23 00:00:00','2023-05-23 09:00:00',1012,''),(515,37523,5,17,156,'2023-05-24 00:00:00','2023-05-24 09:00:00',1012,''),(516,37526,5,17,156,'2023-05-25 00:00:00','2023-05-25 09:00:00',1012,''),(517,37529,5,17,156,'2023-05-26 00:00:00','2023-05-26 09:00:00',1012,''),(518,37532,5,17,156,'2023-05-29 00:00:00','2023-05-29 09:00:00',1012,''),(519,37535,5,17,156,'2023-05-30 00:00:00','2023-05-30 09:00:00',1012,''),(520,37538,5,17,156,'2023-05-31 00:00:00','2023-05-31 09:00:00',1012,''),(521,37555,5,2,168,'2023-05-08 00:00:00','2023-05-08 05:00:00',1250,''),(522,37558,5,2,168,'2023-05-09 00:00:00','2023-05-09 08:30:00',1250,'imminent~「Dipa Oli」と交代'),(523,37561,5,2,168,'2023-05-10 00:00:00','2023-05-10 09:00:00',1250,''),(524,37564,5,2,168,'2023-05-11 00:00:00','2023-05-11 09:00:00',1250,''),(525,37567,5,2,168,'2023-05-12 00:00:00','2023-05-12 09:00:00',1250,''),(526,37570,5,2,168,'2023-05-15 00:00:00','2023-05-15 09:00:00',1250,''),(527,37573,5,2,168,'2023-05-16 00:00:00','2023-05-16 09:00:00',1250,''),(528,37578,5,2,168,'2023-05-17 00:00:00','2023-05-17 09:00:00',1250,''),(530,37682,2,1,206,'2023-05-08 01:00:00','2023-05-08 05:00:00',1500,'imminent~交代者なし'),(531,37707,2,17,206,'2023-05-08 12:30:00','2023-05-08 13:00:00',1012,''),(533,37748,2,1,206,'2023-05-02 23:00:00','2023-05-03 00:00:00',1500,'present'),(534,37995,2,1,206,'2023-05-09 02:00:00','2023-05-09 09:00:00',1500,'imminent~「歌川　大介」と交代'),(539,38173,5,10,159,'2023-05-10 00:00:00','2023-05-10 08:00:00',1000,''),(540,38181,5,10,159,'2023-05-09 04:00:00','2023-05-09 13:00:00',1000,'imminent~「tina bhattari」と交代'),(541,38193,5,10,161,'2023-05-09 05:00:00','2023-05-09 13:00:00',1000,''),(542,38199,5,1,206,'2023-05-09 15:00:00','2023-05-09 15:00:00',1500,''),(543,38214,5,1,206,'2023-05-10 00:00:00','2023-05-10 11:00:00',1500,''),(544,38219,5,1,206,'2023-05-11 00:00:00','2023-05-11 11:00:00',1500,''),(545,38222,5,10,161,'2023-05-10 00:00:00','2023-05-10 11:00:00',1000,''),(550,38246,5,10,182,'2023-05-10 03:00:00','2023-05-10 07:00:00',1000,''),(551,38248,5,10,193,'2023-05-09 01:00:00','2023-05-09 05:00:00',1000,''),(552,38257,5,27,191,'2023-05-09 02:00:00','2023-05-09 06:00:00',1100,'imminent~「Neupane Ojashwee」と交代'),(553,38259,5,10,182,'2023-05-11 03:00:00','2023-05-11 08:00:00',1000,''),(554,38262,5,10,182,'2023-05-12 08:00:00','2023-05-12 14:00:00',1000,''),(555,38298,5,10,182,'2023-05-13 01:00:00','2023-05-13 05:00:00',1000,''),(563,38938,5,10,182,'2023-05-09 04:00:00','2023-05-09 09:00:00',1000,'imminent~「Neupane Gita」と交代'),(564,39025,5,27,192,'2023-05-09 02:00:00','2023-05-09 06:00:00',0,''),(565,39028,5,10,187,'2023-05-09 04:00:00','2023-05-09 09:00:00',0,''),(569,39084,5,2,179,'2023-05-09 00:00:00','2023-05-09 08:30:00',0,''),(570,39108,5,2,170,'2023-05-09 05:30:00','2023-05-09 13:00:00',1250,''),(571,39171,2,1,208,'2023-05-09 13:00:00','2023-05-09 14:00:00',1500,''),(572,39179,2,1,206,'2023-05-09 02:00:00','2023-05-09 09:00:00',1500,'imminent~「歌川　大介」と交代'),(573,39209,2,1,206,'2023-05-09 02:00:00','2023-05-09 09:00:00',1500,'imminent~「歌川　大介」と交代'),(574,39212,2,1,206,'2023-05-09 02:00:00','2023-05-09 09:00:00',1500,''),(575,39235,2,17,197,'2023-05-09 13:00:00','2023-05-09 14:00:00',1012,'imminent~「Mitch　Pakingan」と交代'),(576,39276,2,17,177,'2023-05-09 13:00:00','2023-05-09 14:00:00',1012,'imminent~「tina bhattari」と交代'),(577,39289,2,17,162,'2023-05-09 13:00:00','2023-05-09 14:00:00',1012,'');

--
-- Table structure for table `text_stamp`
--

CREATE TABLE `text_stamp` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `id_shift` int DEFAULT NULL,
  `work` enum('start','finish') DEFAULT NULL,
  `time` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=181 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_stamp`
--

INSERT INTO `text_stamp` VALUES (139,37542,5,503,'start','2023-05-08 01:50:00'),(140,37582,5,521,'start','2023-05-08 01:55:00'),(141,37927,5,522,'start','2023-05-09 00:25:00'),(142,37929,5,522,'start','2023-05-09 00:25:00'),(143,37935,5,504,'start','2023-05-09 00:30:00'),(144,38050,5,522,'finish','2023-05-09 00:38:00'),(145,38054,5,504,'finish','2023-05-09 00:52:00'),(146,38217,5,540,'start','2023-05-08 22:26:00'),(147,38318,5,540,'finish','2023-05-09 01:50:00'),(148,38320,5,541,'start','2023-05-09 01:50:00'),(149,38327,5,547,'start','2023-05-08 23:51:00'),(150,38339,5,552,'start','2023-05-09 01:52:00'),(151,38348,5,541,'finish','2023-05-09 01:50:00'),(152,38350,5,547,'finish','2023-05-09 03:00:00'),(154,38371,5,552,'finish','2023-05-09 06:00:00'),(156,38381,5,546,'start','2023-05-09 00:58:00'),(157,38385,5,546,'finish','2023-05-09 02:25:00'),(159,38433,5,546,'finish','2023-05-09 05:30:00'),(176,38866,5,557,'finish','2023-05-09 11:59:00'),(180,39113,5,570,'start','2023-05-09 05:30:00');

--
-- Table structure for table `text_tax`
--

CREATE TABLE `text_tax` (
  `id` int NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `salary_min` mediumint DEFAULT NULL,
  `salary_max` mediumint DEFAULT NULL,
  `family_0` mediumint DEFAULT NULL,
  `family_1` mediumint DEFAULT NULL,
  `family_2` mediumint DEFAULT NULL,
  `family_3` mediumint DEFAULT NULL,
  `family_4` mediumint DEFAULT NULL,
  `family_5` mediumint DEFAULT NULL,
  `family_6` mediumint DEFAULT NULL,
  `family_7` mediumint DEFAULT NULL,
  `family_no` mediumint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=510 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_tax`
--

INSERT INTO `text_tax` VALUES (255,1,1,0,88000,0,0,0,0,0,0,0,0,0),(256,1,1,88000,89000,130,0,0,0,0,0,0,0,3200),(257,1,1,89000,90000,180,0,0,0,0,0,0,0,3200),(258,1,1,90000,91000,230,0,0,0,0,0,0,0,3200),(259,1,1,91000,92000,290,0,0,0,0,0,0,0,3200),(260,1,1,92000,93000,340,0,0,0,0,0,0,0,3300),(261,1,1,93000,94000,390,0,0,0,0,0,0,0,3300),(262,1,1,94000,95000,440,0,0,0,0,0,0,0,3300),(263,1,1,95000,96000,490,0,0,0,0,0,0,0,3400),(264,1,1,96000,97000,540,0,0,0,0,0,0,0,3400),(265,1,1,97000,98000,590,0,0,0,0,0,0,0,3500),(266,1,1,98000,99000,640,0,0,0,0,0,0,0,3500),(267,1,1,99000,101000,720,0,0,0,0,0,0,0,3600),(268,1,1,101000,103000,830,0,0,0,0,0,0,0,3600),(269,1,1,103000,105000,930,0,0,0,0,0,0,0,3700),(270,1,1,105000,107000,1030,0,0,0,0,0,0,0,3800),(271,1,1,107000,109000,1130,0,0,0,0,0,0,0,3800),(272,1,1,109000,111000,1240,0,0,0,0,0,0,0,3900),(273,1,1,111000,113000,1340,0,0,0,0,0,0,0,4000),(274,1,1,113000,115000,1440,0,0,0,0,0,0,0,4100),(275,1,1,115000,117000,1540,0,0,0,0,0,0,0,4100),(276,1,1,117000,119000,1640,0,0,0,0,0,0,0,4200),(277,1,1,119000,121000,1750,120,0,0,0,0,0,0,4300),(278,1,1,121000,123000,1850,220,0,0,0,0,0,0,4500),(279,1,1,123000,125000,1950,330,0,0,0,0,0,0,4800),(280,1,1,125000,127000,2050,430,0,0,0,0,0,0,5100),(281,1,1,127000,129000,2150,530,0,0,0,0,0,0,5400),(282,1,1,129000,131000,2260,630,0,0,0,0,0,0,5700),(283,1,1,131000,133000,2360,740,0,0,0,0,0,0,6000),(284,1,1,133000,135000,2460,840,0,0,0,0,0,0,6300),(285,1,1,135000,137000,2550,930,0,0,0,0,0,0,6600),(286,1,1,137000,139000,2610,990,0,0,0,0,0,0,6800),(287,1,1,139000,141000,2680,1050,0,0,0,0,0,0,7100),(288,1,1,141000,143000,2740,1110,0,0,0,0,0,0,7500),(289,1,1,143000,145000,2800,1170,0,0,0,0,0,0,7800),(290,1,1,145000,147000,2860,1240,0,0,0,0,0,0,8100),(291,1,1,147000,149000,2920,1300,0,0,0,0,0,0,8400),(292,1,1,149000,151000,2980,1360,0,0,0,0,0,0,8700),(293,1,1,151000,153000,3050,1430,0,0,0,0,0,0,9000),(294,1,1,153000,155000,3120,1500,0,0,0,0,0,0,9300),(295,1,1,155000,157000,3200,1570,0,0,0,0,0,0,9600),(296,1,1,157000,159000,3270,1640,0,0,0,0,0,0,9900),(297,1,1,159000,161000,3340,1720,100,0,0,0,0,0,10200),(298,1,1,161000,163000,3410,1790,170,0,0,0,0,0,10500),(299,1,1,163000,165000,3480,1860,250,0,0,0,0,0,10800),(300,1,1,165000,167000,3550,1930,320,0,0,0,0,0,11100),(301,1,1,167000,169000,3620,2000,390,0,0,0,0,0,11400),(302,1,1,169000,171000,3700,2070,460,0,0,0,0,0,11700),(303,1,1,171000,173000,3770,2140,530,0,0,0,0,0,12000),(304,1,1,173000,175000,3840,2220,600,0,0,0,0,0,12400),(305,1,1,175000,177000,3910,2290,670,0,0,0,0,0,12700),(306,1,1,177000,179000,3980,2360,750,0,0,0,0,0,13200),(307,1,1,179000,181000,4050,2430,820,0,0,0,0,0,13900),(308,1,1,181000,183000,4120,2500,890,0,0,0,0,0,14600),(309,1,1,183000,185000,4200,2570,960,0,0,0,0,0,15300),(310,1,1,185000,187000,4270,2640,1030,0,0,0,0,0,16000),(311,1,1,187000,189000,4340,2720,1100,0,0,0,0,0,16700),(312,1,1,189000,191000,4410,2790,1170,0,0,0,0,0,17500),(313,1,1,191000,193000,4480,2860,1250,0,0,0,0,0,18100),(314,1,1,193000,195000,4550,2930,1320,0,0,0,0,0,18800),(315,1,1,195000,197000,4630,3000,1390,0,0,0,0,0,19500),(316,1,1,197000,199000,4700,3070,1460,0,0,0,0,0,20200),(317,1,1,199000,201000,4770,3140,1530,0,0,0,0,0,20900),(318,1,1,201000,203000,4840,3220,1600,0,0,0,0,0,21500),(319,1,1,203000,205000,4910,3290,1670,0,0,0,0,0,22200),(320,1,1,205000,207000,4980,3360,1750,130,0,0,0,0,22700),(321,1,1,207000,209000,5050,3430,1820,200,0,0,0,0,23300),(322,1,1,209000,211000,5130,3500,1890,280,0,0,0,0,23900),(323,1,1,211000,213000,5200,3570,1960,350,0,0,0,0,24400),(324,1,1,213000,215000,5270,3640,2030,420,0,0,0,0,25000),(325,1,1,215000,217000,5340,3720,2100,490,0,0,0,0,25500),(326,1,1,217000,219000,5410,3790,2170,560,0,0,0,0,26100),(327,1,1,219000,221000,5480,3860,2250,630,0,0,0,0,26800),(328,1,1,221000,224000,5560,3950,2340,710,0,0,0,0,27400),(329,1,1,224000,227000,5680,4060,2440,830,0,0,0,0,28400),(330,1,1,227000,230000,5780,4170,2550,930,0,0,0,0,29300),(331,1,1,230000,233000,5890,4280,2650,1040,0,0,0,0,30300),(332,1,1,233000,236000,5990,4380,2770,1140,0,0,0,0,31300),(333,1,1,236000,239000,6110,4490,2870,1260,0,0,0,0,32400),(334,1,1,239000,242000,6210,4590,2980,1360,0,0,0,0,33400),(335,1,1,242000,245000,6320,4710,3080,1470,0,0,0,0,34400),(336,1,1,245000,248000,6420,4810,3200,1570,0,0,0,0,35400),(337,1,1,248000,251000,6530,4920,3300,1680,0,0,0,0,36400),(338,1,1,251000,254000,6640,5020,3410,1790,170,0,0,0,37500),(339,1,1,254000,257000,6750,5140,3510,1900,290,0,0,0,38500),(340,1,1,257000,260000,6850,5240,3620,2000,390,0,0,0,39400),(341,1,1,260000,263000,6960,5350,3730,2110,500,0,0,0,40400),(342,1,1,263000,266000,7070,5450,3840,2220,600,0,0,0,41500),(343,1,1,266000,269000,7180,5560,3940,2330,710,0,0,0,42500),(344,1,1,269000,272000,7280,5670,4050,2430,820,0,0,0,43500),(345,1,1,272000,275000,7390,5780,4160,2540,930,0,0,0,44500),(346,1,1,275000,278000,7490,5880,4270,2640,1030,0,0,0,45500),(347,1,1,278000,281000,7610,5990,4370,2760,1140,0,0,0,46600),(348,1,1,281000,284000,7710,6100,4480,2860,1250,0,0,0,47600),(349,1,1,284000,287000,7820,6210,4580,2970,1360,0,0,0,48600),(350,1,1,287000,290000,7920,6310,4700,3070,1460,0,0,0,49700),(351,1,1,290000,293000,8040,6420,4800,3190,1570,0,0,0,50900),(352,1,1,293000,296000,8140,6520,4910,3290,1670,0,0,0,52100),(353,1,1,296000,299000,8250,6640,5010,3400,1790,160,0,0,52900),(354,1,1,299000,302000,8420,6740,5130,3510,1890,280,0,0,53700),(355,1,1,302000,305000,8670,6860,5250,3630,2010,400,0,0,54500),(356,1,1,305000,308000,8910,6980,5370,3760,2130,520,0,0,55200),(357,1,1,308000,311000,9160,7110,5490,3880,2260,640,0,0,56100),(358,1,1,311000,314000,9400,7230,5620,4000,2380,770,0,0,56900),(359,1,1,314000,317000,9650,7350,5740,4120,2500,890,0,0,57800),(360,1,1,317000,320000,9890,7470,5860,4250,2620,1010,0,0,58800),(361,1,1,320000,323000,10140,7600,5980,4370,2750,1130,0,0,59800),(362,1,1,323000,326000,10380,7720,6110,4490,2870,1260,0,0,60900),(363,1,1,326000,329000,10630,7840,6230,4610,2990,1380,0,0,61900),(364,1,1,329000,332000,10870,7960,6350,4740,3110,1500,0,0,62900),(365,1,1,332000,335000,11120,8090,6470,4860,3240,1620,0,0,63900),(366,1,1,335000,338000,11360,8210,6600,4980,3360,1750,130,0,64900),(367,1,1,338000,341000,11610,8370,6720,5110,3480,1870,260,0,66000),(368,1,1,341000,344000,11850,8620,6840,5230,3600,1990,380,0,67000),(369,1,1,344000,347000,12100,8860,6960,5350,3730,2110,500,0,68000),(370,1,1,347000,350000,12340,9110,7090,5470,3850,2240,620,0,69000),(371,1,1,350000,353000,12590,9350,7210,5600,3970,2360,750,0,70000),(372,1,1,353000,356000,12830,9600,7330,5720,4090,2480,870,0,71100),(373,1,1,356000,359000,13080,9840,7450,5840,4220,2600,990,0,72100),(374,1,1,359000,362000,13320,10090,7580,5960,4340,2730,1110,0,73100),(375,1,1,362000,365000,13570,10330,7700,6090,4460,2850,1240,0,74200),(376,1,1,365000,368000,13810,10580,7820,6210,4580,2970,1360,0,75200),(377,1,1,368000,371000,14060,10820,7940,6330,4710,3090,1480,0,76200),(378,1,1,371000,374000,14300,11070,8070,6450,4830,3220,1600,0,77100),(379,1,1,374000,377000,14550,11310,8190,6580,4950,3340,1730,100,78100),(380,1,1,377000,380000,14790,11560,8320,6700,5070,3460,1850,220,79000),(381,1,1,380000,383000,15040,11800,8570,6820,5200,3580,1970,350,79900),(382,1,1,383000,386000,15280,12050,8810,6940,5320,3710,2090,470,81400),(383,1,1,386000,389000,15530,12290,9060,7070,5440,3830,2220,590,83100),(384,1,1,389000,392000,15770,12540,9300,7190,5560,3950,2340,710,84700),(385,1,1,392000,395000,16020,12780,9550,7310,5690,4070,2460,840,86500),(386,1,1,395000,398000,16260,13030,9790,7430,5810,4200,2580,960,88200),(387,1,1,398000,401000,16510,13270,10040,7560,5930,4320,2710,1080,89800),(388,1,1,401000,404000,16750,13520,10280,7680,6050,4440,2830,1200,91600),(389,1,1,404000,407000,17000,13760,10530,7800,6180,4560,2950,1330,93300),(390,1,1,407000,410000,17240,14010,10770,7920,6300,4690,3070,1450,95000),(391,1,1,410000,413000,17490,14250,11020,8050,6420,4810,3200,1570,96700),(392,1,1,413000,416000,17730,14500,11260,8170,6540,4930,3320,1690,98300),(393,1,1,416000,419000,17980,14740,11510,8290,6670,5050,3440,1820,100100),(394,1,1,419000,422000,18220,14990,11750,8530,6790,5180,3560,1940,101800),(395,1,1,422000,425000,18470,15230,12000,8770,6910,5300,3690,2060,103400),(396,1,1,425000,428000,18710,15480,12240,9020,7030,5420,3810,2180,105200),(397,1,1,428000,431000,18960,15720,12490,9260,7160,5540,3930,2310,106900),(398,1,1,431000,434000,19210,15970,12730,9510,7280,5670,4050,2430,108500),(399,1,1,434000,437000,19450,16210,12980,9750,7400,5790,4180,2550,110300),(400,1,1,437000,440000,19700,16460,13220,10000,7520,5910,4300,2680,112000),(401,1,1,440000,443000,20090,16700,13470,10240,7650,6030,4420,2800,113600),(402,1,1,443000,446000,20580,16950,13710,10490,7770,6160,4540,2920,115400),(403,1,1,446000,449000,21070,17190,13960,10730,7890,6280,4670,3040,117100),(404,1,1,449000,452000,21560,17440,14200,10980,8010,6400,4790,3170,118700),(405,1,1,452000,455000,22050,17680,14450,11220,8140,6520,4910,3290,120500),(406,1,1,455000,458000,22540,17930,14690,11470,8260,6650,5030,3410,122200),(407,1,1,458000,461000,23030,18170,14940,11710,8470,6770,5160,3530,123800),(408,1,1,461000,464000,23520,18420,15180,11960,8720,6890,5280,3660,125600),(409,1,1,464000,467000,24010,18660,15430,12200,8960,7010,5400,3780,127300),(410,1,1,467000,470000,24500,18910,15670,12450,9210,7140,5520,3900,129000),(411,1,1,470000,473000,24990,19150,15920,12690,9450,7260,5650,4020,130700),(412,1,1,473000,476000,25480,19400,16160,12940,9700,7380,5770,4150,132300),(413,1,1,476000,479000,25970,19640,16410,13180,9940,7500,5890,4270,134000),(414,1,1,479000,482000,26460,20000,16650,13430,10190,7630,6010,4390,135600),(415,1,1,482000,485000,26950,20490,16900,13670,10430,7750,6140,4510,137200),(416,1,1,485000,488000,27440,20980,17140,13920,10680,7870,6260,4640,138800),(417,1,1,488000,491000,27930,21470,17390,14160,10920,7990,6380,4760,140400),(418,1,1,491000,494000,28420,21960,17630,14410,11170,8120,6500,4880,142000),(419,1,1,494000,497000,28910,22450,17880,14650,11410,8240,6630,5000,143700),(420,1,1,497000,500000,29400,22940,18120,14900,11660,8420,6750,5130,145200),(421,1,1,500000,503000,29890,23430,18370,15140,11900,8670,6870,5250,146800),(422,1,1,503000,506000,30380,23920,18610,15390,12150,8910,6990,5370,148500),(423,1,1,506000,509000,30880,24410,18860,15630,12390,9160,7120,5490,150100),(424,1,1,509000,512000,31370,24900,19100,15880,12640,9400,7240,5620,151600),(425,1,1,512000,515000,31860,25390,19350,16120,12890,9650,7360,5740,153300),(426,1,1,515000,518000,32350,25880,19590,16370,13130,9890,7480,5860,154900),(427,1,1,518000,521000,32840,26370,19900,16610,13380,10140,7610,5980,156500),(428,1,1,521000,524000,33330,26860,20390,16860,13620,10380,7730,6110,158100),(429,1,1,524000,527000,33820,27350,20880,17100,13870,10630,7850,6230,159600),(430,1,1,527000,530000,34310,27840,21370,17350,14110,10870,7970,6350,161000),(431,1,1,530000,533000,34800,28330,21860,17590,14360,11120,8100,6470,162500),(432,1,1,533000,536000,35290,28820,22350,17840,14600,11360,8220,6600,164000),(433,1,1,536000,539000,35780,29310,22840,18080,14850,11610,8380,6720,165400),(434,1,1,539000,542000,36270,29800,23330,18330,15090,11850,8630,6840,166900),(435,1,1,542000,545000,36760,30290,23820,18570,15340,12100,8870,6960,168400),(436,1,1,545000,548000,37250,30780,24310,18820,15580,12340,9120,7090,169900),(437,1,1,548000,551000,37740,31270,24800,19060,15830,12590,9360,7210,171300),(438,1,1,551000,554000,38280,31810,25340,19330,16100,12860,9630,7350,172800),(439,1,1,554000,557000,38830,32370,25890,19600,16380,13140,9900,7480,174300),(440,1,1,557000,560000,39380,32920,26440,19980,16650,13420,10180,7630,175700),(441,1,1,560000,563000,39930,33470,27000,20530,16930,13690,10460,7760,177200),(442,1,1,563000,566000,40480,34020,27550,21080,17200,13970,10730,7900,178700),(443,1,1,566000,569000,41030,34570,28100,21630,17480,14240,11010,8040,180100),(444,1,1,569000,572000,41590,35120,28650,22190,17760,14520,11280,8180,181600),(445,1,1,572000,575000,42140,35670,29200,22740,18030,14790,11560,8330,183100),(446,1,1,575000,578000,42690,36230,29750,23290,18310,15070,11830,8610,184600),(447,1,1,578000,581000,43240,36780,30300,23840,18580,15350,12110,8880,186000),(448,1,1,581000,584000,43790,37330,30850,24390,18860,15620,12380,9160,187500),(449,1,1,584000,587000,44340,37880,31410,24940,19130,15900,12660,9430,189000),(450,1,1,587000,590000,44890,38430,31960,25490,19410,16170,12940,9710,190400),(451,1,1,590000,593000,45440,38980,32510,26050,19680,16450,13210,9990,191900),(452,1,1,593000,596000,46000,39530,33060,26600,20130,16720,13490,10260,193400),(453,1,1,596000,599000,46550,40080,33610,27150,20690,17000,13760,10540,194800),(454,1,1,599000,602000,47100,40640,34160,27700,21240,17280,14040,10810,196300),(455,1,1,602000,605000,47650,41190,34710,28250,21790,17550,14310,11090,197800),(456,1,1,605000,608000,48200,41740,35270,28800,22340,17830,14590,11360,199300),(457,1,1,608000,611000,48750,42290,35820,29350,22890,18100,14870,11640,200700),(458,1,1,611000,614000,49300,42840,36370,29910,23440,18380,15140,11920,202200),(459,1,1,614000,617000,49860,43390,36920,30460,23990,18650,15420,12190,203700),(460,1,1,617000,620000,50410,43940,37470,31010,24540,18930,15690,12470,205100),(461,1,1,620000,623000,50960,44500,38020,31560,25100,19210,15970,12740,206700),(462,1,1,623000,626000,51510,45050,38570,32110,25650,19480,16240,13020,208100),(463,1,1,626000,629000,52060,45600,39120,32660,26200,19760,16520,13290,209500),(464,1,1,629000,632000,52610,46150,39680,33210,26750,20280,16800,13570,211000),(465,1,1,632000,635000,53160,46700,40230,33760,27300,20830,17070,13840,212500),(466,1,1,635000,638000,53710,47250,40780,34320,27850,21380,17350,14120,214000),(467,1,1,638000,641000,54270,47800,41330,34870,28400,21930,17620,14400,214900),(468,1,1,641000,644000,54820,48350,41880,35420,28960,22480,17900,14670,215900),(469,1,1,644000,647000,55370,48910,42430,35970,29510,23030,18170,14950,217000),(470,1,1,647000,650000,55920,49460,42980,36520,30060,23590,18450,15220,218000),(471,1,1,650000,653000,56470,50010,43540,37070,30610,24140,18730,15500,219000),(472,1,1,653000,656000,57020,50560,44090,37620,31160,24690,19000,15770,220000),(473,1,1,656000,659000,57570,51110,44640,38180,31710,25240,19280,16050,221000),(474,1,1,659000,662000,58130,51660,45190,38730,32260,25790,19550,16330,222100),(475,1,1,662000,665000,58680,52210,45740,39280,32810,26340,19880,16600,223100),(476,1,1,665000,668000,59230,52770,46290,39830,33370,26890,20430,16880,224100),(477,1,1,668000,671000,59780,53320,46840,40380,33920,27440,20980,17150,225000),(478,1,1,671000,674000,60330,53870,47390,40930,34470,28000,21530,17430,226000),(479,1,1,674000,677000,60880,54420,47950,41480,35020,28550,22080,17700,227100),(480,1,1,677000,680000,61430,54970,48500,42030,35570,29100,22640,17980,228100),(481,1,1,680000,683000,61980,55520,49050,42590,36120,29650,23190,18260,229100),(482,1,1,683000,686000,62540,56070,49600,43140,36670,30200,23740,18530,230400),(483,1,1,686000,689000,63090,56620,50150,43690,37230,30750,24290,18810,232100),(484,1,1,689000,692000,63640,57180,50700,44240,37780,31300,24840,19080,233600),(485,1,1,692000,695000,64190,57730,51250,44790,38330,31860,25390,19360,235100),(486,1,1,695000,698000,64740,58280,51810,45340,38880,32410,25940,19630,236700),(487,1,1,698000,701000,65290,58830,52360,45890,39430,32960,26490,20030,238200),(488,1,1,701000,704000,65840,59380,52910,46450,39980,33510,27050,20580,239700),(489,1,1,704000,707000,66400,59930,53460,47000,40530,34060,27600,21130,241300),(490,1,1,707000,710000,66960,60480,54020,47550,41090,34620,28150,21690,242900),(491,1,1,710000,713000,67570,61100,54630,48160,41700,35230,28760,22300,244400),(492,1,1,713000,716000,68180,61710,55250,48770,42310,35850,29370,22910,246000),(493,1,1,716000,719000,68790,62320,55860,49390,42920,36460,29990,23520,247500),(494,1,1,719000,722000,69410,62930,56470,50000,43540,37070,30600,24140,249000),(495,1,1,722000,725000,70020,63550,57080,50610,44150,37690,31210,24750,250600),(496,1,1,725000,728000,70630,64160,57700,51220,44760,38300,31820,25360,252200),(497,1,1,728000,731000,71250,64770,58310,51840,45370,38910,32440,25970,253700),(498,1,1,731000,734000,71860,65380,58920,52450,45990,39520,33050,26590,255300),(499,1,1,734000,737000,72470,66000,59530,53060,46600,40140,33660,27200,256800),(500,1,1,737000,740000,73080,66610,60150,53670,47210,40750,34270,27810,258300),(501,1,1,740000,780000,73390,66920,60450,53980,47520,41050,34580,28120,259800),(502,1,1,780000,950000,81560,75090,68620,62150,55690,49220,42750,36290,0),(503,1,1,950000,1700000,121480,115010,108540,102070,95610,89140,82670,76210,0),(504,1,1,1700000,2170000,374180,367710,361240,354770,348310,341840,335370,328910,0),(505,1,1,2170000,2210000,571570,565090,558630,552160,545690,539230,532760,526290,0),(506,1,1,2210000,2250000,593340,586870,580410,573930,567470,561010,554540,548070,0),(507,1,1,2250000,3500000,615120,608650,602190,595710,589250,582790,576310,569850,0),(508,1,1,3500000,0,1125620,1119150,1112690,1106210,1099750,1093290,1086810,1080350,0);

--
-- Table structure for table `text_worker`
--

CREATE TABLE `text_worker` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` int NOT NULL,
  `id_user` int DEFAULT NULL,
  `auto_number` char(10) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `kana` varchar(255) DEFAULT NULL,
  `birth` date DEFAULT NULL,
  `sex` enum('male','female','other') DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `marriage` enum('single','married') DEFAULT NULL,
  `family` enum('0','1','2','3','4','5','6','7','8','9','10') DEFAULT NULL,
  `visa` enum('Japanese_national','Japanese_national_dependent','spouse_visa','permanent_resident_visa','spouse_visa_to_permanent_resident','work_visa','dependent_visa','long_term_visa','student_visa') DEFAULT NULL,
  `document` varchar(255) DEFAULT NULL,
  `expiry` date DEFAULT NULL,
  `other` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `text_worker`
--

INSERT INTO `text_worker` VALUES (147,13551,1,'T000147','牛島','ウシジマ','1998-01-29','male','福岡県','','married','0','Japanese_national',NULL,NULL,NULL),(155,19749,1,'TO000155','Beruma Valentine','ベルマ　バレンタイン','1992-03-12','female','福岡県糸島市','092-1234-5678','single','0','student_visa',NULL,NULL,NULL),(157,24308,6,'000157','Yumi','Yumi','1998-03-14','female','','09012345432','single','0','Japanese_national',NULL,NULL,NULL),(160,24598,5,'SA000160','内和田ユミ','ウチワダユミ','1998-03-09','female','','07023990430','single','0','Japanese_national',NULL,NULL,NULL),(163,25031,5,'IT000163','Ullah Sana','ウラサナ','1993-01-01','male','','080−6037−8807','married','0','student_visa',NULL,NULL,NULL),(164,25086,5,'II000164','Ichikawa Mary Grace','市川目リーグレス','1993-06-08','female','','080−2785−1954','married','0','spouse_visa',NULL,NULL,NULL),(169,25174,5,'IT000169','Philbirth　Umali Jr.','','1992-01-25','male','','09159131312','married','0','long_term_visa',NULL,NULL,NULL),(172,25205,5,'OG000172','Donna　Lantay','ドンナ　ランタイ','1993-09-24','','','09023984728','married','0','spouse_visa',NULL,NULL,NULL),(173,25477,5,'KU000173','Dannnica Jane Manozo','ダニカジェーン　マノゾ','1993-07-05','female','','08032227589','single','0','student_visa',NULL,NULL,NULL),(174,25481,5,'KU000174','Jullia Abby　Mital','ジュリアアビー　ミタル','2002-01-19','female','','+81 80 9104 2049','single','0','long_term_visa',NULL,NULL,NULL),(175,25487,5,'KU000175','Subham Fullel','サブハム　フレル','2001-07-18','male','','08064406870','single','0','student_visa',NULL,NULL,NULL),(176,25493,5,'KU000176','Susan　Chhetri ','スサン　チェトリ','2000-12-18','','','07020330765','single','0','student_visa',NULL,NULL,NULL),(178,25512,5,'KU000178','Nisha　Shrestha','ニシャ　シュレタ','1993-03-23','female','','08045958177','married','0','Japanese_national_dependent',NULL,NULL,NULL),(185,25578,5,'KO000185','Sapana Gurung','サパナ　グルンぐ','2002-11-05','female','福岡県','090629347304','single','0','student_visa',NULL,NULL,NULL),(189,26033,5,'AS000189','Yamamoto Marilyn','山本マリリン','1988-05-03','female','','070−8495−5308','married','0','student_visa',NULL,NULL,NULL),(190,26123,5,'TO000190','Tamrakar Ashmita','タムラカルアシャミた','2000-02-11','female','','鳥栖','single','0','student_visa',NULL,NULL,NULL),(195,26357,5,'KU000195','Sharma Ram','サルマラメ','1998-03-17','male','','070−4572-8176','single','0','student_visa',NULL,NULL,NULL),(196,26362,5,'KO000196','Neupane Dinesh','ネウパネぢネス','2001-04-18','male','','070-4572-8176','single','0','student_visa',NULL,NULL,NULL),(198,26370,5,'KO000198','Bhattarai Priyanka','バタラいプリやんか','1998-03-17','female','','070-4572-8176','single','0','student_visa',NULL,NULL,NULL),(209,39466,5,'Ha000209','Subedi Prayas','すべでぱらやす','2003-08-09','male','静岡県Tojimmachi','08095344826','single','1','student_visa','Jairo card','2025-10-07','Student card'),(210,39483,5,'Ha000210','chapai Rabilal','チャパイ　ラビラル　','2003-03-27','male','静岡県Tojimmachi','090-51983342','single','1','student_visa','Jairo card','2025-10-07','Student card'),(211,39515,5,'Ha000211','Yawa Himal','やわひまる','1996-12-12','male','福岡県','','single','1','student_visa','jairo card','2025-05-10','Student Card'),(212,39519,5,'Ha000212','Dhungana sabin','づんがなさびん','2002-12-09','male','福岡県','','single','1','student_visa','Jairo card','2025-08-02','Student card'),(213,39523,5,'Ha000213','Chapagain Jeevan','チャパガイン　じバン','2001-11-20','male','福岡県','','single','1','student_visa','Jairo card','2025-08-02','Student card'),(214,39538,5,'HA000214','Kumar Ravi　','　クマルラビ','1983-12-15','male','','','single','1','student_visa','jairo card','2025-08-04',''),(215,39542,5,'HA000215','kumar Ravi','クマルラビ','1983-12-15','male','','','single','1','student_visa','Jairo card','2025-08-04',''),(216,39547,5,'Ha000216','Sant Raj','サンタラジ','1986-12-04','male','北海道Minami ku-Fukuoka','','single','1','student_visa','jairo card','2025-08-04',''),(217,39551,5,'Ha000217',' Kirtanaia Dhananjay','キラタンアイア　デャンアンジャヤ','1994-03-11','male','福岡県','','single','1','student_visa','jairo card','2023-12-18',''),(218,39569,5,'Ha000218','Sarkar Subhankar','サラカラスバアンカラ','1994-04-05','male','福岡県','','single','1','student_visa','jairo card','2023-08-25',''),(219,39573,5,'Ha000219','Biswas Tarun','ビスワス　タルン','1986-04-17','male','福岡県','','single','1','student_visa','Jairo card','2023-08-16',''),(220,39577,5,'HA000220','Biswas Rathin','ビスワス　ラチン','1989-05-02','male','','','single','1','student_visa','Jairo card','2023-12-18',''),(222,39587,5,'HA000222','Mandal Pradip','マナダル　パラヂプ','1987-03-08','male','福岡県','','single','1','student_visa','Jairo card','2023-06-18',''),(223,39663,5,'HA000223','Budhathoki Manish','ブダトキ　マニス','1996-12-03','male','','','single','1','student_visa','Jairo card','2023-07-26',''),(224,39667,5,'HA000224','Budhathoki Manish','ブダトキ　マニス','1996-12-03','male','','','single','1','student_visa','Jairo card','2023-07-26','');

--
-- Table structure for table `translate`
--

CREATE TABLE `translate` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` mediumint DEFAULT NULL,
  `id_user` mediumint DEFAULT NULL,
  `dat` varchar(255) DEFAULT NULL,
  `tab` varchar(255) DEFAULT NULL,
  `raw` varchar(255) DEFAULT NULL,
  `en` varchar(255) DEFAULT NULL,
  `jp` varchar(255) DEFAULT NULL,
  `ch` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `translate`
--

INSERT INTO `translate` VALUES (1,3605,1,'has','text_company','company','Company','会社','公司'),(2,3617,1,'has','text_company','name','Name','名前','姓名'),(3,7247,1,'has_beta','text_salary','year','Year','年',''),(4,7255,1,'has_beta','text_salary','month','Month','月',''),(5,7257,1,'has_beta','text_salary','salary','Monthly salary','月給',''),(6,7259,1,'has_beta','text_salary','seconds_work','Duration of work','労働時間',''),(7,7261,1,'has_beta','text_salary','seconds_extra','Duration of extra work','残業時間',''),(8,7263,1,'has_beta','text_salary','age_end_of_month','Age at the end of this month','年齢',''),(9,7265,1,'has_beta','text_salary','todoufuken','Prefecture','都道府県',''),(10,7267,1,'has_beta','text_salary','rate_kenkou','Health insurance rate','健康保険料率',''),(11,7269,1,'has_beta','text_salary','rate_kaigo','Long-term care insurance premium rate','介護保険料率',''),(12,7271,1,'has_beta','text_salary','rate_kouseinenkin','Welfare pension rate','厚生年金料率',''),(13,7280,1,'has_beta','text_salary','rate_koyou','Employment insurance rate','雇用保険料率',''),(14,7282,1,'has_beta','text_salary','insurance_kenkou','Insurance of kenkou','健康保険料',''),(15,7284,1,'has_beta','text_salary','insurance_kaigo','Insurance of kaigo','介護保険料',''),(16,7286,1,'has_beta','text_salary','insurance_kouseinenkin','Insurance of kouseinenkin','厚生年金料',''),(17,7288,1,'has_beta','text_salary','insurance_koyou','Insurance of koyou','雇用年金料',''),(18,7290,1,'has_beta','text_salary','tax_gensen','Withholding tax','源泉徴収税',''),(19,9632,1,'has_beta','text_worker','auto_number','Identification number','識別番号',''),(20,9635,1,'has_beta','text_worker','name','Name','名前',''),(21,9637,1,'has_beta','text_worker','kana','Reading','カナ',''),(22,9639,1,'has_beta','text_worker','birth','Birthday','生年月日',''),(23,9641,1,'has_beta','text_worker','address','Address','住所',''),(24,9643,1,'has_beta','text_worker','contact','Contact','連絡先',''),(25,9645,1,'has_beta','text_worker','marriage','Marital status','婚姻状況',''),(26,9648,1,'has_beta','text_worker','sex','Sex','性別',''),(27,9650,1,'has_beta','text_worker','family','Number of dependents','扶養家族数',''),(28,9656,1,'has_beta','text_worker','visa','Visa status','国籍／ビザ等',''),(29,9671,1,'has_beta','text_group','name','Name','グループ',''),(30,9673,1,'has_beta','text_group','place','Place','場所',''),(31,9675,1,'has_beta','text_group','description','Description','会社名',''),(32,9677,1,'has_beta','text_group','notes','Notes','備考',''),(33,9681,1,'has_beta','text_job','name','Job','職種',''),(34,9684,1,'has_beta','text_job','description','Company','会社名',''),(35,9686,1,'has_beta','text_job','place','Place','場所',''),(36,9689,1,'has_beta','text_job','station','Station','部署',''),(37,9692,1,'has_beta','text_job','notes','Notes','備考',''),(38,12595,1,'has_beta','text_job','hourly','Hourly rate','時給',''),(39,13861,1,'has_beta','text_group','code','Area code','コード',''),(40,15296,1,'has_beta','text_salary','rate_rousai','Labor insurance premium rate','労災保険料率',''),(41,15331,1,'has_beta','text_salary','family','Number of dependents','扶養家族数',''),(42,15335,1,'has_beta','text_salary','visa_status','Visa status','国籍／ビザ等',''),(43,16724,1,'has_beta','text_shift','start','Start','開始時刻',''),(44,16737,1,'has_beta','text_shift','finish','Finish','終了時刻',''),(45,17059,1,'has_beta','text_dakoku','start','Start','開始時刻',''),(46,17062,1,'has_beta','text_dakoku','finish','Finish','終了時刻',''),(47,NULL,NULL,'has_beta','database','group','Group','グループ',NULL),(48,NULL,NULL,'has_beta','database','job','Job','仕事',NULL),(49,36353,1,'has_beta','text_worker','document','Document','証明書類',''),(50,36356,1,'has_beta','text_worker','expiry','Expiry','有効期限',''),(51,39140,1,'has_beta','text_worker','other','Other','その他','');

--
-- Table structure for table `translate_general`
--

CREATE TABLE `translate_general` (
  `id` mediumint NOT NULL AUTO_INCREMENT,
  `id_log` mediumint DEFAULT NULL,
  `id_user` mediumint DEFAULT NULL,
  `raw` varchar(255) DEFAULT NULL,
  `en` varchar(255) DEFAULT NULL,
  `jp` varchar(255) DEFAULT NULL,
  `ch` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `translate_general`
--

INSERT INTO `translate_general` VALUES (1,12621,1,'male','male','男性',''),(2,12623,1,'female','female','女性',''),(3,12625,1,'other','other','その他',''),(4,12627,1,'single','single','独身',''),(5,12629,1,'married','married','既婚',''),(6,12713,1,'number_hit','Total','検索ヒット数',''),(7,12719,1,'number_hit_unit',' hit','件',''),(8,12725,1,'page_next','next >>','次の頁 ＞',''),(9,12731,1,'page_prev','<< prev','＜ 前の頁',''),(10,12742,1,'warning_delete_or_not','Delete?','削除を実行しますか？',''),(11,12766,1,'warning_update_or_not','Update?','変更を実行しますか？',''),(12,12806,1,'button_send','Send','送信',''),(13,12871,1,'data_new','New','新規',''),(14,12875,1,'data_search','Search','検索',''),(15,12881,1,'data_search_again','New search','再検索',''),(16,12883,1,'data_search_result','Results','検索結果',''),(17,12889,1,'button_reset','Reset','リセット',''),(18,12892,1,'Japanese_national','Japanese national','日本人',''),(19,12918,1,'Japanese_national_dependent','Japanese national (dependent)','扶養内',''),(20,12921,1,'student_visa','Student visa','留学ビザ',''),(21,12942,1,'spouse_visa','Spouse visa','配偶者ビザ（日本人を配偶者に持つ外国人）',''),(22,12946,1,'spouse_visa_dependent','Spouse visa (dependent)','配偶者ビザ（扶養）',''),(23,12950,1,'dependent_visa','Dependent visa','家族滞在ビザ（就労ビザの外国人の扶養を受けている配偶者や子供）',''),(24,12954,1,'permanent_resident_visa','Permanent resident visa','永住ビザ',''),(25,12958,1,'long_term_visa','Long term visa','長期ビザ',''),(26,14809,1,'age_at_end_of_this_month','Age at end of this month','今月末の年齢',''),(27,14811,1,'years_old','years old','歳',''),(28,14817,1,'person',' ','人',''),(29,14823,1,'number_of_dependents','Number of dependents','扶養親族等の数',''),(30,14827,1,'prefecture','Prefecture','都道府県名',''),(31,14829,1,'health_insurance_premium','Health insurance premium','健康保険料',''),(32,14831,1,'welfare_pension_premium','Welfare pension premium','厚生年金保険料',''),(33,14833,1,'employment_insurance_premium','Employment insurance premium','雇用保険料',''),(34,14835,1,'industrial_accident_insurance_premium','Industrial accident insurance premium','労災保険料',''),(35,14837,1,'long_term_care_insurance_premium','Long-term care insurance premium','介護保険料',''),(36,14839,1,'withholding_tax','Withholding tax','源泉徴収税',''),(37,14857,1,'rate_of_social_insurance_tax','Rate of social insurance tax','社会保険税率',''),(38,14863,1,'yen','Yen','円',''),(39,14880,1,'symbol_percent','%','％',''),(40,14971,1,'visa_status','Visa status','国籍／ビザ等',''),(41,14975,1,'salary_month','Monthly salary','給料',''),(42,14983,1,'salary','Salary','給与',''),(43,15895,1,'year','Year','年',''),(44,15897,1,'month','Month','月',''),(45,16740,1,'date','Date','日付',''),(46,16743,1,'day_of_week','Day','曜日',''),(47,16872,1,'delete','Delete','削除',''),(48,17037,1,'add_to_shift','Add to schedule','シフトに追加',''),(49,17039,1,'add_to_dakoku','Record working hours','打刻する',''),(50,17115,1,'job','Job','仕事',''),(51,17117,1,'period','Period','期間',''),(52,17120,1,'item','Item','項目',''),(53,23943,1,'en','English','英語',''),(54,23945,1,'jp','Japanese','日本語',''),(55,NULL,NULL,'spouse_visa_to_permanent_resident','Spouse visa to permanent resident','永住者の配偶者ビザ',NULL),(56,NULL,NULL,'work_visa','Work visa','就労ビザ',NULL),(57,NULL,NULL,'number_hit_unit_plural',' hits','件',NULL),(58,NULL,NULL,'group','Group','グループ',NULL),(59,27657,1,'identification_number','ID','認識番号',''),(60,27668,1,'name','Name','名前',''),(61,27670,1,'age','Age','年齢',''),(62,27672,1,'visa','Visa','国籍／ビザ等',''),(63,27674,1,'working_hours','Working hours','労働時間',''),(64,27676,1,'extra_working_hours','Extra working hours','残業時間',''),(65,27679,1,'income','Income','所得',''),(66,1,1,'warning_insert_default_shift','Link the working hour as the scheduled hour?','紐付けられていない労働時間を、そのままこのシフトに紐付けますか？',''),(67,1,1,'warning_insert_default_dakoku','Set the scheduled hour in the working hour?','シフト時間通りの労働時間を打刻しますか？',''),(68,1,1,'warning_insert_link_or_not','Link and add the default working hour ?','打刻の紐付けを追加しますか？',''),(69,29375,1,'work_hour_start','Start','開始',''),(70,29386,1,'work_hour_finish','Finish','終了',''),(71,29388,1,'work_hour_duration','Duration','時間',''),(72,29390,1,'work_hourly_property','Property','属性',''),(73,29392,1,'work_hourly_rate','Hourly rate','時給',''),(74,29394,1,'work_salary','Salary','給料',''),(75,31898,1,'silent','Absent without notice','無断欠勤',''),(76,31901,1,'unwell','Illness or injury','傷病欠勤',''),(77,31904,1,'family','Family-related reasons','家事都合',''),(78,31909,1,'notes','Notes','備考',''),(79,31913,1,'unknown','Unknown','不明',''),(80,31936,1,'cancel','Cancel','キャンセル',''),(81,31939,1,'write_reason','Write','記録',''),(82,31959,1,'absent_from_work','Absent','欠勤',''),(83,32111,1,'shift_dakoku','Work on time','通常出勤',''),(84,32128,1,'shift_dakoku_late','Late','遅刻',''),(85,32131,1,'shift_dakoku_leave','Early leave','早退',''),(86,32133,1,'shift_dakoku_late_leave','Late & early leave','遅刻＆早退',''),(87,32135,1,'noshift_dakoku','Unscheduled work','シフトなし勤務',''),(88,32137,1,'shift_absent','Absent','欠勤',''),(89,32139,1,'shift_nodakoku_past','Not recorded yet','未打刻',''),(90,32141,1,'shift_nodakoku_now','Not recorded yet (today)','未打刻（当日）',''),(91,32143,1,'shift_nodakoku_future','Scheduled for work','シフト',''),(92,32175,1,'personal','Personal','私事都合',''),(93,32177,1,'traffic','Traffic','交通障害',''),(94,33825,1,'imminent','Last moment','ドタキャン',''),(95,36250,1,'student_visa_over_28_hours','This person\'s visa status is \'student\', who is allowed to work maximum of 28 hours per week. It will exceed if this person takes the work.','この人は「学生ビザ」で、この仕事をしてしまうと、週28時間の労働時間上限を超えるためスワップできない。',''),(96,37358,1,'dependent_over_88000_yen','Not able to swap as a dependent status, because the monthly salary will exceed 88,000 yen.','扶養内で働いているため、月収 88,000円を超える労働は控える。','');


