Revision 5267
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 783 | 783 |
creator_id int(11) NOT NULL, |
| 784 | 784 |
identifyingtaxonomicname text, |
| 785 | 785 |
canon_taxonconcept_id int(11), |
| 786 |
parent_id int(11), |
|
| 786 | 787 |
taxonname text, |
| 787 | 788 |
rank text, |
| 788 | 789 |
verbatimrank text, |
| ... | ... | |
| 836 | 837 |
|
| 837 | 838 |
|
| 838 | 839 |
-- |
| 840 |
-- Name: COLUMN taxonconcept.parent_id; Type: COMMENT; Schema: public; Owner: - |
|
| 841 |
-- |
|
| 842 |
|
|
| 843 |
|
|
| 844 |
|
|
| 845 |
|
|
| 846 |
-- |
|
| 839 | 847 |
-- Name: COLUMN taxonconcept.taxonname; Type: COMMENT; Schema: public; Owner: - |
| 840 | 848 |
-- |
| 841 | 849 |
|
| ... | ... | |
| 4093 | 4101 |
|
| 4094 | 4102 |
|
| 4095 | 4103 |
-- |
| 4104 |
-- Name: taxonconcept_unique_within_parent; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 4105 |
-- |
|
| 4106 |
|
|
| 4107 |
|
|
| 4108 |
|
|
| 4109 |
|
|
| 4110 |
-- |
|
| 4096 | 4111 |
-- Name: taxondetermination_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4097 | 4112 |
-- |
| 4098 | 4113 |
|
| schemas/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