Project

General

Profile

« Previous | Next » 

Revision 496

vegbien.sql: Removed taxondetermination columns that have been moved to specimen

View differences:

schemas/vegbien.sql
2258 2258
    specimen_id integer NOT NULL,
2259 2259
    individualplant_id integer,
2260 2260
    reference_id integer NOT NULL,
2261
    collectioncode_dwc character varying(255) NOT NULL,
2261
    collectioncode_dwc character varying(255),
2262 2262
    catalognumber_dwc character varying(255),
2263 2263
    collectiondate timestamp with time zone
2264 2264
);
......
2511 2511
    taxonfit character varying(50),
2512 2512
    taxonconfidence character varying(50),
2513 2513
    collector_id integer,
2514
    collectionnumber character varying(100),
2515 2514
    museum_id integer,
2516 2515
    museumaccessionnumber character varying(100),
2517 2516
    grouptype character varying(20),
......
2520 2519
    notesmgt boolean,
2521 2520
    revisions boolean,
2522 2521
    determinationdate timestamp with time zone NOT NULL,
2523
    collectiondate timestamp with time zone,
2524 2522
    emb_taxondetermination integer,
2525 2523
    accessioncode character varying(255),
2526 2524
    specimen_id integer

Also available in: Unified diff