Revision 5469
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 788 | 788 |
CREATE TABLE taxonconcept ( |
| 789 | 789 |
taxonconcept_id int(11) NOT NULL, |
| 790 | 790 |
creator_id int(11) NOT NULL, |
| 791 |
sourceaccessioncode text, |
|
| 791 | 792 |
creationdate timestamp NULL, |
| 792 | 793 |
accepted_concept_id int(11), |
| 793 | 794 |
matched_concept_id int(11), |
| ... | ... | |
| 3935 | 3936 |
|
| 3936 | 3937 |
|
| 3937 | 3938 |
-- |
| 3939 |
-- Name: taxonconcept_1_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
| 3940 |
-- |
|
| 3941 |
|
|
| 3942 |
|
|
| 3943 |
|
|
| 3944 |
|
|
| 3945 |
-- |
|
| 3938 | 3946 |
-- Name: taxonconcept_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 3939 | 3947 |
-- |
| 3940 | 3948 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonconcept: Added sourceaccessioncode, and allow it to scope the taxonconcept when provided