Revision 673
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_ERD.sql | ||
|---|---|---|
| 257 | 257 |
CONSTRAINT plantobservation_aggregateoccurrence_id_1_to_1 UNIQUE (aggregateoccurrence_id ) |
| 258 | 258 |
); |
| 259 | 259 |
|
| 260 |
CREATE TABLE stem -- VegBank's stemlocation table. |
|
| 260 |
CREATE TABLE stemobservation -- VegBank's stemlocation table.
|
|
| 261 | 261 |
( |
| 262 |
stem_id serial NOT NULL, |
|
| 262 |
stemobservation_id serial NOT NULL,
|
|
| 263 | 263 |
plantobservation_id integer NOT NULL, |
| 264 | 264 |
authorstemcode character varying(20), |
| 265 | 265 |
xposition double precision, |
| 266 | 266 |
yposition double precision, |
| 267 | 267 |
health character varying(50), |
| 268 |
emb_stem integer, |
|
| 268 |
emb_stemobservation integer,
|
|
| 269 | 269 |
diameter double precision, |
| 270 | 270 |
height double precision, |
| 271 | 271 |
heightaccuracy double precision, |
| ... | ... | |
| 273 | 273 |
accessioncode character varying(255), |
| 274 | 274 |
diameteraccuracy double precision, |
| 275 | 275 |
sourceaccessioncode character varying(100), |
| 276 |
CONSTRAINT stem_pkey PRIMARY KEY (stem_id ),
|
|
| 277 |
CONSTRAINT stem_plantobservation_id FOREIGN KEY (plantobservation_id) |
|
| 276 |
CONSTRAINT stemobservation_pkey PRIMARY KEY (stemobservation_id ),
|
|
| 277 |
CONSTRAINT stemobservation_plantobservation_id FOREIGN KEY (plantobservation_id)
|
|
| 278 | 278 |
REFERENCES plantobservation (plantobservation_id) MATCH SIMPLE |
| 279 | 279 |
ON UPDATE CASCADE ON DELETE CASCADE, |
| 280 |
CONSTRAINT stem_keys_accessioncode UNIQUE (plantobservation_id , sourceaccessioncode ), |
|
| 281 |
CONSTRAINT stem_keys_code UNIQUE (plantobservation_id , authorstemcode ) |
|
| 280 |
CONSTRAINT stemobservation_keys_accessioncode UNIQUE (plantobservation_id , sourceaccessioncode ),
|
|
| 281 |
CONSTRAINT stemobservation_keys_code UNIQUE (plantobservation_id , authorstemcode )
|
|
| 282 | 282 |
); |
| 283 | 283 |
|
| 284 | 284 |
CREATE TABLE specimen -- A physical specimen collected from a plant. Used to link replicates of the same specimen together. |
Also available in: Unified diff
VegBIEN: Renamed stem to stemobservation