h-you / trunk / ddl / InitData.SQL @ 487
履歴 | 表示 | アノテート | ダウンロード (84.3 KB)
| 1 | 487 | h-you | |
|---|---|---|---|
| 2 | 461 | h-you | --
|
| 3 | -- Table structure for table `budgetsumcode`
|
||
| 4 | --
|
||
| 5 | |||
| 6 | DROP TABLE IF EXISTS `budgetsumcode`; |
||
| 7 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 8 | /*!40101 SET character_set_client = utf8 */;
|
||
| 9 | CREATE TABLE `budgetsumcode` ( |
||
| 10 | `BlockCode` decimal(2,0) unsigned NOT NULL COMMENT '?u???b?N???', |
||
| 11 | `GroupCode` decimal(2,0) unsigned NOT NULL COMMENT '?O???[?v???', |
||
| 12 | `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '?\???L?[', |
||
| 13 | `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[', |
||
| 14 | `ElementsName` varchar(100) NOT NULL COMMENT '?v?f????', |
||
| 15 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 16 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 17 | PRIMARY KEY (`BlockCode`,`GroupCode`,`ComponentCode`,`ItemCode`) |
||
| 18 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?\?Z???W?v?R?[?h?}?X?^'; |
||
| 19 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 20 | |||
| 21 | --
|
||
| 22 | -- Dumping data for table `budgetsumcode`
|
||
| 23 | --
|
||
| 24 | |||
| 25 | LOCK TABLES `budgetsumcode` WRITE; |
||
| 26 | /*!40000 ALTER TABLE `budgetsumcode` DISABLE KEYS */;
|
||
| 27 | 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'); |
||
| 28 | /*!40000 ALTER TABLE `budgetsumcode` ENABLE KEYS */;
|
||
| 29 | UNLOCK TABLES;
|
||
| 30 | |||
| 31 | --
|
||
| 32 | -- Table structure for table `businesstypemaster`
|
||
| 33 | --
|
||
| 34 | |||
| 35 | DROP TABLE IF EXISTS `businesstypemaster`; |
||
| 36 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 37 | /*!40101 SET character_set_client = utf8 */;
|
||
| 38 | CREATE TABLE `businesstypemaster` ( |
||
| 39 | `BusinessTypeCode` decimal(5,0) unsigned NOT NULL COMMENT '?@?l?i?R?[?h', |
||
| 40 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 41 | `BusinessTypeName` varchar(100) NOT NULL DEFAULT '' COMMENT '???', |
||
| 42 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 43 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 44 | PRIMARY KEY (`BusinessTypeCode`), |
||
| 45 | KEY `BusinessTypeMaster_Index1` (`DisplayOrder`) |
||
| 46 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?@?l?i?}?X?^'; |
||
| 47 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 48 | |||
| 49 | --
|
||
| 50 | -- Dumping data for table `businesstypemaster`
|
||
| 51 | --
|
||
| 52 | |||
| 53 | LOCK TABLES `businesstypemaster` WRITE; |
||
| 54 | /*!40000 ALTER TABLE `businesstypemaster` DISABLE KEYS */;
|
||
| 55 | 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'); |
||
| 56 | /*!40000 ALTER TABLE `businesstypemaster` ENABLE KEYS */;
|
||
| 57 | UNLOCK TABLES;
|
||
| 58 | |||
| 59 | --
|
||
| 60 | 487 | h-you | -- Table structure for table `chgchargedep`
|
| 61 | --
|
||
| 62 | |||
| 63 | DROP TABLE IF EXISTS `chgchargedep`; |
||
| 64 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 65 | /*!40101 SET character_set_client = utf8 */;
|
||
| 66 | CREATE TABLE `chgchargedep` ( |
||
| 67 | `PersonCode` decimal(8,0) NOT NULL COMMENT '?S????R?[?h', |
||
| 68 | `StartDate` date NOT NULL COMMENT '?J?n?N????', |
||
| 69 | `CompDate` date NOT NULL COMMENT '?I???N????', |
||
| 70 | `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '?????R?[?h', |
||
| 71 | `DepartmentName` varchar(60) DEFAULT NULL COMMENT '??????', |
||
| 72 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 73 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 74 | PRIMARY KEY (`PersonCode`,`StartDate`) |
||
| 75 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S????????????f?[?^'; |
||
| 76 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 77 | |||
| 78 | --
|
||
| 79 | -- Dumping data for table `chgchargedep`
|
||
| 80 | --
|
||
| 81 | |||
| 82 | LOCK TABLES `chgchargedep` WRITE; |
||
| 83 | /*!40000 ALTER TABLE `chgchargedep` DISABLE KEYS */;
|
||
| 84 | 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'); |
||
| 85 | /*!40000 ALTER TABLE `chgchargedep` ENABLE KEYS */;
|
||
| 86 | UNLOCK TABLES;
|
||
| 87 | |||
| 88 | --
|
||
| 89 | 461 | h-you | -- Table structure for table `componentlinkmaster`
|
| 90 | --
|
||
| 91 | |||
| 92 | DROP TABLE IF EXISTS `componentlinkmaster`; |
||
| 93 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 94 | /*!40101 SET character_set_client = utf8 */;
|
||
| 95 | CREATE TABLE `componentlinkmaster` ( |
||
| 96 | `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '?\???L?[', |
||
| 97 | `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[', |
||
| 98 | `DisplayOrder` decimal(5,0) unsigned DEFAULT NULL COMMENT '?\????', |
||
| 99 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 100 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 101 | PRIMARY KEY (`ComponentCode`,`ItemCode`), |
||
| 102 | KEY `ComponentLinkMaster_Index1` (`ComponentCode`), |
||
| 103 | KEY `ComponentLinkMaster_Index2` (`ItemCode`) |
||
| 104 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?\???H???A?}?X?^'; |
||
| 105 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 106 | |||
| 107 | --
|
||
| 108 | -- Dumping data for table `componentlinkmaster`
|
||
| 109 | --
|
||
| 110 | |||
| 111 | LOCK TABLES `componentlinkmaster` WRITE; |
||
| 112 | /*!40000 ALTER TABLE `componentlinkmaster` DISABLE KEYS */;
|
||
| 113 | 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'); |
||
| 114 | /*!40000 ALTER TABLE `componentlinkmaster` ENABLE KEYS */;
|
||
| 115 | UNLOCK TABLES;
|
||
| 116 | |||
| 117 | --
|
||
| 118 | -- Table structure for table `componentmaster`
|
||
| 119 | --
|
||
| 120 | |||
| 121 | DROP TABLE IF EXISTS `componentmaster`; |
||
| 122 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 123 | /*!40101 SET character_set_client = utf8 */;
|
||
| 124 | CREATE TABLE `componentmaster` ( |
||
| 125 | `ComponentCode` decimal(5,0) unsigned NOT NULL COMMENT '?\???L?[', |
||
| 126 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 127 | `ComponentName` varchar(120) NOT NULL DEFAULT '' COMMENT '?\??????', |
||
| 128 | `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O', |
||
| 129 | `DirectInputFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O', |
||
| 130 | `MyExpensesFlg` decimal(1,0) DEFAULT NULL COMMENT '????o??t???O', |
||
| 131 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 132 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 133 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 134 | PRIMARY KEY (`ComponentCode`), |
||
| 135 | KEY `ComponentMaster_Index1` (`DisplayOrder`) |
||
| 136 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?\???}?X?^'; |
||
| 137 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 138 | |||
| 139 | --
|
||
| 140 | -- Dumping data for table `componentmaster`
|
||
| 141 | --
|
||
| 142 | |||
| 143 | LOCK TABLES `componentmaster` WRITE; |
||
| 144 | /*!40000 ALTER TABLE `componentmaster` DISABLE KEYS */;
|
||
| 145 | 487 | h-you | 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'); |
| 146 | 461 | h-you | /*!40000 ALTER TABLE `componentmaster` ENABLE KEYS */;
|
| 147 | UNLOCK TABLES;
|
||
| 148 | |||
| 149 | --
|
||
| 150 | -- Table structure for table `constructionitemmaster`
|
||
| 151 | --
|
||
| 152 | |||
| 153 | DROP TABLE IF EXISTS `constructionitemmaster`; |
||
| 154 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 155 | /*!40101 SET character_set_client = utf8 */;
|
||
| 156 | CREATE TABLE `constructionitemmaster` ( |
||
| 157 | `ItemCode` decimal(5,0) unsigned NOT NULL COMMENT '?H??L?[', |
||
| 158 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 159 | `ItemName` varchar(120) NOT NULL DEFAULT '' COMMENT '?H????', |
||
| 160 | `SubItemsFlg` decimal(1,0) DEFAULT NULL COMMENT '???????t???O', |
||
| 161 | `MyExpensesFlg` decimal(1,0) NOT NULL COMMENT '????o??t???O', |
||
| 162 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 163 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 164 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 165 | PRIMARY KEY (`ItemCode`) |
||
| 166 | 487 | h-you | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?H??}?X?^'; |
| 167 | 461 | h-you | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 168 | |||
| 169 | --
|
||
| 170 | -- Dumping data for table `constructionitemmaster`
|
||
| 171 | --
|
||
| 172 | |||
| 173 | LOCK TABLES `constructionitemmaster` WRITE; |
||
| 174 | /*!40000 ALTER TABLE `constructionitemmaster` DISABLE KEYS */;
|
||
| 175 | 487 | h-you | 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'); |
| 176 | 461 | h-you | /*!40000 ALTER TABLE `constructionitemmaster` ENABLE KEYS */;
|
| 177 | UNLOCK TABLES;
|
||
| 178 | 487 | h-you | |
| 179 | 461 | h-you | --
|
| 180 | -- Table structure for table `constructiontypemaster`
|
||
| 181 | --
|
||
| 182 | |||
| 183 | DROP TABLE IF EXISTS `constructiontypemaster`; |
||
| 184 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 185 | /*!40101 SET character_set_client = utf8 */;
|
||
| 186 | CREATE TABLE `constructiontypemaster` ( |
||
| 187 | `TypeCode` decimal(5,0) unsigned NOT NULL COMMENT '?H?????R?[?h', |
||
| 188 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 189 | `NameString` varchar(100) NOT NULL COMMENT '????', |
||
| 190 | `PublicFlg` decimal(1,0) NOT NULL COMMENT '?????t???O', |
||
| 191 | `RepairFlg` decimal(1,0) NOT NULL COMMENT '?V?z?E???C?t???O', |
||
| 192 | `SecRank` decimal(1,0) NOT NULL COMMENT '?????????N', |
||
| 193 | `ExpensesLink` decimal(1,0) NOT NULL COMMENT '?o??g?p??', |
||
| 194 | 487 | h-you | `CompanyProp` decimal(1,0) NOT NULL COMMENT '????H????', |
| 195 | 461 | h-you | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
| 196 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 197 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 198 | PRIMARY KEY (`TypeCode`) |
||
| 199 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?H?????}?X?^'; |
||
| 200 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 201 | |||
| 202 | --
|
||
| 203 | -- Dumping data for table `constructiontypemaster`
|
||
| 204 | --
|
||
| 205 | |||
| 206 | LOCK TABLES `constructiontypemaster` WRITE; |
||
| 207 | /*!40000 ALTER TABLE `constructiontypemaster` DISABLE KEYS */;
|
||
| 208 | 487 | h-you | 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'); |
| 209 | 461 | h-you | /*!40000 ALTER TABLE `constructiontypemaster` ENABLE KEYS */;
|
| 210 | UNLOCK TABLES;
|
||
| 211 | |||
| 212 | --
|
||
| 213 | -- Table structure for table `daymaster`
|
||
| 214 | --
|
||
| 215 | |||
| 216 | DROP TABLE IF EXISTS `daymaster`; |
||
| 217 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 218 | /*!40101 SET character_set_client = utf8 */;
|
||
| 219 | CREATE TABLE `daymaster` ( |
||
| 220 | `days` smallint(6) NOT NULL COMMENT '??', |
||
| 221 | PRIMARY KEY (`days`) |
||
| 222 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='???}?X?^'; |
||
| 223 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 224 | |||
| 225 | --
|
||
| 226 | -- Dumping data for table `daymaster`
|
||
| 227 | --
|
||
| 228 | |||
| 229 | LOCK TABLES `daymaster` WRITE; |
||
| 230 | /*!40000 ALTER TABLE `daymaster` DISABLE KEYS */;
|
||
| 231 | 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); |
||
| 232 | /*!40000 ALTER TABLE `daymaster` ENABLE KEYS */;
|
||
| 233 | UNLOCK TABLES;
|
||
| 234 | 487 | h-you | |
| 235 | 461 | h-you | --
|
| 236 | -- Table structure for table `departmentexpensesmaster`
|
||
| 237 | --
|
||
| 238 | |||
| 239 | DROP TABLE IF EXISTS `departmentexpensesmaster`; |
||
| 240 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 241 | /*!40101 SET character_set_client = utf8 */;
|
||
| 242 | CREATE TABLE `departmentexpensesmaster` ( |
||
| 243 | `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '?????R?[?h', |
||
| 244 | `ExpensesPeriod` smallint(6) NOT NULL COMMENT '?????', |
||
| 245 | `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '?o??R?[?h', |
||
| 246 | `NameString` varchar(100) NOT NULL COMMENT '????', |
||
| 247 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 248 | `ExpensesRaito` decimal(4,2) NOT NULL COMMENT '?o??', |
||
| 249 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 250 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 251 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 252 | PRIMARY KEY (`DepartmentCode`,`ExpensesPeriod`,`NameCode`) |
||
| 253 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?????o???}?X?^'; |
||
| 254 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 255 | |||
| 256 | --
|
||
| 257 | -- Dumping data for table `departmentexpensesmaster`
|
||
| 258 | --
|
||
| 259 | |||
| 260 | LOCK TABLES `departmentexpensesmaster` WRITE; |
||
| 261 | /*!40000 ALTER TABLE `departmentexpensesmaster` DISABLE KEYS */;
|
||
| 262 | 487 | h-you | 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'); |
| 263 | 461 | h-you | /*!40000 ALTER TABLE `departmentexpensesmaster` ENABLE KEYS */;
|
| 264 | UNLOCK TABLES;
|
||
| 265 | |||
| 266 | --
|
||
| 267 | -- Table structure for table `departmentmaster`
|
||
| 268 | --
|
||
| 269 | |||
| 270 | DROP TABLE IF EXISTS `departmentmaster`; |
||
| 271 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 272 | /*!40101 SET character_set_client = utf8 */;
|
||
| 273 | CREATE TABLE `departmentmaster` ( |
||
| 274 | `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '?????R?[?h', |
||
| 275 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 276 | `DepartmentString` varchar(100) NOT NULL COMMENT '??????', |
||
| 277 | `ActionScheduleFlg` decimal(1,0) NOT NULL COMMENT '?s???\??\???t???O', |
||
| 278 | `StaffAssignFlg` decimal(1,0) NOT NULL COMMENT '?l???z?u?\???t???O', |
||
| 279 | `StartDate` datetime NOT NULL COMMENT '?J?n???t', |
||
| 280 | `CompDate` datetime NOT NULL COMMENT '?I?????t', |
||
| 281 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 282 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 283 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 284 | PRIMARY KEY (`DepartmentCode`), |
||
| 285 | KEY `DepartmentMaster_index1` (`DisplayOrder`) |
||
| 286 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????}?X?^'; |
||
| 287 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 288 | |||
| 289 | --
|
||
| 290 | -- Dumping data for table `departmentmaster`
|
||
| 291 | --
|
||
| 292 | |||
| 293 | LOCK TABLES `departmentmaster` WRITE; |
||
| 294 | /*!40000 ALTER TABLE `departmentmaster` DISABLE KEYS */;
|
||
| 295 | 487 | h-you | 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'); |
| 296 | 461 | h-you | /*!40000 ALTER TABLE `departmentmaster` ENABLE KEYS */;
|
| 297 | UNLOCK TABLES;
|
||
| 298 | |||
| 299 | --
|
||
| 300 | -- Table structure for table `divisionmaster`
|
||
| 301 | --
|
||
| 302 | |||
| 303 | DROP TABLE IF EXISTS `divisionmaster`; |
||
| 304 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 305 | /*!40101 SET character_set_client = utf8 */;
|
||
| 306 | CREATE TABLE `divisionmaster` ( |
||
| 307 | `DivisionCode` decimal(5,0) unsigned NOT NULL COMMENT '???R?[?h', |
||
| 308 | `NameCode` decimal(5,0) unsigned NOT NULL COMMENT '????R?[?h', |
||
| 309 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 310 | `NameString` varchar(100) NOT NULL DEFAULT '' COMMENT '????', |
||
| 311 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 312 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 313 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 314 | PRIMARY KEY (`DivisionCode`,`NameCode`) |
||
| 315 | 487 | h-you | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='???}?X?^'; |
| 316 | 461 | h-you | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 317 | |||
| 318 | --
|
||
| 319 | -- Dumping data for table `divisionmaster`
|
||
| 320 | --
|
||
| 321 | |||
| 322 | LOCK TABLES `divisionmaster` WRITE; |
||
| 323 | /*!40000 ALTER TABLE `divisionmaster` DISABLE KEYS */;
|
||
| 324 | 487 | h-you | 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'); |
| 325 | 461 | h-you | /*!40000 ALTER TABLE `divisionmaster` ENABLE KEYS */;
|
| 326 | UNLOCK TABLES;
|
||
| 327 | |||
| 328 | --
|
||
| 329 | -- Table structure for table `monthmaster`
|
||
| 330 | --
|
||
| 331 | |||
| 332 | DROP TABLE IF EXISTS `monthmaster`; |
||
| 333 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 334 | /*!40101 SET character_set_client = utf8 */;
|
||
| 335 | CREATE TABLE `monthmaster` ( |
||
| 336 | `month` smallint(6) NOT NULL COMMENT '??', |
||
| 337 | PRIMARY KEY (`month`) |
||
| 338 | 487 | h-you | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='???}?X?^'; |
| 339 | 461 | h-you | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 340 | |||
| 341 | --
|
||
| 342 | -- Dumping data for table `monthmaster`
|
||
| 343 | --
|
||
| 344 | |||
| 345 | LOCK TABLES `monthmaster` WRITE; |
||
| 346 | /*!40000 ALTER TABLE `monthmaster` DISABLE KEYS */;
|
||
| 347 | INSERT INTO `monthmaster` VALUES (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11),(12); |
||
| 348 | /*!40000 ALTER TABLE `monthmaster` ENABLE KEYS */;
|
||
| 349 | UNLOCK TABLES;
|
||
| 350 | |||
| 351 | --
|
||
| 352 | 487 | h-you | -- Table structure for table `persondepartmentmaster`
|
| 353 | --
|
||
| 354 | |||
| 355 | DROP TABLE IF EXISTS `persondepartmentmaster`; |
||
| 356 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 357 | /*!40101 SET character_set_client = utf8 */;
|
||
| 358 | CREATE TABLE `persondepartmentmaster` ( |
||
| 359 | `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h', |
||
| 360 | `DepartmentCode` decimal(5,0) unsigned NOT NULL COMMENT '?????R?[?h', |
||
| 361 | `AffiliationFlg` decimal(1,0) NOT NULL COMMENT '?????t???O', |
||
| 362 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 363 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 364 | PRIMARY KEY (`PersonCode`,`DepartmentCode`), |
||
| 365 | KEY `PersonDepartmentMaster_Index1` (`PersonCode`), |
||
| 366 | KEY `PersonDepartmentMaster_Index2` (`DepartmentCode`) |
||
| 367 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S??????????}?X?^'; |
||
| 368 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 369 | |||
| 370 | --
|
||
| 371 | -- Dumping data for table `persondepartmentmaster`
|
||
| 372 | --
|
||
| 373 | |||
| 374 | LOCK TABLES `persondepartmentmaster` WRITE; |
||
| 375 | /*!40000 ALTER TABLE `persondepartmentmaster` DISABLE KEYS */;
|
||
| 376 | INSERT INTO `persondepartmentmaster` VALUES (20181001,1,1,'2020-09-29 16:26:56','2020-09-29 16:26:56'); |
||
| 377 | /*!40000 ALTER TABLE `persondepartmentmaster` ENABLE KEYS */;
|
||
| 378 | UNLOCK TABLES;
|
||
| 379 | |||
| 380 | --
|
||
| 381 | 461 | h-you | -- Table structure for table `personinchargemaster`
|
| 382 | --
|
||
| 383 | |||
| 384 | DROP TABLE IF EXISTS `personinchargemaster`; |
||
| 385 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 386 | /*!40101 SET character_set_client = utf8 */;
|
||
| 387 | CREATE TABLE `personinchargemaster` ( |
||
| 388 | `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h', |
||
| 389 | `DisplayOrder` decimal(8,0) unsigned NOT NULL COMMENT '?\????', |
||
| 390 | `PersonName` varchar(60) NOT NULL COMMENT '?S?????', |
||
| 391 | `PersonNameKana` varchar(60) DEFAULT NULL COMMENT '?t???K?i', |
||
| 392 | `Sex` decimal(1,0) DEFAULT '0' COMMENT '????', |
||
| 393 | `BloodType` varchar(6) DEFAULT NULL COMMENT '???t?^', |
||
| 394 | `Birthday` date NOT NULL COMMENT '???N????', |
||
| 395 | `ZipCode` varchar(8) DEFAULT NULL COMMENT '?X????', |
||
| 396 | `Address1` varchar(60) DEFAULT NULL COMMENT '???Z??1', |
||
| 397 | `Address2` varchar(60) DEFAULT NULL COMMENT '???Z??2', |
||
| 398 | `Address3` varchar(60) DEFAULT NULL COMMENT '???Z??3', |
||
| 399 | `PhoneNumber` varchar(13) DEFAULT NULL COMMENT '?A????d?b???', |
||
| 400 | `EmgPhoneNumber` varchar(13) DEFAULT NULL COMMENT '??}?A????d?b???', |
||
| 401 | `EmgContact` varchar(60) DEFAULT NULL COMMENT '??}?A????', |
||
| 402 | `StartDate` date NOT NULL COMMENT '????N????', |
||
| 403 | `EndDate` date DEFAULT NULL COMMENT '???N????', |
||
| 404 | `PassWord` varchar(16) DEFAULT NULL COMMENT '?p?X???[?h', |
||
| 405 | `SecurityManagement` decimal(1,0) NOT NULL COMMENT '?@????', |
||
| 406 | `SecCode` decimal(2,0) unsigned NOT NULL COMMENT '???????', |
||
| 407 | `MsgBackColor` varchar(8) DEFAULT NULL COMMENT '???b?Z?[?W?w?i?F', |
||
| 408 | `DisplayString` varchar(20) DEFAULT NULL COMMENT '??E????', |
||
| 409 | `DepartmentCode` decimal(5,0) unsigned DEFAULT NULL COMMENT '?????R?[?h', |
||
| 410 | `MonthlySalary` decimal(11,0) NOT NULL COMMENT '???????z', |
||
| 411 | `YearSalary` decimal(12,0) NOT NULL COMMENT '?N????z', |
||
| 412 | `Qualification` varchar(120) DEFAULT NULL COMMENT '???i?????', |
||
| 413 | `SealPrintName` varchar(5) DEFAULT NULL COMMENT '???\????', |
||
| 414 | `EmployeeClassFlg` decimal(1,0) NOT NULL COMMENT '?????', |
||
| 415 | `LedgerFlg` decimal(1,0) NOT NULL COMMENT '???v?Z???t???O', |
||
| 416 | `CommutingDistance` decimal(5,2) NOT NULL COMMENT '??????', |
||
| 417 | `CommuteCosts` decimal(5,0) NOT NULL COMMENT '??????', |
||
| 418 | `PaidVacationDays` decimal(4,1) NOT NULL COMMENT '???N?x?L???x?????', |
||
| 419 | `PaidVacationDaysPrev` decimal(4,1) NOT NULL COMMENT '?O?N?x?L???x?????', |
||
| 420 | `WorkingCode` decimal(3,0) unsigned NOT NULL COMMENT '?A??R?[?h', |
||
| 421 | `PaidDayOffFlg` decimal(1,0) unsigned NOT NULL COMMENT '?L?????t???O', |
||
| 422 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 423 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 424 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 425 | PRIMARY KEY (`PersonCode`), |
||
| 426 | KEY `PersonInChargeMaster_Index1` (`StartDate`), |
||
| 427 | KEY `PersonInChargeMaster_Index2` (`DepartmentCode`) |
||
| 428 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='?S????}?X?^'; |
||
| 429 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 430 | |||
| 431 | --
|
||
| 432 | -- Dumping data for table `personinchargemaster`
|
||
| 433 | --
|
||
| 434 | |||
| 435 | LOCK TABLES `personinchargemaster` WRITE; |
||
| 436 | /*!40000 ALTER TABLE `personinchargemaster` DISABLE KEYS */;
|
||
| 437 | 487 | h-you | 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'); |
| 438 | 461 | h-you | /*!40000 ALTER TABLE `personinchargemaster` ENABLE KEYS */;
|
| 439 | UNLOCK TABLES;
|
||
| 440 |
|
||
| 441 | 487 | h-you |
|
| 442 | 461 | h-you | --
|
| 443 | 487 | h-you | -- Dumping data for table `personqualification`
|
| 444 | --
|
||
| 445 |
|
||
| 446 | LOCK TABLES `personqualification` WRITE;
|
||
| 447 | /*!40000 ALTER TABLE `personqualification` DISABLE KEYS */;
|
||
| 448 | /*!40000 ALTER TABLE `personqualification` ENABLE KEYS */;
|
||
| 449 | UNLOCK TABLES;
|
||
| 450 |
|
||
| 451 | --
|
||
| 452 | -- Table structure for table `personsalarymaster`
|
||
| 453 | --
|
||
| 454 |
|
||
| 455 | DROP TABLE IF EXISTS `personsalarymaster`;
|
||
| 456 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 457 | /*!40101 SET character_set_client = utf8 */;
|
||
| 458 | CREATE TABLE `personsalarymaster` (
|
||
| 459 | `PersonCode` decimal(8,0) unsigned NOT NULL COMMENT '?S????R?[?h', |
||
| 460 | `StartDate` date NOT NULL COMMENT '?g?p?J?n?N????', |
||
| 461 | `MonthlySalary` decimal(11,0) NOT NULL COMMENT '???????z', |
||
| 462 | `YearSalary` decimal(12,0) NOT NULL COMMENT '?N????z', |
||
| 463 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 464 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 465 | PRIMARY KEY (`PersonCode`,`StartDate`),
|
||
| 466 | KEY `PersonSalaryMaster_Index1` (`PersonCode`),
|
||
| 467 | KEY `PersonSalaryMaster_Index2` (`StartDate`),
|
||
| 468 | KEY `PersonSalaryMaster_Index3` (`MonthlySalary`)
|
||
| 469 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?S??????^?}?X?^'; |
||
| 470 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 471 |
|
||
| 472 | --
|
||
| 473 | -- Dumping data for table `personsalarymaster`
|
||
| 474 | --
|
||
| 475 |
|
||
| 476 | LOCK TABLES `personsalarymaster` WRITE;
|
||
| 477 | /*!40000 ALTER TABLE `personsalarymaster` DISABLE KEYS */;
|
||
| 478 | INSERT INTO `personsalarymaster` VALUES (20181001,'2020-01-01',0,0,'2020-09-29 16:26:56','2020-09-29 16:26:56'); |
||
| 479 | /*!40000 ALTER TABLE `personsalarymaster` ENABLE KEYS */;
|
||
| 480 | UNLOCK TABLES;
|
||
| 481 |
|
||
| 482 | --
|
||
| 483 | 461 | h-you | -- Table structure for table `processexcutemaster`
|
| 484 | --
|
||
| 485 |
|
||
| 486 | DROP TABLE IF EXISTS `processexcutemaster`;
|
||
| 487 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 488 | /*!40101 SET character_set_client = utf8 */;
|
||
| 489 | CREATE TABLE `processexcutemaster` (
|
||
| 490 | `SecCode` decimal(2,0) unsigned NOT NULL COMMENT '???????', |
||
| 491 | `ExecCode` decimal(4,0) unsigned NOT NULL COMMENT '?N?????????', |
||
| 492 | `EditFlg` decimal(1,0) NOT NULL COMMENT '??W?t???O', |
||
| 493 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 494 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 495 | PRIMARY KEY (`SecCode`,`ExecCode`),
|
||
| 496 | KEY `ProcessExcuteMaster_Index1` (`SecCode`),
|
||
| 497 | KEY `ProcessExcuteMaster_Index2` (`ExecCode`)
|
||
| 498 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?N?????}?X?^'; |
||
| 499 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 500 |
|
||
| 501 | --
|
||
| 502 | -- Dumping data for table `processexcutemaster`
|
||
| 503 | --
|
||
| 504 |
|
||
| 505 | LOCK TABLES `processexcutemaster` WRITE;
|
||
| 506 | /*!40000 ALTER TABLE `processexcutemaster` DISABLE KEYS */;
|
||
| 507 | 487 | h-you | 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'); |
| 508 | 461 | h-you | /*!40000 ALTER TABLE `processexcutemaster` ENABLE KEYS */;
|
| 509 | UNLOCK TABLES;
|
||
| 510 |
|
||
| 511 | --
|
||
| 512 | 487 | h-you | -- Table structure for table `securitymaster`
|
| 513 | --
|
||
| 514 |
|
||
| 515 | DROP TABLE IF EXISTS `securitymaster`;
|
||
| 516 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 517 | /*!40101 SET character_set_client = utf8 */;
|
||
| 518 | CREATE TABLE `securitymaster` (
|
||
| 519 | `SecCode` decimal(4,0) unsigned NOT NULL COMMENT '???????', |
||
| 520 | `DisplayOrder` decimal(4,0) NOT NULL COMMENT '?\????', |
||
| 521 | `SecName` varchar(60) NOT NULL COMMENT '????????', |
||
| 522 | `SecRank` decimal(1,0) NOT NULL COMMENT '?????????N', |
||
| 523 | `SecRange` decimal(1,0) NOT NULL COMMENT '???????', |
||
| 524 | `GeneralAffairs` decimal(1,0) NOT NULL COMMENT '????????t???O', |
||
| 525 | `SelectBackColor` varchar(8) NOT NULL COMMENT '?I??w?i?F', |
||
| 526 | `DeleteFlg` decimal(1,0) NOT NULL COMMENT '???t???O', |
||
| 527 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 528 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 529 | PRIMARY KEY (`SecCode`),
|
||
| 530 | KEY `SecurityMaster_Index1` (`DisplayOrder`),
|
||
| 531 | KEY `SecurityMaster_Index2` (`SecRank`),
|
||
| 532 | KEY `SecurityMaster_Index3` (`SecRange`)
|
||
| 533 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?????}?X?^'; |
||
| 534 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 535 |
|
||
| 536 | --
|
||
| 537 | -- Dumping data for table `securitymaster`
|
||
| 538 | --
|
||
| 539 |
|
||
| 540 | LOCK TABLES `securitymaster` WRITE;
|
||
| 541 | /*!40000 ALTER TABLE `securitymaster` DISABLE KEYS */;
|
||
| 542 | INSERT INTO `securitymaster` VALUES (1,1,'??\',1,1,1,'0x000000',0,'2020-09-29 16:25:38','2020-09-29 16:25:47'); |
||
| 543 | /*!40000 ALTER TABLE `securitymaster` ENABLE KEYS */;
|
||
| 544 | UNLOCK TABLES;
|
||
| 545 |
|
||
| 546 | --
|
||
| 547 | 461 | h-you | -- Table structure for table `systemexecute`
|
| 548 | --
|
||
| 549 |
|
||
| 550 | DROP TABLE IF EXISTS `systemexecute`;
|
||
| 551 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 552 | /*!40101 SET character_set_client = utf8 */;
|
||
| 553 | CREATE TABLE `systemexecute` (
|
||
| 554 | `PrimaryCode` tinyint(4) NOT NULL COMMENT '?L?[????', |
||
| 555 | `TargetDate` date NOT NULL COMMENT '?N?????t', |
||
| 556 | `SystemVersion` int(11) NOT NULL COMMENT '?{??E????o?[?W????', |
||
| 557 | `UpDateCopyVersion` int(11) NOT NULL COMMENT '?R?s?[?o?[?W????', |
||
| 558 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 559 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 560 | PRIMARY KEY (`PrimaryCode`)
|
||
| 561 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?V?X?e???N???m?F?f?[?^'; |
||
| 562 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 563 |
|
||
| 564 | --
|
||
| 565 | -- Dumping data for table `systemexecute`
|
||
| 566 | --
|
||
| 567 |
|
||
| 568 | LOCK TABLES `systemexecute` WRITE;
|
||
| 569 | /*!40000 ALTER TABLE `systemexecute` DISABLE KEYS */;
|
||
| 570 | 487 | h-you | 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'); |
| 571 | 461 | h-you | /*!40000 ALTER TABLE `systemexecute` ENABLE KEYS */;
|
| 572 | UNLOCK TABLES;
|
||
| 573 | 487 | h-you |
|
| 574 | 461 | h-you | --
|
| 575 | -- Table structure for table `systemmaster`
|
||
| 576 | --
|
||
| 577 |
|
||
| 578 | DROP TABLE IF EXISTS `systemmaster`;
|
||
| 579 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 580 | /*!40101 SET character_set_client = utf8 */;
|
||
| 581 | CREATE TABLE `systemmaster` (
|
||
| 582 | `SystemCode` decimal(3,0) unsigned NOT NULL COMMENT '???R?[?h', |
||
| 583 | `CompanyName1` varchar(60) NOT NULL COMMENT '?????P', |
||
| 584 | `CompanyName2` varchar(60) DEFAULT NULL COMMENT '?????Q', |
||
| 585 | `CEOName` varchar(60) NOT NULL COMMENT '??\?????', |
||
| 586 | `CEOPositionName` varchar(60) DEFAULT NULL COMMENT '??\???E??', |
||
| 587 | `ZipCode` varchar(8) NOT NULL COMMENT '?X????', |
||
| 588 | `Address1` varchar(60) NOT NULL COMMENT '?Z???P', |
||
| 589 | `Address2` varchar(60) DEFAULT NULL COMMENT '?Z??2', |
||
| 590 | `Address3` varchar(60) DEFAULT NULL COMMENT '?Z??3', |
||
| 591 | `PhoneNumber` varchar(13) NOT NULL COMMENT '?d?b???', |
||
| 592 | `FaxNumber` varchar(13) DEFAULT NULL COMMENT 'FAX???', |
||
| 593 | `HomePageURL` varchar(120) DEFAULT NULL COMMENT '?z?[???y?[?WURL', |
||
| 594 | `ConsumptionTax` decimal(4,2) NOT NULL COMMENT '?????', |
||
| 595 | `CooperationRate` decimal(4,2) NOT NULL COMMENT '???????', |
||
| 596 | `StatutoryWelfareRate` decimal(4,2) NOT NULL COMMENT '?@???????', |
||
| 597 | `FuelPrice` decimal(5,2) NOT NULL COMMENT '?R???L???P??', |
||
| 598 | `AreaDistance` decimal(5,2) NOT NULL COMMENT '????u????????', |
||
| 599 | `ExcelSavePath` varchar(120) DEFAULT NULL COMMENT 'Excel????p?X', |
||
| 600 | `BusinessPeriod` smallint(6) NOT NULL COMMENT '????c?????', |
||
| 601 | `ConstrYear` smallint(6) NOT NULL COMMENT '????H???N?x', |
||
| 602 | `BusinessBeginDate` datetime NOT NULL COMMENT '?c????????', |
||
| 603 | `ConstrBeginDate` datetime NOT NULL COMMENT '?H???N?x?????', |
||
| 604 | `BusinessCompDate` datetime NOT NULL COMMENT '?c?????????', |
||
| 605 | `ConstrCompDate` datetime NOT NULL COMMENT '?H???N?x??????', |
||
| 606 | `ConstructionNoBase` decimal(1,0) NOT NULL COMMENT '?H????????l', |
||
| 607 | `SloganString1` varchar(100) DEFAULT NULL COMMENT '?W??1', |
||
| 608 | `SloganString2` varchar(100) DEFAULT NULL COMMENT '?W??2', |
||
| 609 | `SloganString3` varchar(100) DEFAULT NULL COMMENT '?W??3', |
||
| 610 | `OperationFlg` decimal(2,0) unsigned NOT NULL COMMENT '???F?^?p?t???O', |
||
| 611 | 487 | h-you | `SystemOpenTime` datetime NOT NULL COMMENT '?^?p?J?n????', |
| 612 | `SystemCloseTime` datetime NOT NULL COMMENT '?^?p?I??????', |
||
| 613 | `PesrsonCost1` decimal(7,0) unsigned NOT NULL COMMENT '???l????P?i?w?????R?X?g?j', |
||
| 614 | `PesrsonCost2` decimal(7,0) unsigned NOT NULL COMMENT '???l????Q?i???S????R?X?g?j', |
||
| 615 | 461 | h-you | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
| 616 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 617 | PRIMARY KEY (`SystemCode`)
|
||
| 618 | 487 | h-you | ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='????}?X?^'; |
| 619 | 461 | h-you | /*!40101 SET character_set_client = @saved_cs_client */;
|
| 620 |
|
||
| 621 | --
|
||
| 622 | -- Dumping data for table `systemmaster`
|
||
| 623 | --
|
||
| 624 |
|
||
| 625 | LOCK TABLES `systemmaster` WRITE;
|
||
| 626 | /*!40000 ALTER TABLE `systemmaster` DISABLE KEYS */;
|
||
| 627 | 487 | h-you | 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'); |
| 628 | 461 | h-you | /*!40000 ALTER TABLE `systemmaster` ENABLE KEYS */;
|
| 629 | UNLOCK TABLES;
|
||
| 630 |
|
||
| 631 | --
|
||
| 632 | -- Table structure for table `unitmaster`
|
||
| 633 | --
|
||
| 634 |
|
||
| 635 | DROP TABLE IF EXISTS `unitmaster`;
|
||
| 636 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 637 | /*!40101 SET character_set_client = utf8 */;
|
||
| 638 | CREATE TABLE `unitmaster` (
|
||
| 639 | `UnitKey` decimal(5,0) unsigned NOT NULL COMMENT '?P??L?[', |
||
| 640 | `DisplayOrder` decimal(5,0) unsigned NOT NULL COMMENT '?\????', |
||
| 641 | `UnitName` varchar(30) NOT NULL COMMENT '?P?????', |
||
| 642 | `EntryDate` datetime NOT NULL COMMENT '?o?^???t', |
||
| 643 | `UpdateDate` datetime NOT NULL COMMENT '?X?V???t', |
||
| 644 | PRIMARY KEY (`UnitKey`),
|
||
| 645 | KEY `UnitMaster_Index1` (`DisplayOrder`)
|
||
| 646 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?P??}?X?^'; |
||
| 647 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 648 |
|
||
| 649 | --
|
||
| 650 | -- Dumping data for table `unitmaster`
|
||
| 651 | --
|
||
| 652 |
|
||
| 653 | LOCK TABLES `unitmaster` WRITE;
|
||
| 654 | /*!40000 ALTER TABLE `unitmaster` DISABLE KEYS */;
|
||
| 655 | 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'); |
||
| 656 | /*!40000 ALTER TABLE `unitmaster` ENABLE KEYS */;
|
||
| 657 | UNLOCK TABLES;
|
||
| 658 |
|
||
| 659 | --
|
||
| 660 | -- Table structure for table `yearmaster`
|
||
| 661 | --
|
||
| 662 |
|
||
| 663 | DROP TABLE IF EXISTS `yearmaster`;
|
||
| 664 | /*!40101 SET @saved_cs_client = @@character_set_client */;
|
||
| 665 | /*!40101 SET character_set_client = utf8 */;
|
||
| 666 | CREATE TABLE `yearmaster` (
|
||
| 667 | `years` smallint(6) NOT NULL COMMENT '?N', |
||
| 668 | PRIMARY KEY (`years`)
|
||
| 669 | ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='?N?}?X?^'; |
||
| 670 | /*!40101 SET character_set_client = @saved_cs_client */;
|
||
| 671 |
|
||
| 672 | --
|
||
| 673 | -- Dumping data for table `yearmaster`
|
||
| 674 | --
|
||
| 675 |
|
||
| 676 | LOCK TABLES `yearmaster` WRITE;
|
||
| 677 | /*!40000 ALTER TABLE `yearmaster` DISABLE KEYS */;
|
||
| 678 | 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);
|
||
| 679 | /*!40000 ALTER TABLE `yearmaster` ENABLE KEYS */;
|
||
| 680 | UNLOCK TABLES;
|
||
| 681 | |