Project

General

Profile

« Previous | Next » 

Revision 597

Added by Aaron Marcuse-Kubitza almost 13 years ago

vegbien.sql: Removed confusing plantconcept.plantname field since we are using plantname.plantname instead

View differences:

schemas/vegbien.for_ERD.my.sql
43 43 
  plantconcept_id int(11) NOT NULL AUTO_INCREMENT,
44 44 
  plantname_id int(11) NOT NULL,
45 45 
  reference_id int(11) NOT NULL,
46 
  plantname character varying(200),
47 46 
  plantcode character varying(23),
48 47 
  plantdescription text,
49 48 
  d_obscount int(11),
schemas/vegbien.for_ERD.sql
43 43 
  plantconcept_id serial NOT NULL,
44 44 
  plantname_id integer NOT NULL,
45 45 
  reference_id integer NOT NULL,
46 
  plantname character varying(200),
47 46 
  plantcode character varying(23),
48 47 
  plantdescription text,
49 48 
  d_obscount integer,
schemas/vegbien.sql
1611 1611 
    plantconcept_id integer NOT NULL,
1612 1612 
    plantname_id integer NOT NULL,
1613 1613 
    reference_id integer NOT NULL,
1614 
    plantname character varying(200),
1615 1614 
    plantcode character varying(23),
1616 1615 
    plantdescription text,
1617 1616 
    d_obscount integer,

Also available in: Unified diff