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

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

       -- Project Name : noname
       -- Date/Time    : 2018/06/19 8:22:40
       -- Author       : Horiuchi
       -- RDBMS Type   : MySQL
       -- Application  : A5:SQL Mk-2
       -- ?S????s???\??f?[?^
       drop table if exists actionscheduledata cascade;
       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?^
       drop table if exists approvalmaster cascade;
       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?[?^
       drop table if exists attendancedailydata cascade;
       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?[?^
       drop table if exists attendancedata cascade;
       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?^
       drop table if exists bankbusinessdaymaster cascade;
       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?[?^
       drop table if exists billingdata cascade;
       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?[?^
       drop table if exists billingdatadetail cascade;
       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?[?^
       drop table if exists billingpaymentsummary cascade;
       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?????????
       drop table if exists bizperiodhistory cascade;
       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
       drop table if exists bk_constructionledger cascade;
       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
       drop table if exists bk_constructionledgerdetail cascade;
       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
       drop table if exists bk_constructionledgerexcute cascade;
       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
       drop table if exists bk_estimatedata cascade;
       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
       drop table if exists bk_estimatedatabody cascade;
       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
       drop table if exists bk_estimatedatadetail cascade;
       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?^
       drop table if exists budgetsumcode cascade;
       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?^
       drop table if exists businesstypemaster cascade;
       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?[?^
       drop table if exists chgchargedep cascade;
       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?[?^
       drop table if exists chgconstrcharge cascade;
       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????'
         , 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?^
       drop table if exists commoncostlarge cascade;
       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?^
       drop table if exists commoncostlinkms cascade;
       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?^
       drop table if exists commoncostmiddle cascade;
       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?^
       drop table if exists commoncostmiddlesearchword cascade;
       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?^
       drop table if exists componentlinkmaster cascade;
       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?^
       drop table if exists componentmaster cascade;
       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?^
       drop table if exists componenttotypemaster cascade;
       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?[?^
       drop table if exists constrledgerexpenses cascade;
       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????{???
       drop table if exists constructionbaseinfo cascade;
       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????{????
       drop table if exists constructionbaseinfodetail cascade;
       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?[?^
       drop table if exists constructionbudget cascade;
       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?[?^????
       drop table if exists constructionbudgetdetail cascade;
       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?^
       drop table if exists constructionitemmaster cascade;
       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?[?^
       drop table if exists constructionledger cascade;
       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?[?^
       drop table if exists constructionledgerdetail cascade;
       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?[?^
       drop table if exists constructionledgerexcute cascade;
       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???
       drop table if exists constructionlink cascade;
       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????????
       drop table if exists constructionmaterialinfo cascade;
       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?[?^
       drop table if exists constructionprogressdate cascade;
       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?^
       drop table if exists constructionspecmaster cascade;
       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?^
       drop table if exists constructionspecunitprice cascade;
       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?^
       drop table if exists constructiontypemaster cascade;
       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?[?^
       drop table if exists costdataofdepartment cascade;
       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?[?^
       drop table if exists costdataofperson cascade;
       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?[?^
       drop table if exists costomerregist cascade;
       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?[?^
       drop table if exists dailydataconstruction cascade;
       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?[?^ (????)
       drop table if exists dailydatadetail cascade;
       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?[?^ (??????)
       drop table if exists dailydatafield cascade;
       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?[?^ (????)
       drop table if exists dailydatamaterials cascade;
       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??)
       drop table if exists dailydatasubcontractors cascade;
       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?[?^ (???)
       drop table if exists dailydatavehicles cascade;
       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?^
       drop table if exists daymaster cascade;
       create table daymaster (
         days smallint(6) not null comment '??'
         , constraint daymaster_PKC primary key (days)
       ) comment '???}?X?^' ;
       -- ?????}?X?^
       drop table if exists deadlinemaster cascade;
       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?^
       drop table if exists departmentexpensesmaster cascade;
       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?^
       drop table if exists departmentmaster cascade;
       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?[?^
       drop table if exists depositapprovalinfo cascade;
       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?[?^
       drop table if exists depositdata cascade;
       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?[?^
       drop table if exists depositdatadetail cascade;
       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?^
       drop table if exists divisionmaster cascade;
       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?[?^
       drop table if exists estimatebudget cascade;
       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?[?^????
       drop table if exists estimatebudgetdetail cascade;
       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?[?^
       drop table if exists estimatedata cascade;
       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?[?^
       drop table if exists estimatedatabody cascade;
       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?[?^????
       drop table if exists estimatedatadetail cascade;
       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?^
       drop table if exists expensesmaster cascade;
       create table expensesmaster (
         DivisionCode smallint(6) not null comment '?H?????R?[?h'
         , NameCode smallint(6) not null comment '?o????R?[?h'
         , DisplayOrder smallint(6) not null comment '?\????'
         , ExpensesRatio decimal(4,2) not null comment '?o??'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint expensesmaster_PKC primary key (DivisionCode,NameCode)
       ) comment '?o???}?X?^' ;
       -- ???x???}?X?^
       drop table if exists holidaycalendermaster cascade;
       create table holidaycalendermaster (
         Holiday date not null comment '?x??'
         , BusinessYear smallint(5) unsigned not null comment '?c??N?x'
         , TargetMonth tinyint(3) unsigned not null comment '?Y????'
         , TargetDay tinyint(3) unsigned not null comment '?Y????'
         , constraint holidaycalendermaster_PKC primary key (Holiday)
       ) comment '???x???}?X?^' ;
       create index HolidayCalender_Index1
         on holidaycalendermaster(BusinessYear);
       create index HolidayCalenderMaster_Index2
         on holidaycalendermaster(TargetMonth);
       create index HolidayCalenderMaster_Index3
         on holidaycalendermaster(TargetDay);
       -- ?????????????
       drop table if exists inputsearchlogdata cascade;
       create table inputsearchlogdata (
         ConstructionCode decimal(10,0) not null comment '?H???R?[?h'
         , UsedProcessNo decimal(4,0) not null comment '?g?p?@?\???'
         , DisplayOrder decimal(4,0) unsigned not null comment '?\????'
         , DataType decimal(1,0) not null comment '?f?[?^???'
         , InputCode decimal(10,0) comment '????R?[?h'
         , constraint inputsearchlogdata_PKC primary key (ConstructionCode,UsedProcessNo,DisplayOrder)
       ) comment '?????????????' ;
       create index InputSearchLogData_Index1
         on inputsearchlogdata(ConstructionCode,UsedProcessNo,InputCode);
       -- ???????f?[?^
       drop table if exists invoicedata cascade;
       create table invoicedata (
         INVOICENO decimal(9,0) not null comment '??????No'
         , ORDERERSDIVISION decimal(5,0) not null comment '???????'
         , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'
         , REQUESTMONTH decimal(6,0) not null comment '??????'
         , SEQNO decimal(2,0) not null comment '?A??'
         , CRETATEDATE date not null comment '????'
         , REQUESTDATE date not null comment '??????'
         , REQUESTNAME varchar(120) comment '??????'
         , TOTALAMOUNT decimal(10,0) comment '???????v???z'
         , TAXAMOUNT decimal(10,0) comment '???????z'
         , COMMENT1 varchar(60) comment '?R?????g1'
         , COMMENT2 varchar(60) comment '?R?????g2'
         , COMMENT3 varchar(60) not null comment '?R?????g3'
         , COMMENT4 varchar(60) not null comment '?R?????g4'
         , COMMENT5 varchar(60) not null comment '?R?????g5'
         , COMPLETEFLG decimal(1,0) default '0' not null comment '?????t???O'
         , ENTRYDATE datetime not null comment '?o?^?N????'
         , UPDATEDATE datetime not null comment '?X?V?N????'
         , constraint invoicedata_PKC primary key (INVOICENO)
       ) comment '???????f?[?^' ;
       alter table invoicedata add unique ORDERERSDIVISION (ORDERERSDIVISION,ORDERERSCODE,REQUESTMONTH,SEQNO) ;
       -- ??????
       drop table if exists materialinfo cascade;
       create table materialinfo (
         MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'
         , MATERIALCOUNT smallint(5) unsigned comment '?????'
         , RENTCOUNT smallint(5) unsigned comment '??o??\??'
         , DELETEFLG smallint(5) unsigned comment '???t???O'
         , ENTRYDATE datetime comment '?o?^???t'
         , UPDATEDATE datetime comment '?X?V???t'
         , constraint materialinfo_PKC primary key (MATERIALITEMCODE)
       ) comment '??????' ;
       -- ????i??}?X?^
       drop table if exists materialitemmaster cascade;
       create table materialitemmaster (
         MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'
         , MATERIALKINDCODE smallint(5) unsigned comment '??????R?[?h'
         , MATERIALITEMNAME varchar(40) comment '????i?????'
         , DISPLAYORDER smallint(5) unsigned comment '?\????'
         , DELETEFLG tinyint(3) unsigned comment '???t???O'
         , ENTRYDATE datetime comment '?o?^???t'
         , UPDATEDATE datetime comment '?X?V???t'
         , VERSIONNO decimal(8,0) default '0' not null comment '?o?[?W???????'
         , constraint materialitemmaster_PKC primary key (MATERIALITEMCODE)
       ) comment '????i??}?X?^' ;
       -- ??????}?X?^
       drop table if exists materialkindmaster cascade;
       create table materialkindmaster (
         MATERIALKINDCODE smallint(5) unsigned default 0 not null comment '??????R?[?h'
         , MATERIALKINDNAME varchar(40) comment '?????????'
         , DISPLAYORDER smallint(5) unsigned comment '?\????'
         , DELETEFLG tinyint(3) unsigned comment '???t???O'
         , ENTRYDATE datetime comment '?o?^???t'
         , UPDATEDATE datetime comment '?X?V???t'
         , constraint materialkindmaster_PKC primary key (MATERIALKINDCODE)
       ) comment '??????}?X?^' ;
       -- ??????????
       drop table if exists materialrecordinfo cascade;
       create table materialrecordinfo (
         MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'
         , PROCESSDATE date default '0000-00-00' not null comment '?????N????'
         , SEQNO smallint(5) unsigned default 0 not null comment '?A??'
         , RECKIND tinyint(3) unsigned comment '???R?[?h??'
         , CONSTRUCTIONCODE int(10) unsigned comment '?H?????'
         , PERSONCODE int(10) unsigned comment '?S????R?[?h'
         , MATERIALCOUNT smallint(5) unsigned comment '?????'
         , REPAYPLANDATE date comment '??p?\??N????'
         , COMMENTTEXT varchar(80) comment '?R?????g'
         , ENTRYDATE datetime comment '?o?^???t'
         , UPDATEDATE datetime comment '?X?V???t'
         , constraint materialrecordinfo_PKC primary key (MATERIALITEMCODE,PROCESSDATE,SEQNO)
       ) comment '??????????' ;
       -- ?f??????b?Z?[?W
       drop table if exists messageboarddata cascade;
       create table messageboarddata (
         RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'
         , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'
         , FromCode decimal(8,0) unsigned not null comment '???????R?[?h'
         , FromName varchar(60) not null comment '???????'
         , MessageTitile varchar(100) comment '?`???^?C?g??'
         , MessageContent varchar(1333) not null comment '?`?????e'
         , LinkType decimal(2,0) not null comment '?????N????^?C?v'
         , LinkMessage varchar(200) comment '?????N??????'
         , LinkCode varchar(30) comment '?????N?L?['
         , WritingDate datetime not null comment '?????????'
         , PersonCode decimal(8,0) not null comment '??????S????R?[?h'
         , ShareFlag decimal(2,0) not null comment '???????t???O'
         , MessageColor varchar(8) comment '?????F'
         , BackColor varchar(8) comment '?o?b?N?J???['
         , MessageFlag decimal(1,0) not null comment '???b?Z?[?W?t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint messageboarddata_PKC primary key (RecordNumber,BranchNumber)
       ) comment '?f??????b?Z?[?W' ;
       create index MessageBoardData_Index1
         on messageboarddata(WritingDate);
       create index MessageBoardData_Index2
         on messageboarddata(MessageFlag);
       -- ?f???????e?[?u??
       drop table if exists messageboardterget cascade;
       create table messageboardterget (
         RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'
         , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'
         , SeqNum decimal(3,0) unsigned not null comment '????'
         , ToCode decimal(8,0) not null comment '????R?[?h'
         , ToName varchar(60) not null comment '????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint messageboardterget_PKC primary key (RecordNumber,BranchNumber,SeqNum)
       ) comment '?f???????e?[?u??' ;
       create index MessageBoardTerget_Index1
         on messageboardterget(RecordNumber,BranchNumber);
       -- ?f??????b?Z?[?W?{??????
       drop table if exists messagebrowsinghistory cascade;
       create table messagebrowsinghistory (
         RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'
         , BranchNumber decimal(3,0) unsigned not null comment '???R?[?h?}??'
         , SeqNum decimal(3,0) unsigned not null comment '????'
         , BrowsingCode decimal(8,0) not null comment '?{????R?[?h'
         , BrowsingDate datetime not null comment '?{?????t'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint messagebrowsinghistory_PKC primary key (RecordNumber,BranchNumber,SeqNum)
       ) comment '?f??????b?Z?[?W?{??????' ;
       -- ???}?X?^
       drop table if exists monthmaster cascade;
       create table monthmaster (
         month smallint(6) not null comment '??'
         , constraint monthmaster_PKC primary key (month)
       ) comment '???}?X?^' ;
       -- ??????}?X?^
       drop table if exists orderersmaster cascade;
       create table orderersmaster (
         OrderCotegory decimal(5,0) unsigned not null comment '???????'
         , OrderersCode decimal(5,0) unsigned not null comment '??????R?[?h'
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , OrderFlg decimal(1,0) not null comment '?@?l?c??E??l?t???O'
         , CorporateStatusName varchar(100) comment '?@?l?i????'
         , CorporateStatusPoint decimal(1,0) comment '?@?l?i?????u'
         , OrderersName1 varchar(60) not null comment '???????1'
         , OrderersName2 varchar(60) comment '????????Q'
         , DepartmentName varchar(60) comment '??????'
         , ChargePersonName varchar(60) comment '?S?????'
         , ZipCode varchar(8) comment '?X????'
         , Address1 varchar(60) comment '?Z???P'
         , Address2 varchar(60) comment '?Z??2'
         , Address3 varchar(60) comment '?Z??3'
         , PhoneNumber varchar(13) comment '?d?b???'
         , FaxNumber varchar(13) comment 'FAX???'
         , MailAddress varchar(257) comment '???[???A?h???X'
         , Note varchar(300) comment '???l'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint orderersmaster_PKC primary key (OrderCotegory,OrderersCode)
       ) comment '??????}?X?^' ;
       -- ????z?f?[?^
       drop table if exists orderspricedata cascade;
       create table orderspricedata (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ChangeNo decimal(3,0) unsigned not null comment '??X???'
         , ChangeDate date not null comment '??X??'
         , ChangePersonCode decimal(8,0) unsigned not null comment '??X??R?[?h'
         , ChangePersonName varchar(60) comment '??X???'
         , BeforeValue decimal(14,0) not null comment '??X?O???????z'
         , BeforeValueInTax decimal(14,0) not null comment '??X?O???????z'
         , AfterValue decimal(14,0) not null comment '??X????????z'
         , AfterValueInTax decimal(14,0) not null comment '??X????????z'
         , ChangeComment varchar(200) comment '??X???R'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint orderspricedata_PKC primary key (ConstructionCode,ChangeNo)
       ) comment '????z?f?[?^' ;
       -- ?x?????F???f?[?^
       drop table if exists paymentapprovalinfo cascade;
       create table paymentapprovalinfo (
         COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
         , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
         , SEQNO decimal(3,0) default '0' not null comment '?A??'
         , LINECOUNT decimal(3,0) default '0' not null comment '?s???'
         , APPROVALNO decimal(3,0) default '0' not null comment '???F????'
         , APPROVALPERSON decimal(8,0) comment '???F??R?[?h'
         , APPROVALPERSONNAME varchar(20) comment '???F???'
         , APPROVALAUTHORITY decimal(1,0) comment '???F??????'
         , APPROVALDATE date comment '???F???t'
         , ENTRYDATE datetime comment '?o?^???t'
         , UPDATEDATE datetime comment '?X?V???t'
         , constraint paymentapprovalinfo_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT,APPROVALNO)
       ) comment '?x?????F???f?[?^' ;
       -- ?x??????f?[?^
       drop table if exists paymentdatadetail cascade;
       create table paymentdatadetail (
         COMPANYCODE decimal(8,0) default '0' not null comment '??????R?[?h'
         , TARGETDATE decimal(6,0) default '0' not null comment '???N??'
         , SEQNO decimal(3,0) default '0' not null comment '?A??'
         , LINECOUNT decimal(3,0) default '0' not null comment '?s???'
         , BILLPRICE decimal(10,0) comment '???????z'
         , DISCOUNTPRICE decimal(10,0) comment '?l???????z'
         , OFFSETPRICE decimal(10,0) comment '???E???z'
         , NEXTCOPRICE decimal(10,0) comment '????J?z'
         , HIGHWPRICE decimal(10,0) comment '??????'
         , HARDWPRICE decimal(10,0) comment '??????'
         , INDSWASTETAX decimal(10,0) comment '?Y?p??'
         , CNSTRPRICE decimal(10,0) comment '?????'
         , CNSTRPRICEEXIST decimal(1,0) comment '??????L??'
         , APPROVALPERSONCODE decimal(8,0) comment '???F?S????R?[?h'
         , APPROVALDATE date comment '?S??????F???t'
         , APPROVALENDFLG decimal(1,0) comment '???F?????t???O'
         , ENTRYDATE datetime comment '?o?^???t'
         , UPDATEDATE datetime comment '?X?V???t'
         , constraint paymentdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)
       ) comment '?x??????f?[?^' ;
       create index PayDataDetail_Index1
         on paymentdatadetail(TARGETDATE);
       create index PayDataDetail_Index2
         on paymentdatadetail(APPROVALPERSONCODE);
       -- ?H??????????f?[?^
       drop table if exists periodavoidance cascade;
       create table periodavoidance (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'
         , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint periodavoidance_PKC primary key (ConstructionCode,ConstructionStatusFlg,FieldNo)
       ) comment '?H??????????f?[?^' ;
       create index PeriodAvoidance_Index1
         on periodavoidance(ConstructionCode);
       create index PeriodAvoidance_Index2
         on periodavoidance(ConstructionStatusFlg);
       create index PeriodAvoidance_Index3
         on periodavoidance(FieldNo);
       -- ?S??????F?f?[?^
       drop table if exists personapproval cascade;
       create table personapproval (
         PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
         , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
         , OrderDate date not null comment '??t??'
         , OrderNo decimal(2,0) unsigned not null comment '??t???'
         , SeqNo decimal(2,0) not null comment '?}??'
         , PersonCodeApproval decimal(8,0) unsigned not null comment '?\???E???F??R?[?h'
         , PetitionApprovalDate datetime not null comment '?\???E???F???t'
         , ApprovalLimitDates datetime not null comment '???F??]??'
         , ApprovalStatus decimal(1,0) not null comment '???F???'
         , InputComment varchar(300) comment '?R?????g'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint personapproval_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,SeqNo)
       ) comment '?S??????F?f?[?^' ;
       -- ?S??????F?R?????g?f?[?^
       drop table if exists personapprovalcomment cascade;
       create table personapprovalcomment (
         PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
         , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
         , OrderDate date not null comment '??t??'
         , OrderNo decimal(2,0) unsigned not null comment '??t???'
         , CommentNo decimal(2,0) not null comment '?R?????g???'
         , ParentNo decimal(2,0) not null comment '?e?R?????g???'
         , ApproValComment varchar(300) comment '?w???E?A???R?????g'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint personapprovalcomment_PKC primary key (PersonCode,ApprovalCode,OrderDate,OrderNo,CommentNo)
       ) comment '?S??????F?R?????g?f?[?^' ;
       -- ?S??????????}?X?^
       drop table if exists persondepartmentmaster cascade;
       create table persondepartmentmaster (
         PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
         , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'
         , AffiliationFlg decimal(1,0) not null comment '?????t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint persondepartmentmaster_PKC primary key (PersonCode,DepartmentCode)
       ) comment '?S??????????}?X?^' ;
       create index PersonDepartmentMaster_Index1
         on persondepartmentmaster(PersonCode);
       create index PersonDepartmentMaster_Index2
         on persondepartmentmaster(DepartmentCode);
       -- ?S????}?X?^
       drop table if exists personinchargemaster cascade;
       create table personinchargemaster (
         PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
         , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
         , PersonName varchar(60) not null comment '?S?????'
         , StartDate date not null comment '?g?p?J?n?N????'
         , EndDate date comment '?g?p?I???N????'
         , PassWord varchar(16) comment '?p?X???[?h'
         , SecurityManagement decimal(1,0) not null comment '?@????'
         , SecCode decimal(2,0) unsigned not null comment '???????'
         , MsgBackColor varchar(8) comment '???b?Z?[?W?w?i?F'
         , DisplayString varchar(20) comment '?\???E???????'
         , DepartmentCode decimal(5,0) unsigned comment '?????R?[?h'
         , MonthlySalary decimal(11,0) not null comment '???????z'
         , YearSalary decimal(12,0) not null comment '?N????z'
         , Qualification varchar(120) comment '???i?????'
         , SealPrintName varchar(5) comment '???\????'
         , EmployeeClassFlg decimal(1,0) not null comment '?????'
         , LedgerFlg decimal(1,0) not null comment '???v?Z???t???O'
         , CommutingDistance decimal(5,2) not null comment '??????'
         , CommuteCosts decimal(5,0) not null comment '??????'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint personinchargemaster_PKC primary key (PersonCode)
       ) comment '?S????}?X?^' ;
       create index PersonInChargeMaster_Index1
         on personinchargemaster(StartDate);
       create index PersonInChargeMaster_Index2
         on personinchargemaster(DepartmentCode);
       -- ?S??????^?}?X?^
       drop table if exists personsalarymaster cascade;
       create table personsalarymaster (
         PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
         , StartDate date not null comment '?g?p?J?n?N????'
         , MonthlySalary decimal(11,0) not null comment '???????z'
         , YearSalary decimal(12,0) not null comment '?N????z'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint personsalarymaster_PKC primary key (PersonCode,StartDate)
       ) comment '?S??????^?}?X?^' ;
       create index PersonSalaryMaster_Index1
         on personsalarymaster(PersonCode);
       create index PersonSalaryMaster_Index2
         on personsalarymaster(StartDate);
       create index PersonSalaryMaster_Index3
         on personsalarymaster(MonthlySalary);
       -- ?w???????f?[?^
       drop table if exists pointingoutcomment cascade;
       create table pointingoutcomment (
         ConstructionCode decimal(10,0) not null comment '?H???R?[?h'
         , ProcessNo smallint(6) not null comment '????????i??????j'
         , SeqNo smallint(6) not null comment '????'
         , PageCount smallint(6) not null comment '?y?[?W???'
         , PersonCode decimal(8,0) not null comment '?L????R?[?h'
         , DrowColor varchar(8) comment '?`??F'
         , CommentMessage varchar(1000) comment '???b?Z?[?W'
         , StartPointX smallint(6) not null comment '?w?E?????u?w'
         , StartPointY smallint(6) not null comment '?w?E?????u?x'
         , CurrentPointX smallint(6) not null comment '??????u?w'
         , CurrentPointY smallint(6) not null comment '??????u?x'
         , CurrentWidth smallint(6) not null comment '?\???T?C?YWidth'
         , CurrentHeight smallint(6) not null comment '?\???T?C?YHeigth'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint pointingoutcomment_PKC primary key (ConstructionCode,ProcessNo,SeqNo)
       ) comment '?w???????f?[?^' ;
       -- ?????????????c???^?f?[?^
       drop table if exists proceedingsdata cascade;
       create table proceedingsdata (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ProceedingsDataDate date not null comment '?c???^????'
         , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'
         , EndMeetingTime decimal(4,0) unsigned not null comment '??c????I??'
         , CreatorCode decimal(8,0) not null comment '????R?[?h'
         , PalceFlag decimal(1,0) not null comment '???n?t???O'
         , MeetingPalce varchar(120) comment '???????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint proceedingsdata_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime)
       ) comment '?????????????c???^?f?[?^' ;
       -- ?????????????c???^?f?[?^?i?o???j
       drop table if exists proceedingsdataattend cascade;
       create table proceedingsdataattend (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ProceedingsDataDate date not null comment '?c???^????'
         , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'
         , SeqNo decimal(3,0) unsigned not null comment '????s???'
         , Department varchar(20) comment '?o??????'
         , AttendName varchar(10) comment '?o??????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint proceedingsdataattend_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
       ) comment '?????????????c???^?f?[?^?i?o???j' ;
       -- ?????????????c???^?f?[?^?i????j
       drop table if exists proceedingsdatadetail cascade;
       create table proceedingsdatadetail (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ProceedingsDataDate date not null comment '?c???^????'
         , StartMeetingTime decimal(4,0) unsigned not null comment '??c????J?n'
         , SeqNo decimal(3,0) unsigned not null comment '????s???'
         , TitleNo varchar(5) comment '?c????'
         , Title varchar(20) comment '?c??'
         , ContentsText varchar(50) comment '???e'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint proceedingsdatadetail_PKC primary key (ConstructionCode,ProceedingsDataDate,StartMeetingTime,SeqNo)
       ) comment '?????????????c???^?f?[?^?i????j' ;
       -- ???F?f?[?^
       drop table if exists processapproval cascade;
       create table processapproval (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
         , OrderNo decimal(2,0) unsigned not null comment '??t???'
         , SeqNo decimal(2,0) not null comment '?}??'
         , PersonCode decimal(8,0) unsigned not null comment '?\???E???F??R?[?h'
         , PetitionApprovalDate datetime not null comment '?\???E???F???t'
         , ApprovalLimitDates datetime not null comment '???F??]??'
         , ApprovalStatus decimal(1,0) not null comment '???F???'
         , InputComment varchar(300) comment '?R?????g'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint processapproval_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SeqNo)
       ) comment '???F?f?[?^' ;
       -- ???F?R?????g?f?[?^
       drop table if exists processapprovalcomment cascade;
       create table processapprovalcomment (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
         , OrderNo decimal(2,0) unsigned not null comment '??t???'
         , CommentNo decimal(2,0) not null comment '?R?????g???'
         , ParentNo decimal(2,0) not null comment '?e?R?????g???'
         , ApproValComment varchar(300) comment '?w???E?A???R?????g'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint processapprovalcomment_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,CommentNo)
       ) comment '???F?R?????g?f?[?^' ;
       -- ???F????f?[?^
       drop table if exists processapprovaldetail cascade;
       create table processapprovaldetail (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , ApprovalCode decimal(3,0) unsigned not null comment '???F?@?\???'
         , OrderNo decimal(2,0) unsigned not null comment '??t???'
         , SerialNo decimal(2,0) unsigned not null comment '?}??'
         , LinkCode decimal(10,0) not null comment '?????N???'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint processapprovaldetail_PKC primary key (ConstructionCode,ApprovalCode,OrderNo,SerialNo)
       ) comment '???F????f?[?^' ;
       -- ?N?????}?X?^
       drop table if exists processexcutemaster cascade;
       create table processexcutemaster (
         SecCode decimal(2,0) unsigned not null comment '???????'
         , ExecCode decimal(4,0) unsigned not null comment '?N?????????'
         , EditFlg decimal(1,0) not null comment '??W?t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint processexcutemaster_PKC primary key (SecCode,ExecCode)
       ) comment '?N?????}?X?^' ;
       create index ProcessExcuteMaster_Index1
         on processexcutemaster(SecCode);
       create index ProcessExcuteMaster_Index2
         on processexcutemaster(ExecCode);
       -- ???????f?[?^
       drop table if exists purchaseorder cascade;
       create table purchaseorder (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , SeqNo decimal(3,0) unsigned not null comment '???????}??'
         , CompanyCode decimal(8,0) not null comment '??????R?[?h'
         , CreateDate date comment '?????t'
         , OrderPrice decimal(12,0) not null comment '???????z'
         , LastRowStringDate date not null comment '??I?s?\?????t'
         , OrderSheetType decimal(1,0) not null comment '???E?{???t???O'
         , PaymentTerms decimal(1,0) not null comment '?x????????'
         , CashRatio decimal(4,1) not null comment '?????????i???j'
         , BillPeriod decimal(4,0) not null comment '??`????'
         , PrePayments decimal(1,0) not null comment '?O????'
         , PrePaymentsDays decimal(3,0) not null comment '?O????????'
         , PrePaymentsPrice decimal(12,0) not null comment '?O???????z'
         , PartialPayment decimal(1,0) not null comment '??????'
         , PartialPaymentMounth decimal(2,0) unsigned not null comment '???????????'
         , PartialPaymentDay1 decimal(2,0) unsigned not null comment '???????????'
         , PartialPaymentDay2 decimal(2,0) unsigned not null comment '???????x????'
         , PartialPaymentPrice decimal(12,0) not null comment '?????????z'
         , CompletionPayment decimal(1,0) not null comment '???n??????x??'
         , CompletionPaymentDays decimal(3,0) unsigned not null comment '???n??????x??????'
         , CompletionPaymentPrice decimal(12,0) not null comment '???n??????x?????z'
         , LeadEngineerCode decimal(8,0) comment '??C?Z?p??R?[?h'
         , LeadEngineerName varchar(60) comment '??C?Z?p???'
         , SafetyOfficerCode decimal(8,0) comment '???S?????R?[?h'
         , SafetyOfficerName varchar(60) comment '???S??????'
         , WorkersCount decimal(3,0) unsigned comment '??????'
         , PrintoutDate date not null comment '????N????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint purchaseorder_PKC primary key (ConstructionCode,SeqNo)
       ) comment '???????f?[?^' ;
       -- ?????????t?f?[?^
       drop table if exists purchaseorderdate cascade;
       create table purchaseorderdate (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , SeqNo decimal(3,0) unsigned not null comment '???????}??'
         , CompanyCode decimal(8,0) not null comment '??????R?[?h'
         , SendDate date not null comment '???????X????'
         , ReturnDate date not null comment '???????????'
         , ReturnCheckDate date not null comment '??????????m?F??'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint purchaseorderdate_PKC primary key (ConstructionCode,SeqNo)
       ) comment '?????????t?f?[?^' ;
       -- ??????????f?[?^
       drop table if exists purchaseorderdetail cascade;
       create table purchaseorderdetail (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , SeqNo decimal(3,0) unsigned not null comment '???????}??'
         , GroupCount decimal(1,0) not null comment '?O???[?v???'
         , LineCount decimal(3,0) unsigned not null comment '?s???'
         , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
         , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
         , FirstString varchar(120) comment '?H??E?i??'
         , SecondString varchar(120) comment '???e????'
         , UnitCount decimal(8,2) not null comment '????'
         , UnitName varchar(30) comment '?P??'
         , UnitPrice decimal(10,0) not null comment '?P??'
         , OrdersLinePrice decimal(12,0) comment '???z'
         , SourceCode decimal(10,0) unsigned not null comment '???H?????'
         , SourceDetailCnt decimal(4,0) unsigned not null comment '????????'
         , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'
         , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)
       ) comment '??????????f?[?^' ;
       create index POrderDetail_Index1
         on purchaseorderdetail(SourceCode);
       -- ?????f?[?^
       drop table if exists requestdata cascade;
       create table requestdata (
         REQUESTNO decimal(9,0) not null comment '????No'
         , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '?{?H?????'
         , CONSTRUCTIONNAME varchar(120) not null comment '?H??????'
         , CONTRACTAMOUNT decimal(10,0) not null comment '???????z'
         , PAIDAMOUNT decimal(10,0) not null comment '????????z'
         , REQUESTAMOUNT0 decimal(10,0) not null comment '???????z?O'
         , REQUESTAMOUNT1 decimal(10,0) not null comment '???????z?P'
         , REQUESTAMOUNT2 decimal(10,0) comment '???????z?Q'
         , REQUESTAMOUNT3 decimal(10,0) comment '???????z?R'
         , REQUESTAMOUNT4 decimal(10,0) comment '???????z?S'
         , REQUESTAMOUNT5 decimal(10,0) comment '???????z?T'
         , REQUESTAMOUNT6 decimal(10,0) comment '???????z?U'
         , UNCLAIMEDAMOUNT decimal(10,0) not null comment '?????c???z'
         , UNPAIDAMOUNT decimal(10,0) not null comment '?????????z'
         , TAXAMOUNT decimal(10,0) not null comment '?????'
         , NOTE varchar(120) not null comment '???l'
         , ENTRYDATE datetime not null comment '?o?^?N????'
         , UPDATEDATE datetime not null comment '?X?V?N????'
         , constraint requestdata_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE)
       ) comment '?????f?[?^' ;
       -- ?????f?[?^????
       drop table if exists requestdatadetail cascade;
       create table requestdatadetail (
         REQUESTNO decimal(9,0) not null comment '????No'
         , MAINCONSTRUCTIONCODE decimal(10,0) not null comment '?{?H?????'
         , CONSTRUCTIONCODE decimal(10,0) not null comment '?H?????'
         , CONSTRUCTIONKIND decimal(1,0) not null comment '?H????'
         , REQUESTAMOUNT decimal(10,0) not null comment '???????z'
         , TAXAMOUNT decimal(10,0) not null comment '?????'
         , ENTRYDATE datetime not null comment '?o?^?N????'
         , UPDATEDATE datetime not null comment '?X?V?N????'
         , constraint requestdatadetail_PKC primary key (REQUESTNO,MAINCONSTRUCTIONCODE,CONSTRUCTIONCODE,CONSTRUCTIONKIND)
       ) comment '?????f?[?^????' ;
       -- ?????w?b?_
       drop table if exists requesthead cascade;
       create table requesthead (
         REQUESTNO decimal(9,0) not null comment '????No'
         , REQCONSTRUCTIONCODE decimal(10,0) not null comment '?????H?????'
         , ORDERNO decimal(2,0) not null comment '??t???'
         , REQUESTMONTH decimal(6,0) not null comment '??????'
         , ORDERERSDIVISION decimal(5,0) not null comment '???????'
         , ORDERERSCODE decimal(5,0) not null comment '??????R?[?h'
         , ORDERERSNAME varchar(120) not null comment '???????'
         , REQCONSTRUCTIONNAME varchar(120) not null comment '?????H??????'
         , REQUESTTOTALAMOUNT decimal(10,0) not null comment '???????z???v'
         , REQUESTAMOUNT decimal(10,0) not null comment '???????z'
         , TAXAMOUNT decimal(10,0) not null comment '?????'
         , UNPAIDAMOUNT decimal(10,0) comment '??????'
         , NOTE varchar(120) comment '???l'
         , ASSIGNEDFLG decimal(1,0) comment '??????t???O'
         , INVOICENO decimal(9,0) not null comment '??????No'
         , ENTRYDATE datetime not null comment '?o?^?N????'
         , UPDATEDATE datetime not null comment '?X?V?N????'
         , constraint requesthead_PKC primary key (REQUESTNO)
       ) comment '?????w?b?_' ;
       alter table requesthead add unique REQCONSTRUCTIONCODE (REQCONSTRUCTIONCODE,ORDERNO) ;
       -- ?????????t?f?[?^
       drop table if exists requestorderdate cascade;
       create table requestorderdate (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , InvoiceNo decimal(9,0) not null comment '??????No'
         , SendDate date not null comment '???????????X????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint requestorderdate_PKC primary key (ConstructionCode,InvoiceNo)
       ) comment '?????????t?f?[?^' ;
       -- ????O???t?f?[?^
       drop table if exists salesgraphdata cascade;
       create table salesgraphdata (
         GraphDataCode decimal(8,0) not null comment '?O???t?f?[?^?R?[?h'
         , ConstructionPeriod decimal(4,0) unsigned not null comment '?????'
         , SalesDataDays date not null comment '????N??'
         , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
         , DataName varchar(100) not null comment '?f?[?^?\??????'
         , SalesAmount decimal(10,0) not null comment '????f?[?^'
         , AdministrativeExpense decimal(10,0) not null comment '???E?????o??'
         , GrossProfit decimal(10,0) not null comment '?e???v'
         , NetIncome decimal(10,0) not null comment '?????v(???v)'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint salesgraphdata_PKC primary key (GraphDataCode,ConstructionPeriod,SalesDataDays)
       ) comment '????O???t?f?[?^' ;
       create index SalesGraphData_Idx1
         on salesgraphdata(DisplayOrder);
       create index SalesGraphData_idx2
         on salesgraphdata(ConstructionPeriod);
       -- ?????}?X?^
       drop table if exists securitymaster cascade;
       create table securitymaster (
         SecCode decimal(2,0) unsigned not null comment '???????'
         , DisplayOrder decimal(2,0) not null comment '?\????'
         , SecName varchar(60) not null comment '????????'
         , SecRank decimal(1,0) not null comment '?????????N'
         , SecRange decimal(1,0) not null comment '???????'
         , GeneralAffairs decimal(1,0) not null comment '????????t???O'
         , SelectBackColor varchar(8) not null comment '?I??w?i?F'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint securitymaster_PKC primary key (SecCode)
       ) comment '?????}?X?^' ;
       create index SecurityMaster_Index1
         on securitymaster(DisplayOrder);
       create index SecurityMaster_Index2
         on securitymaster(SecRank);
       create index SecurityMaster_Index3
         on securitymaster(SecRange);
       -- ???S?p?g???[???f?[?^
       drop table if exists sfpdata cascade;
       create table sfpdata (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'
         , RequestDate datetime not null comment '?p?g???[???v??????'
         , PersonCode decimal(8,0) unsigned not null comment '?\????R?[?h'
         , StringValue varchar(300) comment '?R?????g'
         , OrderNo decimal(2,0) unsigned not null comment '?\????t???'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint sfpdata_PKC primary key (ConstructionCode,DataCount)
       ) comment '???S?p?g???[???f?[?^' ;
       create index SFPData_Index1
         on sfpdata(RequestDate);
       -- ???S?p?g???[??????f?[?^
       drop table if exists sfpdatadetail cascade;
       create table sfpdatadetail (
         ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
         , DataCount decimal(2,0) unsigned not null comment '?p?g???[????'
         , SeqNo decimal(2,0) unsigned not null comment '?f?[?^?}??'
         , CompanyCode decimal(8,0) unsigned not null comment '??????R?[?h'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint sfpdatadetail_PKC primary key (ConstructionCode,DataCount,SeqNo)
       ) comment '???S?p?g???[??????f?[?^' ;
       -- ??????{?H?H??o?^?\???f?[?^
       drop table if exists subconstrjobitemregist cascade;
       create table subconstrjobitemregist (
         PersonCode decimal(8,0) unsigned not null comment '?\??????'
         , CreateDate date not null comment '????'
         , SeqNo decimal(2,0) unsigned not null comment '?\???A??'
         , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
         , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subconstrjobitemregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)
       ) comment '??????{?H?H??o?^?\???f?[?^' ;
       -- ??????E?????N?o?^?\???f?[?^
       drop table if exists subconstrjoblinkregist cascade;
       create table subconstrjoblinkregist (
         PersonCode decimal(8,0) unsigned not null comment '?\??????'
         , CreateDate date not null comment '????'
         , SeqNo decimal(2,0) unsigned not null comment '?\???A??'
         , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
         , JobCategoryCode decimal(5,0) not null comment '?E??L?['
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subconstrjoblinkregist_PKC primary key (PersonCode,CreateDate,SeqNo,DisplayOrder)
       ) comment '??????E?????N?o?^?\???f?[?^' ;
       -- ??????o?^?\???f?[?^
       drop table if exists subconstrregist cascade;
       create table subconstrregist (
         PersonCode decimal(8,0) unsigned not null comment '?\??????'
         , CreateDate date not null comment '????'
         , SeqNo decimal(2,0) unsigned not null comment '?\???A??'
         , DataMode decimal(1,0) comment '?f?[?^??'
         , SourceCode decimal(8,0) not null comment '??????R?[?h'
         , PetitionPeriod decimal(4,0) unsigned not null comment '?\???N?x'
         , CorporateStatusName varchar(40) comment '?@?l?i????'
         , CorporateStatusPoint decimal(1,0) not null comment '?@?l?i?????u'
         , CompanyName varchar(100) not null comment '???????'
         , CEOPositionName varchar(60) comment '??\???E??'
         , CEOName varchar(60) comment '??\?????'
         , ContactPersonName varchar(60) comment '?S???????'
         , ZipCode varchar(8) comment '?X????'
         , Address1 varchar(60) comment '?Z???P'
         , Address2 varchar(60) comment '?Z??2'
         , Address3 varchar(60) comment '?Z??3'
         , CellPhoneNumber varchar(13) comment '?g??d?b???'
         , MailAddress varchar(257) comment '???[???A?h???X'
         , PhoneNumber varchar(13) comment '?d?b???'
         , FaxNumber varchar(13) comment 'FAX???'
         , JapaneseSyllabary varchar(2) comment '50?????'
         , StartDate date not null comment '????J?n?N????'
         , Note varchar(300) comment '???l'
         , labourKind decimal(1,0) not null comment '?x???????E????'
         , OrderDate date comment '?\????'
         , OrderNo decimal(2,0) unsigned not null comment '?\????t???'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subconstrregist_PKC primary key (PersonCode,CreateDate,SeqNo)
       ) comment '??????o?^?\???f?[?^' ;
       -- ??????H??}?X?^
       drop table if exists subcontractoritemmaster cascade;
       create table subcontractoritemmaster (
         ItemCode decimal(5,0) unsigned not null comment '?H??L?['
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , ItemName varchar(120) not null comment '?H????'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subcontractoritemmaster_PKC primary key (ItemCode)
       ) comment '??????H??}?X?^' ;
       -- ??????E??}?X?^
       drop table if exists subcontractorjobcategory cascade;
       create table subcontractorjobcategory (
         JobCategoryCode decimal(5,0) not null comment '?E??L?['
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , JobCategoryName varchar(120) not null comment '?E????'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subcontractorjobcategory_PKC primary key (JobCategoryCode)
       ) comment '??????E??}?X?^' ;
       -- ??????{?H?H??f?[?^
       drop table if exists subcontractorjobitem cascade;
       create table subcontractorjobitem (
         CompanyCode decimal(8,0) not null comment '??????R?[?h'
         , ItemCode decimal(5,0) unsigned not null comment '?H??L?['
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subcontractorjobitem_PKC primary key (CompanyCode,ItemCode)
       ) comment '??????{?H?H??f?[?^' ;
       create index SubContractorJobItem_Index1
         on subcontractorjobitem(CompanyCode);
       create index SubContractorJobItem_Index2
         on subcontractorjobitem(ItemCode);
       -- ??????E?????N?}?X?^
       drop table if exists subcontractorjoblink cascade;
       create table subcontractorjoblink (
         CompanyCode decimal(8,0) not null comment '??????R?[?h'
         , JobCategoryCode decimal(5,0) not null comment '?E??L?['
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subcontractorjoblink_PKC primary key (CompanyCode,JobCategoryCode)
       ) comment '??????E?????N?}?X?^' ;
       create index SubContractorJobLink_Index1
         on subcontractorjoblink(CompanyCode);
       create index SubContractorJobLink_Index2
         on subcontractorjoblink(JobCategoryCode);
       -- ??????}?X?^
       drop table if exists subcontractormaster cascade;
       create table subcontractormaster (
         CompanyCode decimal(8,0) not null comment '??????R?[?h'
         , DisplayOrder decimal(8,0) unsigned not null comment '?\????'
         , CorporateStatusName varchar(40) comment '?@?l?i????'
         , CorporateStatusPoint decimal(1,0) not null comment '?@?l?i?????u'
         , CompanyName varchar(100) not null comment '???????'
         , CEOPositionName varchar(60) comment '??\???E??'
         , CEOName varchar(60) comment '??\?????'
         , ContactPersonName varchar(60) comment '?S???????'
         , ZipCode varchar(8) comment '?X????'
         , Address1 varchar(60) comment '?Z???P'
         , Address2 varchar(60) comment '?Z??2'
         , Address3 varchar(60) comment '?Z??3'
         , CellPhoneNumber varchar(13) comment '?g??d?b???'
         , MailAddress varchar(257) comment '???[???A?h???X'
         , PhoneNumber varchar(13) comment '?d?b???'
         , FaxNumber varchar(13) comment 'FAX???'
         , JapaneseSyllabary varchar(2) comment '50?????'
         , StartDate date not null comment '????J?n?N????'
         , Note varchar(300) comment '???l'
         , labourKind decimal(1,0) not null comment '?x???????E????'
         , DeleteFlg decimal(1,0) default '0' not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint subcontractormaster_PKC primary key (CompanyCode)
       ) comment '??????}?X?^' ;
       create index SubContractorMaster_Index1
         on subcontractormaster(JapaneseSyllabary);
       -- ?d????}?X?^
       drop table if exists suppliersmaster cascade;
       create table suppliersmaster (
         SuppliersCode decimal(5,0) unsigned not null comment '?d????R?[?h'
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , SuppliersName1 varchar(60) not null comment '?d????1'
         , SuppliersName2 varchar(60) comment '?d?????Q'
         , ZipCode varchar(8) comment '?X????'
         , Address1 varchar(60) comment '?Z???P'
         , Address2 varchar(60) comment '?Z??2'
         , Address3 varchar(60) comment '?Z??3'
         , PhoneNumber varchar(13) comment '?d?b???'
         , FaxNumber varchar(13) comment 'FAX???'
         , Note varchar(300) comment '???l'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint suppliersmaster_PKC primary key (SuppliersCode)
       ) comment '?d????}?X?^' ;
       -- ?V?X?e???N???m?F?f?[?^
       drop table if exists systemexecute cascade;
       create table systemexecute (
         PrimaryCode tinyint(4) not null comment '?L?[????'
         , TargetDate date not null comment '?N?????t'
         , SystemVersion int(11) not null comment '?{??E????o?[?W????'
         , UpDateCopyVersion int(11) not null comment '?R?s?[?o?[?W????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint systemexecute_PKC primary key (PrimaryCode)
       ) comment '?V?X?e???N???m?F?f?[?^' ;
       -- ????}?X?^
       drop table if exists systemmaster cascade;
       create table systemmaster (
         SystemCode decimal(3,0) unsigned not null comment '???R?[?h'
         , CompanyName1 varchar(60) not null comment '?????P'
         , CompanyName2 varchar(60) comment '?????Q'
         , CEOName varchar(60) not null comment '??\?????'
         , CEOPositionName varchar(60) comment '??\???E??'
         , ZipCode varchar(8) not null comment '?X????'
         , Address1 varchar(60) not null comment '?Z???P'
         , Address2 varchar(60) comment '?Z??2'
         , Address3 varchar(60) comment '?Z??3'
         , PhoneNumber varchar(13) not null comment '?d?b???'
         , FaxNumber varchar(13) comment 'FAX???'
         , HomePageURL varchar(120) comment '?z?[???y?[?WURL'
         , ConsumptionTax decimal(4,2) not null comment '?????'
         , CooperationRate decimal(4,2) not null comment '???????'
         , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'
         , FuelPrice decimal(5,2) not null comment '?R???L???P??'
         , AreaDistance decimal(5,2) not null comment '????u????????'
         , ExcelSavePath varchar(120) comment 'Excel????p?X'
         , BusinessPeriod smallint(6) not null comment '????c?????'
         , ConstrYear smallint(6) not null comment '????H???N?x'
         , BusinessBeginDate datetime not null comment '?c????????'
         , ConstrBeginDate datetime not null comment '?H???N?x?????'
         , BusinessCompDate datetime not null comment '?c?????????'
         , ConstrCompDate datetime not null comment '?H???N?x??????'
         , ConstructionNoBase decimal(1,0) not null comment '?H????????l'
         , SloganString1 varchar(100) comment '?W??1'
         , SloganString2 varchar(100) comment '?W??2'
         , SloganString3 varchar(100) comment '?W??3'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint systemmaster_PKC primary key (SystemCode)
       ) comment '????}?X?^' ;
       -- ?????}?X?^
       drop table if exists termmaster cascade;
       create table termmaster (
         ConstructionStatusFlg decimal(2,0) not null comment '?H?????t???O'
         , FieldNo decimal(2,0) not null comment '?`?F?b?N???t?B?[???h???'
         , SeqNo decimal(2,0) not null comment '?}??'
         , DisplayOrder decimal(2,0) not null comment '?\????'
         , CheckSchdule decimal(1,0) not null comment '?`?F?b?N?^?C?~???O'
         , TermDays decimal(3,0) not null comment '?o???'
         , SendTitile varchar(100) comment '?^?C?g??'
         , SendMessage varchar(100) comment '???b?Z?[?W'
         , BackColor varchar(8) comment '?w?i?F'
         , ForeColor varchar(8) comment '?????F'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint termmaster_PKC primary key (ConstructionStatusFlg,FieldNo,SeqNo)
       ) comment '?????}?X?^' ;
       create index TermMaster_Index1
         on termmaster(DisplayOrder);
       -- ?o?????f?[?^
       drop table if exists tranceportdailydata cascade;
       create table tranceportdailydata (
         PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
         , AttendanceDate date not null comment '???????'
         , StartDistance decimal(7,1) not null comment '?????o???L????'
         , ComplateDistance decimal(7,1) not null comment '?????I???L????'
         , TotalDistance decimal(6,1) not null comment '???????v?L????'
         , OfficeGoFlg decimal(1,0) not null comment '???????o??t???O'
         , OfficeOutFlg decimal(1,0) not null comment '???????A??t???O'
         , TrancePayGoFlg decimal(1,0) not null comment '?L?????o??t???O'
         , TrancePayOutFlg decimal(1,0) not null comment '?L?????A??t???O'
         , WareHouseFlg decimal(1,0) not null comment '????u??t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint tranceportdailydata_PKC primary key (PersonCode,AttendanceDate)
       ) comment '?o?????f?[?^' ;
       create index TranceportDailyData_Index1
         on tranceportdailydata(AttendanceDate);
       -- ?H?????o???}?X?^
       drop table if exists typeexpensesmaster cascade;
       create table typeexpensesmaster (
         TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'
         , ExpensesPeriod smallint(6) not null comment '?????'
         , NameCode decimal(5,0) unsigned not null comment '?o????R?[?h'
         , ExpensesRaito decimal(4,2) not null comment '?o??'
         , DeleteFlg decimal(1,0) not null comment '???t???O'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint typeexpensesmaster_PKC primary key (TypeCode,ExpensesPeriod,NameCode)
       ) comment '?H?????o???}?X?^' ;
       -- ?P??}?X?^
       drop table if exists unitmaster cascade;
       create table unitmaster (
         UnitKey decimal(5,0) unsigned not null comment '?P??L?['
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , UnitName varchar(30) not null comment '?P?????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint unitmaster_PKC primary key (UnitKey)
       ) comment '?P??}?X?^' ;
       create index UnitMaster_Index1
         on unitmaster(DisplayOrder);
       -- ????}?X?^
       drop table if exists vehiclemaster cascade;
       create table vehiclemaster (
         VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'
         , DisplayOrder decimal(5,0) unsigned not null comment '?\????'
         , VehicleName varchar(100) not null comment '???????'
         , RegistrationNumber varchar(30) comment '?o?^???'
         , IdentificationNumber varchar(30) comment '?????'
         , ModelCode varchar(30) comment '?^??'
         , DepartmentCode decimal(5,0) unsigned not null comment '???????'
         , VehicleScheduleFlg decimal(1,0) not null comment '????\??\???t???O'
         , PurchaseDate date comment '?w????'
         , PurchaseName varchar(30) comment '?w????'
         , PurchaseContactPersons varchar(30) comment '?w????S????'
         , PurchasePhone varchar(13) comment '?w????d?b???'
         , LeaseDate date comment '???[?X?J?n??'
         , LeaseDestination varchar(30) comment '???[?X??'
         , LeaseContactPersons varchar(30) comment '???[?X??S????'
         , LeasePhone varchar(13) comment '???[?X??d?b???'
         , InsuranceCompany varchar(30) comment '?C???????'
         , InsuranceContactPersons varchar(30) comment '?C???????S????'
         , InsurancePhone varchar(13) comment '?C???????d?b???'
         , Note varchar(300) comment '???l'
         , EntryDate datetime comment '?o?^???t'
         , UpdateDate datetime comment '?X?V???t'
         , constraint vehiclemaster_PKC primary key (VehicleCode)
       ) comment '????}?X?^' ;
       -- ????L?^?f?[?^
       drop table if exists vehiclerecorddata cascade;
       create table vehiclerecorddata (
         VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'
         , DivisionCode decimal(2,0) unsigned not null comment '?f?[?^??'
         , SeqNo decimal(2,0) not null comment '?}??'
         , RecordDate date comment '???n??'
         , Mileage mediumint(9) comment '???s????'
         , Content varchar(100) comment '???e'
         , PaymentCost decimal(10,0) comment '??p'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint vehiclerecorddata_PKC primary key (VehicleCode,DivisionCode,SeqNo)
       ) comment '????L?^?f?[?^' ;
       -- ????\??f?[?^
       drop table if exists vehiclescheduledata cascade;
       create table vehiclescheduledata (
         TargetDate date not null comment '????'
         , VehicleCode decimal(5,0) unsigned not null comment '????R?[?h'
         , MorningAfternoon decimal(1,0) not null comment '??O?E???'
         , PersonCode decimal(8,0) unsigned not null comment '?S????R?[?h'
         , TargetYear year(4) not null comment '?Y???N'
         , TargetMonth tinyint(3) unsigned not null comment '?Y????'
         , TargetDay year(4) not null comment '?Y????'
         , EntryDate datetime not null comment '?o?^???t'
         , UpdateDate datetime not null comment '?X?V???t'
         , constraint vehiclescheduledata_PKC primary key (TargetDate,VehicleCode,MorningAfternoon)
       ) comment '????\??f?[?^' ;
       create index VehicleScheduleData_Index1
         on vehiclescheduledata(TargetYear);
       create index VehicleScheduleData_Index2
         on vehiclescheduledata(TargetMonth);
       create index VehicleScheduleData_Index3
         on vehiclescheduledata(TargetDay);
       -- ?N?}?X?^
       drop table if exists yearmaster cascade;
       create table yearmaster (
         years smallint(6) not null comment '?N'
         , constraint yearmaster_PKC primary key (years)
       ) comment '?N?}?X?^' ;

プロジェクト

全般

プロフィール

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

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