Revision 4729
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 2380 | 2380 |
rank text NOT NULL, |
| 2381 | 2381 |
verbatimrank text, |
| 2382 | 2382 |
taxonname text NOT NULL, |
| 2383 |
authority text,
|
|
| 2383 |
authority_id int(11),
|
|
| 2384 | 2384 |
description text, |
| 2385 | 2385 |
accessioncode text |
| 2386 | 2386 |
); |
| ... | ... | |
| 4920 | 4920 |
|
| 4921 | 4921 |
|
| 4922 | 4922 |
-- |
| 4923 |
-- Name: taxon_authority_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 4924 |
-- |
|
| 4925 |
|
|
| 4926 |
|
|
| 4927 |
|
|
| 4928 |
|
|
| 4929 |
-- |
|
| 4923 | 4930 |
-- Name: taxon_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 4924 | 4931 |
-- |
| 4925 | 4932 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxon: Made authority an fkey to reference instead of a text field