リビジョン 406
工事種別・構成関連マスタ変更
種別・構成単価マスタ変更
管理マスタフラグ追加
| ProcessManagement.sql | ||
|---|---|---|
| 1 | 1 |
-- Project Name : noname |
| 2 |
-- Date/Time : 2018/08/06 8:37:19
|
|
| 2 |
-- Date/Time : 2018/09/20 10:20:05
|
|
| 3 | 3 |
-- Author : Horiuchi |
| 4 | 4 |
-- RDBMS Type : MySQL |
| 5 | 5 |
-- Application : A5:SQL Mk-2 |
| ... | ... | |
| 516 | 516 |
create index ComponentMaster_Index1 |
| 517 | 517 |
on componentmaster(DisplayOrder); |
| 518 | 518 |
|
| 519 |
-- ?\???H??????A?}?X?^
|
|
| 519 |
-- ?H?????E?\???????N?}?X?^
|
|
| 520 | 520 |
--* BackupToTempTable |
| 521 | 521 |
drop table if exists componenttotypemaster cascade; |
| 522 | 522 |
|
| 523 | 523 |
--* RestoreFromTempTable |
| 524 | 524 |
create table componenttotypemaster ( |
| 525 |
ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
|
|
| 526 |
, TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'
|
|
| 527 |
, Dummy decimal(1,0) not null comment '?_?~?[????'
|
|
| 525 |
TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'
|
|
| 526 |
, ComponentCode decimal(5,0) unsigned not null comment '?\???L?['
|
|
| 527 |
, DisplayOrder decimal(5,0) unsigned not null comment '?\????'
|
|
| 528 | 528 |
, EntryDate datetime not null comment '?o?^???t' |
| 529 | 529 |
, UpdateDate datetime not null comment '?X?V???t' |
| 530 |
, constraint componenttotypemaster_PKC primary key (ComponentCode,TypeCode)
|
|
| 531 |
) comment '?\???H??????A?}?X?^' ;
|
|
| 530 |
, constraint componenttotypemaster_PKC primary key (TypeCode,ComponentCode)
|
|
| 531 |
) comment '?H?????E?\???????N?}?X?^' ;
|
|
| 532 | 532 |
|
| 533 | 533 |
create index ComponentToTypeMaster_Index1 |
| 534 |
on componenttotypemaster(ComponentCode);
|
|
| 534 |
on componenttotypemaster(TypeCode);
|
|
| 535 | 535 |
|
| 536 | 536 |
create index ComponentToTypeMaster_Index2 |
| 537 |
on componenttotypemaster(TypeCode);
|
|
| 537 |
on componenttotypemaster(ComponentCode);
|
|
| 538 | 538 |
|
| 539 | 539 |
-- ?H???????o??f?[?^ |
| 540 | 540 |
--* BackupToTempTable |
| ... | ... | |
| 949 | 949 |
|
| 950 | 950 |
--* RestoreFromTempTable |
| 951 | 951 |
create table constructionspecunitprice ( |
| 952 |
ComponentCode decimal(5,0) unsigned not null comment '?\???L?[' |
|
| 952 |
ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h' |
|
| 953 |
, ComponentCode decimal(5,0) unsigned not null comment '?\???L?[' |
|
| 953 | 954 |
, ItemCode decimal(5,0) unsigned not null comment '?H??L?[' |
| 954 | 955 |
, SpecCode decimal(5,0) unsigned not null comment '???L?[' |
| 955 |
, ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h' |
|
| 956 | 956 |
, UnitPrice decimal(9,2) not null comment '?P??' |
| 957 | 957 |
, EntryDate datetime not null comment '?o?^???t' |
| 958 | 958 |
, UpdateDate datetime not null comment '?X?V???t' |
| 959 |
, constraint constructionspecunitprice_PKC primary key (ComponentCode,ItemCode,SpecCode,ConstructionTypeCode)
|
|
| 959 |
, constraint constructionspecunitprice_PKC primary key (ConstructionTypeCode,ComponentCode,ItemCode,SpecCode)
|
|
| 960 | 960 |
) comment '???P???}?X?^' ; |
| 961 | 961 |
|
| 962 |
create index constructionspecunitprice_Index1 |
|
| 963 |
on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode); |
|
| 964 |
|
|
| 962 | 965 |
-- ?H?????}?X?^ |
| 963 | 966 |
--* BackupToTempTable |
| 964 | 967 |
drop table if exists constructiontypemaster cascade; |
| ... | ... | |
| 1337 | 1340 |
, REQUESTNO decimal(10,0) not null comment '????No' |
| 1338 | 1341 |
, ORDERNO decimal(2,0) comment '??t???' |
| 1339 | 1342 |
, DEPOSITAMOUNT decimal(10,0) comment '???????z?i??????j' |
| 1340 |
, TAXAMOUNT decimal(10,0) DEFAULT NULL COMMENT '?????'
|
|
| 1343 |
, TAXAMOUNT decimal(10,0) comment '?????'
|
|
| 1341 | 1344 |
, DISCOUNTAMOUNT decimal(10,0) comment '?l???????z' |
| 1342 | 1345 |
, CNSTRPRICE decimal(10,0) comment '?????' |
| 1343 | 1346 |
, FEES decimal(10,0) comment '????' |
| ... | ... | |
| 2661 | 2664 |
, SloganString1 varchar(100) comment '?W??1' |
| 2662 | 2665 |
, SloganString2 varchar(100) comment '?W??2' |
| 2663 | 2666 |
, SloganString3 varchar(100) comment '?W??3' |
| 2667 |
, OperationFlg decimal(2,0) unsigned not null comment '???F?^?p?t???O' |
|
| 2664 | 2668 |
, EntryDate datetime not null comment '?o?^???t' |
| 2665 | 2669 |
, UpdateDate datetime not null comment '?X?V???t' |
| 2666 | 2670 |
, constraint systemmaster_PKC primary key (SystemCode) |
他の形式にエクスポート: Unified diff