Revision 6883
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 6589 | 6589 |
-- Name: trait_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6590 | 6590 |
-- |
| 6591 | 6591 |
|
| 6592 |
CREATE UNIQUE INDEX trait_unique ON trait USING btree (taxonoccurrence_id, name, (COALESCE(value, '\N'::text)), (COALESCE(units, '\N'::text)));
|
|
| 6592 |
CREATE UNIQUE INDEX trait_unique ON trait USING btree (taxonoccurrence_id, name); |
|
| 6593 | 6593 |
|
| 6594 | 6594 |
|
| 6595 | 6595 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: trait: trait_unique: Removed value and units because there should only be one value of a trait for each taxonoccurrence