プロジェクト

全般

プロフィール

リビジョン 357

堀内 が6年以上前に追加

部署出納データ追加
注文書明細修正

差分を表示:

branches/ddl/ProcessManagement.sql
1 1 
-- Project Name : noname
2 
-- Date/Time    : 2018/05/25 8:19:35
2 
-- Date/Time    : 2018/06/19 8:22:40
3 3 
-- Author       : Horiuchi
4 4 
-- RDBMS Type   : MySQL
5 5 
-- Application  : A5:SQL Mk-2
......
56 56 
  , CompTime datetime comment '?I??????'
57 57 
  , DayTimes decimal(4,1) not null comment '????????v????'
58 58 
  , WorkingComment varchar(120) comment '?R?????g'
59 
  , NightFlg decimal(1,0) not null comment '?????t???O'
59 
  , WorkKindFlg decimal(1,0) not null comment '?????t???O'
60 60 
  , EntryDate datetime not null comment '?o?^???t'
61 61 
  , UpdateDate datetime not null comment '?X?V???t'
62 62 
  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)
......
888 888 
  , constraint constructiontypemaster_PKC primary key (TypeCode)
889 889 
) comment '?H?????}?X?^' ;
890 890 

  		




  
  891
  
    
-- ?????o?[?f?[?^


  		




  
  892
  
    
drop table if exists costdataofdepartment cascade;


  		




  
  893
  
    

  		




  
  894
  
    
create table costdataofdepartment (


  		




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


  		




  
  896
  
    
  , ConstrYear smallint(5) unsigned not null comment '?H???????E?N??'


  		




  
  897
  
    
  , SeqNo decimal(5,0) unsigned not null comment '?f?[?^???'


  		




  
  898
  
    
  , CostDate date not null comment '?????t'


  		




  
  899
  
    
  , DepartmentName varchar(100) not null comment '??????'


  		




  
  900
  
    
  , SuppliersCode decimal(8,0) unsigned not null comment '?o?[??R?[?h'


  		




  
  901
  
    
  , SuppliersName varchar(120) comment '?o?[??'


  		




  
  902
  
    
  , PaymentContent varchar(100) comment '?o?[???e'


  		




  
  903
  
    
  , SendReceiveFlg decimal(1,0) not null comment '?o?[?t???O'


  		




  
  904
  
    
  , EntryPrice decimal(12,0) not null comment '???z?i????j'


  		




  
  905
  
    
  , EntryTax decimal(12,0) not null comment '???z?i????j'


  		




  
  906
  
    
  , Coment varchar(100) comment '???l'


  		




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


  		




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


  		




  
  909
  
    
  , constraint costdataofdepartment_PKC primary key (DepartmentCode,ConstrYear,SeqNo)


  		




  
  910
  
    
) comment '?????o?[?f?[?^' ;


  		




  
  911
  
    

  		




  891
  912
  
    
-- ?S??????o??f?[?^


  		




  892
  913
  
    
drop table if exists costdataofperson cascade;


  		




  893
  914
  
    

  		




  ......




  1968
  1989
  
    
  , SourceCode decimal(10,0) unsigned not null comment '???H?????'


  		




  1969
  1990
  
    
  , SourceDetailCnt decimal(4,0) unsigned not null comment '????????'


  		




  1970
  1991
  
    
  , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'


  		




  
  1992
  
    
  , StatutoryWelfareRate decimal(4,2) not null comment '?@???????'


  		




  1971
  1993
  
    
  , EntryDate datetime not null comment '?o?^???t'


  		




  1972
  1994
  
    
  , UpdateDate datetime not null comment '?X?V???t'


  		




  1973
  1995
  
    
  , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)


  		












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