Revision 7335
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 2382 | 2382 |
|
| 2383 | 2383 |
CREATE TABLE taxonverbatim ( |
| 2384 | 2384 |
taxonverbatim_id integer NOT NULL, |
| 2385 |
source_id integer NOT NULL, |
|
| 2385 | 2386 |
taxonlabel_id integer NOT NULL, |
| 2386 | 2387 |
verbatimrank text, |
| 2387 | 2388 |
taxonomicname text, |
| ... | ... | |
| 8475 | 8476 |
|
| 8476 | 8477 |
|
| 8477 | 8478 |
-- |
| 8479 |
-- Name: taxonverbatim_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 8480 |
-- |
|
| 8481 |
|
|
| 8482 |
ALTER TABLE ONLY taxonverbatim |
|
| 8483 |
ADD CONSTRAINT taxonverbatim_source_id_fkey FOREIGN KEY (source_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 8484 |
|
|
| 8485 |
|
|
| 8486 |
-- |
|
| 8478 | 8487 |
-- Name: taxonverbatim_taxonlabel_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 8479 | 8488 |
-- |
| 8480 | 8489 |
|
Also available in: Unified diff
schemas/vegbien.sql: taxonverbatim: Added source_id to allow creating taxonverbatims without a (scoping) taxonlabel