プロジェクト

全般

プロフィール

リビジョン 353

堀内6年以上前に追加

工事担当変更履歴データ:変更
予算書集計コードマスタ:新規作成
工事種別マスタ:変更
残件一覧アップロード

差分を表示:

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