Revision 5267
Added by Aaron Marcuse-Kubitza over 12 years ago
| 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 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added parent_id to point to the parent taxonconcept