Index: trunk/ddl/ProcessManagement.sql
===================================================================
--- trunk/ddl/ProcessManagement.sql	(nonexistent)
+++ trunk/ddl/ProcessManagement.sql	(revision 379)
@@ -0,0 +1,2833 @@
+-- Project Name : noname
+-- Date/Time    : 2018/08/06 8:37:19
+-- Author       : Horiuchi
+-- RDBMS Type   : MySQL
+-- Application  : A5:SQL Mk-2
+
+/*
+  BackupToTempTable, RestoreFromTempTable‹^Ž—–½—ß‚ª•t‰Á‚³‚ê‚Ä‚¢‚Ü‚·�B
+  ‚±‚ê‚É‚æ‚è�Adrop table, create table Œã‚àƒf�[ƒ^‚ªŽc‚è‚Ü‚·�B
+  ‚±‚Ì‹@”\‚ÍˆêŽž“I‚É $$TableName ‚Ì‚æ‚¤‚ÈˆêŽžƒe�[ƒuƒ‹‚ð�ì�¬‚µ‚Ü‚·�B
+*/
+
+-- ’S“–ŽÒ�s“®—\’èƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists actionscheduledata cascade;
+
+--* RestoreFromTempTable
+create table actionscheduledata (
+  TargetDate date not null comment '‘Î�Û“ú'
+  , PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
+  , ActionSchedule varchar(30) comment '�s“®—\’è'
+  , TargetYear year(4) not null comment 'ŠY“–”N'
+  , TargetMonth year(4) not null comment 'ŠY“–ŒŽ'
+  , TargetDay year(4) not null comment 'ŠY“–“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint actionscheduledata_PKC primary key (TargetDate,PersonCode)
+) comment '’S“–ŽÒ�s“®—\’èƒf�[ƒ^' ;
+
+create index ActionScheduleData_Index1
+  on actionscheduledata(TargetYear);
+
+create index ActionScheduleData_Index2
+  on actionscheduledata(TargetMonth);
+
+create index ActionScheduleData_Index3
+  on actionscheduledata(TargetDay);
+
+-- �³”FŒo˜Hƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists approvalmaster cascade;
+
+--* RestoreFromTempTable
+create table approvalmaster (
+  ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
+  , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , SeqNo decimal(2,0) not null comment 'Ž}”Ô'
+  , DisplayOrder decimal(2,0) not null comment '•\Ž¦�‡'
+  , ApprovalPerson decimal(8,0) unsigned not null comment '�³”FŽÒƒR�[ƒh'
+  , ApprovalAuthority decimal(1,0) not null comment '�³”FŒ ŒÀ‹æ•ª'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint approvalmaster_PKC primary key (ApprovalCode,DepartmentCode,SeqNo)
+) comment '�³”FŒo˜Hƒ}ƒXƒ^' ;
+
+-- �o‹Î“ú•ñƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists attendancedailydata cascade;
+
+--* 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“®ŽÀ�Ñ'
+  , StartTime datetime comment 'ŠJŽnŽžŠÔ'
+  , CompTime datetime comment '�I—¹ŽžŠÔ'
+  , DayTimes decimal(4,1) not null comment '“ú‰Ò“­�‡ŒvŽžŠÔ'
+  , WorkingComment varchar(120) comment 'ƒRƒ�ƒ“ƒg'
+  , WorkKindFlg decimal(1,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)
+) comment '�o‹Î“ú•ñƒf�[ƒ^' ;
+
+create index AttendDaily_Index1
+  on attendancedailydata(ConstructionCode);
+
+create index AttendDaily_Index2
+  on attendancedailydata(AttendanceDate);
+
+-- �o‹ÎŠÇ—�ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists attendancedata cascade;
+
+--* RestoreFromTempTable
+create table attendancedata (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , AttendanceMonth date 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 '�\�¿“ú'
+  , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint attendancedata_PKC primary key (PersonCode,AttendanceMonth)
+) comment '�o‹ÎŠÇ—�ƒf�[ƒ^' ;
+
+-- ‹â�s‰c‹Æ“úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists bankbusinessdaymaster cascade;
+
+--* 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‹Æ“ú'
+  , NOTE varchar(120) comment '”õ�l'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY)
+) comment '‹â�s‰c‹Æ“úƒ}ƒXƒ^' ;
+
+-- ‹ÆŽÒ�¿‹�ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists billingdata cascade;
+
+--* 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ŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
+) comment '‹ÆŽÒ�¿‹�ƒf�[ƒ^' ;
+
+-- ‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists billingdatadetail cascade;
+
+--* 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”Ô�†'
+  , 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 '—ñ”Ô�†'
+  , 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�Å'
+  , NOTE varchar(120) comment '”õ�l'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
+) comment '‹ÆŽÒ�¿‹�–¾�×ƒf�[ƒ^' ;
+
+-- ‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists billingpaymentsummary cascade;
+
+--* 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ŒŽ'
+  , CHARGEPAYMENTKIND decimal(1,0) default '0' not null comment '�¿‹�Žx•¥‹æ•ª'
+  , PAYDAY date comment 'Žx•¥“ú'
+  , BILLPRICESTOTAL decimal(10,0) comment '�¿‹�‹àŠz�¬Œv'
+  , CONSUMPTIONTAXRATE decimal(6,3) comment '�Á”ï�Å—¦'
+  , CONSUMPTIONTAXPRICE decimal(10,0) comment '�Á”ï�ÅŠz'
+  , HIGHWPRICESTOTAL decimal(10,0) comment '�‚‘¬‘ã�¬Œv'
+  , HARDWPRICESTOTAL decimal(10,0) comment '‹à•¨‘ã�¬Œv'
+  , INDSWASTETAXSTOTAL decimal(10,0) comment 'ŽY”p�Å�¬Œv'
+  , CNSTRPRICERATE decimal(6,3) comment '‹¦—Í‹à”ä—¦'
+  , CNSTRPRICESTOTAL decimal(10,0) comment '‹¦—Í‹à�¬Œv'
+  , BILLINGPRICETOTAL decimal(10,0) comment '�¿‹�‹àŠz�‡Œv'
+  , ENTRYDATE datetime comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime comment '�X�V”NŒŽ“ú'
+  , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)
+) comment '‹ÆŽÒ�¿‹�Žx•¥ƒTƒ}ƒŠ�[ƒf�[ƒ^' ;
+
+-- ‰^‰cŠú—š—ð�î•ñ
+--* BackupToTempTable
+drop table if exists bizperiodhistory cascade;
+
+--* 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'
+  , BeginDate datetime not null comment 'ŠúŽñ“ú'
+  , CompleteDate datetime not null comment 'Šú––“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bizperiodhistory_PKC primary key (PeriodYear,PeriodFlag)
+) comment '‰^‰cŠú—š—ð�î•ñ' ;
+
+-- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
+drop table if exists bk_constructionledger cascade;
+
+--* RestoreFromTempTable
+create table bk_constructionledger (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
+  , CreatorCode decimal(8,0) comment '�ì�¬ŽÒƒR�[ƒh'
+  , CreatorName varchar(60) comment '�ì�¬ŽÒ–¼'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , ConstructionTimes decimal(5,2) not null comment '�HŠú�i’PˆÊ�EŒŽ�j'
+  , ConstructionStart date not null comment 'Œ_–ñ�HŠúŠJŽn'
+  , ConstructionEnd date not null comment 'Œ_–ñ�HŠúŠ®—¹'
+  , OrdersDecisionPrice decimal(14,0) not null comment '�Å”²Žó’�Œˆ’è‹àŠz'
+  , CompanyExpenses decimal(10,0) not null comment '‰ïŽÐŒo”ï�‡Œv'
+  , DepartmentExpenses decimal(10,0) not null comment '•”��Œo”ï�‡Œv'
+  , SalesExpenses decimal(10,0) not null comment '‰c‹ÆŒo”ï�‡Œv'
+  , TotalPayment decimal(10,0) not null comment '‘�Žx•¥Šz'
+  , GrossProfit decimal(10,0) not null comment '‘e—˜'
+  , Allowance decimal(10,0) not null comment '‹‹—^'
+  , NetProfit decimal(10,0) not null comment '�ƒ—˜‰v'
+  , ComplateFlg decimal(1,0) not null comment '“ü—ÍŠ®—¹ƒtƒ‰ƒO'
+  , IntegrationFlg decimal(1,0) not null comment 'Žó’�‹àŠz�ÏŽZƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bk_constructionledger_PKC primary key (ConstructionCode)
+) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^�y‘Þ”ð—p�z' ;
+
+-- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
+drop table if exists bk_constructionledgerdetail cascade;
+
+--* 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”Ô�†'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , FirstString varchar(120) comment '�€–Ú–¼�Ì'
+  , SecondString varchar(120) comment '�HŽ–“à—e'
+  , CompanyType decimal(1,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒhƒ^ƒCƒv'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , CompanyName varchar(120) comment '‹¦—Í‰ïŽÐ–¼�Ì'
+  , EstimatePrice decimal(12,0) not null comment '—\ŽZ�iŒ©�Ï�j‹àŠz'
+  , ExecutionAmount decimal(12,0) not null comment 'ŽÀ�s‹àŠz'
+  , AmountConfigRate decimal(5,2) not null comment '‹àŠz�\�¬—¦'
+  , PaymentBurden decimal(12,0) not null comment 'Žx•¥•â“UŠz'
+  , FixDataFlg decimal(1,0) not null comment 'ŒÅ’èƒf�[ƒ^ƒtƒ‰ƒO'
+  , IndependentFlg decimal(1,0) not null comment '“Æ—§ƒf�[ƒ^ƒtƒ‰ƒO'
+  , FluctuationFlg decimal(1,0) not null comment '‘�Œ¸ƒf�[ƒ^ƒtƒ‰ƒO'
+  , SalaryFlg decimal(1,0) not null comment '‹‹—^�U•ª‹æ•ª'
+  , SalaryDays decimal(4,0) not null comment '‹‹—^�U•ª“ú�”'
+  , OperatingFlg decimal(1,0) not null comment '’S“–’†ƒtƒ‰ƒO'
+  , SourceCode decimal(10,0) unsigned not null comment 'Œ³�HŽ–”Ô�†'
+  , 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'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bk_constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
+) comment '�HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^�y‘Þ”ð—p�z' ;
+
+-- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
+drop table if exists bk_constructionledgerexcute cascade;
+
+--* 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”Ô�†'
+  , LineCount decimal(5,0) unsigned not null comment '�s”Ô�†'
+  , ColumnCount decimal(3,0) not null comment '—ñ”Ô�†'
+  , PaymentAmount decimal(12,0) not null comment 'Žx•¥‹àŠz'
+  , TargetMonth date not null comment '‘Î�Û”NŒŽ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bk_constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)
+) comment '�HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^�y‘Þ”ð—p�z' ;
+
+-- �ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
+drop table if exists bk_estimatedata cascade;
+
+--* RestoreFromTempTable
+create table bk_estimatedata (
+  SaveDate datetime not null comment '‘Þ”ð“ú•t'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , FixedItemCode varchar(1) comment 'ŒÅ’è�€–ÚƒL�['
+  , ItemName varchar(120) comment '�ì‹Æ–¼�Ì'
+  , SpecName varchar(120) comment '�ì‹Æ�^•iŽ¿�EŒ`�ó�E�¡–@'
+  , PriceValue decimal(14,0) not null comment '‹àŠz'
+  , note varchar(60) comment '”õ�l'
+  , MyExpensesFlg decimal(1,0) not null comment 'Ž©ŽÐŒo”ïƒtƒ‰ƒO'
+  , InputFlg decimal(1,0) not null comment '“ü—Íƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bk_estimatedata_PKC primary key (SaveDate,ConstructionCode,LineCount)
+) comment '�ÏŽZŒ©�Ïƒf�[ƒ^�y‘Þ”ð—p�z' ;
+
+-- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z
+--* BackupToTempTable
+drop table if exists bk_estimatedatabody cascade;
+
+--* RestoreFromTempTable
+create table bk_estimatedatabody (
+  SaveDate datetime not null comment '‘Þ”ð“ú•t'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
+  , Category decimal(1,0) not null comment 'ƒy�[ƒW‹æ•ª'
+  , UnionComponentCode decimal(5,0) unsigned not null comment '�Š‘®�\�¬ƒL�['
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SelectComponent decimal(5,0) unsigned not null comment '‘I‘ð�\�¬ƒL�['
+  , PageTitle varchar(120) not null comment 'ƒy�[ƒW•\Ž¦–¼'
+  , DetailLineCount decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bk_estimatedatabody_PKC primary key (SaveDate,ConstructionCode,PageCount)
+) comment '�ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^�y‘Þ”ð—p�z' ;
+
+-- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z
+--* BackupToTempTable
+drop table if exists bk_estimatedatadetail cascade;
+
+--* RestoreFromTempTable
+create table bk_estimatedatadetail (
+  SaveDate datetime not null comment '‘Þ”ð“ú•t'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , PageCount decimal(4,0) unsigned not null comment 'ƒy�[ƒW”Ô�†'
+  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , DataType decimal(1,0) not null comment 'ƒf�[ƒ^Ží•Ê'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
+  , ItemName varchar(120) comment '�ì‹Æ–¼�Ì'
+  , SpecName varchar(120) comment '�ì‹Æ�^•iŽ¿�EŒ`�ó�E�¡–@'
+  , Unitcount decimal(8,2) not null comment '�”—Ê'
+  , UnitName varchar(30) comment '’PˆÊ–¼�Ì'
+  , UnitPrice decimal(9,2) not null comment '’P‰¿'
+  , LineTotal decimal(12,0) not null comment '‹àŠz'
+  , note varchar(60) comment '”õ�l'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , MyExpensesFlg decimal(1,0) not null comment 'Ž©ŽÐŒo”ïƒtƒ‰ƒO'
+  , InputFlg decimal(1,0) comment '“ü—Íƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint bk_estimatedatadetail_PKC primary key (SaveDate,ConstructionCode,PageCount,LineCount)
+) comment '�ÏŽZŒ©�Ïƒf�[ƒ^–¾�×�y‘Þ”ð—p�z' ;
+
+-- —\ŽZ�‘�WŒvƒR�[ƒhƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists budgetsumcode cascade;
+
+--* 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”Ô�†'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , ElementsName varchar(100) not null comment '—v‘f–¼�Ì'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint budgetsumcode_PKC primary key (BlockCode,GroupCode,ComponentCode,ItemCode)
+) comment '—\ŽZ�‘�WŒvƒR�[ƒhƒ}ƒXƒ^' ;
+
+-- –@�lŠiƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists businesstypemaster cascade;
+
+--* RestoreFromTempTable
+create table businesstypemaster (
+  BusinessTypeCode decimal(5,0) unsigned not null comment '–@�lŠiƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , BusinessTypeName varchar(100) not null comment '‹ÆŽí–¼'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint businesstypemaster_PKC primary key (BusinessTypeCode)
+) comment '–@�lŠiƒ}ƒXƒ^' ;
+
+create index BusinessTypeMaster_Index1
+  on businesstypemaster(DisplayOrder);
+
+-- ’S“–ŽÒ•”��—š—ðƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists chgchargedep cascade;
+
+--* RestoreFromTempTable
+create table chgchargedep (
+  PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
+  , StartDate date not null comment 'ŠJŽn”NŒŽ“ú'
+  , CompDate date not null comment '�I—¹”NŒŽ“ú'
+  , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , DepartmentName varchar(60) comment '•”��–¼'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint chgchargedep_PKC primary key (PersonCode,StartDate)
+) comment '’S“–ŽÒ•”��—š—ðƒf�[ƒ^' ;
+
+-- �HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists chgconstrcharge cascade;
+
+--* RestoreFromTempTable
+create table chgconstrcharge (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , Division decimal(1,0) not null comment '�Ý’è‹æ•ª'
+  , SeqNo smallint(5) unsigned not null comment '˜A”Ô'
+  , DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , PersonCode decimal(8,0) not null comment '’S“–ŽÒƒR�[ƒh'
+  , StartDate date comment '’S“–ŠJŽn”NŒŽ“ú'
+  , CompDate date comment '’S“–�I—¹”NŒŽ“ú'
+  , SourceCode decimal(10,0) unsigned not null comment 'Œ³�HŽ–ƒ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'
+  , constraint chgconstrcharge_PKC primary key (ConstructionCode,Division,SeqNo)
+) comment '�HŽ–’S“–•Ï�X—š—ðƒf�[ƒ^' ;
+
+-- ‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists commoncostlarge cascade;
+
+--* RestoreFromTempTable
+create table commoncostlarge (
+  LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , LargeName varchar(50) not null comment '‘å�€–Ú–¼�Ì'
+  , CommentText varchar(120) comment '�à–¾�‘‚«'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint commoncostlarge_PKC primary key (LargeCode)
+) comment '‹¤’Ê”ï‘å�€–Úƒ}ƒXƒ^' ;
+
+-- ‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists commoncostlinkms cascade;
+
+--* RestoreFromTempTable
+create table commoncostlinkms (
+  LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
+  , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , EntryDate datetime comment '“o˜^“ú•t'
+  , UpdateDate datetime comment '�X�V“ú•t'
+  , constraint commoncostlinkms_PKC primary key (LargeCode,MiddleCode,ItemCode)
+) comment '‹¤’Ê”ï�HŽíŠÖ˜Aƒ}ƒXƒ^' ;
+
+-- ‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists commoncostmiddle cascade;
+
+--* RestoreFromTempTable
+create table commoncostmiddle (
+  LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
+  , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , MiddleName varchar(50) not null comment '’†�€–Ú–¼�Ì'
+  , CommentText varchar(120) comment '�à–¾�‘‚«'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint commoncostmiddle_PKC primary key (LargeCode,MiddleCode)
+) comment '‹¤’Ê”ï’†�€–Úƒ}ƒXƒ^' ;
+
+-- ‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists commoncostmiddlesearchword cascade;
+
+--* RestoreFromTempTable
+create table commoncostmiddlesearchword (
+  LargeCode decimal(5,0) unsigned not null comment '‘å�€–ÚƒL�['
+  , MiddleCode decimal(5,0) unsigned not null comment '’†�€–ÚƒL�['
+  , SeqNo decimal(5,0) unsigned not null comment '�‡�˜'
+  , SearchWord varchar(50) not null comment 'ŒŸ�õ�€–Ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint commoncostmiddlesearchword_PKC primary key (LargeCode,MiddleCode,SeqNo)
+) comment '‹¤’Ê”ï’†�€–ÚƒL�[ƒ}ƒXƒ^' ;
+
+-- �\�¬�HŽíŠÖ˜Aƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists componentlinkmaster cascade;
+
+--* RestoreFromTempTable
+create table componentlinkmaster (
+  ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , DisplayOrder decimal(5,0) unsigned comment '•\Ž¦�‡'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint componentlinkmaster_PKC primary key (ComponentCode,ItemCode)
+) comment '�\�¬�HŽíŠÖ˜Aƒ}ƒXƒ^' ;
+
+create index ComponentLinkMaster_Index1
+  on componentlinkmaster(ComponentCode);
+
+create index ComponentLinkMaster_Index2
+  on componentlinkmaster(ItemCode);
+
+-- �\�¬ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists componentmaster cascade;
+
+--* RestoreFromTempTable
+create table componentmaster (
+  ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , ComponentName varchar(120) not null comment '�\�¬–¼�Ì'
+  , SubItemsFlg decimal(1,0) comment '‰ºˆÊ�€–Úƒtƒ‰ƒO'
+  , DirectInputFlg decimal(1,0) comment '’¼�Ú“ü—Íƒtƒ‰ƒO'
+  , MyExpensesFlg decimal(1,0) comment 'Ž©ŽÐŒo”ïƒtƒ‰ƒO'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint componentmaster_PKC primary key (ComponentCode)
+) comment '�\�¬ƒ}ƒXƒ^' ;
+
+create index ComponentMaster_Index1
+  on componentmaster(DisplayOrder);
+
+-- �\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists componenttotypemaster cascade;
+
+--* RestoreFromTempTable
+create table componenttotypemaster (
+  ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , Dummy decimal(1,0) not null comment 'ƒ_ƒ~�[�€–Ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint componenttotypemaster_PKC primary key (ComponentCode,TypeCode)
+) comment '�\�¬�HŽ–Ží•ÊŠÖ˜Aƒ}ƒXƒ^' ;
+
+create index ComponentToTypeMaster_Index1
+  on componenttotypemaster(ComponentCode);
+
+create index ComponentToTypeMaster_Index2
+  on componenttotypemaster(TypeCode);
+
+-- �HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists constrledgerexpenses cascade;
+
+--* RestoreFromTempTable
+create table constrledgerexpenses (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(5,0) not null comment 'Ž}”Ô'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ïƒR�[ƒh'
+  , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
+  , ExpensesValue decimal(10,0) not null comment 'Œo”ï‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constrledgerexpenses_PKC primary key (ConstructionCode,SeqNo,NameCode)
+) comment '�HŽ–�Ú�×‘ä’ Œo”ïƒf�[ƒ^' ;
+
+create index ConstrLedgerExpenses_Index1
+  on constrledgerexpenses(ConstructionCode);
+
+create index ConstrLedgerExpenses_Index2
+  on constrledgerexpenses(SeqNo);
+
+create index ConstrLedgerExpenses_Index3
+  on constrledgerexpenses(NameCode);
+
+-- �HŽ–Šî–{�î•ñ
+--* BackupToTempTable
+drop table if exists constructionbaseinfo cascade;
+
+--* 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'
+  , JoinFlg decimal(1,0) not null comment 'Œ‹�‡Œ_–ñ�HŽ–ƒtƒ‰ƒO'
+  , ConstructionYear smallint(5) unsigned not null comment '�HŽ–”N“x'
+  , ConstructionPeriod smallint(5) unsigned not null comment '�HŽ–Šú�”'
+  , RequestedDate date comment 'ˆË—ŠŽó‚¯“ú'
+  , EstimatesSubmitDeadline date comment 'Œ©�Ï’ñ�oŠúŒÀ'
+  , EstimatesSubmittedDate date comment 'Œ©�Ï’ñ�o“ú'
+  , ProvisionalOrderDate date comment '‰¼Žó’�“ú'
+  , OrderDate date comment 'Žó’�“ú'
+  , OrderStartingDate date comment 'ŠJŽn—\’è“ú'
+  , OrderCompletionDate date comment 'Š®—¹—\’è“ú'
+  , PreparationStartDate date comment 'Ž{�H�€”õŠJŽn“ú'
+  , ConstructionStartingDate date comment 'Ž{�HŠJŽn“ú'
+  , ConstructionCompletionDate date comment 'Ž{�HŠ®—¹“ú'
+  , NonOrderDate date comment '”ñŽó’�“ú'
+  , OrdersDecisionPrice decimal(12,0) not null comment '�Å”²Žó’�Œˆ’è‹àŠz'
+  , OrdersDecisionPriceInTax decimal(12,0) not null comment '�Å�žŽó’�Œˆ’è‹àŠz'
+  , SalesDepCode decimal(5,0) unsigned not null comment '‰c‹Æ’S“–ŽÒ•”��ƒR�[ƒh'
+  , SalesPersonCode decimal(8,0) unsigned not null comment '‰c‹Æ’S“–ŽÒƒR�[ƒh'
+  , SalesSubDepCode decimal(5,0) unsigned not null comment '‰c‹Æ•›’S“–ŽÒ•”��ƒR�[ƒh'
+  , SalesSubPersonCode decimal(8,0) unsigned not null comment '‰c‹Æ•›’S“–ŽÒƒR�[ƒh'
+  , ConstrDepCode decimal(5,0) unsigned not null comment '�HŽ–’S“–ŽÒ•”��ƒR�[ƒh'
+  , ConstructionPersonCode decimal(8,0) not null comment '�HŽ–’S“–ŽÒƒR�[ƒh'
+  , ConstrSubDepCode decimal(5,0) unsigned not null comment '�HŽ–•›’S“–ŽÒ•”��ƒR�[ƒh'
+  , ConstrSubPersonCode decimal(8,0) not null comment '�HŽ–•›’S“–ŽÒƒR�[ƒh'
+  , ConstrInstrDepCode decimal(5,0) unsigned not null comment '�HŽ–Žw“±ˆõ•”��ƒR�[ƒh'
+  , ConstructionInstructor decimal(8,0) not null comment '�HŽ–Žw“±ˆõƒR�[ƒh'
+  , TransferConstruction decimal(8,0) not null comment '�HŽ–ˆÚŠÇ�æƒR�[ƒh'
+  , TransferConstructionDate date comment '�HŽ–ˆÚŠÇ“ú'
+  , OrderersDivision decimal(5,0) not null comment '”­’�ŽÒ‹æ•ªƒR�[ƒh'
+  , OrderersCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
+  , EstimatesExpirationDate date comment 'Œ©�Ï—LŒøŠúŒÀ'
+  , ConstructionPeriodStart date comment 'Œ_–ñ�HŠúŠJŽn“ú'
+  , ConstructionPeriodEnd date comment 'Œ_–ñ�HŠúŠ®—¹'
+  , ConstructionPeriodStart2 date comment 'Œ_–ñ�HŠúŠJŽn�i‰„’·Žž�j'
+  , ConstructionPeriodEnd2 date comment 'Œ_–ñ�HŠúŠ®—¹�i‰„’·Žž�j'
+  , StartDate date comment '�HŽ–ŠJŽn“ú'
+  , EndDate date comment '�HŽ–�I—¹“ú'
+  , PurchaseOrderMailingDate date comment '’�•¶�‘—X‘—“ú'
+  , PurchaseOrderReturnDate date comment '’�•¶�‘•Ô‘—“ú'
+  , PurchaseOrderReturnCheckDate date comment '’�•¶�‘•Ô‘—Šm”F“ú'
+  , ConsumptionTaxFlg decimal(1,0) not null comment '�Á”ï�Åƒtƒ‰ƒO'
+  , PrimeContractorFlg decimal(1,0) not null comment 'Œ³�¿ƒtƒ‰ƒO'
+  , SalesCostFlg decimal(1,0) not null comment '‰c‹ÆŒo”ï”­�¶ƒtƒ‰ƒO'
+  , ConstructionStatusFlg decimal(2,0) not null comment '�HŽ–�ó‘Ôƒtƒ‰ƒO'
+  , ConstructionType decimal(5,0) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , EstimateType decimal(1,0) not null comment 'Œ©�ÏŽí•Ê'
+  , BillingStartDate date not null comment '�¿‹��€”õŠJŽn“ú'
+  , BillingDate date not null comment '�¿‹�“ú'
+  , BillingSplitFlg decimal(1,0) not null comment '�¿‹�‰ñ�”ƒtƒ‰ƒO'
+  , BillingSendDate date comment '�¿‹��‘—X‘—/Žè“n‚µ“ú'
+  , LedgerComplateDate date not null comment '�HŽ–�Ú�×‘ä’ “ü—ÍŠ®—¹“ú•t'
+  , InspectPlanningDate date not null comment 'ŒŸ�¸—\’è“ú'
+  , InspectExecuteDate date not null comment 'ŒŸ�¸ŽÀ�s“ú'
+  , RevCompleteDate date not null comment 'ŒŸ�¸�¥�³Š®—¹“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
+) comment '�HŽ–Šî–{�î•ñ' ;
+
+create index BaseInfo_Index1
+  on constructionbaseinfo(ConstructionStatusFlg);
+
+create index BaseInfo_Index2
+  on constructionbaseinfo(EstimateType);
+
+create index BaseInfo_Index3
+  on constructionbaseinfo(SalesPersonCode);
+
+create index BaseInfo_Index4
+  on constructionbaseinfo(ConstructionPersonCode);
+
+create index BaseInfo_Index5
+  on constructionbaseinfo(ConstructionInstructor);
+
+create index BaseInfo_Index6
+  on constructionbaseinfo(ConstructionPeriod);
+
+-- �HŽ–Šî–{�î•ñ–¾�×
+--* BackupToTempTable
+drop table if exists constructionbaseinfodetail cascade;
+
+--* RestoreFromTempTable
+create table constructionbaseinfodetail (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , DetailNo decimal(3,0) not null comment '–¾�×”Ô�†'
+  , DetailString varchar(300) comment '–¾�×“à—e'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionbaseinfodetail_PKC primary key (ConstructionCode,DetailNo)
+) comment '�HŽ–Šî–{�î•ñ–¾�×' ;
+
+create index BaseInfoDetail_Idx1
+  on constructionbaseinfodetail(ConstructionCode);
+
+create index BaseInfoDetail_Idx2
+  on constructionbaseinfodetail(DetailNo);
+
+-- �HŽ–Ž{�H—\ŽZƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists constructionbudget cascade;
+
+--* RestoreFromTempTable
+create table constructionbudget (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , CreatorCode decimal(8,0) not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , CreatorName varchar(60) comment '�ì�¬ŽÒ–¼'
+  , CreatorCosts decimal(11,0) not null comment '�ì�¬ŽÒ‹‹—^'
+  , AssistantCode decimal(8,0) not null comment '•›’S“–ŽÒƒR�[ƒh'
+  , AssistantName varchar(60) comment '•›’S“–ŽÒ–¼'
+  , AssistantCosts decimal(11,0) not null comment '•›’S“–ŽÒ‹‹—^'
+  , InstructorCode decimal(8,0) not null comment '�HŽ–Žw“±ˆõƒR�[ƒh'
+  , InstructorName varchar(60) comment '�HŽ–Žw“±ˆõ–¼'
+  , InstructorCosts decimal(11,0) not null comment '�HŽ–Žw“±ˆõ‹‹—^'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , ConstructionTimes decimal(5,2) not null comment '�HŠú�i’PˆÊ�EŒŽ�j'
+  , ConstructionStart date not null comment 'Œ_–ñ�HŠúŠJŽn'
+  , ConstructionEnd date not null comment 'Œ_–ñ�HŠúŠ®—¹'
+  , InstructorTimes decimal(5,2) not null comment 'Žw“±ˆõ‰Ò“­ŒŽ�”'
+  , SalaryFlg decimal(1,0) not null comment '‹‹—^�U•ª‹æ•ª'
+  , SalaryDays decimal(4,0) not null comment '�U•ª“ú�”'
+  , A_SalaryFlg decimal(1,0) not null comment '•›’S“–ŽÒ‹‹—^�U•ª‹æ•ª'
+  , A_SalaryDays decimal(4,0) not null comment '•›’S“–ŽÒ�U•ª“ú�”'
+  , I_SalaryFlg decimal(1,0) not null comment 'Žw“±ˆõ‹‹—^�U•ª‹æ•ª'
+  , I_SalaryDays decimal(4,0) not null comment 'Žw“±ˆõ�U•ª“ú�”'
+  , OrdersDecisionPrice decimal(12,0) not null comment '�Å”²Žó’�Œˆ’è‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionbudget_PKC primary key (ConstructionCode)
+) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^' ;
+
+-- �HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×
+--* BackupToTempTable
+drop table if exists constructionbudgetdetail cascade;
+
+--* 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”Ô�†'
+  , LineCount decimal(3,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 '�€–Ú–¼�Ì'
+  , SecondString varchar(120) comment '�HŽ–“à—e'
+  , CompanyType decimal(1,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒhƒ^ƒCƒv'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , CompanyName varchar(120) comment '‹¦—Í‰ïŽÐ–¼�Ì'
+  , EstimatePrice decimal(12,0) not null comment '�ÏŽZŽžŒ©�Ï‹àŠz'
+  , NegotiationPrice decimal(12,0) not null comment '�ÏŽZŽžŒð�Â‹àŠz'
+  , OrderDesiredAmount decimal(12,0) not null comment '”­’�Šó–]‹àŠz'
+  , ExecutionAmount decimal(12,0) not null comment 'ŽÀ�s‹àŠz'
+  , AmountConfigRate decimal(5,2) not null comment '‹àŠz�\�¬—¦'
+  , NegotiateFlg decimal(1,0) not null comment '‹¦—Í‹ÆŽÒŒð�Âƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionbudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
+) comment '�HŽ–Ž{�H—\ŽZƒf�[ƒ^–¾�×' ;
+
+-- �HŽíƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists constructionitemmaster cascade;
+
+--* RestoreFromTempTable
+create table constructionitemmaster (
+  ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , ItemName varchar(120) not null comment '�HŽí–¼�Ì'
+  , SubItemsFlg decimal(1,0) comment '‰ºˆÊ�€–Úƒtƒ‰ƒO'
+  , MyExpensesFlg decimal(1,0) not null comment 'Ž©ŽÐŒo”ïƒtƒ‰ƒO'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionitemmaster_PKC primary key (ItemCode)
+) comment '�HŽíƒ}ƒXƒ^' ;
+
+-- �HŽ–�Ú�×‘ä’ ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists constructionledger cascade;
+
+--* RestoreFromTempTable
+create table constructionledger (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
+  , CreatorCode decimal(8,0) comment '�ì�¬ŽÒƒR�[ƒh'
+  , CreatorName varchar(60) comment '�ì�¬ŽÒ–¼'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , ConstructionTimes decimal(5,2) not null comment '�HŠú�i’PˆÊ�EŒŽ�j'
+  , ConstructionStart date not null comment 'Œ_–ñ�HŠúŠJŽn'
+  , ConstructionEnd date not null comment 'Œ_–ñ�HŠúŠ®—¹'
+  , OrdersDecisionPrice decimal(14,0) not null comment '�Å”²Žó’�Œˆ’è‹àŠz'
+  , CompanyExpenses decimal(10,0) not null comment '‰ïŽÐŒo”ï�‡Œv'
+  , DepartmentExpenses decimal(10,0) not null comment '•”��Œo”ï�‡Œv'
+  , SalesExpenses decimal(10,0) not null comment '‰c‹ÆŒo”ï�‡Œv'
+  , TotalPayment decimal(10,0) not null comment '‘�Žx•¥Šz'
+  , GrossProfit decimal(10,0) not null comment '‘e—˜'
+  , Allowance decimal(10,0) not null comment '‹‹—^'
+  , NetProfit decimal(10,0) not null comment '�ƒ—˜‰v'
+  , ComplateFlg decimal(1,0) not null comment '“ü—ÍŠ®—¹ƒtƒ‰ƒO'
+  , IntegrationFlg decimal(1,0) not null comment 'Žó’�‹àŠz�ÏŽZƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionledger_PKC primary key (ConstructionCode)
+) comment '�HŽ–�Ú�×‘ä’ ƒf�[ƒ^' ;
+
+create index constructionledger_Index1
+  on constructionledger(ConstructionStart);
+
+create index constructionledger_Index2
+  on constructionledger(ConstructionEnd);
+
+-- �HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists constructionledgerdetail cascade;
+
+--* 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”Ô�†'
+  , 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 '�€–Ú–¼�Ì'
+  , SecondString varchar(120) comment '�HŽ–“à—e'
+  , CompanyType decimal(1,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒhƒ^ƒCƒv'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , CompanyName varchar(120) comment '‹¦—Í‰ïŽÐ–¼�Ì'
+  , EstimatePrice decimal(12,0) not null comment '—\ŽZ�iŒ©�Ï�j‹àŠz'
+  , ExecutionAmount decimal(12,0) not null comment 'ŽÀ�s‹àŠz'
+  , AmountConfigRate decimal(5,2) not null comment '‹àŠz�\�¬—¦'
+  , PaymentBurden decimal(12,0) not null comment 'Žx•¥•â“UŠz'
+  , FixDataFlg decimal(1,0) not null comment 'ŒÅ’èƒf�[ƒ^ƒtƒ‰ƒO'
+  , IndependentFlg decimal(1,0) not null comment '“Æ—§ƒf�[ƒ^ƒtƒ‰ƒO'
+  , FluctuationFlg decimal(1,0) not null comment '‘�Œ¸ƒf�[ƒ^ƒtƒ‰ƒO'
+  , SalaryFlg decimal(1,0) not null comment '‹‹—^�U•ª‹æ•ª'
+  , SalaryDays decimal(4,0) not null comment '‹‹—^�U•ª“ú�”'
+  , OperatingFlg decimal(1,0) not null comment '’S“–’†ƒtƒ‰ƒO'
+  , SourceCode decimal(10,0) unsigned not null comment 'Œ³�HŽ–”Ô�†'
+  , 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 '–¾�×”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
+) comment '�HŽ–�Ú�×‘ä’ –¾�×ƒf�[ƒ^' ;
+
+create index LedgerDetail_Index01
+  on constructionledgerdetail(ConstructionCode);
+
+create index LedgerDetail_Index02
+  on constructionledgerdetail(GroupCount);
+
+create index LedgerDetail_Index03
+  on constructionledgerdetail(LineCount);
+
+create index LedgerDetail_Index04
+  on constructionledgerdetail(SourceCode);
+
+create index LedgerDetail_Index05
+  on constructionledgerdetail(DetailCount);
+
+create index LedgerDetail_Index06
+  on constructionledgerdetail(SalaryFlg);
+
+create index LedgerDetail_Index07
+  on constructionledgerdetail(CompanyCode);
+
+-- �HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists constructionledgerexcute cascade;
+
+--* 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”Ô�†'
+  , LineCount decimal(4,0) unsigned not null comment '�s”Ô�†'
+  , ColumnCount decimal(3,0) not null comment '—ñ”Ô�†'
+  , PaymentAmount decimal(12,0) not null comment 'Žx•¥‹àŠz'
+  , TargetMonth date not null comment '‘Î�Û”NŒŽ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)
+) comment '�HŽ–�Ú�×‘ä’ ŽÀ�sƒf�[ƒ^' ;
+
+create index LedgerExcute_Index1
+  on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
+
+-- �HŽ–ƒŠƒ“ƒN�î•ñ
+--* BackupToTempTable
+drop table if exists constructionlink cascade;
+
+--* RestoreFromTempTable
+create table constructionlink (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , FluctuationCode decimal(10,0) not null comment 'Žq�HŽ–”Ô�†'
+  , LinkType decimal(1,0) not null comment 'ƒŠƒ“ƒNŽí•Ê'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionlink_PKC primary key (ConstructionCode,FluctuationCode)
+) comment '�HŽ–ƒŠƒ“ƒN�î•ñ' ;
+
+create index ConstructionLink_Index1
+  on constructionlink(ConstructionCode);
+
+create index ConstructionLink_Index2
+  on constructionlink(FluctuationCode);
+
+create index ConstructionLink_Index3
+  on constructionlink(LinkType);
+
+-- �HŽ–Ž‘�Þ�î•ñ
+--* BackupToTempTable
+drop table if exists constructionmaterialinfo cascade;
+
+--* 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'
+  , PROCESSDATE datetime default '0000-00-00 00:00:00' not null comment '�ˆ—�”NŒŽ“ú'
+  , RENTCOUNT smallint(5) unsigned comment '‘Ý�o�”'
+  , REPAYCOUNT smallint(5) unsigned comment '•Ô‹p�”'
+  , JUNKCOUNT smallint(5) unsigned comment '”jŠü�”'
+  , COMPLETEFLG tinyint(3) unsigned comment 'Š®—¹ƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE,PROCESSDATE)
+) comment '�HŽ–Ž‘�Þ�î•ñ' ;
+
+-- ˆÄŒ��i’»“ú•tƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists constructionprogressdate cascade;
+
+--* RestoreFromTempTable
+create table constructionprogressdate (
+  ConstructionCode decimal(10,0) not null comment '�HŽ–”Ô�†'
+  , ConstructionStatusFlg decimal(2,0) not null comment '�Ý’è�HŽ–�ó‘Ô'
+  , PreviousStatusFlg decimal(2,0) comment '•Ï�X‘O�ó‘Ô'
+  , ChangeDate datetime not null comment '�Ý’è“ú•t'
+  , ChangePersonCode decimal(8,0) not null comment '�Ý’è’S“–ŽÒ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionprogressdate_PKC primary key (ConstructionCode,ChangeDate)
+) comment 'ˆÄŒ��i’»“ú•tƒf�[ƒ^' ;
+
+create index ConstrProg_Index1
+  on constructionprogressdate(ConstructionCode);
+
+create index ConstrProg_Index2
+  on constructionprogressdate(ConstructionStatusFlg);
+
+create index ConstrProg_Index3
+  on constructionprogressdate(ChangeDate);
+
+-- �ì‹Æƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists constructionspecmaster cascade;
+
+--* RestoreFromTempTable
+create table constructionspecmaster (
+  ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , ItemName varchar(120) comment '�ì‹Æ–¼�Ì'
+  , SpecName varchar(120) comment '�ì‹Æ–¼�Ì'
+  , UnitName varchar(30) comment '’PˆÊ–¼�Ì'
+  , UnitPrice decimal(9,2) not null comment '’P‰¿'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionspecmaster_PKC primary key (ItemCode,SpecCode)
+) comment '�ì‹Æƒ}ƒXƒ^' ;
+
+create index ConstructionSpecMaster_Index1
+  on constructionspecmaster(DisplayOrder);
+
+-- �ì‹Æ’P‰¿ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists constructionspecunitprice cascade;
+
+--* RestoreFromTempTable
+create table constructionspecunitprice (
+  ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
+  , ConstructionTypeCode mediumint(8) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , UnitPrice decimal(9,2) not null comment '’P‰¿'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructionspecunitprice_PKC primary key (ComponentCode,ItemCode,SpecCode,ConstructionTypeCode)
+) comment '�ì‹Æ’P‰¿ƒ}ƒXƒ^' ;
+
+-- �HŽ–Ží•Êƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists constructiontypemaster cascade;
+
+--* RestoreFromTempTable
+create table constructiontypemaster (
+  TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , NameString varchar(100) not null comment '–¼�Ì'
+  , PublicFlg decimal(1,0) not null comment 'Œö‹¤ƒtƒ‰ƒO'
+  , RepairFlg decimal(1,0) not null comment '�V’z�E‰ü�Cƒtƒ‰ƒO'
+  , SecRank decimal(1,0) not null comment '•ÛŒì‹æ•ªƒ‰ƒ“ƒN'
+  , ExpensesLink decimal(1,0) not null comment 'Œo”ïŽg—p‹æ•ª'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint constructiontypemaster_PKC primary key (TypeCode)
+) comment '�HŽ–Ží•Êƒ}ƒXƒ^' ;
+
+-- •”���o”[ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists costdataofdepartment cascade;
+
+--* RestoreFromTempTable
+create table costdataofdepartment (
+  DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , ConstrYear smallint(5) unsigned not null comment '�HŽ–Šú�”�E”N�”'
+  , SeqNo decimal(5,0) unsigned not null comment 'ƒf�[ƒ^”Ô�†'
+  , CostDate date not null comment '‘Î�Û“ú•t'
+  , DepartmentName varchar(100) not null comment '•”��–¼'
+  , SuppliersCode decimal(8,0) unsigned not null comment '�o”[�æƒR�[ƒh'
+  , SuppliersName varchar(120) comment '�o”[�æ–¼'
+  , PaymentContent varchar(100) comment '�o”[“à—e'
+  , SendReceiveFlg decimal(1,0) not null comment '�o”[ƒtƒ‰ƒO'
+  , EntryPrice decimal(12,0) not null comment '‹àŠz�i�Å”²�j'
+  , EntryTax decimal(12,0) not null comment '‹àŠz�i�Å�ž�j'
+  , Coment varchar(100) comment '”õ�l'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint costdataofdepartment_PKC primary key (DepartmentCode,ConstrYear,SeqNo)
+) comment '•”���o”[ƒf�[ƒ^' ;
+
+-- ’S“–ŽÒ–ˆŒo”ïƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists costdataofperson cascade;
+
+--* RestoreFromTempTable
+create table costdataofperson (
+  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , ActionDate date not null comment '‘Î�Û“ú•t'
+  , DataType decimal(1,0) not null comment 'ƒf�[ƒ^‹æ•ª'
+  , DataAddCount decimal(5,0) unsigned not null comment 'ƒf�[ƒ^’Ç‰Á”Ô�†'
+  , TargetMonth varchar(7) not null comment '‘Î�Û”NŒŽ'
+  , ConstructionCode decimal(10,0) unsigned comment '�HŽ–ƒR�[ƒh'
+  , SuppliersCode decimal(5,0) unsigned not null comment 'Žx•¥�æƒR�[ƒh'
+  , SuppliersName varchar(120) comment 'Žx•¥�æ–¼�Ì'
+  , PaymentContent varchar(60) comment 'Žx•¥“à—e'
+  , PaymentType decimal(1,0) not null comment 'Žx•¥•û–@ƒtƒ‰ƒO'
+  , EntryPrice decimal(12,0) not null comment '‹àŠz�i�Å”²�j'
+  , EntryPriceInTax decimal(12,0) not null comment '‹àŠz�i�Å�ž�j'
+  , SlipNumber varchar(12) comment '“`•[”Ô�†'
+  , ComplateFlg decimal(1,0) not null comment 'ˆø�ž�Ï‚Ýƒtƒ‰ƒO'
+  , ApprovalFlg decimal(1,0) not null comment '�³”Fƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint costdataofperson_PKC primary key (PersonCode,ActionDate,DataType,DataAddCount)
+) comment '’S“–ŽÒ–ˆŒo”ïƒf�[ƒ^' ;
+
+create index CostDataOfPerson_Index1
+  on costdataofperson(TargetMonth);
+
+create index CostDataOfPerson_Index2
+  on costdataofperson(ConstructionCode);
+
+-- ”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists costomerregist cascade;
+
+--* RestoreFromTempTable
+create table costomerregist (
+  CreatePersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , SeqNo decimal(2,0) not null comment 'ƒL�[˜A”Ô'
+  , DataMode decimal(1,0) not null comment 'ƒf�[ƒ^‹æ•ª'
+  , SourceCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
+  , SourceCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
+  , PetitionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
+  , OrderFlg decimal(1,0) not null comment '–@�l’c‘Ì�EŒÂ�lƒtƒ‰ƒO'
+  , CorporateStatusName varchar(100) comment '–@�lŠi–¼�Ì'
+  , CorporateStatusPoint decimal(1,0) comment '–@�lŠi–¼�ÌˆÊ’u'
+  , OrderersName1 varchar(60) not null comment '”­’�ŽÒ–¼1'
+  , OrderersName2 varchar(60) comment '”­’�ŽÒ–¼‚Q'
+  , DepartmentName varchar(60) comment '•”��–¼'
+  , PersonName varchar(60) comment '’S“–ŽÒ–¼'
+  , ZipCode varchar(8) comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) comment '�Z�Š‚P'
+  , Address2 varchar(60) comment '�Z�Š2'
+  , Address3 varchar(60) comment '�Z�Š3'
+  , PhoneNumber varchar(13) comment '“d˜b”Ô�†'
+  , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , 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 '�\�¿“ú'
+  , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
+  , CreateDepartmentCode decimal(5,0) unsigned not null comment '�\�¿•”��ƒR�[ƒh'
+  , CreateDepartmentName varchar(60) comment '�\�¿•”��–¼'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint costomerregist_PKC primary key (CreatePersonCode,CreateDate,SeqNo)
+) comment '”­’�ŽÒ“o˜^�\�¿ƒf�[ƒ^' ;
+
+create index CostomerRegist_Index1
+  on costomerregist(PetitionPeriod);
+
+create index CostomerRegist_Index2
+  on costomerregist(CreatePersonCode);
+
+create index CostomerRegist_Index3
+  on costomerregist(CreateDepartmentCode);
+
+-- “ú•ñƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists dailydataconstruction cascade;
+
+--* RestoreFromTempTable
+create table dailydataconstruction (
+  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , Weather varchar(60) comment '“V‹C'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint dailydataconstruction_PKC primary key (PersonCode,DailyDataDate,ConstructionCode)
+) comment '“ú•ñƒf�[ƒ^' ;
+
+create index DailyDataConstruction_Index1
+  on dailydataconstruction(PersonCode);
+
+create index DailyDataConstruction_Index2
+  on dailydataconstruction(DailyDataDate);
+
+create index DailyDataConstruction_Index3
+  on dailydataconstruction(ConstructionCode);
+
+-- “ú•ñƒf�[ƒ^ (–¾�×)
+--* BackupToTempTable
+drop table if exists dailydatadetail cascade;
+
+--* RestoreFromTempTable
+create table dailydatadetail (
+  PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , TodayHeadCount decimal(4,1) not null comment '“–“ú�lˆõ�”'
+  , TotalHeadCount decimal(5,1) not null comment '—ÝŒv�lˆõ�”'
+  , TodayWork varchar(100) comment '“–“ú�ì‹Æ“à—e'
+  , NextdayWork varchar(100) comment '—‚“ú�ì‹Æ“à—e'
+  , NextdayHeadCount decimal(4,1) not null comment '—‚“ú�lˆõ�”'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint dailydatadetail_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+) comment '“ú•ñƒf�[ƒ^ (–¾�×)' ;
+
+create index DailyDataDetail_Index
+  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
+
+-- “ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)
+--* BackupToTempTable
+drop table if exists dailydatafield cascade;
+
+--* RestoreFromTempTable
+create table dailydatafield (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , PatrolTime datetime not null comment '�„‰ñŽžŠÔ'
+  , ContentsText varchar(200) comment '“à—e'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint dailydatafield_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+) comment '“ú•ñƒf�[ƒ^ (Œ»�ê�„‰ñ)' ;
+
+create index DailyDataField_Index
+  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
+
+-- “ú•ñƒf�[ƒ^ (Ž‘�Þ)
+--* BackupToTempTable
+drop table if exists dailydatamaterials cascade;
+
+--* RestoreFromTempTable
+create table dailydatamaterials (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , Materials varchar(100) comment 'Ž‘�Þ–¼'
+  , Quantity varchar(100) comment '�”—Ê'
+  , Production varchar(100) comment '�§�ì‰ïŽÐ'
+  , Delivery varchar(100) comment '”[“ü‹ÆŽÒ'
+  , QualityControl varchar(100) comment '•iŽ¿ŠÇ—�Ž–�€'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint dailydatamaterials_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+) comment '“ú•ñƒf�[ƒ^ (Ž‘�Þ)' ;
+
+create index DailyDataMaterials_Index
+  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
+
+-- “ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)
+--* BackupToTempTable
+drop table if exists dailydatasubcontractors cascade;
+
+--* RestoreFromTempTable
+create table dailydatasubcontractors (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , Attendee varchar(100) comment '�o�ÈŽÒ'
+  , ContentsText varchar(200) comment '“à—e'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint dailydatasubcontractors_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+) comment '“ú•ñƒf�[ƒ^ (‹¦—Í‹ÆŽÒŽwŽ¦)' ;
+
+create index DailyDataSubcontractors_Index
+  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
+
+-- “ú•ñƒf�[ƒ^ (ŽÔ—¼)
+--* BackupToTempTable
+drop table if exists dailydatavehicles cascade;
+
+--* RestoreFromTempTable
+create table dailydatavehicles (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , DailyDataDate date not null comment '“ú•ñ�ì�¬“ú'
+  , ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , Model varchar(100) comment '‹@Ží'
+  , Performance varchar(100) comment '�«”\'
+  , Owner varchar(100) comment '�Š—L‰ïŽÐ'
+  , Driver varchar(100) comment '“–“ú‰^“]ŽÒ'
+  , StartWorkingTime datetime not null comment '�ì‹ÆŽžŠÔŠJŽn'
+  , EndWorkingTime datetime not null comment '�ì‹ÆŽžŠÔ�I—¹'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint dailydatavehicles_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
+) comment '“ú•ñƒf�[ƒ^ (ŽÔ—¼)' ;
+
+create index DailyDataVehicles_Index
+  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
+
+-- “úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists daymaster cascade;
+
+--* RestoreFromTempTable
+create table daymaster (
+  days smallint(6) not null comment '“ú'
+  , constraint daymaster_PKC primary key (days)
+) comment '“úƒ}ƒXƒ^' ;
+
+-- ’÷“úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists deadlinemaster cascade;
+
+--* RestoreFromTempTable
+create table deadlinemaster (
+  LABOURKIND decimal(1,0) default '0' not null comment 'ŽèŠÔ‹ÆŽÒ‹æ•ª'
+  , DEADLINE decimal(2,0) comment '’÷“ú'
+  , PAYDAY decimal(2,0) comment 'Žx•¥“ú'
+  , NOTE varchar(120) comment '”õ�l'
+  , DELETEFLG decimal(1,0) comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint deadlinemaster_PKC primary key (LABOURKIND)
+) comment '’÷“úƒ}ƒXƒ^' ;
+
+-- •”��Œo”ï—¦ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists departmentexpensesmaster cascade;
+
+--* RestoreFromTempTable
+create table departmentexpensesmaster (
+  DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ïƒR�[ƒh'
+  , NameString varchar(100) not null comment '–¼�Ì'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint departmentexpensesmaster_PKC primary key (DepartmentCode,ExpensesPeriod,NameCode)
+) comment '•”��Œo”ï—¦ƒ}ƒXƒ^' ;
+
+-- •”��ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists departmentmaster cascade;
+
+--* RestoreFromTempTable
+create table departmentmaster (
+  DepartmentCode decimal(5,0) unsigned not null comment '•”��ƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , DepartmentString varchar(100) not null comment '•”��–¼'
+  , ActionScheduleFlg decimal(1,0) not null comment '�s“®—\’è•\Ž¦ƒtƒ‰ƒO'
+  , StaffAssignFlg decimal(1,0) not null comment '�lˆõ”z’u•\Ž¦ƒtƒ‰ƒO'
+  , StartDate datetime not null comment 'ŠJŽn“ú•t'
+  , CompDate datetime not null comment '�I—¹“ú•t'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint departmentmaster_PKC primary key (DepartmentCode)
+) comment '•”��ƒ}ƒXƒ^' ;
+
+create index DepartmentMaster_index1
+  on departmentmaster(DisplayOrder);
+
+-- “ü‹àŠm”F�³”Fƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists depositapprovalinfo cascade;
+
+--* RestoreFromTempTable
+create table depositapprovalinfo (
+  ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , TARGETDATE decimal(6,0) not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) not null comment '�s”Ô�†'
+  , APPROVALNO decimal(3,0) not null comment '�³”F�‡�˜'
+  , APPROVALPERSON decimal(8,0) comment '�³”FŽÒƒR�[ƒh'
+  , APPROVALPERSONNAME varchar(20) comment '�³”FŽÒ–¼'
+  , APPROVALAUTHORITY decimal(1,0) comment '�³”FŒ ŒÀ‹æ•ª'
+  , APPROVALDATE date comment '�³”F“ú•t'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
+) comment '“ü‹àŠm”F�³”Fƒf�[ƒ^' ;
+
+-- “ü‹àƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists depositdata cascade;
+
+--* RestoreFromTempTable
+create table depositdata (
+  ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , TARGETDATE decimal(6,0) not null comment '‘Î�Û”NŒŽ'
+  , SEQNO decimal(3,0) not null comment '˜A”Ô'
+  , BUSINESSPERIOD decimal(4,0) comment '‰c‹ÆŠú'
+  , DEPOSITDATE date comment '“ü‹à“ú'
+  , DEPOSITAMOUNT decimal(12,0) comment '“ü‹à‹àŠz'
+  , DEPOSITAMOUNTCASH decimal(10,0) comment '“ü‹à‹àŠz�iŒ»‹à�j'
+  , DEPOSITAMOUNTBILL decimal(10,0) comment '“ü‹à‹àŠz�iŽèŒ`�j'
+  , DEPOSITPERSONCODE decimal(8,0) not null comment '“ü‹à’S“–ŽÒƒR�[ƒh'
+  , NOTE varchar(120) comment '”õ�l'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO)
+) comment '“ü‹àƒf�[ƒ^' ;
+
+-- “ü‹à–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists depositdatadetail cascade;
+
+--* 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”Ô�†'
+  , DEPOSITAMOUNT decimal(10,0) comment '“ü‹à‹àŠz'
+  , DISCOUNTAMOUNT decimal(10,0) comment '’lˆø‚«‹àŠz'
+  , CNSTRPRICE decimal(10,0) comment '‹¦—Í‹à'
+  , FEES decimal(10,0) comment 'Žè�”—¿'
+  , OTHERADJUSTMENTS decimal(10,0) comment '‚»‚Ì‘¼'
+  , DIFFERENCEAMOUNT decimal(10,0) comment '�·•ª'
+  , CONFIRMATIONPERSONCODE decimal(8,0) comment 'Šm”F’S“–ŽÒƒR�[ƒh'
+  , CONFIRMATIONDATE date comment '’S“–ŽÒŠm”F“ú•t'
+  , CONFIRMATIONENDFLG decimal(1,0) comment 'Šm”FŠ®—¹ƒtƒ‰ƒO'
+  , 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)
+) comment '“ü‹à–¾�×ƒf�[ƒ^' ;
+
+-- ‹æ•ªƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists divisionmaster cascade;
+
+--* RestoreFromTempTable
+create table divisionmaster (
+  DivisionCode decimal(5,0) unsigned not null comment '‹æ•ªƒR�[ƒh'
+  , NameCode decimal(5,0) unsigned not null comment '–¼�ÌƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , NameString varchar(100) not null comment '–¼�Ì'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint divisionmaster_PKC primary key (DivisionCode,NameCode)
+) comment '‹æ•ªƒ}ƒXƒ^' ;
+
+-- �ÏŽZ—\ŽZ�‘ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists estimatebudget cascade;
+
+--* RestoreFromTempTable
+create table estimatebudget (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ConstructionTime decimal(5,2) unsigned not null comment '�HŠú'
+  , IntegratedCode decimal(8,0) not null comment '�ÏŽZŽÒ'
+  , DataCreateDate datetime not null comment 'ƒf�[ƒ^ˆø�ž“ú'
+  , RetValue1 decimal(12,0) not null comment '—\’è‰¿Ši'
+  , RetValue2 decimal(12,0) not null comment '’¼�Ú�HŽ–”ï'
+  , RetValue3 decimal(12,0) not null comment '�Ï‚Ý�ã‚°‹¤’Ê‰¼�Ý”ï'
+  , RetValue4 decimal(12,0) not null comment '�Ï‚Ý�ã‚°Œ»�êŠÇ—�”ï'
+  , RetPercent decimal(5,2) not null comment 'ˆê”ÊŠÇ—�”ï—¦'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint estimatebudget_PKC primary key (ConstructionCode)
+) comment '�ÏŽZ—\ŽZ�‘ƒf�[ƒ^' ;
+
+-- �ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×
+--* BackupToTempTable
+drop table if exists estimatebudgetdetail cascade;
+
+--* 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”Ô�†'
+  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned comment '�HŽíƒL�['
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , FirstString varchar(120) comment '‘å�€–Ú–¼�Ì'
+  , SecondString varchar(120) comment '�HŽí–¼�Ì�E‹¦—Í‰ïŽÐ–¼'
+  , Content varchar(120) comment '“à—e'
+  , EstimatePrice decimal(12,0) not null comment 'Œ©�ÏŽž‹àŠz'
+  , NegotiationPrice decimal(12,0) not null comment 'Œð�ÂŽž‹àŠz'
+  , Notes varchar(120) comment '’�ˆÓŽ–�€'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint estimatebudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
+) comment '�ÏŽZ—\ŽZ“à–óƒf�[ƒ^–¾�×' ;
+
+-- �ÏŽZŒ©�Ïƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists estimatedata cascade;
+
+--* RestoreFromTempTable
+create table estimatedata (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , FixedItemCode varchar(1) comment 'ŒÅ’è�€–ÚƒL�['
+  , ItemName varchar(120) comment '�ì‹Æ–¼�Ì'
+  , SpecName varchar(120) comment '�ì‹Æ�^•iŽ¿�EŒ`�ó�E�¡–@'
+  , PriceValue decimal(14,0) not null comment '‹àŠz'
+  , note varchar(60) comment '”õ�l'
+  , MyExpensesFlg decimal(1,0) not null comment 'Ž©ŽÐŒo”ïƒtƒ‰ƒO'
+  , InputFlg decimal(1,0) not null comment '“ü—Íƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint estimatedata_PKC primary key (ConstructionCode,LineCount)
+) comment '�ÏŽZŒ©�Ïƒf�[ƒ^' ;
+
+create index EstimateData_Index1
+  on estimatedata(ConstructionCode,FixedItemCode);
+
+-- �ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists estimatedatabody cascade;
+
+--* 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”Ô�†'
+  , Category decimal(1,0) not null comment 'ƒy�[ƒW‹æ•ª'
+  , UnionComponentCode decimal(5,0) unsigned not null comment '�Š‘®�\�¬ƒL�['
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SelectComponent decimal(5,0) unsigned not null comment '‘I‘ð�\�¬ƒL�['
+  , PageTitle varchar(120) not null comment 'ƒy�[ƒW•\Ž¦–¼'
+  , DetailLineCount decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint estimatedatabody_PKC primary key (ConstructionCode,PageCount)
+) comment '�ÏŽZŒ©�Ïƒy�[ƒWƒf�[ƒ^' ;
+
+create index EstimateDataBody_Index1
+  on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);
+
+-- �ÏŽZŒ©�Ïƒf�[ƒ^–¾�×
+--* BackupToTempTable
+drop table if exists estimatedatadetail cascade;
+
+--* 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”Ô�†'
+  , LineCount decimal(3,0) unsigned not null comment '�s”Ô�†'
+  , DataType decimal(1,0) not null comment 'ƒf�[ƒ^Ží•Ê'
+  , ComponentCode decimal(5,0) unsigned not null comment '�\�¬ƒL�['
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , SpecCode decimal(5,0) unsigned not null comment '�ì‹ÆƒL�['
+  , ItemName varchar(120) comment '�ì‹Æ–¼�Ì'
+  , SpecName varchar(120) comment '�ì‹Æ�^•iŽ¿�EŒ`�ó�E�¡–@'
+  , Unitcount decimal(8,2) not null comment '�”—Ê'
+  , UnitName varchar(30) comment '’PˆÊ–¼�Ì'
+  , UnitPrice decimal(9,2) not null comment '’P‰¿'
+  , LineTotal decimal(12,0) not null comment '‹àŠz'
+  , note varchar(60) comment '”õ�l'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , MyExpensesFlg decimal(1,0) not null comment 'Ž©ŽÐŒo”ïƒtƒ‰ƒO'
+  , InputFlg decimal(1,0) comment '“ü—Íƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint estimatedatadetail_PKC primary key (ConstructionCode,PageCount,LineCount)
+) comment '�ÏŽZŒ©�Ïƒf�[ƒ^–¾�×' ;
+
+create index EstimateDataDetail_Index1
+  on estimatedatadetail(ConstructionCode,PageCount);
+
+-- Œo”ï—¦ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists expensesmaster cascade;
+
+--* RestoreFromTempTable
+create table expensesmaster (
+  DivisionCode smallint(6) not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , NameCode smallint(6) not null comment 'Œo”ï–¼�ÌƒR�[ƒh'
+  , DisplayOrder smallint(6) not null comment '•\Ž¦�‡'
+  , ExpensesRatio decimal(4,2) not null comment 'Œo”ï—¦'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint expensesmaster_PKC primary key (DivisionCode,NameCode)
+) comment 'Œo”ï—¦ƒ}ƒXƒ^' ;
+
+-- ‰ïŽÐ‹x“úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists holidaycalendermaster cascade;
+
+--* RestoreFromTempTable
+create table holidaycalendermaster (
+  Holiday date not null comment '‹x“ú'
+  , BusinessYear smallint(5) unsigned not null comment '‰c‹Æ”N“x'
+  , TargetMonth tinyint(3) unsigned not null comment 'ŠY“–ŒŽ'
+  , TargetDay tinyint(3) unsigned not null comment 'ŠY“–“ú'
+  , constraint holidaycalendermaster_PKC primary key (Holiday)
+) comment '‰ïŽÐ‹x“úƒ}ƒXƒ^' ;
+
+create index HolidayCalender_Index1
+  on holidaycalendermaster(BusinessYear);
+
+create index HolidayCalenderMaster_Index2
+  on holidaycalendermaster(TargetMonth);
+
+create index HolidayCalenderMaster_Index3
+  on holidaycalendermaster(TargetDay);
+
+-- “ü—ÍŽžŒŸ�õ—š—ð
+--* BackupToTempTable
+drop table if exists inputsearchlogdata cascade;
+
+--* RestoreFromTempTable
+create table inputsearchlogdata (
+  ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
+  , UsedProcessNo decimal(4,0) not null comment 'Žg—p‹@”\”Ô�†'
+  , DisplayOrder decimal(4,0) unsigned not null comment '•\Ž¦�‡'
+  , DataType decimal(1,0) not null comment 'ƒf�[ƒ^Ží•Ê'
+  , InputCode decimal(10,0) comment '“ü—ÍƒR�[ƒh'
+  , constraint inputsearchlogdata_PKC primary key (ConstructionCode,UsedProcessNo,DisplayOrder)
+) comment '“ü—ÍŽžŒŸ�õ—š—ð' ;
+
+create index InputSearchLogData_Index1
+  on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
+
+-- �¿‹��‘ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists invoicedata cascade;
+
+--* RestoreFromTempTable
+create table invoicedata (
+  INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
+  , ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , REQUESTMONTH decimal(6,0) not null comment '�¿‹�ŒŽ'
+  , SEQNO decimal(2,0) not null comment '˜A”Ô'
+  , CRETATEDATE date not null comment '�ì�¬“ú'
+  , REQUESTDATE date not null comment '�¿‹�“ú'
+  , REQUESTNAME varchar(120) comment '�¿‹��æ–¼'
+  , TOTALAMOUNT decimal(10,0) comment '�Å�ž‚Ý�‡Œv‹àŠz'
+  , TAXAMOUNT decimal(10,0) comment '�Á”ï�Å‹àŠz'
+  , COMMENT1 varchar(60) comment 'ƒRƒ�ƒ“ƒg1'
+  , COMMENT2 varchar(60) comment 'ƒRƒ�ƒ“ƒg2'
+  , COMMENT3 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg3'
+  , COMMENT4 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg4'
+  , COMMENT5 varchar(60) not null comment 'ƒRƒ�ƒ“ƒg5'
+  , COMPLETEFLG decimal(1,0) default '0' not null comment 'Š®—¹ƒtƒ‰ƒO'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint invoicedata_PKC primary key (INVOICENO)
+) comment '�¿‹��‘ƒf�[ƒ^' ;
+
+alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
+
+-- Ž‘�Þ�î•ñ
+--* BackupToTempTable
+drop table if exists materialinfo cascade;
+
+--* RestoreFromTempTable
+create table materialinfo (
+  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
+  , MATERIALCOUNT smallint(5) unsigned comment 'Ž‘�Þ�”'
+  , RENTCOUNT smallint(5) unsigned comment '‘Ý�o‰Â”\�”'
+  , DELETEFLG smallint(5) unsigned comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialinfo_PKC primary key (MATERIALITEMCODE)
+) comment 'Ž‘�Þ�î•ñ' ;
+
+-- Ž‘�Þ•i–Úƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists materialitemmaster cascade;
+
+--* RestoreFromTempTable
+create table materialitemmaster (
+  MATERIALITEMCODE smallint(5) unsigned default 0 not null comment 'Ž‘�Þ•i–ÚƒR�[ƒh'
+  , MATERIALKINDCODE smallint(5) unsigned comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
+  , MATERIALITEMNAME varchar(40) comment 'Ž‘�Þ•i–Ú–¼�Ì'
+  , DISPLAYORDER smallint(5) unsigned comment '•\Ž¦�‡'
+  , DELETEFLG tinyint(3) unsigned comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , VERSIONNO decimal(8,0) default '0' not null comment 'ƒo�[ƒWƒ‡ƒ“”Ô�†'
+  , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE)
+) comment 'Ž‘�Þ•i–Úƒ}ƒXƒ^' ;
+
+-- Ž‘�ÞŽí—Þƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists materialkindmaster cascade;
+
+--* RestoreFromTempTable
+create table materialkindmaster (
+  MATERIALKINDCODE smallint(5) unsigned default 0 not null comment 'Ž‘�ÞŽí—ÞƒR�[ƒh'
+  , MATERIALKINDNAME varchar(40) comment 'Ž‘�ÞŽí—Þ–¼�Ì'
+  , DISPLAYORDER smallint(5) unsigned comment '•\Ž¦�‡'
+  , DELETEFLG tinyint(3) unsigned comment '�í�œƒtƒ‰ƒO'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE)
+) comment 'Ž‘�ÞŽí—Þƒ}ƒXƒ^' ;
+
+-- Ž‘�Þ—š—ð�î•ñ
+--* BackupToTempTable
+drop table if exists materialrecordinfo cascade;
+
+--* 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ŒŽ“ú'
+  , SEQNO smallint(5) unsigned default 0 not null comment '˜A”Ô'
+  , RECKIND tinyint(3) unsigned comment 'ƒŒƒR�[ƒh‹æ•ª'
+  , CONSTRUCTIONCODE int(10) unsigned comment '�HŽ–”Ô�†'
+  , PERSONCODE int(10) unsigned comment '’S“–ŽÒƒR�[ƒh'
+  , MATERIALCOUNT smallint(5) unsigned comment 'Ž‘�Þ�”'
+  , REPAYPLANDATE date comment '•Ô‹p—\’è”NŒŽ“ú'
+  , COMMENTTEXT varchar(80) comment 'ƒRƒ�ƒ“ƒg'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO)
+) comment 'Ž‘�Þ—š—ð�î•ñ' ;
+
+-- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW
+--* BackupToTempTable
+drop table if exists messageboarddata cascade;
+
+--* RestoreFromTempTable
+create table messageboarddata (
+  RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
+  , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
+  , FromCode decimal(8,0) unsigned not null comment '�‘�ž‚ÝŽÒƒR�[ƒh'
+  , FromName varchar(60) not null comment '�‘�ž‚ÝŽÒ'
+  , MessageTitile varchar(100) comment '“`Œ¾ƒ^ƒCƒgƒ‹'
+  , MessageContent varchar(1333) not null comment '“`Œ¾“à—e'
+  , LinkType decimal(2,0) not null comment 'ƒŠƒ“ƒN“®�ìƒ^ƒCƒv'
+  , LinkMessage varchar(200) comment 'ƒŠƒ“ƒN•¶Žš—ñ'
+  , LinkCode varchar(30) comment 'ƒŠƒ“ƒNƒL�['
+  , WritingDate datetime not null comment '�‘�ž‚Ý“úŽž'
+  , 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ƒ‰�['
+  , MessageFlag decimal(1,0) not null comment 'ƒ�ƒbƒZ�[ƒWƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint messageboarddata_PKC primary key (RecordNumber,BranchNumber)
+) comment 'ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW' ;
+
+create index MessageBoardData_Index1
+  on messageboarddata(WritingDate);
+
+create index MessageBoardData_Index2
+  on messageboarddata(MessageFlag);
+
+-- ŒfŽ¦”Â‘Î�ÛŽÒƒe�[ƒuƒ‹
+--* BackupToTempTable
+drop table if exists messageboardterget cascade;
+
+--* RestoreFromTempTable
+create table messageboardterget (
+  RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
+  , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
+  , SeqNum decimal(3,0) unsigned not null comment '�‡”Ô'
+  , ToCode decimal(8,0) not null comment '‘Î�ÛŽÒƒR�[ƒh'
+  , ToName varchar(60) not null comment '‘Î�ÛŽÒ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint messageboardterget_PKC primary key (RecordNumber,BranchNumber,SeqNum)
+) comment 'ŒfŽ¦”Â‘Î�ÛŽÒƒe�[ƒuƒ‹' ;
+
+create index MessageBoardTerget_Index1
+  on messageboardterget(RecordNumber,BranchNumber);
+
+-- ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð
+--* BackupToTempTable
+drop table if exists messagebrowsinghistory cascade;
+
+--* RestoreFromTempTable
+create table messagebrowsinghistory (
+  RecordNumber decimal(6,0) unsigned not null comment 'ƒŒƒR�[ƒh”Ô�†'
+  , BranchNumber decimal(3,0) unsigned not null comment 'ƒŒƒR�[ƒhŽ}”Ô'
+  , SeqNum decimal(3,0) unsigned not null comment '�‡”Ô'
+  , BrowsingCode decimal(8,0) not null comment '‰{——ŽÒƒR�[ƒh'
+  , BrowsingDate datetime not null comment '‰{——“ú•t'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint messagebrowsinghistory_PKC primary key (RecordNumber,BranchNumber,SeqNum)
+) comment 'ŒfŽ¦”Âƒ�ƒbƒZ�[ƒW‰{———š—ð' ;
+
+-- ŒŽƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists monthmaster cascade;
+
+--* RestoreFromTempTable
+create table monthmaster (
+  month smallint(6) not null comment 'ŒŽ'
+  , constraint monthmaster_PKC primary key (month)
+) comment 'ŒŽƒ}ƒXƒ^' ;
+
+-- ”­’�ŽÒƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists orderersmaster cascade;
+
+--* RestoreFromTempTable
+create table orderersmaster (
+  OrderCotegory decimal(5,0) unsigned not null comment '”­’�ŽÒ‹æ•ª'
+  , OrderersCode decimal(5,0) unsigned not null comment '”­’�ŽÒƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , OrderFlg decimal(1,0) not null comment '–@�l’c‘Ì�EŒÂ�lƒtƒ‰ƒO'
+  , CorporateStatusName varchar(100) comment '–@�lŠi–¼�Ì'
+  , CorporateStatusPoint decimal(1,0) comment '–@�lŠi–¼�ÌˆÊ’u'
+  , OrderersName1 varchar(60) not null comment '”­’�ŽÒ–¼1'
+  , OrderersName2 varchar(60) comment '”­’�ŽÒ–¼‚Q'
+  , DepartmentName varchar(60) comment '•”��–¼'
+  , ChargePersonName varchar(60) comment '’S“–ŽÒ–¼'
+  , ZipCode varchar(8) comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) comment '�Z�Š‚P'
+  , Address2 varchar(60) comment '�Z�Š2'
+  , Address3 varchar(60) comment '�Z�Š3'
+  , PhoneNumber varchar(13) comment '“d˜b”Ô�†'
+  , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
+  , 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 orderersmaster_PKC primary key (OrderCotegory,OrderersCode)
+) comment '”­’�ŽÒƒ}ƒXƒ^' ;
+
+-- Žó’�‹àŠzƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists orderspricedata cascade;
+
+--* RestoreFromTempTable
+create table orderspricedata (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ChangeNo decimal(3,0) unsigned not null comment '•Ï�X”Ô�†'
+  , ChangeDate date not null comment '•Ï�X“ú'
+  , ChangePersonCode decimal(8,0) unsigned not null comment '•Ï�XŽÒƒR�[ƒh'
+  , ChangePersonName varchar(60) comment '•Ï�XŽÒ–¼'
+  , BeforeValue decimal(14,0) not null comment '•Ï�X‘O�Å”²Žó’�‹àŠz'
+  , BeforeValueInTax decimal(14,0) not null comment '•Ï�X‘O�Å�žŽó’�‹àŠz'
+  , AfterValue decimal(14,0) not null comment '•Ï�XŒã�Å”²Žó’�‹àŠz'
+  , AfterValueInTax decimal(14,0) not null comment '•Ï�XŒã�Å�žŽó’�‹àŠz'
+  , ChangeComment varchar(200) comment '•Ï�X—�—R'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint orderspricedata_PKC primary key (ConstructionCode,ChangeNo)
+) comment 'Žó’�‹àŠzƒf�[ƒ^' ;
+
+-- Žx•¥�³”F�î•ñƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists paymentapprovalinfo cascade;
+
+--* 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ŒŽ'
+  , SEQNO decimal(3,0) default '0' not null comment '˜A”Ô'
+  , LINECOUNT decimal(3,0) default '0' not null comment '�s”Ô�†'
+  , APPROVALNO decimal(3,0) default '0' not null comment '�³”F�‡�˜'
+  , APPROVALPERSON decimal(8,0) comment '�³”FŽÒƒR�[ƒh'
+  , APPROVALPERSONNAME varchar(20) comment '�³”FŽÒ–¼'
+  , APPROVALAUTHORITY decimal(1,0) comment '�³”FŒ ŒÀ‹æ•ª'
+  , APPROVALDATE date comment '�³”F“ú•t'
+  , ENTRYDATE datetime comment '“o˜^“ú•t'
+  , UPDATEDATE datetime comment '�X�V“ú•t'
+  , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
+) comment 'Žx•¥�³”F�î•ñƒf�[ƒ^' ;
+
+-- Žx•¥–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists paymentdatadetail cascade;
+
+--* 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”Ô�†'
+  , BILLPRICE decimal(10,0) comment '�¿‹�‹àŠz'
+  , DISCOUNTPRICE decimal(10,0) comment '’lˆø‚«‹àŠz'
+  , OFFSETPRICE decimal(10,0) comment '‘ŠŽE‹àŠz'
+  , NEXTCOPRICE decimal(10,0) comment 'ŽŸ‰ñŒJ‰z'
+  , HIGHWPRICE decimal(10,0) comment '�‚‘¬‘ã'
+  , HARDWPRICE decimal(10,0) comment '‹à•¨‘ã'
+  , 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'
+  , 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)
+) comment 'Žx•¥–¾�×ƒf�[ƒ^' ;
+
+create index PayDataDetail_Index1
+  on paymentdatadetail(TARGETDATE);
+
+create index PayDataDetail_Index2
+  on paymentdatadetail(APPROVALPERSONCODE);
+
+-- �HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists periodavoidance cascade;
+
+--* 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'
+  , FieldNo decimal(2,0) not null comment 'ƒ`ƒFƒbƒN‘Î�ÛƒtƒB�[ƒ‹ƒh”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint periodavoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)
+) comment '�HŽ–ŠúŒÀ‰ñ”ðƒf�[ƒ^' ;
+
+create index PeriodAvoidance_Index1
+  on periodavoidance(ConstructionCode);
+
+create index PeriodAvoidance_Index2
+  on periodavoidance(ConstructionStatusFlg);
+
+create index PeriodAvoidance_Index3
+  on periodavoidance(FieldNo);
+
+-- ’S“–ŽÒ�³”Fƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists personapproval cascade;
+
+--* 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“ú'
+  , 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'
+  , PetitionApprovalDate datetime not null comment '�\�¿�E�³”F“ú•t'
+  , ApprovalLimitDates datetime not null comment '�³”FŠó–]“ú'
+  , ApprovalStatus decimal(1,0) not null comment '�³”F�ó‘Ô'
+  , InputComment varchar(300) comment 'ƒRƒ�ƒ“ƒg'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint personapproval_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,SeqNo)
+) comment '’S“–ŽÒ�³”Fƒf�[ƒ^' ;
+
+-- ’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists personapprovalcomment cascade;
+
+--* 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“ú'
+  , 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”Ô�†'
+  , ApproValComment varchar(300) comment 'ŽwŽ¦�E˜A—�ƒRƒ�ƒ“ƒg'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint personapprovalcomment_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,CommentNo)
+) comment '’S“–ŽÒ�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
+
+-- ’S“–ŽÒ‘Î�Û•”��ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists persondepartmentmaster cascade;
+
+--* 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'
+  , AffiliationFlg decimal(1,0) not null comment '�Š‘®ƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint persondepartmentmaster_PKC primary key (PersonCode,DepartmentCode)
+) comment '’S“–ŽÒ‘Î�Û•”��ƒ}ƒXƒ^' ;
+
+create index PersonDepartmentMaster_Index1
+  on persondepartmentmaster(PersonCode);
+
+create index PersonDepartmentMaster_Index2
+  on persondepartmentmaster(DepartmentCode);
+
+-- ’S“–ŽÒƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists personinchargemaster cascade;
+
+--* 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ŒŽ“ú'
+  , 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ˆó�ü–¼�Ì'
+  , 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'
+  , Qualification varchar(120) comment 'Ž‘Ši“ü—Í—“'
+  , SealPrintName varchar(5) comment 'ˆóŠÓ•\Ž¦–¼'
+  , EmployeeClassFlg decimal(1,0) not null comment 'ŽÐˆõ‹æ•ª'
+  , LedgerFlg decimal(1,0) not null comment '‘ä’ ŒvŽZ‘Î�Ûƒtƒ‰ƒO'
+  , CommutingDistance decimal(5,2) not null comment '’Ê‹Î‹——£'
+  , CommuteCosts decimal(5,0) not null comment '’Ê‹ÎŒð’Ê”ï'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint personinchargemaster_PKC primary key (PersonCode)
+) comment '’S“–ŽÒƒ}ƒXƒ^' ;
+
+create index PersonInChargeMaster_Index1
+  on personinchargemaster(StartDate);
+
+create index PersonInChargeMaster_Index2
+  on personinchargemaster(DepartmentCode);
+
+-- ’S“–ŽÒ‹‹—^ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists personsalarymaster cascade;
+
+--* 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ŒŽ“ú'
+  , MonthlySalary decimal(11,0) not null comment 'ŒŽ‹‹‹àŠz'
+  , YearSalary decimal(12,0) not null comment '”N•î‹àŠz'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint personsalarymaster_PKC primary key (PersonCode,StartDate)
+) comment '’S“–ŽÒ‹‹—^ƒ}ƒXƒ^' ;
+
+create index PersonSalaryMaster_Index1
+  on personsalarymaster(PersonCode);
+
+create index PersonSalaryMaster_Index2
+  on personsalarymaster(StartDate);
+
+create index PersonSalaryMaster_Index3
+  on personsalarymaster(MonthlySalary);
+
+-- ŽwŽ¦Ž–�€ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists pointingoutcomment cascade;
+
+--* RestoreFromTempTable
+create table pointingoutcomment (
+  ConstructionCode decimal(10,0) not null comment '�HŽ–ƒR�[ƒh'
+  , ProcessNo smallint(6) not null comment '�ˆ—�”Ô�†�i‰æ–Ê”Ô�†�j'
+  , SeqNo smallint(6) not null comment '�‡�˜'
+  , PageCount smallint(6) not null comment 'ƒy�[ƒW”Ô�†'
+  , PersonCode decimal(8,0) not null comment '‹L“üŽÒƒR�[ƒh'
+  , DrowColor varchar(8) comment '•`‰æ�F'
+  , CommentMessage varchar(1000) comment 'ƒ�ƒbƒZ�[ƒW'
+  , StartPointX smallint(6) not null comment 'Žw“E�€–ÚˆÊ’u‚w'
+  , StartPointY smallint(6) not null comment 'Žw“E�€–ÚˆÊ’u‚x'
+  , CurrentPointX smallint(6) not null comment '�‰ŠúˆÊ’u‚w'
+  , CurrentPointY smallint(6) not null comment '�‰ŠúˆÊ’u‚x'
+  , CurrentWidth smallint(6) not null comment '•\Ž¦ƒTƒCƒYWidth'
+  , CurrentHeight smallint(6) not null comment '•\Ž¦ƒTƒCƒYHeigth'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint pointingoutcomment_PKC primary key (ConstructionCode,ProcessNo,SeqNo)
+) comment 'ŽwŽ¦Ž–�€ƒf�[ƒ^' ;
+
+-- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists proceedingsdata cascade;
+
+--* RestoreFromTempTable
+create table proceedingsdata (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
+  , StartMeetingTime decimal(4,0) unsigned not null comment '‰ï‹cŽžŠÔŠJŽn'
+  , EndMeetingTime decimal(4,0) unsigned not null comment '‰ï‹cŽžŠÔ�I—¹'
+  , CreatorCode decimal(8,0) not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , PalceFlag decimal(1,0) not null comment 'Œ»’nƒtƒ‰ƒO'
+  , MeetingPalce varchar(120) comment '‘Å�‡‚¹�ê�Š'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint proceedingsdata_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime)
+) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^' ;
+
+-- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j
+--* BackupToTempTable
+drop table if exists proceedingsdataattend cascade;
+
+--* RestoreFromTempTable
+create table proceedingsdataattend (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
+  , StartMeetingTime decimal(4,0) unsigned not null comment '‰ï‹cŽžŠÔŠJŽn'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , Department varchar(20) comment '�o�ÈŽÒ�Š‘®'
+  , AttendName varchar(10) comment '�o�ÈŽÒŽ�–¼'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
+) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i�o�ÈŽÒ�j' ;
+
+-- ”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j
+--* BackupToTempTable
+drop table if exists proceedingsdatadetail cascade;
+
+--* RestoreFromTempTable
+create table proceedingsdatadetail (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ProceedingsDataDate date not null comment '‹cŽ–˜^�ì�¬“ú'
+  , StartMeetingTime decimal(4,0) unsigned not null comment '‰ï‹cŽžŠÔŠJŽn'
+  , SeqNo decimal(3,0) unsigned not null comment '–¾�×�s”Ô�†'
+  , TitleNo varchar(5) comment '‹c‘è”Ô�†'
+  , Title varchar(20) comment '‹c‘è'
+  , ContentsText varchar(50) comment '“à—e'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint proceedingsdatadetail_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
+) comment '”­’�ŽÒ‘Å‚¿�‡‚í‚¹‹cŽ–˜^ƒf�[ƒ^�i–¾�×�j' ;
+
+-- �³”Fƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists processapproval cascade;
+
+--* RestoreFromTempTable
+create table processapproval (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
+  , OrderNo decimal(2,0) unsigned not null comment 'Žó•t”Ô�†'
+  , SeqNo decimal(2,0) not null comment 'Ž}”Ô'
+  , PersonCode decimal(8,0) unsigned not null comment '�\�¿�E�³”FŽÒƒR�[ƒh'
+  , PetitionApprovalDate datetime not null comment '�\�¿�E�³”F“ú•t'
+  , ApprovalLimitDates datetime not null comment '�³”FŠó–]“ú'
+  , ApprovalStatus decimal(1,0) not null comment '�³”F�ó‘Ô'
+  , InputComment varchar(300) comment 'ƒRƒ�ƒ“ƒg'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint processapproval_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SeqNo)
+) comment '�³”Fƒf�[ƒ^' ;
+
+-- �³”FƒRƒ�ƒ“ƒgƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists processapprovalcomment cascade;
+
+--* RestoreFromTempTable
+create table processapprovalcomment (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
+  , 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”Ô�†'
+  , ApproValComment varchar(300) comment 'ŽwŽ¦�E˜A—�ƒRƒ�ƒ“ƒg'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint processapprovalcomment_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,CommentNo)
+) comment '�³”FƒRƒ�ƒ“ƒgƒf�[ƒ^' ;
+
+-- �³”F–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists processapprovaldetail cascade;
+
+--* RestoreFromTempTable
+create table processapprovaldetail (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , ApprovalCode decimal(3,0) unsigned not null comment '�³”F‹@”\”Ô�†'
+  , OrderNo decimal(2,0) unsigned not null comment 'Žó•t”Ô�†'
+  , SerialNo decimal(2,0) unsigned not null comment 'Ž}”Ô'
+  , LinkCode decimal(10,0) not null comment 'ƒŠƒ“ƒN�î•ñ'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo)
+) comment '�³”F–¾�×ƒf�[ƒ^' ;
+
+-- ‹N“®‘Î�Ûƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists processexcutemaster cascade;
+
+--* RestoreFromTempTable
+create table processexcutemaster (
+  SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
+  , ExecCode decimal(4,0) unsigned not null comment '‹N“®�ˆ—�”Ô�†'
+  , EditFlg decimal(1,0) not null comment '•Ò�Wƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint processexcutemaster_PKC primary key (SecCode,ExecCode)
+) comment '‹N“®‘Î�Ûƒ}ƒXƒ^' ;
+
+create index ProcessExcuteMaster_Index1
+  on processexcutemaster(SecCode);
+
+create index ProcessExcuteMaster_Index2
+  on processexcutemaster(ExecCode);
+
+-- ’�•¶�‘ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists purchaseorder cascade;
+
+--* RestoreFromTempTable
+create table purchaseorder (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , CreateDate date comment '�ì�¬“ú•t'
+  , OrderPrice decimal(12,0) not null comment '”­’�‹àŠz'
+  , LastRowStringDate date not null comment '�Å�I�s•\Ž¦“ú•t'
+  , OrderSheetType decimal(1,0) not null comment 'ŠÈˆÕ�E–{Ž®ƒtƒ‰ƒO'
+  , PaymentTerms decimal(1,0) not null comment 'Žx•¥‚¢�ðŒ�'
+  , CashRatio decimal(4,1) not null comment 'Œ»‹àŠ„�‡�i�“�j'
+  , BillPeriod decimal(4,0) not null comment 'ŽèŒ`ŠúŠÔ'
+  , PrePayments decimal(1,0) not null comment '‘O‹à•¥'
+  , PrePaymentsDays decimal(3,0) not null comment '‘O‹à•¥“ú�”'
+  , PrePaymentsPrice decimal(12,0) not null comment '‘O‹à•¥‹àŠz'
+  , PartialPayment decimal(1,0) not null comment '•”•ª•¥'
+  , PartialPaymentMounth decimal(2,0) unsigned not null comment '•”•ª•¥’÷�ØŒŽ'
+  , PartialPaymentDay1 decimal(2,0) unsigned not null comment '•”•ª•¥’÷�Ø“ú'
+  , PartialPaymentDay2 decimal(2,0) unsigned not null comment '•”•ª•¥Žx•¥“ú'
+  , PartialPaymentPrice decimal(12,0) not null comment '•”•ª•¥‹àŠz'
+  , CompletionPayment decimal(1,0) not null comment 'ˆø“n‚µŽž‚ÌŽx•¥'
+  , CompletionPaymentDays decimal(3,0) unsigned not null comment 'ˆø“n‚µŽž‚ÌŽx•¥“ú�”'
+  , CompletionPaymentPrice decimal(12,0) not null comment 'ˆø“n‚µŽž‚ÌŽx•¥‹àŠz'
+  , LeadEngineerCode decimal(8,0) comment 'Žå”C‹Z�pŽÒƒR�[ƒh'
+  , LeadEngineerName varchar(60) comment 'Žå”C‹Z�pŽÒ–¼'
+  , SafetyOfficerCode decimal(8,0) comment 'ˆÀ‘SŠÇ—�ŽÒƒR�[ƒh'
+  , SafetyOfficerName varchar(60) comment 'ˆÀ‘SŠÇ—�ŽÒ–¼'
+  , WorkersCount decimal(3,0) unsigned comment '�ì‹Æˆõ�”'
+  , PrintoutDate date not null comment 'ˆó�ü”NŒŽ“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)
+) comment '’�•¶�‘ƒf�[ƒ^' ;
+
+-- ’�•¶�‘“ú•tƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists purchaseorderdate cascade;
+
+--* RestoreFromTempTable
+create table purchaseorderdate (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
+  , CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , SendDate date not null comment '’�•¶�‘—X‘—“ú'
+  , ReturnDate date not null comment '’�•¶�‘•Ô‘—“ú'
+  , ReturnCheckDate date not null comment '’�•¶�‘•Ô‘—Šm”F“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint purchaseorderdate_PKC primary key (ConstructionCode,SeqNo)
+) comment '’�•¶�‘“ú•tƒf�[ƒ^' ;
+
+-- ’�•¶�‘–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists purchaseorderdetail cascade;
+
+--* RestoreFromTempTable
+create table purchaseorderdetail (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , SeqNo decimal(3,0) unsigned not null comment '’�•¶�‘Ž}”Ô'
+  , GroupCount decimal(1,0) not null comment 'ƒOƒ‹�[ƒv”Ô�†'
+  , LineCount decimal(3,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 '�HŽí�E•i–¼'
+  , SecondString varchar(120) comment '“à—e“à–ó'
+  , UnitCount decimal(8,2) not null comment '�”—Ê'
+  , UnitName varchar(30) comment '’PˆÊ'
+  , UnitPrice decimal(10,0) not null comment '’P‰¿'
+  , OrdersLinePrice decimal(12,0) comment '‹àŠz'
+  , SourceCode decimal(10,0) unsigned not null comment '‘ä’ �HŽ–”Ô�†'
+  , SourceDetailCnt decimal(4,0) unsigned not null comment '‘ä’ –¾�×”Ô�†'
+  , DataTypeFlag decimal(1,0) unsigned not null comment 'ƒf�[ƒ^ƒ^ƒCƒvƒtƒ‰ƒO'
+  , StatutoryWelfareRate decimal(4,2) not null comment '–@’è•Ÿ—˜”ï”ä—¦'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)
+) comment '’�•¶�‘–¾�×ƒf�[ƒ^' ;
+
+create index POrderDetail_Index1
+  on purchaseorderdetail(SourceCode);
+
+-- ƒŒƒR�[ƒh”Ô�†ŠÇ—�
+--* BackupToTempTable
+drop table if exists recordkey cascade;
+
+--* 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”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint recordkey_PKC primary key (KeyNo,RecordNumber)
+) comment 'ƒŒƒR�[ƒh”Ô�†ŠÇ—�' ;
+
+-- �¿‹��‘�í�œƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists reminvoicedata cascade;
+
+--* RestoreFromTempTable
+create table reminvoicedata (
+  InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
+  , RemPerson decimal(8,0) not null comment '�í�œ’S“–ŽÒƒR�[ƒh'
+  , RemDate date not null comment '�í�œ“ú•t'
+  , RemComment varchar(300) comment '�í�œ—�—R'
+  , EntryDate datetime not null comment '“o˜^”NŒŽ“ú'
+  , UpdateDate datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint reminvoicedata_PKC primary key (InvoiceNo)
+) comment '�¿‹��‘�í�œƒf�[ƒ^' ;
+
+-- �¿‹��‘�í�œ–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists reminvoicedatadetail cascade;
+
+--* RestoreFromTempTable
+create table reminvoicedatadetail (
+  InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
+  , SeqNo smallint(5) unsigned not null comment '˜A”Ô'
+  , RequestNo decimal(9,0) not null comment '�¿‹�No'
+  , EntryDate datetime not null comment '“o˜^”NŒŽ“ú'
+  , UpdateDate datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint reminvoicedatadetail_PKC primary key (InvoiceNo,SeqNo)
+) comment '�¿‹��‘�í�œ–¾�×ƒf�[ƒ^' ;
+
+-- �¿‹�ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists requestdata cascade;
+
+--* RestoreFromTempTable
+create table requestdata (
+  REQUESTNO decimal(9,0) not null comment '�¿‹�No'
+  , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
+  , CONSTRUCTIONNAME varchar(120) not null comment '�HŽ–Œ�–¼'
+  , CONTRACTAMOUNT decimal(10,0) not null comment '�¿•‰‹àŠz'
+  , PAIDAMOUNT decimal(10,0) not null comment '�¿‹��Ï‹àŠz'
+  , REQUESTAMOUNT0 decimal(10,0) not null comment '�¿‹�‹àŠz‚O'
+  , REQUESTAMOUNT1 decimal(10,0) not null comment '�¿‹�‹àŠz‚P'
+  , REQUESTAMOUNT2 decimal(10,0) comment '�¿‹�‹àŠz‚Q'
+  , REQUESTAMOUNT3 decimal(10,0) comment '�¿‹�‹àŠz‚R'
+  , REQUESTAMOUNT4 decimal(10,0) comment '�¿‹�‹àŠz‚S'
+  , REQUESTAMOUNT5 decimal(10,0) comment '�¿‹�‹àŠz‚T'
+  , REQUESTAMOUNT6 decimal(10,0) comment '�¿‹�‹àŠz‚U'
+  , UNCLAIMEDAMOUNT decimal(10,0) not null comment '�¿‹�Žc‹àŠz'
+  , UNPAIDAMOUNT decimal(10,0) not null comment '–¢“ü‹à‹àŠz'
+  , TAXAMOUNT decimal(10,0) not null comment '�Á”ï�Å'
+  , NOTE varchar(120) not null comment '”õ�l'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE)
+) comment '�¿‹�ƒf�[ƒ^' ;
+
+-- �¿‹�ƒf�[ƒ^–¾�×
+--* BackupToTempTable
+drop table if exists requestdatadetail cascade;
+
+--* RestoreFromTempTable
+create table requestdatadetail (
+  REQUESTNO decimal(9,0) not null comment '�¿‹�No'
+  , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '–{�HŽ–”Ô�†'
+  , CONSTRUCTIONCODE decimal(10,0) not null comment '�HŽ–”Ô�†'
+  , CONSTRUCTIONKIND decimal(1,0) not null comment '�HŽ–‹æ•ª'
+  , REQUESTAMOUNT decimal(10,0) not null comment '�¿‹�‹àŠz'
+  , TAXAMOUNT decimal(10,0) not null comment '�Á”ï�Å'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND)
+) comment '�¿‹�ƒf�[ƒ^–¾�×' ;
+
+-- �¿‹�ƒwƒbƒ_
+--* BackupToTempTable
+drop table if exists requesthead cascade;
+
+--* RestoreFromTempTable
+create table requesthead (
+  REQUESTNO decimal(9,0) not null comment '�¿‹�No'
+  , REQCONSTRUCTIONCODE decimal(10,0) not null comment '�¿‹��HŽ–”Ô�†'
+  , ORDERNO decimal(2,0) not null comment 'Žó•t”Ô�†'
+  , REQUESTMONTH decimal(6,0) not null comment '�¿‹�ŒŽ'
+  , ORDERERSDIVISION decimal(5,0) not null comment '”­’�ŽÒ‹æ•ª'
+  , ORDERERSCODE decimal(5,0) not null comment '”­’�ŽÒƒR�[ƒh'
+  , ORDERERSNAME varchar(120) not null comment '”­’�ŽÒ�æ–¼'
+  , REQCONSTRUCTIONNAME varchar(120) not null comment '�¿‹��HŽ–Œ�–¼'
+  , REQUESTTOTALAMOUNT decimal(10,0) not null comment '�¿‹�‹àŠz�‡Œv'
+  , REQUESTAMOUNT decimal(10,0) not null comment '�¿‹�‹àŠz'
+  , TAXAMOUNT decimal(10,0) not null comment '�Á”ï�Å'
+  , UNPAIDAMOUNT decimal(10,0) comment '–¢“ü‹à'
+  , NOTE varchar(120) comment '”õ�l'
+  , ASSIGNEDFLG decimal(1,0) comment 'Š„“–�Ïƒtƒ‰ƒO'
+  , INVOICENO decimal(9,0) not null comment '�¿‹��‘No'
+  , ENTRYDATE datetime not null comment '“o˜^”NŒŽ“ú'
+  , UPDATEDATE datetime not null comment '�X�V”NŒŽ“ú'
+  , constraint requesthead_PKC primary key (REQUESTNO)
+) comment '�¿‹�ƒwƒbƒ_' ;
+
+alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
+
+-- �¿‹��‘“ú•tƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists requestorderdate cascade;
+
+--* RestoreFromTempTable
+create table requestorderdate (
+  ConstructionCode decimal(10,0) unsigned not null comment '�HŽ–ƒR�[ƒh'
+  , InvoiceNo decimal(9,0) not null comment '�¿‹��‘No'
+  , SendDate date not null comment '�¿‹��‘”­‹‹—X‘—“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint requestorderdate_PKC primary key (ConstructionCode,InvoiceNo)
+) comment '�¿‹��‘“ú•tƒf�[ƒ^' ;
+
+-- ”„�ãƒOƒ‰ƒtƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists salesgraphdata cascade;
+
+--* RestoreFromTempTable
+create table salesgraphdata (
+  GraphDataCode decimal(8,0) not null comment 'ƒOƒ‰ƒtƒf�[ƒ^ƒR�[ƒh'
+  , ConstructionPeriod decimal(4,0) unsigned not null comment 'Ž–‹ÆŠú'
+  , SalesDataDays date not null comment '”„�ã”NŒŽ'
+  , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
+  , DataName varchar(100) not null comment 'ƒf�[ƒ^•\Ž¦–¼�Ì'
+  , SalesAmount decimal(10,0) not null comment '”„�ãƒf�[ƒ^'
+  , AdministrativeExpense decimal(10,0) not null comment '”ÌŠÇ�E•”��Œo”ï'
+  , GrossProfit decimal(10,0) not null comment '‘e—˜‰v'
+  , NetIncome decimal(10,0) not null comment '�ƒ—˜‰v(‘¹‰v)'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint salesgraphdata_PKC primary key (GraphDataCode,ConstructionPeriod,SalesDataDays)
+) comment '”„�ãƒOƒ‰ƒtƒf�[ƒ^' ;
+
+create index SalesGraphData_Idx1
+  on salesgraphdata(DisplayOrder);
+
+create index SalesGraphData_idx2
+  on salesgraphdata(ConstructionPeriod);
+
+-- •ÛŒì‹æ•ªƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists securitymaster cascade;
+
+--* RestoreFromTempTable
+create table securitymaster (
+  SecCode decimal(2,0) unsigned not null comment '•ÛŒì‹æ•ª”Ô�†'
+  , DisplayOrder decimal(2,0) not null comment '•\Ž¦�‡'
+  , SecName varchar(60) not null comment '•ÛŒì‹æ•ª–¼�Ì'
+  , SecRank decimal(1,0) not null comment '•ÛŒì‹æ•ªƒ‰ƒ“ƒN'
+  , SecRange decimal(1,0) not null comment '•ÛŒì‹æ•ª”ÍˆÍ'
+  , GeneralAffairs decimal(1,0) not null comment '‘�–±‹Æ–±ƒtƒ‰ƒO'
+  , SelectBackColor varchar(8) not null comment '‘I‘ð”wŒi�F'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint securitymaster_PKC primary key (SecCode)
+) comment '•ÛŒì‹æ•ªƒ}ƒXƒ^' ;
+
+create index SecurityMaster_Index1
+  on securitymaster(DisplayOrder);
+
+create index SecurityMaster_Index2
+  on securitymaster(SecRank);
+
+create index SecurityMaster_Index3
+  on securitymaster(SecRange);
+
+-- ˆÀ‘Sƒpƒgƒ��[ƒ‹ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists sfpdata cascade;
+
+--* 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ƒ��[ƒ‹‰ñ�”'
+  , RequestDate datetime not null comment 'ƒpƒgƒ��[ƒ‹—v�¿“úŽž'
+  , PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒƒR�[ƒh'
+  , StringValue varchar(300) comment 'ƒRƒ�ƒ“ƒg'
+  , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint sfpdata_PKC primary key (ConstructionCode,DataCount)
+) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹ƒf�[ƒ^' ;
+
+create index SFPData_Index1
+  on sfpdata(RequestDate);
+
+-- ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists sfpdatadetail cascade;
+
+--* 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ƒ��[ƒ‹‰ñ�”'
+  , SeqNo decimal(2,0) unsigned not null comment 'ƒf�[ƒ^Ž}”Ô'
+  , CompanyCode decimal(8,0) unsigned not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint sfpdatadetail_PKC primary key (ConstructionCode,DataCount,SeqNo)
+) comment 'ˆÀ‘Sƒpƒgƒ��[ƒ‹–¾�×ƒf�[ƒ^' ;
+
+-- ‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists subconstrjobitemregist cascade;
+
+--* RestoreFromTempTable
+create table subconstrjobitemregist (
+  PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , SeqNo decimal(2,0) unsigned not null comment '�\�¿˜A”Ô'
+  , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subconstrjobitemregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)
+) comment '‹¦—Í‹ÆŽÒŽ{�H�HŽí“o˜^�\�¿ƒf�[ƒ^' ;
+
+-- ‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists subconstrjoblinkregist cascade;
+
+--* RestoreFromTempTable
+create table subconstrjoblinkregist (
+  PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , SeqNo decimal(2,0) unsigned not null comment '�\�¿˜A”Ô'
+  , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
+  , JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subconstrjoblinkregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)
+) comment '‹¦—Í‹ÆŽÒ�EŽíƒŠƒ“ƒN“o˜^�\�¿ƒf�[ƒ^' ;
+
+-- ‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists subconstrregist cascade;
+
+--* RestoreFromTempTable
+create table subconstrregist (
+  PersonCode decimal(8,0) unsigned not null comment '�\�¿ŽÒ”Ô�†'
+  , CreateDate date not null comment '�ì�¬“ú'
+  , SeqNo decimal(2,0) unsigned not null comment '�\�¿˜A”Ô'
+  , DataMode decimal(1,0) comment 'ƒf�[ƒ^‹æ•ª'
+  , SourceCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , PetitionPeriod decimal(4,0) unsigned not null comment '�\�¿”N“x'
+  , CorporateStatusName varchar(40) comment '–@�lŠi–¼�Ì'
+  , CorporateStatusPoint decimal(1,0) not null comment '–@�lŠi–¼�ÌˆÊ’u'
+  , CompanyName varchar(100) not null comment '‹¦—Í‰ïŽÐ–¼'
+  , CEOPositionName varchar(60) comment '‘ã•\ŽÒ–ð�E–¼'
+  , CEOName varchar(60) comment '‘ã•\ŽÒŽ�–¼'
+  , ContactPersonName varchar(60) comment '’S“–ŽÒŽ�–¼'
+  , ZipCode varchar(8) comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) comment '�Z�Š‚P'
+  , Address2 varchar(60) comment '�Z�Š2'
+  , Address3 varchar(60) comment '�Z�Š3'
+  , CellPhoneNumber varchar(13) comment 'Œg‘Ñ“d˜b”Ô�†'
+  , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
+  , PhoneNumber varchar(13) comment '“d˜b”Ô�†'
+  , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , JapaneseSyllabary varchar(2) comment '50‰¹“Ç‚Ý'
+  , 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 '�\�¿“ú'
+  , OrderNo decimal(2,0) unsigned not null comment '�\�¿Žó•t”Ô�†'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subconstrregist_PKC primary key (PersonCode,CreateDate,SeqNo)
+) comment '‹¦—Í‹ÆŽÒ“o˜^�\�¿ƒf�[ƒ^' ;
+
+-- ‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists subcontractoritemmaster cascade;
+
+--* RestoreFromTempTable
+create table subcontractoritemmaster (
+  ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , ItemName varchar(120) 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'
+  , constraint subcontractoritemmaster_PKC primary key (ItemCode)
+) comment '‹¦—Í‰ïŽÐ�HŽíƒ}ƒXƒ^' ;
+
+-- ‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists subcontractorjobcategory cascade;
+
+--* RestoreFromTempTable
+create table subcontractorjobcategory (
+  JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , JobCategoryName varchar(120) not null comment '�EŽí–¼�Ì'
+  , 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 subcontractorjobcategory_PKC primary key (JobCategoryCode)
+) comment '‹¦—Í‰ïŽÐ�EŽíƒ}ƒXƒ^' ;
+
+-- ‹¦—Í‰ïŽÐŽ{�H�HŽíƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists subcontractorjobitem cascade;
+
+--* RestoreFromTempTable
+create table subcontractorjobitem (
+  CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , ItemCode decimal(5,0) unsigned not null comment '�HŽíƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subcontractorjobitem_PKC primary key (CompanyCode,ItemCode)
+) comment '‹¦—Í‰ïŽÐŽ{�H�HŽíƒf�[ƒ^' ;
+
+create index SubContractorJobItem_Index1
+  on subcontractorjobitem(CompanyCode);
+
+create index SubContractorJobItem_Index2
+  on subcontractorjobitem(ItemCode);
+
+-- ‹¦—Í‰ïŽÐ�EŽíƒŠƒ“ƒNƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists subcontractorjoblink cascade;
+
+--* RestoreFromTempTable
+create table subcontractorjoblink (
+  CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , JobCategoryCode decimal(5,0) not null comment '�EŽíƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint subcontractorjoblink_PKC primary key (CompanyCode,JobCategoryCode)
+) comment '‹¦—Í‰ïŽÐ�EŽíƒŠƒ“ƒNƒ}ƒXƒ^' ;
+
+create index SubContractorJobLink_Index1
+  on subcontractorjoblink(CompanyCode);
+
+create index SubContractorJobLink_Index2
+  on subcontractorjoblink(JobCategoryCode);
+
+-- ‹¦—Í‰ïŽÐƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists subcontractormaster cascade;
+
+--* RestoreFromTempTable
+create table subcontractormaster (
+  CompanyCode decimal(8,0) not null comment '‹¦—Í‰ïŽÐƒR�[ƒh'
+  , DisplayOrder decimal(8,0) unsigned not null comment '•\Ž¦�‡'
+  , CorporateStatusName varchar(40) comment '–@�lŠi–¼�Ì'
+  , CorporateStatusPoint decimal(1,0) not null comment '–@�lŠi–¼�ÌˆÊ’u'
+  , CompanyName varchar(100) not null comment '‹¦—Í‰ïŽÐ–¼'
+  , CEOPositionName varchar(60) comment '‘ã•\ŽÒ–ð�E–¼'
+  , CEOName varchar(60) comment '‘ã•\ŽÒŽ�–¼'
+  , ContactPersonName varchar(60) comment '’S“–ŽÒŽ�–¼'
+  , ZipCode varchar(8) comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) comment '�Z�Š‚P'
+  , Address2 varchar(60) comment '�Z�Š2'
+  , Address3 varchar(60) comment '�Z�Š3'
+  , CellPhoneNumber varchar(13) comment 'Œg‘Ñ“d˜b”Ô�†'
+  , MailAddress varchar(257) comment 'ƒ��[ƒ‹ƒAƒhƒŒƒX'
+  , PhoneNumber varchar(13) comment '“d˜b”Ô�†'
+  , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , JapaneseSyllabary varchar(2) comment '50‰¹“Ç‚Ý'
+  , StartDate date not null comment 'ŽæˆøŠJŽn”NŒŽ“ú'
+  , Note varchar(300) comment '”õ�l'
+  , labourKind decimal(1,0) not null comment 'Žx•¥‚¢’Ê�í�EŽèŠÔ‹æ•ª'
+  , 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 subcontractormaster_PKC primary key (CompanyCode)
+) comment '‹¦—Í‰ïŽÐƒ}ƒXƒ^' ;
+
+create index SubContractorMaster_Index1
+  on subcontractormaster(JapaneseSyllabary);
+
+-- Žd“ü�æƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists suppliersmaster cascade;
+
+--* RestoreFromTempTable
+create table suppliersmaster (
+  SuppliersCode decimal(5,0) unsigned not null comment 'Žd“ü�æƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , SuppliersName1 varchar(60) not null comment 'Žd“ü�æ–¼1'
+  , SuppliersName2 varchar(60) comment 'Žd“ü�æ–¼‚Q'
+  , ZipCode varchar(8) comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) comment '�Z�Š‚P'
+  , Address2 varchar(60) comment '�Z�Š2'
+  , Address3 varchar(60) comment '�Z�Š3'
+  , PhoneNumber varchar(13) comment '“d˜b”Ô�†'
+  , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , 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 suppliersmaster_PKC primary key (SuppliersCode)
+) comment 'Žd“ü�æƒ}ƒXƒ^' ;
+
+-- ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists systemexecute cascade;
+
+--* RestoreFromTempTable
+create table systemexecute (
+  PrimaryCode tinyint(4) not null comment 'ƒL�[�€–Ú'
+  , TargetDate date not null comment '‹N“®“ú•t'
+  , SystemVersion int(11) not null comment '–{‘Ì�EŠÂ‹«ƒo�[ƒWƒ‡ƒ“'
+  , UpDateCopyVersion int(11) not null comment 'ƒRƒs�[ƒo�[ƒWƒ‡ƒ“'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint systemexecute_PKC primary key (PrimaryCode)
+) comment 'ƒVƒXƒeƒ€‹N“®Šm”Fƒf�[ƒ^' ;
+
+-- ŠÇ—�ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists systemmaster cascade;
+
+--* RestoreFromTempTable
+create table systemmaster (
+  SystemCode decimal(3,0) unsigned not null comment '‰ïŽÐƒR�[ƒh'
+  , CompanyName1 varchar(60) not null comment '‰ïŽÐ–¼‚P'
+  , CompanyName2 varchar(60) comment '‰ïŽÐ–¼‚Q'
+  , CEOName varchar(60) not null comment '‘ã•\ŽÒŽ�–¼'
+  , CEOPositionName varchar(60) comment '‘ã•\ŽÒ–ð�E–¼'
+  , ZipCode varchar(8) not null comment '—X•Ö”Ô�†'
+  , Address1 varchar(60) not null comment '�Z�Š‚P'
+  , Address2 varchar(60) comment '�Z�Š2'
+  , Address3 varchar(60) comment '�Z�Š3'
+  , PhoneNumber varchar(13) not null comment '“d˜b”Ô�†'
+  , FaxNumber varchar(13) comment 'FAX”Ô�†'
+  , HomePageURL varchar(120) comment 'ƒz�[ƒ€ƒy�[ƒWURL'
+  , ConsumptionTax decimal(4,2) not null comment '�Á”ï�Å'
+  , CooperationRate decimal(4,2) not null comment '‹¦—Í‹à”ä—¦'
+  , StatutoryWelfareRate decimal(4,2) not null comment '–@’è•Ÿ—˜”ï”ä—¦'
+  , FuelPrice decimal(5,2) not null comment '”R—¿ƒLƒ�’P‰¿'
+  , AreaDistance decimal(5,2) not null comment 'Ž‘�Þ’u�êˆÚ“®‹——£'
+  , ExcelSavePath varchar(120) comment 'Excel•Û‘¶ƒpƒX'
+  , BusinessPeriod smallint(6) not null comment 'Œ»�Ý‰c‹ÆŠú�”'
+  , ConstrYear smallint(6) not null comment 'Œ»�Ý�HŽ–”N“x'
+  , BusinessBeginDate datetime not null comment '‰c‹ÆŠúŠúŽñ“ú'
+  , ConstrBeginDate datetime not null comment '�HŽ–”N“xŠúŽñ“ú'
+  , BusinessCompDate datetime not null comment '‰c‹ÆŠúŠú––“ú'
+  , ConstrCompDate datetime not null comment '�HŽ–”N“xŠú––“ú'
+  , ConstructionNoBase decimal(1,0) not null comment '�HŽ–”Ô�†Šî�€’l'
+  , SloganString1 varchar(100) comment '•WŒê1'
+  , SloganString2 varchar(100) comment '•WŒê2'
+  , SloganString3 varchar(100) comment '•WŒê3'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint systemmaster_PKC primary key (SystemCode)
+) comment 'ŠÇ—�ƒ}ƒXƒ^' ;
+
+-- ŠúŒÀƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists termmaster cascade;
+
+--* 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”Ô�†'
+  , SeqNo decimal(2,0) not null comment 'Ž}”Ô'
+  , DisplayOrder decimal(2,0) not null comment '•\Ž¦�‡'
+  , CheckSchdule decimal(1,0) not null comment 'ƒ`ƒFƒbƒNƒ^ƒCƒ~ƒ“ƒO'
+  , TermDays decimal(3,0) not null comment 'Œo‰ß“ú'
+  , SendTitile varchar(100) comment 'ƒ^ƒCƒgƒ‹'
+  , SendMessage varchar(100) comment 'ƒ�ƒbƒZ�[ƒW'
+  , BackColor varchar(8) comment '”wŒi�F'
+  , ForeColor varchar(8) comment '•¶Žš�F'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint termmaster_PKC primary key (ConstructionStatusFlg,FieldNo,SeqNo)
+) comment 'ŠúŒÀƒ}ƒXƒ^' ;
+
+create index TermMaster_Index1
+  on termmaster(DisplayOrder);
+
+-- �o‹ÎŒð’Ê”ïƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists tranceportdailydata cascade;
+
+--* RestoreFromTempTable
+create table tranceportdailydata (
+  PersonCode decimal(8,0) unsigned not null comment '�ì�¬ŽÒƒR�[ƒh'
+  , AttendanceDate date not null comment '“ú•ñ�ì�¬“ú'
+  , StartDistance decimal(7,1) not null comment '“–“ú�o”­ƒLƒ��”'
+  , ComplateDistance decimal(7,1) not null comment '“–“ú�I—¹ƒLƒ��”'
+  , TotalDistance decimal(6,1) not null comment '“–“ú�‡ŒvƒLƒ��”'
+  , OfficeGoFlg decimal(1,0) not null comment 'Ž––±�Š�o‹Îƒtƒ‰ƒO'
+  , OfficeOutFlg decimal(1,0) not null comment 'Ž––±�Š‹A‘îƒtƒ‰ƒO'
+  , TrancePayGoFlg decimal(1,0) not null comment '—L—¿’Ê‹Î�o‹Îƒtƒ‰ƒO'
+  , TrancePayOutFlg decimal(1,0) not null comment '—L—¿’Ê‹Î‹A‘îƒtƒ‰ƒO'
+  , WareHouseFlg decimal(1,0) not null comment 'Ž‘�Þ’u�êƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint tranceportdailydata_PKC primary key (PersonCode,AttendanceDate)
+) comment '�o‹ÎŒð’Ê”ïƒf�[ƒ^' ;
+
+create index TranceportDailyData_Index1
+  on tranceportdailydata(AttendanceDate);
+
+-- �HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists typeexpensesmaster cascade;
+
+--* RestoreFromTempTable
+create table typeexpensesmaster (
+  TypeCode decimal(5,0) unsigned not null comment '�HŽ–Ží•ÊƒR�[ƒh'
+  , ExpensesPeriod smallint(6) not null comment 'Ž–‹ÆŠú'
+  , NameCode decimal(5,0) unsigned not null comment 'Œo”ï–¼�ÌƒR�[ƒh'
+  , ExpensesRaito decimal(4,2) not null comment 'Œo”ï—¦'
+  , DeleteFlg decimal(1,0) not null comment '�í�œƒtƒ‰ƒO'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint typeexpensesmaster_PKC primary key (TypeCode,ExpensesPeriod,NameCode)
+) comment '�HŽ–Ží•ÊŒo”ï—¦ƒ}ƒXƒ^' ;
+
+-- ’PˆÊƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists unitmaster cascade;
+
+--* RestoreFromTempTable
+create table unitmaster (
+  UnitKey decimal(5,0) unsigned not null comment '’PˆÊƒL�['
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , UnitName varchar(30) not null comment '’PˆÊ–¼�Ì'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint unitmaster_PKC primary key (UnitKey)
+) comment '’PˆÊƒ}ƒXƒ^' ;
+
+create index UnitMaster_Index1
+  on unitmaster(DisplayOrder);
+
+-- ŽÔ—¼ƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists vehiclemaster cascade;
+
+--* RestoreFromTempTable
+create table vehiclemaster (
+  VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
+  , DisplayOrder decimal(5,0) unsigned not null comment '•\Ž¦�‡'
+  , VehicleName varchar(100) not null comment 'ŽÔ—¼–¼�Ì'
+  , RegistrationNumber varchar(30) comment '“o˜^”Ô�†'
+  , IdentificationNumber varchar(30) comment 'ŽÔ‘Ì”Ô�†'
+  , ModelCode varchar(30) comment 'Œ^Ž®'
+  , DepartmentCode decimal(5,0) unsigned not null comment 'ŠÇ—�•”��'
+  , VehicleScheduleFlg decimal(1,0) not null comment 'ŽÔ—¼—\–ñ•\Ž¦ƒtƒ‰ƒO'
+  , PurchaseDate date comment '�w“ü“ú'
+  , PurchaseName varchar(30) comment '�w“ü�æ'
+  , PurchaseContactPersons varchar(30) comment '�w“ü�æ’S“–ŽÒ'
+  , PurchasePhone varchar(13) comment '�w“ü�æ“d˜b”Ô�†'
+  , LeaseDate date comment 'ƒŠ�[ƒXŠJŽn“ú'
+  , LeaseDestination varchar(30) comment 'ƒŠ�[ƒX�æ'
+  , LeaseContactPersons varchar(30) comment 'ƒŠ�[ƒX�æ’S“–ŽÒ'
+  , LeasePhone varchar(13) comment 'ƒŠ�[ƒX�æ“d˜b”Ô�†'
+  , InsuranceCompany varchar(30) comment '”CˆÓ•ÛŒ¯‰ïŽÐ'
+  , InsuranceContactPersons varchar(30) comment '”CˆÓ•ÛŒ¯‰ïŽÐ’S“–ŽÒ'
+  , InsurancePhone varchar(13) comment '”CˆÓ•ÛŒ¯‰ïŽÐ“d˜b”Ô�†'
+  , Note varchar(300) comment '”õ�l'
+  , EntryDate datetime comment '“o˜^“ú•t'
+  , UpdateDate datetime comment '�X�V“ú•t'
+  , constraint vehiclemaster_PKC primary key (VehicleCode)
+) comment 'ŽÔ—¼ƒ}ƒXƒ^' ;
+
+-- ŽÔ—¼‹L˜^ƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists vehiclerecorddata cascade;
+
+--* RestoreFromTempTable
+create table vehiclerecorddata (
+  VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
+  , DivisionCode decimal(2,0) unsigned not null comment 'ƒf�[ƒ^‹æ•ª'
+  , SeqNo decimal(2,0) not null comment 'Ž}”Ô'
+  , RecordDate date comment 'ŽÀ’n“ú'
+  , Mileage mediumint(9) comment '‘–�s‹——£'
+  , Content varchar(100) comment '“à—e'
+  , PaymentCost decimal(10,0) comment '”ï—p'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint vehiclerecorddata_PKC primary key (VehicleCode,DivisionCode,SeqNo)
+) comment 'ŽÔ—¼‹L˜^ƒf�[ƒ^' ;
+
+-- ŽÔ—¼—\–ñƒf�[ƒ^
+--* BackupToTempTable
+drop table if exists vehiclescheduledata cascade;
+
+--* RestoreFromTempTable
+create table vehiclescheduledata (
+  TargetDate date not null comment '‘Î�Û“ú'
+  , VehicleCode decimal(5,0) unsigned not null comment 'ŽÔ—¼ƒR�[ƒh'
+  , MorningAfternoon decimal(1,0) not null comment 'Œß‘O�EŒßŒã'
+  , PersonCode decimal(8,0) unsigned not null comment '’S“–ŽÒƒR�[ƒh'
+  , TargetYear year(4) not null comment 'ŠY“–”N'
+  , TargetMonth tinyint(3) unsigned not null comment 'ŠY“–ŒŽ'
+  , TargetDay year(4) not null comment 'ŠY“–“ú'
+  , EntryDate datetime not null comment '“o˜^“ú•t'
+  , UpdateDate datetime not null comment '�X�V“ú•t'
+  , constraint vehiclescheduledata_PKC primary key (TargetDate,VehicleCode,MorningAfternoon)
+) comment 'ŽÔ—¼—\–ñƒf�[ƒ^' ;
+
+create index VehicleScheduleData_Index1
+  on vehiclescheduledata(TargetYear);
+
+create index VehicleScheduleData_Index2
+  on vehiclescheduledata(TargetMonth);
+
+create index VehicleScheduleData_Index3
+  on vehiclescheduledata(TargetDay);
+
+-- ”Nƒ}ƒXƒ^
+--* BackupToTempTable
+drop table if exists yearmaster cascade;
+
+--* RestoreFromTempTable
+create table yearmaster (
+  years smallint(6) not null comment '”N'
+  , constraint yearmaster_PKC primary key (years)
+) comment '”Nƒ}ƒXƒ^' ;
