リビジョン 342
工事詳細台帳経費データ追加
案件新著億データ：キー項目変更・インデックス追加
部署経費マスタ：経費名称追加
担当者給与マスタ：インデックス追加
| ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2018/04/06 11:54:53
|
|
| 2 |
-- Date/Time : 2018/04/12 9:06:32
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 462 | 462 |
, constraint constrchgcharge_PKC primary key (ConstructionCode,Division,SeqNo) |
| 463 | 463 |
) comment '?H???S???????f?[?^' ; |
| 464 | 464 |
|
| 465 |
-- ?H???????o??f?[?^ |
|
| 466 |
drop table if exists constrledgerexpenses cascade; |
|
| 467 |
|
|
| 468 |
create table constrledgerexpenses ( |
|
| 469 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
| 470 |
, SeqNo decimal(5,0) not null comment '?}??' |
|
| 471 |
, NameCode decimal(5,0) unsigned not null comment '?o??R?[?h' |
|
| 472 |
, ExpensesRaito decimal(4,2) not null comment '?o??' |
|
| 473 |
, ExpensesValue decimal(10,0) not null comment '?o????z' |
|
| 474 |
, EntryDate datetime not null comment '?o?^???t' |
|
| 475 |
, UpdateDate datetime not null comment '?X?V???t' |
|
| 476 |
, constraint constrledgerexpenses_PKC primary key (ConstructionCode,SeqNo,NameCode) |
|
| 477 |
) comment '?H???????o??f?[?^' ; |
|
| 478 |
|
|
| 479 |
create index ConstrLedgerExpenses_Index1 |
|
| 480 |
on constrledgerexpenses(ConstructionCode); |
|
| 481 |
|
|
| 482 |
create index ConstrLedgerExpenses_Index2 |
|
| 483 |
on constrledgerexpenses(SeqNo); |
|
| 484 |
|
|
| 485 |
create index ConstrLedgerExpenses_Index3 |
|
| 486 |
on constrledgerexpenses(NameCode); |
|
| 487 |
|
|
| 465 | 488 |
-- ?H????{???
|
| 466 | 489 |
drop table if exists constructionbaseinfo cascade; |
| 467 | 490 |
|
| ... | ... | |
| 788 | 811 |
, ChangePersonCode decimal(8,0) not null comment '???S????' |
| 789 | 812 |
, EntryDate datetime not null comment '?o?^???t' |
| 790 | 813 |
, UpdateDate datetime not null comment '?X?V???t' |
| 791 |
, constraint constructionprogressdate_PKC primary key (ConstructionCode,ConstructionStatusFlg)
|
|
| 814 |
, constraint constructionprogressdate_PKC primary key (ConstructionCode,ChangeDate)
|
|
| 792 | 815 |
) comment '????i?????t?f?[?^' ; |
| 793 | 816 |
|
| 817 |
create index ConstrProg_Index1 |
|
| 818 |
on constructionprogressdate(ConstructionCode); |
|
| 819 |
|
|
| 820 |
create index ConstrProg_Index2 |
|
| 821 |
on constructionprogressdate(ConstructionStatusFlg); |
|
| 822 |
|
|
| 823 |
create index ConstrProg_Index3 |
|
| 824 |
on constructionprogressdate(ChangeDate); |
|
| 825 |
|
|
| 794 | 826 |
-- ???}?X?^ |
| 795 | 827 |
drop table if exists constructionspecmaster cascade; |
| 796 | 828 |
|
| ... | ... | |
| 1068 | 1100 |
create table departmentexpensesmaster ( |
| 1069 | 1101 |
DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h' |
| 1070 | 1102 |
, ExpensesPeriod smallint(6) not null comment '?????' |
| 1071 |
, NameCode decimal(5,0) unsigned not null comment '?o????R?[?h' |
|
| 1103 |
, NameCode decimal(5,0) unsigned not null comment '?o??R?[?h' |
|
| 1104 |
, NameString varchar(100) not null comment '????' |
|
| 1072 | 1105 |
, DisplayOrder decimal(5,0) unsigned not null comment '?\????' |
| 1073 | 1106 |
, ExpensesRaito decimal(4,2) not null comment '?o??' |
| 1074 | 1107 |
, DeleteFlg decimal(1,0) not null comment '???t???O' |
| ... | ... | |
| 1713 | 1746 |
create index PersonSalaryMaster_Index2 |
| 1714 | 1747 |
on personsalarymaster(StartDate); |
| 1715 | 1748 |
|
| 1749 |
create index PersonSalaryMaster_Index3 |
|
| 1750 |
on personsalarymaster(MonthlySalary); |
|
| 1751 |
|
|
| 1716 | 1752 |
-- ?w???????f?[?^ |
| 1717 | 1753 |
drop table if exists pointingoutcomment cascade; |
| 1718 | 1754 |
|
他の形式にエクスポート: Unified diff