プロジェクト

全般

プロフィール

リビジョン 353

堀内 が7年以上前に追加

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

差分を表示:

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