Revision 4830
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.sql | ||
|---|---|---|
| 4644 | 4644 |
-- Name: stemobservation_unique_within_plantobservation; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4645 | 4645 |
-- |
| 4646 | 4646 |
|
| 4647 |
CREATE UNIQUE INDEX stemobservation_unique_within_plantobservation ON stemobservation USING btree (plantobservation_id, (COALESCE(authorstemcode, '\\N'::text))) WHERE (sourceaccessioncode IS NULL); |
|
| 4647 |
CREATE UNIQUE INDEX stemobservation_unique_within_plantobservation ON stemobservation USING btree (plantobservation_id, (COALESCE(authorstemcode, '\\N'::text)), (COALESCE(tag, '\\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
|
| 4648 | 4648 |
|
| 4649 | 4649 |
|
| 4650 | 4650 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: stemobservation: stemobservation_unique_within_plantobservation unique index: Added tag so that a stemobservation can be scoped by its tag when no other ID is specified