Revision 583
Added by Aaron Marcuse-Kubitza about 13 years ago
| vegbien.for_ERD.my.sql | ||
|---|---|---|
| 359 | 359 |
CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated. |
| 360 | 360 |
( |
| 361 | 361 |
taxonbin_id int(11) NOT NULL, |
| 362 |
label character varying(255) NOT NULL, |
|
| 362 |
label character varying(255) NOT NULL DEFAULT '',
|
|
| 363 | 363 |
stratum_id int(11), |
| 364 | 364 |
sizeclass_id int(11), |
| 365 | 365 |
coverindex_id int(11), |
| 366 | 366 |
accessioncode character varying(255), |
| 367 |
count int(11) NOT NULL, |
|
| 368 | 367 |
CONSTRAINT taxonbin_pkey PRIMARY KEY (taxonbin_id ), |
| 369 | 368 |
CONSTRAINT taxonbin_sizeclass_id FOREIGN KEY (sizeclass_id) |
| 370 | 369 |
REFERENCES sizeclass (sizeclass_id) MATCH SIMPLE |
| 371 |
ON UPDATE CASCADE ON DELETE CASCADE |
|
| 370 |
ON UPDATE CASCADE ON DELETE CASCADE, |
|
| 371 |
CONSTRAINT taxonbin_keys UNIQUE (label , stratum_id , sizeclass_id , coverindex_id ) |
|
| 372 | 372 |
); |
Also available in: Unified diff
vegbien.sql: Removed taxonbin.count because that belongs in aggregateoccurrence and taxonbin is more similar to a sampling method. Added taxonbin UNIQUE constraint.