Revision 6178
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 2628 | 2628 |
|
| 2629 | 2629 |
CREATE TABLE referencename ( |
| 2630 | 2630 |
referencename_id int(11) NOT NULL, |
| 2631 |
reference_id int(11), |
|
| 2631 |
reference_id int(11) NOT NULL,
|
|
| 2632 | 2632 |
system text, |
| 2633 |
name text NOT NULL |
|
| 2633 |
name text NOT NULL, |
|
| 2634 |
matched_reference_id int(11) |
|
| 2634 | 2635 |
); |
| 2635 | 2636 |
|
| 2636 | 2637 |
|
| ... | ... | |
| 5974 | 5975 |
|
| 5975 | 5976 |
|
| 5976 | 5977 |
-- |
| 5977 |
-- Name: referencename_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5978 |
-- Name: referencename_matched_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
|
|
| 5978 | 5979 |
-- |
| 5979 | 5980 |
|
| 5980 | 5981 |
ALTER TABLE referencename |
| 5981 |
ADD CONSTRAINT referencename_reference_id_fkey FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5982 |
ADD CONSTRAINT referencename_matched_reference_id_fkey FOREIGN KEY (matched_reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE;
|
|
| 5982 | 5983 |
|
| 5983 | 5984 |
|
| 5984 | 5985 |
-- |
| 5986 |
-- Name: referencename_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 5987 |
-- |
|
| 5988 |
|
|
| 5989 |
|
|
| 5990 |
|
|
| 5991 |
|
|
| 5992 |
-- |
|
| 5985 | 5993 |
-- Name: revision_previousrevision_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 5986 | 5994 |
-- |
| 5987 | 5995 |
|
| schemas/filter_ERD.csv | ||
|---|---|---|
| 8 | 8 |
"^ALTER TABLE (?!method)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES method\b[^;]*;",,inward |
| 9 | 9 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\(submethod_id\) REFERENCES method\b[^;]*;",,inward |
| 10 | 10 |
"^ALTER TABLE (?!party|address|referencecontributor|telephone)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES party\b[^;]*;",,inward |
| 11 |
"^ALTER TABLE (?!reference)\b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES reference\b[^;]*;",,inward
|
|
| 11 |
"^ALTER TABLE (?!referencecontributor)\b[^;]*\bFOREIGN KEY\b[^;]*\((?:reference_id|commauthority_id|concept_reference_id)\) REFERENCES reference\b[^;]*;",,inward
|
|
| 12 | 12 |
"^ALTER TABLE \b[^;]*\bFOREIGN KEY\b[^;]*\bREFERENCES referencename\b[^;]*;",,inward |
| schemas/vegbien.sql | ||
|---|---|---|
| 3503 | 3503 |
|
| 3504 | 3504 |
CREATE TABLE referencename ( |
| 3505 | 3505 |
referencename_id integer NOT NULL, |
| 3506 |
reference_id integer, |
|
| 3506 |
reference_id integer NOT NULL,
|
|
| 3507 | 3507 |
system text, |
| 3508 |
name text NOT NULL |
|
| 3508 |
name text NOT NULL, |
|
| 3509 |
matched_reference_id integer |
|
| 3509 | 3510 |
); |
| 3510 | 3511 |
|
| 3511 | 3512 |
|
| ... | ... | |
| 6068 | 6069 |
-- Name: referencename_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 6069 | 6070 |
-- |
| 6070 | 6071 |
|
| 6071 |
CREATE UNIQUE INDEX referencename_unique ON referencename USING btree ((COALESCE(name, '\\N'::text))); |
|
| 6072 |
CREATE UNIQUE INDEX referencename_unique ON referencename USING btree (reference_id, (COALESCE(name, '\\N'::text)));
|
|
| 6072 | 6073 |
|
| 6073 | 6074 |
|
| 6074 | 6075 |
-- |
| ... | ... | |
| 6988 | 6989 |
|
| 6989 | 6990 |
|
| 6990 | 6991 |
-- |
| 6992 |
-- Name: referencename_matched_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6993 |
-- |
|
| 6994 |
|
|
| 6995 |
ALTER TABLE ONLY referencename |
|
| 6996 |
ADD CONSTRAINT referencename_matched_reference_id_fkey FOREIGN KEY (matched_reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6997 |
|
|
| 6998 |
|
|
| 6999 |
-- |
|
| 6991 | 7000 |
-- Name: referencename_reference_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6992 | 7001 |
-- |
| 6993 | 7002 |
|
Also available in: Unified diff
schemas/vegbien.sql: referencename: Scope it by top-level datasource, because institutionCodes (which map to this field) are not globally unique. This involves renaming the previous reference_id field, which was for the matched reference, to matched_reference_id, to allow a scoping reference_id field.