工事管理システム製品化対応

--

-- 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 '?u???b?N???',

  `GroupCode` decimal(2,0) unsigned NOT NULL COMMENT '?O???[?v???',

  `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '?\???L?[',

  `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[',

  `ElementsName` varchar(100) NOT NULL COMMENT '?v?f????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`BlockCode`,`GroupCode`,`ComponentCode`,`ItemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?\?Z???W?v?R?[?h?}?X?^';

/*!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,'???????H????i????????j?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,2,0,'???H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,3,0,'???z?H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,4,0,'?d?C????H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,5,0,'?@?B????H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,6,0,'????????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,7,0,'???????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,18,0,'???????????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(2,1,18,0,'???????????@?????????D?H???p','2018-05-24 09:41:36','2018-05-24 09:41:36'),(3,2,7,0,'???????@?????????D?H???p','2018-09-29 10:12:43','2018-09-29 10:12:43'),(3,2,8,0,'???o??@?????????E???H???p','2018-09-29 10:12:43','2018-09-29 10:12:43'),(3,2,21,0,'???????@?????????E???H???p','2018-09-29 10:12:43','2018-09-29 10:12:43'),(4,3,6,0,'????????@?????????D?H???p','2018-05-24 09:42:01','2018-05-24 09:42:01'),(4,3,20,0,'????????@?????????E???H???p','2018-05-24 09:42:01','2018-05-24 09:42:01'),(5,4,1,0,'???????H????i????????j?????????D?H???p','2018-05-24 09:42:21','2018-05-24 09:42:21'),(5,4,1,10,'????????????@???????H??','2018-05-24 09:42:33','2018-05-24 09:42:33'),(6,5,2,0,'???H????@?????????D?H???p','2018-05-24 09:42:46','2018-05-24 09:42:46'),(6,6,3,0,'???z?H????@?????????D?H???p','2018-05-24 09:42:55','2018-05-24 09:42:55'),(6,7,4,0,'?d?C????H????@?????????D?H???p','2018-05-24 09:43:04','2018-05-24 09:43:04'),(6,8,5,0,'?@?B????H????@?????????D?H???p','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 '?@?l?i?R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `BusinessTypeName` varchar(100) NOT NULL DEFAULT '' COMMENT '???',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`BusinessTypeCode`),

  KEY `BusinessTypeMaster_Index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?@?l?i?}?X?^';

/*!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,'?L?????','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,'???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(7,7,'???@?l??c','2015-11-04 00:00:00','2015-11-04 00:00:00'),(8,8,'???@?l???c','2015-11-04 00:00:00','2015-11-04 00:00:00'),(9,9,'?????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(10,10,'???c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(11,11,'?????c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(12,12,'???v???c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(13,13,'??c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(14,14,'????c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(15,15,'???v??c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(16,16,'?@???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(17,17,'?w?Z?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(18,18,'??????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(19,19,'?X?????@?l','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,'?????c???????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(22,22,'????s???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(23,23,'?n??????s???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(24,24,'???m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(25,25,'?L????C????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(26,26,'??????C????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(27,27,'?s?????m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(28,28,'?i?@???m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(29,29,'????m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(30,30,'??????w?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(31,31,'??????w?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(32,32,'?_???g???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(33,33,'????g???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(34,34,'??????J???m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00');

/*!40000 ALTER TABLE `businesstypemaster` 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 '?\???L?[',

  `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[',

  `DisplayOrder` decimal(5,0) unsigned DEFAULT NULL COMMENT '?\????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`ComponentCode`,`ItemCode`),

  KEY `ComponentLinkMaster_Index1` (`ComponentCode`),

  KEY `ComponentLinkMaster_Index2` (`ItemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?\???H???A?}?X?^';

/*!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 '?\???L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `ComponentName` varchar(120) NOT NULL DEFAULT '' COMMENT '?\??????',

  `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O',

  `DirectInputFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O',

  `MyExpensesFlg` decimal(1,0) DEFAULT NULL COMMENT '????o??t???O',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`ComponentCode`),

  KEY `ComponentMaster_Index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?\???}?X?^';

/*!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,'???????H????i????????j?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(2,14,'???H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(3,15,'???z?H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(4,17,'?d?C????H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(5,16,'?@?B????H????@?????????D?H???p',1,0,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(6,19,'????????@?????????D?H???p',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(7,20,'???????@?????????D?H???p',0,1,1,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(8,9,'???o??@?????????E???H???p',0,1,0,0,'2015-09-02 00:00:00','2018-04-05 19:19:45'),(17,2,'?H????@?????????E???H???p',1,0,0,0,'2016-02-16 11:29:45','2018-04-05 19:19:45'),(18,18,'???????????@?????????D?H???p',0,1,0,0,'2016-03-08 16:41:32','2018-04-05 19:19:45'),(19,1,'????H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:03:35','2018-04-05 19:19:45'),(20,7,'????????@?????????E???H???p',0,1,1,0,'2016-03-08 17:23:00','2018-04-05 19:19:45'),(21,8,'???????@?????????E???H???p',0,1,1,0,'2016-03-08 17:24:06','2018-04-05 19:19:45'),(22,3,'?????H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:24:56','2018-04-05 19:19:45'),(23,4,'?d?C?H????@?????????E???H???p',1,0,0,0,'2016-03-08 17:25:37','2018-04-05 19:19:45'),(24,5,'?@?B????H????@?????????E???H???p',1,0,0,0,'2016-03-24 07:43:42','2018-04-05 19:19:45'),(25,6,'?d?C????H????@?????????E???H???p',1,0,0,0,'2016-03-24 07:44:15','2018-04-05 19:19:45'),(26,21,'??v??p',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,'???H????????V?z?p',1,0,0,1,'2018-01-31 08:14:46','2018-10-23 07:52:54'),(29,24,'?O???H????????V?z?p',1,0,0,1,'2018-01-31 08:15:48','2018-10-23 07:52:59'),(30,25,'?????H????????V?z?p',1,0,0,1,'2018-01-31 08:16:16','2018-10-23 07:53:03'),(31,26,'?????????H????????V?z?p',1,0,0,1,'2018-01-31 08:17:33','2018-10-23 07:53:06'),(32,27,'??r?H????????V?z?p',1,0,0,1,'2018-01-31 08:18:25','2018-10-23 07:53:09'),(33,28,'????p??????V?z',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 '?H??L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `ItemName` varchar(120) NOT NULL DEFAULT '' COMMENT '?H????',

  `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O',

  `MyExpensesFlg` decimal(1,0) NOT NULL COMMENT '????o??t???O',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`ItemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?H??}?X?^';

/*!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 (10,2,'????????????',1,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:10'),(11,1,'???????H???@???W???Z?????',0,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:09'),(20,4,'???????H????',1,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:09'),(22,13,'?y?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(23,14,'?n??H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(24,16,'?S??H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(25,17,'?R???N???[?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(26,18,'?^?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(27,19,'?S???H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(28,20,'?????H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(29,21,'?`?k?b?p?l???H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(30,22,'???o???`?Z?????g??H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(31,24,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(32,25,'??E?^?C???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(33,26,'??H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(35,29,'?????E????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(36,30,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(37,31,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(39,33,'???????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(40,34,'??????????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(41,35,'?V???b?^?[?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(42,36,'?K???X?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(43,38,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(44,39,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(45,41,'?y?S?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(46,42,'?????d???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(47,44,'???j?b?g?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(50,50,'??????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(51,43,'???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(86,48,'?A??H??',1,0,0,'2016-02-15 15:13:16','2018-10-03 13:53:09'),(112,23,'?????R???N???[?g?H??',1,0,0,'2016-04-21 08:26:28','2018-10-03 13:53:09'),(116,40,'?O???H??',1,0,0,'2016-09-21 16:58:22','2018-10-03 13:53:09'),(117,15,'??b?H??',1,0,0,'2016-10-12 15:22:56','2018-10-03 13:53:09'),(119,47,'???O?H??',1,0,0,'2016-10-27 13:10:39','2018-10-03 13:53:09'),(120,37,'????E?K???X?H??',1,0,0,'2016-10-27 13:13:18','2018-10-03 13:53:09'),(126,49,'?T?C???H??',1,0,0,'2017-01-14 10:20:06','2018-10-03 13:53:09');

/*!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 '?H?????R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `NameString` varchar(100) NOT NULL COMMENT '????',

  `PublicFlg` decimal(1,0) NOT NULL COMMENT '?????t???O',

  `RepairFlg` decimal(1,0) NOT NULL COMMENT '?V?z?E???C?t???O',

  `SecRank` decimal(1,0) NOT NULL COMMENT '?????????N',

  `ExpensesLink` decimal(1,0) NOT NULL COMMENT '?o??g?p??',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`TypeCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?H?????}?X?^';

/*!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,5,'????H???@???C?i?????j',2,0,4,0,0,'2015-11-16 15:19:01','2018-05-24 09:40:41'),(2,7,'????H???@???C?i?????j',2,0,4,0,0,'2015-11-16 15:19:01','2018-05-24 09:40:41'),(3,11,'??l?q???t?H?[???H???i?????j',2,0,4,0,0,'2015-11-16 15:19:01','2018-05-24 09:40:41'),(4,1,'?????H???@???C?i?????j',1,2,4,0,0,'2015-11-17 08:16:00','2018-05-24 09:40:41'),(5,3,'?????H???@???C?i?????j',1,2,4,0,0,'2015-11-17 08:16:00','2018-05-24 09:40:41'),(9,2,'?????H???@?V?z?i?????j',1,1,4,0,0,'2016-01-30 10:35:47','2018-05-24 09:40:41'),(10,4,'?????H???@?V?z?i?????j',1,1,4,0,0,'2016-01-30 10:42:20','2018-05-24 09:40:41'),(11,6,'????H???@?V?z?i?????j',2,0,4,0,0,'2016-01-30 10:43:14','2018-05-24 09:40:41'),(12,8,'????H???@?V?z?i?????j',2,0,4,0,0,'2016-01-30 10:43:47','2018-05-24 09:40:41');

/*!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='???}?X?^';

/*!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 '?????R?[?h',

  `ExpensesPeriod` smallint(6) NOT NULL COMMENT '?????',

  `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '?o??R?[?h',

  `NameString` varchar(100) NOT NULL COMMENT '????',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `ExpensesRaito` decimal(4,2) NOT NULL COMMENT '?o??',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`DepartmentCode`,`ExpensesPeriod`,`NameCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?????o???}?X?^';

/*!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 (0,15,1,'?c??o??',1,8.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,15,2,'?e?????o??',2,5.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,15,3,'???o??',3,7.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,1,'?c??o??',1,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,2,'?e?????o??',2,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,3,'???o??',3,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,1,'?c??o??',1,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,2,'?e?????o??',2,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,3,'???o??',3,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(1,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,15,3,'???o??',1,7.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,16,1,'?c??o??',2,2.00,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,16,2,'?e?????o??',3,7.00,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,16,3,'???o??',1,8.50,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,17,1,'?c??o??',2,2.00,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,17,2,'?e?????o??',3,6.50,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,17,3,'???o??',1,8.50,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,18,1,'?c??o??',3,1.50,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,18,2,'?e?????o??',2,7.50,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,18,3,'???o??',1,9.50,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,18,4,'?S???C??',4,0.00,0,'2018-11-14 11:02:45','2018-11-14 11:02:45'),(1,19,1,'?c??o??',3,1.50,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,19,2,'?e?????o??',2,7.50,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,19,3,'???o??',1,9.50,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,19,4,'?S???C??',4,0.20,0,'2019-09-02 08:10:06','2019-09-02 08:10:06'),(1,20,1,'?c??o??',3,1.50,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,20,2,'?e?????o??',2,6.80,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,20,3,'???o??',1,9.80,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,20,4,'?S???C??',4,0.20,0,'2019-10-03 08:49:06','2019-10-03 08:49:06'),(1,21,1,'?c??o??',3,1.50,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(1,21,2,'?e?????o??',2,6.80,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(1,21,3,'???o??',1,9.80,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(1,21,4,'?S???C??',4,0.20,0,'2019-10-03 08:49:07','2019-10-03 08:49:07'),(2,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,15,3,'???o??',1,7.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,16,1,'?c??o??',2,2.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,16,2,'?e?????o??',3,8.00,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,16,3,'???o??',1,8.50,0,'2016-04-27 17:06:52','2016-04-27 17:06:52'),(2,17,1,'?c??o??',2,2.00,0,'2017-11-24 15:05:17','2017-11-24 15:05:17'),(2,17,2,'?e?????o??',3,7.00,0,'2017-11-24 15:05:17','2017-11-24 15:05:17'),(2,17,3,'???o??',1,8.50,0,'2017-11-24 15:05:17','2017-11-24 15:05:17'),(2,18,1,'?c??o??',3,1.50,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,18,2,'?e?????o??',2,6.00,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,18,3,'???o??',1,9.50,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,18,4,'?S???C??',4,0.00,0,'2018-12-06 15:44:59','2018-12-06 15:44:59'),(2,19,1,'?c??o??',3,1.50,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,19,2,'?e?????o??',2,7.00,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,19,3,'???o??',1,9.50,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,19,4,'?S???C??',4,0.20,0,'2019-09-02 08:13:48','2019-09-02 08:13:48'),(2,20,1,'?c??o??',3,1.50,0,'2018-10-13 10:50:57','2018-10-13 10:50:57'),(2,20,2,'?e?????o??',2,5.70,0,'2018-10-13 10:50:57','2018-10-13 10:50:57'),(2,20,3,'???o??',1,9.80,0,'2018-10-13 10:50:57','2018-10-13 10:50:57'),(3,15,1,'?c??o??',2,8.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,15,2,'?e?????o??',3,5.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,15,3,'???o??',1,7.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,1,'?c??o??',2,2.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,2,'?e?????o??',3,9.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,3,'???o??',1,8.50,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,17,1,'?c??o??',2,2.00,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,17,2,'?e?????o??',3,7.50,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,17,3,'???o??',1,8.50,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,18,3,'???o??',1,9.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,19,1,'?c??o??',2,2.00,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(3,19,2,'?e?????o??',3,10.00,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(3,19,3,'???o??',1,8.50,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(4,15,1,'?c??o??',2,8.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,15,2,'?e?????o??',3,5.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,15,3,'???o??',1,7.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,16,1,'?c??o??',2,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,16,2,'?e?????o??',3,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,16,3,'???o??',1,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,17,1,'?c??o??',2,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,17,2,'?e?????o??',3,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(4,17,3,'???o??',1,0.00,0,'2016-04-26 14:35:35','2016-04-26 14:35:35'),(5,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,15,3,'???o??',1,7.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,16,1,'?c??o??',2,10.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,16,2,'?e?????o??',3,20.00,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,16,3,'???o??',1,20.50,0,'2016-04-27 17:11:45','2016-04-27 17:11:45'),(5,17,1,'?c??o??',2,10.00,0,'2017-05-09 09:47:21','2017-05-09 09:47:21'),(5,17,2,'?e?????o??',3,20.00,0,'2017-05-09 09:47:21','2017-05-09 09:47:21'),(5,17,3,'???o??',1,10.00,0,'2017-05-09 09:47:21','2017-05-09 09:47:21'),(5,18,1,'?c??o??',3,10.00,0,'2018-10-13 10:52:41','2018-10-13 10:52:41'),(5,18,2,'?e?????o??',2,20.00,0,'2018-10-13 10:52:41','2018-10-13 10:52:41'),(5,18,3,'???o??',1,10.00,0,'2018-10-13 10:52:41','2018-10-13 10:52:41'),(5,19,1,'?c??o??',3,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,19,2,'?e?????o??',2,20.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,19,3,'???o??',1,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,19,4,'?S???C??',4,0.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,1,'?c??o??',3,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,2,'?e?????o??',2,20.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,3,'???o??',1,10.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(5,20,4,'?S???C??',4,0.00,0,'2019-08-23 17:12:59','2019-08-23 17:12:59'),(7,15,1,'?c??o??',2,8.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,15,2,'?e?????o??',3,5.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,15,3,'???o??',1,7.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,16,1,'?c??o??',2,2.00,0,'2016-12-16 10:10:10','2016-12-16 10:10:10'),(7,16,2,'?e?????o??',3,7.00,0,'2016-12-16 10:10:10','2016-12-16 10:10:10'),(7,16,3,'???o??',1,8.50,0,'2016-12-16 10:10:10','2016-12-16 10:10:10'),(7,17,1,'?c??o??',2,2.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,17,2,'?e?????o??',3,7.00,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,17,3,'???o??',1,8.50,0,'2016-08-02 10:07:24','2016-08-02 10:07:24'),(7,18,1,'?c??o??',2,1.50,0,'2018-02-10 20:41:24','2018-02-10 20:41:24'),(7,18,2,'?e?????o??',3,7.50,0,'2018-02-10 20:41:24','2018-02-10 20:41:24'),(7,18,3,'???o??',1,9.50,0,'2018-02-10 20:41:24','2018-02-10 20:41:24'),(7,19,1,'?c??o??',3,1.50,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,19,2,'?e?????o??',2,8.00,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,19,3,'???o??',1,9.50,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,19,4,'?S???C??',4,0.02,0,'2018-12-06 15:50:31','2018-12-06 15:50:31'),(7,20,1,'?c??o??',3,1.50,0,'2018-10-13 10:52:04','2018-10-13 10:52:04'),(7,20,2,'?e?????o??',2,7.50,0,'2018-10-13 10:52:04','2018-10-13 10:52:04'),(7,20,3,'???o??',1,9.80,0,'2018-10-13 10:52:04','2018-10-13 10:52:04'),(8,15,1,'?c??o??',2,8.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,15,2,'?e?????o??',3,5.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,15,3,'???o??',1,7.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,16,1,'?c??o??',2,2.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,16,2,'?e?????o??',3,7.00,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,16,3,'???o??',1,8.50,1,'2016-09-27 18:46:03','2019-05-07 08:15:22'),(8,17,1,'?c??o??',2,2.00,1,'2017-05-09 09:50:16','2019-05-07 08:15:22'),(8,17,2,'?e?????o??',3,10.00,1,'2017-05-09 09:50:16','2019-05-07 08:15:22'),(8,17,3,'???o??',1,8.50,1,'2017-05-09 09:50:16','2019-05-07 08:15:22'),(8,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:39:49','2019-05-07 08:15:22'),(8,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:39:49','2019-05-07 08:15:22'),(8,18,3,'???o??',1,9.50,1,'2018-02-10 20:39:49','2019-05-07 08:15:22'),(8,19,1,'?c??o??',3,1.50,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,19,2,'?e?????o??',2,7.70,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,19,3,'???o??',1,9.50,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,19,4,'?S???C??',4,0.20,1,'2019-01-29 19:09:40','2019-05-07 08:15:22'),(8,20,1,'?c??o??',3,1.50,1,'2018-10-13 10:49:59','2019-05-07 08:15:22'),(8,20,2,'?e?????o??',2,6.80,1,'2018-10-13 10:49:59','2019-05-07 08:15:22'),(8,20,3,'???o??',1,9.80,1,'2018-10-13 10:49:59','2019-05-07 08:15:22'),(9,15,1,'?c??o??',2,8.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,15,2,'?e?????o??',3,5.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,15,3,'???o??',1,7.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,1,'?c??o??',2,2.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,2,'?e?????o??',3,8.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,3,'???o??',1,15.50,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,17,1,'?c??o??',2,1.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,17,2,'?e?????o??',3,7.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,17,3,'???o??',1,9.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,18,1,'?c??o??',2,2.00,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,18,2,'?e?????o??',3,9.00,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,18,3,'???o??',1,8.50,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,19,1,'?c??o??',2,2.00,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(9,19,2,'?e?????o??',3,10.00,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(9,19,3,'???o??',1,8.50,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(10,17,1,'?c??o??',2,0.00,1,'2018-03-29 17:28:32','2019-09-02 08:28:01'),(10,17,2,'?e?????o??',3,0.00,1,'2018-03-29 17:28:32','2019-09-02 08:28:01'),(10,17,3,'???o??',1,0.00,1,'2018-03-29 17:28:32','2019-09-02 08:28:01'),(10,18,1,'?c??o??',3,1.50,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,18,2,'?e?????o??',2,7.50,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,18,3,'???o??',1,9.50,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,18,4,'?S???C??',4,0.00,1,'2018-11-14 11:02:13','2019-09-02 08:28:01'),(10,19,1,'?c??o??',3,1.50,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,19,2,'?e?????o??',2,7.90,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,19,3,'???o??',1,9.50,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,19,4,'?S???C??',4,0.20,1,'2019-08-23 17:12:51','2019-09-02 08:28:01'),(10,20,1,'?c??o??',3,1.50,1,'2018-10-13 10:51:36','2019-09-02 08:28:01'),(10,20,2,'?e?????o??',2,9.20,1,'2018-10-13 10:51:36','2019-09-02 08:28:01'),(10,20,3,'???o??',1,9.80,1,'2018-10-13 10:51:36','2019-09-02 08:28:01'),(11,18,1,'?c??o??',3,1.50,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,18,2,'?e?????o??',2,18.50,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,18,3,'???o??',1,5.00,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,18,4,'?S???C??',4,0.02,1,'2018-12-06 15:46:16','2019-09-02 08:28:34'),(11,19,1,'?c??o??',3,1.50,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,19,2,'?e?????o??',2,16.30,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,19,3,'???o??',1,0.00,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,19,4,'?S???C??',4,0.00,1,'2019-08-23 17:12:11','2019-09-02 08:28:34'),(11,20,1,'?c??o??',3,1.50,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(11,20,2,'?e?????o??',2,16.30,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(11,20,3,'???o??',1,0.00,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(11,20,4,'?S???C??',4,0.00,1,'2019-01-29 19:11:10','2019-09-02 08:28:34'),(12,18,1,'?c??o??',3,1.50,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,18,2,'?e?????o??',2,18.50,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,18,3,'???o??',1,5.00,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,18,4,'?S???C??',4,0.02,0,'2019-01-25 17:54:39','2019-01-25 17:54:39'),(12,19,1,'?c??o??',3,1.50,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,19,2,'?e?????o??',2,19.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,19,3,'???o??',1,5.00,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,19,4,'?S???C??',4,0.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,1,'?c??o??',3,1.50,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,2,'?e?????o??',2,19.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,3,'???o??',1,5.00,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(12,20,4,'?S???C??',4,0.20,0,'2019-01-29 19:11:33','2019-01-29 19:11:33'),(13,19,1,'?c??o??',3,1.50,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,19,2,'?e?????o??',2,7.50,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,19,3,'???o??',1,9.50,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,19,4,'?S???C??',4,0.20,0,'2019-08-24 09:23:34','2019-08-24 09:23:34'),(13,20,1,'?c??o??',3,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(13,20,2,'?e?????o??',2,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(13,20,3,'???o??',1,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(13,20,4,'?S???C??',4,0.00,0,'2019-08-23 17:10:42','2019-08-23 17:10:42'),(14,19,1,'?c??o??',3,1.50,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,19,2,'?e?????o??',2,7.50,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,19,3,'???o??',1,9.50,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,19,4,'?S???C??',4,0.20,0,'2019-08-24 09:24:01','2019-08-24 09:24:01'),(14,20,1,'?c??o??',3,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,20,2,'?e?????o??',2,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,20,3,'???o??',1,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,20,4,'?S???C??',4,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,1,'?c??o??',3,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,2,'?e?????o??',2,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,3,'???o??',1,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52'),(14,21,4,'?S???C??',4,0.00,0,'2019-08-23 17:11:52','2019-08-23 17:11:52');

/*!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 '?????R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `DepartmentString` varchar(100) NOT NULL COMMENT '??????',

  `ActionScheduleFlg` decimal(1,0) NOT NULL COMMENT '?s???\??\???t???O',

  `StaffAssignFlg` decimal(1,0) NOT NULL COMMENT '?l???z?u?\???t???O',

  `StartDate` datetime NOT NULL COMMENT '?J?n???t',

  `CompDate` datetime NOT NULL COMMENT '?I?????t',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`DepartmentCode`),

  KEY `DepartmentMaster_index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????}?X?^';

/*!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,'?H????',0,0,'2018-10-01 00:00:00','0001-01-01 00:00:00',0,'0000-00-00 00:00:00','0000-00-00 00:00:00');

/*!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 '???R?[?h',

  `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '????R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `NameString` varchar(100) NOT NULL DEFAULT '' COMMENT '????',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`DivisionCode`,`NameCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='???}?X?^';

/*!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,'?@?l?i??????j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,2,2,'?@?l?i??????j',0,'2015-11-09 14:25:45','2018-10-03 14:18:22'),(1,3,3,'?@?l?i?a?@?E?????{????j',0,'2018-02-24 19:31:29','2018-10-03 14:18:22'),(1,4,4,'?@?l?i?w?Z?@?l?j',0,'2015-11-09 14:31:08','2018-10-03 14:18:22'),(1,5,5,'?????c??i?e????j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,6,6,'???z?m???????E??????m???????',0,'2015-11-13 13:47:24','2018-10-03 14:18:22'),(1,7,7,'??l?i???j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,8,8,'????g???E??????',0,'2017-04-19 07:36:33','2018-10-03 14:18:22'),(1,9,9,'?X???',0,'2018-02-24 19:25:37','2018-10-03 14:18:22'),(1,10,10,'?????',0,'2017-04-19 07:36:44','2018-10-03 14:18:22'),(3,3,1,'???o??',0,'2015-11-16 15:19:23','2018-04-27 08:33:01');

/*!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=utf8 COMMENT='???}?X?^';

/*!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 `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 '?S????R?[?h',

  `DisplayOrder` decimal(8,0) unsigned NOT NULL COMMENT '?\????',

  `PersonName` varchar(60) NOT NULL COMMENT '?S?????',

  `PersonNameKana` varchar(60) DEFAULT NULL COMMENT '?t???K?i',

  `Sex` decimal(1,0) DEFAULT '0' COMMENT '????',

  `BloodType` varchar(6) DEFAULT NULL COMMENT '???t?^',

  `Birthday` date NOT NULL COMMENT '???N????',

  `ZipCode` varchar(8) DEFAULT NULL COMMENT '?X????',

  `Address1` varchar(60) DEFAULT NULL COMMENT '???Z??1',

  `Address2` varchar(60) DEFAULT NULL COMMENT '???Z??2',

  `Address3` varchar(60) DEFAULT NULL COMMENT '???Z??3',

  `PhoneNumber` varchar(13) DEFAULT NULL COMMENT '?A????d?b???',

  `EmgPhoneNumber` varchar(13) DEFAULT NULL COMMENT '??}?A????d?b???',

  `EmgContact` varchar(60) DEFAULT NULL COMMENT '??}?A????',

  `StartDate` date NOT NULL COMMENT '????N????',

  `EndDate` date DEFAULT NULL COMMENT '???N????',

  `PassWord` varchar(16) DEFAULT NULL COMMENT '?p?X???[?h',

  `SecurityManagement` decimal(1,0) NOT NULL COMMENT '?@????',

  `SecCode` decimal(2,0) unsigned NOT NULL COMMENT '???????',

  `MsgBackColor` varchar(8) DEFAULT NULL COMMENT '???b?Z?[?W?w?i?F',

  `DisplayString` varchar(20) DEFAULT NULL COMMENT '??E????',

  `DepartmentCode` decimal(5,0) unsigned DEFAULT NULL COMMENT '?????R?[?h',

  `MonthlySalary` decimal(11,0) NOT NULL COMMENT '???????z',

  `YearSalary` decimal(12,0) NOT NULL COMMENT '?N????z',

  `Qualification` varchar(120) DEFAULT NULL COMMENT '???i?????',

  `SealPrintName` varchar(5) DEFAULT NULL COMMENT '???\????',

  `EmployeeClassFlg` decimal(1,0) NOT NULL COMMENT '?????',

  `LedgerFlg` decimal(1,0) NOT NULL COMMENT '???v?Z???t???O',

  `CommutingDistance` decimal(5,2) NOT NULL COMMENT '??????',

  `CommuteCosts` decimal(5,0) NOT NULL COMMENT '??????',

  `PaidVacationDays` decimal(4,1) NOT NULL COMMENT '???N?x?L???x?????',

  `PaidVacationDaysPrev` decimal(4,1) NOT NULL COMMENT '?O?N?x?L???x?????',

  `WorkingCode` decimal(3,0) unsigned NOT NULL COMMENT '?A??R?[?h',

  `PaidDayOffFlg` decimal(1,0) unsigned NOT NULL COMMENT '?L?????t???O',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`PersonCode`),

  KEY `PersonInChargeMaster_Index1` (`StartDate`),

  KEY `PersonInChargeMaster_Index2` (`DepartmentCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?S????}?X?^';

/*!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 (20181001,1,'?H???????','?R?E?W?J?????V??',0,'A','9999-12-31','','','','','','','','2018-10-01','9999-12-31','20181001',4,1,'','',1,0,0,'','???F??',1,1,0.00,0.0,0.0,0,0,0,0,'2018-10-03 14:23:19','2018-10-03 14:23:19');

/*!40000 ALTER TABLE `personinchargemaster` 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 '?N?????????',

  `EditFlg` decimal(1,0) NOT NULL COMMENT '??W?t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`SecCode`,`ExecCode`),

  KEY `ProcessExcuteMaster_Index1` (`SecCode`),

  KEY `ProcessExcuteMaster_Index2` (`ExecCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?N?????}?X?^';

/*!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,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,7,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,11,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,37,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,45,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,101,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,102,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,111,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,112,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,115,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,117,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,118,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,120,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,124,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,126,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,129,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,131,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,132,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(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 `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 '?L?[????',

  `TargetDate` date NOT NULL COMMENT '?N?????t',

  `SystemVersion` int(11) NOT NULL COMMENT '?{??E????o?[?W????',

  `UpDateCopyVersion` int(11) NOT NULL COMMENT '?R?s?[?o?[?W????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`PrimaryCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?V?X?e???N???m?F?f?[?^';

/*!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',228,2,'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 '???R?[?h',

  `CompanyName1` varchar(60) NOT NULL COMMENT '?????P',

  `CompanyName2` varchar(60) DEFAULT NULL COMMENT '?????Q',

  `CEOName` varchar(60) NOT NULL COMMENT '??\?????',

  `CEOPositionName` varchar(60) DEFAULT NULL COMMENT '??\???E??',

  `ZipCode` varchar(8) NOT NULL COMMENT '?X????',

  `Address1` varchar(60) NOT NULL COMMENT '?Z???P',

  `Address2` varchar(60) DEFAULT NULL COMMENT '?Z??2',

  `Address3` varchar(60) DEFAULT NULL COMMENT '?Z??3',

  `PhoneNumber` varchar(13) NOT NULL COMMENT '?d?b???',

  `FaxNumber` varchar(13) DEFAULT NULL COMMENT 'FAX???',

  `HomePageURL` varchar(120) DEFAULT NULL COMMENT '?z?[???y?[?WURL',

  `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 '?R???L???P??',

  `AreaDistance` decimal(5,2) NOT NULL COMMENT '????u????????',

  `ExcelSavePath` varchar(120) DEFAULT NULL COMMENT 'Excel????p?X',

  `BusinessPeriod` smallint(6) NOT NULL COMMENT '????c?????',

  `ConstrYear` smallint(6) NOT NULL COMMENT '????H???N?x',

  `BusinessBeginDate` datetime NOT NULL COMMENT '?c????????',

  `ConstrBeginDate` datetime NOT NULL COMMENT '?H???N?x?????',

  `BusinessCompDate` datetime NOT NULL COMMENT '?c?????????',

  `ConstrCompDate` datetime NOT NULL COMMENT '?H???N?x??????',

  `ConstructionNoBase` decimal(1,0) NOT NULL COMMENT '?H????????l',

  `SloganString1` varchar(100) DEFAULT NULL COMMENT '?W??1',

  `SloganString2` varchar(100) DEFAULT NULL COMMENT '?W??2',

  `SloganString3` varchar(100) DEFAULT NULL COMMENT '?W??3',

  `OperationFlg` decimal(2,0) unsigned NOT NULL COMMENT '???F?^?p?t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`SystemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='????}?X?^';

/*!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,'???????@???z???','','??\?@???N','??\?????','650-0001','?????','?_??s??????','???[??','078-000-0000','078-000-0001','',10.00,0.50,8.00,20.00,3.00,'C:\\Temp\\?G?N?Z???f?[?^',0,0,'2010-01-01 00:00:00','2010-01-01 00:00:00','9999-12-31 00:00:00','9999-12-31 00:00:00',-1,'','','',0,'2015-09-05 00:00:00','2018-09-28 15:25:49');

/*!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 '?P??L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `UnitName` varchar(30) NOT NULL COMMENT '?P?????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`UnitKey`),

  KEY `UnitMaster_Index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?P??}?X?^';

/*!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,'???j?b?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(3,26,'?p?b?N','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,'?n??','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,'?X?p??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(12,33,'?p??','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,'?A','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,'???E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(19,9,'?????Q','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,'???E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(22,3,'???Q','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,'???Q?E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(25,40,'?????Q','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,'?X?p????','2015-08-31 00:00:00','2018-09-14 11:02:46'),(28,8,'?????Q','2015-08-31 00:00:00','2018-09-14 11:02:46'),(29,13,'?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(30,42,'???X?p??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(31,10,'?????Q','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,'??E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(34,44,'???????Q','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,'???E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(37,47,'???k','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,'?{?E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(40,50,'?k','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,'?g?E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(43,4,'???R','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,'??E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(46,5,'??R','2015-08-31 00:00:00','2018-09-14 11:02:46'),(47,54,'?Z?b?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(48,55,'???E??','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,'?L?b?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(51,58,'?Z?b?g??','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,'???Q?E??','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,'??E??','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,'??E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(61,66,'?E','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,'????Q','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,'?????O','2015-08-31 00:00:00','2018-09-14 11:02:46'),(66,12,'????Q','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,'???Q?E??','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,'?S????','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,'?P?[?X','2015-08-31 00:00:00','2018-09-14 11:02:46'),(75,76,'???X?p??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(76,77,'?o','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,'?|?C???g','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 '?N',

  PRIMARY KEY (`years`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?N?}?X?^';

/*!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;

--

-- 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 '?u???b?N???',

  `GroupCode` decimal(2,0) unsigned NOT NULL COMMENT '?O???[?v???',

  `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '?\???L?[',

  `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[',

  `ElementsName` varchar(100) NOT NULL COMMENT '?v?f????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`BlockCode`,`GroupCode`,`ComponentCode`,`ItemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?\?Z???W?v?R?[?h?}?X?^';

/*!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,'???????H????i????????j?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,2,0,'???H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,3,0,'???z?H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,4,0,'?d?C????H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,5,0,'?@?B????H????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,6,0,'????????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,7,0,'???????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(1,0,18,0,'???????????@?????????D?H???p','2018-05-24 09:41:24','2018-05-24 09:41:24'),(2,1,18,0,'???????????@?????????D?H???p','2018-05-24 09:41:36','2018-05-24 09:41:36'),(3,2,7,0,'???????@?????????D?H???p','2018-05-24 09:41:50','2018-05-24 09:41:50'),(3,2,21,0,'???????@?????????E???H???p','2018-05-24 09:41:50','2018-05-24 09:41:50'),(4,3,6,0,'????????@?????????D?H???p','2018-05-24 09:42:01','2018-05-24 09:42:01'),(4,3,20,0,'????????@?????????E???H???p','2018-05-24 09:42:01','2018-05-24 09:42:01'),(5,4,1,0,'???????H????i????????j?????????D?H???p','2018-05-24 09:42:21','2018-05-24 09:42:21'),(5,4,1,10,'????????????@???????H??','2018-05-24 09:42:33','2018-05-24 09:42:33'),(6,5,2,0,'???H????@?????????D?H???p','2018-05-24 09:42:46','2018-05-24 09:42:46'),(6,6,3,0,'???z?H????@?????????D?H???p','2018-05-24 09:42:55','2018-05-24 09:42:55'),(6,7,4,0,'?d?C????H????@?????????D?H???p','2018-05-24 09:43:04','2018-05-24 09:43:04'),(6,8,5,0,'?@?B????H????@?????????D?H???p','2018-05-24 09:43:12','2018-05-24 09:43:12');

/*!40000 ALTER TABLE `budgetsumcode` ENABLE KEYS */;

UNLOCK TABLES;

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 '?@?l?i?R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `BusinessTypeName` varchar(100) NOT NULL DEFAULT '' COMMENT '???',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`BusinessTypeCode`),

  KEY `BusinessTypeMaster_Index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?@?l?i?}?X?^';

/*!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,'?L?????','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,'???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(7,7,'???@?l??c','2015-11-04 00:00:00','2015-11-04 00:00:00'),(8,8,'???@?l???c','2015-11-04 00:00:00','2015-11-04 00:00:00'),(9,9,'?????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(10,10,'???c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(11,11,'?????c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(12,12,'???v???c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(13,13,'??c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(14,14,'????c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(15,15,'???v??c?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(16,16,'?@???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(17,17,'?w?Z?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(18,18,'??????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(19,19,'?X?????@?l','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,'?????c???????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(22,22,'????s???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(23,23,'?n??????s???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(24,24,'???m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(25,25,'?L????C????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(26,26,'??????C????@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(27,27,'?s?????m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(28,28,'?i?@???m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(29,29,'????m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(30,30,'??????w?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(31,31,'??????w?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(32,32,'?_???g???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(33,33,'????g???@?l','2015-11-04 00:00:00','2015-11-04 00:00:00'),(34,34,'??????J???m?@?l','2015-11-04 00:00:00','2015-11-04 00:00:00');

/*!40000 ALTER TABLE `businesstypemaster` 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 '?\???L?[',

  `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[',

  `DisplayOrder` decimal(5,0) unsigned DEFAULT NULL COMMENT '?\????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`ComponentCode`,`ItemCode`),

  KEY `ComponentLinkMaster_Index1` (`ComponentCode`),

  KEY `ComponentLinkMaster_Index2` (`ItemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?\???H???A?}?X?^';

/*!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'),(3,20,2,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,22,1,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,23,3,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,24,4,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,25,5,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,26,6,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,27,7,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,28,8,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,29,9,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,30,10,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,31,11,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,32,12,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,33,13,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,34,14,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,35,15,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,36,16,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,37,17,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,38,18,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,39,19,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,40,20,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,41,21,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,42,22,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,43,23,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,44,24,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,45,25,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,46,26,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,47,28,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,48,29,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,49,30,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,50,31,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(3,51,27,'2018-10-03 13:39:07','2018-10-03 13:39:07'),(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');

/*!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 '?\???L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `ComponentName` varchar(120) NOT NULL DEFAULT '' COMMENT '?\??????',

  `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O',

  `DirectInputFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O',

  `MyExpensesFlg` decimal(1,0) DEFAULT NULL COMMENT '????o??t???O',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`ComponentCode`),

  KEY `ComponentMaster_Index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?\???}?X?^';

/*!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,1,'???????H????i????????j',1,0,0,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(2,2,'???H????',1,0,0,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(3,3,'???z?H????',1,0,0,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(4,5,'?d?C????H????',1,0,0,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(5,4,'?@?B????H????',1,0,0,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(6,7,'????????',0,1,1,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(7,8,'???????',0,1,1,0,'2015-09-02 00:00:00','2018-10-03 13:49:54'),(18,6,'???????????',0,1,0,0,'2016-03-08 16:41:32','2018-10-03 13:49:54');

/*!40000 ALTER TABLE `componentmaster` ENABLE KEYS */;

UNLOCK TABLES;

--

-- Table structure for table `componenttotypemaster`

--

DROP TABLE IF EXISTS `componenttotypemaster`;

/*!40101 SET @saved_cs_client     = @@character_set_client */;

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `componenttotypemaster` (

  `TypeCode` decimal(5,0) unsigned NOT NULL COMMENT '?H?????R?[?h',

  `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '?\???L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`TypeCode`,`ComponentCode`),

  KEY `ComponentToTypeMaster_Index1` (`TypeCode`),

  KEY `ComponentToTypeMaster_Index2` (`ComponentCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?H?????E?\???????N?}?X?^';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- Dumping data for table `componenttotypemaster`

--

LOCK TABLES `componenttotypemaster` WRITE;

/*!40000 ALTER TABLE `componenttotypemaster` DISABLE KEYS */;

INSERT INTO `componenttotypemaster` VALUES (1,1,1,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,2,2,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,3,3,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,4,5,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,5,4,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,6,7,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,7,8,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(1,18,6,'2018-10-03 14:00:55','2018-10-03 14:00:55'),(2,1,1,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,2,2,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,3,3,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,4,5,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,5,4,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,6,7,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,7,8,'2018-10-03 14:00:26','2018-10-03 14:00:26'),(2,18,6,'2018-10-03 14:00:26','2018-10-03 14:00:26');

/*!40000 ALTER TABLE `componenttotypemaster` 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 '?H??L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `ItemName` varchar(120) NOT NULL DEFAULT '' COMMENT '?H????',

  `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O',

  `MyExpensesFlg` decimal(1,0) NOT NULL COMMENT '????o??t???O',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`ItemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?H??}?X?^';

/*!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 (10,2,'????????????',1,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:10'),(11,1,'???????H???@???W???Z?????',0,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:09'),(20,4,'???????H????',1,0,0,'2016-02-15 15:13:10','2018-10-03 13:53:09'),(22,13,'?y?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(23,14,'?n??H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(24,16,'?S??H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(25,17,'?R???N???[?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(26,18,'?^?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(27,19,'?S???H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(28,20,'?????H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(29,21,'?`?k?b?p?l???H??',1,0,0,'2016-02-15 15:13:11','2018-10-03 13:53:09'),(30,22,'???o???`?Z?????g??H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(31,24,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(32,25,'??E?^?C???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(33,26,'??H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(35,29,'?????E????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(36,30,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(37,31,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(39,33,'???????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(40,34,'??????????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(41,35,'?V???b?^?[?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(42,36,'?K???X?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(43,38,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(44,39,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(45,41,'?y?S?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(46,42,'?????d???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(47,44,'???j?b?g?H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(50,50,'??????H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(51,43,'???H??',1,0,0,'2016-02-15 15:13:12','2018-10-03 13:53:09'),(86,48,'?A??H??',1,0,0,'2016-02-15 15:13:16','2018-10-03 13:53:09'),(112,23,'?????R???N???[?g?H??',1,0,0,'2016-04-21 08:26:28','2018-10-03 13:53:09'),(116,40,'?O???H??',1,0,0,'2016-09-21 16:58:22','2018-10-03 13:53:09'),(117,15,'??b?H??',1,0,0,'2016-10-12 15:22:56','2018-10-03 13:53:09'),(119,47,'???O?H??',1,0,0,'2016-10-27 13:10:39','2018-10-03 13:53:09'),(120,37,'????E?K???X?H??',1,0,0,'2016-10-27 13:13:18','2018-10-03 13:53:09'),(126,49,'?T?C???H??',1,0,0,'2017-01-14 10:20:06','2018-10-03 13:53:09');

/*!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 '?H?????R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `NameString` varchar(100) NOT NULL COMMENT '????',

  `PublicFlg` decimal(1,0) NOT NULL COMMENT '?????t???O',

  `RepairFlg` decimal(1,0) NOT NULL COMMENT '?V?z?E???C?t???O',

  `SecRank` decimal(1,0) NOT NULL COMMENT '?????????N',

  `ExpensesLink` decimal(1,0) NOT NULL COMMENT '?o??g?p??',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`TypeCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?H?????}?X?^';

/*!40101 SET character_set_client = @saved_cs_client */;

--

-- 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=utf8 COMMENT='???}?X?^';

/*!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;

--

-- Dumping data for table `constructiontypemaster`

--

LOCK TABLES `constructiontypemaster` WRITE;

/*!40000 ALTER TABLE `constructiontypemaster` DISABLE KEYS */;

INSERT INTO `constructiontypemaster` VALUES (1,1,'????H??',2,0,4,0,0,'2015-11-16 15:19:01','2018-10-03 14:07:00'),(2,2,'?????H??',1,0,4,0,0,'2015-11-17 08:18:18','2018-10-03 14:07:00'),(3,3,'???C?E?C?U?H??',2,1,4,0,0,'2016-01-30 10:35:47','2018-10-03 14:07:00'),(4,4,'???t?H?[???H??',0,0,4,0,0,'2016-01-30 10:43:14','2018-10-03 14:07:00');

/*!40000 ALTER TABLE `constructiontypemaster` ENABLE KEYS */;

UNLOCK TABLES;

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 '?????R?[?h',

  `ExpensesPeriod` smallint(6) NOT NULL COMMENT '?????',

  `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '?o??R?[?h',

  `NameString` varchar(100) NOT NULL COMMENT '????',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `ExpensesRaito` decimal(4,2) NOT NULL COMMENT '?o??',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`DepartmentCode`,`ExpensesPeriod`,`NameCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????o???}?X?^';

/*!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 (0,15,1,'?c??o??',1,8.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,15,2,'?e?????o??',2,5.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,15,3,'???o??',3,7.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,1,'?c??o??',1,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,2,'?e?????o??',2,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,16,3,'???o??',3,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,1,'?c??o??',1,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,2,'?e?????o??',2,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(0,17,3,'???o??',3,0.00,0,'2015-12-04 21:57:39','2015-12-04 21:57:39'),(1,15,1,'?c??o??',2,8.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,15,2,'?e?????o??',3,5.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,15,3,'???o??',1,7.00,0,'2016-04-27 17:09:02','2016-04-27 17:09:02'),(1,16,1,'?c??o??',2,2.00,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,16,2,'?e?????o??',3,7.00,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,16,3,'???o??',1,8.50,0,'2016-12-16 10:09:55','2016-12-16 10:09:55'),(1,17,1,'?c??o??',2,2.00,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,17,2,'?e?????o??',3,6.50,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,17,3,'???o??',1,8.50,0,'2017-05-09 09:33:45','2017-05-09 09:33:45'),(1,18,3,'???o??',1,7.00,0,'2018-10-03 14:16:56','2018-10-03 14:16:56'),(1,19,1,'?c??o??',2,2.00,0,'2017-11-24 15:04:26','2017-11-24 15:04:26'),(1,19,2,'?e?????o??',3,6.00,0,'2017-11-24 15:04:26','2017-11-24 15:04:26'),(1,19,3,'???o??',1,8.50,0,'2017-11-24 15:04:26','2017-11-24 15:04:26'),(2,15,1,'?c??o??',2,8.00,1,'2016-04-27 17:06:52','2018-10-03 14:23:19'),(2,15,2,'?e?????o??',3,5.00,1,'2016-04-27 17:06:52','2018-10-03 14:23:19'),(2,15,3,'???o??',1,7.00,1,'2016-04-27 17:06:52','2018-10-03 14:23:19'),(2,16,1,'?c??o??',2,2.00,1,'2016-04-27 17:06:52','2018-10-03 14:23:19'),(2,16,2,'?e?????o??',3,8.00,1,'2016-04-27 17:06:52','2018-10-03 14:23:19'),(2,16,3,'???o??',1,8.50,1,'2016-04-27 17:06:52','2018-10-03 14:23:19'),(2,17,1,'?c??o??',2,2.00,1,'2017-11-24 15:05:17','2018-10-03 14:23:19'),(2,17,2,'?e?????o??',3,7.00,1,'2017-11-24 15:05:17','2018-10-03 14:23:19'),(2,17,3,'???o??',1,8.50,1,'2017-11-24 15:05:17','2018-10-03 14:23:19'),(2,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:40:34','2018-10-03 14:23:19'),(2,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:40:34','2018-10-03 14:23:19'),(2,18,3,'???o??',1,9.50,1,'2018-02-10 20:40:34','2018-10-03 14:23:19'),(2,19,1,'?c??o??',2,2.00,1,'2017-11-24 14:59:38','2018-10-03 14:23:19'),(2,19,2,'?e?????o??',3,7.00,1,'2017-11-24 14:59:38','2018-10-03 14:23:19'),(2,19,3,'???o??',1,8.50,1,'2017-11-24 14:59:38','2018-10-03 14:23:19'),(3,15,1,'?c??o??',2,8.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,15,2,'?e?????o??',3,5.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,15,3,'???o??',1,7.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,1,'?c??o??',2,2.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,2,'?e?????o??',3,9.00,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,16,3,'???o??',1,8.50,1,'2016-06-04 16:50:08','2016-06-04 16:50:08'),(3,17,1,'?c??o??',2,2.00,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,17,2,'?e?????o??',3,7.50,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,17,3,'???o??',1,8.50,1,'2017-11-01 16:14:57','2017-11-01 16:14:57'),(3,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,18,3,'???o??',1,9.50,1,'2018-02-10 20:40:52','2018-02-10 20:40:52'),(3,19,1,'?c??o??',2,2.00,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(3,19,2,'?e?????o??',3,10.00,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(3,19,3,'???o??',1,8.50,1,'2017-11-24 14:59:01','2017-11-24 14:59:01'),(4,15,1,'?c??o??',2,8.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,15,2,'?e?????o??',3,5.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,15,3,'???o??',1,7.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,16,1,'?c??o??',2,0.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,16,2,'?e?????o??',3,0.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,16,3,'???o??',1,0.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,17,1,'?c??o??',2,0.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,17,2,'?e?????o??',3,0.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(4,17,3,'???o??',1,0.00,1,'2016-04-26 14:35:35','2018-10-03 14:23:34'),(5,15,1,'?c??o??',2,8.00,1,'2016-04-27 17:11:45','2018-10-03 14:23:26'),(5,15,2,'?e?????o??',3,5.00,1,'2016-04-27 17:11:45','2018-10-03 14:23:26'),(5,15,3,'???o??',1,7.00,1,'2016-04-27 17:11:45','2018-10-03 14:23:26'),(5,16,1,'?c??o??',2,10.00,1,'2016-04-27 17:11:45','2018-10-03 14:23:26'),(5,16,2,'?e?????o??',3,20.00,1,'2016-04-27 17:11:45','2018-10-03 14:23:26'),(5,16,3,'???o??',1,20.50,1,'2016-04-27 17:11:45','2018-10-03 14:23:26'),(5,17,1,'?c??o??',2,10.00,1,'2017-05-09 09:47:21','2018-10-03 14:23:26'),(5,17,2,'?e?????o??',3,20.00,1,'2017-05-09 09:47:21','2018-10-03 14:23:26'),(5,17,3,'???o??',1,10.00,1,'2017-05-09 09:47:21','2018-10-03 14:23:26'),(5,18,1,'?c??o??',2,10.00,1,'2018-02-10 20:41:36','2018-10-03 14:23:26'),(5,18,2,'?e?????o??',3,20.00,1,'2018-02-10 20:41:36','2018-10-03 14:23:26'),(5,18,3,'???o??',1,10.00,1,'2018-02-10 20:41:36','2018-10-03 14:23:26'),(5,19,1,'?c??o??',2,10.00,1,'2018-02-10 20:41:36','2018-10-03 14:23:26'),(5,19,2,'?e?????o??',3,20.00,1,'2018-02-10 20:41:36','2018-10-03 14:23:26'),(5,19,3,'???o??',1,10.00,1,'2018-02-10 20:41:36','2018-10-03 14:23:26'),(7,15,1,'?c??o??',2,8.00,1,'2016-08-02 10:07:24','2018-10-03 14:23:39'),(7,15,2,'?e?????o??',3,5.00,1,'2016-08-02 10:07:24','2018-10-03 14:23:39'),(7,15,3,'???o??',1,7.00,1,'2016-08-02 10:07:24','2018-10-03 14:23:39'),(7,16,1,'?c??o??',2,2.00,1,'2016-12-16 10:10:10','2018-10-03 14:23:39'),(7,16,2,'?e?????o??',3,7.00,1,'2016-12-16 10:10:10','2018-10-03 14:23:39'),(7,16,3,'???o??',1,8.50,1,'2016-12-16 10:10:10','2018-10-03 14:23:39'),(7,17,1,'?c??o??',2,2.00,1,'2016-08-02 10:07:24','2018-10-03 14:23:39'),(7,17,2,'?e?????o??',3,7.00,1,'2016-08-02 10:07:24','2018-10-03 14:23:39'),(7,17,3,'???o??',1,8.50,1,'2016-08-02 10:07:24','2018-10-03 14:23:39'),(7,18,1,'?c??o??',3,1.50,1,'2018-09-14 09:16:08','2018-10-03 14:23:39'),(7,18,2,'?e?????o??',2,7.50,1,'2018-09-14 09:16:08','2018-10-03 14:23:39'),(7,18,3,'???o??',1,9.50,1,'2018-09-14 09:16:08','2018-10-03 14:23:39'),(7,19,1,'?c??o??',2,1.50,1,'2018-02-10 20:41:24','2018-10-03 14:23:39'),(7,19,2,'?e?????o??',3,7.50,1,'2018-02-10 20:41:24','2018-10-03 14:23:39'),(7,19,3,'???o??',1,9.50,1,'2018-02-10 20:41:24','2018-10-03 14:23:39'),(8,15,1,'?c??o??',2,8.00,1,'2016-09-27 18:46:03','2018-10-03 14:23:14'),(8,15,2,'?e?????o??',3,5.00,1,'2016-09-27 18:46:03','2018-10-03 14:23:14'),(8,15,3,'???o??',1,7.00,1,'2016-09-27 18:46:03','2018-10-03 14:23:14'),(8,16,1,'?c??o??',2,2.00,1,'2016-09-27 18:46:03','2018-10-03 14:23:14'),(8,16,2,'?e?????o??',3,7.00,1,'2016-09-27 18:46:03','2018-10-03 14:23:14'),(8,16,3,'???o??',1,8.50,1,'2016-09-27 18:46:03','2018-10-03 14:23:14'),(8,17,1,'?c??o??',2,2.00,1,'2017-05-09 09:50:16','2018-10-03 14:23:14'),(8,17,2,'?e?????o??',3,10.00,1,'2017-05-09 09:50:16','2018-10-03 14:23:14'),(8,17,3,'???o??',1,8.50,1,'2017-05-09 09:50:16','2018-10-03 14:23:14'),(8,18,1,'?c??o??',2,1.50,1,'2018-02-10 20:39:49','2018-10-03 14:23:14'),(8,18,2,'?e?????o??',3,7.50,1,'2018-02-10 20:39:49','2018-10-03 14:23:14'),(8,18,3,'???o??',1,9.50,1,'2018-02-10 20:39:49','2018-10-03 14:23:14'),(8,19,1,'?c??o??',2,2.00,1,'2017-11-24 15:03:58','2018-10-03 14:23:14'),(8,19,2,'?e?????o??',3,11.00,1,'2017-11-24 15:03:58','2018-10-03 14:23:14'),(8,19,3,'???o??',1,8.50,1,'2017-11-24 15:03:58','2018-10-03 14:23:14'),(9,15,1,'?c??o??',2,8.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,15,2,'?e?????o??',3,5.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,15,3,'???o??',1,7.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,1,'?c??o??',2,2.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,2,'?e?????o??',3,8.00,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,16,3,'???o??',1,15.50,1,'2016-06-09 18:29:25','2016-06-09 18:29:25'),(9,17,1,'?c??o??',2,1.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,17,2,'?e?????o??',3,7.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,17,3,'???o??',1,9.50,1,'2018-02-10 20:41:06','2018-02-10 20:41:06'),(9,18,1,'?c??o??',2,2.00,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,18,2,'?e?????o??',3,9.00,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,18,3,'???o??',1,8.50,1,'2017-11-24 15:02:32','2017-11-24 15:02:32'),(9,19,1,'?c??o??',2,2.00,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(9,19,2,'?e?????o??',3,10.00,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(9,19,3,'???o??',1,8.50,1,'2017-11-24 15:00:21','2017-11-24 15:00:21'),(10,17,1,'?c??o??',2,0.00,1,'2018-03-29 17:28:32','2018-10-03 14:23:23'),(10,17,2,'?e?????o??',3,0.00,1,'2018-03-29 17:28:32','2018-10-03 14:23:23'),(10,17,3,'???o??',1,0.00,1,'2018-03-29 17:28:32','2018-10-03 14:23:23'),(10,18,1,'?c??o??',3,1.50,1,'2018-09-14 09:16:24','2018-10-03 14:23:23'),(10,18,2,'?e?????o??',2,7.50,1,'2018-09-14 09:16:24','2018-10-03 14:23:23'),(10,18,3,'???o??',1,9.50,1,'2018-09-14 09:16:24','2018-10-03 14:23:23'),(10,19,1,'?c??o??',2,1.50,1,'2018-03-28 16:32:28','2018-10-03 14:23:23'),(10,19,2,'?e?????o??',3,7.50,1,'2018-03-28 16:32:28','2018-10-03 14:23:23'),(10,19,3,'???o??',1,9.50,1,'2018-03-28 16:32:28','2018-10-03 14:23:23'),(11,18,1,'?c??o??',3,0.00,1,'2018-09-13 09:22:04','2018-09-13 09:29:06'),(11,18,2,'?e?????o??',2,0.00,1,'2018-09-13 09:22:04','2018-09-13 09:29:06'),(11,18,3,'???o??',1,0.00,1,'2018-09-13 09:22:04','2018-09-13 09:29:06'),(11,19,1,'?c??o??',3,0.00,1,'2018-09-13 09:22:04','2018-09-13 09:29:06'),(11,19,2,'?e?????o??',2,0.00,1,'2018-09-13 09:22:04','2018-09-13 09:29:06'),(11,19,3,'???o??',1,0.00,1,'2018-09-13 09:22:04','2018-09-13 09:29:06');

/*!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 '?????R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `DepartmentString` varchar(100) NOT NULL COMMENT '??????',

  `ActionScheduleFlg` decimal(1,0) NOT NULL COMMENT '?s???\??\???t???O',

  `StaffAssignFlg` decimal(1,0) NOT NULL COMMENT '?l???z?u?\???t???O',

  `StartDate` datetime NOT NULL COMMENT '?J?n???t',

  `CompDate` datetime NOT NULL COMMENT '?I?????t',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`DepartmentCode`),

  KEY `DepartmentMaster_index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????}?X?^';

/*!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,'?H????',0,0,'2018-10-01 00:00:00','0001-01-01 00:00:00',0,'0000-00-00 00:00:00','0000-00-00 00:00:00');

/*!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 '???R?[?h',

  `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '????R?[?h',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `NameString` varchar(100) NOT NULL DEFAULT '' COMMENT '????',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`DivisionCode`,`NameCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='???}?X?^';

/*!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,'?@?l?i??????j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,2,2,'?@?l?i??????j',0,'2015-11-09 14:25:45','2018-10-03 14:18:22'),(1,3,3,'?@?l?i?a?@?E?????{????j',0,'2018-02-24 19:31:29','2018-10-03 14:18:22'),(1,4,4,'?@?l?i?w?Z?@?l?j',0,'2015-11-09 14:31:08','2018-10-03 14:18:22'),(1,5,5,'?????c??i?e????j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,6,6,'???z?m???????E??????m???????',0,'2015-11-13 13:47:24','2018-10-03 14:18:22'),(1,7,7,'??l?i???j',0,'2015-11-09 14:23:45','2018-10-03 14:18:22'),(1,8,8,'????g???E??????',0,'2017-04-19 07:36:33','2018-10-03 14:18:22'),(1,9,9,'?X???',0,'2018-02-24 19:25:37','2018-10-03 14:18:22'),(1,10,10,'?????',0,'2017-04-19 07:36:44','2018-10-03 14:18:22'),(3,3,1,'???o??',0,'2015-11-16 15:19:23','2018-04-27 08:33:01');

/*!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=utf8 COMMENT='???}?X?^';

/*!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 `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 '?S????R?[?h',

  `DisplayOrder` decimal(8,0) unsigned NOT NULL COMMENT '?\????',

  `PersonName` varchar(60) NOT NULL COMMENT '?S?????',

  `StartDate` date NOT NULL COMMENT '?g?p?J?n?N????',

  `EndDate` date DEFAULT NULL COMMENT '?g?p?I???N????',

  `PassWord` varchar(16) DEFAULT NULL COMMENT '?p?X???[?h',

  `SecurityManagement` decimal(1,0) NOT NULL COMMENT '?@????',

  `SecCode` decimal(2,0) unsigned NOT NULL COMMENT '???????',

  `MsgBackColor` varchar(8) DEFAULT NULL COMMENT '???b?Z?[?W?w?i?F',

  `DisplayString` varchar(20) DEFAULT NULL COMMENT '?\???E???????',

  `DepartmentCode` decimal(5,0) unsigned DEFAULT NULL COMMENT '?????R?[?h',

  `MonthlySalary` decimal(11,0) NOT NULL COMMENT '???????z',

  `YearSalary` decimal(12,0) NOT NULL COMMENT '?N????z',

  `Qualification` varchar(120) DEFAULT NULL COMMENT '???i?????',

  `SealPrintName` varchar(5) DEFAULT NULL COMMENT '???\????',

  `EmployeeClassFlg` decimal(1,0) NOT NULL COMMENT '?????',

  `LedgerFlg` decimal(1,0) NOT NULL COMMENT '???v?Z???t???O',

  `CommutingDistance` decimal(5,2) NOT NULL COMMENT '??????',

  `CommuteCosts` decimal(5,0) NOT NULL COMMENT '??????',

  `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`PersonCode`),

  KEY `PersonInChargeMaster_Index1` (`StartDate`),

  KEY `PersonInChargeMaster_Index2` (`DepartmentCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S????}?X?^';

/*!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 (20181001,1,'?????','2018-10-01','0001-01-01','20181001',4,1,'','',1,0,0,'','',1,1,0.00,0,0,'2018-10-03 14:23:19','2018-10-03 14:23:19');

/*!40000 ALTER TABLE `personinchargemaster` 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 '?N?????????',

  `EditFlg` decimal(1,0) NOT NULL COMMENT '??W?t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`SecCode`,`ExecCode`),

  KEY `ProcessExcuteMaster_Index1` (`SecCode`),

  KEY `ProcessExcuteMaster_Index2` (`ExecCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?N?????}?X?^';

/*!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,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,7,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,11,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,37,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,45,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,101,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,102,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,111,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,112,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,115,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,117,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,118,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,120,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,124,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,126,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,129,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,131,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(1,132,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(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 `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 '?L?[????',

  `TargetDate` date NOT NULL COMMENT '?N?????t',

  `SystemVersion` int(11) NOT NULL COMMENT '?{??E????o?[?W????',

  `UpDateCopyVersion` int(11) NOT NULL COMMENT '?R?s?[?o?[?W????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`PrimaryCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?V?X?e???N???m?F?f?[?^';

/*!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',228,2,'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 '???R?[?h',

  `CompanyName1` varchar(60) NOT NULL COMMENT '?????P',

  `CompanyName2` varchar(60) DEFAULT NULL COMMENT '?????Q',

  `CEOName` varchar(60) NOT NULL COMMENT '??\?????',

  `CEOPositionName` varchar(60) DEFAULT NULL COMMENT '??\???E??',

  `ZipCode` varchar(8) NOT NULL COMMENT '?X????',

  `Address1` varchar(60) NOT NULL COMMENT '?Z???P',

  `Address2` varchar(60) DEFAULT NULL COMMENT '?Z??2',

  `Address3` varchar(60) DEFAULT NULL COMMENT '?Z??3',

  `PhoneNumber` varchar(13) NOT NULL COMMENT '?d?b???',

  `FaxNumber` varchar(13) DEFAULT NULL COMMENT 'FAX???',

  `HomePageURL` varchar(120) DEFAULT NULL COMMENT '?z?[???y?[?WURL',

  `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 '?R???L???P??',

  `AreaDistance` decimal(5,2) NOT NULL COMMENT '????u????????',

  `ExcelSavePath` varchar(120) DEFAULT NULL COMMENT 'Excel????p?X',

  `BusinessPeriod` smallint(6) NOT NULL COMMENT '????c?????',

  `ConstrYear` smallint(6) NOT NULL COMMENT '????H???N?x',

  `BusinessBeginDate` datetime NOT NULL COMMENT '?c????????',

  `ConstrBeginDate` datetime NOT NULL COMMENT '?H???N?x?????',

  `BusinessCompDate` datetime NOT NULL COMMENT '?c?????????',

  `ConstrCompDate` datetime NOT NULL COMMENT '?H???N?x??????',

  `ConstructionNoBase` decimal(1,0) NOT NULL COMMENT '?H????????l',

  `SloganString1` varchar(100) DEFAULT NULL COMMENT '?W??1',

  `SloganString2` varchar(100) DEFAULT NULL COMMENT '?W??2',

  `SloganString3` varchar(100) DEFAULT NULL COMMENT '?W??3',

  `OperationFlg` decimal(2,0) unsigned NOT NULL COMMENT '???F?^?p?t???O',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`SystemCode`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='????}?X?^';

/*!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,'???????@?q???E?H???X','','?Z?@?T??Y','??\??????@????CEO','651-1312','?????','?_??s?k??','?L???L??813-2','078-984-5210','078-984-5220','http://www.hyou.co.jp',8.00,0.50,8.00,20.00,3.00,'Z:?@?S??????????L???????????G?N?Z???f?[?^',0,0,'2018-10-01 00:00:00','2018-10-01 00:00:00','9999-12-31 00:00:00','9999-12-31 00:00:00',0,'','','',0,'2015-09-05 00:00:00','2018-09-28 15:25:49');

/*!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 '?P??L?[',

  `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????',

  `UnitName` varchar(30) NOT NULL COMMENT '?P?????',

  `EntryDate` datetime NOT NULL COMMENT '?o?^???t',

  `UpdateDate` datetime NOT NULL COMMENT '?X?V???t',

  PRIMARY KEY (`UnitKey`),

  KEY `UnitMaster_Index1` (`DisplayOrder`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?P??}?X?^';

/*!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,'???j?b?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(3,26,'?p?b?N','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,'?n??','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,'?X?p??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(12,33,'?p??','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,'?A','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,'???E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(19,9,'?????Q','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,'???E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(22,3,'???Q','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,'???Q?E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(25,40,'?????Q','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,'?X?p????','2015-08-31 00:00:00','2018-09-14 11:02:46'),(28,8,'?????Q','2015-08-31 00:00:00','2018-09-14 11:02:46'),(29,13,'?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(30,42,'???X?p??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(31,10,'?????Q','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,'??E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(34,44,'???????Q','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,'???E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(37,47,'???k','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,'?{?E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(40,50,'?k','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,'?g?E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(43,4,'???R','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,'??E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(46,5,'??R','2015-08-31 00:00:00','2018-09-14 11:02:46'),(47,54,'?Z?b?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(48,55,'???E??','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,'?L?b?g','2015-08-31 00:00:00','2018-09-14 11:02:46'),(51,58,'?Z?b?g??','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,'???Q?E??','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,'??E??','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,'??E??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(61,66,'?E','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,'????Q','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,'?????O','2015-08-31 00:00:00','2018-09-14 11:02:46'),(66,12,'????Q','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,'???Q?E??','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,'?S????','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,'?P?[?X','2015-08-31 00:00:00','2018-09-14 11:02:46'),(75,76,'???X?p??','2015-08-31 00:00:00','2018-09-14 11:02:46'),(76,77,'?o','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,'?|?C???g','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 '?N',

  PRIMARY KEY (`years`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?N?}?X?^';

/*!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 (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;

-- Date/Time    : 2019/11/21 17:23:43

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

  , ConstructionCode decimal(10,0) not null comment '?H???R?[?h'

  , ActionResult varchar(100) not null comment '?s??????'

  , DayTimes decimal(5,2) not null comment '???????'

  , Overtime decimal(5,2) not null comment '????O?A??'

  , OvertimeWA decimal(5,2) not null comment '?c??F?????'

  , WorkKindFlg decimal(2,0) not null comment '?????t???O'

-- BackupToTempTable

-- RestoreFromTempTable

  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'

  , NormalTimes decimal(5,2) not null comment '??????????'

  , OutEarlyTimes decimal(5,2) not null comment '???o?????'

  , OverTimes decimal(5,2) not null comment '?c??????'

  , HolidayWorkTimes decimal(5,2) not null comment '?x???o??????'

  , TransferHolidayTimes decimal(5,2) not null comment '?U??x????'

  , CompensatoryHolidayTimes decimal(5,2) not null comment '??x??'

  , PaidHolidaysTimes decimal(5,2) not null comment '?L???x???'

  , AbsenceTimes decimal(5,2) not null comment '????????'

  , LateTimes decimal(5,2) not null comment '?x???????'

  , LeaveEarlyTimes decimal(5,2) not null comment '????????'

  , GoOutTimes decimal(5,2) not null comment '?O?o?????'

  , OrderDate decimal(6,0) unsigned not null comment '?\????'

-- ????o?f?[?^

-- BackupToTempTable

drop table if exists attendancenotice cascade;

-- RestoreFromTempTable

create table attendancenotice (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceNo decimal(2,0) unsigned not null comment '????'

  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'

  , OrderNo decimal(3,0) unsigned not null comment '????'

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , HolidayReason decimal(1,0) unsigned not null comment '?x???'

  , FromDate datetime not null comment '?J?n????'

  , ToDate datetime not null comment '?I??????'

  , NoticePeriod decimal(5,2) unsigned not null comment '???????'

  , TransferDay datetime not null comment '?U???'

  , Reason varchar(300) comment '???R'

  , Note varchar(300) comment '???l'

  , ApprovalDate decimal(6,0) unsigned not null comment '???F??'

  , ApprovalNo decimal(2,0) unsigned not null comment '???F??t???'

  , DeleteFlg decimal(1,0) unsigned not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attendancenotice_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)

) comment '????o?f?[?^' ;

-- ????o?R?t???f?[?^

-- BackupToTempTable

drop table if exists attendancenoticelink cascade;

-- RestoreFromTempTable

create table attendancenoticelink (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceNo decimal(2,0) unsigned not null comment '????'

  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'

  , OrderNo decimal(3,0) unsigned not null comment '????'

  , DailyDate date not null comment '???????'

  , SeqNo decimal(3,0) unsigned not null comment '?????s???'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attendancenoticelink_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo,DailyDate,SeqNo)

) comment '????o?R?t???f?[?^' ;

create index AttendanceNoticeLink_Index1

  on attendancenoticelink(PersonCode);

create index AttendanceNoticeLink_Index2

  on attendancenoticelink(AttendanceNo);

create index AttendanceNoticeLink_Index3

  on attendancenoticelink(AttendanceMonth);

create index AttendanceNoticeLink_Index4

  on attendancenoticelink(OrderNo);

create index AttendanceNoticeLink_Index5

  on attendancenoticelink(DailyDate);

create index AttendanceNoticeLink_Index6

  on attendancenoticelink(SeqNo);

-- ????o?H???f?[?^

-- BackupToTempTable

drop table if exists attnoticeconstrction cascade;

-- RestoreFromTempTable

create table attnoticeconstrction (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceNo decimal(2,0) unsigned not null comment '????'

  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'

  , OrderNo decimal(3,0) unsigned not null comment '????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , ConstructionName varchar(300) comment '?H??????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attnoticeconstrction_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)

) comment '????o?H???f?[?^' ;

-- ?L???x??????R?t?f?[?^

-- BackupToTempTable

drop table if exists attnpaidholidyalink cascade;

-- RestoreFromTempTable

create table attnpaidholidyalink (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceNo decimal(2,0) unsigned not null comment '????'

  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'

  , OrderNo decimal(3,0) unsigned not null comment '????'

  , PreviousYear decimal(3,1) not null comment '?O?N?x?L??????'

  , CurrentYear decimal(3,1) not null comment '???N?x?L??????'

  , Completed decimal(1,0) unsigned not null comment '?????????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attnpaidholidyalink_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)

) comment '?L???x??????R?t?f?[?^' ;

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

  , LABOURKIND decimal(1,0) not null comment '?x???????E????'

  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '????????'

  , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '??????'

  , LinkDataType decimal(1,0) not null comment '??A?t???f?[?^?^?C?v'

  , OverFlg decimal(1,0) comment '?x??????t???O'

  , DELETEFLG decimal(1,0) comment '???t???O'

  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,LABOURKIND)

create index billingdatadetail_Index1

  on billingdatadetail(COMPANYCODE);

create index billingdatadetail_Index2

  on billingdatadetail(TARGETDATE);

create index billingdatadetail_Index3

  on billingdatadetail(SEQNO);

create index billingdatadetail_Index4

  on billingdatadetail(LINECOUNT);

create index billingdatadetail_Index5

  on billingdatadetail(LABOURKIND);

create index billingdatadetail_Index6

  on billingdatadetail(CONSTRUCTIONCODE);

create index billingdatadetail_Index7

  on billingdatadetail(CONSTRUCTIONROWCNT);

create index billingdatadetail_Index8

  on billingdatadetail(CONSTRUCTIONCOLCNT);

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

  , LineCount decimal(4,0) unsigned not null comment '?s???'

  , DetailCount decimal(4,0) unsigned not null comment '??????'

  , InvalidLine decimal(1,0) not null comment '?????s'

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable

-- RestoreFromTempTable

-- BackupToTempTable