Project

General

Profile

« Previous | Next » 

Revision 481

vegbien.sql: Made specimen.individualplant_id optional because specimens are not required to have a corresponding plot event (which all individualplants must have)

View differences:

vegbien.sql
2222 2222

  
2223 2223
CREATE TABLE specimen (
2224 2224
    specimen_id integer NOT NULL,
2225
    individualplant_id integer NOT NULL,
2225
    individualplant_id integer,
2226 2226
    reference_id integer NOT NULL,
2227 2227
    collectioncode character varying(255) NOT NULL,
2228 2228
    catalognumber character varying(255)

Also available in: Unified diff