プロジェクト

全般

プロフィール

リビジョン 332

堀内 がほぼ7年前に追加

工事担当者履歴テーブル追加
工事基本情報：部署項目追加
工事基本情報明細：明細番号2桁->3桁（部署名追加）
発注者登録申請テーブル：申請部署追加

差分を表示:

ProcessManagement.sql
1 1 
-- Project Name : noname
2 
-- Date/Time    : 2018/03/01 9:40:48
2 
-- Date/Time    : 2018/03/28 9:13:42
3 3 
-- Author       : Horiuchi
4 4 
-- RDBMS Type   : MySQL
5 5 
-- Application  : A5:SQL Mk-2
......
323 323 
create index BusinessTypeMaster_Index1
324 324 
  on businesstypemaster(DisplayOrder);
325 325 

  		




  
  326
  
    
-- ?S????????????f?[?^


  		




  
  327
  
    
drop table if exists chgchargedep cascade;


  		




  
  328
  
    

  		




  
  329
  
    
create table chgchargedep (


  		




  
  330
  
    
  PersonCode decimal(8,0) not null comment '?S????R?[?h'


  		




  
  331
  
    
  , StartDate date not null comment '?J?n?N????'


  		




  
  332
  
    
  , CompDate date not null comment '?I???N????'


  		




  
  333
  
    
  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'


  		




  
  334
  
    
  , DepartmentName varchar(60) comment '??????'


  		




  
  335
  
    
  , EntryDate datetime not null comment '?o?^???t'


  		




  
  336
  
    
  , UpdateDate datetime not null comment '?X?V???t'


  		




  
  337
  
    
  , constraint chgchargedep_PKC primary key (PersonCode,StartDate)


  		




  
  338
  
    
) comment '?S????????????f?[?^' ;


  		




  
  339
  
    

  		




  326
  340
  
    
-- ????????}?X?^


  		




  327
  341
  
    
drop table if exists commoncostlarge cascade;


  		




  328
  342
  
    

  		




  ......




  432
  446
  
    
create index ComponentToTypeMaster_Index2


  		




  433
  447
  
    
  on componenttotypemaster(TypeCode);


  		




  434
  448
  
    

  		




  
  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
  
    

  		




  435
  465
  
    
-- ?H????{???


  		




  436
  466
  
    
drop table if exists constructionbaseinfo cascade;


  		




  437
  467
  
    

  		




  ......




  454
  484
  
    
  , NonOrderDate date comment '????'


  		




  455
  485
  
    
  , OrdersDecisionPrice decimal(12,0) not null comment '??????????z'


  		




  456
  486
  
    
  , OrdersDecisionPriceInTax decimal(12,0) not null comment '??????????z'


  		




  457
  
  
    
  , SalesPersonCode decimal(8,0) comment '?c??S?????'


  		




  458
  
  
    
  , ConstructionPersonCode decimal(8,0) not null comment '?H???S????'


  		




  459
  
  
    
  , ConstrSubPersonCode decimal(8,0) not null comment '?H?????S????'


  		




  460
  
  
    
  , ConstructionInstructor decimal(8,0) not null comment '?H???w????'


  		




  
  487
  
    
  , SalesDepCode decimal(5,0) unsigned not null comment '?c??S????????R?[?h'


  		




  
  488
  
    
  , SalesPersonCode decimal(8,0) unsigned not null comment '?c??S????R?[?h'


  		




  
  489
  
    
  , ConstrDepCode decimal(5,0) unsigned not null comment '?H???S????????R?[?h'


  		




  
  490
  
    
  , ConstructionPersonCode decimal(8,0) not null comment '?H???S????R?[?h'


  		




  
  491
  
    
  , ConstrSubDepCode decimal(5,0) unsigned not null comment '?H?????S????????R?[?h'


  		




  
  492
  
    
  , ConstrSubPersonCode decimal(8,0) not null comment '?H?????S????R?[?h'


  		




  
  493
  
    
  , ConstrInstrDepCode decimal(5,0) unsigned not null comment '?H???w?????????R?[?h'


  		




  
  494
  
    
  , ConstructionInstructor decimal(8,0) not null comment '?H???w?????R?[?h'


  		




  461
  495
  
    
  , TransferConstruction decimal(8,0) not null comment '?H??????R?[?h'


  		




  462
  496
  
    
  , TransferConstructionDate date comment '?H??????'


  		




  463
  
  
    
  , OrderersDivision decimal(5,0) not null comment '???????'


  		




  
  497
  
    
  , OrderersDivision decimal(5,0) not null comment '????????R?[?h'


  		




  464
  498
  
    
  , OrderersCode decimal(5,0) unsigned not null comment '??????R?[?h'


  		




  465
  499
  
    
  , EstimatesExpirationDate date comment '????L??????'


  		




  466
  500
  
    
  , ConstructionPeriodStart date comment '?_??H???J?n??'


  		




  ......




  514
  548
  
    

  		




  515
  549
  
    
create table constructionbaseinfodetail (


  		




  516
  550
  
    
  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'


  		




  517
  
  
    
  , DetailNo decimal(2,0) not null comment '??????'


  		




  
  551
  
    
  , DetailNo decimal(3,0) not null comment '??????'


  		




  518
  552
  
    
  , DetailString varchar(300) comment '??????e'


  		




  519
  553
  
    
  , EntryDate datetime not null comment '?o?^???t'


  		




  520
  554
  
    
  , UpdateDate datetime not null comment '?X?V???t'


  		




  ......




  827
  861
  
    
drop table if exists costomerregist cascade;


  		




  828
  862
  
    

  		




  829
  863
  
    
create table costomerregist (


  		




  830
  
  
    
  PersonCode decimal(8,0) unsigned not null comment '?\??????'


  		




  
  864
  
    
  CreatePersonCode decimal(8,0) unsigned not null comment '?\??????'


  		




  831
  865
  
    
  , CreateDate date not null comment '????'


  		




  832
  866
  
    
  , SeqNo decimal(2,0) not null comment '?L?[?A??'


  		




  833
  867
  
    
  , DataMode decimal(1,0) not null comment '?f?[?^??'


  		




  ......




  840
  874
  
    
  , OrderersName1 varchar(60) not null comment '???????1'


  		




  841
  875
  
    
  , OrderersName2 varchar(60) comment '????????Q'


  		




  842
  876
  
    
  , DepartmentName varchar(60) comment '??????'


  		




  843
  
  
    
  , ChargePersonName varchar(60) comment '?S?????'


  		




  
  877
  
    
  , PersonName varchar(60) comment '?S?????'


  		




  844
  878
  
    
  , ZipCode varchar(8) comment '?X????'


  		




  845
  879
  
    
  , Address1 varchar(60) comment '?Z???P'


  		




  846
  880
  
    
  , Address2 varchar(60) comment '?Z??2'


  		




  ......




  852
  886
  
    
  , OrderCotegory decimal(5,0) unsigned not null comment '???????'


  		




  853
  887
  
    
  , OrderDate date not null comment '?\????'


  		




  854
  888
  
    
  , OrderNo decimal(2,0) unsigned not null comment '?\????t???'


  		




  
  889
  
    
  , CreateDepartmentCode decimal(5,0) unsigned not null comment '?\???????R?[?h'


  		




  
  890
  
    
  , CreateDepartmentName varchar(60) comment '?\????????'


  		




  855
  891
  
    
  , EntryDate datetime not null comment '?o?^???t'


  		




  856
  892
  
    
  , UpdateDate datetime not null comment '?X?V???t'


  		




  857
  
  
    
  , constraint costomerregist_PKC primary key (PersonCode,CreateDate,SeqNo)


  		




  
  893
  
    
  , constraint costomerregist_PKC primary key (CreatePersonCode,CreateDate,SeqNo)


  		




  858
  894
  
    
) comment '??????o?^?\???f?[?^' ;


  		




  859
  895
  
    

  		




  860
  896
  
    
create index CostomerRegist_Index1


  		




  861
  897
  
    
  on costomerregist(PetitionPeriod);


  		




  862
  898
  
    

  		




  
  899
  
    
create index CostomerRegist_Index2


  		




  
  900
  
    
  on costomerregist(CreatePersonCode);


  		




  
  901
  
    

  		




  
  902
  
    
create index CostomerRegist_Index3


  		




  
  903
  
    
  on costomerregist(CreateDepartmentCode);


  		




  
  904
  
    

  		




  863
  905
  
    
-- ????f?[?^


  		




  864
  906
  
    
drop table if exists dailydataconstruction cascade;


  		




  865
  907
  
    

  		












他の形式にエクスポート:  Unified diff