Revision 5267
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 1117 | 1117 |
creator_id integer NOT NULL, |
| 1118 | 1118 |
identifyingtaxonomicname text, |
| 1119 | 1119 |
canon_taxonconcept_id integer, |
| 1120 |
parent_id integer, |
|
| 1120 | 1121 |
taxonname text, |
| 1121 | 1122 |
rank taxonrank, |
| 1122 | 1123 |
verbatimrank text, |
| ... | ... | |
| 1177 | 1178 |
|
| 1178 | 1179 |
|
| 1179 | 1180 |
-- |
| 1181 |
-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: - |
|
| 1182 |
-- |
|
| 1183 |
|
|
| 1184 |
COMMENT ON COLUMN taxonconcept.parent_id IS 'The parent taxonconcept.'; |
|
| 1185 |
|
|
| 1186 |
|
|
| 1187 |
-- |
|
| 1180 | 1188 |
-- Name: COLUMN taxonconcept.taxonname; Type: COMMENT; Schema: public; Owner: - |
| 1181 | 1189 |
-- |
| 1182 | 1190 |
|
| ... | ... | |
| 4745 | 4753 |
|
| 4746 | 4754 |
|
| 4747 | 4755 |
-- |
| 4756 |
-- Name: taxonconcept_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4757 |
-- |
|
| 4758 |
|
|
| 4759 |
CREATE UNIQUE INDEX taxonconcept_unique_within_parent ON taxonconcept USING btree ((COALESCE(taxonname, '\\N'::text)), (COALESCE(rank, 'unknown'::taxonrank)), (COALESCE(parent_id, 2147483647))) WHERE (((identifyingtaxonomicname IS NULL) AND (taxonname IS NOT NULL)) AND (parent_id IS NOT NULL)); |
|
| 4760 |
|
|
| 4761 |
|
|
| 4762 |
-- |
|
| 4748 | 4763 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4749 | 4764 |
-- |
| 4750 | 4765 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added parent_id to point to the parent taxonconcept