Revision 6296
Added by Aaron Marcuse-Kubitza over 11 years ago
vegbien.sql | ||
---|---|---|
1888 | 1888 |
|
1889 | 1889 |
CREATE TABLE source ( |
1890 | 1890 |
source_id integer NOT NULL, |
1891 |
parent_id integer, |
|
1891 | 1892 |
shortname text, |
1892 | 1893 |
fulltext text, |
1893 | 1894 |
sourcetype sourcetype, |
... | ... | |
7014 | 7015 |
|
7015 | 7016 |
|
7016 | 7017 |
-- |
7018 |
-- Name: source_parent_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
7019 |
-- |
|
7020 |
|
|
7021 |
ALTER TABLE ONLY source |
|
7022 |
ADD CONSTRAINT source_parent_id_fkey FOREIGN KEY (parent_id) REFERENCES source(source_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
7023 |
|
|
7024 |
|
|
7025 |
-- |
|
7017 | 7026 |
-- Name: source_sourcejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
7018 | 7027 |
-- |
7019 | 7028 |
|
Also available in: Unified diff
schemas/vegbien.sql: source: Added parent_id for nested sources, e.g. an article in a journal