Revision 4716
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1676 | 1676 |
scope_id int(11), |
| 1677 | 1677 |
rank text NOT NULL, |
| 1678 | 1678 |
verbatimrank text, |
| 1679 |
plantname text NOT NULL,
|
|
| 1679 |
taxonname text NOT NULL,
|
|
| 1680 | 1680 |
authority text, |
| 1681 | 1681 |
description text, |
| 1682 | 1682 |
accessioncode text |
| schemas/vegbien.sql | ||
|---|---|---|
| 2128 | 2128 |
scope_id integer, |
| 2129 | 2129 |
rank taxonrank NOT NULL, |
| 2130 | 2130 |
verbatimrank text, |
| 2131 |
plantname text NOT NULL,
|
|
| 2131 |
taxonname text NOT NULL,
|
|
| 2132 | 2132 |
authority text, |
| 2133 | 2133 |
description text, |
| 2134 | 2134 |
accessioncode text |
| ... | ... | |
| 4381 | 4381 |
-- Name: plantname_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4382 | 4382 |
-- |
| 4383 | 4383 |
|
| 4384 |
CREATE UNIQUE INDEX plantname_unique ON plantname USING btree ((COALESCE(parent_id, 2147483647)), plantname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(authority, '\\N'::text)));
|
|
| 4384 |
CREATE UNIQUE INDEX plantname_unique ON plantname USING btree ((COALESCE(parent_id, 2147483647)), taxonname, rank, (COALESCE(scope_id, 2147483647)), (COALESCE(authority, '\\N'::text)));
|
|
| 4385 | 4385 |
|
| 4386 | 4386 |
|
| 4387 | 4387 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: plantname: Renamed plantname field to taxonname for consistency with DwC's Taxon category