Revision 583
Added by Aaron Marcuse-Kubitza almost 13 years ago
| vegbien.sql | ||
|---|---|---|
| 2491 | 2491 |
|
| 2492 | 2492 |
CREATE TABLE taxonbin ( |
| 2493 | 2493 |
taxonbin_id integer NOT NULL, |
| 2494 |
label character varying(255) NOT NULL, |
|
| 2494 |
label character varying(255) DEFAULT ''::character varying NOT NULL,
|
|
| 2495 | 2495 |
stratum_id integer, |
| 2496 | 2496 |
sizeclass_id integer, |
| 2497 | 2497 |
coverindex_id integer, |
| 2498 |
accessioncode character varying(255), |
|
| 2499 |
count integer NOT NULL |
|
| 2498 |
accessioncode character varying(255) |
|
| 2500 | 2499 |
); |
| 2501 | 2500 |
|
| 2502 | 2501 |
|
| ... | ... | |
| 4419 | 4418 |
|
| 4420 | 4419 |
|
| 4421 | 4420 |
-- |
| 4421 |
-- Name: taxonbin_keys; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
| 4422 |
-- |
|
| 4423 |
|
|
| 4424 |
ALTER TABLE ONLY taxonbin |
|
| 4425 |
ADD CONSTRAINT taxonbin_keys UNIQUE (label, stratum_id, sizeclass_id, coverindex_id); |
|
| 4426 |
|
|
| 4427 |
|
|
| 4428 |
-- |
|
| 4422 | 4429 |
-- Name: taxonbin_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
| 4423 | 4430 |
-- |
| 4424 | 4431 |
|
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.