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_postgres.sql
61 61 
  status                 INT8,          -- non-zero indicates an error status
62 62 
  message                VARCHAR(1000), -- text message for this log entry
63 63 
  harvest_operation_code VARCHAR(30),   -- the type of harvest operation
64 
  site_schedule_id       INT8,          -- foreign key
65 
  CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id),
66 
  CONSTRAINT harvest_log_site_schedule_id_fk
67 
        FOREIGN KEY (site_schedule_id) REFERENCES harvest_site_schedule
64 
  site_schedule_id       INT8,          -- site schedule id, or 0 if no site
65 
  CONSTRAINT harvest_log_pk PRIMARY KEY (harvest_log_id)
68 66 
);
69 67 

  		




  70
  68
  
    
/* 


  		




  ......




  81
  79
  
    
  error_message          VARCHAR(1000), -- text error message


  		




  82
  80
  
    
  document_type          VARCHAR(100),  -- document type


  		




  83
  81
  
    
  CONSTRAINT harvest_detail_log_pk PRIMARY KEY (detail_log_id),


  		




  84
  
  
    
  CONSTRAINT harvest_detail_log_harvest_log_id_fk 


  		




  
  82
  
    
  CONSTRAINT harvest_detail_log_fk 


  		




  85
  83
  
    
        FOREIGN KEY (harvest_log_id) REFERENCES harvest_log


  		




  86
  84
  
    
);


  		




  87
  85
  
    

  		












Also available in:  Unified diff