Revision 719
Added by Aaron Marcuse-Kubitza about 13 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 1675 | 1675 |
stopdate timestamp NULL, |
| 1676 | 1676 |
d_obscount int(11), |
| 1677 | 1677 |
d_lastlocationaddeddate timestamp NULL, |
| 1678 |
accessioncode character varying(255) |
|
| 1678 |
accessioncode character varying(255), |
|
| 1679 |
reference_id int(11) |
|
| 1679 | 1680 |
); |
| 1680 | 1681 |
|
| 1681 | 1682 |
|
| ... | ... | |
| 3987 | 3988 |
-- |
| 3988 | 3989 |
|
| 3989 | 3990 |
ALTER TABLE project |
| 3990 |
ADD CONSTRAINT project_keys UNIQUE (projectname, startdate, stopdate);
|
|
| 3991 |
ADD CONSTRAINT project_keys UNIQUE (reference_id, projectname);
|
|
| 3991 | 3992 |
|
| 3992 | 3993 |
|
| 3993 | 3994 |
-- |
| ... | ... | |
| 6165 | 6166 |
|
| 6166 | 6167 |
|
| 6167 | 6168 |
-- |
| 6169 |
-- Name: project_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6170 |
-- |
|
| 6171 |
|
|
| 6172 |
ALTER TABLE project |
|
| 6173 |
ADD CONSTRAINT project_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6174 |
|
|
| 6175 |
|
|
| 6176 |
-- |
|
| 6168 | 6177 |
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6169 | 6178 |
-- |
| 6170 | 6179 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 1936 | 1936 |
stopdate timestamp with time zone, |
| 1937 | 1937 |
d_obscount integer, |
| 1938 | 1938 |
d_lastlocationaddeddate timestamp with time zone, |
| 1939 |
accessioncode character varying(255) |
|
| 1939 |
accessioncode character varying(255), |
|
| 1940 |
reference_id integer |
|
| 1940 | 1941 |
); |
| 1941 | 1942 |
|
| 1942 | 1943 |
|
| ... | ... | |
| 4433 | 4434 |
-- |
| 4434 | 4435 |
|
| 4435 | 4436 |
ALTER TABLE ONLY project |
| 4436 |
ADD CONSTRAINT project_keys UNIQUE (projectname, startdate, stopdate);
|
|
| 4437 |
ADD CONSTRAINT project_keys UNIQUE (reference_id, projectname);
|
|
| 4437 | 4438 |
|
| 4438 | 4439 |
|
| 4439 | 4440 |
-- |
| ... | ... | |
| 6611 | 6612 |
|
| 6612 | 6613 |
|
| 6613 | 6614 |
-- |
| 6615 |
-- Name: project_reference_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
|
| 6616 |
-- |
|
| 6617 |
|
|
| 6618 |
ALTER TABLE ONLY project |
|
| 6619 |
ADD CONSTRAINT project_reference_id FOREIGN KEY (reference_id) REFERENCES reference(reference_id) ON UPDATE CASCADE ON DELETE CASCADE; |
|
| 6620 |
|
|
| 6621 |
|
|
| 6622 |
-- |
|
| 6614 | 6623 |
-- Name: projectcontributor_party_id; Type: FK CONSTRAINT; Schema: public; Owner: - |
| 6615 | 6624 |
-- |
| 6616 | 6625 |
|
Also available in: Unified diff
vegbien.sql: Added project.reference_id to namespace project names by datasource