Revision 670
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_wiki.sql | ||
|---|---|---|
| 92 | 92 |
sourceaccessioncode character varying(100), |
| 93 | 93 |
); |
| 94 | 94 |
|
| 95 |
CREATE TABLE specimen |
|
| 95 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together.
|
|
| 96 | 96 |
( |
| 97 | 97 |
specimen_id serial NOT NULL, |
| 98 | 98 |
); |
| 99 | 99 |
|
| 100 |
CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
|
|
| 100 |
CREATE TABLE specimenreplicate -- A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
|
|
| 101 | 101 |
( |
| 102 | 102 |
specimenreplicate_id serial NOT NULL, |
| 103 | 103 |
reference_id integer NOT NULL, |
Also available in: Unified diff
vegbien.sql: Updated table comments for specimenreplicate and specimen