/ - Diff - BIEN 3 - NCEAS Projects

« Previous | Next »

Revision 7336

schemas/vegbien.sql: taxonverbatim: Allow taxonlabel_id to be NULL when morphoname is provided

     CREATE TABLE taxonverbatim (
         taxonverbatim_id int(11) NOT NULL,
         source_id int(11) NOT NULL,
         taxonlabel_id int(11) NOT NULL,
         taxonlabel_id int(11),
         verbatimrank varchar(255),
         taxonomicname varchar(255),
         taxonname varchar(255),

     CREATE TABLE taxonverbatim (
         taxonverbatim_id integer NOT NULL,
         source_id integer NOT NULL,
         taxonlabel_id integer NOT NULL,
         taxonlabel_id integer,
         verbatimrank text,
         taxonomicname text,
         taxonname text,
-...
         morphospecies text,
         morphoname text,
         growthform growthform,
         description text
         description text,
         CONSTRAINT taxonverbatim_required_key CHECK (((taxonlabel_id IS NOT NULL) OR (morphoname IS NOT NULL)))
     );

Also available in: Unified diff