-- -- Table structure for table `budgetsumcode` -- DROP TABLE IF EXISTS `budgetsumcode`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `budgetsumcode` ( `BlockCode` decimal(2,0) unsigned NOT NULL COMMENT 'ブロック番号', `GroupCode` decimal(2,0) unsigned NOT NULL COMMENT 'グループ番号', `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '構成キー', `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '工種キー', `ElementsName` varchar(100) NOT NULL COMMENT '要素名称', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`BlockCode`,`GroupCode`,`ComponentCode`,`ItemCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='予算書集計コードマスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `budgetsumcode` -- LOCK TABLES `budgetsumcode` WRITE; /*!40000 ALTER TABLE `budgetsumcode` DISABLE KEYS */; INSERT INTO `budgetsumcode` VALUES (1,0,1,0,'共通仮設工事費（積み上げ費含む）※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,2,0,'解体工事費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,3,0,'建築工事費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,4,0,'電気設備工事費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,5,0,'機械設備工事費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,6,0,'現場管理費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,7,0,'一般管理費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,18,0,'発生材処分費　※公共入札工事用','2018-05-24 09:41:24','2018-05-24 09:41:24'),(2,1,18,0,'発生材処分費　※公共入札工事用','2018-05-24 09:41:36','2018-05-24 09:41:36'),(3,2,7,0,'一般管理費　※公共入札工事用','2018-09-29 10:12:43','2018-09-29 10:12:43'),(3,2,8,0,'諸経費　※公共簡易・一般工事用','2018-09-29 10:12:43','2018-09-29 10:12:43'),(3,2,21,0,'一般管理費　※公共簡易・一般工事用','2018-09-29 10:12:43','2018-09-29 10:12:43'),(4,3,6,0,'現場管理費　※公共入札工事用','2018-05-24 09:42:01','2018-05-24 09:42:01'),(4,3,20,0,'現場管理費　※公共簡易・一般工事用','2018-05-24 09:42:01','2018-05-24 09:42:01'),(5,4,1,0,'共通仮設工事費（積み上げ費含む）※公共入札工事用','2018-05-24 09:42:21','2018-05-24 09:42:21'),(5,4,1,10,'積み上げ共通仮設費　※公共工事','2018-05-24 09:42:33','2018-05-24 09:42:33'),(6,5,2,0,'解体工事費　※公共入札工事用','2018-05-24 09:42:46','2018-05-24 09:42:46'),(6,6,3,0,'建築工事費　※公共入札工事用','2018-05-24 09:42:55','2018-05-24 09:42:55'),(6,7,4,0,'電気設備工事費　※公共入札工事用','2018-05-24 09:43:04','2018-05-24 09:43:04'),(6,8,5,0,'機械設備工事費　※公共入札工事用','2018-05-24 09:43:12','2018-05-24 09:43:12'); /*!40000 ALTER TABLE `budgetsumcode` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `businesstypemaster` -- DROP TABLE IF EXISTS `businesstypemaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `businesstypemaster` ( `BusinessTypeCode` decimal(5,0) unsigned NOT NULL COMMENT '法人格コード', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `BusinessTypeName` varchar(100) NOT NULL DEFAULT '' COMMENT '業種名', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`BusinessTypeCode`), KEY `BusinessTypeMaster_Index1` (`DisplayOrder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='法人格マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `businesstypemaster` -- LOCK TABLES `businesstypemaster` WRITE; /*!40000 ALTER TABLE `businesstypemaster` DISABLE KEYS */; INSERT INTO `businesstypemaster` VALUES (1,1,'株式会社','2015-11-04 00:00:00','2015-11-04 00:00:00'),(2,2,'有限会社','2015-11-04 00:00:00','2015-11-04 00:00:00'),(3,3,'合名会社','2015-11-04 00:00:00','2015-11-04 00:00:00'),(4,4,'合資会社','2015-11-04 00:00:00','2015-11-04 00:00:00'),(5,5,'合同会社','2015-11-04 00:00:00','2015-11-04 00:00:00'),(6,6,'医療法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(7,7,'医療法人社団','2015-11-04 00:00:00','2015-11-04 00:00:00'),(8,8,'医療法人財団','2015-11-04 00:00:00','2015-11-04 00:00:00'),(9,9,'社会医療法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(10,10,'財団法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(11,11,'一般財団法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(12,12,'公益財団法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(13,13,'社団法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(14,14,'一般社団法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(15,15,'公益社団法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(16,16,'宗教法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(17,17,'学校法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(18,18,'社会福祉法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(19,19,'更生保護法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(20,20,'相互会社','2015-11-04 00:00:00','2015-11-04 00:00:00'),(21,21,'特定非営利活動法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(22,22,'独立行政法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(23,23,'地方独立行政法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(24,24,'弁護士法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(25,25,'有限責任中間法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(26,26,'無限責任中間法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(27,27,'行政書士法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(28,28,'司法書士法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(29,29,'税理士法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(30,30,'国立大学法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(31,31,'公立大学法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(32,32,'農事組合法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(33,33,'管理組合法人','2015-11-04 00:00:00','2015-11-04 00:00:00'),(34,34,'社会保険労務士法人','2015-11-04 00:00:00','2015-11-04 00:00:00'); /*!40000 ALTER TABLE `businesstypemaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `chgchargedep` -- DROP TABLE IF EXISTS `chgchargedep`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `chgchargedep` ( `PersonCode` decimal(8,0) NOT NULL COMMENT '担当者コード', `StartDate` date NOT NULL COMMENT '開始年月日', `CompDate` date NOT NULL COMMENT '終了年月日', `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '部署コード', `DepartmentName` varchar(60) DEFAULT NULL COMMENT '部署名', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`PersonCode`,`StartDate`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='担当者部署履歴データ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `chgchargedep` -- LOCK TABLES `chgchargedep` WRITE; /*!40000 ALTER TABLE `chgchargedep` DISABLE KEYS */; INSERT INTO `chgchargedep` VALUES (20181001,'2020-01-01','9999-12-31',1,'工事部','2020-09-29 16:26:56','2020-09-29 16:26:56'); /*!40000 ALTER TABLE `chgchargedep` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componentlinkmaster` -- DROP TABLE IF EXISTS `componentlinkmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componentlinkmaster` ( `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '構成キー', `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '工種キー', `DisplayOrder` decimal(5,0) unsigned DEFAULT NULL COMMENT '表示順', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`ComponentCode`,`ItemCode`), KEY `ComponentLinkMaster_Index1` (`ComponentCode`), KEY `ComponentLinkMaster_Index2` (`ItemCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='構成工種関連マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componentlinkmaster` -- LOCK TABLES `componentlinkmaster` WRITE; /*!40000 ALTER TABLE `componentlinkmaster` DISABLE KEYS */; INSERT INTO `componentlinkmaster` VALUES (1,1,2,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,2,3,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,3,4,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,4,5,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,5,6,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,6,7,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,7,8,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,8,9,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,10,10,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(1,11,1,'2016-03-08 17:40:19','2016-03-08 17:40:19'),(2,15,2,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(2,16,3,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(2,17,4,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(2,18,5,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(2,19,6,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(2,20,1,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(2,21,7,'2016-02-15 15:13:10','2016-02-15 15:13:10'),(3,20,2,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,22,1,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,23,3,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,24,4,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,25,5,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,26,6,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,27,7,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,28,8,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,29,9,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,30,10,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,31,11,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,32,12,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,33,13,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,34,14,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,35,15,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,36,16,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,37,17,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,38,18,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,39,19,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,40,20,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,41,21,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,42,22,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,43,23,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,44,24,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,45,25,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,46,26,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,47,28,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,48,29,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,49,30,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,50,31,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,51,27,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,52,35,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,53,36,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,54,34,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,55,37,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,56,38,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,57,39,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,58,40,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,59,32,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,60,41,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,110,33,'2018-10-29 21:40:55','2018-10-29 21:40:55'),(3,111,42,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,112,43,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,140,45,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(3,166,44,'2018-10-29 21:40:56','2018-10-29 21:40:56'),(4,58,7,'2016-02-15 15:13:14','2016-02-15 15:13:14'),(4,61,1,'2016-02-15 15:13:13','2016-02-15 15:13:13'),(4,62,2,'2016-02-15 15:13:13','2016-02-15 15:13:13'),(4,63,3,'2016-02-15 15:13:13','2016-02-15 15:13:13'),(4,64,4,'2016-02-15 15:13:14','2016-02-15 15:13:14'),(4,65,5,'2016-02-15 15:13:14','2016-02-15 15:13:14'),(4,66,6,'2016-02-15 15:13:14','2016-02-15 15:13:14'),(5,58,10,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,67,2,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,68,3,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,69,4,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,70,5,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,71,6,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,72,7,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,73,8,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,74,9,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(5,131,1,'2017-02-13 18:45:45','2017-02-13 18:45:45'),(14,106,1,'2016-02-15 15:13:18','2016-02-15 15:13:18'),(14,107,2,'2016-02-15 15:13:18','2016-02-15 15:13:18'),(15,108,1,'2016-02-15 15:13:18','2016-02-15 15:13:18'),(15,109,2,'2016-02-15 15:13:18','2016-02-15 15:13:18'),(17,15,2,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,16,4,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,17,5,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,18,7,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,19,6,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,20,1,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,22,8,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,23,9,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,24,10,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,25,13,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,26,11,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,27,14,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,28,16,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,29,15,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,30,17,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,31,24,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,32,22,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,33,20,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,34,19,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,35,23,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,36,30,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,37,21,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,38,70,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,39,28,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,40,26,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,41,27,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,42,29,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,43,25,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,44,31,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,45,32,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,46,33,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,47,35,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,48,37,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,49,39,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,50,34,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,51,36,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,52,47,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,53,48,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,54,46,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,55,50,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,56,49,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,57,40,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,59,45,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,60,3,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,61,51,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,62,52,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,63,53,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,64,54,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,65,55,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,67,56,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,68,57,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,69,58,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,70,59,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,71,60,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,72,61,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,73,62,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,74,63,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,86,41,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,110,44,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,111,42,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,112,68,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,113,64,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,114,65,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,115,66,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,116,43,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,117,12,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,119,72,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,120,71,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,121,69,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,122,67,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,123,74,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,125,38,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(17,126,73,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,138,75,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,139,76,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,144,77,'2018-04-26 10:17:19','2018-04-26 10:17:19'),(17,165,18,'2018-04-26 10:17:18','2018-04-26 10:17:18'),(19,14,1,'2016-03-08 17:44:29','2016-03-08 17:44:29'),(22,67,1,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,68,2,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,69,3,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,70,4,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,71,5,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,72,6,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,73,7,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(22,124,8,'2016-12-23 10:06:54','2016-12-23 10:06:54'),(23,61,1,'2016-12-23 10:00:57','2016-12-23 10:00:57'),(23,62,2,'2016-12-23 10:00:57','2016-12-23 10:00:57'),(23,63,3,'2016-12-23 10:00:58','2016-12-23 10:00:58'),(23,64,4,'2016-12-23 10:00:58','2016-12-23 10:00:58'),(23,65,5,'2016-12-23 10:00:58','2016-12-23 10:00:58'),(23,71,6,'2016-12-23 10:00:58','2016-12-23 10:00:58'),(23,72,7,'2016-12-23 10:00:58','2016-12-23 10:00:58'),(23,73,8,'2016-12-23 10:00:58','2016-12-23 10:00:58'),(24,67,1,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,68,2,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,69,3,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,70,7,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,71,4,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,72,5,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,73,6,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,123,8,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,124,9,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,131,14,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,132,10,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,133,11,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,134,12,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,135,13,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(24,136,15,'2017-02-13 18:47:45','2017-02-13 18:47:45'),(25,61,1,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,62,2,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,63,3,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,64,4,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,65,5,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,71,6,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,72,7,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,127,8,'2017-01-17 08:07:46','2017-01-17 08:07:46'),(25,128,9,'2017-01-17 08:07:47','2017-01-17 08:07:47'),(25,129,10,'2017-01-17 08:07:47','2017-01-17 08:07:47'),(25,130,12,'2017-01-17 08:07:47','2017-01-17 08:07:47'),(25,131,13,'2017-01-17 08:07:47','2017-01-17 08:07:47'),(25,137,11,'2017-01-17 08:07:47','2017-01-17 08:07:47'),(26,160,1,'2018-04-05 18:42:54','2018-04-05 18:42:54'),(26,161,2,'2018-04-05 18:42:54','2018-04-05 18:42:54'),(26,162,5,'2018-04-05 18:42:54','2018-04-05 18:42:54'),(26,163,3,'2018-04-05 18:42:54','2018-04-05 18:42:54'),(26,164,4,'2018-04-05 18:42:54','2018-04-05 18:42:54'),(29,148,1,'2018-01-31 10:24:45','2018-01-31 10:24:45'),(29,149,2,'2018-01-31 10:24:45','2018-01-31 10:24:45'),(29,150,3,'2018-01-31 10:24:45','2018-01-31 10:24:45'),(30,151,1,'2018-01-31 10:25:14','2018-01-31 10:25:14'),(30,152,2,'2018-01-31 10:25:14','2018-01-31 10:25:14'),(30,153,3,'2018-01-31 10:25:14','2018-01-31 10:25:14'),(30,154,4,'2018-01-31 10:25:14','2018-01-31 10:25:14'),(31,63,4,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(31,73,2,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(31,155,1,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(31,156,3,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(31,157,5,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(31,158,6,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(31,159,7,'2018-02-01 08:05:16','2018-02-01 08:05:16'),(32,61,1,'2018-02-01 08:06:10','2018-02-01 08:06:10'),(32,67,2,'2018-02-01 08:06:10','2018-02-01 08:06:10'),(32,74,3,'2018-02-01 08:06:10','2018-02-01 08:06:10'); /*!40000 ALTER TABLE `componentlinkmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `componentmaster` -- DROP TABLE IF EXISTS `componentmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `componentmaster` ( `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '構成キー', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `ComponentName` varchar(120) NOT NULL DEFAULT '' COMMENT '構成名称', `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '下位項目フラグ', `DirectInputFlg` decimal(1,0) DEFAULT NULL COMMENT '直接入力フラグ', `MyExpensesFlg` decimal(1,0) DEFAULT NULL COMMENT '自社経費フラグ', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`ComponentCode`), KEY `ComponentMaster_Index1` (`DisplayOrder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='構成マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `componentmaster` -- LOCK TABLES `componentmaster` WRITE; /*!40000 ALTER TABLE `componentmaster` DISABLE KEYS */; INSERT INTO `componentmaster` VALUES (1,13,'共通仮設工事費（積み上げ費含む）※公共入札工事用',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(2,14,'解体工事費　※公共入札工事用',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(3,15,'建築工事費　※公共入札工事用',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(4,17,'電気設備工事費　※公共入札工事用',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(5,16,'機械設備工事費　※公共入札工事用',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(6,19,'現場管理費　※公共入札工事用',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(7,20,'一般管理費　※公共入札工事用',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(8,9,'諸経費　※公共簡易・一般工事用',0,1,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(14,10,'空き家修繕工事　※営繕部市住関連用',1,0,0,0,'2015-11-18 18:45:38','2018-04-05 19:19:45'),(15,11,'一般補修工事　※営繕部市住関連用',1,0,0,0,'2015-11-18 18:46:07','2018-04-05 19:19:45'),(16,12,'諸費用　※営繕部市住関連用',0,1,1,0,'2015-11-27 09:14:52','2018-04-05 19:19:45'),(17,2,'工事費　※公共簡易・一般工事用',1,0,0,0,'2016-02-16 11:29:45','2018-04-05 19:19:45'),(18,18,'発生材処分費　※公共入札工事用',0,1,0,0,'2016-03-08 16:41:32','2018-04-05 19:19:45'),(19,1,'仮設工事費　※公共簡易・一般工事用',1,0,0,0,'2016-03-08 17:03:35','2018-04-05 19:19:45'),(20,7,'現場管理費　※公共簡易・一般工事用',0,1,1,0,'2016-03-08 17:23:00','2018-04-05 19:19:45'),(21,8,'一般管理費　※公共簡易・一般工事用',0,1,1,0,'2016-03-08 17:24:06','2018-04-05 19:19:45'),(22,3,'水道工事費　※公共簡易・一般工事用',1,0,0,0,'2016-03-08 17:24:56','2018-04-05 19:19:45'),(23,4,'電気工事費　※公共簡易・一般工事用',1,0,0,0,'2016-03-08 17:25:37','2018-04-05 19:19:45'),(24,5,'機械設備工事費　※公共簡易・一般工事用',1,0,0,0,'2016-03-24 07:43:42','2018-04-05 19:19:45'),(25,6,'電気設備工事費　※公共簡易・一般工事用',1,0,0,0,'2016-03-24 07:44:15','2018-04-05 19:19:45'),(26,21,'設計費用',1,0,1,0,'2016-10-15 12:27:37','2018-04-05 19:19:45'),(27,22,'法定福利費',0,1,1,0,'2017-03-30 16:44:21','2018-04-05 19:19:45'),(28,23,'躯体工事※木造新築用',1,0,0,1,'2018-01-31 08:14:46','2018-10-23 07:52:54'),(29,24,'外部工事※木造新築用',1,0,0,1,'2018-01-31 08:15:48','2018-10-23 07:52:59'),(30,25,'内部工事※木造新築用',1,0,0,1,'2018-01-31 08:16:16','2018-10-23 07:53:03'),(31,26,'その他特殊工事※木造新築用',1,0,0,1,'2018-01-31 08:17:33','2018-10-23 07:53:06'),(32,27,'別途工事※木造新築用',1,0,0,1,'2018-01-31 08:18:25','2018-10-23 07:53:09'),(33,28,'諸費用※木造新築',1,0,1,1,'2018-01-31 10:29:30','2018-10-23 07:53:12'); /*!40000 ALTER TABLE `componentmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `constructionitemmaster` -- DROP TABLE IF EXISTS `constructionitemmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `constructionitemmaster` ( `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '工種キー', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `ItemName` varchar(120) NOT NULL DEFAULT '' COMMENT '工種名称', `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '下位項目フラグ', `MyExpensesFlg` decimal(1,0) NOT NULL COMMENT '自社経費フラグ', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`ItemCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工種マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `constructionitemmaster` -- LOCK TABLES `constructionitemmaster` WRITE; /*!40000 ALTER TABLE `constructionitemmaster` DISABLE KEYS */; INSERT INTO `constructionitemmaster` VALUES (1,1,'準備費　※標準算定率',0,1,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(2,2,'仮設建物費　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(3,3,'工事施設費　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(4,4,'環境安全費　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(5,5,'動力用水光熱費　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(6,6,'屋外整理清掃費　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(7,7,'機械器具費　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(8,8,'その他　※標準算定率',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(10,10,'積み上げ共通仮設費　※公共工事',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(11,9,'共通仮設算定率　※公共工事',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(14,11,'仮設工事　※簡易・一般工事',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(15,15,'解体工事費',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(16,16,'内部撤去工事',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(17,17,'外部撤去工事',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(18,19,'斫り工事',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(19,20,'解体材積み込み',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(20,12,'直接仮設工事費',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(21,90,'空き家　撤去工事',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:56'),(22,21,'土工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(23,22,'地業工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(24,24,'鉄筋工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(25,25,'コンクリート工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(26,26,'型枠工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(27,27,'鉄骨工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(28,28,'耐火被覆工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(29,29,'ＡＬＣパネル工事',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(30,30,'押出成形セメント板工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(31,32,'防水工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(32,33,'石・タイル工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(33,34,'木工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(34,35,'大工工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(35,37,'屋根・とい工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(36,38,'金属工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(37,39,'左官工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(38,40,'吹き付け工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(39,41,'木製建具工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(40,42,'金属製建具工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(41,43,'シャッター工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(42,44,'ガラス工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(43,46,'塗装工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(44,47,'内装工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(45,49,'軽鉄工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(46,50,'内装仕上げ工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(47,52,'ユニット工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(48,53,'フリーアクセスフロア工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(49,54,'外構工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(50,58,'その他工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(51,51,'家具工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(52,63,'防水改修工事',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(53,64,'塗装改修工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(54,62,'外壁改修工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(55,65,'建具改修工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(56,66,'内装改修工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(57,67,'耐震改修工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(58,89,'空き家　営繕工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:56'),(59,59,'改修工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(60,18,'撤去工事',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:54'),(61,68,'配線工事費',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(62,69,'ｺﾝｾﾝﾄ・スイッチ工事費',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(63,70,'照明器具工事費',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(64,71,'弱電工事費',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(65,72,'キュービクル・ブレーカー等',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:55'),(67,73,'給排水配管工事費',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(68,74,'衛星器具取り付け工事',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(69,76,'保温工事費',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(70,77,'配管類塗装工事費',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(71,78,'空調設備工事費',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(72,79,'吸気・換気工事',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(73,80,'エアコン工事',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(74,83,'ガス設備工事費',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(86,56,'植栽工事',1,0,0,'2016-02-15 15:13:16','2018-10-29 21:39:55'),(106,85,'空き家A修繕工事',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(107,86,'空き家C修繕工事',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(108,87,'個人負担工事',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(109,88,'行政負担工事',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(110,60,'補修工事',1,0,0,'2016-02-16 10:22:40','2018-10-29 21:39:55'),(111,61,'外部改修工事',1,0,0,'2016-04-18 07:55:25','2018-10-29 21:39:55'),(112,31,'既成コンクリート工事',1,0,0,'2016-04-21 08:26:28','2018-10-29 21:39:54'),(113,91,'Ｐｌａｎ-Ａ',1,0,0,'2016-09-14 16:22:45','2018-10-29 21:39:56'),(114,92,'Ｐｌａｎ-Ｂ',1,0,0,'2016-09-14 16:23:19','2018-10-29 21:39:56'),(115,93,'Ｐｌａｎ-Ｃ',1,0,0,'2016-09-14 16:23:45','2018-10-29 21:39:56'),(116,48,'外装工事',1,0,0,'2016-09-21 16:58:22','2018-10-29 21:39:55'),(117,23,'基礎工事',1,0,0,'2016-10-12 15:22:56','2018-10-29 21:39:54'),(118,13,'本体工事 ',1,0,0,'2016-10-27 13:09:47','2018-10-29 21:39:53'),(119,55,'屋外工事',1,0,0,'2016-10-27 13:10:39','2018-10-29 21:39:55'),(120,45,'建具・ガラス工事',1,0,0,'2016-10-27 13:13:18','2018-10-29 21:39:55'),(121,36,'木・内装工事',1,0,0,'2016-10-27 13:14:20','2018-10-29 21:39:54'),(122,14,'雑工事',1,0,0,'2016-10-27 13:14:46','2018-10-29 21:39:53'),(123,82,'冷蔵・冷凍設備工事',1,0,0,'2016-12-23 09:55:36','2018-10-29 21:39:56'),(124,75,'グリストラップ設置工事',1,0,0,'2016-12-23 10:06:14','2018-10-29 21:39:56'),(125,94,'厨房機器什器工事',1,0,0,'2016-12-23 10:33:40','2018-10-29 21:39:56'),(126,57,'サイン工事',1,0,0,'2017-01-14 10:20:06','2018-10-29 21:39:55'),(127,95,'高圧変電設備工事',1,0,0,'2017-01-17 07:50:49','2018-10-29 21:39:56'),(128,96,'幹線・動力設備工事',1,0,0,'2017-01-17 07:51:41','2018-10-29 21:39:56'),(129,97,'電灯・ｺﾝｾﾝﾄ設備工事',1,0,0,'2017-01-17 07:52:35','2018-10-29 21:39:56'),(130,99,'弱電設備工事',1,0,0,'2017-01-17 07:53:10','2018-10-29 21:39:56'),(131,100,'消防設備工事',1,0,0,'2017-01-17 07:53:51','2018-10-29 21:39:56'),(132,101,'ダクト・フード工事',1,0,0,'2017-01-17 07:54:33','2018-10-29 21:39:56'),(133,102,'機器本体（空調機器）',1,0,0,'2017-01-17 07:55:08','2018-10-29 21:39:56'),(134,103,'機器本体（換気機器）',1,0,0,'2017-01-17 07:59:26','2018-10-29 21:39:56'),(135,104,'空調設備工事',1,0,0,'2017-01-17 08:00:15','2018-10-29 21:39:56'),(136,105,'換気設備工事',1,0,0,'2017-01-17 08:01:02','2018-10-29 21:39:56'),(137,98,'照明設備工事',1,0,0,'2017-01-17 08:06:28','2018-10-29 21:39:56'),(138,106,'美装工事',1,0,0,'2017-02-15 08:19:36','2018-10-29 21:39:56'),(139,107,'減額工事',1,0,0,'2017-02-15 08:39:06','2018-10-29 21:39:56'),(140,108,'築造工事',1,0,0,'2017-03-09 17:19:19','2018-10-29 21:39:56'),(144,109,'増額工事',1,0,0,'2017-09-30 09:22:07','2018-10-29 21:39:56'),(145,110,'共通仮設工事※木造新築用',1,1,0,'2018-01-31 08:19:51','2018-10-29 21:39:56'),(146,111,'基礎工事※木造新築用',1,0,0,'2018-01-31 08:20:37','2018-10-29 21:39:57'),(147,112,'躯体工事※木造新築用',1,0,0,'2018-01-31 08:21:02','2018-10-29 21:39:57'),(148,113,'外部共通工事※木造新築用',1,0,0,'2018-01-31 08:21:28','2018-10-29 21:39:57'),(149,114,'外部建具工事※木造新築用',1,0,0,'2018-01-31 08:23:00','2018-10-29 21:39:57'),(150,115,'外部付帯工事※木造新築用',1,0,0,'2018-01-31 08:23:44','2018-10-29 21:39:57'),(151,116,'内部共通工事※木造新築用',1,0,0,'2018-01-31 08:24:32','2018-10-29 21:39:57'),(152,117,'内部建具工事※木造新築用',1,0,0,'2018-01-31 08:25:10','2018-10-29 21:39:57'),(153,118,'部屋工事工事※木造新築用',1,0,0,'2018-01-31 08:25:52','2018-10-29 21:39:57'),(154,119,'その他設備・付帯工事※木造新築用',1,0,0,'2018-01-31 08:26:21','2018-10-29 21:39:57'),(155,81,'太陽光発電工事',1,0,0,'2018-01-31 08:27:46','2018-10-29 21:39:56'),(156,84,'その他設備工事',1,0,0,'2018-02-01 07:59:14','2018-10-29 21:39:56'),(157,120,'窓掛工事',1,0,0,'2018-02-01 07:59:43','2018-10-29 21:39:57'),(158,121,'残土・客土工事',1,0,0,'2018-02-01 08:00:12','2018-10-29 21:39:57'),(159,122,'安全対策・特殊施工',1,0,0,'2018-02-01 08:00:56','2018-10-29 21:39:57'),(160,123,'調査業務',0,0,0,'2018-04-05 18:34:43','2018-10-29 21:39:57'),(161,124,'管理業務',0,0,0,'2018-04-05 18:35:06','2018-10-29 21:39:57'),(162,125,'設計業務：申請手数料',0,0,0,'2018-04-05 18:35:25','2018-10-29 21:39:57'),(163,126,'設計業務：構造検討費用',0,0,0,'2018-04-05 18:41:30','2018-10-29 21:39:57'),(164,127,'設計業務：意匠設計料',0,0,0,'2018-04-05 18:42:13','2018-10-29 21:39:57'),(165,128,'造作工事',1,0,0,'2018-04-26 10:16:20','2018-10-29 21:39:57'),(166,129,'屋根・折版工事',1,0,0,'2018-10-29 21:38:03','2018-10-29 21:39:57'); /*!40000 ALTER TABLE `constructionitemmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `constructiontypemaster` -- DROP TABLE IF EXISTS `constructiontypemaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `constructiontypemaster` ( `TypeCode` decimal(5,0) unsigned NOT NULL COMMENT '工事種別コード', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `NameString` varchar(100) NOT NULL COMMENT '名称', `PublicFlg` decimal(1,0) NOT NULL COMMENT '公共フラグ', `RepairFlg` decimal(1,0) NOT NULL COMMENT '新築・改修フラグ', `SecRank` decimal(1,0) NOT NULL COMMENT '保護区分ランク', `ExpensesLink` decimal(1,0) NOT NULL COMMENT '経費使用区分', `CompanyProp` decimal(1,0) NOT NULL COMMENT '自社工事区分', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`TypeCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='工事種別マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `constructiontypemaster` -- LOCK TABLES `constructiontypemaster` WRITE; /*!40000 ALTER TABLE `constructiontypemaster` DISABLE KEYS */; INSERT INTO `constructiontypemaster` VALUES (1,1,'公共工事　改修（元請）',1,2,4,0,0,0,'2015-11-17 08:16:00','2019-12-03 14:10:14'),(2,2,'公共工事　新築（元請）',1,1,4,0,0,0,'2016-01-30 10:35:47','2019-12-03 14:10:14'),(3,3,'公共工事　改修（下請）',1,2,4,0,0,0,'2015-11-17 08:16:00','2019-12-03 14:10:14'),(4,4,'公共工事　新築（下請）',1,1,4,0,0,0,'2016-01-30 10:42:20','2019-12-03 14:10:14'),(5,5,'民間工事　改修（元請）',2,0,4,0,0,0,'2015-11-16 15:19:01','2019-12-03 14:10:14'),(6,6,'民間工事　新築（元請）',2,0,4,0,0,0,'2016-01-30 10:43:14','2019-12-03 14:10:14'),(7,7,'民間工事　改修（下請）',2,0,4,0,0,0,'2015-11-16 15:19:01','2019-12-03 14:10:14'),(8,8,'民間工事　新築（下請）',2,0,4,0,0,0,'2016-01-30 10:43:47','2019-12-03 14:10:14'); /*!40000 ALTER TABLE `constructiontypemaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `daymaster` -- DROP TABLE IF EXISTS `daymaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `daymaster` ( `days` smallint(6) NOT NULL COMMENT '日', PRIMARY KEY (`days`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `daymaster` -- LOCK TABLES `daymaster` WRITE; /*!40000 ALTER TABLE `daymaster` DISABLE KEYS */; INSERT INTO `daymaster` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16),(17),(18),(19),(20),(21),(22),(23),(24),(25),(26),(27),(28),(29),(30),(31); /*!40000 ALTER TABLE `daymaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departmentexpensesmaster` -- DROP TABLE IF EXISTS `departmentexpensesmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `departmentexpensesmaster` ( `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '部署コード', `ExpensesPeriod` smallint(6) NOT NULL COMMENT '事業期', `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '経費コード', `NameString` varchar(100) NOT NULL COMMENT '名称', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `ExpensesRaito` decimal(4,2) NOT NULL COMMENT '経費率', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`DepartmentCode`,`ExpensesPeriod`,`NameCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='部署経費率マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departmentexpensesmaster` -- LOCK TABLES `departmentexpensesmaster` WRITE; /*!40000 ALTER TABLE `departmentexpensesmaster` DISABLE KEYS */; INSERT INTO `departmentexpensesmaster` VALUES (1,1,1,'会社経費',1,0.00,0,'2020-09-29 16:17:58','2020-09-29 16:17:58'),(1,1,2,'営業経費',2,0.00,0,'2020-09-29 16:17:58','2020-09-29 16:17:58'); /*!40000 ALTER TABLE `departmentexpensesmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `departmentmaster` -- DROP TABLE IF EXISTS `departmentmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `departmentmaster` ( `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '部署コード', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `DepartmentString` varchar(100) NOT NULL COMMENT '部署名', `ActionScheduleFlg` decimal(1,0) NOT NULL COMMENT '行動予定表示フラグ', `StaffAssignFlg` decimal(1,0) NOT NULL COMMENT '人員配置表示フラグ', `StartDate` datetime NOT NULL COMMENT '開始日付', `CompDate` datetime NOT NULL COMMENT '終了日付', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`DepartmentCode`), KEY `DepartmentMaster_index1` (`DisplayOrder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='部署マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `departmentmaster` -- LOCK TABLES `departmentmaster` WRITE; /*!40000 ALTER TABLE `departmentmaster` DISABLE KEYS */; INSERT INTO `departmentmaster` VALUES (1,1,'工事部',0,0,'2018-10-01 00:00:00','0001-01-01 00:00:00',0,'0000-00-00 00:00:00','2020-09-29 16:17:58'); /*!40000 ALTER TABLE `departmentmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `divisionmaster` -- DROP TABLE IF EXISTS `divisionmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `divisionmaster` ( `DivisionCode` decimal(5,0) unsigned NOT NULL COMMENT '区分コード', `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '名称コード', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `NameString` varchar(100) NOT NULL DEFAULT '' COMMENT '名称', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`DivisionCode`,`NameCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='区分マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `divisionmaster` -- LOCK TABLES `divisionmaster` WRITE; /*!40000 ALTER TABLE `divisionmaster` DISABLE KEYS */; INSERT INTO `divisionmaster` VALUES (1,1,1,'公共団体',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,2,2,'法人',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,3,3,'個人',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,4,4,'その他',0,'2017-04-19 07:36:44','2020-09-29 16:14:53'),(3,1,1,'会社経費',0,'2015-11-16 15:19:23','2018-11-14 11:01:03'),(3,2,2,'営業経費',0,'2015-11-16 15:19:23','2018-11-14 11:01:03'); /*!40000 ALTER TABLE `divisionmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `monthmaster` -- DROP TABLE IF EXISTS `monthmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `monthmaster` ( `month` smallint(6) NOT NULL COMMENT '月', PRIMARY KEY (`month`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='月マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `monthmaster` -- LOCK TABLES `monthmaster` WRITE; /*!40000 ALTER TABLE `monthmaster` DISABLE KEYS */; INSERT INTO `monthmaster` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12); /*!40000 ALTER TABLE `monthmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `persondepartmentmaster` -- DROP TABLE IF EXISTS `persondepartmentmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `persondepartmentmaster` ( `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '部署コード', `AffiliationFlg` decimal(1,0) NOT NULL COMMENT '所属フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`PersonCode`,`DepartmentCode`), KEY `PersonDepartmentMaster_Index1` (`PersonCode`), KEY `PersonDepartmentMaster_Index2` (`DepartmentCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='担当者対象部署マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `persondepartmentmaster` -- LOCK TABLES `persondepartmentmaster` WRITE; /*!40000 ALTER TABLE `persondepartmentmaster` DISABLE KEYS */; INSERT INTO `persondepartmentmaster` VALUES (20181001,1,1,'2020-09-29 16:26:56','2020-09-29 16:26:56'); /*!40000 ALTER TABLE `persondepartmentmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personinchargemaster` -- DROP TABLE IF EXISTS `personinchargemaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personinchargemaster` ( `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', `DisplayOrder` decimal(8,0) unsigned NOT NULL COMMENT '表示順', `PersonName` varchar(60) NOT NULL COMMENT '担当者名', `PersonNameKana` varchar(60) DEFAULT NULL COMMENT 'フリガナ', `Sex` decimal(1,0) DEFAULT '0' COMMENT '性別', `BloodType` varchar(6) DEFAULT NULL COMMENT '血液型', `Birthday` date NOT NULL COMMENT '生年月日', `ZipCode` varchar(8) DEFAULT NULL COMMENT '郵便番号', `Address1` varchar(60) DEFAULT NULL COMMENT '現住所1', `Address2` varchar(60) DEFAULT NULL COMMENT '現住所2', `Address3` varchar(60) DEFAULT NULL COMMENT '現住所3', `PhoneNumber` varchar(13) DEFAULT NULL COMMENT '連絡先電話番号', `EmgPhoneNumber` varchar(13) DEFAULT NULL COMMENT '緊急連絡先電話番号', `EmgContact` varchar(60) DEFAULT NULL COMMENT '緊急連絡先名', `StartDate` date NOT NULL COMMENT '入社年月日', `EndDate` date DEFAULT NULL COMMENT '退社年月日', `PassWord` varchar(16) DEFAULT NULL COMMENT 'パスワード', `SecurityManagement` decimal(1,0) NOT NULL COMMENT '機密区分', `SecCode` decimal(2,0) unsigned NOT NULL COMMENT '保護区分番号', `MsgBackColor` varchar(8) DEFAULT NULL COMMENT 'メッセージ背景色', `DisplayString` varchar(20) DEFAULT NULL COMMENT '役職名称', `DepartmentCode` decimal(5,0) unsigned DEFAULT NULL COMMENT '部署コード', `MonthlySalary` decimal(11,0) NOT NULL COMMENT '月給金額', `YearSalary` decimal(12,0) NOT NULL COMMENT '年俸金額', `Qualification` varchar(120) DEFAULT NULL COMMENT '資格入力欄', `SealPrintName` varchar(5) DEFAULT NULL COMMENT '印鑑表示名', `EmployeeClassFlg` decimal(1,0) NOT NULL COMMENT '社員区分', `LedgerFlg` decimal(1,0) NOT NULL COMMENT '台帳計算対象フラグ', `CommutingDistance` decimal(5,2) NOT NULL COMMENT '通勤距離', `CommuteCosts` decimal(5,0) NOT NULL COMMENT '通勤交通費', `PaidVacationDays` decimal(4,1) NOT NULL COMMENT '今年度有給休暇日数', `PaidVacationDaysPrev` decimal(4,1) NOT NULL COMMENT '前年度有給休暇日数', `WorkingCode` decimal(3,0) unsigned NOT NULL COMMENT '就業コード', `PaidDayOffFlg` decimal(1,0) unsigned NOT NULL COMMENT '有給取得フラグ', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`PersonCode`), KEY `PersonInChargeMaster_Index1` (`StartDate`), KEY `PersonInChargeMaster_Index2` (`DepartmentCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='担当者マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personinchargemaster` -- LOCK TABLES `personinchargemaster` WRITE; /*!40000 ALTER TABLE `personinchargemaster` DISABLE KEYS */; INSERT INTO `personinchargemaster` VALUES (20200101,1,'初期　','ショキ　',0,'A','9999-12-31','','','','','','','','2018-10-01','9999-12-31','20200101',4,1,'','代表',1,0,0,'','承認者',1,1,0.00,0,0.0,0.0,0,0,0,'2018-10-03 14:23:19','2020-09-29 16:26:56'); /*!40000 ALTER TABLE `personinchargemaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping data for table `personqualification` -- LOCK TABLES `personqualification` WRITE; /*!40000 ALTER TABLE `personqualification` DISABLE KEYS */; /*!40000 ALTER TABLE `personqualification` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `personsalarymaster` -- DROP TABLE IF EXISTS `personsalarymaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `personsalarymaster` ( `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '担当者コード', `StartDate` date NOT NULL COMMENT '使用開始年月日', `MonthlySalary` decimal(11,0) NOT NULL COMMENT '月給金額', `YearSalary` decimal(12,0) NOT NULL COMMENT '年俸金額', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`PersonCode`,`StartDate`), KEY `PersonSalaryMaster_Index1` (`PersonCode`), KEY `PersonSalaryMaster_Index2` (`StartDate`), KEY `PersonSalaryMaster_Index3` (`MonthlySalary`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='担当者給与マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `personsalarymaster` -- LOCK TABLES `personsalarymaster` WRITE; /*!40000 ALTER TABLE `personsalarymaster` DISABLE KEYS */; INSERT INTO `personsalarymaster` VALUES (20181001,'2020-01-01',0,0,'2020-09-29 16:26:56','2020-09-29 16:26:56'); /*!40000 ALTER TABLE `personsalarymaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `processexcutemaster` -- DROP TABLE IF EXISTS `processexcutemaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `processexcutemaster` ( `SecCode` decimal(2,0) unsigned NOT NULL COMMENT '保護区分番号', `ExecCode` decimal(4,0) unsigned NOT NULL COMMENT '起動処理番号', `EditFlg` decimal(1,0) NOT NULL COMMENT '編集フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`SecCode`,`ExecCode`), KEY `ProcessExcuteMaster_Index1` (`SecCode`), KEY `ProcessExcuteMaster_Index2` (`ExecCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='起動対象マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `processexcutemaster` -- LOCK TABLES `processexcutemaster` WRITE; /*!40000 ALTER TABLE `processexcutemaster` DISABLE KEYS */; INSERT INTO `processexcutemaster` VALUES (1,1,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,2,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,3,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,4,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,5,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,6,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,7,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,8,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,9,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,10,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,11,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,12,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,13,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,14,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,15,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,16,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,17,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,19,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,29,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,30,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,31,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,32,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,37,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,39,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,40,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,41,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,42,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,45,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,101,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,102,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,103,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,104,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,105,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,106,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,107,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,108,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,109,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,110,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,111,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,112,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,114,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,115,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,116,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,117,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,119,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,120,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,122,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,123,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,124,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,125,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,126,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,131,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,132,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,134,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,135,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(2,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(2,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(3,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(4,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(6,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(7,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,18,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(8,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(9,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,2,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,3,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,16,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,17,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,19,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,29,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,30,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,31,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,32,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,34,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,36,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,39,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,40,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,42,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(10,102,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,103,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,110,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,111,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,114,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,116,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,118,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,121,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,122,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,123,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,125,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,126,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(11,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(12,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'); /*!40000 ALTER TABLE `processexcutemaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `securitymaster` -- DROP TABLE IF EXISTS `securitymaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `securitymaster` ( `SecCode` decimal(4,0) unsigned NOT NULL COMMENT '保護区分番号', `DisplayOrder` decimal(4,0) NOT NULL COMMENT '表示順', `SecName` varchar(60) NOT NULL COMMENT '保護区分名称', `SecRank` decimal(1,0) NOT NULL COMMENT '保護区分ランク', `SecRange` decimal(1,0) NOT NULL COMMENT '保護区分範囲', `GeneralAffairs` decimal(1,0) NOT NULL COMMENT '総務業務フラグ', `SelectBackColor` varchar(8) NOT NULL COMMENT '選択背景色', `DeleteFlg` decimal(1,0) NOT NULL COMMENT '削除フラグ', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`SecCode`), KEY `SecurityMaster_Index1` (`DisplayOrder`), KEY `SecurityMaster_Index2` (`SecRank`), KEY `SecurityMaster_Index3` (`SecRange`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='保護区分マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `securitymaster` -- LOCK TABLES `securitymaster` WRITE; /*!40000 ALTER TABLE `securitymaster` DISABLE KEYS */; INSERT INTO `securitymaster` VALUES (1,1,'代表',1,1,1,'0x000000',0,'2020-09-29 16:25:38','2020-09-29 16:25:47'); /*!40000 ALTER TABLE `securitymaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `systemexecute` -- DROP TABLE IF EXISTS `systemexecute`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `systemexecute` ( `PrimaryCode` tinyint(4) NOT NULL COMMENT 'キー項目', `TargetDate` date NOT NULL COMMENT '起動日付', `SystemVersion` int(11) NOT NULL COMMENT '本体・環境バージョン', `UpDateCopyVersion` int(11) NOT NULL COMMENT 'コピーバージョン', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`PrimaryCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='システム起動確認データ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `systemexecute` -- LOCK TABLES `systemexecute` WRITE; /*!40000 ALTER TABLE `systemexecute` DISABLE KEYS */; INSERT INTO `systemexecute` VALUES (1,'2018-10-03',0,0,'2015-12-21 17:24:12','2018-10-03 13:27:49'),(2,'2017-02-27',1,1,'2017-02-27 15:04:23','2017-05-13 13:15:23'); /*!40000 ALTER TABLE `systemexecute` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `systemmaster` -- DROP TABLE IF EXISTS `systemmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `systemmaster` ( `SystemCode` decimal(3,0) unsigned NOT NULL COMMENT '会社コード', `CompanyName1` varchar(60) NOT NULL COMMENT '会社名１', `CompanyName2` varchar(60) DEFAULT NULL COMMENT '会社名２', `CEOName` varchar(60) NOT NULL COMMENT '代表者氏名', `CEOPositionName` varchar(60) DEFAULT NULL COMMENT '代表者役職名', `ZipCode` varchar(8) NOT NULL COMMENT '郵便番号', `Address1` varchar(60) NOT NULL COMMENT '住所１', `Address2` varchar(60) DEFAULT NULL COMMENT '住所2', `Address3` varchar(60) DEFAULT NULL COMMENT '住所3', `PhoneNumber` varchar(13) NOT NULL COMMENT '電話番号', `FaxNumber` varchar(13) DEFAULT NULL COMMENT 'FAX番号', `HomePageURL` varchar(120) DEFAULT NULL COMMENT 'ホームページURL', `ConsumptionTax` decimal(4,2) NOT NULL COMMENT '消費税', `CooperationRate` decimal(4,2) NOT NULL COMMENT '協力金比率', `StatutoryWelfareRate` decimal(4,2) NOT NULL COMMENT '法定福利費比率', `FuelPrice` decimal(5,2) NOT NULL COMMENT '燃料キロ単価', `AreaDistance` decimal(5,2) NOT NULL COMMENT '資材置場移動距離', `ExcelSavePath` varchar(120) DEFAULT NULL COMMENT 'Excel保存パス', `BusinessPeriod` smallint(6) NOT NULL COMMENT '現在営業期数', `ConstrYear` smallint(6) NOT NULL COMMENT '現在工事年度', `BusinessBeginDate` datetime NOT NULL COMMENT '営業期期首日', `ConstrBeginDate` datetime NOT NULL COMMENT '工事年度期首日', `BusinessCompDate` datetime NOT NULL COMMENT '営業期期末日', `ConstrCompDate` datetime NOT NULL COMMENT '工事年度期末日', `ConstructionNoBase` decimal(1,0) NOT NULL COMMENT '工事番号基準値', `SloganString1` varchar(100) DEFAULT NULL COMMENT '標語1', `SloganString2` varchar(100) DEFAULT NULL COMMENT '標語2', `SloganString3` varchar(100) DEFAULT NULL COMMENT '標語3', `OperationFlg` decimal(2,0) unsigned NOT NULL COMMENT '承認運用フラグ', `SystemOpenTime` datetime NOT NULL COMMENT '運用開始時間', `SystemCloseTime` datetime NOT NULL COMMENT '運用終了時間', `PesrsonCost1` decimal(7,0) unsigned NOT NULL COMMENT '固定人件費１（指導員コスト）', `PesrsonCost2` decimal(7,0) unsigned NOT NULL COMMENT '固定人件費２（副担当者コスト）', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`SystemCode`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='管理マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `systemmaster` -- LOCK TABLES `systemmaster` WRITE; /*!40000 ALTER TABLE `systemmaster` DISABLE KEYS */; INSERT INTO `systemmaster` VALUES (1,'株式会社　建築会社','','代表　太朗','代表取締役','650-0001','兵庫県','神戸市中央区','加納町','078-000-0000','078-000-0000','',10.00,0.50,8.00,0.00,0.00,'C:\\Temp\\エクセルデータ',1,2020,'2020-04-01 00:00:00','2020-04-01 00:00:00','2021-03-31 00:00:00','2021-03-31 00:00:00',-1,'','','',0,'0001-01-01 06:00:00','0001-01-01 22:00:00',100000,100000,'2015-09-05 00:00:00','2020-09-29 16:20:48'); /*!40000 ALTER TABLE `systemmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `unitmaster` -- DROP TABLE IF EXISTS `unitmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `unitmaster` ( `UnitKey` decimal(5,0) unsigned NOT NULL COMMENT '単位キー', `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '表示順', `UnitName` varchar(30) NOT NULL COMMENT '単位名称', `EntryDate` datetime NOT NULL COMMENT '登録日付', `UpdateDate` datetime NOT NULL COMMENT '更新日付', PRIMARY KEY (`UnitKey`), KEY `UnitMaster_Index1` (`DisplayOrder`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='単位マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `unitmaster` -- LOCK TABLES `unitmaster` WRITE; /*!40000 ALTER TABLE `unitmaster` DISABLE KEYS */; INSERT INTO `unitmaster` VALUES (1,2,'ｍ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(2,28,'ユニット','2015-08-31 00:00:00','2018-09-14 11:02:46'),(3,26,'パック','2015-08-31 00:00:00','2018-09-14 11:02:46'),(4,27,'口','2015-08-31 00:00:00','2018-09-14 11:02:46'),(5,21,'丁','2015-08-31 00:00:00','2018-09-14 11:02:46'),(6,29,'往復','2015-08-31 00:00:00','2018-09-14 11:02:46'),(7,30,'ｍｍ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(8,18,'束','2015-08-31 00:00:00','2018-09-14 11:02:46'),(9,31,'系統','2015-08-31 00:00:00','2018-09-14 11:02:46'),(10,7,'延ｍ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(11,32,'スパン','2015-08-31 00:00:00','2018-09-14 11:02:46'),(12,33,'継手','2015-08-31 00:00:00','2018-09-14 11:02:46'),(13,15,'ｋｇ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(14,1,'式','2015-08-31 00:00:00','2018-09-14 11:02:46'),(15,34,'連','2015-08-31 00:00:00','2018-09-14 11:02:46'),(16,16,'ｔ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(17,35,'窓','2015-08-31 00:00:00','2018-09-14 11:02:46'),(18,36,'ｍ・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(19,9,'床ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(20,37,'箱','2015-08-31 00:00:00','2018-09-14 11:02:46'),(21,38,'ｔ・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(22,3,'ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(23,14,'個','2015-08-31 00:00:00','2018-09-14 11:02:46'),(24,39,'ｍ２・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(25,40,'ｃｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(26,23,'巻','2015-08-31 00:00:00','2018-09-14 11:02:46'),(27,41,'スパン日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(28,8,'延ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(29,13,'組','2015-08-31 00:00:00','2018-09-14 11:02:46'),(30,42,'ｍスパ日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(31,10,'建ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(32,19,'本','2015-08-31 00:00:00','2018-09-14 11:02:46'),(33,43,'個・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(34,44,'水平ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(35,45,'基','2015-08-31 00:00:00','2018-09-14 11:02:46'),(36,46,'枚・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(37,47,'ｋＬ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(38,48,'缶','2015-08-31 00:00:00','2018-09-14 11:02:46'),(39,49,'本・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(40,50,'Ｌ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(41,20,'枚','2015-08-31 00:00:00','2018-09-14 11:02:46'),(42,51,'組・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(43,4,'ｍ３','2015-08-31 00:00:00','2018-09-14 11:02:46'),(44,52,'台','2015-08-31 00:00:00','2018-09-14 11:02:46'),(45,53,'台・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(46,5,'空ｍ３','2015-08-31 00:00:00','2018-09-14 11:02:46'),(47,54,'セット','2015-08-31 00:00:00','2018-09-14 11:02:46'),(48,55,'棟・日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(49,56,'柱','2015-08-31 00:00:00','2018-09-14 11:02:46'),(50,57,'キット','2015-08-31 00:00:00','2018-09-14 11:02:46'),(51,58,'セット日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(52,59,'日','2015-08-31 00:00:00','2018-09-14 11:02:46'),(53,22,'袋','2015-08-31 00:00:00','2018-09-14 11:02:46'),(54,60,'ｍ２・月','2015-08-31 00:00:00','2018-09-14 11:02:46'),(55,61,'月','2015-08-31 00:00:00','2018-09-14 11:02:46'),(56,62,'面','2015-08-31 00:00:00','2018-09-14 11:02:46'),(57,63,'台・月','2015-08-31 00:00:00','2018-09-14 11:02:46'),(58,64,'試料','2015-08-31 00:00:00','2018-09-14 11:02:46'),(59,6,'坪','2015-08-31 00:00:00','2018-09-14 11:02:46'),(60,65,'基・月','2015-08-31 00:00:00','2018-09-14 11:02:46'),(61,66,'孔','2015-08-31 00:00:00','2018-09-14 11:02:46'),(62,67,'個所','2015-08-31 00:00:00','2018-09-14 11:02:46'),(63,11,'壁ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(64,24,'回','2015-08-31 00:00:00','2018-09-14 11:02:46'),(65,68,'リング','2015-08-31 00:00:00','2018-09-14 11:02:46'),(66,12,'架ｍ２','2015-08-31 00:00:00','2018-09-14 11:02:46'),(67,69,'玉','2015-08-31 00:00:00','2018-09-14 11:02:46'),(68,70,'鉢','2015-08-31 00:00:00','2018-09-14 11:02:46'),(69,71,'ｍ２・回','2015-08-31 00:00:00','2018-09-14 11:02:46'),(70,72,'棟','2015-08-31 00:00:00','2018-09-14 11:02:46'),(71,73,'函','2015-08-31 00:00:00','2018-09-14 11:02:46'),(72,74,'百ｍｍ','2015-08-31 00:00:00','2018-09-14 11:02:46'),(73,75,'穴','2015-08-31 00:00:00','2018-09-14 11:02:46'),(74,25,'ケース','2015-08-31 00:00:00','2018-09-14 11:02:46'),(75,76,'ｍスパン','2015-08-31 00:00:00','2018-09-14 11:02:46'),(76,77,'双','2015-08-31 00:00:00','2018-09-14 11:02:46'),(77,78,'検体','2015-08-31 00:00:00','2018-09-14 11:02:46'),(78,79,'ポイント','2015-08-31 00:00:00','2018-09-14 11:02:46'),(79,80,'足','2015-08-31 00:00:00','2018-09-14 11:02:46'),(80,17,'ヶ所','2015-08-31 00:00:00','2018-09-14 11:02:46'),(81,81,'着','2015-08-31 00:00:00','2018-09-14 11:02:46'),(82,82,'業務','2015-08-31 00:00:00','2018-09-14 11:02:46'); /*!40000 ALTER TABLE `unitmaster` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `yearmaster` -- DROP TABLE IF EXISTS `yearmaster`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `yearmaster` ( `years` smallint(6) NOT NULL COMMENT '年', PRIMARY KEY (`years`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='年マスタ'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `yearmaster` -- LOCK TABLES `yearmaster` WRITE; /*!40000 ALTER TABLE `yearmaster` DISABLE KEYS */; INSERT INTO `yearmaster` VALUES (2010),(2011),(2012),(2013),(2014),(2015),(2016),(2017),(2018),(2019),(2020),(2021),(2022),(2023),(2024),(2025),(2026),(2027),(2028),(2029),(2030),(2031),(2032),(2033),(2034),(2035),(2036),(2037),(2038),(2039),(2040),(2041),(2042),(2043),(2044),(2045),(2046),(2047),(2048),(2049),(2050),(2051),(2052),(2053),(2054),(2055),(2056),(2057),(2058),(2059),(2060),(2061),(2062),(2063),(2064),(2065),(2066),(2067),(2068),(2069),(2070),(2071),(2072),(2073),(2074),(2075),(2076),(2077),(2078),(2079),(2080),(2081),(2082),(2083),(2084),(2085),(2086),(2087),(2088),(2089),(2090),(2091),(2092),(2093),(2094),(2095),(2096),(2097),(2098),(2099),(2100),(2101),(2102),(2103),(2104),(2105),(2106),(2107),(2108),(2109),(2110),(2111),(2112),(2113),(2114); /*!40000 ALTER TABLE `yearmaster` ENABLE KEYS */; UNLOCK TABLES;