Revision 5615
Added by Aaron Marcuse-Kubitza over 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 198 | 198 |
taxonlabel_id int(11) NOT NULL, |
| 199 | 199 |
creator_id int(11) NOT NULL, |
| 200 | 200 |
sourceaccessioncode text, |
| 201 |
concept_reference_id int(11), |
|
| 201 | 202 |
creationdate date, |
| 202 | 203 |
accepted_label_id int(11), |
| 203 | 204 |
matched_label_id int(11), |
| ... | ... | |
| 241 | 242 |
|
| 242 | 243 |
|
| 243 | 244 |
-- |
| 245 |
-- Name: COLUMN taxonlabel.concept_reference_id; Type: COMMENT; Schema: public; Owner: - |
|
| 246 |
-- |
|
| 247 |
|
|
| 248 |
|
|
| 249 |
|
|
| 250 |
|
|
| 251 |
-- |
|
| 244 | 252 |
-- Name: COLUMN taxonlabel.creationdate; Type: COMMENT; Schema: public; Owner: - |
| 245 | 253 |
-- |
| 246 | 254 |
|
| ... | ... | |
| 4907 | 4915 |
|
| 4908 | 4916 |
|
| 4909 | 4917 |
-- |
| 4918 |
-- Name: taxonlabel_concept_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4919 |
-- |
|
| 4920 |
|
|
| 4921 |
|
|
| 4922 |
|
|
| 4923 |
|
|
| 4924 |
-- |
|
| 4910 | 4925 |
-- Name: taxonlabel_creator_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4911 | 4926 |
-- |
| 4912 | 4927 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonlabel: Added concept_reference_id, which is the entity that defined the taxon concept (who the taxon label is according to)