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

-- Project Name : noname

-- Date/Time    : 2018/08/06 8:37:19

-- Author       : Horiuchi

-- RDBMS Type   : MySQL

-- Application  : A5:SQL Mk-2

/*

  BackupToTempTable, RestoreFromTempTable?^????????t????????????B

  ???????Adrop table, create table ????f?[?^???c?????B

  ????@?\????I?? $$TableName ???????e?[?u????????????B

*/

-- ?S????s???\??f?[?^

--* BackupToTempTable

drop table if exists actionscheduledata cascade;

--* RestoreFromTempTable

create table actionscheduledata (

  TargetDate date not null comment '????'

  , PersonCode decimal(8,0) not null comment '?S????R?[?h'

  , ActionSchedule varchar(30) comment '?s???\??'

  , TargetYear year(4) not null comment '?Y???N'

  , TargetMonth year(4) not null comment '?Y????'

  , TargetDay year(4) not null comment '?Y????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint actionscheduledata_PKC primary key (TargetDate,PersonCode)

) comment '?S????s???\??f?[?^' ;

create index ActionScheduleData_Index1

  on actionscheduledata(TargetYear);

create index ActionScheduleData_Index2

  on actionscheduledata(TargetMonth);

create index ActionScheduleData_Index3

  on actionscheduledata(TargetDay);

-- ???F?o?H?}?X?^

--* BackupToTempTable

drop table if exists approvalmaster cascade;

--* RestoreFromTempTable

create table approvalmaster (

  ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , SeqNo decimal(2,0) not null comment '?}??'

  , DisplayOrder decimal(2,0) not null comment '?\????'

  , ApprovalPerson decimal(8,0) unsigned not null comment '???F??R?[?h'

  , ApprovalAuthority decimal(1,0) not null comment '???F??????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint approvalmaster_PKC primary key (ApprovalCode,DepartmentCode,SeqNo)

) comment '???F?o?H?}?X?^' ;

-- ?o?????f?[?^

--* BackupToTempTable

drop table if exists attendancedailydata cascade;

--* RestoreFromTempTable

create table attendancedailydata (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceDate date not null comment '???????'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , ActionResult varchar(30) not null comment '?s??????'

  , StartTime datetime comment '?J?n????'

  , CompTime datetime comment '?I??????'

  , DayTimes decimal(4,1) not null comment '????????v????'

  , WorkingComment varchar(120) comment '?R?????g'

  , WorkKindFlg decimal(1,0) not null comment '?????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)

) comment '?o?????f?[?^' ;

create index AttendDaily_Index1

  on attendancedailydata(ConstructionCode);

create index AttendDaily_Index2

  on attendancedailydata(AttendanceDate);

-- ?o?????f?[?^

--* BackupToTempTable

drop table if exists attendancedata cascade;

--* RestoreFromTempTable

create table attendancedata (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , AttendanceMonth date not null comment '?o?????N??'

  , LastDays decimal(2,0) unsigned not null comment '??????I??'

  , AttendDayCount decimal(2,0) unsigned not null comment '?o?????'

  , TotalOverTimes decimal(4,1) not null comment '?c??????'

  , OrderDate date not null comment '?\????'

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint attendancedata_PKC primary key (PersonCode,AttendanceMonth)

) comment '?o?????f?[?^' ;

-- ??s?c????}?X?^

--* BackupToTempTable

drop table if exists bankbusinessdaymaster cascade;

--* RestoreFromTempTable

create table bankbusinessdaymaster (

  YEARMONTH decimal(6,0) default '0' not null comment '?N??'

  , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '??s?c???'

  , NOTE varchar(120) comment '???l'

  , DELETEFLG decimal(1,0) comment '???t???O'

  , ENTRYDATE datetime comment '?o?^?N????'

  , UPDATEDATE datetime comment '?X?V?N????'

  , constraint bankbusinessdaymaster_PKC primary key (YEARMONTH,BANKBUSINESSDAY)

) comment '??s?c????}?X?^' ;

-- ???????f?[?^

--* BackupToTempTable

drop table if exists billingdata cascade;

--* RestoreFromTempTable

create table billingdata (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

  , BILLPRICE decimal(10,0) comment '???????z'

  , ENTRYDATE datetime comment '?o?^?N????'

  , UPDATEDATE datetime comment '?X?V?N????'

  , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO)

) comment '???????f?[?^' ;

-- ??????????f?[?^

--* BackupToTempTable

drop table if exists billingdatadetail cascade;

--* RestoreFromTempTable

create table billingdatadetail (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

  , LINECOUNT decimal(3,0) default '0' not null comment '?s???'

  , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'

  , CONSTRUCTIONROWCNT decimal(3,0) default '0' not null comment '?s???'

  , CONSTRUCTIONCOLCNT decimal(3,0) default '0' not null comment '????'

  , FIELDNAME varchar(120) comment '????'

  , BILLPRICE decimal(10,0) comment '???????z'

  , HIGHWPRICE decimal(10,0) comment '??????'

  , HARDWPRICE decimal(10,0) comment '??????'

  , INDSWASTETAX decimal(10,0) comment '?Y?p??'

  , NOTE varchar(120) comment '???l'

  , ENTRYDATE datetime comment '?o?^?N????'

  , UPDATEDATE datetime comment '?X?V?N????'

  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)

) comment '??????????f?[?^' ;

-- ???????x???T?}???[?f?[?^

--* BackupToTempTable

drop table if exists billingpaymentsummary cascade;

--* RestoreFromTempTable

create table billingpaymentsummary (

  COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

  , CHARGEPAYMENTKIND decimal(1,0) default '0' not null comment '?????x????'

  , PAYDAY date comment '?x????'

  , BILLPRICESTOTAL decimal(10,0) comment '???????z???v'

  , CONSUMPTIONTAXRATE decimal(6,3) comment '??????'

  , CONSUMPTIONTAXPRICE decimal(10,0) comment '?????z'

  , HIGHWPRICESTOTAL decimal(10,0) comment '???????v'

  , HARDWPRICESTOTAL decimal(10,0) comment '???????v'

  , INDSWASTETAXSTOTAL decimal(10,0) comment '?Y?p????v'

  , CNSTRPRICERATE decimal(6,3) comment '???????'

  , CNSTRPRICESTOTAL decimal(10,0) comment '????????v'

  , BILLINGPRICETOTAL decimal(10,0) comment '???????z???v'

  , ENTRYDATE datetime comment '?o?^?N????'

  , UPDATEDATE datetime comment '?X?V?N????'

  , constraint billingpaymentsummary_PKC primary key (COMPANYCODE,TARGETDATE,CHARGEPAYMENTKIND)

) comment '???????x???T?}???[?f?[?^' ;

-- ?^?c?????????

--* BackupToTempTable

drop table if exists bizperiodhistory cascade;

--* RestoreFromTempTable

create table bizperiodhistory (

  PeriodYear smallint(6) not null comment '?c??????E?H???N?x'

  , PeriodFlag smallint(1) not null comment '?c??????E?H???N?x?t???O'

  , BeginDate datetime not null comment '?????'

  , CompleteDate datetime not null comment '??????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bizperiodhistory_PKC primary key (PeriodYear,PeriodFlag)

) comment '?^?c?????????' ;

-- ?H???????f?[?^?y???p?z

--* BackupToTempTable

drop table if exists bk_constructionledger cascade;

--* RestoreFromTempTable

create table bk_constructionledger (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

  , CreatorCode decimal(8,0) comment '????R?[?h'

  , CreatorName varchar(60) comment '?????'

  , CreateDate date not null comment '????'

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

  , ConstructionStart date not null comment '?_??H???J?n'

  , ConstructionEnd date not null comment '?_??H??????'

  , OrdersDecisionPrice decimal(14,0) not null comment '??????????z'

  , CompanyExpenses decimal(10,0) not null comment '???o???v'

  , DepartmentExpenses decimal(10,0) not null comment '?????o???v'

  , SalesExpenses decimal(10,0) not null comment '?c??o???v'

  , TotalPayment decimal(10,0) not null comment '???x???z'

  , GrossProfit decimal(10,0) not null comment '?e??'

  , Allowance decimal(10,0) not null comment '???^'

  , NetProfit decimal(10,0) not null comment '?????v'

  , ComplateFlg decimal(1,0) not null comment '????????t???O'

  , IntegrationFlg decimal(1,0) not null comment '????z??Z?t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bk_constructionledger_PKC primary key (ConstructionCode)

) comment '?H???????f?[?^?y???p?z' ;

-- ?H??????????f?[?^?y???p?z

--* BackupToTempTable

drop table if exists bk_constructionledgerdetail cascade;

--* RestoreFromTempTable

create table bk_constructionledgerdetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  , LineCount decimal(5,0) unsigned not null comment '?s???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , FirstString varchar(120) comment '???????'

  , SecondString varchar(120) comment '?H?????e'

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , CompanyName varchar(120) comment '?????????'

  , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

  , PaymentBurden decimal(12,0) not null comment '?x????U?z'

  , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'

  , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'

  , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

  , SalaryDays decimal(4,0) not null comment '???^?U??????'

  , OperatingFlg decimal(1,0) not null comment '?S?????t???O'

  , SourceCode decimal(10,0) unsigned not null comment '???H?????'

  , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'

  , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'

  , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bk_constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

) comment '?H??????????f?[?^?y???p?z' ;

-- ?H?????????s?f?[?^?y???p?z

--* BackupToTempTable

drop table if exists bk_constructionledgerexcute cascade;

--* RestoreFromTempTable

create table bk_constructionledgerexcute (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  , LineCount decimal(5,0) unsigned not null comment '?s???'

  , ColumnCount decimal(3,0) not null comment '????'

  , PaymentAmount decimal(12,0) not null comment '?x?????z'

  , TargetMonth date not null comment '???N??'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bk_constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)

) comment '?H?????????s?f?[?^?y???p?z' ;

-- ??Z????f?[?^?y???p?z

--* BackupToTempTable

drop table if exists bk_estimatedata cascade;

--* RestoreFromTempTable

create table bk_estimatedata (

  SaveDate datetime not null comment '?????t'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , FixedItemCode varchar(1) comment '?????L?['

  , ItemName varchar(120) comment '??????'

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

  , PriceValue decimal(14,0) not null comment '???z'

  , note varchar(60) comment '???l'

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

  , InputFlg decimal(1,0) not null comment '????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bk_estimatedata_PKC primary key (SaveDate,ConstructionCode,LineCount)

) comment '??Z????f?[?^?y???p?z' ;

-- ??Z????y?[?W?f?[?^?y???p?z

--* BackupToTempTable

drop table if exists bk_estimatedatabody cascade;

--* RestoreFromTempTable

create table bk_estimatedatabody (

  SaveDate datetime not null comment '?????t'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

  , Category decimal(1,0) not null comment '?y?[?W??'

  , UnionComponentCode decimal(5,0) unsigned not null comment '?????\???L?['

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SelectComponent decimal(5,0) unsigned not null comment '?I???\???L?['

  , PageTitle varchar(120) not null comment '?y?[?W?\????'

  , DetailLineCount decimal(3,0) unsigned not null comment '????s???'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bk_estimatedatabody_PKC primary key (SaveDate,ConstructionCode,PageCount)

) comment '??Z????y?[?W?f?[?^?y???p?z' ;

-- ??Z????f?[?^????y???p?z

--* BackupToTempTable

drop table if exists bk_estimatedatadetail cascade;

--* RestoreFromTempTable

create table bk_estimatedatadetail (

  SaveDate datetime not null comment '?????t'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  , DataType decimal(1,0) not null comment '?f?[?^???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

  , ItemName varchar(120) comment '??????'

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

  , Unitcount decimal(8,2) not null comment '????'

  , UnitName varchar(30) comment '?P?????'

  , UnitPrice decimal(9,2) not null comment '?P??'

  , LineTotal decimal(12,0) not null comment '???z'

  , note varchar(60) comment '???l'

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

  , InputFlg decimal(1,0) comment '????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint bk_estimatedatadetail_PKC primary key (SaveDate,ConstructionCode,PageCount,LineCount)

) comment '??Z????f?[?^????y???p?z' ;

-- ?\?Z???W?v?R?[?h?}?X?^

--* BackupToTempTable

drop table if exists budgetsumcode cascade;

--* RestoreFromTempTable

create table budgetsumcode (

  BlockCode decimal(2,0) unsigned not null comment '?u???b?N???'

  , GroupCode decimal(2,0) unsigned not null comment '?O???[?v???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , ElementsName varchar(100) not null comment '?v?f????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint budgetsumcode_PKC primary key (BlockCode,GroupCode,ComponentCode,ItemCode)

) comment '?\?Z???W?v?R?[?h?}?X?^' ;

-- ?@?l?i?}?X?^

--* BackupToTempTable

drop table if exists businesstypemaster cascade;

--* RestoreFromTempTable

create table businesstypemaster (

  BusinessTypeCode decimal(5,0) unsigned not null comment '?@?l?i?R?[?h'

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , BusinessTypeName varchar(100) not null comment '???'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint businesstypemaster_PKC primary key (BusinessTypeCode)

) comment '?@?l?i?}?X?^' ;

create index BusinessTypeMaster_Index1

  on businesstypemaster(DisplayOrder);

-- ?S????????????f?[?^

--* BackupToTempTable

drop table if exists chgchargedep cascade;

--* RestoreFromTempTable

create table chgchargedep (

  PersonCode decimal(8,0) not null comment '?S????R?[?h'

  , StartDate date not null comment '?J?n?N????'

  , CompDate date not null comment '?I???N????'

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , DepartmentName varchar(60) comment '??????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint chgchargedep_PKC primary key (PersonCode,StartDate)

) comment '?S????????????f?[?^' ;

-- ?H???S????X?????f?[?^

--* BackupToTempTable

drop table if exists chgconstrcharge cascade;

--* RestoreFromTempTable

create table chgconstrcharge (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , Division decimal(1,0) not null comment '????'

  , SeqNo smallint(5) unsigned not null comment '?A??'

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , PersonCode decimal(8,0) not null comment '?S????R?[?h'

  , StartDate date comment '?S???J?n?N????'

  , CompDate date comment '?S???I???N????'

  , SourceCode decimal(10,0) unsigned not null comment '???H???R?[?h'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint chgconstrcharge_PKC primary key (ConstructionCode,Division,SeqNo)

) comment '?H???S????X?????f?[?^' ;

-- ????????}?X?^

--* BackupToTempTable

drop table if exists commoncostlarge cascade;

--* RestoreFromTempTable

create table commoncostlarge (

  LargeCode decimal(5,0) unsigned not null comment '????L?['

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , LargeName varchar(50) not null comment '???????'

  , CommentText varchar(120) comment '????????'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint commoncostlarge_PKC primary key (LargeCode)

) comment '????????}?X?^' ;

-- ?????H???A?}?X?^

--* BackupToTempTable

drop table if exists commoncostlinkms cascade;

--* RestoreFromTempTable

create table commoncostlinkms (

  LargeCode decimal(5,0) unsigned not null comment '????L?['

  , MiddleCode decimal(5,0) unsigned not null comment '??????L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , EntryDate datetime comment '?o?^???t'

  , UpdateDate datetime comment '?X?V???t'

  , constraint commoncostlinkms_PKC primary key (LargeCode,MiddleCode,ItemCode)

) comment '?????H???A?}?X?^' ;

-- ?????????}?X?^

--* BackupToTempTable

drop table if exists commoncostmiddle cascade;

--* RestoreFromTempTable

create table commoncostmiddle (

  LargeCode decimal(5,0) unsigned not null comment '????L?['

  , MiddleCode decimal(5,0) unsigned not null comment '??????L?['

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , MiddleName varchar(50) not null comment '?????????'

  , CommentText varchar(120) comment '????????'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint commoncostmiddle_PKC primary key (LargeCode,MiddleCode)

) comment '?????????}?X?^' ;

-- ?????????L?[?}?X?^

--* BackupToTempTable

drop table if exists commoncostmiddlesearchword cascade;

--* RestoreFromTempTable

create table commoncostmiddlesearchword (

  LargeCode decimal(5,0) unsigned not null comment '????L?['

  , MiddleCode decimal(5,0) unsigned not null comment '??????L?['

  , SeqNo decimal(5,0) unsigned not null comment '????'

  , SearchWord varchar(50) not null comment '????????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint commoncostmiddlesearchword_PKC primary key (LargeCode,MiddleCode,SeqNo)

) comment '?????????L?[?}?X?^' ;

-- ?\???H???A?}?X?^

--* BackupToTempTable

drop table if exists componentlinkmaster cascade;

--* RestoreFromTempTable

create table componentlinkmaster (

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , DisplayOrder decimal(5,0) unsigned comment '?\????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint componentlinkmaster_PKC primary key (ComponentCode,ItemCode)

) comment '?\???H???A?}?X?^' ;

create index ComponentLinkMaster_Index1

  on componentlinkmaster(ComponentCode);

create index ComponentLinkMaster_Index2

  on componentlinkmaster(ItemCode);

-- ?\???}?X?^

--* BackupToTempTable

drop table if exists componentmaster cascade;

--* RestoreFromTempTable

create table componentmaster (

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , ComponentName varchar(120) not null comment '?\??????'

  , SubItemsFlg decimal(1,0) comment '???????t???O'

  , DirectInputFlg decimal(1,0) comment '???????t???O'

  , MyExpensesFlg decimal(1,0) comment '????o??t???O'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint componentmaster_PKC primary key (ComponentCode)

) comment '?\???}?X?^' ;

create index ComponentMaster_Index1

  on componentmaster(DisplayOrder);

-- ?\???H??????A?}?X?^

--* BackupToTempTable

drop table if exists componenttotypemaster cascade;

--* RestoreFromTempTable

create table componenttotypemaster (

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

  , Dummy decimal(1,0) not null comment '?_?~?[????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint componenttotypemaster_PKC primary key (ComponentCode,TypeCode)

) comment '?\???H??????A?}?X?^' ;

create index ComponentToTypeMaster_Index1

  on componenttotypemaster(ComponentCode);

create index ComponentToTypeMaster_Index2

  on componenttotypemaster(TypeCode);

-- ?H???????o??f?[?^

--* BackupToTempTable

drop table if exists constrledgerexpenses cascade;

--* RestoreFromTempTable

create table constrledgerexpenses (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(5,0) not null comment '?}??'

  , NameCode decimal(5,0) unsigned not null comment '?o??R?[?h'

  , ExpensesRaito decimal(4,2) not null comment '?o??'

  , ExpensesValue decimal(10,0) not null comment '?o????z'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constrledgerexpenses_PKC primary key (ConstructionCode,SeqNo,NameCode)

) comment '?H???????o??f?[?^' ;

create index ConstrLedgerExpenses_Index1

  on constrledgerexpenses(ConstructionCode);

create index ConstrLedgerExpenses_Index2

  on constrledgerexpenses(SeqNo);

create index ConstrLedgerExpenses_Index3

  on constrledgerexpenses(NameCode);

-- ?H????{???

--* BackupToTempTable

drop table if exists constructionbaseinfo cascade;

--* RestoreFromTempTable

create table constructionbaseinfo (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , TyingFlg decimal(1,0) not null comment '?R?t?f?[?^?t???O'

  , JoinFlg decimal(1,0) not null comment '?????_??H???t???O'

  , ConstructionYear smallint(5) unsigned not null comment '?H???N?x'

  , ConstructionPeriod smallint(5) unsigned not null comment '?H??????'

  , RequestedDate date comment '??????'

  , EstimatesSubmitDeadline date comment '?????o????'

  , EstimatesSubmittedDate date comment '?????o??'

  , ProvisionalOrderDate date comment '?????'

  , OrderDate date comment '???'

  , OrderStartingDate date comment '?J?n?\???'

  , OrderCompletionDate date comment '?????\???'

  , PreparationStartDate date comment '?{?H?????J?n??'

  , ConstructionStartingDate date comment '?{?H?J?n??'

  , ConstructionCompletionDate date comment '?{?H??????'

  , NonOrderDate date comment '????'

  , OrdersDecisionPrice decimal(12,0) not null comment '??????????z'

  , OrdersDecisionPriceInTax decimal(12,0) not null comment '??????????z'

  , SalesDepCode decimal(5,0) unsigned not null comment '?c??S????????R?[?h'

  , SalesPersonCode decimal(8,0) unsigned not null comment '?c??S????R?[?h'

  , SalesSubDepCode decimal(5,0) unsigned not null comment '?c????S????????R?[?h'

  , SalesSubPersonCode decimal(8,0) unsigned not null comment '?c????S????R?[?h'

  , ConstrDepCode decimal(5,0) unsigned not null comment '?H???S????????R?[?h'

  , ConstructionPersonCode decimal(8,0) not null comment '?H???S????R?[?h'

  , ConstrSubDepCode decimal(5,0) unsigned not null comment '?H?????S????????R?[?h'

  , ConstrSubPersonCode decimal(8,0) not null comment '?H?????S????R?[?h'

  , ConstrInstrDepCode decimal(5,0) unsigned not null comment '?H???w?????????R?[?h'

  , ConstructionInstructor decimal(8,0) not null comment '?H???w?????R?[?h'

  , TransferConstruction decimal(8,0) not null comment '?H??????R?[?h'

  , TransferConstructionDate date comment '?H??????'

  , OrderersDivision decimal(5,0) not null comment '????????R?[?h'

  , OrderersCode decimal(5,0) unsigned not null comment '??????R?[?h'

  , EstimatesExpirationDate date comment '????L??????'

  , ConstructionPeriodStart date comment '?_??H???J?n??'

  , ConstructionPeriodEnd date comment '?_??H??????'

  , ConstructionPeriodStart2 date comment '?_??H???J?n?i???????j'

  , ConstructionPeriodEnd2 date comment '?_??H???????i???????j'

  , StartDate date comment '?H???J?n??'

  , EndDate date comment '?H???I????'

  , PurchaseOrderMailingDate date comment '???????X????'

  , PurchaseOrderReturnDate date comment '???????????'

  , PurchaseOrderReturnCheckDate date comment '??????????m?F??'

  , ConsumptionTaxFlg decimal(1,0) not null comment '?????t???O'

  , PrimeContractorFlg decimal(1,0) not null comment '?????t???O'

  , SalesCostFlg decimal(1,0) not null comment '?c??o?????t???O'

  , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'

  , ConstructionType decimal(5,0) not null comment '?H?????R?[?h'

  , EstimateType decimal(1,0) not null comment '??????'

  , BillingStartDate date not null comment '?????????J?n??'

  , BillingDate date not null comment '??????'

  , BillingSplitFlg decimal(1,0) not null comment '??????t???O'

  , BillingSendDate date comment '???????X??/??n????'

  , LedgerComplateDate date not null comment '?H????????????????t'

  , InspectPlanningDate date not null comment '?????\???'

  , InspectExecuteDate date not null comment '???????s??'

  , RevCompleteDate date not null comment '??????????????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionbaseinfo_PKC primary key (ConstructionCode)

) comment '?H????{???' ;

create index BaseInfo_Index1

  on constructionbaseinfo(ConstructionStatusFlg);

create index BaseInfo_Index2

  on constructionbaseinfo(EstimateType);

create index BaseInfo_Index3

  on constructionbaseinfo(SalesPersonCode);

create index BaseInfo_Index4

  on constructionbaseinfo(ConstructionPersonCode);

create index BaseInfo_Index5

  on constructionbaseinfo(ConstructionInstructor);

create index BaseInfo_Index6

  on constructionbaseinfo(ConstructionPeriod);

-- ?H????{????

--* BackupToTempTable

drop table if exists constructionbaseinfodetail cascade;

--* RestoreFromTempTable

create table constructionbaseinfodetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , DetailNo decimal(3,0) not null comment '??????'

  , DetailString varchar(300) comment '??????e'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionbaseinfodetail_PKC primary key (ConstructionCode,DetailNo)

) comment '?H????{????' ;

create index BaseInfoDetail_Idx1

  on constructionbaseinfodetail(ConstructionCode);

create index BaseInfoDetail_Idx2

  on constructionbaseinfodetail(DetailNo);

-- ?H???{?H?\?Z?f?[?^

--* BackupToTempTable

drop table if exists constructionbudget cascade;

--* RestoreFromTempTable

create table constructionbudget (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , CreatorCode decimal(8,0) not null comment '????R?[?h'

  , CreatorName varchar(60) comment '?????'

  , CreatorCosts decimal(11,0) not null comment '??????^'

  , AssistantCode decimal(8,0) not null comment '???S????R?[?h'

  , AssistantName varchar(60) comment '???S?????'

  , AssistantCosts decimal(11,0) not null comment '???S??????^'

  , InstructorCode decimal(8,0) not null comment '?H???w?????R?[?h'

  , InstructorName varchar(60) comment '?H???w??????'

  , InstructorCosts decimal(11,0) not null comment '?H???w???????^'

  , CreateDate date not null comment '????'

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

  , ConstructionStart date not null comment '?_??H???J?n'

  , ConstructionEnd date not null comment '?_??H??????'

  , InstructorTimes decimal(5,2) not null comment '?w???????????'

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

  , SalaryDays decimal(4,0) not null comment '?U??????'

  , A_SalaryFlg decimal(1,0) not null comment '???S??????^?U????'

  , A_SalaryDays decimal(4,0) not null comment '???S????U??????'

  , I_SalaryFlg decimal(1,0) not null comment '?w???????^?U????'

  , I_SalaryDays decimal(4,0) not null comment '?w?????U??????'

  , OrdersDecisionPrice decimal(12,0) not null comment '??????????z'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionbudget_PKC primary key (ConstructionCode)

) comment '?H???{?H?\?Z?f?[?^' ;

-- ?H???{?H?\?Z?f?[?^????

--* BackupToTempTable

drop table if exists constructionbudgetdetail cascade;

--* RestoreFromTempTable

create table constructionbudgetdetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , FirstString varchar(120) comment '???????'

  , SecondString varchar(120) comment '?H?????e'

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , CompanyName varchar(120) comment '?????????'

  , EstimatePrice decimal(12,0) not null comment '??Z????????z'

  , NegotiationPrice decimal(12,0) not null comment '??Z????????z'

  , OrderDesiredAmount decimal(12,0) not null comment '??????]???z'

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

  , NegotiateFlg decimal(1,0) not null comment '?????????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionbudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

) comment '?H???{?H?\?Z?f?[?^????' ;

-- ?H??}?X?^

--* BackupToTempTable

drop table if exists constructionitemmaster cascade;

--* RestoreFromTempTable

create table constructionitemmaster (

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , ItemName varchar(120) not null comment '?H????'

  , SubItemsFlg decimal(1,0) comment '???????t???O'

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionitemmaster_PKC primary key (ItemCode)

) comment '?H??}?X?^' ;

-- ?H???????f?[?^

--* BackupToTempTable

drop table if exists constructionledger cascade;

--* RestoreFromTempTable

create table constructionledger (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'

  , CreatorCode decimal(8,0) comment '????R?[?h'

  , CreatorName varchar(60) comment '?????'

  , CreateDate date not null comment '????'

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

  , ConstructionStart date not null comment '?_??H???J?n'

  , ConstructionEnd date not null comment '?_??H??????'

  , OrdersDecisionPrice decimal(14,0) not null comment '??????????z'

  , CompanyExpenses decimal(10,0) not null comment '???o???v'

  , DepartmentExpenses decimal(10,0) not null comment '?????o???v'

  , SalesExpenses decimal(10,0) not null comment '?c??o???v'

  , TotalPayment decimal(10,0) not null comment '???x???z'

  , GrossProfit decimal(10,0) not null comment '?e??'

  , Allowance decimal(10,0) not null comment '???^'

  , NetProfit decimal(10,0) not null comment '?????v'

  , ComplateFlg decimal(1,0) not null comment '????????t???O'

  , IntegrationFlg decimal(1,0) not null comment '????z??Z?t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionledger_PKC primary key (ConstructionCode)

) comment '?H???????f?[?^' ;

create index constructionledger_Index1

  on constructionledger(ConstructionStart);

create index constructionledger_Index2

  on constructionledger(ConstructionEnd);

-- ?H??????????f?[?^

--* BackupToTempTable

drop table if exists constructionledgerdetail cascade;

--* RestoreFromTempTable

create table constructionledgerdetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  , LineCount decimal(4,0) unsigned not null comment '?s???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , FirstString varchar(120) comment '???????'

  , SecondString varchar(120) comment '?H?????e'

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , CompanyName varchar(120) comment '?????????'

  , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

  , PaymentBurden decimal(12,0) not null comment '?x????U?z'

  , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'

  , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'

  , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

  , SalaryDays decimal(4,0) not null comment '???^?U??????'

  , OperatingFlg decimal(1,0) not null comment '?S?????t???O'

  , SourceCode decimal(10,0) unsigned not null comment '???H?????'

  , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'

  , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'

  , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'

  , DetailCount decimal(4,0) unsigned not null comment '??????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

) comment '?H??????????f?[?^' ;

create index LedgerDetail_Index01

  on constructionledgerdetail(ConstructionCode);

create index LedgerDetail_Index02

  on constructionledgerdetail(GroupCount);

create index LedgerDetail_Index03

  on constructionledgerdetail(LineCount);

create index LedgerDetail_Index04

  on constructionledgerdetail(SourceCode);

create index LedgerDetail_Index05

  on constructionledgerdetail(DetailCount);

create index LedgerDetail_Index06

  on constructionledgerdetail(SalaryFlg);

create index LedgerDetail_Index07

  on constructionledgerdetail(CompanyCode);

-- ?H?????????s?f?[?^

--* BackupToTempTable

drop table if exists constructionledgerexcute cascade;

--* RestoreFromTempTable

create table constructionledgerexcute (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  , LineCount decimal(4,0) unsigned not null comment '?s???'

  , ColumnCount decimal(3,0) not null comment '????'

  , PaymentAmount decimal(12,0) not null comment '?x?????z'

  , TargetMonth date not null comment '???N??'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionledgerexcute_PKC primary key (ConstructionCode,GroupCount,LineCount,ColumnCount)

) comment '?H?????????s?f?[?^' ;

create index LedgerExcute_Index1

  on constructionledgerexcute(ConstructionCode,TargetMonth,GroupCount,LineCount);

-- ?H???????N???

--* BackupToTempTable

drop table if exists constructionlink cascade;

--* RestoreFromTempTable

create table constructionlink (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , FluctuationCode decimal(10,0) not null comment '?q?H?????'

  , LinkType decimal(1,0) not null comment '?????N???'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionlink_PKC primary key (ConstructionCode,FluctuationCode)

) comment '?H???????N???' ;

create index ConstructionLink_Index1

  on constructionlink(ConstructionCode);

create index ConstructionLink_Index2

  on constructionlink(FluctuationCode);

create index ConstructionLink_Index3

  on constructionlink(LinkType);

-- ?H????????

--* BackupToTempTable

drop table if exists constructionmaterialinfo cascade;

--* RestoreFromTempTable

create table constructionmaterialinfo (

  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'

  , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

  , PROCESSDATE datetime default '0000-00-00 00:00:00' not null comment '?????N????'

  , RENTCOUNT smallint(5) unsigned comment '??o??'

  , REPAYCOUNT smallint(5) unsigned comment '??p??'

  , JUNKCOUNT smallint(5) unsigned comment '?j????'

  , COMPLETEFLG tinyint(3) unsigned comment '?????t???O'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE,PROCESSDATE)

) comment '?H????????' ;

-- ????i?????t?f?[?^

--* BackupToTempTable

drop table if exists constructionprogressdate cascade;

--* RestoreFromTempTable

create table constructionprogressdate (

  ConstructionCode decimal(10,0) not null comment '?H?????'

  , ConstructionStatusFlg decimal(2,0) not null comment '???H?????'

  , PreviousStatusFlg decimal(2,0) comment '??X?O???'

  , ChangeDate datetime not null comment '?????t'

  , ChangePersonCode decimal(8,0) not null comment '???S????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionprogressdate_PKC primary key (ConstructionCode,ChangeDate)

) comment '????i?????t?f?[?^' ;

create index ConstrProg_Index1

  on constructionprogressdate(ConstructionCode);

create index ConstrProg_Index2

  on constructionprogressdate(ConstructionStatusFlg);

create index ConstrProg_Index3

  on constructionprogressdate(ChangeDate);

-- ???}?X?^

--* BackupToTempTable

drop table if exists constructionspecmaster cascade;

--* RestoreFromTempTable

create table constructionspecmaster (

  ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , ItemName varchar(120) comment '??????'

  , SpecName varchar(120) comment '??????'

  , UnitName varchar(30) comment '?P?????'

  , UnitPrice decimal(9,2) not null comment '?P??'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionspecmaster_PKC primary key (ItemCode,SpecCode)

) comment '???}?X?^' ;

create index ConstructionSpecMaster_Index1

  on constructionspecmaster(DisplayOrder);

-- ???P???}?X?^

--* BackupToTempTable

drop table if exists constructionspecunitprice cascade;

--* RestoreFromTempTable

create table constructionspecunitprice (

  ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

  , ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h'

  , UnitPrice decimal(9,2) not null comment '?P??'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionspecunitprice_PKC primary key (ComponentCode,ItemCode,SpecCode,ConstructionTypeCode)

) comment '???P???}?X?^' ;

-- ?H?????}?X?^

--* BackupToTempTable

drop table if exists constructiontypemaster cascade;

--* RestoreFromTempTable

create table constructiontypemaster (

  TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , NameString varchar(100) not null comment '????'

  , PublicFlg decimal(1,0) not null comment '?????t???O'

  , RepairFlg decimal(1,0) not null comment '?V?z?E???C?t???O'

  , SecRank decimal(1,0) not null comment '?????????N'

  , ExpensesLink decimal(1,0) not null comment '?o??g?p??'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructiontypemaster_PKC primary key (TypeCode)

) comment '?H?????}?X?^' ;

-- ?????o?[?f?[?^

--* BackupToTempTable

drop table if exists costdataofdepartment cascade;

--* RestoreFromTempTable

create table costdataofdepartment (

  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , ConstrYear smallint(5) unsigned not null comment '?H???????E?N??'

  , SeqNo decimal(5,0) unsigned not null comment '?f?[?^???'

  , CostDate date not null comment '?????t'

  , DepartmentName varchar(100) not null comment '??????'

  , SuppliersCode decimal(8,0) unsigned not null comment '?o?[??R?[?h'

  , SuppliersName varchar(120) comment '?o?[??'

  , PaymentContent varchar(100) comment '?o?[???e'

  , SendReceiveFlg decimal(1,0) not null comment '?o?[?t???O'

  , EntryPrice decimal(12,0) not null comment '???z?i????j'

  , EntryTax decimal(12,0) not null comment '???z?i????j'

  , Coment varchar(100) comment '???l'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint costdataofdepartment_PKC primary key (DepartmentCode,ConstrYear,SeqNo)

) comment '?????o?[?f?[?^' ;

-- ?S??????o??f?[?^

--* BackupToTempTable

drop table if exists costdataofperson cascade;

--* RestoreFromTempTable

create table costdataofperson (

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

  , ActionDate date not null comment '?????t'

  , DataType decimal(1,0) not null comment '?f?[?^??'

  , DataAddCount decimal(5,0) unsigned not null comment '?f?[?^??????'

  , TargetMonth varchar(7) not null comment '???N??'

  , ConstructionCode decimal(10,0) unsigned comment '?H???R?[?h'

  , SuppliersCode decimal(5,0) unsigned not null comment '?x????R?[?h'

  , SuppliersName varchar(120) comment '?x??????'

  , PaymentContent varchar(60) comment '?x?????e'

  , PaymentType decimal(1,0) not null comment '?x?????@?t???O'

  , EntryPrice decimal(12,0) not null comment '???z?i????j'

  , EntryPriceInTax decimal(12,0) not null comment '???z?i????j'

  , SlipNumber varchar(12) comment '?`?[???'

  , ComplateFlg decimal(1,0) not null comment '???????t???O'

  , ApprovalFlg decimal(1,0) not null comment '???F?t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint costdataofperson_PKC primary key (PersonCode,ActionDate,DataType,DataAddCount)

) comment '?S??????o??f?[?^' ;

create index CostDataOfPerson_Index1

  on costdataofperson(TargetMonth);

create index CostDataOfPerson_Index2

  on costdataofperson(ConstructionCode);

-- ??????o?^?\???f?[?^

--* BackupToTempTable

drop table if exists costomerregist cascade;

--* RestoreFromTempTable

create table costomerregist (

  CreatePersonCode decimal(8,0) unsigned not null comment '?\??????'

  , CreateDate date not null comment '????'

  , SeqNo decimal(2,0) not null comment '?L?[?A??'

  , DataMode decimal(1,0) not null comment '?f?[?^??'

  , SourceCotegory decimal(5,0) unsigned not null comment '???????'

  , SourceCode decimal(5,0) unsigned not null comment '??????R?[?h'

  , PetitionPeriod decimal(4,0) unsigned not null comment '?????'

  , OrderFlg decimal(1,0) not null comment '?@?l?c??E??l?t???O'

  , CorporateStatusName varchar(100) comment '?@?l?i????'

  , CorporateStatusPoint decimal(1,0) comment '?@?l?i?????u'

  , OrderersName1 varchar(60) not null comment '???????1'

  , OrderersName2 varchar(60) comment '????????Q'

  , DepartmentName varchar(60) comment '??????'

  , PersonName varchar(60) comment '?S?????'

  , ZipCode varchar(8) comment '?X????'

  , Address1 varchar(60) comment '?Z???P'

  , Address2 varchar(60) comment '?Z??2'

  , Address3 varchar(60) comment '?Z??3'

  , PhoneNumber varchar(13) comment '?d?b???'

  , FaxNumber varchar(13) comment 'FAX???'

  , MailAddress varchar(257) comment '???[???A?h???X'

  , Note varchar(300) comment '???l'

  , OrderCotegory decimal(5,0) unsigned not null comment '???????'

  , OrderDate date not null comment '?\????'

  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'

  , CreateDepartmentCode decimal(5,0) unsigned not null comment '?\???????R?[?h'

  , CreateDepartmentName varchar(60) comment '?\????????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint costomerregist_PKC primary key (CreatePersonCode,CreateDate,SeqNo)

) comment '??????o?^?\???f?[?^' ;

create index CostomerRegist_Index1

  on costomerregist(PetitionPeriod);

create index CostomerRegist_Index2

  on costomerregist(CreatePersonCode);

create index CostomerRegist_Index3

  on costomerregist(CreateDepartmentCode);

-- ????f?[?^

--* BackupToTempTable

drop table if exists dailydataconstruction cascade;

--* RestoreFromTempTable

create table dailydataconstruction (

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

  , DailyDataDate date not null comment '???????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , Weather varchar(60) comment '?V?C'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint dailydataconstruction_PKC primary key (PersonCode,DailyDataDate,ConstructionCode)

) comment '????f?[?^' ;

create index DailyDataConstruction_Index1

  on dailydataconstruction(PersonCode);

create index DailyDataConstruction_Index2

  on dailydataconstruction(DailyDataDate);

create index DailyDataConstruction_Index3

  on dailydataconstruction(ConstructionCode);

-- ????f?[?^ (????)

--* BackupToTempTable

drop table if exists dailydatadetail cascade;

--* RestoreFromTempTable

create table dailydatadetail (

  PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'

  , DailyDataDate date not null comment '???????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , JobCategoryCode decimal(5,0) not null comment '?E??L?['

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , TodayHeadCount decimal(4,1) not null comment '?????l????'

  , TotalHeadCount decimal(5,1) not null comment '??v?l????'

  , TodayWork varchar(100) comment '?????????e'

  , NextdayWork varchar(100) comment '?????????e'

  , NextdayHeadCount decimal(4,1) not null comment '?????l????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint dailydatadetail_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

) comment '????f?[?^ (????)' ;

create index DailyDataDetail_Index

  on dailydatadetail(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (??????)

--* BackupToTempTable

drop table if exists dailydatafield cascade;

--* RestoreFromTempTable

create table dailydatafield (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , DailyDataDate date not null comment '???????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , PatrolTime datetime not null comment '?????'

  , ContentsText varchar(200) comment '???e'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint dailydatafield_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

) comment '????f?[?^ (??????)' ;

create index DailyDataField_Index

  on dailydatafield(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (????)

--* BackupToTempTable

drop table if exists dailydatamaterials cascade;

--* RestoreFromTempTable

create table dailydatamaterials (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , DailyDataDate date not null comment '???????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , Materials varchar(100) comment '?????'

  , Quantity varchar(100) comment '????'

  , Production varchar(100) comment '??????'

  , Delivery varchar(100) comment '?[?????'

  , QualityControl varchar(100) comment '?i?????????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint dailydatamaterials_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

) comment '????f?[?^ (????)' ;

create index DailyDataMaterials_Index

  on dailydatamaterials(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (??????w??)

--* BackupToTempTable

drop table if exists dailydatasubcontractors cascade;

--* RestoreFromTempTable

create table dailydatasubcontractors (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , DailyDataDate date not null comment '???????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , Attendee varchar(100) comment '?o???'

  , ContentsText varchar(200) comment '???e'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint dailydatasubcontractors_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

) comment '????f?[?^ (??????w??)' ;

create index DailyDataSubcontractors_Index

  on dailydatasubcontractors(PersonCode,DailyDataDate,ConstructionCode);

-- ????f?[?^ (???)

--* BackupToTempTable

drop table if exists dailydatavehicles cascade;

--* RestoreFromTempTable

create table dailydatavehicles (

  PersonCode decimal(8,0) unsigned not null comment '????R?[?h'

  , DailyDataDate date not null comment '???????'

  , ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(3,0) unsigned not null comment '????s???'

  , Model varchar(100) comment '?@??'

  , Performance varchar(100) comment '???\'

  , Owner varchar(100) comment '???L???'

  , Driver varchar(100) comment '?????^?]??'

  , StartWorkingTime datetime not null comment '??????J?n'

  , EndWorkingTime datetime not null comment '??????I??'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint dailydatavehicles_PKC primary key (PersonCode,DailyDataDate,ConstructionCode,SeqNo)

) comment '????f?[?^ (???)' ;

create index DailyDataVehicles_Index

  on dailydatavehicles(PersonCode,DailyDataDate,ConstructionCode);

-- ???}?X?^

--* BackupToTempTable

drop table if exists daymaster cascade;

--* RestoreFromTempTable

create table daymaster (

  days smallint(6) not null comment '??'

  , constraint daymaster_PKC primary key (days)

) comment '???}?X?^' ;

-- ?????}?X?^

--* BackupToTempTable

drop table if exists deadlinemaster cascade;

--* RestoreFromTempTable

create table deadlinemaster (

  LABOURKIND decimal(1,0) default '0' not null comment '??????'

  , DEADLINE decimal(2,0) comment '????'

  , PAYDAY decimal(2,0) comment '?x????'

  , NOTE varchar(120) comment '???l'

  , DELETEFLG decimal(1,0) comment '???t???O'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint deadlinemaster_PKC primary key (LABOURKIND)

) comment '?????}?X?^' ;

-- ?????o???}?X?^

--* BackupToTempTable

drop table if exists departmentexpensesmaster cascade;

--* RestoreFromTempTable

create table departmentexpensesmaster (

  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , ExpensesPeriod smallint(6) not null comment '?????'

  , NameCode decimal(5,0) unsigned not null comment '?o??R?[?h'

  , NameString varchar(100) not null comment '????'

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , ExpensesRaito decimal(4,2) not null comment '?o??'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint departmentexpensesmaster_PKC primary key (DepartmentCode,ExpensesPeriod,NameCode)

) comment '?????o???}?X?^' ;

-- ?????}?X?^

--* BackupToTempTable

drop table if exists departmentmaster cascade;

--* RestoreFromTempTable

create table departmentmaster (

  DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , DepartmentString varchar(100) not null comment '??????'

  , ActionScheduleFlg decimal(1,0) not null comment '?s???\??\???t???O'

  , StaffAssignFlg decimal(1,0) not null comment '?l???z?u?\???t???O'

  , StartDate datetime not null comment '?J?n???t'

  , CompDate datetime not null comment '?I?????t'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint departmentmaster_PKC primary key (DepartmentCode)

) comment '?????}?X?^' ;

create index DepartmentMaster_index1

  on departmentmaster(DisplayOrder);

-- ?????m?F???F?f?[?^

--* BackupToTempTable

drop table if exists depositapprovalinfo cascade;

--* RestoreFromTempTable

create table depositapprovalinfo (

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

  , TARGETDATE decimal(6,0) not null comment '???N??'

  , SEQNO decimal(3,0) not null comment '?A??'

  , LINECOUNT decimal(3,0) not null comment '?s???'

  , APPROVALNO decimal(3,0) not null comment '???F????'

  , APPROVALPERSON decimal(8,0) comment '???F??R?[?h'

  , APPROVALPERSONNAME varchar(20) comment '???F???'

  , APPROVALAUTHORITY decimal(1,0) comment '???F??????'

  , APPROVALDATE date comment '???F???t'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint depositapprovalinfo_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)

) comment '?????m?F???F?f?[?^' ;

-- ?????f?[?^

--* BackupToTempTable

drop table if exists depositdata cascade;

--* RestoreFromTempTable

create table depositdata (

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

  , TARGETDATE decimal(6,0) not null comment '???N??'

  , SEQNO decimal(3,0) not null comment '?A??'

  , BUSINESSPERIOD decimal(4,0) comment '?c???'

  , DEPOSITDATE date comment '??????'

  , DEPOSITAMOUNT decimal(12,0) comment '???????z'

  , DEPOSITAMOUNTCASH decimal(10,0) comment '???????z?i?????j'

  , DEPOSITAMOUNTBILL decimal(10,0) comment '???????z?i??`?j'

  , DEPOSITPERSONCODE decimal(8,0) not null comment '?????S????R?[?h'

  , NOTE varchar(120) comment '???l'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint depositdata_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,SEQNO)

) comment '?????f?[?^' ;

-- ????????f?[?^

--* BackupToTempTable

drop table if exists depositdatadetail cascade;

--* RestoreFromTempTable

create table depositdatadetail (

  ORDERERSDIVISION decimal(5,0) not null comment '???????'

  , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'

  , TARGETDATE decimal(6,0) not null comment '???N??'

  , REQUESTNO decimal(10,0) not null comment '????No'

  , ORDERNO decimal(2,0) comment '??t???'

  , DEPOSITAMOUNT decimal(10,0) comment '???????z'

  , DISCOUNTAMOUNT decimal(10,0) comment '?l???????z'

  , CNSTRPRICE decimal(10,0) comment '?????'

  , FEES decimal(10,0) comment '????'

  , OTHERADJUSTMENTS decimal(10,0) comment '?????'

  , DIFFERENCEAMOUNT decimal(10,0) comment '????'

  , CONFIRMATIONPERSONCODE decimal(8,0) comment '?m?F?S????R?[?h'

  , CONFIRMATIONDATE date comment '?S????m?F???t'

  , CONFIRMATIONENDFLG decimal(1,0) comment '?m?F?????t???O'

  , NOTE varchar(120) comment '???l'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint depositdatadetail_PKC primary key (ORDERERSDIVISION,ORDERERSCODE,TARGETDATE,REQUESTNO)

) comment '????????f?[?^' ;

-- ???}?X?^

--* BackupToTempTable

drop table if exists divisionmaster cascade;

--* RestoreFromTempTable

create table divisionmaster (

  DivisionCode decimal(5,0) unsigned not null comment '???R?[?h'

  , NameCode decimal(5,0) unsigned not null comment '????R?[?h'

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , NameString varchar(100) not null comment '????'

  , DeleteFlg decimal(1,0) not null comment '???t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint divisionmaster_PKC primary key (DivisionCode,NameCode)

) comment '???}?X?^' ;

-- ??Z?\?Z???f?[?^

--* BackupToTempTable

drop table if exists estimatebudget cascade;

--* RestoreFromTempTable

create table estimatebudget (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , ConstructionTime decimal(5,2) unsigned not null comment '?H??'

  , IntegratedCode decimal(8,0) not null comment '??Z??'

  , DataCreateDate datetime not null comment '?f?[?^??????'

  , RetValue1 decimal(12,0) not null comment '?\???i'

  , RetValue2 decimal(12,0) not null comment '????H????'

  , RetValue3 decimal(12,0) not null comment '????????????'

  , RetValue4 decimal(12,0) not null comment '????????????'

  , RetPercent decimal(5,2) not null comment '???????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint estimatebudget_PKC primary key (ConstructionCode)

) comment '??Z?\?Z???f?[?^' ;

-- ??Z?\?Z????f?[?^????

--* BackupToTempTable

drop table if exists estimatebudgetdetail cascade;

--* RestoreFromTempTable

create table estimatebudgetdetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , GroupCount decimal(2,0) unsigned not null comment '?O???[?v???'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned comment '?H??L?['

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , FirstString varchar(120) comment '???????'

  , SecondString varchar(120) comment '?H????E???????'

  , Content varchar(120) comment '???e'

  , EstimatePrice decimal(12,0) not null comment '????????z'

  , NegotiationPrice decimal(12,0) not null comment '????????z'

  , Notes varchar(120) comment '???????'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint estimatebudgetdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

) comment '??Z?\?Z????f?[?^????' ;

-- ??Z????f?[?^

--* BackupToTempTable

drop table if exists estimatedata cascade;

--* RestoreFromTempTable

create table estimatedata (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , FixedItemCode varchar(1) comment '?????L?['

  , ItemName varchar(120) comment '??????'

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

  , PriceValue decimal(14,0) not null comment '???z'

  , note varchar(60) comment '???l'

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

  , InputFlg decimal(1,0) not null comment '????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint estimatedata_PKC primary key (ConstructionCode,LineCount)

) comment '??Z????f?[?^' ;

create index EstimateData_Index1

  on estimatedata(ConstructionCode,FixedItemCode);

-- ??Z????y?[?W?f?[?^

--* BackupToTempTable

drop table if exists estimatedatabody cascade;

--* RestoreFromTempTable

create table estimatedatabody (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

  , Category decimal(1,0) not null comment '?y?[?W??'

  , UnionComponentCode decimal(5,0) unsigned not null comment '?????\???L?['

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SelectComponent decimal(5,0) unsigned not null comment '?I???\???L?['

  , PageTitle varchar(120) not null comment '?y?[?W?\????'

  , DetailLineCount decimal(3,0) unsigned not null comment '????s???'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint estimatedatabody_PKC primary key (ConstructionCode,PageCount)

) comment '??Z????y?[?W?f?[?^' ;

create index EstimateDataBody_Index1

  on estimatedatabody(ConstructionCode,ComponentCode,ItemCode);

-- ??Z????f?[?^????

--* BackupToTempTable

drop table if exists estimatedatadetail cascade;

--* RestoreFromTempTable

create table estimatedatadetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , PageCount decimal(4,0) unsigned not null comment '?y?[?W???'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

  , DataType decimal(1,0) not null comment '?f?[?^???'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

  , ItemName varchar(120) comment '??????'

  , SpecName varchar(120) comment '???^?i???E?`??E???@'

  , Unitcount decimal(8,2) not null comment '????'

  , UnitName varchar(30) comment '?P?????'

  , UnitPrice decimal(9,2) not null comment '?P??'

  , LineTotal decimal(12,0) not null comment '???z'

  , note varchar(60) comment '???l'

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , MyExpensesFlg decimal(1,0) not null comment '????o??t???O'

  , InputFlg decimal(1,0) comment '????t???O'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint estimatedatadetail_PKC primary key (ConstructionCode,PageCount,LineCount)

) comment '??Z????f?[?^????' ;

create index EstimateDataDetail_Index1

  on estimatedatadetail(ConstructionCode,PageCount);

-- ?o???}?X?^

--* BackupToTempTable

drop table if exists expensesmaster cascade;

--* RestoreFromTempTable

create table expensesmaster (