Revision 7335
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.my.sql | ||
|---|---|---|
| 1508 | 1508 |
|
| 1509 | 1509 |
CREATE TABLE taxonverbatim ( |
| 1510 | 1510 |
taxonverbatim_id int(11) NOT NULL, |
| 1511 |
source_id int(11) NOT NULL, |
|
| 1511 | 1512 |
taxonlabel_id int(11) NOT NULL, |
| 1512 | 1513 |
verbatimrank varchar(255), |
| 1513 | 1514 |
taxonomicname varchar(255), |
| ... | ... | |
| 7250 | 7251 |
|
| 7251 | 7252 |
|
| 7252 | 7253 |
-- |
| 7254 |
-- Name: taxonverbatim_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 7255 |
-- |
|
| 7256 |
|
|
| 7257 |
|
|
| 7258 |
|
|
| 7259 |
|
|
| 7260 |
-- |
|
| 7253 | 7261 |
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 7254 | 7262 |
-- |
| 7255 | 7263 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: Added source_id to allow creating taxonverbatims without a (scoping) taxonlabel