Index: ProcessManagement.sql
===================================================================
--- ProcessManagement.sql	(revision 460)
+++ ProcessManagement.sql	(revision 461)
@@ -1,5 +1,5 @@
 -- Project Name : noname
--- Date/Time    : 2018/10/23 8:09:34
+-- Date/Time    : 2019/11/21 17:23:43
 -- 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,21 +54,23 @@
 ) 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 '“ú•ñ�ì�¬“ú'
   , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
-  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
-  , ActionResult varchar(30) not null comment '�s“®ŽÀ�Ñ'
+  , ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
+  , ActionResult varchar(100) not null comment '�s“®ŽÀ�Ñ'
   , StartTime datetime comment 'ŠJŽnŽžŠÔ'
   , CompTime datetime comment '�I—¹ŽžŠÔ'
-  , DayTimes decimal(4,1) not null comment '“ú‰Ò“­�‡ŒvŽžŠÔ'
+  , DayTimes decimal(5,2) not null comment '‰Ò“­ŽžŠÔ'
+  , Overtime decimal(5,2) not null comment 'ŽžŠÔŠO�A‹Æ'
+  , OvertimeWA decimal(5,2) not null comment 'Žc‹Æ”F‰ÂŽžŠÔ'
   , WorkingComment varchar(120) comment 'ƒRƒ�ƒ“ƒg'
-  , WorkKindFlg decimal(1,0) not null comment '�ì‹Æ‹æ•ªƒtƒ‰ƒO'
+  , WorkKindFlg decimal(2,0) not null comment '�ì‹Æ‹æ•ªƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)
@@ -81,17 +83,27 @@
   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 date not null comment '�o‹ÎŠÇ—�”NŒŽ'
+  , AttendanceMonth decimal(6,0) unsigned not null comment '�o‹ÎŠÇ—�”NŒŽ'
   , LastDays decimal(2,0) unsigned not null comment '“–ŒŽ�Å�I“ú'
   , AttendDayCount decimal(2,0) unsigned not null comment '�o‹Î“ú�”'
-  , TotalOverTimes decimal(4,1) not null comment 'Žc‹ÆŽžŠÔ�”'
-  , OrderDate date not null comment '�\�¿“ú'
+  , NormalTimes decimal(5,2) not null comment '’Ê�í‹Î–±ŽžŠÔ�”'
+  , OutEarlyTimes decimal(5,2) not null comment '‘��oŽžŠÔ�”'
+  , OverTimes decimal(5,2) not null comment 'Žc‹ÆŽžŠÔ�”'
+  , HolidayWorkTimes decimal(5,2) not null comment '‹x“ú�o‹ÎŽžŠÔ�”'
+  , TransferHolidayTimes decimal(5,2) not null comment '�U‘Ö‹x“ú‰ñ�”'
+  , CompensatoryHolidayTimes decimal(5,2) not null comment '‘ã‹x‰ñ�”'
+  , PaidHolidaysTimes decimal(5,2) not null comment '—L‹‹‹x‰É‰ñ�”'
+  , AbsenceTimes decimal(5,2) not null comment 'Œ‡‹ÎŽžŠÔ�”'
+  , LateTimes decimal(5,2) not null comment '’x��ŽžŠÔ�”'
+  , LeaveEarlyTimes decimal(5,2) not null comment '‘�‘ÞŽžŠÔ�”'
+  , GoOutTimes decimal(5,2) not null comment 'ŠO�oŽžŠÔ�”'
+  , OrderDate decimal(6,0) unsigned not null comment '�\�¿“ú'
   , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
@@ -98,11 +110,107 @@
   , constraint attendancedata_PKC primary key (PersonCode,AttendanceMonth)
 ) comment '�o‹ÎŠÇ—�ƒf�[ƒ^' ;
 
+-- ‹Î‘Ó“Í�oƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists attendancenotice cascade;
+
+-- RestoreFromTempTable
+create table attendancenotice (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
+  , AttendanceMonth decimal(6,0) unsigned not null comment '�o‹ÎŠÇ—�”NŒŽ'
+  , OrderNo decimal(3,0) unsigned not null comment '“Í”Ô�†'
+  , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , HolidayReason decimal(1,0) unsigned not null comment '‹x‚Ý‹æ•ª'
+  , FromDate datetime not null comment 'ŠJŽn“úŽž'
+  , ToDate datetime not null comment '�I—¹“úŽž'
+  , NoticePeriod decimal(5,2) unsigned not null comment '‹Î‘ÓŠúŠÔ“ú'
+  , TransferDay datetime not null comment '�U‘Ö“ú'
+  , Reason varchar(300) comment 'Ž–—R'
+  , Note varchar(300) comment '”õ�l'
+  , ApprovalDate decimal(6,0) unsigned not null comment '�³”F“ú'
+  , ApprovalNo decimal(2,0) unsigned not null comment '�³”FŽó•t”Ô�†'
+  , DeleteFlg decimal(1,0) unsigned not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint attendancenotice_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
+) comment '‹Î‘Ó“Í�oƒf�[ƒ^' ;
+
+-- ‹Î‘Ó“Í�o•R•t‚¯ƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists attendancenoticelink cascade;
+
+-- RestoreFromTempTable
+create table attendancenoticelink (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
+  , AttendanceMonth decimal(6,0) unsigned not null comment '�o‹ÎŠÇ—�”NŒŽ'
+  , OrderNo decimal(3,0) unsigned not null comment '“Í”Ô�†'
+  , DailyDate date not null comment '“ú•ñ�ì�¬“ú'
+  , SeqNo decimal(3,0) unsigned not null comment '“ú•ñ–¾�×�s”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint attendancenoticelink_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo,DailyDate,SeqNo)
+) comment '‹Î‘Ó“Í�o•R•t‚¯ƒf�[ƒ^' ;
+
+create index AttendanceNoticeLink_Index1
+  on attendancenoticelink(PersonCode);
+
+create index AttendanceNoticeLink_Index2
+  on attendancenoticelink(AttendanceNo);
+
+create index AttendanceNoticeLink_Index3
+  on attendancenoticelink(AttendanceMonth);
+
+create index AttendanceNoticeLink_Index4
+  on attendancenoticelink(OrderNo);
+
+create index AttendanceNoticeLink_Index5
+  on attendancenoticelink(DailyDate);
+
+create index AttendanceNoticeLink_Index6
+  on attendancenoticelink(SeqNo);
+
+-- ‹Î‘Ó“Í�o�HŽ–ƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists attnoticeconstrction cascade;
+
+-- RestoreFromTempTable
+create table attnoticeconstrction (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
+  , AttendanceMonth decimal(6,0) unsigned not null comment '�o‹ÎŠÇ—�”NŒŽ'
+  , OrderNo decimal(3,0) unsigned not null comment '“Í”Ô�†'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ConstructionName varchar(300) comment '�HŽ––¼�Ì'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint attnoticeconstrction_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
+) comment '‹Î‘Ó“Í�o�HŽ–ƒf�[ƒ^' ;
+
+-- —L‹‹‹x‰É�Á‰»•R•tƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists attnpaidholidyalink cascade;
+
+-- RestoreFromTempTable
+create table attnpaidholidyalink (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , AttendanceNo decimal(2,0) unsigned not null comment '‹Î‘Ó‹æ•ª'
+  , AttendanceMonth decimal(6,0) unsigned not null comment '�o‹ÎŠÇ—�”NŒŽ'
+  , OrderNo decimal(3,0) unsigned not null comment '“Í”Ô�†'
+  , PreviousYear decimal(3,1) not null comment '‘O”N“x—L‹‹Žæ“¾�”'
+  , CurrentYear decimal(3,1) not null comment '�¡”N“x—L‹‹Žæ“¾�”'
+  , Completed decimal(1,0) unsigned not null comment '�í�œŽž–ß‚µ�Ïƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint attnpaidholidyalink_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
+) comment '—L‹‹‹x‰É�Á‰»•R•tƒf�[ƒ^' ;
+
 -- ‹â�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‹Æ“ú'
@@ -114,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ŒŽ'
@@ -129,34 +237,62 @@
 ) 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ŒŽ'
   , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
   , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , LABOURKIND decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
   , CONSTRUCTIONCODE decimal(10,0) comment '�HŽ–”Ô�†'
-  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '�s”Ô�†'
-  , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '—ñ”Ô�†'
+  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '‘ä’ –¾�×”Ô�†'
+  , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '‘ä’ —ñ”Ô�†'
+  , LinkDataType decimal(1,0) not null comment 'ŠÖ˜A•t‚¯ƒf�[ƒ^ƒ^ƒCƒv'
   , FIELDNAME varchar(120) comment 'Œ»�ê–¼'
   , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
   , HIGHWPRICE decimal(10,0) comment '�‚‘¬‘ã'
   , HARDWPRICE decimal(10,0) comment '‹à•¨‘ã'
   , INDSWASTETAX decimal(10,0) comment 'ŽY”p�Å'
+  , OverFlg decimal(1,0) comment 'Žx•¥’´‰ßƒtƒ‰ƒO'
   , NOTE varchar(120) comment '”õ�l'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
   , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
   , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
-  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
+  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,LABOURKIND)
 ) comment '‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^' ;
 
+create index billingdatadetail_Index1
+  on billingdatadetail(COMPANYCODE);
+
+create index billingdatadetail_Index2
+  on billingdatadetail(TARGETDATE);
+
+create index billingdatadetail_Index3
+  on billingdatadetail(SEQNO);
+
+create index billingdatadetail_Index4
+  on billingdatadetail(LINECOUNT);
+
+create index billingdatadetail_Index5
+  on billingdatadetail(LABOURKIND);
+
+create index billingdatadetail_Index6
+  on billingdatadetail(CONSTRUCTIONCODE);
+
+create index billingdatadetail_Index7
+  on billingdatadetail(CONSTRUCTIONROWCNT);
+
+create index billingdatadetail_Index8
+  on billingdatadetail(CONSTRUCTIONCOLCNT);
+
 -- ‹ÆŽÒ�¿‹�Ž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ŒŽ'
@@ -177,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'
@@ -192,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 'Ž–‹ÆŠú'
@@ -221,14 +357,14 @@
 ) 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”Ô�†'
-  , LineCount decimal(5,0) unsigned not null comment '�s”Ô�†'
+  , LineCount decimal(4,0) unsigned not null comment '�s”Ô�†'
   , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
   , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
   , FirstString varchar(120) comment '�€–Ú–¼�Ì'
@@ -250,6 +386,8 @@
   , JoinTitleFlg decimal(1,0) not null comment '�HŽ––¼�Ìƒ^ƒCƒgƒ‹'
   , SalaryOnRegist decimal(12,0) not null comment '“o˜^ŽžŒŽŠz‹‹—^'
   , PurchaseOrderFlg decimal(2,0) not null comment '’�•¶�‘”­�sƒtƒ‰ƒO'
+  , DetailCount decimal(4,0) unsigned not null comment '–¾�×”Ô�†'
+  , InvalidLine decimal(1,0) not null comment '–³Œø�s'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint bk_constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
@@ -256,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”Ô�†'
@@ -273,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'
@@ -295,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'
@@ -316,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'
@@ -345,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”Ô�†'
@@ -361,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 '•\Ž¦�‡'
@@ -378,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ŒŽ“ú'
@@ -394,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 '�Ý’è‹æ•ª'
@@ -413,11 +551,27 @@
   , constraint chgconstrcharge_PKC primary key (ConstructionCode,Division,SeqNo)
 ) comment '�HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^' ;
 
+-- Web-EDI’÷‚ß“úƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists closingdateofmonth cascade;
+
+-- 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”Ô'
+  , StartDate date comment '“ü—ÍŠJŽn“ú'
+  , CompDate date comment '“ü—ÍŠ®—¹“ú'
+  , PayPlansDate date comment 'Žx•¥—\’è“ú'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint closingdateofmonth_PKC primary key (TARGETDATE,SEQNO)
+) 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 '•\Ž¦�‡'
@@ -430,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�['
@@ -444,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�['
@@ -461,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�['
@@ -476,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�['
@@ -496,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 '•\Ž¦�‡'
@@ -517,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�['
@@ -537,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 'Ž}”Ô'
@@ -562,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'
@@ -623,6 +777,7 @@
   , InspectPlanningDate date not null comment 'ŒŸ�¸—\’è“ú'
   , InspectExecuteDate date not null comment 'ŒŸ�¸ŽÀ�s“ú'
   , RevCompleteDate date not null comment 'ŒŸ�¸�¥�³Š®—¹“ú'
+  , ExpectedOrder decimal(3,0) not null comment 'Žó’�Šú‘Ò“x'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
@@ -647,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 '–¾�×”Ô�†'
@@ -667,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'
@@ -700,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”Ô�†'
@@ -727,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 '•\Ž¦�‡'
@@ -744,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 'Ž–‹ÆŠú'
@@ -779,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”Ô�†'
@@ -809,6 +964,7 @@
   , SalaryOnRegist decimal(12,0) not null comment '“o˜^ŽžŒŽŠz‹‹—^'
   , PurchaseOrderFlg decimal(2,0) not null comment '’�•¶�‘”­�sƒtƒ‰ƒO'
   , DetailCount decimal(4,0) unsigned not null comment '–¾�×”Ô�†'
+  , InvalidLine decimal(1,0) not null comment '–³Œø�s'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
@@ -836,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”Ô�†'
@@ -856,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Ž–”Ô�†'
@@ -879,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'
@@ -897,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Ž–�ó‘Ô'
@@ -922,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�['
@@ -944,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�['
@@ -963,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 '•\Ž¦�‡'
@@ -981,11 +1137,26 @@
   , constraint constructiontypemaster_PKC primary key (TypeCode)
 ) comment '�HŽ–Ží•Êƒ}ƒXƒ^' ;
 
+-- �Á”ï�Åƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists consumptiontax cascade;
+
+-- RestoreFromTempTable
+create table consumptiontax (
+  StartDate date not null comment 'Žg—pŠJŽn”NŒŽ“ú'
+  , ComplateDate date comment 'Žg—p�I—¹”NŒŽ“ú'
+  , TaxRate decimal(4,2) default '0.00' not null comment '�Á”ï�Å—¦'
+  , DeleteFlg decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime comment '“o˜^”NŒŽ“ú'
+  , UpdateDate datetime comment '�X�V”NŒŽ“ú'
+  , constraint consumptiontax_PKC primary key (StartDate)
+) 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�”'
@@ -1005,10 +1176,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'
@@ -1037,10 +1208,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 '�ì�¬“ú'
@@ -1065,7 +1236,7 @@
   , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
   , Note varchar(300) comment '”õ�l'
   , OrderCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
-  , OrderDate date not null comment '�\�¿“ú'
+  , OrderDate decimal(6,0) unsigned not null comment '�\�¿“ú'
   , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
   , CreateDepartmentCode decimal(5,0) unsigned not null comment '�\�¿•”��ƒR�[ƒh'
   , CreateDepartmentName varchar(60) comment '�\�¿•”��–¼'
@@ -1084,10 +1255,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 '“ú•ñ�ì�¬“ú'
@@ -1108,10 +1279,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 '“ú•ñ�ì�¬“ú'
@@ -1133,10 +1304,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 '“ú•ñ�ì�¬“ú'
@@ -1153,10 +1324,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 '“ú•ñ�ì�¬“ú'
@@ -1176,10 +1347,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 '“ú•ñ�ì�¬“ú'
@@ -1196,10 +1367,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 '“ú•ñ�ì�¬“ú'
@@ -1220,10 +1391,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)
@@ -1230,10 +1401,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 '’÷“ú'
@@ -1246,10 +1417,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 'Ž–‹ÆŠú'
@@ -1264,10 +1435,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 '•\Ž¦�‡'
@@ -1286,10 +1457,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'
@@ -1307,10 +1478,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'
@@ -1321,6 +1492,10 @@
   , DEPOSITAMOUNT decimal(12,0) comment '“ü‹à‹àŠz'
   , DEPOSITAMOUNTCASH decimal(10,0) comment '“ü‹à‹àŠz�iŒ»‹à�j'
   , DEPOSITAMOUNTBILL decimal(10,0) comment '“ü‹à‹àŠz�iŽèŒ`�j'
+  , FEES decimal(10,0) comment 'Žè�”—¿'
+  , OTHERADJUSTMENTS decimal(10,0) comment '‘——¿'
+  , CNSTRPRICE decimal(10,0) comment '‹¦—Í‹à'
+  , REMAININGCLEARING decimal(10,0) comment '�Á�žŽc‹àŠz'
   , DEPOSITPERSONCODE decimal(8,0) not null comment '“ü‹à’S“–ŽÒƒR�[ƒh'
   , NOTE varchar(120) comment '”õ�l'
   , ENTRYDATE datetime comment '“o˜^“ú•t'
@@ -1329,16 +1504,18 @@
 ) 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'
   , TARGETDATE decimal(6,0) not null comment '‘Î�Û”NŒŽ'
   , REQUESTNO decimal(10,0) not null comment '�¿‹�No'
-  , ORDERNO decimal(2,0) comment 'Žó•t”Ô�†'
+  , ORDERNO decimal(2,0) not null comment 'Žó•t”Ô�†'
+  , DEPOSITMONTH decimal(6,0) not null comment '“ü‹à”NŒŽ'
+  , SEQNO decimal(3,0) not null comment '“ü‹à˜A”Ô'
   , DEPOSITAMOUNT decimal(10,0) comment '“ü‹à‹àŠz�i�Å”²‚«�j'
   , TAXAMOUNT decimal(10,0) comment '�Á”ï�Å'
   , DISCOUNTAMOUNT decimal(10,0) comment '’lˆø‚«‹àŠz'
@@ -1352,14 +1529,20 @@
   , NOTE varchar(120) comment '”õ�l'
   , ENTRYDATE datetime comment '“o˜^“ú•t'
   , UPDATEDATE datetime comment '�X�V“ú•t'
-  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO)
+  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO,ORDERNO)
 ) comment '“ü‹à–¾�×ƒf�[ƒ^' ;
 
+create index depositdatadetail_Index1
+  on depositdatadetail(TARGETDATE);
+
+create index depositdatadetail_Index2
+  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'
@@ -1372,10 +1555,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Šú'
@@ -1392,10 +1575,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”Ô�†'
@@ -1415,10 +1598,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”Ô�†'
@@ -1439,10 +1622,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”Ô�†'
@@ -1462,10 +1645,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”Ô�†'
@@ -1493,10 +1676,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'
@@ -1509,10 +1692,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'
@@ -1530,11 +1713,74 @@
 create index HolidayCalenderMaster_Index3
   on holidaycalendermaster(TargetDay);
 
+-- ‹ÆŽÒ�¿‹�“ü—Íƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists inputbillingdata cascade;
+
+-- 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ŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , CONSTRUCTIONCODE decimal(10,0) comment '�HŽ–”Ô�†'
+  , FIELDNAME varchar(120) comment 'Œ»�ê–¼'
+  , PERSONNAME varchar(60) comment '’S“–ŽÒ–¼'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , CONSUMPTIONTAX decimal(10,0) comment '�Á”ï�Å'
+  , OTHERPRICE decimal(10,0) comment '‹à•¨‘ã'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint inputbillingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
+) comment '‹ÆŽÒ�¿‹�“ü—Íƒf�[ƒ^' ;
+
+-- ‹ÆŽÒ�¿‹�“ü—Í–¾�×ƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists inputbillingdatadetail cascade;
+
+-- 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ŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , LABOURKIND decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
+  , CONSTRUCTIONCODE decimal(10,0) comment '�HŽ–”Ô�†'
+  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '‘ä’ –¾�×”Ô�†'
+  , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '‘ä’ —ñ”Ô�†'
+  , FIELDNAME varchar(120) comment 'Œ»�ê–¼'
+  , SECONDSTRING varchar(120) comment '�HŽ–“à—e'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , HIGHWPRICE decimal(10,0) comment '�‚‘¬‘ã'
+  , HARDWPRICE decimal(10,0) comment '‹à•¨‘ã'
+  , INDSWASTETAX decimal(10,0) comment 'ŽY”p�Å'
+  , NOTE varchar(120) comment '”õ�l'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint inputbillingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
+) comment '‹ÆŽÒ�¿‹�“ü—Í–¾�×ƒf�[ƒ^' ;
+
+-- ‹ÆŽÒ�¿‹�“ü—Í�ó‘Ô
+-- BackupToTempTable
+drop table if exists inputbillingstatus cascade;
+
+-- 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ŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , STATUS decimal(1,0) default '0' comment '�¿‹��ó‘Ô'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint inputbillingstatus_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
+) 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‹@”\”Ô�†'
@@ -1548,10 +1794,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 '”­’�ŽÒ‹æ•ª'
@@ -1576,11 +1822,25 @@
 
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
 
+-- ƒ��[ƒ‹ƒRƒ“ƒeƒ“ƒcƒ}ƒXƒ^
+-- BackupToTempTable
+drop table if exists mailcontentsmaster cascade;
+
+-- 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 'Ž‘�Þ�”'
@@ -1592,10 +1852,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'
@@ -1609,10 +1869,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 'Ž‘�ÞŽí—Þ–¼�Ì'
@@ -1624,10 +1884,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ŒŽ“ú'
@@ -1644,10 +1904,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Ž}”Ô'
@@ -1676,10 +1936,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Ž}”Ô'
@@ -1695,10 +1955,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Ž}”Ô'
@@ -1711,20 +1971,72 @@
 ) 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)
 ) comment 'ŒŽƒ}ƒXƒ^' ;
 
+-- ‚¨’m‚ç‚¹�î•ñ
+-- BackupToTempTable
+drop table if exists notificationmessage cascade;
+
+-- RestoreFromTempTable
+create table notificationmessage (
+  MessageDate datetime not null comment '•\Ž¦”NŒŽ“ú'
+  , SeqNo decimal(3,0) unsigned not null comment '˜A”Ô'
+  , MessageTitle varchar(100) comment '‚¨’m‚ç‚¹ƒ^ƒCƒgƒ‹'
+  , MessageContent varchar(1333) not null comment '‚¨’m‚ç‚¹“à—e'
+  , PersonCode decimal(8,0) not null comment '�‘�ž‚Ý’S“–ŽÒƒR�[ƒh'
+  , ShareFlag decimal(2,0) not null comment 'ŠÇ—�ŽÒ‘Î�Ûƒtƒ‰ƒO'
+  , MessageColor varchar(8) comment '•¶Žš�F'
+  , BackColor varchar(8) comment 'ƒoƒbƒNƒJƒ‰�['
+  , QueSeqNo decimal(8,0) default '0' not null comment '‘—�MƒLƒ…�[˜A”Ô'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint notificationmessage_PKC primary key (MessageDate,SeqNo)
+) comment '‚¨’m‚ç‚¹�î•ñ' ;
+
+-- ‚¨’m‚ç‚¹‰{——�î•ñ
+-- BackupToTempTable
+drop table if exists notificationmessagebrowsing cascade;
+
+-- RestoreFromTempTable
+create table notificationmessagebrowsing (
+  MessageDate datetime not null comment '•\Ž¦”NŒŽ“ú'
+  , SeqNo decimal(4,0) unsigned not null comment '˜A”Ô'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , BrowsingFlag decimal(1,0) unsigned default '0' not null comment '‰{——ƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint notificationmessagebrowsing_PKC primary key (MessageDate,SeqNo,CompanyCode)
+) comment '‚¨’m‚ç‚¹‰{——�î•ñ' ;
+
+create index NotificationMessageBrowsing_Index1
+  on notificationmessagebrowsing(CompanyCode);
+
+-- ‚¨’m‚ç‚¹‘Î�Û‹ÆŽÒ‘I‘ð�î•ñ
+-- BackupToTempTable
+drop table if exists notificationmessageselect cascade;
+
+-- RestoreFromTempTable
+create table notificationmessageselect (
+  MessageDate datetime not null comment '•\Ž¦”NŒŽ“ú'
+  , SeqNo decimal(4,0) unsigned not null comment '˜A”Ô'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint notificationmessageselect_PKC primary key (MessageDate,SeqNo,CompanyCode)
+) 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'
@@ -1744,6 +2056,7 @@
   , FaxNumber varchar(13) comment 'FAX”Ô�†'
   , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
   , Note varchar(300) comment '”õ�l'
+  , PersonCode decimal(8,0) not null comment '“o˜^’S“–ŽÒƒR�[ƒ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'
@@ -1751,10 +2064,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”Ô�†'
@@ -1772,10 +2085,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ŒŽ'
@@ -1792,15 +2105,16 @@
 ) 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ŒŽ'
   , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
   , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , LABOURKIND decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
   , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
   , DISCOUNTPRICE decimal(10,0) comment '’lˆø‚«‹àŠz'
   , OFFSETPRICE decimal(10,0) comment '‘ŠŽE‹àŠz'
@@ -1810,12 +2124,12 @@
   , INDSWASTETAX decimal(10,0) comment 'ŽY”p�Å'
   , CNSTRPRICE decimal(10,0) comment '‹¦—Í‹à'
   , CNSTRPRICEEXIST decimal(1,0) comment '‹¦—Í‹à—L–³'
-  , APPROVALPERSONCODE decimal(8,0) comment '�³”F’S“–ŽÒƒR�[ƒh'
-  , APPROVALDATE date comment '’S“–ŽÒ�³”F“ú•t'
+  , APPROVALPERSONCODE decimal(8,0) comment '�\�¿’S“–ŽÒƒR�[ƒh'
+  , APPROVALDATE date comment '’S“–ŽÒ�\�¿“ú•t'
   , APPROVALENDFLG decimal(1,0) comment '�³”FŠ®—¹ƒtƒ‰ƒO'
   , ENTRYDATE datetime comment '“o˜^“ú•t'
   , UPDATEDATE datetime comment '�X�V“ú•t'
-  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
+  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,LABOURKIND)
 ) comment 'Žx•¥–¾�×ƒf�[ƒ^' ;
 
 create index PayDataDetail_Index1
@@ -1825,10 +2139,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'
@@ -1848,14 +2162,14 @@
   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‹@”\”Ô�†'
-  , OrderDate date not null comment 'Žó•t“ú'
+  , OrderDate decimal(6,0) unsigned not null comment 'Žó•t“ú'
   , OrderNo decimal(2,0) unsigned not null comment 'Žó•t”Ô�†'
   , SeqNo decimal(2,0) not null comment 'Ž}”Ô'
   , PersonCodeApproval decimal(8,0) unsigned not null comment '�\�¿�E�³”FŽÒƒR�[ƒh'
@@ -1868,15 +2182,30 @@
   , constraint personapproval_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,SeqNo)
 ) comment '’S“–ŽÒ�³”Fƒf�[ƒ^' ;
 
+create index personapproval_Index1
+  on personapproval(PersonCode);
+
+create index personapproval_Index2
+  on personapproval(ApprovalCode);
+
+create index personapproval_Index3
+  on personapproval(OrderDate);
+
+create index personapproval_Index4
+  on personapproval(OrderNo);
+
+create index personapproval_Index5
+  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‹@”\”Ô�†'
-  , OrderDate date not null comment 'Žó•t“ú'
+  , OrderDate decimal(6,0) unsigned not null comment 'Žó•t“ú'
   , OrderNo decimal(2,0) unsigned not null comment 'Žó•t”Ô�†'
   , CommentNo decimal(2,0) not null comment 'ƒRƒ�ƒ“ƒg”Ô�†'
   , ParentNo decimal(2,0) not null comment '�eƒRƒ�ƒ“ƒg”Ô�†'
@@ -1887,10 +2216,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'
@@ -1907,21 +2236,32 @@
   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 '•\Ž¦�‡'
   , PersonName varchar(60) not null comment '’S“–ŽÒ–¼'
-  , StartDate date not null comment 'Žg—pŠJŽn”NŒŽ“ú'
-  , EndDate date comment 'Žg—p�I—¹”NŒŽ“ú'
+  , PersonNameKana varchar(60) comment 'ƒtƒŠƒKƒi'
+  , Sex decimal(1,0) default '0' comment '�«•Ê'
+  , BloodType varchar(6) comment 'ŒŒ‰tŒ^'
+  , Birthday date not null comment '�¶”NŒŽ“ú'
+  , ZipCode varchar(8) comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) comment 'Œ»�Z�Š1'
+  , Address2 varchar(60) comment 'Œ»�Z�Š2'
+  , Address3 varchar(60) comment 'Œ»�Z�Š3'
+  , PhoneNumber varchar(13) comment '˜A—��æ“d˜b”Ô�†'
+  , EmgPhoneNumber varchar(13) comment '‹Ù‹}˜A—��æ“d˜b”Ô�†'
+  , EmgContact varchar(60) comment '‹Ù‹}˜A—��æ–¼'
+  , StartDate date not null comment '“üŽÐ”NŒŽ“ú'
+  , EndDate date comment '‘ÞŽÐ”NŒŽ“ú'
   , PassWord varchar(16) comment 'ƒpƒXƒ��[ƒh'
   , SecurityManagement decimal(1,0) not null comment '‹@–§‹æ•ª'
   , SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
   , MsgBackColor varchar(8) comment 'ƒ�ƒbƒZ�[ƒW”wŒi�F'
-  , DisplayString varchar(20) comment '•\Ž¦�Eˆó�ü–¼�Ì'
+  , DisplayString varchar(20) comment '–ð�E–¼�Ì'
   , DepartmentCode decimal(5,0) unsigned comment '•”��ƒR�[ƒh'
   , MonthlySalary decimal(11,0) not null comment 'ŒŽ‹‹‹àŠz'
   , YearSalary decimal(12,0) not null comment '”N•î‹àŠz'
@@ -1931,6 +2271,10 @@
   , LedgerFlg decimal(1,0) not null comment '‘ä’ ŒvŽZ‘Î�Ûƒtƒ‰ƒO'
   , CommutingDistance decimal(5,2) not null comment '’Ê‹Î‹——£'
   , CommuteCosts decimal(5,0) not null comment '’Ê‹ÎŒð’Ê”ï'
+  , PaidVacationDays decimal(4,1) not null comment '�¡”N“x—L‹‹‹x‰É“ú�”'
+  , PaidVacationDaysPrev decimal(4,1) not null comment '‘O”N“x—L‹‹‹x‰É“ú�”'
+  , WorkingCode decimal(3,0) unsigned not null comment '�A‹ÆƒR�[ƒh'
+  , PaidDayOffFlg decimal(1,0) unsigned not null comment '—L‹‹Žæ“¾ƒtƒ‰ƒO'
   , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
@@ -1943,11 +2287,29 @@
 create index PersonInChargeMaster_Index2
   on personinchargemaster(DepartmentCode);
 
+-- ’S“–ŽÒŽ‘Šiƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists personqualification cascade;
+
+-- RestoreFromTempTable
+create table personqualification (
+  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment 'ƒf�[ƒ^�‡”Ô'
+  , DCode decimal(5,0) unsigned not null comment '•ª—Þ‹æ•ª'
+  , Qcode decimal(5,0) unsigned not null comment 'Ž‘ŠiƒR�[ƒh'
+  , DateOfAcquisition datetime not null comment 'Ž‘ŠiŽæ“¾“ú•t'
+  , Qualification varchar(120) comment '‚»‚Ì‘¼Ž‘Ši–¼'
+  , Notes varchar(120) comment '”õ�l'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint personqualification_PKC primary key (PersonCode,SeqNo)
+) 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ŒŽ“ú'
@@ -1968,10 +2330,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'
@@ -1992,10 +2354,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Ž–˜^�ì�¬“ú'
@@ -2010,10 +2372,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Ž–˜^�ì�¬“ú'
@@ -2027,10 +2389,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Ž–˜^�ì�¬“ú'
@@ -2045,10 +2407,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‹@”\”Ô�†'
@@ -2065,10 +2427,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‹@”\”Ô�†'
@@ -2082,10 +2444,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‹@”\”Ô�†'
@@ -2098,10 +2460,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“®�ˆ—�”Ô�†'
@@ -2118,10 +2480,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 '’�•¶�‘Ž}”Ô'
@@ -2150,6 +2512,9 @@
   , SafetyOfficerName varchar(60) comment 'ˆÀ‘SŠÇ—�ŽÒ–¼'
   , WorkersCount decimal(3,0) unsigned comment '�ì‹Æˆõ�”'
   , PrintoutDate date not null comment 'ˆó�ü”NŒŽ“ú'
+  , 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 'Žó’��ó‘Ô'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
   , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)
@@ -2156,10 +2521,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 '’�•¶�‘Ž}”Ô'
@@ -2173,10 +2538,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 '’�•¶�‘Ž}”Ô'
@@ -2202,11 +2567,36 @@
 create index POrderDetail_Index1
   on purchaseorderdetail(SourceCode);
 
+-- Ž‘Šiƒ}ƒXƒ^
+-- BackupToTempTable
+drop table if exists qualificationmaster cascade;
+
+-- RestoreFromTempTable
+create table qualificationmaster (
+  DCode decimal(5,0) unsigned not null comment '•ª—Þ‹æ•ª'
+  , Qcode decimal(5,0) unsigned not null comment 'Ž‘ŠiƒR�[ƒh'
+  , Qualification varchar(120) comment '•ª—Þ�EŽ‘Ši–¼'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , DeleteFlg decimal(1,0) default '0' not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint qualificationmaster_PKC primary key (DCode,Qcode)
+) comment 'Ž‘Šiƒ}ƒXƒ^' ;
+
+create index QualificationMaster_Index1
+  on qualificationmaster(DCode);
+
+create index QualificationMaster_Index2
+  on qualificationmaster(Qcode);
+
+create index QualificationMaster_Index3
+  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”Ô�†'
@@ -2216,10 +2606,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'
@@ -2231,10 +2621,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”Ô'
@@ -2245,10 +2635,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 '�¿‹�Žæ�Á“ú'
@@ -2284,10 +2674,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'
@@ -2303,10 +2693,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Ž–”Ô�†'
@@ -2330,10 +2720,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Ž–”Ô�†'
@@ -2347,10 +2737,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Ž–”Ô�†'
@@ -2367,6 +2757,8 @@
   , NOTE varchar(120) comment '”õ�l'
   , ASSIGNEDFLG decimal(1,0) comment 'Š„“–�Ïƒtƒ‰ƒO'
   , INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
+  , BILLINGDATE datetime not null comment '�¿‹�“ú'
+  , BILLCONFIRMDATE datetime not null comment '�¿‹�Šm”F“ú'
   , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
   , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
   , constraint requesthead_PKC primary key (REQUESTNO)
@@ -2375,10 +2767,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'
@@ -2389,10 +2781,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 'Ž–‹ÆŠú'
@@ -2415,10 +2807,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 '•\Ž¦�‡'
@@ -2442,10 +2834,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ƒ��[ƒ‹‰ñ�”'
@@ -2462,10 +2854,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ƒ��[ƒ‹‰ñ�”'
@@ -2476,11 +2868,37 @@
   , constraint sfpdatadetail_PKC primary key (ConstructionCode,DataCount,SeqNo)
 ) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^' ;
 
+-- ‹¦—Í‰ïŽÐƒ��[ƒ‹‘—�MƒLƒ…�[
+-- BackupToTempTable
+drop table if exists subconmailqueue cascade;
+
+-- 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'
+  , MailDelivery decimal(3,0) default '0' not null comment '‘—�M�æ�Ý’è”Ô�†'
+  , Argument0 varchar(32) comment 'ƒ��[ƒ‹‘}“ü•¶Žš‚O'
+  , Argument1 varchar(32) comment 'ƒ��[ƒ‹‘}“ü•¶Žš‚P'
+  , Argument2 varchar(32) comment 'ƒ��[ƒ‹‘}“ü•¶Žš‚Q'
+  , Argument3 varchar(32) comment 'ƒ��[ƒ‹‘}“ü•¶Žš‚R'
+  , Argument4 varchar(32) comment 'ƒ��[ƒ‹‘}“ü•¶Žš‚S'
+  , Status decimal(1,0) default '0' not null comment 'ƒXƒe�[ƒ^ƒX'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subconmailqueue_PKC primary key (SeqNo,CompanyCode)
+) comment '‹¦—Í‰ïŽÐƒ��[ƒ‹‘—�MƒLƒ…�[' ;
+
+create index subconmailqueue_Index1
+  on subconmailqueue(CompanyCode);
+
+create index subconmailqueue_Index2
+  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 '�ì�¬“ú'
@@ -2493,10 +2911,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 '�ì�¬“ú'
@@ -2509,10 +2927,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 '�ì�¬“ú'
@@ -2538,7 +2956,7 @@
   , StartDate date not null comment 'ŽæˆøŠJŽn”NŒŽ“ú'
   , Note varchar(300) comment '”õ�l'
   , labourKind decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
-  , OrderDate date comment '�\�¿“ú'
+  , OrderDate decimal(6,0) unsigned comment '�\�¿“ú'
   , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
@@ -2546,10 +2964,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 '•\Ž¦�‡'
@@ -2561,10 +2979,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 '•\Ž¦�‡'
@@ -2576,10 +2994,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�['
@@ -2596,10 +3014,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�['
@@ -2615,11 +3033,25 @@
 create index SubContractorJobLink_Index2
   on subcontractorjoblink(JobCategoryCode);
 
+-- ‹¦—Í‰ïŽÐƒ��[ƒ‹ƒf�[ƒ^
+-- BackupToTempTable
+drop table if exists subcontractormail cascade;
+
+-- 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”Ô'
+  , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subcontractormail_PKC primary key (CompanyCode,SeqNo)
+) 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 '•\Ž¦�‡'
@@ -2626,9 +3058,12 @@
   , CorporateStatusName varchar(40) comment '–@�lŠi–¼�Ì'
   , CorporateStatusPoint decimal(1,0) not null comment '–@�lŠi–¼�ÌˆÊ’u'
   , CompanyName varchar(100) not null comment '‹¦—Í‰ïŽÐ–¼'
+  , CompanyNameKana varchar(100) not null comment '‹¦—Í‰ïŽÐ–¼�iƒJƒi�j'
   , CEOPositionName varchar(60) comment '‘ã•\ŽÒ–ð�E–¼'
   , CEOName varchar(60) comment '‘ã•\ŽÒŽ�–¼'
+  , CEONameKana varchar(60) comment '‘ã•\ŽÒŽ�–¼�iƒJƒi�j'
   , ContactPersonName varchar(60) comment '’S“–ŽÒŽ�–¼'
+  , ContactPersonNameKana varchar(60) comment '’S“–ŽÒŽ�–¼�iƒJƒi�j'
   , ZipCode varchar(8) comment '—X•Ö”Ô�†'
   , Address1 varchar(60) comment '�Z�Š‚P'
   , Address2 varchar(60) comment '�Z�Š2'
@@ -2641,6 +3076,17 @@
   , StartDate date not null comment 'ŽæˆøŠJŽn”NŒŽ“ú'
   , Note varchar(300) comment '”õ�l'
   , labourKind decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
+  , RequestImputId varchar(8) not null comment '�¿‹�“ü—ÍID'
+  , Password varchar(20) comment 'ƒpƒXƒ��[ƒh'
+  , BankCode decimal(4,0) unsigned not null comment '‹â�sƒR�[ƒh'
+  , BankName varchar(20) comment '‹â�s–¼'
+  , BankBranchCode decimal(3,0) unsigned not null comment 'Žx“XƒR�[ƒh'
+  , BankBranchName varchar(20) comment 'Žx“X–¼'
+  , BankAccountKind decimal(1,0) not null comment 'Œû�ÀŽí—Þ'
+  , BankAccountNo decimal(7,0) unsigned not null comment 'Œû�À”Ô�†'
+  , BankAccountName varchar(30) comment 'Œû�À–¼‹`(ŽóŽæ�l–¼)'
+  , TransferFees decimal(4,0) unsigned not null comment '�U�žŽè�”—¿'
+  , ConfirmedDate datetime not null comment 'ƒf�[ƒ^Šm”F“ú'
   , DeleteFlg decimal(1,0) default '0' not null comment '�í�œƒtƒ‰ƒO'
   , EntryDate datetime not null comment '“o˜^“ú•t'
   , UpdateDate datetime not null comment '�X�V“ú•t'
@@ -2647,14 +3093,30 @@
   , constraint subcontractormaster_PKC primary key (CompanyCode)
 ) comment '‹¦—Í‰ïŽÐƒ}ƒXƒ^' ;
 
+alter table subcontractormaster add unique SubContractorMaster_Index2 (RequestImputId) ;
+
 create index SubContractorMaster_Index1
   on subcontractormaster(JapaneseSyllabary);
 
+-- ‹¦—Í‰ïŽÐƒ��[ƒ‹‘—�M�Ý’è
+-- BackupToTempTable
+drop table if exists subcontrmaildelivery cascade;
+
+-- 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”Ô'
+  , MailDelivery decimal(3,0) default '0' not null comment '‘—�M�æ�Ý’è”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subcontrmaildelivery_PKC primary key (CompanyCode,SeqNo,MailDelivery)
+) 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 '•\Ž¦�‡'
@@ -2674,10 +3136,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'
@@ -2689,10 +3151,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'
@@ -2729,10 +3191,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”Ô�†'
@@ -2753,10 +3215,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 '“ú•ñ�ì�¬“ú'
@@ -2777,10 +3239,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 'Ž–‹ÆŠú'
@@ -2793,10 +3255,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 '•\Ž¦�‡'
@@ -2810,10 +3272,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 '•\Ž¦�‡'
@@ -2841,10 +3303,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�[ƒ^‹æ•ª'
@@ -2859,10 +3321,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'
@@ -2885,11 +3347,53 @@
 create index VehicleScheduleData_Index3
   on vehiclescheduledata(TargetDay);
 
+-- �A‹ÆŽžŠÔƒ}ƒXƒ^
+-- BackupToTempTable
+drop table if exists workingtime cascade;
+
+-- RestoreFromTempTable
+create table workingtime (
+  WorkingCode decimal(3,0) unsigned not null comment '�A‹ÆƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , WorkingName varchar(60) comment '�A‹ÆŽžŠÔ–¼�Ì'
+  , StartTime datetime not null comment 'ŠJŽnŽžŠÔ'
+  , CompTime datetime not null comment '�I—¹ŽžŠÔ'
+  , OverStartTime datetime not null comment 'Žc‹Æ�\�¿ŠJŽnŽžŠÔ'
+  , OnCalender decimal(1,0) not null comment 'ƒJƒŒƒ“ƒ_�[’Ê‚èƒtƒ‰ƒO'
+  , MonValue decimal(1,0) not null comment 'ŒŽ—j“ú‹xƒtƒ‰ƒO'
+  , TueValue decimal(1,0) not null comment '‰Î—j“ú‹xƒtƒ‰ƒO'
+  , WedValue decimal(1,0) not null comment '�…—j“ú‹xƒtƒ‰ƒO'
+  , ThuValue decimal(1,0) not null comment '–Ø—j“ú‹xƒtƒ‰ƒO'
+  , FriValue decimal(1,0) not null comment '‹à—j“ú‹xƒtƒ‰ƒO'
+  , SatValue decimal(1,0) not null comment '“y—j“ú‹xƒtƒ‰ƒO'
+  , SunValue decimal(1,0) not null comment '“ú—j“ú‹xƒtƒ‰ƒO'
+  , Note varchar(300) comment '”õ�l'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint workingtime_PKC primary key (WorkingCode)
+) comment '�A‹ÆŽžŠÔƒ}ƒXƒ^' ;
+
+-- �A‹Æ‹xŒeŽžŠÔƒ}ƒXƒ^
+-- BackupToTempTable
+drop table if exists workingtimebreak cascade;
+
+-- 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”Ô�†'
+  , StartTime datetime not null comment 'ŠJŽnŽžŠÔ'
+  , CompTime datetime not null comment '�I—¹ŽžŠÔ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint workingtimebreak_PKC primary key (WorkingCode,BreakNo)
+) 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)
