Index: ProcessManagement.sql
===================================================================
--- ProcessManagement.sql	(revision 467)
+++ ProcessManagement.sql	(revision 468)
@@ -1,5 +1,5 @@
 -- Project Name : noname
--- Date/Time    : 2019/11/21 17:23:43
+-- Date/Time    : 2019/12/07 16:08:48
 -- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
@@ -11,10 +11,10 @@
 */
 
 -- ’S“–ŽÒ�s“®—\’èƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists actionscheduledata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table actionscheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
   , PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
@@ -37,10 +37,10 @@
   on actionscheduledata(TargetDay);
 
 -- �³”FŒo˜Hƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists approvalmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table approvalmaster (
   ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
   , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -54,10 +54,10 @@
 ) comment '�³”FŒo˜Hƒ}ƒXƒ^' ;
 
 -- �o‹Î“ú•ñƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists attendancedailydata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table attendancedailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -83,10 +83,10 @@
   on attendancedailydata(AttendanceDate);
 
 -- �o‹ÎŠÇ—�ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists attendancedata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table attendancedata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceMonth decimal(6,0) unsigned not null comment '�o‹ÎŠÇ—�”NŒŽ'
@@ -111,10 +111,10 @@
 ) comment '�o‹ÎŠÇ—�ƒf�[ƒ^' ;
 
 -- ‹Î‘Ó“Í�oƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists attendancenotice cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table attendancenotice (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
@@ -137,10 +137,10 @@
 ) comment '‹Î‘Ó“Í�oƒf�[ƒ^' ;
 
 -- ‹Î‘Ó“Í�o•R•t‚¯ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists attendancenoticelink cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table attendancenoticelink (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
@@ -172,10 +172,10 @@
   on attendancenoticelink(SeqNo);
 
 -- ‹Î‘Ó“Í�o�HŽ–ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists attnoticeconstrction cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table attnoticeconstrction (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
@@ -189,10 +189,10 @@
 ) comment '‹Î‘Ó“Í�o�HŽ–ƒf�[ƒ^' ;
 
 -- —L‹‹‹x‰É�Á‰»•R•tƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists attnpaidholidyalink cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table attnpaidholidyalink (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
@@ -207,10 +207,10 @@
 ) comment '—L‹‹‹x‰É�Á‰»•R•tƒf�[ƒ^' ;
 
 -- ‹â�s‰c‹Æ“úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bankbusinessdaymaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bankbusinessdaymaster (
   YEARMONTH decimal(6,0) default '0' not null comment '”NŒŽ'
   , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '‹â�s‰c‹Æ“ú'
@@ -222,10 +222,10 @@
 ) comment '‹â�s‰c‹Æ“úƒ}ƒXƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists billingdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table billingdata (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -237,10 +237,10 @@
 ) comment '‹ÆŽÒ�¿‹�ƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists billingdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table billingdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -289,10 +289,10 @@
   on billingdatadetail(CONSTRUCTIONCOLCNT);
 
 -- ‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists billingpaymentsummary cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table billingpaymentsummary (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -313,10 +313,10 @@
 ) comment '‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^' ;
 
 -- ‰^‰cŠú—š—ð�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bizperiodhistory cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bizperiodhistory (
   PeriodYear smallint(6) not null comment '‰c‹ÆŠú�”�E�HŽ–”N“x'
   , PeriodFlag smallint(1) not null comment '‰c‹ÆŠú�”�E�HŽ–”N“xƒtƒ‰ƒO'
@@ -328,10 +328,10 @@
 ) comment '‰^‰cŠú—š—ð�î•ñ' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bk_constructionledger cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bk_constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
@@ -357,10 +357,10 @@
 ) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bk_constructionledgerdetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bk_constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -394,10 +394,10 @@
 ) comment '�HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bk_constructionledgerexcute cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bk_constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -411,10 +411,10 @@
 ) comment '�HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bk_estimatedata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bk_estimatedata (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -433,10 +433,10 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bk_estimatedatabody cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bk_estimatedatabody (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -454,10 +454,10 @@
 ) comment '�ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists bk_estimatedatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table bk_estimatedatadetail (
   SaveDate datetime not null comment '‘Þ”ð“ú•t'
   , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
@@ -483,10 +483,10 @@
 ) comment '�ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z' ;
 
 -- —\ŽZ�‘�WŒvƒR�[ƒhƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists budgetsumcode cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table budgetsumcode (
   BlockCode decimal(2,0) unsigned not null comment 'ƒuƒ�ƒbƒN”Ô�†'
   , GroupCode decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -499,10 +499,10 @@
 ) comment '—\ŽZ�‘�WŒvƒR�[ƒhƒ}ƒXƒ^' ;
 
 -- –@�lŠiƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists businesstypemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table businesstypemaster (
   BusinessTypeCode decimal(5,0) unsigned not null comment '–@�lŠiƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -516,10 +516,10 @@
   on businesstypemaster(DisplayOrder);
 
 -- ’S“–ŽÒ•”��—š—ðƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists chgchargedep cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table chgchargedep (
   PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
   , StartDate date not null comment 'ŠJŽn”NŒŽ“ú'
@@ -532,10 +532,10 @@
 ) comment '’S“–ŽÒ•”��—š—ðƒf�[ƒ^' ;
 
 -- �HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists chgconstrcharge cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table chgconstrcharge (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , Division decimal(1,0) not null comment '�Ý’è‹æ•ª'
@@ -552,10 +552,10 @@
 ) comment '�HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^' ;
 
 -- Web-EDI’÷‚ß“úƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists closingdateofmonth cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table closingdateofmonth (
   TARGETDATE decimal(6,0) unsigned default '0' not null comment '‘Î�Û”NŒŽ'
   , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
@@ -568,10 +568,10 @@
 ) comment 'Web-EDI’÷‚ß“úƒf�[ƒ^' ;
 
 -- ‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists commoncostlarge cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table commoncostlarge (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -584,10 +584,10 @@
 ) comment '‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists commoncostlinkms cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table commoncostlinkms (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
@@ -598,10 +598,10 @@
 ) comment '‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists commoncostmiddle cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table commoncostmiddle (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
@@ -615,10 +615,10 @@
 ) comment '‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^' ;
 
 -- ‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists commoncostmiddlesearchword cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table commoncostmiddlesearchword (
   LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
   , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
@@ -630,10 +630,10 @@
 ) comment '‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^' ;
 
 -- �\�¬�HŽíŠÖ˜Aƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists componentlinkmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table componentlinkmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -650,10 +650,10 @@
   on componentlinkmaster(ItemCode);
 
 -- �\�¬ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists componentmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table componentmaster (
   ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -671,10 +671,10 @@
   on componentmaster(DisplayOrder);
 
 -- �HŽ–Ží•Ê�E�\�¬ƒŠƒ“ƒNƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists componenttotypemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table componenttotypemaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -691,10 +691,10 @@
   on componenttotypemaster(ComponentCode);
 
 -- �HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constrledgerexpenses cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constrledgerexpenses (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(5,0) not null comment 'Ž}”Ô'
@@ -716,10 +716,10 @@
   on constrledgerexpenses(NameCode);
 
 -- �HŽ–Šî–{�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionbaseinfo cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionbaseinfo (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , TyingFlg decimal(1,0) not null comment '•R•tƒf�[ƒ^ƒtƒ‰ƒO'
@@ -802,10 +802,10 @@
   on constructionbaseinfo(ConstructionPeriod);
 
 -- �HŽ–Šî–{�î•ñ–¾�×
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionbaseinfodetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionbaseinfodetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DetailNo decimal(3,0) not null comment '–¾�×”Ô�†'
@@ -822,10 +822,10 @@
   on constructionbaseinfodetail(DetailNo);
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionbudget cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionbudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , CreatorCode decimal(8,0) not null comment '�ì�¬ŽÒƒR�[ƒh'
@@ -855,10 +855,10 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^' ;
 
 -- �HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionbudgetdetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionbudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -882,10 +882,10 @@
 ) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×' ;
 
 -- �HŽíƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionitemmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionitemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -899,10 +899,10 @@
 ) comment '�HŽíƒ}ƒXƒ^' ;
 
 -- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionledger cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionledger (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
@@ -934,10 +934,10 @@
   on constructionledger(ConstructionEnd);
 
 -- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionledgerdetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionledgerdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -992,10 +992,10 @@
   on constructionledgerdetail(CompanyCode);
 
 -- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionledgerexcute cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionledgerexcute (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -1012,10 +1012,10 @@
   on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
 
 -- �HŽ–ƒŠƒ“ƒN�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionlink cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionlink (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , FluctuationCode decimal(10,0) not null comment 'Žq�HŽ–”Ô�†'
@@ -1035,10 +1035,10 @@
   on constructionlink(LinkType);
 
 -- �HŽ–Ž‘�Þ�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionmaterialinfo cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionmaterialinfo (
   CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '�HŽ–”Ô�†'
   , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
@@ -1053,10 +1053,10 @@
 ) comment '�HŽ–Ž‘�Þ�î•ñ' ;
 
 -- ˆÄŒ��i’»“ú•tƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionprogressdate cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionprogressdate (
   ConstructionCode decimal(10,0) not null comment '�HŽ–”Ô�†'
   , ConstructionStatusFlg decimal(2,0) not null comment '�Ý’è�HŽ–�ó‘Ô'
@@ -1078,10 +1078,10 @@
   on constructionprogressdate(ChangeDate);
 
 -- �ì‹Æƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionspecmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionspecmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
@@ -1100,10 +1100,10 @@
   on constructionspecmaster(DisplayOrder);
 
 -- �ì‹Æ’P‰¿ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructionspecunitprice cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructionspecunitprice (
   ConstructionTypeCode mediumint(8) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
@@ -1119,10 +1119,10 @@
   on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode);
 
 -- �HŽ–Ží•Êƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists constructiontypemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table constructiontypemaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -1131,6 +1131,7 @@
   , RepairFlg decimal(1,0) not null comment '�V’z�E‰ü�Cƒtƒ‰ƒO'
   , SecRank decimal(1,0) not null comment '•ÛŒì‹æ•ªƒ‰ƒ“ƒN'
   , ExpensesLink decimal(1,0) not null comment 'Œo”ïŽg—p‹æ•ª'
+  , CompanyProp decimal(1,0) not null comment 'Ž©ŽÐ�HŽ–‹æ•ª'
   , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
@@ -1138,10 +1139,10 @@
 ) comment '�HŽ–Ží•Êƒ}ƒXƒ^' ;
 
 -- �Á”ï�Åƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists consumptiontax cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table consumptiontax (
   StartDate date not null comment 'Žg—pŠJŽn”NŒŽ“ú'
   , ComplateDate date comment 'Žg—p�I—¹”NŒŽ“ú'
@@ -1153,10 +1154,10 @@
 ) comment '�Á”ï�Åƒf�[ƒ^' ;
 
 -- •”���o”[ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists costdataofdepartment cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table costdataofdepartment (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , ConstrYear smallint(5) unsigned not null comment '�HŽ–Šú�”�E”N�”'
@@ -1176,10 +1177,10 @@
 ) comment '•”���o”[ƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ–ˆŒo”ïƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists costdataofperson cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table costdataofperson (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , ActionDate date not null comment '‘Î�Û“ú•t'
@@ -1208,10 +1209,10 @@
   on costdataofperson(ConstructionCode);
 
 -- ”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists costomerregist cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table costomerregist (
   CreatePersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -1255,10 +1256,10 @@
   on costomerregist(CreateDepartmentCode);
 
 -- “ú•ñƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists dailydataconstruction cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table dailydataconstruction (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1279,10 +1280,10 @@
   on dailydataconstruction(ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (–¾�×)
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists dailydatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table dailydatadetail (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1304,10 +1305,10 @@
   on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists dailydatafield cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table dailydatafield (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1324,10 +1325,10 @@
   on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (Ž‘�Þ)
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists dailydatamaterials cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table dailydatamaterials (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1347,10 +1348,10 @@
   on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists dailydatasubcontractors cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table dailydatasubcontractors (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1367,10 +1368,10 @@
   on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “ú•ñƒf�[ƒ^ (ŽÔ—¼)
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists dailydatavehicles cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table dailydatavehicles (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -1391,10 +1392,10 @@
   on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
 
 -- “úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists daymaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table daymaster (
   days smallint(6) not null comment '“ú'
   , constraint daymaster_PKC primary key (days)
@@ -1401,10 +1402,10 @@
 ) comment '“úƒ}ƒXƒ^' ;
 
 -- ’÷“úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists deadlinemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table deadlinemaster (
   LABOURKIND decimal(1,0) default '0' not null comment 'ŽèŠÔ‹ÆŽÒ‹æ•ª'
   , DEADLINE decimal(2,0) comment '’÷“ú'
@@ -1417,10 +1418,10 @@
 ) comment '’÷“úƒ}ƒXƒ^' ;
 
 -- •”��Œo”ï—¦ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists departmentexpensesmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table departmentexpensesmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
@@ -1435,10 +1436,10 @@
 ) comment '•”��Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- •”��ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists departmentmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table departmentmaster (
   DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -1457,10 +1458,10 @@
   on departmentmaster(DisplayOrder);
 
 -- “ü‹àŠm”F�³”Fƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists depositapprovalinfo cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table depositapprovalinfo (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
   , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1478,10 +1479,10 @@
 ) comment '“ü‹àŠm”F�³”Fƒf�[ƒ^' ;
 
 -- “ü‹àƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists depositdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table depositdata (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
   , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1504,10 +1505,10 @@
 ) comment '“ü‹àƒf�[ƒ^' ;
 
 -- “ü‹à–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists depositdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table depositdatadetail (
   ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
   , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
@@ -1539,10 +1540,10 @@
   on depositdatadetail(ORDERERSDIVISION,ORDERERSCODE,DEPOSITMONTH,SEQNO);
 
 -- ‹æ•ªƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists divisionmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table divisionmaster (
   DivisionCode decimal(5,0) unsigned not null comment '‹æ•ªƒR�[ƒh'
   , NameCode decimal(5,0) unsigned not null comment '–¼�ÌƒR�[ƒh'
@@ -1555,10 +1556,10 @@
 ) comment '‹æ•ªƒ}ƒXƒ^' ;
 
 -- �ÏŽZ—\ŽZ�‘ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists estimatebudget cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table estimatebudget (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionTime decimal(5,2) unsigned not null comment '�HŠú'
@@ -1575,10 +1576,10 @@
 ) comment '�ÏŽZ—\ŽZ�‘ƒf�[ƒ^' ;
 
 -- �ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists estimatebudgetdetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table estimatebudgetdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , GroupCount decimal(2,0) unsigned not null comment 'ƒOƒ‹�[ƒv”Ô�†'
@@ -1598,10 +1599,10 @@
 ) comment '�ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×' ;
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists estimatedata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table estimatedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
@@ -1622,10 +1623,10 @@
   on estimatedata(ConstructionCode,FixedItemCode);
 
 -- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists estimatedatabody cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table estimatedatabody (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
@@ -1645,10 +1646,10 @@
   on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);
 
 -- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists estimatedatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table estimatedatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
@@ -1676,10 +1677,10 @@
   on estimatedatadetail(ConstructionCode,PageCount);
 
 -- Œo”ï—¦ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists expensesmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table expensesmaster (
   DivisionCode smallint(6) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , NameCode smallint(6) not null comment 'Œo”ï–¼�ÌƒR�[ƒh'
@@ -1692,10 +1693,10 @@
 ) comment 'Œo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ‰ïŽÐ‹x“úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists holidaycalendermaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table holidaycalendermaster (
   Holiday date not null comment '‹x“ú'
   , BusinessYear smallint(5) unsigned not null comment '‰c‹Æ”N“x'
@@ -1714,10 +1715,10 @@
   on holidaycalendermaster(TargetDay);
 
 -- ‹ÆŽÒ�¿‹�“ü—Íƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists inputbillingdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table inputbillingdata (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -1735,10 +1736,10 @@
 ) comment '‹ÆŽÒ�¿‹�“ü—Íƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�“ü—Í–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists inputbillingdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table inputbillingdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -1762,10 +1763,10 @@
 ) comment '‹ÆŽÒ�¿‹�“ü—Í–¾�×ƒf�[ƒ^' ;
 
 -- ‹ÆŽÒ�¿‹�“ü—Í�ó‘Ô
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists inputbillingstatus cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table inputbillingstatus (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -1777,10 +1778,10 @@
 ) comment '‹ÆŽÒ�¿‹�“ü—Í�ó‘Ô' ;
 
 -- “ü—ÍŽžŒŸ�õ—š—ð
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists inputsearchlogdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table inputsearchlogdata (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
   , UsedProcessNo decimal(4,0) not null comment 'Žg—p‹@”\”Ô�†'
@@ -1794,10 +1795,10 @@
   on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
 
 -- �¿‹��‘ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists invoicedata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table invoicedata (
   INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
   , ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
@@ -1823,24 +1824,22 @@
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
 -- ƒ��[ƒ‹ƒRƒ“ƒeƒ“ƒcƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists mailcontentsmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table mailcontentsmaster (
   MailDelivery decimal(3,0) not null comment '‘—�M�æ�Ý’è”Ô�†'
   , MailTitle varchar(30) comment 'ƒ��[ƒ‹ƒ^ƒCƒgƒ‹'
   , MailContent varchar(400) comment 'ƒ��[ƒ‹–{•¶'
-  , EntryDate datetime not null comment '“o˜^“ú•t'
-  , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint mailcontentsmaster_PKC primary key (MailDelivery)
 ) comment 'ƒ��[ƒ‹ƒRƒ“ƒeƒ“ƒcƒ}ƒXƒ^' ;
 
 -- Ž‘�Þ�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists materialinfo cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table materialinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
   , MATERIALCOUNT smallint(5) unsigned comment 'Ž‘�Þ�”'
@@ -1852,10 +1851,10 @@
 ) comment 'Ž‘�Þ�î•ñ' ;
 
 -- Ž‘�Þ•i–Úƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists materialitemmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table materialitemmaster (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
   , MATERIALKINDCODE smallint(5) unsigned comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
@@ -1869,10 +1868,10 @@
 ) comment 'Ž‘�Þ•i–Úƒ}ƒXƒ^' ;
 
 -- Ž‘�ÞŽí—Þƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists materialkindmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table materialkindmaster (
   MATERIALKINDCODE smallint(5) unsigned default 0 not null comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
   , MATERIALKINDNAME varchar(40) comment 'Ž‘�ÞŽí—Þ–¼�Ì'
@@ -1884,10 +1883,10 @@
 ) comment 'Ž‘�ÞŽí—Þƒ}ƒXƒ^' ;
 
 -- Ž‘�Þ—š—ð�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists materialrecordinfo cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table materialrecordinfo (
   MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
   , PROCESSDATE date default '0000-00-00' not null comment '�ˆ—�”NŒŽ“ú'
@@ -1904,10 +1903,10 @@
 ) comment 'Ž‘�Þ—š—ð�î•ñ' ;
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists messageboarddata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table messageboarddata (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
   , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
@@ -1936,10 +1935,10 @@
   on messageboarddata(MessageFlag);
 
 -- ŒfŽ¦”Â‘Î�ÛŽÒƒe�[ƒuƒ‹
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists messageboardterget cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table messageboardterget (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
   , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
@@ -1955,10 +1954,10 @@
   on messageboardterget(RecordNumber,BranchNumber);
 
 -- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists messagebrowsinghistory cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table messagebrowsinghistory (
   RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
   , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
@@ -1971,10 +1970,10 @@
 ) comment 'ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð' ;
 
 -- ŒŽƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists monthmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table monthmaster (
   month smallint(6) not null comment 'ŒŽ'
   , constraint monthmaster_PKC primary key (month)
@@ -1981,10 +1980,10 @@
 ) comment 'ŒŽƒ}ƒXƒ^' ;
 
 -- ‚¨’m‚ç‚¹�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists notificationmessage cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table notificationmessage (
   MessageDate datetime not null comment '•\Ž¦”NŒŽ“ú'
   , SeqNo decimal(3,0) unsigned not null comment '˜A”Ô'
@@ -2001,10 +2000,10 @@
 ) comment '‚¨’m‚ç‚¹�î•ñ' ;
 
 -- ‚¨’m‚ç‚¹‰{——�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists notificationmessagebrowsing cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table notificationmessagebrowsing (
   MessageDate datetime not null comment '•\Ž¦”NŒŽ“ú'
   , SeqNo decimal(4,0) unsigned not null comment '˜A”Ô'
@@ -2019,10 +2018,10 @@
   on notificationmessagebrowsing(CompanyCode);
 
 -- ‚¨’m‚ç‚¹‘Î�Û‹ÆŽÒ‘I‘ð�î•ñ
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists notificationmessageselect cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table notificationmessageselect (
   MessageDate datetime not null comment '•\Ž¦”NŒŽ“ú'
   , SeqNo decimal(4,0) unsigned not null comment '˜A”Ô'
@@ -2033,10 +2032,10 @@
 ) comment '‚¨’m‚ç‚¹‘Î�Û‹ÆŽÒ‘I‘ð�î•ñ' ;
 
 -- ”­’�ŽÒƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists orderersmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table orderersmaster (
   OrderCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
   , OrderersCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
@@ -2064,10 +2063,10 @@
 ) comment '”­’�ŽÒƒ}ƒXƒ^' ;
 
 -- Žó’�‹àŠzƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists orderspricedata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table orderspricedata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ChangeNo decimal(3,0) unsigned not null comment '•Ï�X”Ô�†'
@@ -2085,10 +2084,10 @@
 ) comment 'Žó’�‹àŠzƒf�[ƒ^' ;
 
 -- Žx•¥�³”F�î•ñƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists paymentapprovalinfo cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table paymentapprovalinfo (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -2105,10 +2104,10 @@
 ) comment 'Žx•¥�³”F�î•ñƒf�[ƒ^' ;
 
 -- Žx•¥–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists paymentdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table paymentdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , TARGETDATE decimal(6,0) default '0' not null comment '‘Î�Û”NŒŽ'
@@ -2139,10 +2138,10 @@
   on paymentdatadetail(APPROVALPERSONCODE);
 
 -- �HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists periodavoidance cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table periodavoidance (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
@@ -2162,10 +2161,10 @@
   on periodavoidance(FieldNo);
 
 -- ’S“–ŽÒ�³”Fƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists personapproval cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table personapproval (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -2198,10 +2197,10 @@
   on personapproval(PersonCodeApproval);
 
 -- ’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists personapprovalcomment cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table personapprovalcomment (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -2216,10 +2215,10 @@
 ) comment '’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ‘Î�Û•”��ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists persondepartmentmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table persondepartmentmaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
@@ -2236,10 +2235,10 @@
   on persondepartmentmaster(DepartmentCode);
 
 -- ’S“–ŽÒƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists personinchargemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table personinchargemaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
@@ -2288,10 +2287,10 @@
   on personinchargemaster(DepartmentCode);
 
 -- ’S“–ŽÒŽ‘Šiƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists personqualification cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table personqualification (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment 'ƒf�[ƒ^�‡”Ô'
@@ -2306,10 +2305,10 @@
 ) comment '’S“–ŽÒŽ‘Šiƒf�[ƒ^' ;
 
 -- ’S“–ŽÒ‹‹—^ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists personsalarymaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table personsalarymaster (
   PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
   , StartDate date not null comment 'Žg—pŠJŽn”NŒŽ“ú'
@@ -2330,10 +2329,10 @@
   on personsalarymaster(MonthlySalary);
 
 -- ŽwŽ¦Ž–�€ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists pointingoutcomment cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table pointingoutcomment (
   ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
   , ProcessNo smallint(6) not null comment '�ˆ—�”Ô�†�i‰æ–Ê”Ô�†�j'
@@ -2354,10 +2353,10 @@
 ) comment 'ŽwŽ¦Ž–�€ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists proceedingsdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table proceedingsdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
@@ -2372,10 +2371,10 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists proceedingsdataattend cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table proceedingsdataattend (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
@@ -2389,10 +2388,10 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j' ;
 
 -- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists proceedingsdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table proceedingsdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
@@ -2407,10 +2406,10 @@
 ) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j' ;
 
 -- �³”Fƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists processapproval cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table processapproval (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -2427,10 +2426,10 @@
 ) comment '�³”Fƒf�[ƒ^' ;
 
 -- �³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists processapprovalcomment cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table processapprovalcomment (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -2444,10 +2443,10 @@
 ) comment '�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
 
 -- �³”F–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists processapprovaldetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table processapprovaldetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
@@ -2460,10 +2459,10 @@
 ) comment '�³”F–¾�×ƒf�[ƒ^' ;
 
 -- ‹N“®‘Î�Ûƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists processexcutemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table processexcutemaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
   , ExecCode decimal(4,0) unsigned not null comment '‹N“®�ˆ—�”Ô�†'
@@ -2480,10 +2479,10 @@
   on processexcutemaster(ExecCode);
 
 -- ’�•¶�‘ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists purchaseorder cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table purchaseorder (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
@@ -2515,6 +2514,8 @@
   , RePrintFlag decimal(1,0) default '0' not null comment '�Äˆó�ü‰Â”\ƒtƒ‰ƒO�i–¢Žg—p�j'
   , OrderDate date not null comment 'Žó’��EƒLƒƒƒ“ƒZƒ‹”NŒŽ“ú'
   , OrderStatus decimal(1,0) default '0' not null comment 'Žó’��ó‘Ô'
+  , OrderStDate date not null comment '’…�H“ú'
+  , OrderEdDate date not null comment 'Š®—¹“ú'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)
@@ -2521,10 +2522,10 @@
 ) comment '’�•¶�‘ƒf�[ƒ^' ;
 
 -- ’�•¶�‘“ú•tƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists purchaseorderdate cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table purchaseorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
@@ -2538,10 +2539,10 @@
 ) comment '’�•¶�‘“ú•tƒf�[ƒ^' ;
 
 -- ’�•¶�‘–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists purchaseorderdetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table purchaseorderdetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
@@ -2568,10 +2569,10 @@
   on purchaseorderdetail(SourceCode);
 
 -- Ž‘Šiƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists qualificationmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table qualificationmaster (
   DCode decimal(5,0) unsigned not null comment '•ª—Þ‹æ•ª'
   , Qcode decimal(5,0) unsigned not null comment 'Ž‘ŠiƒR�[ƒh'
@@ -2593,10 +2594,10 @@
   on qualificationmaster(DisplayOrder);
 
 -- ƒŒƒR�[ƒh”Ô�†ŠÇ—�
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists recordkey cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table recordkey (
   KeyNo decimal(2,0) unsigned not null comment 'ƒL�[ƒR�[ƒh'
   , RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
@@ -2606,10 +2607,10 @@
 ) comment 'ƒŒƒR�[ƒh”Ô�†ŠÇ—�' ;
 
 -- �¿‹��‘�í�œƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists reminvoicedata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table reminvoicedata (
   InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
   , RemPerson decimal(8,0) not null comment '�í�œ’S“–ŽÒƒR�[ƒh'
@@ -2621,10 +2622,10 @@
 ) comment '�¿‹��‘�í�œƒf�[ƒ^' ;
 
 -- �¿‹��‘�í�œ–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists reminvoicedatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table reminvoicedatadetail (
   InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
   , SeqNo smallint(5) unsigned not null comment '˜A”Ô'
@@ -2635,10 +2636,10 @@
 ) comment '�¿‹��‘�í�œ–¾�×ƒf�[ƒ^' ;
 
 -- �¿‹�Žæ�Áƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists removerequest cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table removerequest (
   RemoveNo decimal(10,0) not null comment 'Žæ�ÁNo'
   , RemoveDate decimal(8,0) not null comment '�¿‹�Žæ�Á“ú'
@@ -2674,10 +2675,10 @@
   on removerequest(ORDERNO);
 
 -- �¿‹�Žæ�Áƒf�[ƒ^–¾�×
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists removerequestdetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table removerequestdetail (
   RemoveNo decimal(10,0) not null comment 'Žæ�ÁNo'
   , SeqNo decimal(9,0) not null comment 'Žó•tno'
@@ -2693,10 +2694,10 @@
 ) comment '�¿‹�Žæ�Áƒf�[ƒ^–¾�×' ;
 
 -- �¿‹�ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists requestdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table requestdata (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
   , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
@@ -2720,10 +2721,10 @@
 ) comment '�¿‹�ƒf�[ƒ^' ;
 
 -- �¿‹�ƒf�[ƒ^–¾�×
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists requestdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table requestdatadetail (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
   , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
@@ -2737,10 +2738,10 @@
 ) comment '�¿‹�ƒf�[ƒ^–¾�×' ;
 
 -- �¿‹�ƒwƒbƒ_
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists requesthead cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table requesthead (
   REQUESTNO decimal(9,0) not null comment '�¿‹�No'
   , REQCONSTRUCTIONCODE decimal(10,0) not null comment '�¿‹��HŽ–”Ô�†'
@@ -2767,10 +2768,10 @@
 alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
 
 -- �¿‹��‘“ú•tƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists requestorderdate cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table requestorderdate (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
@@ -2781,10 +2782,10 @@
 ) comment '�¿‹��‘“ú•tƒf�[ƒ^' ;
 
 -- ”„�ãƒOƒ‰ƒtƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists salesgraphdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table salesgraphdata (
   GraphDataCode decimal(8,0) not null comment 'ƒOƒ‰ƒtƒf�[ƒ^ƒR�[ƒh'
   , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
@@ -2807,10 +2808,10 @@
   on salesgraphdata(ConstructionPeriod);
 
 -- •ÛŒì‹æ•ªƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists securitymaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table securitymaster (
   SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
   , DisplayOrder decimal(2,0) not null comment '•\Ž¦�‡'
@@ -2834,10 +2835,10 @@
   on securitymaster(SecRange);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists sfpdata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table sfpdata (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DataCount decimal(2,0) unsigned not null comment 'ƒpƒgƒ��[ƒ‹‰ñ�”'
@@ -2854,10 +2855,10 @@
   on sfpdata(RequestDate);
 
 -- ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists sfpdatadetail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table sfpdatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
   , DataCount decimal(2,0) unsigned not null comment 'ƒpƒgƒ��[ƒ‹‰ñ�”'
@@ -2869,10 +2870,10 @@
 ) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^' ;
 
 -- ‹¦—Í‰ïŽÐƒ��[ƒ‹‘—�MƒLƒ…�[
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subconmailqueue cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subconmailqueue (
   SeqNo decimal(8,0) default '0' not null comment '˜A”Ô'
   , CompanyCode decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
@@ -2895,10 +2896,10 @@
   on subconmailqueue(Argument0);
 
 -- ‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subconstrjobitemregist cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subconstrjobitemregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -2911,10 +2912,10 @@
 ) comment '‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subconstrjoblinkregist cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subconstrjoblinkregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -2927,10 +2928,10 @@
 ) comment '‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subconstrregist cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subconstrregist (
   PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
   , CreateDate date not null comment '�ì�¬“ú'
@@ -2964,10 +2965,10 @@
 ) comment '‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontractoritemmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontractoritemmaster (
   ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2979,10 +2980,10 @@
 ) comment '‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontractorjobcategory cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontractorjobcategory (
   JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -2994,10 +2995,10 @@
 ) comment '‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^' ;
 
 -- ‹¦—Í‰ïŽÐŽ{�H�HŽíƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontractorjobitem cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontractorjobitem (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
@@ -3014,10 +3015,10 @@
   on subcontractorjobitem(ItemCode);
 
 -- ‹¦—Í‰ïŽÐ�EŽíƒŠƒ“ƒNƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontractorjoblink cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontractorjoblink (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
@@ -3034,10 +3035,10 @@
   on subcontractorjoblink(JobCategoryCode);
 
 -- ‹¦—Í‰ïŽÐƒ��[ƒ‹ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontractormail cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontractormail (
   CompanyCode decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , SeqNo decimal(3,0) default '0' not null comment '˜A”Ô'
@@ -3048,10 +3049,10 @@
 ) comment '‹¦—Í‰ïŽÐƒ��[ƒ‹ƒf�[ƒ^' ;
 
 -- ‹¦—Í‰ïŽÐƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontractormaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontractormaster (
   CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
@@ -3099,10 +3100,10 @@
   on subcontractormaster(JapaneseSyllabary);
 
 -- ‹¦—Í‰ïŽÐƒ��[ƒ‹‘—�M�Ý’è
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists subcontrmaildelivery cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table subcontrmaildelivery (
   CompanyCode decimal(8,0) default '0' not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
   , SeqNo decimal(3,0) default '0' not null comment '˜A”Ô'
@@ -3113,10 +3114,10 @@
 ) comment '‹¦—Í‰ïŽÐƒ��[ƒ‹‘—�M�Ý’è' ;
 
 -- Žd“ü�æƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists suppliersmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table suppliersmaster (
   SuppliersCode decimal(5,0) unsigned not null comment 'Žd“ü�æƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -3136,10 +3137,10 @@
 ) comment 'Žd“ü�æƒ}ƒXƒ^' ;
 
 -- ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists systemexecute cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table systemexecute (
   PrimaryCode tinyint(4) not null comment 'ƒL�[�€–Ú'
   , TargetDate date not null comment '‹N“®“ú•t'
@@ -3151,10 +3152,10 @@
 ) comment 'ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^' ;
 
 -- ŠÇ—�ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists systemmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table systemmaster (
   SystemCode decimal(3,0) unsigned not null comment '‰ïŽÐƒR�[ƒh'
   , CompanyName1 varchar(60) not null comment '‰ïŽÐ–¼‚P'
@@ -3191,10 +3192,10 @@
 ) comment 'ŠÇ—�ƒ}ƒXƒ^' ;
 
 -- ŠúŒÀƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists termmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table termmaster (
   ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
   , FieldNo decimal(2,0) not null comment 'ƒ`ƒFƒbƒN‘Î�ÛƒtƒB�[ƒ‹ƒh”Ô�†'
@@ -3215,10 +3216,10 @@
   on termmaster(DisplayOrder);
 
 -- �o‹ÎŒð’Ê”ïƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists tranceportdailydata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table tranceportdailydata (
   PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
   , AttendanceDate date not null comment '“ú•ñ�ì�¬“ú'
@@ -3239,10 +3240,10 @@
   on tranceportdailydata(AttendanceDate);
 
 -- �HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists typeexpensesmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table typeexpensesmaster (
   TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
   , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
@@ -3255,10 +3256,10 @@
 ) comment '�HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^' ;
 
 -- ’PˆÊƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists unitmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table unitmaster (
   UnitKey decimal(5,0) unsigned not null comment '’PˆÊƒL�['
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -3272,10 +3273,10 @@
   on unitmaster(DisplayOrder);
 
 -- ŽÔ—¼ƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists vehiclemaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table vehiclemaster (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -3303,10 +3304,10 @@
 ) comment 'ŽÔ—¼ƒ}ƒXƒ^' ;
 
 -- ŽÔ—¼‹L˜^ƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists vehiclerecorddata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table vehiclerecorddata (
   VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
   , DivisionCode decimal(2,0) unsigned not null comment 'ƒf�[ƒ^‹æ•ª'
@@ -3321,10 +3322,10 @@
 ) comment 'ŽÔ—¼‹L˜^ƒf�[ƒ^' ;
 
 -- ŽÔ—¼—\–ñƒf�[ƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists vehiclescheduledata cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table vehiclescheduledata (
   TargetDate date not null comment '‘Î�Û“ú'
   , VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
@@ -3348,10 +3349,10 @@
   on vehiclescheduledata(TargetDay);
 
 -- �A‹ÆŽžŠÔƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists workingtime cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table workingtime (
   WorkingCode decimal(3,0) unsigned not null comment '�A‹ÆƒR�[ƒh'
   , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
@@ -3375,10 +3376,10 @@
 ) comment '�A‹ÆŽžŠÔƒ}ƒXƒ^' ;
 
 -- �A‹Æ‹xŒeŽžŠÔƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists workingtimebreak cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table workingtimebreak (
   WorkingCode decimal(3,0) unsigned not null comment '�A‹ÆƒR�[ƒh'
   , BreakNo decimal(2,0) unsigned not null comment '‹xŒe”Ô�†'
@@ -3390,10 +3391,10 @@
 ) comment '�A‹Æ‹xŒeŽžŠÔƒ}ƒXƒ^' ;
 
 -- ”Nƒ}ƒXƒ^
--- BackupToTempTable
+--* BackupToTempTable
 drop table if exists yearmaster cascade;
 
--- RestoreFromTempTable
+--* RestoreFromTempTable
 create table yearmaster (
   years smallint(6) not null comment '”N'
   , constraint yearmaster_PKC primary key (years)
