リビジョン 353
工事担当変更履歴データ:変更
予算書集計コードマスタ:新規作成
工事種別マスタ:変更
残件一覧アップロード
ProcessManagement.sql | ||
---|---|---|
1 | 1 |
-- Project Name : noname |
2 |
-- Date/Time : 2018/04/12 9:06:32
|
|
2 |
-- Date/Time : 2018/05/25 8:19:35
|
|
3 | 3 |
-- Author : Horiuchi |
4 | 4 |
-- RDBMS Type : MySQL |
5 | 5 |
-- Application : A5:SQL Mk-2 |
... | ... | |
308 | 308 |
, constraint bk_estimatedatadetail_PKC primary key (SaveDate,ConstructionCode,PageCount,LineCount) |
309 | 309 |
) comment '??Z????f?[?^????y???p?z' ; |
310 | 310 |
|
311 |
-- ?\?Z???W?v?R?[?h?}?X?^ |
|
312 |
drop table if exists budgetsumcode cascade; |
|
313 |
|
|
314 |
create table budgetsumcode ( |
|
315 |
BlockCode decimal(2,0) unsigned not null comment '?u???b?N???' |
|
316 |
, GroupCode decimal(2,0) unsigned not null comment '?O???[?v???' |
|
317 |
, ComponentCode decimal(5,0) unsigned not null comment '?\???L?[' |
|
318 |
, ItemCode decimal(5,0) unsigned not null comment '?H??L?[' |
|
319 |
, ElementsName varchar(100) not null comment '?v?f????' |
|
320 |
, EntryDate datetime not null comment '?o?^???t' |
|
321 |
, UpdateDate datetime not null comment '?X?V???t' |
|
322 |
, constraint budgetsumcode_PKC primary key (BlockCode,GroupCode,ComponentCode,ItemCode) |
|
323 |
) comment '?\?Z???W?v?R?[?h?}?X?^' ; |
|
324 |
|
|
311 | 325 |
-- ?@?l?i?}?X?^ |
312 | 326 |
drop table if exists businesstypemaster cascade; |
313 | 327 |
|
... | ... | |
337 | 351 |
, constraint chgchargedep_PKC primary key (PersonCode,StartDate) |
338 | 352 |
) comment '?S????????????f?[?^' ; |
339 | 353 |
|
354 |
-- ?H???S????X?????f?[?^ |
|
355 |
drop table if exists chgconstrcharge cascade; |
|
356 |
|
|
357 |
create table chgconstrcharge ( |
|
358 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
359 |
, Division decimal(1,0) not null comment '????' |
|
360 |
, SeqNo smallint(5) unsigned not null comment '?A??' |
|
361 |
, DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h' |
|
362 |
, PersonCode decimal(8,0) not null comment '?S????R?[?h' |
|
363 |
, StartDate date comment '?S???J?n?N????' |
|
364 |
, CompDate date comment '?S???I???N????' |
|
365 |
, EntryDate datetime not null comment '?o?^???t' |
|
366 |
, UpdateDate datetime not null comment '?X?V???t' |
|
367 |
, constraint chgconstrcharge_PKC primary key (ConstructionCode,Division,SeqNo) |
|
368 |
) comment '?H???S????X?????f?[?^' ; |
|
369 |
|
|
340 | 370 |
-- ????????}?X?^ |
341 | 371 |
drop table if exists commoncostlarge cascade; |
342 | 372 |
|
... | ... | |
446 | 476 |
create index ComponentToTypeMaster_Index2 |
447 | 477 |
on componenttotypemaster(TypeCode); |
448 | 478 |
|
449 |
-- ?H???S???????f?[?^ |
|
450 |
drop table if exists constrchgcharge cascade; |
|
451 |
|
|
452 |
create table constrchgcharge ( |
|
453 |
ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h' |
|
454 |
, Division decimal(1,0) not null comment '????' |
|
455 |
, SeqNo smallint(5) unsigned not null comment '?A??' |
|
456 |
, DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h' |
|
457 |
, PersonCode decimal(8,0) not null comment '?S????R?[?h' |
|
458 |
, StartDate date comment '?S???J?n?N????' |
|
459 |
, CompDate date comment '?S???I???N????' |
|
460 |
, EntryDate datetime not null comment '?o?^???t' |
|
461 |
, UpdateDate datetime not null comment '?X?V???t' |
|
462 |
, constraint constrchgcharge_PKC primary key (ConstructionCode,Division,SeqNo) |
|
463 |
) comment '?H???S???????f?[?^' ; |
|
464 |
|
|
465 | 479 |
-- ?H???????o??f?[?^ |
466 | 480 |
drop table if exists constrledgerexpenses cascade; |
467 | 481 |
|
... | ... | |
864 | 878 |
TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h' |
865 | 879 |
, DisplayOrder decimal(5,0) unsigned not null comment '?\????' |
866 | 880 |
, NameString varchar(100) not null comment '????' |
867 |
, PublicFlg decimal(1,0) not null comment '?H?????t???O' |
|
881 |
, PublicFlg decimal(1,0) not null comment '?????t???O' |
|
882 |
, RepairFlg decimal(1,0) not null comment '?V?z?E???C?t???O' |
|
868 | 883 |
, SecRank decimal(1,0) not null comment '?????????N' |
869 | 884 |
, ExpensesLink decimal(1,0) not null comment '?o??g?p??' |
870 | 885 |
, DeleteFlg decimal(1,0) not null comment '???t???O' |
他の形式にエクスポート: Unified diff