Revision 670
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.sql | ||
|---|---|---|
| 281 | 281 |
CONSTRAINT stem_keys_code UNIQUE (individualplant_id , authorstemcode ) |
| 282 | 282 |
); |
| 283 | 283 |
|
| 284 |
CREATE TABLE specimen |
|
| 284 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together.
|
|
| 285 | 285 |
( |
| 286 | 286 |
specimen_id serial NOT NULL, |
| 287 | 287 |
CONSTRAINT specimen_pkey PRIMARY KEY (specimen_id ) |
| 288 | 288 |
); |
| 289 | 289 |
|
| 290 |
CREATE TABLE specimenreplicate -- A herbarium specimenreplicate. Contains Darwin Core specimenreplicate data.
|
|
| 290 |
CREATE TABLE specimenreplicate -- A herbarium's replicate of a specimen. Contains Darwin Core specimen data.
|
|
| 291 | 291 |
( |
| 292 | 292 |
specimenreplicate_id serial NOT NULL, |
| 293 | 293 |
reference_id integer NOT NULL, |
Also available in: Unified diff
vegbien.sql: Updated table comments for specimenreplicate and specimen