--
-- Host: localhost    Database: web_monitor_db_012
-- ------------------------------------------------------


--
-- Table structure for table `website_checks`
--

CREATE TABLE `website_checks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `website_id` int unsigned NOT NULL COMMENT '|ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ID| websites ãƒ†ãƒ¼ãƒ–ãƒ«ã¸ã®å¤–éƒ¨ã‚­ãƒ¼å‚ç…§',
  `checked_at` datetime NOT NULL COMMENT '|å·¡å›žå®Ÿè¡Œæ—¥æ™‚| å·¡å›žå®Ÿè¡Œæ—¥æ™‚',
  `http_status_code` int unsigned DEFAULT NULL COMMENT '|HTTPã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚³ãƒ¼ãƒ‰| HTTPã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ã‚³ãƒ¼ãƒ‰ (ä¾‹: 200ã€€403',
  `error_message` text COMMENT '|ã‚¨ãƒ©ãƒ¼ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸| ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã—ãŸå ´åˆã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ï¼ˆä¾‹: "Connection timed out" ãªã©ï¼‰',
  `is_success` tinyint(1) NOT NULL COMMENT '|æˆåŠŸãƒ•ãƒ©ã‚°| å·¡å›žãŒæˆåŠŸã—ãŸã‹ã©ã†ã‹ (True: æˆåŠŸã€€False: å¤±æ•—)',
  `is_chatwork_notified` tinyint(1) NOT NULL DEFAULT '0' COMMENT '|Chatworké€šçŸ¥æ¸ˆ| Chatworkã«é€šçŸ¥ã•ã‚ŒãŸã‹ã©ã†ã‹',
  `retry_count` int unsigned NOT NULL DEFAULT '0' COMMENT '|å†è©¦è¡Œå›žæ•°| ä»Šå›žã®å·¡å›žãŒå‰å›žã®å¤±æ•—ã‹ã‚‰ã®ä½•å›žç›®ã®å†è©¦è¡Œã§ã‚ã‚‹ã‹',
  `response_time_ms` int unsigned DEFAULT NULL COMMENT '|å¿œç­”æ™‚é–“(ms)| ãƒ¬ã‚¹ãƒãƒ³ã‚¹æ™‚é–“ï¼ˆãƒŸãƒªç§’',
  PRIMARY KEY (`id`),
  KEY `fk_website_id` (`website_id`),
  CONSTRAINT `fk_website_id` FOREIGN KEY (`website_id`) REFERENCES `websites` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=255 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='ãƒ­ã‚°';

--
-- Dumping data for table `website_checks`
--

INSERT INTO `website_checks` VALUES (15,1,'2025-06-07 15:56:03',200,NULL,1,0,0,168),(16,2,'2025-06-07 15:56:05',404,'HTTPステータスコード: 404',0,0,0,1979),(17,2,'2025-06-07 16:02:04',404,'HTTPステータスコード: 404',0,1,1,1473),(18,2,'2025-06-07 16:08:04',404,'HTTPステータスコード: 404',0,1,2,1836),(19,2,'2025-06-07 16:14:04',404,'HTTPステータスコード: 404',0,1,3,1455),(20,2,'2025-06-07 16:20:04',404,'HTTPステータスコード: 404',0,1,4,1783),(21,2,'2025-06-07 16:26:04',404,'HTTPステータスコード: 404',0,1,5,1499),(22,2,'2025-06-07 16:32:04',404,'HTTPステータスコード: 404',0,1,6,1854),(23,2,'2025-06-07 16:38:04',404,'HTTPステータスコード: 404',0,1,7,1476),(24,2,'2025-06-07 16:44:04',404,'HTTPステータスコード: 404',0,1,8,1478),(25,2,'2025-06-07 16:50:04',404,'HTTPステータスコード: 404',0,1,9,1463),(26,2,'2025-06-07 16:56:05',404,'HTTPステータスコード: 404',0,1,10,1818),(27,1,'2025-06-07 16:57:03',200,NULL,1,0,0,168),(28,2,'2025-06-07 17:02:03',404,'HTTPステータスコード: 404',0,1,11,1456),(29,2,'2025-06-07 17:08:04',404,'HTTPステータスコード: 404',0,1,12,1768),(30,2,'2025-06-07 17:14:03',404,'HTTPステータスコード: 404',0,1,13,1439),(31,2,'2025-06-07 17:20:05',404,'HTTPステータスコード: 404',0,1,14,1882),(32,2,'2025-06-07 17:26:04',404,'HTTPステータスコード: 404',0,1,15,1418),(33,2,'2025-06-07 17:32:04',404,'HTTPステータスコード: 404',0,1,16,1866),(34,2,'2025-06-07 17:38:04',404,'HTTPステータスコード: 404',0,1,17,1470),(35,2,'2025-06-07 17:44:04',404,'HTTPステータスコード: 404',0,1,18,1912),(36,2,'2025-06-07 17:50:04',404,'HTTPステータスコード: 404',0,1,19,1424),(37,2,'2025-06-07 17:56:05',404,'HTTPステータスコード: 404',0,1,20,1801),(38,1,'2025-06-07 17:58:03',200,NULL,1,0,0,173),(39,2,'2025-06-07 18:02:04',404,'HTTPステータスコード: 404',0,1,21,1442),(40,2,'2025-06-07 18:08:04',404,'HTTPステータスコード: 404',0,1,22,1836),(41,2,'2025-06-07 18:14:04',404,'HTTPステータスコード: 404',0,1,23,1437),(42,2,'2025-06-07 18:20:05',404,'HTTPステータスコード: 404',0,1,24,1734),(43,2,'2025-06-07 18:26:04',404,'HTTPステータスコード: 404',0,1,25,1457),(44,2,'2025-06-07 18:32:05',404,'HTTPステータスコード: 404',0,1,26,1800),(45,2,'2025-06-07 18:38:04',404,'HTTPステータスコード: 404',0,1,27,1446),(46,2,'2025-06-07 18:44:04',404,'HTTPステータスコード: 404',0,1,28,1778),(47,2,'2025-06-07 18:50:04',404,'HTTPステータスコード: 404',0,1,29,1523),(48,2,'2025-06-07 18:56:05',404,'HTTPステータスコード: 404',0,1,30,1836),(49,1,'2025-06-07 18:59:02',200,NULL,1,0,0,100),(50,2,'2025-06-07 19:02:04',404,'HTTPステータスコード: 404',0,1,31,1551),(51,2,'2025-06-07 19:08:04',404,'HTTPステータスコード: 404',0,1,32,1836),(52,2,'2025-06-07 19:14:04',404,'HTTPステータスコード: 404',0,1,33,1457),(53,2,'2025-06-07 19:20:05',404,'HTTPステータスコード: 404',0,1,34,1819),(54,3,'2025-06-07 19:24:03',200,NULL,1,0,0,32),(55,2,'2025-06-07 19:26:04',404,'HTTPステータスコード: 404',0,1,35,1476),(56,2,'2025-06-07 19:32:05',404,'HTTPステータスコード: 404',0,1,36,1833),(57,2,'2025-06-07 19:38:03',200,NULL,1,0,37,431),(58,1,'2025-06-07 20:00:02',200,NULL,1,0,0,104),(59,1,'2025-06-07 21:00:03',200,NULL,1,0,0,107),(60,1,'2025-06-07 22:01:02',200,NULL,1,0,0,135),(61,1,'2025-06-07 23:01:03',200,NULL,1,0,0,118),(62,1,'2025-06-08 00:02:03',200,NULL,1,0,0,109),(63,1,'2025-06-08 01:03:02',200,NULL,1,0,0,104),(64,1,'2025-06-08 02:03:02',200,NULL,1,0,0,110),(65,1,'2025-06-08 03:03:02',200,NULL,1,0,0,103),(66,1,'2025-06-08 04:03:03',200,NULL,1,0,0,181),(67,1,'2025-06-08 05:04:02',200,NULL,1,0,0,97),(68,1,'2025-06-08 06:05:03',200,NULL,1,0,0,98),(69,1,'2025-06-08 07:06:02',200,NULL,1,0,0,101),(70,1,'2025-06-08 08:06:03',200,NULL,1,0,0,138),(71,1,'2025-06-08 09:07:03',200,NULL,1,0,0,111),(72,1,'2025-06-08 10:08:03',200,NULL,1,0,0,143),(73,1,'2025-06-08 11:09:02',200,NULL,1,0,0,113),(74,1,'2025-06-08 12:09:03',200,NULL,1,0,0,102),(75,1,'2025-06-08 13:10:02',200,NULL,1,0,0,213),(76,1,'2025-06-08 14:10:03',200,NULL,1,0,0,206),(77,1,'2025-06-08 15:11:03',200,NULL,1,0,0,173),(78,1,'2025-06-08 16:12:03',200,NULL,1,0,0,172),(79,1,'2025-06-08 17:13:03',200,NULL,1,0,0,175),(80,1,'2025-06-08 18:14:03',200,NULL,1,0,0,168),(81,1,'2025-06-08 19:15:03',200,NULL,1,0,0,111),(82,1,'2025-06-08 20:16:03',200,NULL,1,0,0,104),(83,1,'2025-06-08 21:17:03',200,NULL,1,0,0,98),(84,1,'2025-06-08 22:18:03',200,NULL,1,0,0,104),(85,1,'2025-06-08 23:19:02',200,NULL,1,0,0,111),(86,1,'2025-06-09 00:19:02',200,NULL,1,0,0,115),(87,1,'2025-06-09 01:20:02',200,NULL,1,0,0,103),(88,1,'2025-06-09 02:20:02',200,NULL,1,0,0,97),(89,1,'2025-06-09 03:20:03',200,NULL,1,0,0,97),(90,1,'2025-06-09 04:21:03',200,NULL,1,0,0,97),(91,1,'2025-06-09 05:22:03',200,NULL,1,0,0,95),(92,1,'2025-06-09 06:23:02',200,NULL,1,0,0,104),(93,1,'2025-06-09 07:23:02',200,NULL,1,0,0,103),(94,1,'2025-06-09 08:24:02',200,NULL,1,0,0,95),(95,1,'2025-06-09 09:24:03',200,NULL,1,0,0,117),(96,1,'2025-06-09 10:25:02',200,NULL,1,0,0,154),(97,1,'2025-06-09 11:25:03',200,NULL,1,0,0,119),(98,1,'2025-06-09 12:26:02',200,NULL,1,0,0,171),(99,1,'2025-06-09 13:26:03',200,NULL,1,0,0,188),(100,1,'2025-06-09 14:27:03',200,NULL,1,0,0,262),(101,1,'2025-06-09 15:28:03',200,NULL,1,0,0,194),(102,1,'2025-06-10 14:55:03',200,NULL,1,0,0,174),(103,1,'2025-06-10 15:56:02',200,NULL,1,0,0,169),(104,5,'2025-06-10 16:11:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7c23e3967d40>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(105,5,'2025-06-10 16:17:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x79df8d017ec0>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(106,2,'2025-06-10 16:52:02',200,NULL,1,0,0,38),(107,1,'2025-06-10 16:56:03',200,NULL,1,0,0,169),(108,1,'2025-06-10 17:57:03',200,NULL,1,0,0,164),(109,1,'2025-06-10 18:58:03',200,NULL,1,0,0,164),(110,1,'2025-06-10 19:59:03',200,NULL,1,0,0,164),(111,1,'2025-06-10 21:00:03',200,NULL,1,0,0,181),(112,1,'2025-06-10 22:01:02',200,NULL,1,0,0,99),(113,1,'2025-06-10 23:01:02',200,NULL,1,0,0,96),(114,1,'2025-06-11 00:01:03',200,NULL,1,0,0,146),(115,1,'2025-06-11 01:02:03',200,NULL,1,0,0,105),(116,1,'2025-06-11 02:03:02',200,NULL,1,0,0,102),(117,1,'2025-06-11 03:03:02',200,NULL,1,0,0,96),(118,1,'2025-06-11 04:03:03',200,NULL,1,0,0,99),(119,1,'2025-06-11 05:04:02',200,NULL,1,0,0,97),(120,1,'2025-06-11 06:04:02',200,NULL,1,0,0,92),(121,1,'2025-06-11 07:04:03',200,NULL,1,0,0,97),(122,1,'2025-06-11 08:05:02',200,NULL,1,0,0,100),(123,1,'2025-06-11 09:05:03',200,NULL,1,0,0,136),(124,1,'2025-06-11 10:06:03',200,NULL,1,0,0,129),(125,1,'2025-06-11 11:07:03',200,NULL,1,0,0,131),(126,1,'2025-06-11 12:08:03',200,NULL,1,0,0,297),(127,6,'2025-06-11 12:20:03',200,NULL,1,0,0,34),(128,1,'2025-06-11 13:09:03',200,NULL,1,0,0,196),(129,6,'2025-06-11 13:21:03',404,'HTTPステータスコード: 404',0,0,0,167),(130,6,'2025-06-11 13:27:03',404,'HTTPステータスコード: 404',0,1,1,620),(131,6,'2025-06-11 13:33:02',404,'HTTPステータスコード: 404',0,1,2,79),(132,6,'2025-06-11 13:39:03',404,'HTTPステータスコード: 404',0,1,3,190),(133,1,'2025-06-11 14:10:03',200,NULL,1,0,0,168),(134,5,'2025-06-11 14:38:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x70a56be63e90>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(135,5,'2025-06-11 14:44:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7c5b13963d70>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(136,1,'2025-06-11 15:11:02',200,NULL,1,0,0,172),(137,5,'2025-06-11 15:45:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x71789ba666f0>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(138,5,'2025-06-11 15:50:03',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7e5be4569d30>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(139,1,'2025-06-11 16:11:02',200,NULL,1,0,0,179),(140,5,'2025-06-11 16:51:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x7cf445d62720>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,0,0,NULL),(141,5,'2025-06-11 16:56:02',NULL,'HTTPConnectionPool(host=\'test.site.com\', port=80): Max retries exceeded with url: / (Caused by NameResolutionError(\"<urllib3.connection.HTTPConnection object at 0x725299763f80>: Failed to resolve \'test.site.com\' ([Errno -2] Name or service not known)\"))',0,1,1,NULL),(142,1,'2025-06-11 17:11:03',200,NULL,1,0,0,193),(143,1,'2025-06-11 18:12:02',200,NULL,1,0,0,172),(144,1,'2025-06-11 19:12:02',200,NULL,1,0,0,116),(145,1,'2025-06-11 20:12:03',200,NULL,1,0,0,108),(146,1,'2025-06-11 21:13:03',200,NULL,1,0,0,103),(147,1,'2025-06-11 22:14:03',200,NULL,1,0,0,103),(148,1,'2025-06-11 23:15:03',200,NULL,1,0,0,98),(149,1,'2025-06-12 00:16:03',200,NULL,1,0,0,106),(150,1,'2025-06-12 01:17:02',200,NULL,1,0,0,104),(151,1,'2025-06-12 02:17:03',200,NULL,1,0,0,151),(152,1,'2025-06-12 03:18:03',200,NULL,1,0,0,132),(153,1,'2025-06-12 04:19:02',200,NULL,1,0,0,145),(154,1,'2025-06-12 05:19:03',200,NULL,1,0,0,97),(155,1,'2025-06-12 06:20:03',200,NULL,1,0,0,97),(156,1,'2025-06-12 07:21:02',200,NULL,1,0,0,122),(157,1,'2025-06-12 08:21:03',200,NULL,1,0,0,108),(158,1,'2025-06-12 09:22:03',200,NULL,1,0,0,99),(159,1,'2025-06-12 10:23:03',200,NULL,1,0,0,99),(160,6,'2025-06-12 10:41:03',404,'HTTPステータスコード: 404',0,0,0,203),(161,6,'2025-06-12 10:47:03',404,'HTTPステータスコード: 404',0,1,1,386),(162,1,'2025-06-12 11:24:03',200,NULL,1,0,0,439),(163,6,'2025-06-12 11:48:03',404,'HTTPステータスコード: 404',0,0,0,390),(164,6,'2025-06-12 11:54:03',404,'HTTPステータスコード: 404',0,1,1,80),(165,1,'2025-06-12 12:25:03',200,NULL,1,0,0,175),(166,6,'2025-06-12 12:55:03',404,'HTTPステータスコード: 404',0,0,0,531),(167,6,'2025-06-12 13:01:02',404,'HTTPステータスコード: 404',0,1,1,163),(168,1,'2025-06-12 13:26:02',200,NULL,1,0,0,166),(169,1,'2025-06-12 14:26:03',200,NULL,1,0,0,171),(170,1,'2025-06-12 15:27:03',200,NULL,1,0,0,285),(171,1,'2025-06-12 16:28:03',200,NULL,1,0,0,171),(172,7,'2025-06-12 16:47:03',200,NULL,1,0,0,171),(173,8,'2025-06-12 16:47:05',404,'HTTPステータスコード: 404',0,0,0,2241),(174,8,'2025-06-12 16:53:04',404,'HTTPステータスコード: 404',0,1,1,1381),(175,9,'2025-06-12 17:16:03',200,NULL,1,0,0,168),(176,10,'2025-06-12 17:16:04',404,'HTTPステータスコード: 404',0,0,0,1823),(177,10,'2025-06-12 17:22:05',404,'HTTPステータスコード: 404',0,1,1,1775),(178,1,'2025-06-12 17:29:03',200,NULL,1,0,0,175),(179,11,'2025-06-12 17:35:03',200,NULL,1,0,0,180),(180,12,'2025-06-12 17:35:04',404,'HTTPステータスコード: 404',0,0,0,1778),(181,12,'2025-06-12 17:41:05',404,'HTTPステータスコード: 404',0,1,1,1809),(182,7,'2025-06-12 17:48:02',200,NULL,1,0,0,191),(183,8,'2025-06-12 17:54:04',404,'HTTPステータスコード: 404',0,0,0,1861),(184,8,'2025-06-12 18:00:04',404,'HTTPステータスコード: 404',0,1,1,1497),(185,9,'2025-06-12 18:17:03',200,NULL,1,0,0,167),(186,10,'2025-06-12 18:23:04',404,'HTTPステータスコード: 404',0,0,0,1838),(187,10,'2025-06-12 18:29:04',404,'HTTPステータスコード: 404',0,1,1,1419),(188,1,'2025-06-12 18:30:02',200,NULL,1,0,0,191),(189,11,'2025-06-12 18:36:03',200,NULL,1,0,0,171),(190,13,'2025-06-12 18:37:29',200,NULL,1,0,0,166),(191,14,'2025-06-12 18:37:29',404,'HTTPステータスコード: 404',0,0,0,1815),(192,12,'2025-06-12 18:42:04',404,'HTTPステータスコード: 404',0,0,0,1365),(193,14,'2025-06-12 18:43:04',404,'HTTPステータスコード: 404',0,1,1,1413),(194,7,'2025-06-12 18:48:02',200,NULL,1,0,0,161),(195,12,'2025-06-12 18:48:04',404,'HTTPステータスコード: 404',0,1,1,1819),(196,8,'2025-06-12 19:01:04',404,'HTTPステータスコード: 404',0,0,0,1832),(197,15,'2025-06-12 19:03:35',200,NULL,1,0,0,172),(198,16,'2025-06-12 19:03:35',404,'HTTPステータスコード: 404',0,0,0,1384),(199,8,'2025-06-12 19:07:04',404,'HTTPステータスコード: 404',0,1,1,1389),(200,16,'2025-06-12 19:09:04',404,'HTTPステータスコード: 404',0,1,1,1380),(201,17,'2025-06-12 19:09:13',200,NULL,1,0,0,167),(202,18,'2025-06-12 19:09:13',404,'HTTPステータスコード: 404',0,0,0,31),(203,19,'2025-06-12 19:10:16',200,NULL,1,0,0,169),(204,20,'2025-06-12 19:10:16',404,'HTTPステータスコード: 404',0,0,0,1416),(205,21,'2025-06-12 19:11:54',200,NULL,1,0,0,162),(206,22,'2025-06-12 19:11:55',404,'HTTPステータスコード: 404',0,0,0,1142),(207,18,'2025-06-12 19:15:04',404,'HTTPステータスコード: 404',0,1,1,1457),(208,20,'2025-06-12 19:16:04',404,'HTTPステータスコード: 404',0,1,1,1113),(209,22,'2025-06-12 19:17:05',404,'HTTPステータスコード: 404',0,1,1,1440),(210,9,'2025-06-12 19:18:03',200,NULL,1,0,0,118),(211,23,'2025-06-12 19:19:29',200,NULL,1,0,0,86),(212,24,'2025-06-12 19:19:29',404,'HTTPステータスコード: 404',0,0,0,1389),(213,24,'2025-06-12 19:25:04',404,'HTTPステータスコード: 404',0,1,1,1409),(214,1,'2025-06-15 13:23:02',200,NULL,1,0,0,166),(215,14,'2025-06-15 13:23:02',404,'HTTPステータスコード: 404',0,0,0,1879),(216,14,'2025-06-15 13:29:01',404,'HTTPステータスコード: 404',0,1,1,1431),(217,1,'2025-06-15 14:24:01',200,NULL,1,0,0,184),(218,14,'2025-06-15 14:29:01',404,'HTTPステータスコード: 404',0,0,0,1839),(219,14,'2025-06-15 14:34:01',404,'HTTPステータスコード: 404',0,1,1,1418),(220,1,'2025-06-15 15:24:01',200,NULL,1,0,0,222),(221,14,'2025-06-15 15:34:01',404,'HTTPステータスコード: 404',0,0,0,1908),(222,14,'2025-06-15 15:39:02',404,'HTTPステータスコード: 404',0,1,1,1476),(223,1,'2025-06-15 16:24:02',200,NULL,1,0,0,176),(224,14,'2025-06-15 16:39:02',404,'HTTPステータスコード: 404',0,0,0,1808),(225,14,'2025-06-15 16:45:01',404,'HTTPステータスコード: 404',0,1,1,1401),(226,1,'2025-06-15 17:25:01',200,NULL,1,0,0,181),(227,1,'2025-06-15 18:25:01',200,NULL,1,0,0,175),(228,1,'2025-06-15 19:25:01',200,NULL,1,0,0,173),(229,1,'2025-06-15 20:25:01',200,NULL,1,0,0,98),(230,1,'2025-06-15 21:25:01',200,NULL,1,0,0,179),(231,1,'2025-06-15 22:25:01',200,NULL,1,0,0,104),(232,1,'2025-06-15 23:25:01',200,NULL,1,0,0,165),(233,1,'2025-06-16 00:25:02',200,NULL,1,0,0,134),(234,1,'2025-06-16 01:26:01',200,NULL,1,0,0,140),(235,1,'2025-06-16 02:26:01',200,NULL,1,0,0,99),(236,1,'2025-06-16 03:26:01',200,NULL,1,0,0,101),(237,1,'2025-06-16 04:26:01',200,NULL,1,0,0,102),(238,1,'2025-06-16 05:26:01',200,NULL,1,0,0,137),(239,1,'2025-06-16 06:26:01',200,NULL,1,0,0,104),(240,1,'2025-06-16 07:26:02',200,NULL,1,0,0,99),(241,1,'2025-06-16 08:27:02',200,NULL,1,0,0,135),(242,1,'2025-06-16 09:27:02',200,NULL,1,0,0,105),(243,6,'2025-06-16 10:19:01',200,NULL,1,0,0,233),(244,1,'2025-06-16 10:28:01',200,NULL,1,0,0,137),(245,6,'2025-06-16 11:19:01',404,'HTTPステータスコード: 404',0,0,0,101),(246,1,'2025-06-16 11:28:01',200,NULL,1,0,0,281),(247,6,'2025-06-16 11:52:01',404,'HTTPステータスコード: 404',0,1,1,107),(248,1,'2025-06-16 12:28:01',200,NULL,1,0,0,172),(249,6,'2025-06-16 12:52:01',404,'HTTPステータスコード: 404',0,0,0,163),(250,6,'2025-06-16 12:57:01',404,'HTTPステータスコード: 404',0,1,1,78),(251,1,'2025-06-16 13:28:02',200,NULL,1,0,0,211),(252,6,'2025-06-16 13:57:02',200,NULL,1,0,0,1159),(253,1,'2025-06-16 14:29:01',200,NULL,1,0,0,196),(254,6,'2025-06-16 14:58:01',200,NULL,1,0,0,454);

--
-- Table structure for table `websites`
--

CREATE TABLE `websites` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL COMMENT '|ãƒ¦ãƒ¼ã‚¶ãƒ¼ID| ã“ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚’ç™»éŒ²ã—ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ID',
  `url` varchar(2048) NOT NULL COMMENT '|URL| å·¡å›žå¯¾è±¡ã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã®URL',
  `name` varchar(255) NOT NULL COMMENT '|åå‰| ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã®è­˜åˆ¥åï¼ˆä¾‹: "å…¬å¼Webã‚µã‚¤ãƒˆ"',
  `check_interval_minutes` int unsigned NOT NULL DEFAULT '60' COMMENT '|å·¡å›žé–“éš”(åˆ†)| é€šå¸¸ã®å·¡å›žé–“éš”ï¼ˆåˆ†ï¼‰ã€‚åˆæœŸå€¤ã¯60åˆ†ï¼ˆ1æ™‚é–“ï¼‰ã€‚',
  `retry_interval_minutes` int unsigned NOT NULL DEFAULT '5' COMMENT '|å†è©¦è¡Œé–“éš”(åˆ†)| ã‚¨ãƒ©ãƒ¼æ™‚ã®å†è©¦è¡Œé–“éš”ï¼ˆåˆ†ï¼‰ã€‚åˆæœŸå€¤ã¯5åˆ†ã€‚',
  `max_retry_attempts` int unsigned NOT NULL DEFAULT '1' COMMENT '|æœ€å¤§å†è©¦è¡Œå›žæ•°| Chatworké€šçŸ¥ã¾ã§ã®æœ€å¤§å†è©¦è¡Œå›žæ•°ã€‚1å›žã‚¨ãƒ©ãƒ¼ã§å³é€šçŸ¥ãªã‚‰0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1' COMMENT '|ã‚¢ã‚¯ãƒ†ã‚£ãƒ–| å·¡å›žã‚’ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã«ã™ã‚‹ã‹ã©ã†ã‹ï¼ˆTrue: ã‚¢ã‚¯ãƒ†ã‚£ãƒ–',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '|ä½œæˆæ—¥æ™‚| ãƒ¬ã‚³ãƒ¼ãƒ‰ä½œæˆæ—¥æ™‚',
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '|æ›´æ–°æ—¥æ™‚| ãƒ¬ã‚³ãƒ¼ãƒ‰æœ€çµ‚æ›´æ–°æ—¥æ™‚',
  PRIMARY KEY (`id`),
  KEY `fk_user_id` (`user_id`),
  CONSTRAINT `fk_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPACT COMMENT='Webã‚µã‚¤ãƒˆ';

--
-- Dumping data for table `websites`
--

INSERT INTO `websites` VALUES (1,1,'https://www.google.com','Google Search',60,5,1,1,'2025-06-06 11:05:34','2025-06-06 11:05:34'),(2,1,'https://www.example.com/','Non-existent Page',60,5,1,0,'2025-06-06 11:05:34','2025-06-10 07:52:49'),(3,1,'https://x162-43-39-30.static.xvps.ne.jp/','test-site',60,5,1,0,'2025-06-07 10:23:33','2025-06-07 10:48:44'),(5,1,'http://test.site.com','test',60,5,1,0,'2025-06-10 07:10:59','2025-06-11 08:03:30'),(6,8,'https://kaitorione.jp/','yahoo',60,5,1,1,'2025-06-11 03:19:22','2025-06-16 04:40:50'),(7,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 07:46:07','2025-06-12 10:28:09'),(8,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 07:46:07','2025-06-12 10:28:15'),(9,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 08:15:49','2025-06-12 10:28:21'),(10,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 08:15:49','2025-06-12 10:28:28'),(11,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 08:34:23','2025-06-12 10:28:34'),(12,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 08:34:23','2025-06-12 10:28:40'),(13,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 09:37:29','2025-06-12 10:28:45'),(14,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 09:37:29','2025-06-15 08:34:04'),(15,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:03:35','2025-06-12 10:28:58'),(16,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:03:35','2025-06-12 10:29:03'),(17,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:09:13','2025-06-12 10:29:08'),(18,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:09:13','2025-06-12 10:29:13'),(19,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:10:16','2025-06-12 10:29:19'),(20,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:10:16','2025-06-12 10:29:25'),(21,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:11:54','2025-06-12 10:29:30'),(22,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:11:54','2025-06-12 10:29:35'),(23,1,'https://www.google.com','Google Search',60,5,1,0,'2025-06-12 10:19:29','2025-06-12 10:29:39'),(24,1,'https://www.example.com/nonexistent-page','Non-existent Page',60,5,1,0,'2025-06-12 10:19:29','2025-06-12 10:29:43');


