Revision 583
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.for_wiki.sql | ||
|---|---|---|
| 159 | 159 |
CREATE TABLE taxonbin -- Defines a set of aggregate measurements. Used by aggregateoccurrence to define how measurements were aggregated. |
| 160 | 160 |
( |
| 161 | 161 |
taxonbin_id integer NOT NULL, |
| 162 |
label character varying(255) NOT NULL, |
|
| 162 |
label character varying(255) NOT NULL DEFAULT ''::character varying,
|
|
| 163 | 163 |
stratum_id integer, |
| 164 | 164 |
sizeclass_id integer, |
| 165 | 165 |
coverindex_id integer, |
| 166 | 166 |
accessioncode character varying(255), |
| 167 |
count integer NOT NULL, |
|
| 168 | 167 |
); |
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.