Project

General

Profile

« Previous | Next » 

Revision 2112

Added by Duane Costa over 20 years ago

Correct minor problems with foreign keys in Harvester tables

View differences:

upgrade-db-to-1.4.sql
70 70 
  status                 NUMBER,         -- non-zero indicates an error status
71 71 
  message                VARCHAR2(1000), -- text message for this log entry
72 72 
  harvest_operation_code VARCHAR2(30),   -- the type of harvest operation
73 
  site_schedule_id       NUMBER,         -- foreign key
74 
  CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id),
75 
  CONSTRAINT harvest_log_site_schedule_id_fk
76 
        FOREIGN KEY (site_schedule_id) REFERENCES harvest_site_schedule
73 
  site_schedule_id       NUMBER,         -- site schedule id, or 0 if no site
74 
  CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id)
77 75 
);
78 76 

  		




  79
  77
  
    
/* 


  		




  ......




  90
  88
  
    
  error_message          VARCHAR2(1000), -- text error message


  		




  91
  89
  
    
  document_type          VARCHAR2(100),  -- document type


  		




  92
  90
  
    
  CONSTRAINT harvest_detail_log_pk PRIMARY KEY (detail_log_id),


  		




  93
  
  
    
  CONSTRAINT harvest_detail_log_harvest_log_id_fk 


  		




  
  91
  
    
  CONSTRAINT harvest_detail_log_fk 


  		




  94
  92
  
    
        FOREIGN KEY (harvest_log_id) REFERENCES harvest_log


  		




  95
  93
  
    
);


  		




  96
  94
  
    

  		












Also available in:  Unified diff