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

-- Table structure for table `chgchargedep`

--

DROP TABLE IF EXISTS `chgchargedep`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `chgchargedep` (

  `PersonCode` decimal(8,0) NOT NULL COMMENT '?S????R?[?h',

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

  `CompDate` date NOT NULL COMMENT '?I???N????',

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

  `DepartmentName` varchar(60) DEFAULT NULL COMMENT '??????',

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

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

  PRIMARY KEY (`PersonCode`,`StartDate`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S????????????f?[?^';

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

--

-- Dumping data for table `chgchargedep`

--

LOCK TABLES `chgchargedep` WRITE;

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

INSERT INTO `chgchargedep` VALUES (20181001,'2020-01-01','9999-12-31',1,'?H????','2020-09-29 16:26:56','2020-09-29 16:26:56');

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

UNLOCK TABLES;

--

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'),(14,10,'???C?U?H???@???c?U???s?Z??A?p',1,0,0,0,'2015-11-18 18:45:38','2018-04-05 19:19:45'),(15,11,'????C?H???@???c?U???s?Z??A?p',1,0,0,0,'2015-11-18 18:46:07','2018-04-05 19:19:45'),(16,12,'????p?@???c?U???s?Z??A?p',0,1,1,0,'2015-11-27 09:14:52','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');

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

INSERT INTO `constructionitemmaster` VALUES (1,1,'??????@???W???Z??',0,1,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(2,2,'?????????@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(3,3,'?H???{???@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(4,4,'??????S??@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(5,5,'????p?????M??@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(6,6,'???O???????|??@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(7,7,'?@?B????@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(8,8,'??????@???W???Z??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(10,10,'????????????@???????H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(11,9,'???????Z???@???????H??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(14,11,'????H???@?????E???H??',0,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(15,15,'???H????',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(16,16,'?????P???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(17,17,'?O???P???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(18,19,'???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(19,20,'?????????',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:54'),(20,12,'???????H????',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:53'),(21,90,'???@?P???H??',1,0,0,'2016-02-15 15:13:10','2018-10-29 21:39:56'),(22,21,'?y?H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(23,22,'?n??H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(24,24,'?S??H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(25,25,'?R???N???[?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(26,26,'?^?g?H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(27,27,'?S???H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(28,28,'?????H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(29,29,'?`?k?b?p?l???H??',1,0,0,'2016-02-15 15:13:11','2018-10-29 21:39:54'),(30,30,'???o???`?Z?????g??H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(31,32,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(32,33,'??E?^?C???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(33,34,'??H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(34,35,'??H?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(35,37,'?????E????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(36,38,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:54'),(37,39,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(38,40,'?????t???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(39,41,'???????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(40,42,'??????????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(41,43,'?V???b?^?[?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(42,44,'?K???X?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(43,46,'?h???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(44,47,'?????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(45,49,'?y?S?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(46,50,'?????d???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(47,52,'???j?b?g?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(48,53,'?t???[?A?N?Z?X?t???A?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(49,54,'?O?\?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(50,58,'??????H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(51,51,'???H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(52,63,'?h?????C?H??',1,0,0,'2016-02-15 15:13:12','2018-10-29 21:39:55'),(53,64,'?h?????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(54,62,'?O????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(55,65,'??????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(56,66,'???????C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(57,67,'??k???C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(58,89,'???@?c?U?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:56'),(59,59,'???C?H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(60,18,'?P???H??',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:54'),(61,68,'?z???H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(62,69,'????E?X?C?b?`?H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(63,70,'??????H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(64,71,'??d?H????',1,0,0,'2016-02-15 15:13:13','2018-10-29 21:39:55'),(65,72,'?L???[?r?N???E?u???[?J?[??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:55'),(67,73,'???r???z??H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(68,74,'?q???????t???H??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(69,76,'????H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(70,77,'?z???h???H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(71,78,'?????H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(72,79,'?z?C?E???C?H??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(73,80,'?G?A?R???H??',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(74,83,'?K?X????H????',1,0,0,'2016-02-15 15:13:14','2018-10-29 21:39:56'),(86,56,'?A??H??',1,0,0,'2016-02-15 15:13:16','2018-10-29 21:39:55'),(106,85,'???A?C?U?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(107,86,'???C?C?U?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(108,87,'??l???S?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(109,88,'?s?????S?H??',1,0,0,'2016-02-15 15:13:18','2018-10-29 21:39:56'),(110,60,'??C?H??',1,0,0,'2016-02-16 10:22:40','2018-10-29 21:39:55'),(111,61,'?O?????C?H??',1,0,0,'2016-04-18 07:55:25','2018-10-29 21:39:55'),(112,31,'?????R???N???[?g?H??',1,0,0,'2016-04-21 08:26:28','2018-10-29 21:39:54'),(113,91,'?o??????-?`',1,0,0,'2016-09-14 16:22:45','2018-10-29 21:39:56'),(114,92,'?o??????-?a',1,0,0,'2016-09-14 16:23:19','2018-10-29 21:39:56'),(115,93,'?o??????-?b',1,0,0,'2016-09-14 16:23:45','2018-10-29 21:39:56'),(116,48,'?O???H??',1,0,0,'2016-09-21 16:58:22','2018-10-29 21:39:55'),(117,23,'??b?H??',1,0,0,'2016-10-12 15:22:56','2018-10-29 21:39:54'),(118,13,'?{??H?? ',1,0,0,'2016-10-27 13:09:47','2018-10-29 21:39:53'),(119,55,'???O?H??',1,0,0,'2016-10-27 13:10:39','2018-10-29 21:39:55'),(120,45,'????E?K???X?H??',1,0,0,'2016-10-27 13:13:18','2018-10-29 21:39:55'),(121,36,'??E?????H??',1,0,0,'2016-10-27 13:14:20','2018-10-29 21:39:54'),(122,14,'?G?H??',1,0,0,'2016-10-27 13:14:46','2018-10-29 21:39:53'),(123,82,'???E??????H??',1,0,0,'2016-12-23 09:55:36','2018-10-29 21:39:56'),(124,75,'?O???X?g???b?v??u?H??',1,0,0,'2016-12-23 10:06:14','2018-10-29 21:39:56'),(125,94,'?~?[?@??Y??H??',1,0,0,'2016-12-23 10:33:40','2018-10-29 21:39:56'),(126,57,'?T?C???H??',1,0,0,'2017-01-14 10:20:06','2018-10-29 21:39:55'),(127,95,'??????d????H??',1,0,0,'2017-01-17 07:50:49','2018-10-29 21:39:56'),(128,96,'?????E???????H??',1,0,0,'2017-01-17 07:51:41','2018-10-29 21:39:56'),(129,97,'?d???E???????H??',1,0,0,'2017-01-17 07:52:35','2018-10-29 21:39:56'),(130,99,'??d????H??',1,0,0,'2017-01-17 07:53:10','2018-10-29 21:39:56'),(131,100,'???h????H??',1,0,0,'2017-01-17 07:53:51','2018-10-29 21:39:56'),(132,101,'?_?N?g?E?t?[?h?H??',1,0,0,'2017-01-17 07:54:33','2018-10-29 21:39:56'),(133,102,'?@??{??i??@??j',1,0,0,'2017-01-17 07:55:08','2018-10-29 21:39:56'),(134,103,'?@??{??i???C?@??j',1,0,0,'2017-01-17 07:59:26','2018-10-29 21:39:56'),(135,104,'?????H??',1,0,0,'2017-01-17 08:00:15','2018-10-29 21:39:56'),(136,105,'???C????H??',1,0,0,'2017-01-17 08:01:02','2018-10-29 21:39:56'),(137,98,'???????H??',1,0,0,'2017-01-17 08:06:28','2018-10-29 21:39:56'),(138,106,'?????H??',1,0,0,'2017-02-15 08:19:36','2018-10-29 21:39:56'),(139,107,'???z?H??',1,0,0,'2017-02-15 08:39:06','2018-10-29 21:39:56'),(140,108,'?z???H??',1,0,0,'2017-03-09 17:19:19','2018-10-29 21:39:56'),(144,109,'???z?H??',1,0,0,'2017-09-30 09:22:07','2018-10-29 21:39:56'),(145,110,'???????H????????V?z?p',1,1,0,'2018-01-31 08:19:51','2018-10-29 21:39:56'),(146,111,'??b?H????????V?z?p',1,0,0,'2018-01-31 08:20:37','2018-10-29 21:39:57'),(147,112,'???H????????V?z?p',1,0,0,'2018-01-31 08:21:02','2018-10-29 21:39:57'),(148,113,'?O??????H????????V?z?p',1,0,0,'2018-01-31 08:21:28','2018-10-29 21:39:57'),(149,114,'?O??????H????????V?z?p',1,0,0,'2018-01-31 08:23:00','2018-10-29 21:39:57'),(150,115,'?O???t??H????????V?z?p',1,0,0,'2018-01-31 08:23:44','2018-10-29 21:39:57'),(151,116,'????????H????????V?z?p',1,0,0,'2018-01-31 08:24:32','2018-10-29 21:39:57'),(152,117,'????????H????????V?z?p',1,0,0,'2018-01-31 08:25:10','2018-10-29 21:39:57'),(153,118,'?????H???H????????V?z?p',1,0,0,'2018-01-31 08:25:52','2018-10-29 21:39:57'),(154,119,'?????????E?t??H????????V?z?p',1,0,0,'2018-01-31 08:26:21','2018-10-29 21:39:57'),(155,81,'???z?????d?H??',1,0,0,'2018-01-31 08:27:46','2018-10-29 21:39:56'),(156,84,'?????????H??',1,0,0,'2018-02-01 07:59:14','2018-10-29 21:39:56'),(157,120,'???|?H??',1,0,0,'2018-02-01 07:59:43','2018-10-29 21:39:57'),(158,121,'?c?y?E?q?y?H??',1,0,0,'2018-02-01 08:00:12','2018-10-29 21:39:57'),(159,122,'???S???E????{?H',1,0,0,'2018-02-01 08:00:56','2018-10-29 21:39:57'),(160,123,'???????',0,0,0,'2018-04-05 18:34:43','2018-10-29 21:39:57'),(161,124,'??????',0,0,0,'2018-04-05 18:35:06','2018-10-29 21:39:57'),(162,125,'??v????F?\??????',0,0,0,'2018-04-05 18:35:25','2018-10-29 21:39:57'),(163,126,'??v????F?\????????p',0,0,0,'2018-04-05 18:41:30','2018-10-29 21:39:57'),(164,127,'??v????F?????v??',0,0,0,'2018-04-05 18:42:13','2018-10-29 21:39:57'),(165,128,'????H??',1,0,0,'2018-04-26 10:16:20','2018-10-29 21:39:57'),(166,129,'?????E???H??',1,0,0,'2018-10-29 21:38:03','2018-10-29 21:39:57');

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

INSERT INTO `constructiontypemaster` VALUES (1,1,'?????H???@???C?i?????j',1,2,4,0,0,0,'2015-11-17 08:16:00','2019-12-03 14:10:14'),(2,2,'?????H???@?V?z?i?????j',1,1,4,0,0,0,'2016-01-30 10:35:47','2019-12-03 14:10:14'),(3,3,'?????H???@???C?i?????j',1,2,4,0,0,0,'2015-11-17 08:16:00','2019-12-03 14:10:14'),(4,4,'?????H???@?V?z?i?????j',1,1,4,0,0,0,'2016-01-30 10:42:20','2019-12-03 14:10:14'),(5,5,'????H???@???C?i?????j',2,0,4,0,0,0,'2015-11-16 15:19:01','2019-12-03 14:10:14'),(6,6,'????H???@?V?z?i?????j',2,0,4,0,0,0,'2016-01-30 10:43:14','2019-12-03 14:10:14'),(7,7,'????H???@???C?i?????j',2,0,4,0,0,0,'2015-11-16 15:19:01','2019-12-03 14:10:14'),(8,8,'????H???@?V?z?i?????j',2,0,4,0,0,0,'2016-01-30 10:43:47','2019-12-03 14:10:14');

INSERT INTO `departmentexpensesmaster` VALUES (1,1,1,'???o??',1,0.00,0,'2020-09-29 16:17:58','2020-09-29 16:17:58'),(1,1,2,'?c??o??',2,0.00,0,'2020-09-29 16:17:58','2020-09-29 16:17:58');

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','2020-09-29 16:17:58');

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

INSERT INTO `divisionmaster` VALUES (1,1,1,'?????c??',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,2,2,'?@?l',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,3,3,'??l',0,'2015-11-09 14:23:45','2020-09-29 16:14:53'),(1,4,4,'?????',0,'2017-04-19 07:36:44','2020-09-29 16:14:53'),(3,1,1,'???o??',0,'2015-11-16 15:19:23','2018-11-14 11:01:03'),(3,2,2,'?c??o??',0,'2015-11-16 15:19:23','2018-11-14 11:01:03');

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

-- Table structure for table `persondepartmentmaster`

--

DROP TABLE IF EXISTS `persondepartmentmaster`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `persondepartmentmaster` (

  `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h',

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

  `AffiliationFlg` 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`,`DepartmentCode`),

  KEY `PersonDepartmentMaster_Index1` (`PersonCode`),

  KEY `PersonDepartmentMaster_Index2` (`DepartmentCode`)

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

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

--

-- Dumping data for table `persondepartmentmaster`

--

LOCK TABLES `persondepartmentmaster` WRITE;

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

INSERT INTO `persondepartmentmaster` VALUES (20181001,1,1,'2020-09-29 16:26:56','2020-09-29 16:26:56');

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

UNLOCK TABLES;

--

INSERT INTO `personinchargemaster` VALUES (20200101,1,'?????@','?V???L?@',0,'A','9999-12-31','','','','','','','','2018-10-01','9999-12-31','20200101',4,1,'','??\',1,0,0,'','???F??',1,1,0.00,0,0.0,0.0,0,0,0,'2018-10-03 14:23:19','2020-09-29 16:26:56');

-- Dumping data for table `personqualification`

--

LOCK TABLES `personqualification` WRITE;

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

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

UNLOCK TABLES;

--

-- Table structure for table `personsalarymaster`

--

DROP TABLE IF EXISTS `personsalarymaster`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `personsalarymaster` (

  `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h',

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

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

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

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

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

  PRIMARY KEY (`PersonCode`,`StartDate`),

  KEY `PersonSalaryMaster_Index1` (`PersonCode`),

  KEY `PersonSalaryMaster_Index2` (`StartDate`),

  KEY `PersonSalaryMaster_Index3` (`MonthlySalary`)

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

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

--

-- Dumping data for table `personsalarymaster`

--

LOCK TABLES `personsalarymaster` WRITE;

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

INSERT INTO `personsalarymaster` VALUES (20181001,'2020-01-01',0,0,'2020-09-29 16:26:56','2020-09-29 16:26:56');

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

UNLOCK TABLES;

--

INSERT INTO `processexcutemaster` VALUES (1,1,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,2,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,3,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,4,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,5,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,6,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,7,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,8,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,9,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,10,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,11,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,12,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,13,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,14,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,15,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,16,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,17,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,19,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,29,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,30,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,31,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,32,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,37,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,39,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,40,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,41,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,42,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,45,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,101,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,102,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,103,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,104,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,105,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,106,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,107,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,108,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,109,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,110,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,111,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,112,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,114,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,115,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,116,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,117,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,119,0,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,120,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,122,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,123,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,124,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,125,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,126,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,131,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,132,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,134,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(1,135,1,'2020-09-29 16:25:47','2020-09-29 16:25:47'),(2,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(2,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(2,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(3,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,104,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,105,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,106,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,107,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,108,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,125,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(3,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(4,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,20,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,21,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(5,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(5,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(6,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(6,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(7,103,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(7,130,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,4,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,9,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,10,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,18,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(8,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(8,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,12,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,15,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(9,127,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(9,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,2,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,3,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,5,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,6,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,13,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,14,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,16,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,17,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,19,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,29,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,30,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,31,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,32,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,34,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,36,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,39,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,40,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,42,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(10,102,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,103,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,109,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,110,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,111,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,114,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,116,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,118,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,121,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,122,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,123,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,125,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,126,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(10,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,11,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,37,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,40,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,41,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,42,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(11,109,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,110,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,114,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,116,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,121,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,122,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,123,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,128,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(11,130,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,2,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,3,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,4,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,5,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,6,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,7,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,8,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,9,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,12,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,13,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,14,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,15,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,16,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,17,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,18,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,19,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,29,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,30,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,31,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,32,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,34,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,36,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,39,1,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07'),(12,128,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(12,129,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,1,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,8,0,'2018-08-28 14:44:30','2018-08-28 14:44:30'),(13,47,1,'2018-08-29 15:14:07','2018-08-29 15:14:07');

-- Table structure for table `securitymaster`

--

DROP TABLE IF EXISTS `securitymaster`;

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

/*!40101 SET character_set_client = utf8 */;

CREATE TABLE `securitymaster` (

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

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

  `SecName` varchar(60) NOT NULL COMMENT '????????',

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

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

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

  `SelectBackColor` varchar(8) NOT NULL COMMENT '?I??w?i?F',

  `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 (`SecCode`),

  KEY `SecurityMaster_Index1` (`DisplayOrder`),

  KEY `SecurityMaster_Index2` (`SecRank`),

  KEY `SecurityMaster_Index3` (`SecRange`)

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

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

--

-- Dumping data for table `securitymaster`

--

LOCK TABLES `securitymaster` WRITE;

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

INSERT INTO `securitymaster` VALUES (1,1,'??\',1,1,1,'0x000000',0,'2020-09-29 16:25:38','2020-09-29 16:25:47');

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

UNLOCK TABLES;

--

INSERT INTO `systemexecute` VALUES (1,'2018-10-03',0,0,'2015-12-21 17:24:12','2018-10-03 13:27:49'),(2,'2017-02-27',1,1,'2017-02-27 15:04:23','2017-05-13 13:15:23');

  `SystemOpenTime` datetime NOT NULL COMMENT '?^?p?J?n????',

  `SystemCloseTime` datetime NOT NULL COMMENT '?^?p?I??????',

  `PesrsonCost1` decimal(7,0) unsigned NOT NULL COMMENT '???l????P?i?w?????R?X?g?j',

  `PesrsonCost2` decimal(7,0) unsigned NOT NULL COMMENT '???l????Q?i???S????R?X?g?j',

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

INSERT INTO `systemmaster` VALUES (1,'???????@???z???','','??\?@???N','??\?????','650-0001','?????','?_??s??????','???[??','078-000-0000','078-000-0000','',10.00,0.50,8.00,0.00,0.00,'C:\\Temp\\?G?N?Z???f?[?^',1,2020,'2020-04-01 00:00:00','2020-04-01 00:00:00','2021-03-31 00:00:00','2021-03-31 00:00:00',-1,'','','',0,'0001-01-01 06:00:00','0001-01-01 22:00:00',100000,100000,'2015-09-05 00:00:00','2020-09-29 16:20:48');

-- Date/Time    : 2020/08/17 9:32:32

  , WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'

  , WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'

create index AttendanceNotice_Index1

  on attendancenotice(PersonCode);

create index AttendanceNotice_Index2

  on attendancenotice(AttendanceNo);

create index AttendanceNotice_Index3

  on attendancenotice(AttendanceMonth);

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

--* BackupToTempTable

drop table if exists billingcostdatalink cascade;

--* RestoreFromTempTable

create table billingcostdatalink (

  CompanyCode decimal(8,0) default '0' not null comment '??????R?[?h'

  , TargetDate decimal(6,0) default '0' not null comment '???N??'

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

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

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

  , LinkType decimal(1,0) not null comment '?????N??f?[?^?^?C?v'

  , YearNumber smallint(5) unsigned not null comment '?N?x'

  , CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O'

  , TargetType decimal(1,0) not null comment '????R?[?h?^?C?v'

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

  , SeqNoC decimal(3,0) not null comment '?f?[?^???'

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

  , ActionDate date not null comment '?????t'

  , DataType decimal(1,0) not null comment '?f?[?^??'

  , DataAddCount decimal(5,0) unsigned not null comment '?f?[?^??????'

  , EntryDate datetime comment '?o?^?N????'

  , UpdateDate datetime comment '?X?V?N????'

  , constraint billingcostdatalink_PKC primary key (CompanyCode,TargetDate,SeqNoB,LineCount,LabourKind)

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

create index BillingCostDataLink_Index1

  on billingcostdatalink(YearNumber,CostType,TargetType,TargetCode,SeqNoC);

create index BillingCostDataLink_Index2

  on billingcostdatalink(PersonCode,ActionDate,DataType,DataAddCount);

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

-- ?v?Z?W??????e?[?u??

--* BackupToTempTable

drop table if exists calccoefficient cascade;

--* RestoreFromTempTable

create table calccoefficient (

  TypeCode decimal(2,0) unsigned not null comment '?W???^?C?v?R?[?h'

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

  , CalcCoefficient01 decimal(15,5) not null comment '?W???l1'

  , CalcCoefficient02 decimal(15,5) not null comment '?W???l2'

  , CalcCoefficient03 decimal(15,5) not null comment '?W???l3'

  , CalcCoefficient04 decimal(15,5) not null comment '?W???l4'

  , CalcCoefficient05 decimal(15,5) not null comment '?W???l5'

  , CalcCoefficient06 decimal(15,5) not null comment '?W???l6'

  , CalcCoefficient07 decimal(15,5) not null comment '?W???l7'

  , CalcCoefficient08 decimal(15,5) not null comment '?W???l8'

  , CalcCoefficient09 decimal(15,5) not null comment '?W???l9'

  , CalcCoefficient10 decimal(15,5) not null comment '?W???l10'

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

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

  , constraint calccoefficient_PKC primary key (TypeCode,SeqNo)

) comment '?v?Z?W??????e?[?u??' ;

  , EvaluationScore decimal(5,2) unsigned not null comment '?]???_??'

create index LedgerExcute_Index2

  on constructionledgerexcute(ConstructionCode);

create index LedgerExcute_Index3

  on constructionledgerexcute(GroupCount);

create index LedgerExcute_Index4

  on constructionledgerexcute(LineCount);

create index LedgerExcute_Index5

  on constructionledgerexcute(ColumnCount);

create index LedgerExcute_Index6

  on constructionledgerexcute(TargetMonth);

drop table if exists costdataofcompensation cascade;

--* RestoreFromTempTable

create table costdataofcompensation (

  YearNumber smallint(5) unsigned not null comment '?N?x'

  , CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O'

  , TargetType decimal(1,0) not null comment '????R?[?h?^?C?v'

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

  , SeqNo decimal(3,0) not null comment '?f?[?^???'

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

  , FromCodeType decimal(1,0) not null comment '?o?[???R?[?h?^?C?v'

  , FromCode decimal(10,0) not null comment '?o?[???R?[?h'

  , SendDate date not null comment '?????t'

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

  , EntryPrice decimal(10,0) not null comment '???z?i????j'

  , EntryTax decimal(10,0) not null comment '???z?i????j'

  , Content varchar(120) comment '?x?????e'

  , BikoComment varchar(120) comment '???l'

  , LockFlg decimal(1,0) not null comment '?f?[?^???b?N'

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

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

  , constraint costdataofcompensation_PKC primary key (YearNumber,CostType,TargetType,TargetCode,SeqNo)

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

create index CostDataOfCompensation_Index1

  on costdataofcompensation(YearNumber);

create index CostDataOfCompensation_Index2

  on costdataofcompensation(CostType);

create index CostDataOfCompensation_Index3

  on costdataofcompensation(TargetType);

create index CostDataOfCompensation_Index4

  on costdataofcompensation(TargetCode);

create index CostDataOfCompensation_Index5

  on costdataofcompensation(PersonCode);

create index CostDataOfCompensation_Index6

  on costdataofcompensation(FromCode);

create index CostDataOfCompensation_Index7

  on costdataofcompensation(SendDate);

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

--* BackupToTempTable

-- ?o?[???o?????}?X?^

--* BackupToTempTable

drop table if exists costdatatargettypeexpenses cascade;

--* RestoreFromTempTable

create table costdatatargettypeexpenses (

  CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O'

  , TargetType decimal(1,0) not null comment '?o?[??R?[?h?^?C?v'

  , ExpensesCode decimal(6,0) not null comment '???o??R?[?h'

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

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

  , constraint costdatatargettypeexpenses_PKC primary key (CostType,TargetType,ExpensesCode)

) comment '?o?[???o?????}?X?^' ;

create index CostDataTargetTypeExpenses_Index1

  on costdatatargettypeexpenses(CostType);

create index CostDataTargetTypeExpenses_Index2

  on costdatatargettypeexpenses(TargetType);

create index CostDataTargetTypeExpenses_Index3

  on costdatatargettypeexpenses(ExpensesCode);

-- ?o?[?^?C?v????}?X?^

--* BackupToTempTable

drop table if exists costdatatype cascade;

--* RestoreFromTempTable

create table costdatatype (

  CostType decimal(1,0) not null comment '?o?[?^?C?v?R?[?h'

  , TargetType decimal(1,0) not null comment '?o?[??R?[?h?^?C?v'

  , CostDataTypeName varchar(60) comment '?o?[?^?C?v????'

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

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

  , constraint costdatatype_PKC primary key (CostType,TargetType)

) comment '?o?[?^?C?v????}?X?^' ;

create index CostDataType_Index1

  on costdatatype(CostType);

create index CostDataType_Index2

  on costdatatype(TargetType);

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

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

  , constraint dailydataconstruction_PKC primary key (ConstructionCode,DailyDataDate,PersonCode)

  on dailydataconstruction(ConstructionCode);

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

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

  , constraint dailydatadetail_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)

  on dailydatadetail(ConstructionCode,DailyDataDate,PersonCode);

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

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

  , constraint dailydatafield_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)

  on dailydatafield(ConstructionCode,DailyDataDate);

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

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

  , constraint dailydatamaterials_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)

  on dailydatamaterials(ConstructionCode,DailyDataDate);

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

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

  , constraint dailydatasubcontractors_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)

  on dailydatasubcontractors(ConstructionCode,DailyDataDate);

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

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

  , constraint dailydatavehicles_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)

  on dailydatavehicles(ConstructionCode,DailyDataDate);

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

  , Unitcount decimal(9,3) not null comment '????'

  , UnitPrice decimal(11,2) not null comment '?P??'

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

-- ???O?C??????

--* BackupToTempTable

drop table if exists loginlog cascade;

--* RestoreFromTempTable

create table loginlog (

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

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

  , LastLogin datetime not null comment '??????I???O?C??????'

  , LastLogout datetime not null comment '??????I???O?A?E?g????'

  , TotalTime decimal(10,0) not null comment '??v???O?C??????'

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

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

  , constraint loginlog_PKC primary key (PersonCode,TargetMonth)

) comment '???O?C??????' ;

  , JapaneseSyllabary varchar(2) comment '50?????'

create index orderersmaster_Index1

  on orderersmaster(JapaneseSyllabary);

create index processapprovaldetail_Index1

  on processapprovaldetail(ConstructionCode,ApprovalCode,LinkCode);

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

-- ?S?????????f?[?^

--* BackupToTempTable

drop table if exists quarterlysales cascade;

--* RestoreFromTempTable

create table quarterlysales (

  YearCode decimal(5,0) unsigned not null comment '???N?x'

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

  , OrderNo decimal(4,0) unsigned not null comment '?f?[?^??'

  , ConstructionStart date comment '?_??H???J?n??'

  , ConstructionEnd date comment '?_??H??????'

  , OrdersPrice decimal(12,0) not null comment '???????z'

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

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

  , constraint quarterlysales_PKC primary key (YearCode,ConstructionCode,OrderNo)

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

create index QuarterlySales_Index1

  on quarterlysales(YearCode);

create index QuarterlySales_Index2

  on quarterlysales(ConstructionCode);

create index QuarterlySales_Index3

  on quarterlysales(OrderNo);

-- ?S???????????f?[?^

--* BackupToTempTable

drop table if exists quarterlysalesdetail cascade;

--* RestoreFromTempTable

create table quarterlysalesdetail (

  YearCode decimal(5,0) unsigned not null comment '???N?x'

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

  , OrderNo decimal(4,0) unsigned not null comment '?f?[?^??'

  , SeqNo decimal(2,0) not null comment '?f?[?^???'

  , DataType decimal(1,0) unsigned not null comment '?f?[?^?^?C?v'

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

  , PriceValue decimal(12,0) not null comment '?????z'

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

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

  , constraint quarterlysalesdetail_PKC primary key (YearCode,ConstructionCode,OrderNo,SeqNo,DataType)

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

create index QuarterlySalesDetail_Index1

  on quarterlysalesdetail(YearCode);

create index QuarterlySalesDetail_Index2

  on quarterlysalesdetail(ConstructionCode);

create index QuarterlySalesDetail_Index3

  on quarterlysalesdetail(OrderNo);

create index QuarterlySalesDetail_Index4

  on quarterlysalesdetail(SeqNo);

create index QuarterlySalesDetail_Index5

  on quarterlysalesdetail(DataType);

create index QuarterlySalesDetail_Index6

  on quarterlysalesdetail(DataYM);

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

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

  , DisplayOrder decimal(4,0) not null comment '?\????'

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

  , SystemOpenTime datetime not null comment '?^?p?J?n????'

  , SystemCloseTime datetime not null comment '?^?p?I??????'

  , PesrsonCost1 decimal(7,0) unsigned not null comment '???l????P?i?w?????R?X?g?j'

  , PesrsonCost2 decimal(7,0) unsigned not null comment '???l????Q?i???S????R?X?g?j'