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

h-you / branches / ddl / ProcessManagement.sql @ 370

-            h-you
+-- Project Name : noname
-            h-you
+-- Date/Time    : 2018/08/06 8:37:19
-            h-you
+-- Author       : Horiuchi
 -- RDBMS Type   : MySQL
 -- Application  : A5:SQL Mk-2
             h-you
-            h-you
+/*
   BackupToTempTable, RestoreFromTempTable?^????????t????????????B
   ???????Adrop table, create table ????f?[?^???c?????B
   ????@?\????I?? $$TableName ???????e?[?u????????????B
 */
-            h-you
+-- ?S????s???\??f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists actionscheduledata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table actionscheduledata (
-            h-you
+  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'
-            h-you
+  , constraint actionscheduledata_PKC primary key (TargetDate,PersonCode)
-            h-you
+) comment '?S????s???\??f?[?^' ;
             h-you
-            h-you
+create index ActionScheduleData_Index1
   on actionscheduledata(TargetYear);
             h-you
-            h-you
+create index ActionScheduleData_Index2
   on actionscheduledata(TargetMonth);
             h-you
-            h-you
+create index ActionScheduleData_Index3
   on actionscheduledata(TargetDay);
             h-you
-            h-you
+-- ???F?o?H?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists approvalmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table approvalmaster (
-            h-you
+  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'
-            h-you
+  , constraint approvalmaster_PKC primary key (ApprovalCode,DepartmentCode,SeqNo)
-            h-you
+) comment '???F?o?H?}?X?^' ;
             h-you
-            h-you
+-- ?o?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists attendancedailydata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table attendancedailydata (
-            h-you
+  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) unsigned not null comment '?H???R?[?h'
-            h-you
+  , ActionResult varchar(30) not null comment '?s??????'
   , StartTime datetime comment '?J?n????'
   , CompTime datetime comment '?I??????'
   , DayTimes decimal(4,1) not null comment '????????v????'
   , WorkingComment varchar(120) comment '?R?????g'
-            h-you
+  , WorkKindFlg decimal(1,0) not null comment '?????t???O'
-            h-you
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)
-            h-you
+) comment '?o?????f?[?^' ;
             h-you
-            h-you
+create index AttendDaily_Index1
   on attendancedailydata(ConstructionCode);
 create index AttendDaily_Index2
   on attendancedailydata(AttendanceDate);
-            h-you
+-- ?o?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists attendancedata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table attendancedata (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , AttendanceMonth date not null comment '?o?????N??'
   , LastDays decimal(2,0) unsigned not null comment '??????I??'
   , AttendDayCount decimal(2,0) unsigned not null comment '?o?????'
   , TotalOverTimes decimal(4,1) not null comment '?c??????'
   , OrderDate date not null comment '?\????'
   , OrderNo decimal(2,0) unsigned not null comment '?\????t???'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint attendancedata_PKC primary key (PersonCode,AttendanceMonth)
-            h-you
+) comment '?o?????f?[?^' ;
             h-you
-            h-you
+-- ??s?c????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bankbusinessdaymaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bankbusinessdaymaster (
-            h-you
+  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????'
-            h-you
+  , constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY)
-            h-you
+) comment '??s?c????}?X?^' ;
             h-you
-            h-you
+-- ???????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists billingdata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table billingdata (
-            h-you
+  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????'
-            h-you
+  , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)
-            h-you
+) comment '???????f?[?^' ;
             h-you
-            h-you
+-- ??????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists billingdatadetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table billingdatadetail (
-            h-you
+  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
   , SEQNO decimal(3,0) default '0' not null comment '?A??'
   , LINECOUNT decimal(3,0) default '0' not null comment '?s???'
   , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'
   , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '?s???'
   , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '????'
   , FIELDNAME varchar(120) comment '????'
   , BILLPRICE decimal(10,0) comment '???????z'
   , HIGHWPRICE decimal(10,0) comment '??????'
   , HARDWPRICE decimal(10,0) comment '??????'
   , INDSWASTETAX decimal(10,0) comment '?Y?p??'
   , NOTE varchar(120) comment '???l'
   , ENTRYDATE datetime comment '?o?^?N????'
   , UPDATEDATE datetime comment '?X?V?N????'
-            h-you
+  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
-            h-you
+) comment '??????????f?[?^' ;
             h-you
-            h-you
+-- ???????x???T?}???[?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists billingpaymentsummary cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table billingpaymentsummary (
-            h-you
+  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????'
-            h-you
+  , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)
-            h-you
+) comment '???????x???T?}???[?f?[?^' ;
             h-you
-            h-you
+-- ?^?c?????????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bizperiodhistory cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+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-you
+-- ?H???????f?[?^?y???p?z
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bk_constructionledger cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bk_constructionledger (
-            h-you
+  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'
-            h-you
+  , constraint bk_constructionledger_PKC primary key (ConstructionCode)
-            h-you
+) comment '?H???????f?[?^?y???p?z' ;
             h-you
-            h-you
+-- ?H??????????f?[?^?y???p?z
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bk_constructionledgerdetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bk_constructionledgerdetail (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'
   , LineCount decimal(5,0) unsigned not null comment '?s???'
   , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
   , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
   , FirstString varchar(120) comment '???????'
   , SecondString varchar(120) comment '?H?????e'
   , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'
   , CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , CompanyName varchar(120) comment '?????????'
   , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'
   , ExecutionAmount decimal(12,0) not null comment '???s???z'
   , AmountConfigRate decimal(5,2) not null comment '???z?\????'
   , PaymentBurden decimal(12,0) not null comment '?x????U?z'
   , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'
   , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'
   , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'
   , SalaryFlg decimal(1,0) not null comment '???^?U????'
   , SalaryDays decimal(4,0) not null comment '???^?U??????'
   , OperatingFlg decimal(1,0) not null comment '?S?????t???O'
   , SourceCode decimal(10,0) unsigned not null comment '???H?????'
   , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'
   , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'
   , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint bk_constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
-            h-you
+) comment '?H??????????f?[?^?y???p?z' ;
             h-you
-            h-you
+-- ?H?????????s?f?[?^?y???p?z
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bk_constructionledgerexcute cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bk_constructionledgerexcute (
-            h-you
+  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'
-            h-you
+  , constraint bk_constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)
-            h-you
+) comment '?H?????????s?f?[?^?y???p?z' ;
             h-you
-            h-you
+-- ??Z????f?[?^?y???p?z
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bk_estimatedata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bk_estimatedata (
-            h-you
+  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'
-            h-you
+  , constraint bk_estimatedata_PKC primary key (SaveDate,ConstructionCode,LineCount)
-            h-you
+) comment '??Z????f?[?^?y???p?z' ;
             h-you
-            h-you
+-- ??Z????y?[?W?f?[?^?y???p?z
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bk_estimatedatabody cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bk_estimatedatabody (
-            h-you
+  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'
-            h-you
+  , constraint bk_estimatedatabody_PKC primary key (SaveDate,ConstructionCode,PageCount)
-            h-you
+) comment '??Z????y?[?W?f?[?^?y???p?z' ;
             h-you
-            h-you
+-- ??Z????f?[?^????y???p?z
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists bk_estimatedatadetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table bk_estimatedatadetail (
-            h-you
+  SaveDate datetime not null comment '?????t'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'
   , LineCount decimal(3,0) unsigned not null comment '?s???'
   , DataType decimal(1,0) not null comment '?f?[?^???'
   , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
   , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
   , SpecCode decimal(5,0) unsigned not null comment '???L?['
   , ItemName varchar(120) comment '??????'
   , SpecName varchar(120) comment '???^?i???E?`??E???@'
   , Unitcount decimal(8,2) not null comment '????'
   , UnitName varchar(30) comment '?P?????'
   , UnitPrice decimal(9,2) not null comment '?P??'
   , LineTotal decimal(12,0) not null comment '???z'
   , note varchar(60) comment '???l'
   , CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'
   , InputFlg decimal(1,0) comment '????t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint bk_estimatedatadetail_PKC primary key (SaveDate,ConstructionCode,PageCount,LineCount)
-            h-you
+) comment '??Z????f?[?^????y???p?z' ;
             h-you
-            h-you
+-- ?\?Z???W?v?R?[?h?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists budgetsumcode cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+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?^' ;
-            h-you
+-- ?@?l?i?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists businesstypemaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table businesstypemaster (
-            h-you
+  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'
-            h-you
+  , constraint businesstypemaster_PKC primary key (BusinessTypeCode)
-            h-you
+) comment '?@?l?i?}?X?^' ;
             h-you
 create index BusinessTypeMaster_Index1
   on businesstypemaster(DisplayOrder);
-            h-you
+-- ?S????????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists chgchargedep cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+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-you
+-- ?H???S????X?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists chgconstrcharge cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+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????'
-            h-you
+  , SourceCode decimal(10,0) unsigned not null comment '???H???R?[?h'
   , DeleteFlg decimal(1,0) not null comment '???t???O'
-            h-you
+  , 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
+-- ????????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists commoncostlarge cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table commoncostlarge (
-            h-you
+  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'
-            h-you
+  , constraint commoncostlarge_PKC primary key (LargeCode)
-            h-you
+) comment '????????}?X?^' ;
             h-you
-            h-you
+-- ?????H???A?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists commoncostlinkms cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table commoncostlinkms (
-            h-you
+  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'
-            h-you
+  , constraint commoncostlinkms_PKC primary key (LargeCode,MiddleCode,ItemCode)
-            h-you
+) comment '?????H???A?}?X?^' ;
             h-you
-            h-you
+-- ?????????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists commoncostmiddle cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table commoncostmiddle (
-            h-you
+  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'
-            h-you
+  , constraint commoncostmiddle_PKC primary key (LargeCode,MiddleCode)
-            h-you
+) comment '?????????}?X?^' ;
             h-you
-            h-you
+-- ?????????L?[?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists commoncostmiddlesearchword cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table commoncostmiddlesearchword (
-            h-you
+  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'
-            h-you
+  , constraint commoncostmiddlesearchword_PKC primary key (LargeCode,MiddleCode,SeqNo)
-            h-you
+) comment '?????????L?[?}?X?^' ;
             h-you
-            h-you
+-- ?\???H???A?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists componentlinkmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table componentlinkmaster (
-            h-you
+  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'
-            h-you
+  , constraint componentlinkmaster_PKC primary key (ComponentCode,ItemCode)
-            h-you
+) comment '?\???H???A?}?X?^' ;
             h-you
-            h-you
+create index ComponentLinkMaster_Index1
   on componentlinkmaster(ComponentCode);
             h-you
-            h-you
+create index ComponentLinkMaster_Index2
   on componentlinkmaster(ItemCode);
             h-you
-            h-you
+-- ?\???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists componentmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table componentmaster (
-            h-you
+  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'
-            h-you
+  , constraint componentmaster_PKC primary key (ComponentCode)
-            h-you
+) comment '?\???}?X?^' ;
             h-you
-            h-you
+create index ComponentMaster_Index1
   on componentmaster(DisplayOrder);
             h-you
-            h-you
+-- ?\???H??????A?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists componenttotypemaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table componenttotypemaster (
-            h-you
+  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
   , TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'
   , Dummy decimal(1,0) not null comment '?_?~?[????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint componenttotypemaster_PKC primary key (ComponentCode,TypeCode)
-            h-you
+) comment '?\???H??????A?}?X?^' ;
             h-you
-            h-you
+create index ComponentToTypeMaster_Index1
   on componenttotypemaster(ComponentCode);
             h-you
-            h-you
+create index ComponentToTypeMaster_Index2
   on componenttotypemaster(TypeCode);
             h-you
-            h-you
+-- ?H???????o??f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constrledgerexpenses cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+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-you
+-- ?H????{???
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionbaseinfo cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionbaseinfo (
-            h-you
+  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'
-            h-you
+  , SalesDepCode decimal(5,0) unsigned not null comment '?c??S????????R?[?h'
   , SalesPersonCode decimal(8,0) unsigned not null comment '?c??S????R?[?h'
-            h-you
+  , SalesSubDepCode decimal(5,0) unsigned not null comment '?c????S????????R?[?h'
   , SalesSubPersonCode decimal(8,0) unsigned not null comment '?c????S????R?[?h'
-            h-you
+  , 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'
-            h-you
+  , TransferConstruction decimal(8,0) not null comment '?H??????R?[?h'
   , TransferConstructionDate date comment '?H??????'
-            h-you
+  , OrderersDivision decimal(5,0) not null comment '????????R?[?h'
-            h-you
+  , 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'
-            h-you
+  , InspectPlanningDate date not null comment '?????\???'
   , InspectExecuteDate date not null comment '???????s??'
   , RevCompleteDate date not null comment '??????????????'
-            h-you
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
-            h-you
+) comment '?H????{???' ;
             h-you
-            h-you
+create index BaseInfo_Index1
   on constructionbaseinfo(ConstructionStatusFlg);
             h-you
-            h-you
+create index BaseInfo_Index2
   on constructionbaseinfo(EstimateType);
             h-you
-            h-you
+create index BaseInfo_Index3
   on constructionbaseinfo(SalesPersonCode);
             h-you
-            h-you
+create index BaseInfo_Index4
   on constructionbaseinfo(ConstructionPersonCode);
             h-you
-            h-you
+create index BaseInfo_Index5
   on constructionbaseinfo(ConstructionInstructor);
             h-you
-            h-you
+create index BaseInfo_Index6
   on constructionbaseinfo(ConstructionPeriod);
             h-you
-            h-you
+-- ?H????{????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionbaseinfodetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionbaseinfodetail (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
-            h-you
+  , DetailNo decimal(3,0) not null comment '??????'
-            h-you
+  , DetailString varchar(300) comment '??????e'
-            h-you
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint constructionbaseinfodetail_PKC primary key (ConstructionCode,DetailNo)
-            h-you
+) comment '?H????{????' ;
             h-you
-            h-you
+create index BaseInfoDetail_Idx1
   on constructionbaseinfodetail(ConstructionCode);
             h-you
-            h-you
+create index BaseInfoDetail_Idx2
   on constructionbaseinfodetail(DetailNo);
             h-you
-            h-you
+-- ?H???{?H?\?Z?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionbudget cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionbudget (
-            h-you
+  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'
-            h-you
+  , constraint constructionbudget_PKC primary key (ConstructionCode)
-            h-you
+) comment '?H???{?H?\?Z?f?[?^' ;
             h-you
-            h-you
+-- ?H???{?H?\?Z?f?[?^????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionbudgetdetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionbudgetdetail (
-            h-you
+  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'
-            h-you
+  , constraint constructionbudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
-            h-you
+) comment '?H???{?H?\?Z?f?[?^????' ;
             h-you
-            h-you
+-- ?H??}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionitemmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionitemmaster (
-            h-you
+  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'
-            h-you
+  , constraint constructionitemmaster_PKC primary key (ItemCode)
-            h-you
+) comment '?H??}?X?^' ;
             h-you
-            h-you
+-- ?H???????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionledger cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionledger (
-            h-you
+  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'
-            h-you
+  , constraint constructionledger_PKC primary key (ConstructionCode)
-            h-you
+) comment '?H???????f?[?^' ;
             h-you
-            h-you
+create index constructionledger_Index1
   on constructionledger(ConstructionStart);
 create index constructionledger_Index2
   on constructionledger(ConstructionEnd);
-            h-you
+-- ?H??????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionledgerdetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionledgerdetail (
-            h-you
+  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???'
-            h-you
+  , 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 '??????'
-            h-you
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
-            h-you
+) comment '?H??????????f?[?^' ;
             h-you
-            h-you
+create index LedgerDetail_Index01
   on constructionledgerdetail(ConstructionCode);
             h-you
-            h-you
+create index LedgerDetail_Index02
   on constructionledgerdetail(GroupCount);
             h-you
-            h-you
+create index LedgerDetail_Index03
-            h-you
+  on constructionledgerdetail(LineCount);
 create index LedgerDetail_Index04
-            h-you
+  on constructionledgerdetail(SourceCode);
             h-you
-            h-you
+create index LedgerDetail_Index05
   on constructionledgerdetail(DetailCount);
-            h-you
+create index LedgerDetail_Index06
   on constructionledgerdetail(SalaryFlg);
 create index LedgerDetail_Index07
   on constructionledgerdetail(CompanyCode);
-            h-you
+-- ?H?????????s?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionledgerexcute cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionledgerexcute (
-            h-you
+  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???'
-            h-you
+  , 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'
-            h-you
+  , constraint constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)
-            h-you
+) comment '?H?????????s?f?[?^' ;
             h-you
-            h-you
+create index LedgerExcute_Index1
   on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);
             h-you
-            h-you
+-- ?H???????N???
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionlink cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionlink (
-            h-you
+  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'
-            h-you
+  , constraint constructionlink_PKC primary key (ConstructionCode,FluctuationCode)
-            h-you
+) comment '?H???????N???' ;
             h-you
-            h-you
+create index ConstructionLink_Index1
   on constructionlink(ConstructionCode);
             h-you
-            h-you
+create index ConstructionLink_Index2
   on constructionlink(FluctuationCode);
             h-you
-            h-you
+create index ConstructionLink_Index3
   on constructionlink(LinkType);
             h-you
-            h-you
+-- ?H????????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionmaterialinfo cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionmaterialinfo (
-            h-you
+  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'
   , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'
-            h-you
+  , PROCESSDATE datetime default '0000-00-00 00:00:00' not null comment '?????N????'
-            h-you
+  , RENTCOUNT smallint(5) unsigned comment '??o??'
   , REPAYCOUNT smallint(5) unsigned comment '??p??'
-            h-you
+  , JUNKCOUNT smallint(5) unsigned comment '?j????'
-            h-you
+  , COMPLETEFLG tinyint(3) unsigned comment '?????t???O'
   , ENTRYDATE datetime comment '?o?^???t'
   , UPDATEDATE datetime comment '?X?V???t'
-            h-you
+  , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE,PROCESSDATE)
-            h-you
+) comment '?H????????' ;
             h-you
-            h-you
+-- ????i?????t?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionprogressdate cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionprogressdate (
-            h-you
+  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'
-            h-you
+  , constraint constructionprogressdate_PKC primary key (ConstructionCode,ChangeDate)
-            h-you
+) comment '????i?????t?f?[?^' ;
             h-you
-            h-you
+create index ConstrProg_Index1
   on constructionprogressdate(ConstructionCode);
 create index ConstrProg_Index2
   on constructionprogressdate(ConstructionStatusFlg);
 create index ConstrProg_Index3
   on constructionprogressdate(ChangeDate);
-            h-you
+-- ???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionspecmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionspecmaster (
-            h-you
+  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'
-            h-you
+  , constraint constructionspecmaster_PKC primary key (ItemCode,SpecCode)
-            h-you
+) comment '???}?X?^' ;
             h-you
-            h-you
+create index ConstructionSpecMaster_Index1
   on constructionspecmaster(DisplayOrder);
             h-you
-            h-you
+-- ???P???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructionspecunitprice cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructionspecunitprice (
-            h-you
+  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
   , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
   , SpecCode decimal(5,0) unsigned not null comment '???L?['
   , ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h'
   , UnitPrice decimal(9,2) not null comment '?P??'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint constructionspecunitprice_PKC primary key (ComponentCode,ItemCode,SpecCode,ConstructionTypeCode)
-            h-you
+) comment '???P???}?X?^' ;
             h-you
-            h-you
+-- ?H?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists constructiontypemaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table constructiontypemaster (
-            h-you
+  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 '????'
-            h-you
+  , PublicFlg decimal(1,0) not null comment '?????t???O'
   , RepairFlg decimal(1,0) not null comment '?V?z?E???C?t???O'
-            h-you
+  , SecRank decimal(1,0) not null comment '?????????N'
   , ExpensesLink decimal(1,0) not null comment '?o??g?p??'
   , DeleteFlg decimal(1,0) not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint constructiontypemaster_PKC primary key (TypeCode)
-            h-you
+) comment '?H?????}?X?^' ;
             h-you
-            h-you
+-- ?????o?[?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists costdataofdepartment cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+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?[?^' ;
-            h-you
+-- ?S??????o??f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists costdataofperson cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table costdataofperson (
-            h-you
+  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'
-            h-you
+  , constraint costdataofperson_PKC primary key (PersonCode,ActionDate,DataType,DataAddCount)
-            h-you
+) comment '?S??????o??f?[?^' ;
             h-you
-            h-you
+create index CostDataOfPerson_Index1
   on costdataofperson(TargetMonth);
             h-you
-            h-you
+create index CostDataOfPerson_Index2
   on costdataofperson(ConstructionCode);
             h-you
-            h-you
+-- ??????o?^?\???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists costomerregist cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table costomerregist (
-            h-you
+  CreatePersonCode decimal(8,0) unsigned not null comment '?\??????'
-            h-you
+  , 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 '??????'
-            h-you
+  , PersonName varchar(60) comment '?S?????'
-            h-you
+  , ZipCode varchar(8) comment '?X????'
   , Address1 varchar(60) comment '?Z???P'
   , Address2 varchar(60) comment '?Z??2'
   , Address3 varchar(60) comment '?Z??3'
   , PhoneNumber varchar(13) comment '?d?b???'
   , FaxNumber varchar(13) comment 'FAX???'
   , MailAddress varchar(257) comment '???[???A?h???X'
   , Note varchar(300) comment '???l'
   , OrderCotegory decimal(5,0) unsigned not null comment '???????'
   , OrderDate date not null comment '?\????'
   , OrderNo decimal(2,0) unsigned not null comment '?\????t???'
-            h-you
+  , CreateDepartmentCode decimal(5,0) unsigned not null comment '?\???????R?[?h'
   , CreateDepartmentName varchar(60) comment '?\????????'
-            h-you
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint costomerregist_PKC primary key (CreatePersonCode,CreateDate,SeqNo)
-            h-you
+) comment '??????o?^?\???f?[?^' ;
             h-you
-            h-you
+create index CostomerRegist_Index1
   on costomerregist(PetitionPeriod);
             h-you
-            h-you
+create index CostomerRegist_Index2
   on costomerregist(CreatePersonCode);
 create index CostomerRegist_Index3
   on costomerregist(CreateDepartmentCode);
-            h-you
+-- ????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists dailydataconstruction cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table dailydataconstruction (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , DailyDataDate date not null comment '???????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , Weather varchar(60) comment '?V?C'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydataconstruction_PKC primary key (PersonCode,DailyDataDate,ConstructionCode)
-            h-you
+) comment '????f?[?^' ;
             h-you
-            h-you
+create index DailyDataConstruction_Index1
   on dailydataconstruction(PersonCode);
             h-you
-            h-you
+create index DailyDataConstruction_Index2
   on dailydataconstruction(DailyDataDate);
             h-you
-            h-you
+create index DailyDataConstruction_Index3
   on dailydataconstruction(ConstructionCode);
             h-you
-            h-you
+-- ????f?[?^ (????)
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists dailydatadetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table dailydatadetail (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , DailyDataDate date not null comment '???????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , SeqNo decimal(3,0) unsigned not null comment '????s???'
   , JobCategoryCode decimal(5,0) not null comment '?E??L?['
   , CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , TodayHeadCount decimal(4,1) not null comment '?????l????'
   , TotalHeadCount decimal(5,1) not null comment '??v?l????'
   , TodayWork varchar(100) comment '?????????e'
   , NextdayWork varchar(100) comment '?????????e'
   , NextdayHeadCount decimal(4,1) not null comment '?????l????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydatadetail_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
-            h-you
+) comment '????f?[?^ (????)' ;
             h-you
-            h-you
+create index DailyDataDetail_Index
   on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);
             h-you
-            h-you
+-- ????f?[?^ (??????)
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists dailydatafield cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table dailydatafield (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , DailyDataDate date not null comment '???????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , SeqNo decimal(3,0) unsigned not null comment '????s???'
   , PatrolTime datetime not null comment '?????'
   , ContentsText varchar(200) comment '???e'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydatafield_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
-            h-you
+) comment '????f?[?^ (??????)' ;
             h-you
-            h-you
+create index DailyDataField_Index
   on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);
             h-you
-            h-you
+-- ????f?[?^ (????)
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists dailydatamaterials cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table dailydatamaterials (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , DailyDataDate date not null comment '???????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , SeqNo decimal(3,0) unsigned not null comment '????s???'
   , Materials varchar(100) comment '?????'
   , Quantity varchar(100) comment '????'
   , Production varchar(100) comment '??????'
   , Delivery varchar(100) comment '?[?????'
   , QualityControl varchar(100) comment '?i?????????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydatamaterials_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
-            h-you
+) comment '????f?[?^ (????)' ;
             h-you
-            h-you
+create index DailyDataMaterials_Index
   on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);
             h-you
-            h-you
+-- ????f?[?^ (??????w??)
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists dailydatasubcontractors cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table dailydatasubcontractors (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , DailyDataDate date not null comment '???????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , SeqNo decimal(3,0) unsigned not null comment '????s???'
   , Attendee varchar(100) comment '?o???'
   , ContentsText varchar(200) comment '???e'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydatasubcontractors_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
-            h-you
+) comment '????f?[?^ (??????w??)' ;
             h-you
-            h-you
+create index DailyDataSubcontractors_Index
   on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);
             h-you
-            h-you
+-- ????f?[?^ (???)
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists dailydatavehicles cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table dailydatavehicles (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
   , DailyDataDate date not null comment '???????'
   , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , SeqNo decimal(3,0) unsigned not null comment '????s???'
   , Model varchar(100) comment '?@??'
   , Performance varchar(100) comment '???\'
   , Owner varchar(100) comment '???L???'
   , Driver varchar(100) comment '?????^?]??'
   , StartWorkingTime datetime not null comment '??????J?n'
   , EndWorkingTime datetime not null comment '??????I??'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint dailydatavehicles_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)
-            h-you
+) comment '????f?[?^ (???)' ;
             h-you
-            h-you
+create index DailyDataVehicles_Index
   on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);
             h-you
-            h-you
+-- ???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists daymaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table daymaster (
-            h-you
+  days smallint(6) not null comment '??'
-            h-you
+  , constraint daymaster_PKC primary key (days)
-            h-you
+) comment '???}?X?^' ;
             h-you
-            h-you
+-- ?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists deadlinemaster cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table deadlinemaster (
-            h-you
+  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'
-            bit
+  , constraint deadlinemaster_PKC primary key (LABOURKIND)
-            h-you
+) comment '?????}?X?^' ;
             bit
-            h-you
+-- ?????o???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists departmentexpensesmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table departmentexpensesmaster (
-            h-you
+  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'
   , ExpensesPeriod smallint(6) not null comment '?????'
-            h-you
+  , NameCode decimal(5,0) unsigned not null comment '?o??R?[?h'
   , NameString varchar(100) not null comment '????'
-            h-you
+  , 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'
-            h-you
+  , constraint departmentexpensesmaster_PKC primary key (DepartmentCode,ExpensesPeriod,NameCode)
-            h-you
+) comment '?????o???}?X?^' ;
             h-you
-            h-you
+-- ?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists departmentmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table departmentmaster (
-            h-you
+  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'
-            h-you
+  , StartDate datetime not null comment '?J?n???t'
   , CompDate datetime not null comment '?I?????t'
-            h-you
+  , DeleteFlg decimal(1,0) not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint departmentmaster_PKC primary key (DepartmentCode)
-            h-you
+) comment '?????}?X?^' ;
             h-you
 create index DepartmentMaster_index1
   on departmentmaster(DisplayOrder);
-            h-you
+-- ?????m?F???F?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists depositapprovalinfo cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            bit
+create table depositapprovalinfo (
-            h-you
+  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'
-            bit
+  , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
-            h-you
+) comment '?????m?F???F?f?[?^' ;
             bit
-            h-you
+-- ?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists depositdata cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table depositdata (
-            h-you
+  ORDERERSDIVISION decimal(5,0) not null comment '???????'
   , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) not null comment '???N??'
   , SEQNO decimal(3,0) not null comment '?A??'
   , BUSINESSPERIOD decimal(4,0) comment '?c???'
   , DEPOSITDATE date comment '??????'
   , DEPOSITAMOUNT decimal(12,0) comment '???????z'
   , DEPOSITAMOUNTCASH decimal(10,0) comment '???????z?i?????j'
   , DEPOSITAMOUNTBILL decimal(10,0) comment '???????z?i??`?j'
   , DEPOSITPERSONCODE decimal(8,0) not null comment '?????S????R?[?h'
   , NOTE varchar(120) comment '???l'
   , ENTRYDATE datetime comment '?o?^???t'
   , UPDATEDATE datetime comment '?X?V???t'
-            bit
+  , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO)
-            h-you
+) comment '?????f?[?^' ;
             bit
-            h-you
+-- ????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists depositdatadetail cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table depositdatadetail (
-            h-you
+  ORDERERSDIVISION decimal(5,0) not null comment '???????'
   , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) not null comment '???N??'
   , REQUESTNO decimal(10,0) not null comment '????No'
   , ORDERNO decimal(2,0) comment '??t???'
   , DEPOSITAMOUNT decimal(10,0) comment '???????z'
   , DISCOUNTAMOUNT decimal(10,0) comment '?l???????z'
   , CNSTRPRICE decimal(10,0) comment '?????'
   , FEES decimal(10,0) comment '????'
   , OTHERADJUSTMENTS decimal(10,0) comment '?????'
   , DIFFERENCEAMOUNT decimal(10,0) comment '????'
   , CONFIRMATIONPERSONCODE decimal(8,0) comment '?m?F?S????R?[?h'
   , CONFIRMATIONDATE date comment '?S????m?F???t'
   , CONFIRMATIONENDFLG decimal(1,0) comment '?m?F?????t???O'
   , NOTE varchar(120) comment '???l'
   , ENTRYDATE datetime comment '?o?^???t'
   , UPDATEDATE datetime comment '?X?V???t'
-            bit
+  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO)
-            h-you
+) comment '????????f?[?^' ;
             bit
-            h-you
+-- ???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists divisionmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table divisionmaster (
-            h-you
+  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'
-            h-you
+  , constraint divisionmaster_PKC primary key (DivisionCode,NameCode)
-            h-you
+) comment '???}?X?^' ;
             h-you
-            h-you
+-- ??Z?\?Z???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists estimatebudget cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table estimatebudget (
-            h-you
+  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'
-            h-you
+  , constraint estimatebudget_PKC primary key (ConstructionCode)
-            h-you
+) comment '??Z?\?Z???f?[?^' ;
             h-you
-            h-you
+-- ??Z?\?Z????f?[?^????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists estimatebudgetdetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table estimatebudgetdetail (
-            h-you
+  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'
-            h-you
+  , constraint estimatebudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
-            h-you
+) comment '??Z?\?Z????f?[?^????' ;
             h-you
-            h-you
+-- ??Z????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists estimatedata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table estimatedata (
-            h-you
+  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'
-            h-you
+  , constraint estimatedata_PKC primary key (ConstructionCode,LineCount)
-            h-you
+) comment '??Z????f?[?^' ;
             h-you
 create index EstimateData_Index1
   on estimatedata(ConstructionCode,FixedItemCode);
-            h-you
+-- ??Z????y?[?W?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists estimatedatabody cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table estimatedatabody (
-            h-you
+  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'
-            h-you
+  , constraint estimatedatabody_PKC primary key (ConstructionCode,PageCount)
-            h-you
+) comment '??Z????y?[?W?f?[?^' ;
             h-you
 create index EstimateDataBody_Index1
   on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);
-            h-you
+-- ??Z????f?[?^????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists estimatedatadetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table estimatedatadetail (
-            h-you
+  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
   , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'
   , LineCount decimal(3,0) unsigned not null comment '?s???'
   , DataType decimal(1,0) not null comment '?f?[?^???'
   , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
   , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
   , SpecCode decimal(5,0) unsigned not null comment '???L?['
   , ItemName varchar(120) comment '??????'
   , SpecName varchar(120) comment '???^?i???E?`??E???@'
   , Unitcount decimal(8,2) not null comment '????'
   , UnitName varchar(30) comment '?P?????'
   , UnitPrice decimal(9,2) not null comment '?P??'
   , LineTotal decimal(12,0) not null comment '???z'
   , note varchar(60) comment '???l'
   , CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'
   , InputFlg decimal(1,0) comment '????t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint estimatedatadetail_PKC primary key (ConstructionCode,PageCount,LineCount)
-            h-you
+) comment '??Z????f?[?^????' ;
             h-you
 create index EstimateDataDetail_Index1
   on estimatedatadetail(ConstructionCode,PageCount);
-            h-you
+-- ?o???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists expensesmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table expensesmaster (
-            h-you
+  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'
-            h-you
+  , constraint expensesmaster_PKC primary key (DivisionCode,NameCode)
-            h-you
+) comment '?o???}?X?^' ;
             h-you
-            h-you
+-- ???x???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists holidaycalendermaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table holidaycalendermaster (
-            h-you
+  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????'
-            h-you
+  , constraint holidaycalendermaster_PKC primary key (Holiday)
-            h-you
+) comment '???x???}?X?^' ;
             h-you
 create index HolidayCalender_Index1
   on holidaycalendermaster(BusinessYear);
 create index HolidayCalenderMaster_Index2
   on holidaycalendermaster(TargetMonth);
 create index HolidayCalenderMaster_Index3
   on holidaycalendermaster(TargetDay);
-            h-you
+-- ?????????????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists inputsearchlogdata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table inputsearchlogdata (
-            h-you
+  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'
-            h-you
+  , constraint inputsearchlogdata_PKC primary key (ConstructionCode,UsedProcessNo,DisplayOrder)
-            h-you
+) comment '?????????????' ;
             h-you
 create index InputSearchLogData_Index1
   on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
-            h-you
+-- ???????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists invoicedata cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table invoicedata (
-            h-you
+  INVOICENO decimal(9,0) not null comment '??????No'
   , ORDERERSDIVISION decimal(5,0) not null comment '???????'
   , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'
   , REQUESTMONTH decimal(6,0) not null comment '??????'
   , SEQNO decimal(2,0) not null comment '?A??'
   , CRETATEDATE date not null comment '????'
   , REQUESTDATE date not null comment '??????'
   , REQUESTNAME varchar(120) comment '??????'
   , TOTALAMOUNT decimal(10,0) comment '???????v???z'
   , TAXAMOUNT decimal(10,0) comment '???????z'
   , COMMENT1 varchar(60) comment '?R?????g1'
   , COMMENT2 varchar(60) comment '?R?????g2'
   , COMMENT3 varchar(60) not null comment '?R?????g3'
   , COMMENT4 varchar(60) not null comment '?R?????g4'
   , COMMENT5 varchar(60) not null comment '?R?????g5'
   , COMPLETEFLG decimal(1,0) default '0' not null comment '?????t???O'
   , ENTRYDATE datetime not null comment '?o?^?N????'
   , UPDATEDATE datetime not null comment '?X?V?N????'
-            bit
+  , constraint invoicedata_PKC primary key (INVOICENO)
-            h-you
+) comment '???????f?[?^' ;
             bit
 alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
-            h-you
+-- ??????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists materialinfo cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table materialinfo (
-            h-you
+  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'
-            bit
+  , constraint materialinfo_PKC primary key (MATERIALITEMCODE)
-            h-you
+) comment '??????' ;
             bit
-            h-you
+-- ????i??}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists materialitemmaster cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table materialitemmaster (
-            h-you
+  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???????'
-            bit
+  , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE)
-            h-you
+) comment '????i??}?X?^' ;
             bit
-            h-you
+-- ??????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists materialkindmaster cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table materialkindmaster (
-            h-you
+  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'
-            bit
+  , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE)
-            h-you
+) comment '??????}?X?^' ;
             bit
-            h-you
+-- ??????????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists materialrecordinfo cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table materialrecordinfo (
-            h-you
+  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'
-            bit
+  , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO)
-            h-you
+) comment '??????????' ;
             bit
-            h-you
+-- ?f??????b?Z?[?W
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists messageboarddata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table messageboarddata (
-            h-you
+  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'
-            h-you
+  , constraint messageboarddata_PKC primary key (RecordNumber,BranchNumber)
-            h-you
+) comment '?f??????b?Z?[?W' ;
             h-you
 create index MessageBoardData_Index1
   on messageboarddata(WritingDate);
 create index MessageBoardData_Index2
   on messageboarddata(MessageFlag);
-            h-you
+-- ?f???????e?[?u??
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists messageboardterget cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table messageboardterget (
-            h-you
+  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'
-            h-you
+  , constraint messageboardterget_PKC primary key (RecordNumber,BranchNumber,SeqNum)
-            h-you
+) comment '?f???????e?[?u??' ;
             h-you
 create index MessageBoardTerget_Index1
   on messageboardterget(RecordNumber,BranchNumber);
-            h-you
+-- ?f??????b?Z?[?W?{??????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists messagebrowsinghistory cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table messagebrowsinghistory (
-            h-you
+  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'
-            h-you
+  , constraint messagebrowsinghistory_PKC primary key (RecordNumber,BranchNumber,SeqNum)
-            h-you
+) comment '?f??????b?Z?[?W?{??????' ;
             h-you
-            h-you
+-- ???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists monthmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table monthmaster (
-            h-you
+  month smallint(6) not null comment '??'
-            h-you
+  , constraint monthmaster_PKC primary key (month)
-            h-you
+) comment '???}?X?^' ;
             h-you
-            h-you
+-- ??????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists orderersmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table orderersmaster (
-            h-you
+  OrderCotegory decimal(5,0) unsigned not null comment '???????'
   , OrderersCode decimal(5,0) unsigned not null comment '??????R?[?h'
   , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
   , OrderFlg decimal(1,0) not null comment '?@?l?c??E??l?t???O'
   , CorporateStatusName varchar(100) comment '?@?l?i????'
   , CorporateStatusPoint decimal(1,0) comment '?@?l?i?????u'
   , OrderersName1 varchar(60) not null comment '???????1'
   , OrderersName2 varchar(60) comment '????????Q'
   , DepartmentName varchar(60) comment '??????'
   , ChargePersonName varchar(60) comment '?S?????'
   , ZipCode varchar(8) comment '?X????'
   , Address1 varchar(60) comment '?Z???P'
   , Address2 varchar(60) comment '?Z??2'
   , Address3 varchar(60) comment '?Z??3'
   , PhoneNumber varchar(13) comment '?d?b???'
   , FaxNumber varchar(13) comment 'FAX???'
   , MailAddress varchar(257) comment '???[???A?h???X'
   , Note varchar(300) comment '???l'
   , DeleteFlg decimal(1,0) not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint orderersmaster_PKC primary key (OrderCotegory,OrderersCode)
-            h-you
+) comment '??????}?X?^' ;
             h-you
-            h-you
+-- ????z?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists orderspricedata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table orderspricedata (
-            h-you
+  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'
-            h-you
+  , constraint orderspricedata_PKC primary key (ConstructionCode,ChangeNo)
-            h-you
+) comment '????z?f?[?^' ;
             h-you
-            h-you
+-- ?x?????F???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists paymentapprovalinfo cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table paymentapprovalinfo (
-            h-you
+  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'
-            bit
+  , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
-            h-you
+) comment '?x?????F???f?[?^' ;
             bit
-            h-you
+-- ?x??????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists paymentdatadetail cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table paymentdatadetail (
-            h-you
+  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
   , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
   , SEQNO decimal(3,0) default '0' not null comment '?A??'
   , LINECOUNT decimal(3,0) default '0' not null comment '?s???'
   , BILLPRICE decimal(10,0) comment '???????z'
   , DISCOUNTPRICE decimal(10,0) comment '?l???????z'
   , OFFSETPRICE decimal(10,0) comment '???E???z'
   , NEXTCOPRICE decimal(10,0) comment '????J?z'
   , HIGHWPRICE decimal(10,0) comment '??????'
   , HARDWPRICE decimal(10,0) comment '??????'
   , INDSWASTETAX decimal(10,0) comment '?Y?p??'
   , CNSTRPRICE decimal(10,0) comment '?????'
   , CNSTRPRICEEXIST decimal(1,0) comment '??????L??'
   , APPROVALPERSONCODE decimal(8,0) comment '???F?S????R?[?h'
   , APPROVALDATE date comment '?S??????F???t'
   , APPROVALENDFLG decimal(1,0) comment '???F?????t???O'
   , ENTRYDATE datetime comment '?o?^???t'
   , UPDATEDATE datetime comment '?X?V???t'
-            bit
+  , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
-            h-you
+) comment '?x??????f?[?^' ;
             bit
-            h-you
+create index PayDataDetail_Index1
   on paymentdatadetail(TARGETDATE);
 create index PayDataDetail_Index2
   on paymentdatadetail(APPROVALPERSONCODE);
-            h-you
+-- ?H??????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists periodavoidance cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+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);
-            h-you
+-- ?S??????F?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists personapproval cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table personapproval (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
   , OrderDate date not null comment '??t??'
   , OrderNo decimal(2,0) unsigned not null comment '??t???'
   , SeqNo decimal(2,0) not null comment '?}??'
   , PersonCodeApproval decimal(8,0) unsigned not null comment '?\???E???F??R?[?h'
   , PetitionApprovalDate datetime not null comment '?\???E???F???t'
   , ApprovalLimitDates datetime not null comment '???F??]??'
   , ApprovalStatus decimal(1,0) not null comment '???F???'
   , InputComment varchar(300) comment '?R?????g'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint personapproval_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,SeqNo)
-            h-you
+) comment '?S??????F?f?[?^' ;
             h-you
-            h-you
+-- ?S??????F?R?????g?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists personapprovalcomment cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table personapprovalcomment (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
   , OrderDate date not null comment '??t??'
   , OrderNo decimal(2,0) unsigned not null comment '??t???'
   , CommentNo decimal(2,0) not null comment '?R?????g???'
   , ParentNo decimal(2,0) not null comment '?e?R?????g???'
   , ApproValComment varchar(300) comment '?w???E?A???R?????g'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint personapprovalcomment_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,CommentNo)
-            h-you
+) comment '?S??????F?R?????g?f?[?^' ;
             h-you
-            h-you
+-- ?S??????????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists persondepartmentmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table persondepartmentmaster (
-            h-you
+  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'
-            h-you
+  , constraint persondepartmentmaster_PKC primary key (PersonCode,DepartmentCode)
-            h-you
+) comment '?S??????????}?X?^' ;
             h-you
 create index PersonDepartmentMaster_Index1
   on persondepartmentmaster(PersonCode);
 create index PersonDepartmentMaster_Index2
   on persondepartmentmaster(DepartmentCode);
-            h-you
+-- ?S????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists personinchargemaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table personinchargemaster (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
   , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
   , PersonName varchar(60) not null comment '?S?????'
   , StartDate date not null comment '?g?p?J?n?N????'
   , EndDate date comment '?g?p?I???N????'
   , PassWord varchar(16) comment '?p?X???[?h'
   , SecurityManagement decimal(1,0) not null comment '?@????'
   , SecCode decimal(2,0) unsigned not null comment '???????'
   , MsgBackColor varchar(8) comment '???b?Z?[?W?w?i?F'
   , DisplayString varchar(20) comment '?\???E???????'
   , DepartmentCode decimal(5,0) unsigned comment '?????R?[?h'
   , MonthlySalary decimal(11,0) not null comment '???????z'
   , YearSalary decimal(12,0) not null comment '?N????z'
   , Qualification varchar(120) comment '???i?????'
   , SealPrintName varchar(5) comment '???\????'
   , EmployeeClassFlg decimal(1,0) not null comment '?????'
   , LedgerFlg decimal(1,0) not null comment '???v?Z???t???O'
   , CommutingDistance decimal(5,2) not null comment '??????'
   , CommuteCosts decimal(5,0) not null comment '??????'
   , DeleteFlg decimal(1,0) not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint personinchargemaster_PKC primary key (PersonCode)
-            h-you
+) comment '?S????}?X?^' ;
             h-you
 create index PersonInChargeMaster_Index1
   on personinchargemaster(StartDate);
 create index PersonInChargeMaster_Index2
   on personinchargemaster(DepartmentCode);
-            h-you
+-- ?S??????^?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists personsalarymaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table personsalarymaster (
-            h-you
+  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'
-            h-you
+  , constraint personsalarymaster_PKC primary key (PersonCode,StartDate)
-            h-you
+) comment '?S??????^?}?X?^' ;
             h-you
 create index PersonSalaryMaster_Index1
   on personsalarymaster(PersonCode);
 create index PersonSalaryMaster_Index2
   on personsalarymaster(StartDate);
-            h-you
+create index PersonSalaryMaster_Index3
   on personsalarymaster(MonthlySalary);
-            h-you
+-- ?w???????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists pointingoutcomment cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table pointingoutcomment (
-            h-you
+  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'
-            h-you
+  , constraint pointingoutcomment_PKC primary key (ConstructionCode,ProcessNo,SeqNo)
-            h-you
+) comment '?w???????f?[?^' ;
             h-you
-            h-you
+-- ?????????????c???^?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists proceedingsdata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table proceedingsdata (
-            h-you
+  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'
-            h-you
+  , constraint proceedingsdata_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime)
-            h-you
+) comment '?????????????c???^?f?[?^' ;
             h-you
-            h-you
+-- ?????????????c???^?f?[?^?i?o???j
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists proceedingsdataattend cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table proceedingsdataattend (
-            h-you
+  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'
-            h-you
+  , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
-            h-you
+) comment '?????????????c???^?f?[?^?i?o???j' ;
             h-you
-            h-you
+-- ?????????????c???^?f?[?^?i????j
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists proceedingsdatadetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table proceedingsdatadetail (
-            h-you
+  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'
-            h-you
+  , constraint proceedingsdatadetail_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
-            h-you
+) comment '?????????????c???^?f?[?^?i????j' ;
             h-you
-            h-you
+-- ???F?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists processapproval cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table processapproval (
-            h-you
+  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'
-            h-you
+  , constraint processapproval_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SeqNo)
-            h-you
+) comment '???F?f?[?^' ;
             h-you
-            h-you
+-- ???F?R?????g?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists processapprovalcomment cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table processapprovalcomment (
-            h-you
+  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'
-            h-you
+  , constraint processapprovalcomment_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,CommentNo)
-            h-you
+) comment '???F?R?????g?f?[?^' ;
             h-you
-            h-you
+-- ???F????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists processapprovaldetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table processapprovaldetail (
-            h-you
+  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'
-            h-you
+  , constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo)
-            h-you
+) comment '???F????f?[?^' ;
             h-you
-            h-you
+-- ?N?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists processexcutemaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table processexcutemaster (
-            h-you
+  SecCode decimal(2,0) unsigned not null comment '???????'
   , ExecCode decimal(4,0) unsigned not null comment '?N?????????'
   , EditFlg decimal(1,0) not null comment '??W?t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint processexcutemaster_PKC primary key (SecCode,ExecCode)
-            h-you
+) comment '?N?????}?X?^' ;
             h-you
 create index ProcessExcuteMaster_Index1
   on processexcutemaster(SecCode);
 create index ProcessExcuteMaster_Index2
   on processexcutemaster(ExecCode);
-            h-you
+-- ???????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists purchaseorder cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table purchaseorder (
-            h-you
+  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'
-            h-you
+  , LeadEngineerName varchar(60) comment '??C?Z?p???'
-            h-you
+  , SafetyOfficerCode decimal(8,0) comment '???S?????R?[?h'
   , SafetyOfficerName varchar(60) comment '???S??????'
   , WorkersCount decimal(3,0) unsigned comment '??????'
   , PrintoutDate date not null comment '????N????'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)
-            h-you
+) comment '???????f?[?^' ;
             h-you
-            h-you
+-- ?????????t?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists purchaseorderdate cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table purchaseorderdate (
-            h-you
+  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'
-            h-you
+  , constraint purchaseorderdate_PKC primary key (ConstructionCode,SeqNo)
-            h-you
+) comment '?????????t?f?[?^' ;
             h-you
-            h-you
+-- ??????????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists purchaseorderdetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table purchaseorderdetail (
-            h-you
+  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'
-            h-you
+  , 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'
-            h-you
+  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'
-            h-you
+  , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)
-            h-you
+) comment '??????????f?[?^' ;
             h-you
 create index POrderDetail_Index1
   on purchaseorderdetail(SourceCode);
-            h-you
+-- ???R?[?h??????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists recordkey cascade;
-            h-you
+--* RestoreFromTempTable
-            h-you
+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??????' ;
-            h-you
+-- ?????????f?[?^
 --* BackupToTempTable
 drop table if exists reminvoicedata cascade;
 --* RestoreFromTempTable
 create table reminvoicedata (
   InvoiceNo decimal(9,0) not null comment '??????No'
   , RemPerson decimal(8,0) not null comment '???S????R?[?h'
   , RemDate date not null comment '?????t'
   , RemComment varchar(300) comment '?????R'
   , EntryDate datetime not null comment '?o?^?N????'
   , UpdateDate datetime not null comment '?X?V?N????'
   , constraint reminvoicedata_PKC primary key (InvoiceNo)
 ) comment '?????????f?[?^' ;
 -- ????????????f?[?^
 --* BackupToTempTable
 drop table if exists reminvoicedatadetail cascade;
 --* RestoreFromTempTable
 create table reminvoicedatadetail (
   InvoiceNo decimal(9,0) not null comment '??????No'
   , SeqNo smallint(5) unsigned not null comment '?A??'
   , RequestNo decimal(9,0) not null comment '????No'
   , EntryDate datetime not null comment '?o?^?N????'
   , UpdateDate datetime not null comment '?X?V?N????'
   , constraint reminvoicedatadetail_PKC primary key (InvoiceNo,SeqNo)
 ) comment '????????????f?[?^' ;
-            h-you
+-- ?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists requestdata cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table requestdata (
-            h-you
+  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????'
-            bit
+  , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE)
-            h-you
+) comment '?????f?[?^' ;
             bit
-            h-you
+-- ?????f?[?^????
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists requestdatadetail cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table requestdatadetail (
-            h-you
+  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????'
-            bit
+  , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND)
-            h-you
+) comment '?????f?[?^????' ;
             bit
-            h-you
+-- ?????w?b?_
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists requesthead cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            bit
+create table requesthead (
-            h-you
+  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????'
-            bit
+  , constraint requesthead_PKC primary key (REQUESTNO)
-            h-you
+) comment '?????w?b?_' ;
             bit
 alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
-            h-you
+-- ?????????t?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists requestorderdate cascade;
             bit
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table requestorderdate (
-            h-you
+  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'
-            h-you
+  , constraint requestorderdate_PKC primary key (ConstructionCode,InvoiceNo)
-            h-you
+) comment '?????????t?f?[?^' ;
             bit
-            h-you
+-- ????O???t?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists salesgraphdata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table salesgraphdata (
-            h-you
+  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'
-            h-you
+  , constraint salesgraphdata_PKC primary key (GraphDataCode,ConstructionPeriod,SalesDataDays)
-            h-you
+) comment '????O???t?f?[?^' ;
             h-you
 create index SalesGraphData_Idx1
   on salesgraphdata(DisplayOrder);
 create index SalesGraphData_idx2
   on salesgraphdata(ConstructionPeriod);
-            h-you
+-- ?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists securitymaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table securitymaster (
-            h-you
+  SecCode decimal(2,0) unsigned not null comment '???????'
   , DisplayOrder decimal(2,0) not null comment '?\????'
   , SecName varchar(60) not null comment '????????'
   , SecRank decimal(1,0) not null comment '?????????N'
   , SecRange decimal(1,0) not null comment '???????'
   , GeneralAffairs decimal(1,0) not null comment '????????t???O'
   , SelectBackColor varchar(8) not null comment '?I??w?i?F'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint securitymaster_PKC primary key (SecCode)
-            h-you
+) comment '?????}?X?^' ;
             h-you
 create index SecurityMaster_Index1
   on securitymaster(DisplayOrder);
 create index SecurityMaster_Index2
   on securitymaster(SecRank);
 create index SecurityMaster_Index3
   on securitymaster(SecRange);
-            h-you
+-- ???S?p?g???[???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists sfpdata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table sfpdata (
-            h-you
+  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'
-            h-you
+  , constraint sfpdata_PKC primary key (ConstructionCode,DataCount)
-            h-you
+) comment '???S?p?g???[???f?[?^' ;
             h-you
 create index SFPData_Index1
   on sfpdata(RequestDate);
-            h-you
+-- ???S?p?g???[??????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists sfpdatadetail cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table sfpdatadetail (
-            h-you
+  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'
-            h-you
+  , constraint sfpdatadetail_PKC primary key (ConstructionCode,DataCount,SeqNo)
-            h-you
+) comment '???S?p?g???[??????f?[?^' ;
             h-you
-            h-you
+-- ??????{?H?H??o?^?\???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subconstrjobitemregist cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subconstrjobitemregist (
-            h-you
+  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'
-            h-you
+  , constraint subconstrjobitemregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)
-            h-you
+) comment '??????{?H?H??o?^?\???f?[?^' ;
             h-you
-            h-you
+-- ??????E?????N?o?^?\???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subconstrjoblinkregist cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subconstrjoblinkregist (
-            h-you
+  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'
-            h-you
+  , constraint subconstrjoblinkregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)
-            h-you
+) comment '??????E?????N?o?^?\???f?[?^' ;
             h-you
-            h-you
+-- ??????o?^?\???f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subconstrregist cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subconstrregist (
-            h-you
+  PersonCode decimal(8,0) unsigned not null comment '?\??????'
   , CreateDate date not null comment '????'
   , SeqNo decimal(2,0) unsigned not null comment '?\???A??'
   , DataMode decimal(1,0) comment '?f?[?^??'
   , SourceCode decimal(8,0) not null comment '??????R?[?h'
   , PetitionPeriod decimal(4,0) unsigned not null comment '?\???N?x'
   , CorporateStatusName varchar(40) comment '?@?l?i????'
   , CorporateStatusPoint decimal(1,0) not null comment '?@?l?i?????u'
   , CompanyName varchar(100) not null comment '???????'
   , CEOPositionName varchar(60) comment '??\???E??'
   , CEOName varchar(60) comment '??\?????'
   , ContactPersonName varchar(60) comment '?S???????'
   , ZipCode varchar(8) comment '?X????'
   , Address1 varchar(60) comment '?Z???P'
   , Address2 varchar(60) comment '?Z??2'
   , Address3 varchar(60) comment '?Z??3'
   , CellPhoneNumber varchar(13) comment '?g??d?b???'
   , MailAddress varchar(257) comment '???[???A?h???X'
   , PhoneNumber varchar(13) comment '?d?b???'
   , FaxNumber varchar(13) comment 'FAX???'
   , JapaneseSyllabary varchar(2) comment '50?????'
   , StartDate date not null comment '????J?n?N????'
   , Note varchar(300) comment '???l'
   , labourKind decimal(1,0) not null comment '?x???????E????'
   , OrderDate date comment '?\????'
   , OrderNo decimal(2,0) unsigned not null comment '?\????t???'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint subconstrregist_PKC primary key (PersonCode,CreateDate,SeqNo)
-            h-you
+) comment '??????o?^?\???f?[?^' ;
             h-you
-            h-you
+-- ??????H??}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontractoritemmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontractoritemmaster (
-            h-you
+  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'
-            h-you
+  , constraint subcontractoritemmaster_PKC primary key (ItemCode)
-            h-you
+) comment '??????H??}?X?^' ;
             h-you
-            h-you
+-- ??????E??}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontractorjobcategory cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontractorjobcategory (
-            h-you
+  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'
-            h-you
+  , constraint subcontractorjobcategory_PKC primary key (JobCategoryCode)
-            h-you
+) comment '??????E??}?X?^' ;
             h-you
-            h-you
+-- ??????{?H?H??f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontractorjobitem cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontractorjobitem (
-            h-you
+  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'
-            h-you
+  , constraint subcontractorjobitem_PKC primary key (CompanyCode,ItemCode)
-            h-you
+) comment '??????{?H?H??f?[?^' ;
             h-you
 create index SubContractorJobItem_Index1
   on subcontractorjobitem(CompanyCode);
 create index SubContractorJobItem_Index2
   on subcontractorjobitem(ItemCode);
-            h-you
+-- ??????E?????N?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontractorjoblink cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontractorjoblink (
-            h-you
+  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'
-            h-you
+  , constraint subcontractorjoblink_PKC primary key (CompanyCode,JobCategoryCode)
-            h-you
+) comment '??????E?????N?}?X?^' ;
             h-you
 create index SubContractorJobLink_Index1
   on subcontractorjoblink(CompanyCode);
 create index SubContractorJobLink_Index2
   on subcontractorjoblink(JobCategoryCode);
-            h-you
+-- ??????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists subcontractormaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table subcontractormaster (
-            h-you
+  CompanyCode decimal(8,0) not null comment '??????R?[?h'
   , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
   , CorporateStatusName varchar(40) comment '?@?l?i????'
   , CorporateStatusPoint decimal(1,0) not null comment '?@?l?i?????u'
   , CompanyName varchar(100) not null comment '???????'
   , CEOPositionName varchar(60) comment '??\???E??'
   , CEOName varchar(60) comment '??\?????'
   , ContactPersonName varchar(60) comment '?S???????'
   , ZipCode varchar(8) comment '?X????'
   , Address1 varchar(60) comment '?Z???P'
   , Address2 varchar(60) comment '?Z??2'
   , Address3 varchar(60) comment '?Z??3'
   , CellPhoneNumber varchar(13) comment '?g??d?b???'
   , MailAddress varchar(257) comment '???[???A?h???X'
   , PhoneNumber varchar(13) comment '?d?b???'
   , FaxNumber varchar(13) comment 'FAX???'
   , JapaneseSyllabary varchar(2) comment '50?????'
   , StartDate date not null comment '????J?n?N????'
   , Note varchar(300) comment '???l'
   , labourKind decimal(1,0) not null comment '?x???????E????'
   , DeleteFlg decimal(1,0) default '0' not null comment '???t???O'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint subcontractormaster_PKC primary key (CompanyCode)
-            h-you
+) comment '??????}?X?^' ;
             h-you
 create index SubContractorMaster_Index1
   on subcontractormaster(JapaneseSyllabary);
-            h-you
+-- ?d????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists suppliersmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table suppliersmaster (
-            h-you
+  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'
-            h-you
+  , constraint suppliersmaster_PKC primary key (SuppliersCode)
-            h-you
+) comment '?d????}?X?^' ;
             h-you
-            h-you
+-- ?V?X?e???N???m?F?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists systemexecute cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table systemexecute (
-            h-you
+  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'
-            h-you
+  , constraint systemexecute_PKC primary key (PrimaryCode)
-            h-you
+) comment '?V?X?e???N???m?F?f?[?^' ;
             h-you
-            h-you
+-- ????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists systemmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table systemmaster (
-            h-you
+  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?????'
-            h-you
+  , 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??????'
-            h-you
+  , ConstructionNoBase decimal(1,0) not null comment '?H????????l'
   , SloganString1 varchar(100) comment '?W??1'
   , SloganString2 varchar(100) comment '?W??2'
   , SloganString3 varchar(100) comment '?W??3'
   , EntryDate datetime not null comment '?o?^???t'
   , UpdateDate datetime not null comment '?X?V???t'
-            h-you
+  , constraint systemmaster_PKC primary key (SystemCode)
-            h-you
+) comment '????}?X?^' ;
             h-you
-            h-you
+-- ?????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists termmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table termmaster (
-            h-you
+  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'
-            h-you
+  , constraint termmaster_PKC primary key (ConstructionStatusFlg,FieldNo,SeqNo)
-            h-you
+) comment '?????}?X?^' ;
             h-you
 create index TermMaster_Index1
   on termmaster(DisplayOrder);
-            h-you
+-- ?o?????f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists tranceportdailydata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table tranceportdailydata (
-            h-you
+  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'
-            h-you
+  , constraint tranceportdailydata_PKC primary key (PersonCode,AttendanceDate)
-            h-you
+) comment '?o?????f?[?^' ;
             h-you
 create index TranceportDailyData_Index1
   on tranceportdailydata(AttendanceDate);
-            h-you
+-- ?H?????o???}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists typeexpensesmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table typeexpensesmaster (
-            h-you
+  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'
-            h-you
+  , constraint typeexpensesmaster_PKC primary key (TypeCode,ExpensesPeriod,NameCode)
-            h-you
+) comment '?H?????o???}?X?^' ;
             h-you
-            h-you
+-- ?P??}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists unitmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table unitmaster (
-            h-you
+  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'
-            h-you
+  , constraint unitmaster_PKC primary key (UnitKey)
-            h-you
+) comment '?P??}?X?^' ;
             h-you
 create index UnitMaster_Index1
   on unitmaster(DisplayOrder);
-            h-you
+-- ????}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists vehiclemaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table vehiclemaster (
-            h-you
+  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'
-            h-you
+  , constraint vehiclemaster_PKC primary key (VehicleCode)
-            h-you
+) comment '????}?X?^' ;
             h-you
-            h-you
+-- ????L?^?f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists vehiclerecorddata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table vehiclerecorddata (
-            h-you
+  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'
-            h-you
+  , constraint vehiclerecorddata_PKC primary key (VehicleCode,DivisionCode,SeqNo)
-            h-you
+) comment '????L?^?f?[?^' ;
             h-you
-            h-you
+-- ????\??f?[?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists vehiclescheduledata cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table vehiclescheduledata (
-            h-you
+  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'
-            h-you
+  , constraint vehiclescheduledata_PKC primary key (TargetDate,VehicleCode,MorningAfternoon)
-            h-you
+) comment '????\??f?[?^' ;
             h-you
 create index VehicleScheduleData_Index1
   on vehiclescheduledata(TargetYear);
 create index VehicleScheduleData_Index2
   on vehiclescheduledata(TargetMonth);
 create index VehicleScheduleData_Index3
   on vehiclescheduledata(TargetDay);
-            h-you
+-- ?N?}?X?^
-            h-you
+--* BackupToTempTable
-            h-you
+drop table if exists yearmaster cascade;
             h-you
-            h-you
+--* RestoreFromTempTable
-            h-you
+create table yearmaster (
-            h-you
+  years smallint(6) not null comment '?N'
-            h-you
+  , constraint yearmaster_PKC primary key (years)
-            h-you
+) comment '?N?}?X?^' ;

プロジェクト

全般

プロフィール

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

h-you / branches / ddl / ProcessManagement.sql @ 370