Revision 5232
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 766 | 766 |
CREATE TABLE taxonconcept ( |
| 767 | 767 |
taxonconcept_id int(11) NOT NULL, |
| 768 | 768 |
datasource_id int(11) NOT NULL, |
| 769 |
concept_reference_id int(11), |
|
| 769 | 770 |
identifyingtaxonomicname text, |
| 770 | 771 |
canon_taxonconcept_id int(11), |
| 771 | 772 |
taxon_id int(11), |
| ... | ... | |
| 786 | 787 |
cultivar text, |
| 787 | 788 |
morphospecies text, |
| 788 | 789 |
otherranks text, |
| 789 |
concept_reference_id int(11), |
|
| 790 | 790 |
accessioncode text |
| 791 | 791 |
); |
| 792 | 792 |
|
| ... | ... | |
| 799 | 799 |
|
| 800 | 800 |
|
| 801 | 801 |
-- |
| 802 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: - |
|
| 803 |
-- |
|
| 804 |
|
|
| 805 |
|
|
| 806 |
|
|
| 807 |
|
|
| 808 |
-- |
|
| 802 | 809 |
-- Name: COLUMN taxonconcept.identifyingtaxonomicname; Type: COMMENT; Schema: public; Owner: - |
| 803 | 810 |
-- |
| 804 | 811 |
|
| ... | ... | |
| 939 | 946 |
|
| 940 | 947 |
|
| 941 | 948 |
-- |
| 942 |
-- Name: COLUMN taxonconcept.concept_reference_id; Type: COMMENT; Schema: public; Owner: - |
|
| 943 |
-- |
|
| 944 |
|
|
| 945 |
|
|
| 946 |
|
|
| 947 |
|
|
| 948 |
-- |
|
| 949 | 949 |
-- Name: taxondetermination; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 950 | 950 |
-- |
| 951 | 951 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Moved concept_reference_id to the top of the table because it is now a key scoping field