Revision 6304
Added by Aaron Marcuse-Kubitza over 11 years ago
vegbien.my.sql | ||
---|---|---|
1200 | 1200 |
accessconditions text, |
1201 | 1201 |
title text, |
1202 | 1202 |
titlesuperior text, |
1203 |
sourcejournal_id int(11), |
|
1204 | 1203 |
volume text, |
1205 | 1204 |
issue text, |
1206 | 1205 |
pagerange text, |
... | ... | |
2730 | 2729 |
|
2731 | 2730 |
|
2732 | 2731 |
-- |
2733 |
-- Name: sourcejournal; Type: TABLE; Schema: public; Owner: -; Tablespace: |
|
2734 |
-- |
|
2735 |
|
|
2736 |
CREATE TABLE sourcejournal ( |
|
2737 |
sourcejournal_id int(11) NOT NULL, |
|
2738 |
journal text NOT NULL, |
|
2739 |
issn text, |
|
2740 |
abbreviation text, |
|
2741 |
accessioncode text |
|
2742 |
); |
|
2743 |
|
|
2744 |
|
|
2745 |
-- |
|
2746 |
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE; Schema: public; Owner: - |
|
2747 |
-- |
|
2748 |
|
|
2749 |
|
|
2750 |
|
|
2751 |
|
|
2752 |
-- |
|
2753 |
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: - |
|
2754 |
-- |
|
2755 |
|
|
2756 |
|
|
2757 |
|
|
2758 |
|
|
2759 |
-- |
|
2760 |
-- Name: sourcejournal_sourcejournal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: - |
|
2761 |
-- |
|
2762 |
|
|
2763 |
|
|
2764 |
|
|
2765 |
-- |
|
2766 | 2732 |
-- Name: sourcename; Type: TABLE; Schema: public; Owner: -; Tablespace: |
2767 | 2733 |
-- |
2768 | 2734 |
|
... | ... | |
3655 | 3621 |
|
3656 | 3622 |
|
3657 | 3623 |
-- |
3658 |
-- Name: sourcejournal_id; Type: DEFAULT; Schema: public; Owner: - |
|
3659 |
-- |
|
3660 |
|
|
3661 |
|
|
3662 |
|
|
3663 |
|
|
3664 |
-- |
|
3665 | 3624 |
-- Name: sourcename_id; Type: DEFAULT; Schema: public; Owner: - |
3666 | 3625 |
-- |
3667 | 3626 |
|
... | ... | |
4070 | 4029 |
|
4071 | 4030 |
|
4072 | 4031 |
-- |
4073 |
-- Data for Name: sourcejournal; Type: TABLE DATA; Schema: public; Owner: - |
|
4074 |
-- |
|
4075 |
|
|
4076 |
|
|
4077 |
|
|
4078 |
-- |
|
4079 | 4032 |
-- Data for Name: sourcename; Type: TABLE DATA; Schema: public; Owner: - |
4080 | 4033 |
-- |
4081 | 4034 |
|
... | ... | |
4596 | 4549 |
|
4597 | 4550 |
|
4598 | 4551 |
-- |
4599 |
-- Name: sourcejournal_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
|
4600 |
-- |
|
4601 |
|
|
4602 |
ALTER TABLE sourcejournal |
|
4603 |
ADD CONSTRAINT sourcejournal_pkey PRIMARY KEY (sourcejournal_id); |
|
4604 |
|
|
4605 |
|
|
4606 |
-- |
|
4607 | 4552 |
-- Name: sourcename_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: |
4608 | 4553 |
-- |
4609 | 4554 |
|
... | ... | |
5090 | 5035 |
|
5091 | 5036 |
|
5092 | 5037 |
-- |
5093 |
-- Name: sourcejournal_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
5094 |
-- |
|
5095 |
|
|
5096 |
CREATE UNIQUE INDEX sourcejournal_accessioncode_index ON sourcejournal (accessioncode); |
|
5097 |
|
|
5098 |
|
|
5099 |
-- |
|
5100 | 5038 |
-- Name: sourcename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
5101 | 5039 |
-- |
5102 | 5040 |
|
... | ... | |
5999 | 5937 |
|
6000 | 5938 |
|
6001 | 5939 |
-- |
6002 |
-- Name: source_sourcejournal_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
6003 |
-- |
|
6004 |
|
|
6005 |
ALTER TABLE source |
|
6006 |
ADD CONSTRAINT source_sourcejournal_id_fkey FOREIGN KEY (sourcejournal_id) REFERENCES sourcejournal(sourcejournal_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
6007 |
|
|
6008 |
|
|
6009 |
-- |
|
6010 | 5940 |
-- Name: sourcecontributor_source_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
6011 | 5941 |
-- |
6012 | 5942 |
|
Also available in: Unified diff
schemas/vegbien.sql: Removed no longer needed sourcejournal, which can be stored in source and pointed to via parent_id instead of sourcejournal_id. sourcejournal.journal maps to source.fulltext, issn to isbn, and abbreviation to shortname.