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

リビジョン 271

業者請求明細データ行・列カラム追加
支払明細データ、協力金有無の初期値-1に変更
工事施工予算データ、受注金額カラム追加

     -- Project Name : noname
     -- Date/Time    : 2017/07/20 9:53:08
     -- Date/Time    : 2017/09/16 11:05:22
     -- 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 '担当者コード'
       , ActionSchedule varchar(30) comment '行動予定'
       , TargetYear year(4) not null comment '該当年'
       , TargetMonth year(4) not null comment '該当月'
       , TargetDay year(4) not null comment '該当日'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '担当者行動予定データ' ;
     ) comment '?S????s???\??f?[?^' ;
     create index ActionScheduleData_Index1
       on actionscheduledata(TargetYear);
-...
     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 '承認機能番号'
       , DepartmentCode decimal(5,0) unsigned not null comment '部署コード'
       , SeqNo decimal(2,0) not null comment '枝番'
       , DisplayOrder decimal(2,0) not null comment '表示順'
       , ApprovalPerson decimal(8,0) unsigned not null comment '承認者コード'
       , ApprovalAuthority decimal(1,0) not null comment '承認権限区分'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '承認経路マスタ' ;
     ) comment '???F?o?H?}?X?^' ;
     -- 出勤日報データ
     -- ?o?????f?[?^
     drop table if exists attendancedailydata cascade;
     create table attendancedailydata (
       PersonCode decimal(8,0) unsigned not null comment '作成者コード'
       , AttendanceDate date not null comment '日報作成日'
       , SeqNo decimal(3,0) unsigned not null comment '明細行番号'
       , ActionResult varchar(30) not null comment '行動実績'
       , OvertimeHours decimal(4,1) not null comment '残業時間'
       , WorkingComment varchar(120) comment 'コメント'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       PersonCode decimal(8,0) unsigned not null comment '????R?[?h'
       , AttendanceDate date not null comment '???????'
       , SeqNo decimal(3,0) unsigned not null comment '????s???'
       , 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'
       , NightFlg 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 '出勤日報データ' ;
     ) comment '?o?????f?[?^' ;
     create index AttendDaily_Index1
       on attendancedailydata(ActionResult);
-...
     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 '作成者コード'
       , AttendanceMonth date not null comment '出勤管理年月'
       , LastDays decimal(2,0) unsigned not null comment '当月最終日'
       , AttendDayCount decimal(2,0) unsigned not null comment '出勤日数'
       , TotalOverTimes decimal(4,1) not null comment '残業時間数'
       , OrderDate date not null comment '申請日'
       , OrderNo decimal(2,0) unsigned not null comment '申請受付番号'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '出勤管理データ' ;
     ) comment '?o?????f?[?^' ;
     -- 銀行営業日マスタ
     -- ??s?c????}?X?^
     drop table if exists bankbusinessdaymaster cascade;
     create table bankbusinessdaymaster (
       YEARMONTH decimal(6,0) default '0' not null comment '年月'
       , BANKBUSINESSDAY decimal(2,0) default '0' not null comment '銀行営業日'
       , NOTE varchar(120) comment '備考'
       , DELETEFLG decimal(1,0) comment '削除フラグ'
       , ENTRYDATE datetime comment '登録年月日'
       , UPDATEDATE datetime comment '更新年月日'
       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 '銀行営業日マスタ' ;
     ) comment '??s?c????}?X?^' ;
     -- 業者請求データ
     -- ???????f?[?^
     drop table if exists billingdata cascade;
     create table billingdata (
       COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード'
       , TARGETDATE decimal(6,0) default '0' not null comment '対象年月'
       , SEQNO decimal(3,0) default '0' not null comment '連番'
       , BILLPRICE decimal(10,0) comment '請求金額'
       , ENTRYDATE datetime comment '登録年月日'
       , UPDATEDATE datetime comment '更新年月日'
       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 '業者請求データ' ;
     ) comment '???????f?[?^' ;
     -- 業者請求明細データ
     -- ??????????f?[?^
     drop table if exists billingdatadetail cascade;
     create table billingdatadetail (
       COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード'
       , TARGETDATE decimal(6,0) default '0' not null comment '対象年月'
       , SEQNO decimal(3,0) default '0' not null comment '連番'
       , LINECOUNT decimal(3,0) default '0' not null comment '行番号'
       , CONSTRUCTIONCODE decimal(10,0) comment '工事番号'
       , FIELDNAME varchar(120) comment '現場名'
       , BILLPRICE decimal(10,0) comment '請求金額'
       , HIGHWPRICE decimal(10,0) comment '高速代'
       , HARDWPRICE decimal(10,0) comment '金物代'
       , INDSWASTETAX decimal(10,0) comment '産廃税'
       , NOTE varchar(120) comment '備考'
       , ENTRYDATE datetime comment '登録年月日'
       , UPDATEDATE datetime comment '更新年月日'
       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 '業者請求明細データ' ;
     ) comment '??????????f?[?^' ;
     -- 業者請求支払サマリーデータ
     -- ???????x???T?}???[?f?[?^
     drop table if exists billingpaymentsummary cascade;
     create table billingpaymentsummary (
       COMPANYCODE decimal(8,0) default '0' not null comment '協力会社コード'
       , TARGETDATE decimal(6,0) default '0' not null comment '対象年月'
       , CHARGEPAYMENTKIND decimal(1,0) default '0' not null comment '請求支払区分'
       , PAYDAY date comment '支払日'
       , BILLPRICESTOTAL decimal(10,0) comment '請求金額小計'
       , CONSUMPTIONTAXRATE decimal(6,3) comment '消費税率'
       , CONSUMPTIONTAXPRICE decimal(10,0) comment '消費税額'
       , HIGHWPRICESTOTAL decimal(10,0) comment '高速代小計'
       , HARDWPRICESTOTAL decimal(10,0) comment '金物代小計'
       , INDSWASTETAXSTOTAL decimal(10,0) comment '産廃税小計'
       , CNSTRPRICERATE decimal(6,3) comment '協力金比率'
       , CNSTRPRICESTOTAL decimal(10,0) comment '協力金小計'
       , BILLINGPRICETOTAL decimal(10,0) comment '請求金額合計'
       , ENTRYDATE datetime comment '登録年月日'
       , UPDATEDATE datetime comment '更新年月日'
       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 '業者請求支払サマリーデータ' ;
     ) comment '???????x???T?}???[?f?[?^' ;
     -- 工事詳細台帳データ【退避用】
     -- ?H???????f?[?^?y???p?z
     drop table if exists bk_constructionledger cascade;
     create table bk_constructionledger (
       ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , ConstructionPeriod decimal(4,0) unsigned not null comment '事業期'
       , CreatorCode decimal(8,0) comment '作成者コード'
       , CreatorName varchar(60) comment '作成者名'
       , CreateDate date not null comment '作成日'
       , ConstructionTimes decimal(5,2) not null comment '工期（単位・月）'
       , ConstructionStart date not null comment '契約工期開始'
       , ConstructionEnd date not null comment '契約工期完了'
       , OrdersDecisionPrice decimal(14,0) not null comment '税抜受注決定金額'
       , CompanyExpenses decimal(10,0) not null comment '会社経費合計'
       , DepartmentExpenses decimal(10,0) not null comment '部署経費合計'
       , SalesExpenses decimal(10,0) not null comment '営業経費合計'
       , TotalPayment decimal(10,0) not null comment '総支払額'
       , GrossProfit decimal(10,0) not null comment '粗利'
       , Allowance decimal(10,0) not null comment '給与'
       , NetProfit decimal(10,0) not null comment '純利益'
       , ComplateFlg decimal(1,0) not null comment '入力完了フラグ'
       , IntegrationFlg decimal(1,0) not null comment '受注金額積算フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事詳細台帳データ【退避用】' ;
     ) 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 '工事コード'
       , GroupCount decimal(2,0) unsigned not null comment 'グループ番号'
       , LineCount decimal(5,0) unsigned not null comment '行番号'
       , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , FirstString varchar(120) comment '項目名称'
       , SecondString varchar(120) comment '工事内容'
       , CompanyType decimal(1,0) not null comment '協力会社コードタイプ'
       , CompanyCode decimal(8,0) not null comment '協力会社コード'
       , CompanyName varchar(120) comment '協力会社名称'
       , EstimatePrice decimal(12,0) not null comment '予算（見積）金額'
       , ExecutionAmount decimal(12,0) not null comment '実行金額'
       , AmountConfigRate decimal(5,2) not null comment '金額構成率'
       , PaymentBurden decimal(12,0) not null comment '支払補填額'
       , FixDataFlg decimal(1,0) not null comment '固定データフラグ'
       , IndependentFlg decimal(1,0) not null comment '独立データフラグ'
       , FluctuationFlg decimal(1,0) not null comment '増減データフラグ'
       , SalaryFlg decimal(1,0) not null comment '給与振分区分'
       , SalaryDays decimal(4,0) not null comment '給与振分日数'
       , OperatingFlg decimal(1,0) not null comment '担当中フラグ'
       , SourceCode decimal(10,0) unsigned not null comment '元工事番号'
       , JoinTitleFlg decimal(1,0) not null comment '工事名称タイトル'
       , SalaryOnRegist decimal(12,0) not null comment '登録時月額給与'
       , PurchaseOrderFlg decimal(2,0) not null comment '注文書発行フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事詳細台帳明細データ【退避用】' ;
     ) 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 '工事コード'
       , GroupCount decimal(2,0) unsigned not null comment 'グループ番号'
       , LineCount decimal(5,0) unsigned not null comment '行番号'
       , ColumnCount decimal(3,0) not null comment '列番号'
       , PaymentAmount decimal(12,0) not null comment '支払金額'
       , TargetMonth date not null comment '対象年月'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事詳細台帳実行データ【退避用】' ;
     ) 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 '退避日付'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , LineCount decimal(3,0) unsigned not null comment '行番号'
       , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , FixedItemCode varchar(1) comment '固定項目キー'
       , ItemName varchar(120) comment '作業名称'
       , SpecName varchar(120) comment '作業／品質・形状・寸法'
       , PriceValue decimal(14,0) not null comment '金額'
       , note varchar(60) comment '備考'
       , MyExpensesFlg decimal(1,0) not null comment '自社経費フラグ'
       , InputFlg decimal(1,0) not null comment '入力フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '積算見積データ【退避用】' ;
     ) 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 '退避日付'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , PageCount decimal(4,0) unsigned not null comment 'ページ番号'
       , Category decimal(1,0) not null comment 'ページ区分'
       , UnionComponentCode decimal(5,0) unsigned not null comment '所属構成キー'
       , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , SelectComponent decimal(5,0) unsigned not null comment '選択構成キー'
       , PageTitle varchar(120) not null comment 'ページ表示名'
       , DetailLineCount decimal(3,0) unsigned not null comment '明細行番号'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '積算見積ページデータ【退避用】' ;
     ) 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 '退避日付'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , PageCount decimal(4,0) unsigned not null comment 'ページ番号'
       , LineCount decimal(3,0) unsigned not null comment '行番号'
       , DataType decimal(1,0) not null comment 'データ種別'
       , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , SpecCode decimal(5,0) unsigned not null comment '作業キー'
       , ItemName varchar(120) comment '作業名称'
       , SpecName varchar(120) comment '作業／品質・形状・寸法'
       , Unitcount decimal(8,2) not null comment '数量'
       , UnitName varchar(30) comment '単位名称'
       , UnitPrice decimal(9,2) not null comment '単価'
       , LineTotal decimal(12,0) not null comment '金額'
       , note varchar(60) comment '備考'
       , CompanyCode decimal(8,0) not null comment '協力会社コード'
       , MyExpensesFlg decimal(1,0) not null comment '自社経費フラグ'
       , InputFlg decimal(1,0) comment '入力フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '積算見積データ明細【退避用】' ;
     ) comment '??Z????f?[?^????y???p?z' ;
     -- 法人格マスタ
     -- ?@?l?i?}?X?^
     drop table if exists businesstypemaster cascade;
     create table businesstypemaster (
       BusinessTypeCode decimal(5,0) unsigned not null comment '法人格コード'
       , DisplayOrder decimal(5,0) unsigned not null comment '表示順'
       , BusinessTypeName varchar(100) not null comment '業種名'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '法人格マスタ' ;
     ) comment '?@?l?i?}?X?^' ;
     create index BusinessTypeMaster_Index1
       on businesstypemaster(DisplayOrder);
     -- 共通費大項目マスタ
     -- ????????}?X?^
     drop table if exists commoncostlarge cascade;
     create table commoncostlarge (
       LargeCode decimal(5,0) unsigned not null comment '大項目キー'
       , 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 '削除フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '共通費大項目マスタ' ;
     ) comment '????????}?X?^' ;
     -- 共通費工種関連マスタ
     -- ?????H???A?}?X?^
     drop table if exists commoncostlinkms cascade;
     create table commoncostlinkms (
       LargeCode decimal(5,0) unsigned not null comment '大項目キー'
       , MiddleCode decimal(5,0) unsigned not null comment '中項目キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , EntryDate datetime comment '登録日付'
       , UpdateDate datetime comment '更新日付'
       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 '共通費工種関連マスタ' ;
     ) comment '?????H???A?}?X?^' ;
     -- 共通費中項目マスタ
     -- ?????????}?X?^
     drop table if exists commoncostmiddle cascade;
     create table commoncostmiddle (
       LargeCode decimal(5,0) unsigned not null comment '大項目キー'
       , MiddleCode decimal(5,0) unsigned not null comment '中項目キー'
       , 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 '削除フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '共通費中項目マスタ' ;
     ) comment '?????????}?X?^' ;
     -- 共通費中項目キーマスタ
     -- ?????????L?[?}?X?^
     drop table if exists commoncostmiddlesearchword cascade;
     create table commoncostmiddlesearchword (
       LargeCode decimal(5,0) unsigned not null comment '大項目キー'
       , MiddleCode decimal(5,0) unsigned not null comment '中項目キー'
       , SeqNo decimal(5,0) unsigned not null comment '順序'
       , SearchWord varchar(50) not null comment '検索項目'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '共通費中項目キーマスタ' ;
     ) comment '?????????L?[?}?X?^' ;
     -- 構成工種関連マスタ
     -- ?\???H???A?}?X?^
     drop table if exists componentlinkmaster cascade;
     create table componentlinkmaster (
       ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , DisplayOrder decimal(5,0) unsigned comment '表示順'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '構成工種関連マスタ' ;
     ) 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 '構成キー'
       , DisplayOrder decimal(5,0) unsigned not null comment '表示順'
       , ComponentName varchar(120) not null comment '構成名称'
       , SubItemsFlg decimal(1,0) comment '下位項目フラグ'
       , DirectInputFlg decimal(1,0) comment '直接入力フラグ'
       , MyExpensesFlg decimal(1,0) comment '自社経費フラグ'
       , DeleteFlg decimal(1,0) not null comment '削除フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '構成マスタ' ;
     ) 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 '構成キー'
       , TypeCode decimal(5,0) unsigned not null comment '工事種別コード'
       , Dummy decimal(1,0) not null comment 'ダミー項目'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '構成工事種別関連マスタ' ;
     ) comment '?\???H??????A?}?X?^' ;
     create index ComponentToTypeMaster_Index1
       on componenttotypemaster(ComponentCode);
-...
     create index ComponentToTypeMaster_Index2
       on componenttotypemaster(TypeCode);
     -- 工事基本情報
     -- ?H????{???
     drop table if exists constructionbaseinfo cascade;
     create table constructionbaseinfo (
       ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , TyingFlg decimal(1,0) not null comment '紐付データフラグ'
       , JoinFlg decimal(1,0) not null comment '結合契約工事フラグ'
       , ConstructionYear smallint(5) unsigned not null comment '工事年度'
       , ConstructionPeriod smallint(5) unsigned not null comment '工事期数'
       , RequestedDate date comment '依頼受け日'
       , EstimatesSubmitDeadline date comment '見積提出期限'
       , EstimatesSubmittedDate date comment '見積提出日'
       , ProvisionalOrderDate date comment '仮受注日'
       , OrderDate date comment '受注日'
       , OrderStartingDate date comment '開始予定日'
       , OrderCompletionDate date comment '完了予定日'
       , PreparationStartDate date comment '施工準備開始日'
       , ConstructionStartingDate date comment '施工開始日'
       , ConstructionCompletionDate date comment '施工完了日'
       , NonOrderDate date comment '非受注日'
       , OrdersDecisionPrice decimal(12,0) not null comment '税抜受注決定金額'
       , OrdersDecisionPriceInTax decimal(12,0) not null comment '税込受注決定金額'
       , SalesPersonCode decimal(8,0) comment '営業担当者名'
       , ConstructionPersonCode decimal(8,0) not null comment '工事担当者'
       , ConstrSubPersonCode decimal(8,0) not null comment '工事副担当者'
       , ConstructionInstructor decimal(8,0) not null comment '工事指導員'
       , TransferConstruction decimal(8,0) not null comment '工事移管先コード'
       , TransferConstructionDate date comment '工事移管日'
       , OrderersDivision decimal(5,0) not null comment '発注者区分'
       , OrderersCode decimal(5,0) unsigned not null comment '発注者コード'
       , EstimatesExpirationDate date comment '見積有効期限'
       , ConstructionPeriodStart date comment '契約工期開始日'
       , ConstructionPeriodEnd date comment '契約工期完了'
       , ConstructionPeriodStart2 date comment '契約工期開始（延長時）'
       , ConstructionPeriodEnd2 date comment '契約工期完了（延長時）'
       , StartDate date comment '工事開始日'
       , EndDate date comment '工事終了日'
       , PurchaseOrderMailingDate date comment '注文書郵送日'
       , PurchaseOrderReturnDate date comment '注文書返送日'
       , PurchaseOrderReturnCheckDate date comment '注文書返送確認日'
       , ConsumptionTaxFlg decimal(1,0) not null comment '消費税フラグ'
       , PrimeContractorFlg decimal(1,0) not null comment '元請フラグ'
       , SalesCostFlg decimal(1,0) not null comment '営業経費発生フラグ'
       , ConstructionStatusFlg decimal(2,0) not null comment '工事状態フラグ'
       , ConstructionType decimal(5,0) not null comment '工事種別コード'
       , EstimateType decimal(1,0) not null comment '見積種別'
       , BillingStartDate date not null comment '請求準備開始日'
       , BillingDate date not null comment '請求日'
       , BillingSplitFlg decimal(1,0) not null comment '請求回数フラグ'
       , BillingSendDate date comment '請求書郵送/手渡し日'
       , LedgerComplateDate date not null comment '工事詳細台帳入力完了日付'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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'
       , SalesPersonCode decimal(8,0) comment '?c??S?????'
       , ConstructionPersonCode decimal(8,0) not null comment '?H???S????'
       , ConstrSubPersonCode decimal(8,0) not null comment '?H?????S????'
       , ConstructionInstructor decimal(8,0) not null comment '?H???w????'
       , TransferConstruction decimal(8,0) not null comment '?H??????R?[?h'
       , TransferConstructionDate date comment '?H??????'
       , OrderersDivision decimal(5,0) not null comment '???????'
       , 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'
       , EntryDate datetime not null comment '?o?^???t'
       , UpdateDate datetime not null comment '?X?V???t'
       , constraint constructionbaseinfo_PKC primary key (ConstructionCode)
     ) comment '工事基本情報' ;
     ) comment '?H????{???' ;
     create index BaseInfo_Index1
       on constructionbaseinfo(ConstructionStatusFlg);
-...
     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 '工事コード'
       , DetailNo decimal(2,0) not null comment '明細番号'
       , DetailString varchar(120) comment '明細内容'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'
       , DetailNo decimal(2,0) not null comment '??????'
       , DetailString varchar(120) 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 '工事基本情報明細' ;
     ) 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 '工事コード'
       , CreatorCode decimal(8,0) not null comment '作成者コード'
       , CreatorName varchar(60) comment '作成者名'
       , CreatorCosts decimal(11,0) not null comment '作成者給与'
       , AssistantCode decimal(8,0) not null comment '副担当者コード'
       , AssistantName varchar(60) comment '副担当者名'
       , AssistantCosts decimal(11,0) not null comment '副担当者給与'
       , InstructorCode decimal(8,0) not null comment '工事指導員コード'
       , InstructorName varchar(60) comment '工事指導員名'
       , InstructorCosts decimal(11,0) not null comment '工事指導員給与'
       , CreateDate date not null comment '作成日'
       , ConstructionTimes decimal(5,2) not null comment '工期（単位・月）'
       , ConstructionStart date not null comment '契約工期開始'
       , ConstructionEnd date not null comment '契約工期完了'
       , InstructorTimes decimal(5,2) not null comment '指導員稼働月数'
       , SalaryFlg decimal(1,0) not null comment '給与振分区分'
       , SalaryDays decimal(4,0) not null comment '振分日数'
       , A_SalaryFlg decimal(1,0) not null comment '副担当者給与振分区分'
       , A_SalaryDays decimal(4,0) not null comment '副担当者振分日数'
       , I_SalaryFlg decimal(1,0) not null comment '指導員給与振分区分'
       , I_SalaryDays decimal(4,0) not null comment '指導員振分日数'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事施工予算データ' ;
     ) 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 '工事コード'
       , GroupCount decimal(2,0) unsigned not null comment 'グループ番号'
       , LineCount decimal(3,0) unsigned not null comment '行番号'
       , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , FirstString varchar(120) comment '項目名称'
       , SecondString varchar(120) comment '工事内容'
       , CompanyType decimal(1,0) not null comment '協力会社コードタイプ'
       , CompanyCode decimal(8,0) not null comment '協力会社コード'
       , CompanyName varchar(120) comment '協力会社名称'
       , EstimatePrice decimal(12,0) not null comment '積算時見積金額'
       , NegotiationPrice decimal(12,0) not null comment '積算時交渉金額'
       , OrderDesiredAmount decimal(12,0) not null comment '発注希望金額'
       , ExecutionAmount decimal(12,0) not null comment '実行金額'
       , AmountConfigRate decimal(5,2) not null comment '金額構成率'
       , NegotiateFlg decimal(1,0) not null comment '協力業者交渉フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事施工予算データ明細' ;
     ) comment '?H???{?H?\?Z?f?[?^????' ;
     -- 工種マスタ
     -- ?H??}?X?^
     drop table if exists constructionitemmaster cascade;
     create table constructionitemmaster (
       ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , DisplayOrder decimal(5,0) unsigned not null comment '表示順'
       , ItemName varchar(120) not null comment '工種名称'
       , SubItemsFlg decimal(1,0) comment '下位項目フラグ'
       , MyExpensesFlg decimal(1,0) not null comment '自社経費フラグ'
       , DeleteFlg decimal(1,0) not null comment '削除フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工種マスタ' ;
     ) comment '?H??}?X?^' ;
     -- 工事詳細台帳データ
     -- ?H???????f?[?^
     drop table if exists constructionledger cascade;
     create table constructionledger (
       ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , ConstructionPeriod decimal(4,0) unsigned not null comment '事業期'
       , CreatorCode decimal(8,0) comment '作成者コード'
       , CreatorName varchar(60) comment '作成者名'
       , CreateDate date not null comment '作成日'
       , ConstructionTimes decimal(5,2) not null comment '工期（単位・月）'
       , ConstructionStart date not null comment '契約工期開始'
       , ConstructionEnd date not null comment '契約工期完了'
       , OrdersDecisionPrice decimal(14,0) not null comment '税抜受注決定金額'
       , CompanyExpenses decimal(10,0) not null comment '会社経費合計'
       , DepartmentExpenses decimal(10,0) not null comment '部署経費合計'
       , SalesExpenses decimal(10,0) not null comment '営業経費合計'
       , TotalPayment decimal(10,0) not null comment '総支払額'
       , GrossProfit decimal(10,0) not null comment '粗利'
       , Allowance decimal(10,0) not null comment '給与'
       , NetProfit decimal(10,0) not null comment '純利益'
       , ComplateFlg decimal(1,0) not null comment '入力完了フラグ'
       , IntegrationFlg decimal(1,0) not null comment '受注金額積算フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事詳細台帳データ' ;
     ) comment '?H???????f?[?^' ;
     -- 工事詳細台帳明細データ
     -- ?H??????????f?[?^
     drop table if exists constructionledgerdetail cascade;
     create table constructionledgerdetail (
       ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , GroupCount decimal(2,0) unsigned not null comment 'グループ番号'
       , LineCount decimal(3,0) unsigned not null comment '行番号'
       , ComponentCode decimal(5,0) unsigned not null comment '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , FirstString varchar(120) comment '項目名称'
       , SecondString varchar(120) comment '工事内容'
       , CompanyType decimal(1,0) not null comment '協力会社コードタイプ'
       , CompanyCode decimal(8,0) not null comment '協力会社コード'
       , CompanyName varchar(120) comment '協力会社名称'
       , EstimatePrice decimal(12,0) not null comment '予算（見積）金額'
       , ExecutionAmount decimal(12,0) not null comment '実行金額'
       , AmountConfigRate decimal(5,2) not null comment '金額構成率'
       , PaymentBurden decimal(12,0) not null comment '支払補填額'
       , FixDataFlg decimal(1,0) not null comment '固定データフラグ'
       , IndependentFlg decimal(1,0) not null comment '独立データフラグ'
       , FluctuationFlg decimal(1,0) not null comment '増減データフラグ'
       , SalaryFlg decimal(1,0) not null comment '給与振分区分'
       , SalaryDays decimal(4,0) not null comment '給与振分日数'
       , OperatingFlg decimal(1,0) not null comment '担当中フラグ'
       , SourceCode decimal(10,0) unsigned not null comment '元工事番号'
       , JoinTitleFlg decimal(1,0) not null comment '工事名称タイトル'
       , SalaryOnRegist decimal(12,0) not null comment '登録時月額給与'
       , PurchaseOrderFlg decimal(2,0) not null comment '注文書発行フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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?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 constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)
     ) comment '工事詳細台帳明細データ' ;
     ) comment '?H??????????f?[?^' ;
     create index LedgerDetail_Index01
       on constructionledgerdetail(ConstructionCode);
-...
     create index LedgerDetail_Index03
       on constructionledgerdetail(SourceCode);
     -- 工事詳細台帳実行データ
     -- ?H?????????s?f?[?^
     drop table if exists constructionledgerexcute cascade;
     create table constructionledgerexcute (
       ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , GroupCount decimal(2,0) unsigned not null comment 'グループ番号'
       , LineCount decimal(3,0) unsigned not null comment '行番号'
       , ColumnCount decimal(3,0) not null comment '列番号'
       , PaymentAmount decimal(12,0) not null comment '支払金額'
       , TargetMonth date not null comment '対象年月'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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???'
       , 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 '工事詳細台帳実行データ' ;
     ) 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 '工事コード'
       , FluctuationCode decimal(10,0) not null comment '子工事番号'
       , LinkType decimal(1,0) not null comment 'リンク種別'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '工事リンク情報' ;
     ) comment '?H???????N???' ;
     create index ConstructionLink_Index1
       on constructionlink(ConstructionCode);
-...
     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 '工事番号'
       , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '資材品目コード'
       , RENTCOUNT smallint(5) unsigned comment '貸出数'
       , REPAYCOUNT smallint(5) unsigned comment '返却数'
       , COMPLETEFLG tinyint(3) unsigned comment '完了フラグ'
       , ENTRYDATE datetime comment '登録日付'
       , UPDATEDATE datetime comment '更新日付'
       CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'
       , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'
       , RENTCOUNT smallint(5) unsigned comment '??o??'
       , REPAYCOUNT smallint(5) unsigned comment '??p??'
       , 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)
     ) comment '工事資材情報' ;
     ) comment '?H????????' ;
     -- 案件進捗日付データ
     -- ????i?????t?f?[?^
     drop table if exists constructionprogressdate cascade;
     create table constructionprogressdate (
       ConstructionCode decimal(10,0) not null comment '工事番号'
       , ConstructionStatusFlg decimal(2,0) not null comment '設定工事状態'
       , PreviousStatusFlg decimal(2,0) comment '変更前状態'
       , ChangeDate datetime not null comment '設定日付'
       , ChangePersonCode decimal(8,0) not null comment '設定担当者'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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,ConstructionStatusFlg)
     ) comment '案件進捗日付データ' ;
     ) comment '????i?????t?f?[?^' ;
     -- 作業マスタ
     -- ???}?X?^
     drop table if exists constructionspecmaster cascade;
     create table constructionspecmaster (
       ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , SpecCode decimal(5,0) unsigned not null comment '作業キー'
       , DisplayOrder decimal(5,0) unsigned not null comment '表示順'
       , ItemName varchar(120) comment '作業名称'
       , SpecName varchar(120) comment '作業名称'
       , UnitName varchar(30) comment '単位名称'
       , UnitPrice decimal(9,2) not null comment '単価'
       , DeleteFlg decimal(1,0) not null comment '削除フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '作業マスタ' ;
     ) 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 '構成キー'
       , ItemCode decimal(5,0) unsigned not null comment '工種キー'
       , SpecCode decimal(5,0) unsigned not null comment '作業キー'
       , ConstructionTypeCode mediumint(8) unsigned not null comment '工事種別コード'
       , UnitPrice decimal(9,2) not null comment '単価'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '作業単価マスタ' ;
     ) comment '???P???}?X?^' ;
     -- 工事種別マスタ
     -- ?H?????}?X?^
     drop table if exists constructiontypemaster cascade;
     create table constructiontypemaster (
       TypeCode decimal(5,0) unsigned not null comment '工事種別コード'
       , DisplayOrder decimal(5,0) unsigned not null comment '表示順'
       , NameString varchar(100) not null comment '名称'
       , PublicFlg decimal(1,0) not null comment '工事種別フラグ'
       , SecRank decimal(1,0) not null comment '保護区分ランク'
       , ExpensesLink decimal(1,0) not null comment '経費使用区分'
       , DeleteFlg decimal(1,0) not null comment '削除フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '?H?????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 '工事種別マスタ' ;
     ) comment '?H?????}?X?^' ;
     -- 担当者毎経費データ
     -- ?S??????o??f?[?^
     drop table if exists costdataofperson cascade;
     create table costdataofperson (
       PersonCode decimal(8,0) unsigned not null comment '担当者コード'
       , ActionDate date not null comment '対象日付'
       , DataType decimal(1,0) not null comment 'データ区分'
       , DataAddCount decimal(5,0) unsigned not null comment 'データ追加番号'
       , TargetMonth varchar(7) not null comment '対象年月'
       , ConstructionCode decimal(10,0) unsigned comment '工事コード'
       , SuppliersCode decimal(5,0) unsigned not null comment '支払先コード'
       , SuppliersName varchar(120) comment '支払先名称'
       , PaymentContent varchar(60) comment '支払内容'
       , PaymentType decimal(1,0) not null comment '支払方法フラグ'
       , EntryPrice decimal(12,0) not null comment '金額（税抜）'
       , EntryPriceInTax decimal(12,0) not null comment '金額（税込）'
       , SlipNumber varchar(12) comment '伝票番号'
       , ComplateFlg decimal(1,0) not null comment '引込済みフラグ'
       , ApprovalFlg decimal(1,0) not null comment '承認フラグ'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '担当者毎経費データ' ;
     ) 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 (
       PersonCode decimal(8,0) unsigned not null comment '申請者番号'
       , CreateDate date not null comment '作成日'
       , SeqNo decimal(2,0) not null comment 'キー連番'
       , DataMode decimal(1,0) not null comment 'データ区分'
       , SourceCotegory decimal(5,0) unsigned not null comment '発注者区分'
       , SourceCode decimal(5,0) unsigned not null comment '発注者コード'
       , PetitionPeriod decimal(4,0) unsigned not null comment '事業期'
       , OrderFlg decimal(1,0) not null comment '法人団体・個人フラグ'
       , CorporateStatusName varchar(100) comment '法人格名称'
       , CorporateStatusPoint decimal(1,0) comment '法人格名称位置'
       , OrderersName1 varchar(60) not null comment '発注者名1'
       , OrderersName2 varchar(60) comment '発注者名２'
       , DepartmentName varchar(60) comment '部署名'
       , ChargePersonName varchar(60) comment '担当者名'
       , ZipCode varchar(8) comment '郵便番号'
       , Address1 varchar(60) comment '住所１'
       , Address2 varchar(60) comment '住所2'
       , Address3 varchar(60) comment '住所3'
       , PhoneNumber varchar(13) comment '電話番号'
       , FaxNumber varchar(13) comment 'FAX番号'
       , MailAddress varchar(257) comment 'メールアドレス'
       , Note varchar(300) comment '備考'
       , OrderCotegory decimal(5,0) unsigned not null comment '発注者区分'
       , OrderDate date not null comment '申請日'
       , OrderNo decimal(2,0) unsigned not null comment '申請受付番号'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       PersonCode 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 '??????'
       , 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'
       , OrderCotegory decimal(5,0) unsigned not null comment '???????'
       , 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 costomerregist_PKC primary key (PersonCode,CreateDate,SeqNo)
     ) comment '発注者登録申請データ' ;
     ) comment '??????o?^?\???f?[?^' ;
     create index CostomerRegist_Index1
       on costomerregist(PetitionPeriod);
     -- 日報データ
     -- ????f?[?^
     drop table if exists dailydataconstruction cascade;
     create table dailydataconstruction (
       PersonCode decimal(8,0) unsigned not null comment '担当者コード'
       , DailyDataDate date not null comment '日報作成日'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , Weather varchar(60) comment '天気'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '日報データ' ;
     ) comment '????f?[?^' ;
     create index DailyDataConstruction_Index1
       on dailydataconstruction(PersonCode);
-...
     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 '担当者コード'
       , DailyDataDate date not null comment '日報作成日'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , SeqNo decimal(3,0) unsigned not null comment '明細行番号'
       , JobCategoryCode decimal(5,0) not null comment '職種キー'
       , CompanyCode decimal(8,0) not null comment '協力会社コード'
       , TodayHeadCount decimal(4,1) not null comment '当日人員数'
       , TotalHeadCount decimal(5,1) not null comment '累計人員数'
       , TodayWork varchar(100) comment '当日作業内容'
       , NextdayWork varchar(100) comment '翌日作業内容'
       , NextdayHeadCount decimal(4,1) not null comment '翌日人員数'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '日報データ (明細)' ;
     ) 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 '作成者コード'
       , DailyDataDate date not null comment '日報作成日'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , SeqNo decimal(3,0) unsigned not null comment '明細行番号'
       , PatrolTime datetime not null comment '巡回時間'
       , ContentsText varchar(200) comment '内容'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '日報データ (現場巡回)' ;
     ) 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 '作成者コード'
       , DailyDataDate date not null comment '日報作成日'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , SeqNo decimal(3,0) unsigned not null comment '明細行番号'
       , Materials varchar(100) comment '資材名'
       , Quantity varchar(100) comment '数量'
       , Production varchar(100) comment '制作会社'
       , Delivery varchar(100) comment '納入業者'
       , QualityControl varchar(100) comment '品質管理事項'
       , EntryDate datetime not null comment '登録日付'
       , UpdateDate datetime not null comment '更新日付'
       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 '日報データ (資材)' ;
     ) 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 '作成者コード'
       , DailyDataDate date not null comment '日報作成日'
       , ConstructionCode decimal(10,0) unsigned not null comment '工事コード'
       , SeqNo decimal(3,0) unsigned not null comment '明細行番号'

... 差分の行数が表示可能な上限を超えました。超過分は表示しません。

他の形式にエクスポート: Unified diff

プロジェクト

全般

プロフィール

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

リビジョン 271