Project

General

Profile

« Previous | Next » 

Revision 596

Added by Aaron Marcuse-Kubitza almost 13 years ago

VegBIEN: Renamed aux_role to role

View differences:

vegbien.for_ERD.sql
1 1 
-- Existing tables
2 2 

  		




  3
  
  
    
CREATE TABLE aux_role


  		




  
  3
  
    
CREATE TABLE role


  		




  4
  4
  
    
(


  		




  5
  5
  
    
  role_id serial NOT NULL,


  		




  6
  6
  
    
  rolecode character varying(30) NOT NULL,


  		




  7
  7
  
    
  roledescription character varying(200),


  		




  8
  
  
    
  CONSTRAINT aux_role_pkey PRIMARY KEY (role_id )


  		




  
  8
  
    
  CONSTRAINT role_pkey PRIMARY KEY (role_id )


  		




  9
  9
  
    
);


  		




  10
  10
  
    

  		




  11
  11
  
    
CREATE TABLE reference


  		




  ......




  359
  359
  
    
      REFERENCES reference (reference_id) MATCH SIMPLE


  		




  360
  360
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  361
  361
  
    
  CONSTRAINT taxondetermination_role_id FOREIGN KEY (role_id)


  		




  362
  
  
    
      REFERENCES aux_role (role_id) MATCH SIMPLE


  		




  
  362
  
    
      REFERENCES role (role_id) MATCH SIMPLE


  		




  363
  363
  
    
      ON UPDATE CASCADE ON DELETE CASCADE,


  		




  364
  364
  
    
  CONSTRAINT taxondetermination_taxonoccurrence_id FOREIGN KEY (taxonoccurrence_id)


  		




  365
  365
  
    
      REFERENCES taxonoccurrence (taxonoccurrence_id) MATCH SIMPLE


  		












Also available in:  Unified diff