Project

General

Profile

« Previous | Next » 

Revision 566

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Renamed place to locationplace

View differences:

vegbien.for_ERD.sql
76 76 
  CONSTRAINT namedplace_keys UNIQUE (placesystem , placename )
77 77 
);
78 78 

  		




  79
  
  
    
CREATE TABLE place


  		




  
  79
  
    
CREATE TABLE locationplace


  		




  80
  80
  
    
(


  		




  81
  81
  
    
  locationplace_id serial NOT NULL,


  		




  82
  82
  
    
  location_id integer NOT NULL,


  		




  83
  83
  
    
  calculated boolean,


  		




  84
  84
  
    
  namedplace_id integer NOT NULL,


  		




  85
  
  
    
  CONSTRAINT place_pkey PRIMARY KEY (locationplace_id ),


  		




  86
  
  
    
  CONSTRAINT place_location_id FOREIGN KEY (location_id)


  		




  
  85
  
    
  CONSTRAINT locationplace_pkey PRIMARY KEY (locationplace_id ),


  		




  
  86
  
    
  CONSTRAINT locationplace_location_id FOREIGN KEY (location_id)


  		




  87
  87
  
    
      REFERENCES location (location_id) MATCH SIMPLE


  		




  88
  88
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  89
  
  
    
  CONSTRAINT place_namedplace_id FOREIGN KEY (namedplace_id)


  		




  
  89
  
    
  CONSTRAINT locationplace_namedplace_id FOREIGN KEY (namedplace_id)


  		




  90
  90
  
    
      REFERENCES namedplace (namedplace_id) MATCH SIMPLE


  		




  91
  91
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  92
  
  
    
  CONSTRAINT place_keys UNIQUE (location_id , namedplace_id )


  		




  
  92
  
    
  CONSTRAINT locationplace_keys UNIQUE (location_id , namedplace_id )


  		




  93
  93
  
    
);


  		




  94
  94
  
    

  		




  95
  95
  
    
CREATE TABLE project


  		












Also available in:  Unified diff