/trunk/ddl/ProcessManagement.sql - アノテート - 工事管理システム製品化対応 - Redmine

h-you / trunk / ddl / ProcessManagement.sql @ 487

-            bit
+-- Project Name : noname
-            h-you
+-- Date/Time    : 2020/08/17 9:32:32
-            bit
+-- 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists actionscheduledata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists approvalmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists attendancedailydata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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???'
-            h-you
+  , ConstructionCode decimal(10,0) not null comment '?H???R?[?h'
   , ActionResult varchar(100) not null comment '?s??????'
-            bit
+  , StartTime datetime comment '?J?n????'
   , CompTime datetime comment '?I??????'
-            h-you
+  , DayTimes decimal(5,2) not null comment '???????'
   , Overtime decimal(5,2) not null comment '????O?A??'
   , OvertimeWA decimal(5,2) not null comment '?c??F?????'
-            bit
+  , WorkingComment varchar(120) comment '?R?????g'
-            h-you
+  , WorkKindFlg decimal(2,0) not null comment '?????t???O'
-            h-you
+  , WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists attendancedata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table attendancedata (
   PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
-            h-you
+  , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'
-            bit
+  , LastDays decimal(2,0) unsigned not null comment '??????I??'
   , AttendDayCount decimal(2,0) unsigned not null comment '?o?????'
-            h-you
+  , NormalTimes decimal(5,2) not null comment '??????????'
   , OutEarlyTimes decimal(5,2) not null comment '???o?????'
   , OverTimes decimal(5,2) not null comment '?c??????'
   , HolidayWorkTimes decimal(5,2) not null comment '?x???o??????'
   , TransferHolidayTimes decimal(5,2) not null comment '?U??x????'
   , CompensatoryHolidayTimes decimal(5,2) not null comment '??x??'
   , PaidHolidaysTimes decimal(5,2) not null comment '?L???x???'
   , AbsenceTimes decimal(5,2) not null comment '????????'
   , LateTimes decimal(5,2) not null comment '?x???????'
   , LeaveEarlyTimes decimal(5,2) not null comment '????????'
   , GoOutTimes decimal(5,2) not null comment '?O?o?????'
   , OrderDate decimal(6,0) unsigned not null comment '?\????'
-            bit
+  , 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?[?^' ;
-            h-you
+-- ????o?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists attendancenotice cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table attendancenotice (
   PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , AttendanceNo decimal(2,0) unsigned not null comment '????'
   , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'
   , OrderNo decimal(3,0) unsigned not null comment '????'
   , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'
   , HolidayReason decimal(1,0) unsigned not null comment '?x???'
   , FromDate datetime not null comment '?J?n????'
   , ToDate datetime not null comment '?I??????'
   , NoticePeriod decimal(5,2) unsigned not null comment '???????'
   , TransferDay datetime not null comment '?U???'
   , Reason varchar(300) comment '???R'
   , Note varchar(300) comment '???l'
   , ApprovalDate decimal(6,0) unsigned not null comment '???F??'
   , ApprovalNo decimal(2,0) unsigned not null comment '???F??t???'
-            h-you
+  , WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'
-            h-you
+  , DeleteFlg decimal(1,0) unsigned not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint attendancenotice_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
 ) comment '????o?f?[?^' ;
-            h-you
+create index AttendanceNotice_Index1
   on attendancenotice(PersonCode);
 create index AttendanceNotice_Index2
   on attendancenotice(AttendanceNo);
 create index AttendanceNotice_Index3
   on attendancenotice(AttendanceMonth);
-            h-you
+-- ????o?R?t???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists attendancenoticelink cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table attendancenoticelink (
   PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , AttendanceNo decimal(2,0) unsigned not null comment '????'
   , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'
   , OrderNo decimal(3,0) unsigned not null comment '????'
   , DailyDate date not null comment '???????'
   , SeqNo decimal(3,0) unsigned not null comment '?????s???'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint attendancenoticelink_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo,DailyDate,SeqNo)
 ) comment '????o?R?t???f?[?^' ;
 create index AttendanceNoticeLink_Index1
   on attendancenoticelink(PersonCode);
 create index AttendanceNoticeLink_Index2
   on attendancenoticelink(AttendanceNo);
 create index AttendanceNoticeLink_Index3
   on attendancenoticelink(AttendanceMonth);
 create index AttendanceNoticeLink_Index4
   on attendancenoticelink(OrderNo);
 create index AttendanceNoticeLink_Index5
   on attendancenoticelink(DailyDate);
 create index AttendanceNoticeLink_Index6
   on attendancenoticelink(SeqNo);
 -- ????o?H???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists attnoticeconstrction cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table attnoticeconstrction (
   PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , AttendanceNo decimal(2,0) unsigned not null comment '????'
   , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'
   , OrderNo decimal(3,0) unsigned not null comment '????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , ConstructionName varchar(300) comment '?H??????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint attnoticeconstrction_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
 ) comment '????o?H???f?[?^' ;
 -- ?L???x??????R?t?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists attnpaidholidyalink cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table attnpaidholidyalink (
   PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , AttendanceNo decimal(2,0) unsigned not null comment '????'
   , AttendanceMonth decimal(6,0) unsigned not null comment '?o?????N??'
   , OrderNo decimal(3,0) unsigned not null comment '????'
   , PreviousYear decimal(3,1) not null comment '?O?N?x?L??????'
   , CurrentYear decimal(3,1) not null comment '???N?x?L??????'
   , Completed decimal(1,0) unsigned not null comment '?????????t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint attnpaidholidyalink_PKC primary key (PersonCode,AttendanceNo,AttendanceMonth,OrderNo)
 ) comment '?L???x??????R?t?f?[?^' ;
-            bit
+-- ??s?c????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bankbusinessdaymaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^' ;
-            h-you
+-- ?H?????????O?f?[?^
 --* BackupToTempTable
 drop table if exists beforecreatingledger cascade;
 --* RestoreFromTempTable
 create table beforecreatingledger (
   ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'
   , TargetMonth decimal(6,0) unsigned not null comment '???N??'
   , PaymentAmount decimal(12,0) not null comment '???????z'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint beforecreatingledger_PKC primary key (ConstructionCode,GroupCount,TargetMonth)
 ) comment '?H?????????O?f?[?^' ;
-            h-you
+-- ???????????o?[?????N?f?[?^
 --* BackupToTempTable
 drop table if exists billingcostdatalink cascade;
 --* RestoreFromTempTable
 create table billingcostdatalink (
   CompanyCode decimal(8,0) default '0' not null comment '??????R?[?h'
   , TargetDate decimal(6,0) default '0' not null comment '???N??'
   , SeqNoB decimal(3,0) default '0' not null comment '?A??'
   , LineCount decimal(3,0) default '0' not null comment '?s???'
   , LabourKind decimal(1,0) not null comment '?x???????E????'
   , LinkType decimal(1,0) not null comment '?????N??f?[?^?^?C?v'
   , YearNumber smallint(5) unsigned not null comment '?N?x'
   , CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O'
   , TargetType decimal(1,0) not null comment '????R?[?h?^?C?v'
   , TargetCode decimal(10,0) not null comment '????R?[?h'
   , SeqNoC decimal(3,0) not null comment '?f?[?^???'
   , PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , ActionDate date not null comment '?????t'
   , DataType decimal(1,0) not null comment '?f?[?^??'
   , DataAddCount decimal(5,0) unsigned not null comment '?f?[?^??????'
   , EntryDate datetime comment '?o?^?N????'
   , UpdateDate datetime comment '?X?V?N????'
   , constraint billingcostdatalink_PKC primary key (CompanyCode,TargetDate,SeqNoB,LineCount,LabourKind)
 ) comment '???????????o?[?????N?f?[?^' ;
 create index BillingCostDataLink_Index1
   on billingcostdatalink(YearNumber,CostType,TargetType,TargetCode,SeqNoC);
 create index BillingCostDataLink_Index2
   on billingcostdatalink(PersonCode,ActionDate,DataType,DataAddCount);
-            bit
+-- ???????f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists billingdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists billingdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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???'
-            h-you
+  , LABOURKIND decimal(1,0) not null comment '?x???????E????'
-            bit
+  , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'
-            h-you
+  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '????????'
   , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '??????'
   , LinkDataType decimal(1,0) not null comment '??A?t???f?[?^?^?C?v'
-            bit
+  , 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??'
-            h-you
+  , OverFlg decimal(1,0) comment '?x??????t???O'
-            bit
+  , NOTE varchar(120) comment '???l'
-            h-you
+  , DELETEFLG decimal(1,0) comment '???t???O'
-            bit
+  , ENTRYDATE datetime comment '?o?^?N????'
   , UPDATEDATE datetime comment '?X?V?N????'
-            h-you
+  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,LABOURKIND)
-            bit
+) comment '??????????f?[?^' ;
-            h-you
+create index billingdatadetail_Index1
   on billingdatadetail(COMPANYCODE);
 create index billingdatadetail_Index2
   on billingdatadetail(TARGETDATE);
 create index billingdatadetail_Index3
   on billingdatadetail(SEQNO);
 create index billingdatadetail_Index4
   on billingdatadetail(LINECOUNT);
 create index billingdatadetail_Index5
   on billingdatadetail(LABOURKIND);
 create index billingdatadetail_Index6
   on billingdatadetail(CONSTRUCTIONCODE);
 create index billingdatadetail_Index7
   on billingdatadetail(CONSTRUCTIONROWCNT);
 create index billingdatadetail_Index8
   on billingdatadetail(CONSTRUCTIONCOLCNT);
-            bit
+-- ???????x???T?}???[?f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists billingpaymentsummary cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?????????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bizperiodhistory cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bk_constructionledger cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bk_constructionledgerdetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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???'
-            h-you
+  , LineCount decimal(4,0) unsigned not null comment '?s???'
-            bit
+  , 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'
-            h-you
+  , DetailCount decimal(4,0) unsigned not null comment '??????'
   , InvalidLine decimal(1,0) not null comment '?????s'
-            bit
+  , 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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bk_constructionledgerexcute cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bk_estimatedata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bk_estimatedatabody cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists bk_estimatedatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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???'
-            h-you
+  , LineCount decimal(4,0) unsigned not null comment '?s???'
-            bit
+  , 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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists budgetsumcode cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists businesstypemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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);
-            h-you
+-- ?v?Z?W??????e?[?u??
 --* BackupToTempTable
 drop table if exists calccoefficient cascade;
 --* RestoreFromTempTable
 create table calccoefficient (
   TypeCode decimal(2,0) unsigned not null comment '?W???^?C?v?R?[?h'
   , SeqNo decimal(2,0) unsigned not null comment '????'
   , CalcCoefficient01 decimal(15,5) not null comment '?W???l1'
   , CalcCoefficient02 decimal(15,5) not null comment '?W???l2'
   , CalcCoefficient03 decimal(15,5) not null comment '?W???l3'
   , CalcCoefficient04 decimal(15,5) not null comment '?W???l4'
   , CalcCoefficient05 decimal(15,5) not null comment '?W???l5'
   , CalcCoefficient06 decimal(15,5) not null comment '?W???l6'
   , CalcCoefficient07 decimal(15,5) not null comment '?W???l7'
   , CalcCoefficient08 decimal(15,5) not null comment '?W???l8'
   , CalcCoefficient09 decimal(15,5) not null comment '?W???l9'
   , CalcCoefficient10 decimal(15,5) not null comment '?W???l10'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint calccoefficient_PKC primary key (TypeCode,SeqNo)
 ) comment '?v?Z?W??????e?[?u??' ;
-            bit
+-- ?S????????????f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists chgchargedep cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists chgconstrcharge cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^' ;
-            h-you
+-- Web-EDI??????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists closingdateofmonth cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table closingdateofmonth (
   TARGETDATE decimal(6,0) unsigned default '0' not null comment '???N??'
   , SEQNO decimal(3,0) default '0' not null comment '?A??'
   , StartDate date comment '????J?n??'
   , CompDate date comment '?????????'
   , PayPlansDate date comment '?x???\???'
   , ENTRYDATE datetime comment '?o?^?N????'
   , UPDATEDATE datetime comment '?X?V?N????'
   , constraint closingdateofmonth_PKC primary key (TARGETDATE,SEQNO)
 ) comment 'Web-EDI??????f?[?^' ;
-            bit
+-- ????????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists commoncostlarge cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists commoncostlinkms cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists commoncostmiddle cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists commoncostmiddlesearchword cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists componentlinkmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists componentmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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-you
+-- ?H?????E?\???????N?}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists componenttotypemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table componenttotypemaster (
-            h-you
+  TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'
   , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
   , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
-            bit
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint componenttotypemaster_PKC primary key (TypeCode,ComponentCode)
 ) comment '?H?????E?\???????N?}?X?^' ;
             bit
 create index ComponentToTypeMaster_Index1
-            h-you
+  on componenttotypemaster(TypeCode);
             bit
 create index ComponentToTypeMaster_Index2
-            h-you
+  on componenttotypemaster(ComponentCode);
             bit
 -- ?H???????o??f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constrledgerexpenses cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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????{???
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionbaseinfo cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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 '??????????????'
-            h-you
+  , ExpectedOrder decimal(3,0) not null comment '?????x'
-            h-you
+  , EvaluationScore decimal(5,2) unsigned not null comment '?]???_??'
-            bit
+  , 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????{????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionbaseinfodetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionbudget cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionbudgetdetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionitemmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionledger cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionledgerdetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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 '??????'
-            h-you
+  , InvalidLine decimal(1,0) not null comment '?????s'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionledgerexcute cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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-you
+create index LedgerExcute_Index2
   on constructionledgerexcute(ConstructionCode);
 create index LedgerExcute_Index3
   on constructionledgerexcute(GroupCount);
 create index LedgerExcute_Index4
   on constructionledgerexcute(LineCount);
 create index LedgerExcute_Index5
   on constructionledgerexcute(ColumnCount);
 create index LedgerExcute_Index6
   on constructionledgerexcute(TargetMonth);
-            bit
+-- ?H???????N???
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionlink cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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????????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionmaterialinfo cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionprogressdate cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionspecmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructionspecunitprice cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table constructionspecunitprice (
-            h-you
+  ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h'
   , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
-            bit
+  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
   , SpecCode decimal(5,0) unsigned not null comment '???L?['
   , UnitPrice decimal(9,2) not null comment '?P??'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint constructionspecunitprice_PKC primary key (ConstructionTypeCode,ComponentCode,ItemCode,SpecCode)
-            bit
+) comment '???P???}?X?^' ;
-            h-you
+create index constructionspecunitprice_Index1
   on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode);
-            bit
+-- ?H?????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists constructiontypemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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??'
-            h-you
+  , CompanyProp decimal(1,0) not null comment '????H????'
-            bit
+  , 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?^' ;
-            h-you
+-- ?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists consumptiontax cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table consumptiontax (
   StartDate date not null comment '?g?p?J?n?N????'
   , ComplateDate date comment '?g?p?I???N????'
   , TaxRate decimal(4,2) default '0.00' not null comment '??????'
   , DeleteFlg decimal(1,0) comment '???t???O'
   , EntryDate datetime comment '?o?^?N????'
   , UpdateDate datetime comment '?X?V?N????'
   , constraint consumptiontax_PKC primary key (StartDate)
 ) comment '?????f?[?^' ;
-            bit
+-- ?????o?[?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists costdataofcompensation cascade;
 --* RestoreFromTempTable
 create table costdataofcompensation (
   YearNumber smallint(5) unsigned not null comment '?N?x'
   , CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O'
   , TargetType decimal(1,0) not null comment '????R?[?h?^?C?v'
   , TargetCode decimal(10,0) not null comment '????R?[?h'
   , SeqNo decimal(3,0) not null comment '?f?[?^???'
   , PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , FromCodeType decimal(1,0) not null comment '?o?[???R?[?h?^?C?v'
   , FromCode decimal(10,0) not null comment '?o?[???R?[?h'
   , SendDate date not null comment '?????t'
   , LinkCode decimal(10,0) not null comment '?????N??H???R?[?h'
   , EntryPrice decimal(10,0) not null comment '???z?i????j'
   , EntryTax decimal(10,0) not null comment '???z?i????j'
   , Content varchar(120) comment '?x?????e'
   , BikoComment varchar(120) comment '???l'
   , LockFlg decimal(1,0) not null comment '?f?[?^???b?N'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint costdataofcompensation_PKC primary key (YearNumber,CostType,TargetType,TargetCode,SeqNo)
 ) comment '?????o?[?f?[?^' ;
 create index CostDataOfCompensation_Index1
   on costdataofcompensation(YearNumber);
 create index CostDataOfCompensation_Index2
   on costdataofcompensation(CostType);
 create index CostDataOfCompensation_Index3
   on costdataofcompensation(TargetType);
 create index CostDataOfCompensation_Index4
   on costdataofcompensation(TargetCode);
 create index CostDataOfCompensation_Index5
   on costdataofcompensation(PersonCode);
 create index CostDataOfCompensation_Index6
   on costdataofcompensation(FromCode);
 create index CostDataOfCompensation_Index7
   on costdataofcompensation(SendDate);
 -- ?????o?[?f?[?^
 --* BackupToTempTable
-            bit
+drop table if exists costdataofdepartment cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists costdataofperson cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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);
-            h-you
+-- ?o?[???o?????}?X?^
 --* BackupToTempTable
 drop table if exists costdatatargettypeexpenses cascade;
 --* RestoreFromTempTable
 create table costdatatargettypeexpenses (
   CostType decimal(1,0) not null comment '?o?[?^?C?v?t???O'
   , TargetType decimal(1,0) not null comment '?o?[??R?[?h?^?C?v'
   , ExpensesCode decimal(6,0) not null comment '???o??R?[?h'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint costdatatargettypeexpenses_PKC primary key (CostType,TargetType,ExpensesCode)
 ) comment '?o?[???o?????}?X?^' ;
 create index CostDataTargetTypeExpenses_Index1
   on costdatatargettypeexpenses(CostType);
 create index CostDataTargetTypeExpenses_Index2
   on costdatatargettypeexpenses(TargetType);
 create index CostDataTargetTypeExpenses_Index3
   on costdatatargettypeexpenses(ExpensesCode);
 -- ?o?[?^?C?v????}?X?^
 --* BackupToTempTable
 drop table if exists costdatatype cascade;
 --* RestoreFromTempTable
 create table costdatatype (
   CostType decimal(1,0) not null comment '?o?[?^?C?v?R?[?h'
   , TargetType decimal(1,0) not null comment '?o?[??R?[?h?^?C?v'
   , CostDataTypeName varchar(60) comment '?o?[?^?C?v????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint costdatatype_PKC primary key (CostType,TargetType)
 ) comment '?o?[?^?C?v????}?X?^' ;
 create index CostDataType_Index1
   on costdatatype(CostType);
 create index CostDataType_Index2
   on costdatatype(TargetType);
-            bit
+-- ??????o?^?\???f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists costomerregist cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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 '???????'
-            h-you
+  , OrderDate decimal(6,0) unsigned not null comment '?\????'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists dailydataconstruction cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table dailydataconstruction (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            bit
+  , DailyDataDate date not null comment '???????'
-            h-you
+  , PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
-            bit
+  , Weather varchar(60) comment '?V?C'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydataconstruction_PKC primary key (ConstructionCode,DailyDataDate,PersonCode)
-            bit
+) comment '????f?[?^' ;
 create index DailyDataConstruction_Index1
-            h-you
+  on dailydataconstruction(ConstructionCode);
             bit
 create index DailyDataConstruction_Index2
   on dailydataconstruction(DailyDataDate);
 -- ????f?[?^ (????)
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists dailydatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table dailydatadetail (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            bit
+  , DailyDataDate date not null comment '???????'
-            h-you
+  , PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
-            bit
+  , 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'
-            h-you
+  , constraint dailydatadetail_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
-            bit
+) comment '????f?[?^ (????)' ;
 create index DailyDataDetail_Index
-            h-you
+  on dailydatadetail(ConstructionCode,DailyDataDate,PersonCode);
             bit
 -- ????f?[?^ (??????)
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists dailydatafield cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table dailydatafield (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            bit
+  , DailyDataDate date not null comment '???????'
-            h-you
+  , PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
-            bit
+  , 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'
-            h-you
+  , constraint dailydatafield_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
-            bit
+) comment '????f?[?^ (??????)' ;
 create index DailyDataField_Index
-            h-you
+  on dailydatafield(ConstructionCode,DailyDataDate);
             bit
 -- ????f?[?^ (????)
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists dailydatamaterials cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table dailydatamaterials (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            bit
+  , DailyDataDate date not null comment '???????'
-            h-you
+  , PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
-            bit
+  , 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'
-            h-you
+  , constraint dailydatamaterials_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
-            bit
+) comment '????f?[?^ (????)' ;
 create index DailyDataMaterials_Index
-            h-you
+  on dailydatamaterials(ConstructionCode,DailyDataDate);
             bit
 -- ????f?[?^ (??????w??)
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists dailydatasubcontractors cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table dailydatasubcontractors (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            bit
+  , DailyDataDate date not null comment '???????'
-            h-you
+  , PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
-            bit
+  , 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'
-            h-you
+  , constraint dailydatasubcontractors_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
-            bit
+) comment '????f?[?^ (??????w??)' ;
 create index DailyDataSubcontractors_Index
-            h-you
+  on dailydatasubcontractors(ConstructionCode,DailyDataDate);
             bit
 -- ????f?[?^ (???)
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists dailydatavehicles cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table dailydatavehicles (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            bit
+  , DailyDataDate date not null comment '???????'
-            h-you
+  , PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
-            bit
+  , 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'
-            h-you
+  , constraint dailydatavehicles_PKC primary key (ConstructionCode,DailyDataDate,PersonCode,SeqNo)
-            bit
+) comment '????f?[?^ (???)' ;
 create index DailyDataVehicles_Index
-            h-you
+  on dailydatavehicles(ConstructionCode,DailyDataDate);
             bit
 -- ???}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists daymaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table daymaster (
   days smallint(6) not null comment '??'
   , constraint daymaster_PKC primary key (days)
 ) comment '???}?X?^' ;
 -- ?????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists deadlinemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists departmentexpensesmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists departmentmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists depositapprovalinfo cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists depositdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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'
-            h-you
+  , FEES decimal(10,0) comment '????'
   , OTHERADJUSTMENTS decimal(10,0) comment '????'
   , CNSTRPRICE decimal(10,0) comment '?????'
   , REMAININGCLEARING decimal(10,0) comment '?????c???z'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists depositdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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'
-            h-you
+  , ORDERNO decimal(2,0) not null comment '??t???'
   , DEPOSITMONTH decimal(6,0) not null comment '?????N??'
   , SEQNO decimal(3,0) not null comment '?????A??'
-            bit
+  , DEPOSITAMOUNT decimal(10,0) comment '???????z?i??????j'
-            h-you
+  , TAXAMOUNT decimal(10,0) comment '?????'
-            bit
+  , 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'
-            h-you
+  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO,ORDERNO)
-            bit
+) comment '????????f?[?^' ;
-            h-you
+create index depositdatadetail_Index1
   on depositdatadetail(TARGETDATE);
 create index depositdatadetail_Index2
   on depositdatadetail(ORDERERSDIVISION,ORDERERSCODE,DEPOSITMONTH,SEQNO);
-            bit
+-- ???}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists divisionmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists estimatebudget cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists estimatebudgetdetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists estimatedata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists estimatedatabody cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists estimatedatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table estimatedatadetail (
   ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'
-            h-you
+  , LineCount decimal(4,0) unsigned not null comment '?s???'
-            bit
+  , 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???@'
-            h-you
+  , Unitcount decimal(9,3) not null comment '????'
-            bit
+  , UnitName varchar(30) comment '?P?????'
-            h-you
+  , UnitPrice decimal(11,2) not null comment '?P??'
-            bit
+  , 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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists expensesmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists holidaycalendermaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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);
-            h-you
+-- ??????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists inputbillingdata cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table inputbillingdata (
   COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
   , SEQNO decimal(3,0) default '0' not null comment '?A??'
   , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'
   , FIELDNAME varchar(120) comment '????'
   , PERSONNAME varchar(60) comment '?S?????'
   , BILLPRICE decimal(10,0) comment '???????z'
   , CONSUMPTIONTAX decimal(10,0) comment '?????'
   , OTHERPRICE decimal(10,0) comment '??????'
   , DELETEFLG decimal(1,0) comment '???t???O'
   , ENTRYDATE datetime comment '?o?^?N????'
   , UPDATEDATE datetime comment '?X?V?N????'
   , constraint inputbillingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
 ) comment '??????????f?[?^' ;
 -- ?????????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists inputbillingdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table inputbillingdatadetail (
   COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
   , SEQNO decimal(3,0) default '0' not null comment '?A??'
   , LINECOUNT decimal(3,0) default '0' not null comment '?s???'
   , LABOURKIND decimal(1,0) not null comment '?x???????E????'
   , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'
   , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '????????'
   , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '??????'
   , FIELDNAME varchar(120) comment '????'
   , SECONDSTRING varchar(120) comment '?H?????e'
   , BILLPRICE decimal(10,0) comment '???????z'
   , HIGHWPRICE decimal(10,0) comment '??????'
   , HARDWPRICE decimal(10,0) comment '??????'
   , INDSWASTETAX decimal(10,0) comment '?Y?p??'
   , NOTE varchar(120) comment '???l'
   , DELETEFLG decimal(1,0) comment '???t???O'
   , ENTRYDATE datetime comment '?o?^?N????'
   , UPDATEDATE datetime comment '?X?V?N????'
   , constraint inputbillingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
 ) comment '?????????????f?[?^' ;
 -- ????????????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists inputbillingstatus cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table inputbillingstatus (
   COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
   , SEQNO decimal(3,0) default '0' not null comment '?A??'
   , STATUS decimal(1,0) default '0' comment '???????'
   , ENTRYDATE datetime comment '?o?^?N????'
   , UPDATEDATE datetime comment '?X?V?N????'
   , constraint inputbillingstatus_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
 ) comment '????????????' ;
-            bit
+-- ?????????????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists inputsearchlogdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists invoicedata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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'
-            h-you
+  , DELETEFLG decimal(1,0) comment '???t???O'
-            bit
+  , 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) ;
-            h-you
+-- ???O?C??????
 --* BackupToTempTable
 drop table if exists loginlog cascade;
 --* RestoreFromTempTable
 create table loginlog (
   PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , TargetMonth decimal(6,0) unsigned not null comment '???N??'
   , LastLogin datetime not null comment '??????I???O?C??????'
   , LastLogout datetime not null comment '??????I???O?A?E?g????'
   , TotalTime decimal(10,0) not null comment '??v???O?C??????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint loginlog_PKC primary key (PersonCode,TargetMonth)
 ) comment '???O?C??????' ;
-            h-you
+-- ???[???R???e???c?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists mailcontentsmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table mailcontentsmaster (
   MailDelivery decimal(3,0) not null comment '???M??????'
   , MailTitle varchar(30) comment '???[???^?C?g??'
   , MailContent varchar(400) comment '???[???{??'
   , constraint mailcontentsmaster_PKC primary key (MailDelivery)
 ) comment '???[???R???e???c?}?X?^' ;
-            bit
+-- ??????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists materialinfo cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists materialitemmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists materialkindmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^' ;
 -- ??????????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists materialrecordinfo cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists messageboarddata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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??
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists messageboardterget cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?{??????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists messagebrowsinghistory cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists monthmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table monthmaster (
   month smallint(6) not null comment '??'
   , constraint monthmaster_PKC primary key (month)
 ) comment '???}?X?^' ;
-            h-you
+-- ???m?????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists notificationmessage cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table notificationmessage (
   MessageDate datetime not null comment '?\???N????'
   , SeqNo decimal(3,0) unsigned not null comment '?A??'
   , MessageTitle varchar(100) comment '???m???^?C?g??'
   , MessageContent varchar(1333) not null comment '???m?????e'
   , PersonCode decimal(8,0) not null comment '??????S????R?[?h'
   , ShareFlag decimal(2,0) not null comment '???????t???O'
   , MessageColor varchar(8) comment '?????F'
   , BackColor varchar(8) comment '?o?b?N?J???['
   , QueSeqNo decimal(8,0) default '0' not null comment '???M?L???[?A??'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint notificationmessage_PKC primary key (MessageDate,SeqNo)
 ) comment '???m?????' ;
 -- ???m???{?????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists notificationmessagebrowsing cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table notificationmessagebrowsing (
   MessageDate datetime not null comment '?\???N????'
   , SeqNo decimal(4,0) unsigned not null comment '?A??'
   , CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , BrowsingFlag decimal(1,0) unsigned default '0' not null comment '?{???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint notificationmessagebrowsing_PKC primary key (MessageDate,SeqNo,CompanyCode)
 ) comment '???m???{?????' ;
 create index NotificationMessageBrowsing_Index1
   on notificationmessagebrowsing(CompanyCode);
 -- ???m???????I?????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists notificationmessageselect cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table notificationmessageselect (
   MessageDate datetime not null comment '?\???N????'
   , SeqNo decimal(4,0) unsigned not null comment '?A??'
   , CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint notificationmessageselect_PKC primary key (MessageDate,SeqNo,CompanyCode)
 ) comment '???m???????I?????' ;
-            bit
+-- ??????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists orderersmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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???'
-            h-you
+  , JapaneseSyllabary varchar(2) comment '50?????'
-            bit
+  , MailAddress varchar(257) comment '???[???A?h???X'
   , Note varchar(300) comment '???l'
-            h-you
+  , PersonCode decimal(8,0) not null comment '?o?^?S????R?[?h'
-            bit
+  , 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?^' ;
-            h-you
+create index orderersmaster_Index1
   on orderersmaster(JapaneseSyllabary);
-            bit
+-- ????z?f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists orderspricedata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists paymentapprovalinfo cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists paymentdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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???'
-            h-you
+  , LABOURKIND decimal(1,0) not null comment '?x???????E????'
-            bit
+  , 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??'
-            h-you
+  , APPROVALPERSONCODE decimal(8,0) comment '?\???S????R?[?h'
   , APPROVALDATE date comment '?S????\?????t'
-            bit
+  , APPROVALENDFLG decimal(1,0) comment '???F?????t???O'
   , ENTRYDATE datetime comment '?o?^???t'
   , UPDATEDATE datetime comment '?X?V???t'
-            h-you
+  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,LABOURKIND)
-            bit
+) comment '?x??????f?[?^' ;
 create index PayDataDetail_Index1
   on paymentdatadetail(TARGETDATE);
 create index PayDataDetail_Index2
   on paymentdatadetail(APPROVALPERSONCODE);
 -- ?H??????????f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists periodavoidance cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists personapproval cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table personapproval (
   PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
-            h-you
+  , OrderDate decimal(6,0) unsigned not null comment '??t??'
-            bit
+  , 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?[?^' ;
-            h-you
+create index personapproval_Index1
   on personapproval(PersonCode);
 create index personapproval_Index2
   on personapproval(ApprovalCode);
 create index personapproval_Index3
   on personapproval(OrderDate);
 create index personapproval_Index4
   on personapproval(OrderNo);
 create index personapproval_Index5
   on personapproval(PersonCodeApproval);
-            bit
+-- ?S??????F?R?????g?f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists personapprovalcomment cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table personapprovalcomment (
   PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
-            h-you
+  , OrderDate decimal(6,0) unsigned not null comment '??t??'
-            bit
+  , 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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists persondepartmentmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists personinchargemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?????'
-            h-you
+  , PersonNameKana varchar(60) comment '?t???K?i'
   , Sex decimal(1,0) default '0' comment '????'
   , BloodType varchar(6) comment '???t?^'
   , Birthday date not null comment '???N????'
   , ZipCode varchar(8) comment '?X????'
   , Address1 varchar(60) comment '???Z??1'
   , Address2 varchar(60) comment '???Z??2'
   , Address3 varchar(60) comment '???Z??3'
   , PhoneNumber varchar(13) comment '?A????d?b???'
   , EmgPhoneNumber varchar(13) comment '??}?A????d?b???'
   , EmgContact varchar(60) comment '??}?A????'
   , StartDate date not null comment '????N????'
   , EndDate date comment '???N????'
-            bit
+  , 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'
-            h-you
+  , DisplayString varchar(20) comment '??E????'
-            bit
+  , 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 '??????'
-            h-you
+  , PaidVacationDays decimal(4,1) not null comment '???N?x?L???x?????'
   , PaidVacationDaysPrev decimal(4,1) not null comment '?O?N?x?L???x?????'
   , WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'
   , PaidDayOffFlg decimal(1,0) unsigned not null comment '?L?????t???O'
-            bit
+  , 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);
-            h-you
+-- ?S??????i?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists personqualification cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table personqualification (
   PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , SeqNo decimal(3,0) unsigned not null comment '?f?[?^????'
   , DCode decimal(5,0) unsigned not null comment '?????'
   , Qcode decimal(5,0) unsigned not null comment '???i?R?[?h'
   , DateOfAcquisition datetime not null comment '???i?????t'
   , Qualification varchar(120) comment '????????i??'
   , Notes varchar(120) comment '???l'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint personqualification_PKC primary key (PersonCode,SeqNo)
 ) comment '?S??????i?f?[?^' ;
-            bit
+-- ?S??????^?}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists personsalarymaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists pointingoutcomment cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists proceedingsdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists proceedingsdataattend cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists proceedingsdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists processapproval cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists processapprovalcomment cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists processapprovaldetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^' ;
-            h-you
+create index processapprovaldetail_Index1
   on processapprovaldetail(ConstructionCode,ApprovalCode,LinkCode);
-            bit
+-- ?N?????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists processexcutemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table processexcutemaster (
-            h-you
+  SecCode decimal(4,0) unsigned not null comment '???????'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists purchaseorder cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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????'
-            h-you
+  , RePrintFlag decimal(1,0) default '0' not null comment '??????\?t???O?i???g?p?j'
   , OrderDate date not null comment '??E?L?????Z???N????'
   , OrderStatus decimal(1,0) default '0' not null comment '????'
-            h-you
+  , OrderStDate date not null comment '???H??'
   , OrderEdDate date not null comment '??????'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists purchaseorderdate cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists purchaseorderdetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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);
-            h-you
+-- ???i?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists qualificationmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table qualificationmaster (
   DCode decimal(5,0) unsigned not null comment '?????'
   , Qcode decimal(5,0) unsigned not null comment '???i?R?[?h'
   , Qualification varchar(120) comment '????E???i??'
   , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
   , DeleteFlg decimal(1,0) default '0' not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint qualificationmaster_PKC primary key (DCode,Qcode)
 ) comment '???i?}?X?^' ;
 create index QualificationMaster_Index1
   on qualificationmaster(DCode);
 create index QualificationMaster_Index2
   on qualificationmaster(Qcode);
 create index QualificationMaster_Index3
   on qualificationmaster(DisplayOrder);
-            h-you
+-- ?S?????????f?[?^
 --* BackupToTempTable
 drop table if exists quarterlysales cascade;
 --* RestoreFromTempTable
 create table quarterlysales (
   YearCode decimal(5,0) unsigned not null comment '???N?x'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , OrderNo decimal(4,0) unsigned not null comment '?f?[?^??'
   , ConstructionStart date comment '?_??H???J?n??'
   , ConstructionEnd date comment '?_??H??????'
   , OrdersPrice decimal(12,0) not null comment '???????z'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint quarterlysales_PKC primary key (YearCode,ConstructionCode,OrderNo)
 ) comment '?S?????????f?[?^' ;
 create index QuarterlySales_Index1
   on quarterlysales(YearCode);
 create index QuarterlySales_Index2
   on quarterlysales(ConstructionCode);
 create index QuarterlySales_Index3
   on quarterlysales(OrderNo);
 -- ?S???????????f?[?^
 --* BackupToTempTable
 drop table if exists quarterlysalesdetail cascade;
 --* RestoreFromTempTable
 create table quarterlysalesdetail (
   YearCode decimal(5,0) unsigned not null comment '???N?x'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , OrderNo decimal(4,0) unsigned not null comment '?f?[?^??'
   , SeqNo decimal(2,0) not null comment '?f?[?^???'
   , DataType decimal(1,0) unsigned not null comment '?f?[?^?^?C?v'
   , DataYM decimal(6,0) unsigned not null comment '???N??'
   , PriceValue decimal(12,0) not null comment '?????z'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint quarterlysalesdetail_PKC primary key (YearCode,ConstructionCode,OrderNo,SeqNo,DataType)
 ) comment '?S???????????f?[?^' ;
 create index QuarterlySalesDetail_Index1
   on quarterlysalesdetail(YearCode);
 create index QuarterlySalesDetail_Index2
   on quarterlysalesdetail(ConstructionCode);
 create index QuarterlySalesDetail_Index3
   on quarterlysalesdetail(OrderNo);
 create index QuarterlySalesDetail_Index4
   on quarterlysalesdetail(SeqNo);
 create index QuarterlySalesDetail_Index5
   on quarterlysalesdetail(DataType);
 create index QuarterlySalesDetail_Index6
   on quarterlysalesdetail(DataYM);
-            bit
+-- ???R?[?h??????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists recordkey cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists reminvoicedata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists reminvoicedatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^' ;
-            h-you
+-- ????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists removerequest cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table removerequest (
   RemoveNo decimal(10,0) not null comment '???No'
   , RemoveDate decimal(8,0) not null comment '?????????'
   , RemovePersonCode decimal(8,0) unsigned not null comment '????????S????R?[?h'
   , RemoveComment varchar(500) comment '??????e'
   , 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 removerequest_PKC primary key (RemoveNo,RemoveDate)
 ) comment '????????f?[?^' ;
 create index RemoveRequest_Index1
   on removerequest(RequestNo);
 create index RemoveRequest_Index2
   on removerequest(ReqConstructionCode);
 create index RemoveRequest_Index3
   on removerequest(ORDERNO);
 -- ????????f?[?^????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists removerequestdetail cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table removerequestdetail (
   RemoveNo decimal(10,0) not null comment '???No'
   , SeqNo decimal(9,0) not null comment '??tno'
   , 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 removerequestdetail_PKC primary key (RemoveNo,SeqNo)
 ) comment '????????f?[?^????' ;
-            bit
+-- ?????f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists requestdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^????
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists requestdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?_
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists requesthead cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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'
-            h-you
+  , BILLINGDATE datetime not null comment '??????'
   , BILLCONFIRMDATE datetime not null comment '?????m?F??'
-            h-you
+  , DELETEFLG decimal(1,0) comment '???t???O'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists requestorderdate cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists salesgraphdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists securitymaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table securitymaster (
-            h-you
+  SecCode decimal(4,0) unsigned not null comment '???????'
   , DisplayOrder decimal(4,0) not null comment '?\????'
-            bit
+  , 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'
-            h-you
+  , DeleteFlg decimal(1,0) not null comment '???t???O'
-            bit
+  , 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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists sfpdata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists sfpdatadetail cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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-you
+-- ????????[?????M?L???[
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subconmailqueue cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subconmailqueue (
   SeqNo decimal(8,0) default '0' not null comment '?A??'
   , CompanyCode decimal(8,0) default '0' not null comment '??????R?[?h'
   , MailDelivery decimal(3,0) default '0' not null comment '???M??????'
   , Argument0 varchar(32) comment '???[???}???????O'
   , Argument1 varchar(32) comment '???[???}???????P'
   , Argument2 varchar(32) comment '???[???}???????Q'
   , Argument3 varchar(32) comment '???[???}???????R'
   , Argument4 varchar(32) comment '???[???}???????S'
   , Status decimal(1,0) default '0' not null comment '?X?e?[?^?X'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint subconmailqueue_PKC primary key (SeqNo,CompanyCode)
 ) comment '????????[?????M?L???[' ;
 create index subconmailqueue_Index1
   on subconmailqueue(CompanyCode);
 create index subconmailqueue_Index2
   on subconmailqueue(Argument0);
-            bit
+-- ??????{?H?H??o?^?\???f?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subconstrjobitemregist cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subconstrjoblinkregist cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subconstrregist cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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????'
-            h-you
+  , OrderDate decimal(6,0) unsigned comment '?\????'
-            bit
+  , 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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subcontractoritemmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subcontractorjobcategory cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subcontractorjobitem cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subcontractorjoblink cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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);
-            h-you
+-- ????????[???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontractormail cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontractormail (
   CompanyCode decimal(8,0) default '0' not null comment '??????R?[?h'
   , SeqNo decimal(3,0) default '0' not null comment '?A??'
   , MailAddress varchar(257) comment '???[???A?h???X'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint subcontractormail_PKC primary key (CompanyCode,SeqNo)
 ) comment '????????[???f?[?^' ;
-            bit
+-- ??????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists subcontractormaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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 '???????'
-            h-you
+  , CompanyNameKana varchar(100) not null comment '????????i?J?i?j'
-            bit
+  , CEOPositionName varchar(60) comment '??\???E??'
   , CEOName varchar(60) comment '??\?????'
-            h-you
+  , CEONameKana varchar(60) comment '??\??????i?J?i?j'
-            bit
+  , ContactPersonName varchar(60) comment '?S???????'
-            h-you
+  , ContactPersonNameKana varchar(60) comment '?S????????i?J?i?j'
-            bit
+  , 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????'
-            h-you
+  , RequestImputId varchar(8) not null comment '????????ID'
   , Password varchar(20) comment '?p?X???[?h'
   , BankCode decimal(4,0) unsigned not null comment '??s?R?[?h'
   , BankName varchar(20) comment '??s??'
   , BankBranchCode decimal(3,0) unsigned not null comment '?x?X?R?[?h'
   , BankBranchName varchar(20) comment '?x?X??'
   , BankAccountKind decimal(1,0) not null comment '???????'
   , BankAccountNo decimal(7,0) unsigned not null comment '???????'
   , BankAccountName varchar(30) comment '???????`(???l??)'
   , TransferFees decimal(4,0) unsigned not null comment '?U??????'
   , ConfirmedDate datetime not null comment '?f?[?^?m?F??'
-            bit
+  , 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?^' ;
-            h-you
+alter table subcontractormaster add unique SubContractorMaster_Index2 (RequestImputId) ;
-            bit
+create index SubContractorMaster_Index1
   on subcontractormaster(JapaneseSyllabary);
-            h-you
+-- ????????[?????M???
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontrmaildelivery cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontrmaildelivery (
   CompanyCode decimal(8,0) default '0' not null comment '??????R?[?h'
   , SeqNo decimal(3,0) default '0' not null comment '?A??'
   , MailDelivery decimal(3,0) default '0' not null comment '???M??????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint subcontrmaildelivery_PKC primary key (CompanyCode,SeqNo,MailDelivery)
 ) comment '????????[?????M???' ;
-            bit
+-- ?d????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists suppliersmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists systemexecute cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists systemmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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'
-            h-you
+  , OperationFlg decimal(2,0) unsigned not null comment '???F?^?p?t???O'
-            h-you
+  , SystemOpenTime datetime not null comment '?^?p?J?n????'
   , SystemCloseTime datetime not null comment '?^?p?I??????'
   , PesrsonCost1 decimal(7,0) unsigned not null comment '???l????P?i?w?????R?X?g?j'
   , PesrsonCost2 decimal(7,0) unsigned not null comment '???l????Q?i???S????R?X?g?j'
-            bit
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint systemmaster_PKC primary key (SystemCode)
 ) comment '????}?X?^' ;
 -- ?????}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists termmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists tranceportdailydata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists typeexpensesmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists unitmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists vehiclemaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists vehiclerecorddata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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?[?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists vehiclescheduledata cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+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);
-            h-you
+-- ?A?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists workingtime cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table workingtime (
   WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'
   , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
   , WorkingName varchar(60) comment '?A????????'
   , StartTime datetime not null comment '?J?n????'
   , CompTime datetime not null comment '?I??????'
   , OverStartTime datetime not null comment '?c??\???J?n????'
   , OnCalender decimal(1,0) not null comment '?J?????_?[???t???O'
   , MonValue decimal(1,0) not null comment '???j???x?t???O'
   , TueValue decimal(1,0) not null comment '??j???x?t???O'
   , WedValue decimal(1,0) not null comment '???j???x?t???O'
   , ThuValue decimal(1,0) not null comment '??j???x?t???O'
   , FriValue decimal(1,0) not null comment '???j???x?t???O'
   , SatValue decimal(1,0) not null comment '?y?j???x?t???O'
   , SunValue decimal(1,0) not null comment '???j???x?t???O'
   , Note varchar(300) comment '???l'
   , DeleteFlg decimal(1,0) not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint workingtime_PKC primary key (WorkingCode)
 ) comment '?A?????}?X?^' ;
 -- ?A??x?e????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists workingtimebreak cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table workingtimebreak (
   WorkingCode decimal(3,0) unsigned not null comment '?A??R?[?h'
   , BreakNo decimal(2,0) unsigned not null comment '?x?e???'
   , StartTime datetime not null comment '?J?n????'
   , CompTime datetime not null comment '?I??????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
   , constraint workingtimebreak_PKC primary key (WorkingCode,BreakNo)
 ) comment '?A??x?e????}?X?^' ;
-            bit
+-- ?N?}?X?^
-            h-you
+--* BackupToTempTable
-            bit
+drop table if exists yearmaster cascade;
-            h-you
+--* RestoreFromTempTable
-            bit
+create table yearmaster (
   years smallint(6) not null comment '?N'
   , constraint yearmaster_PKC primary key (years)
 ) comment '?N?}?X?^' ;

プロジェクト

全般

プロフィール

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

h-you / trunk / ddl / ProcessManagement.sql @ 487