Revision 6789
Added by Aaron Marcuse-Kubitza about 12 years ago
schemas/vegbien.my.sql | ||
---|---|---|
1189 | 1189 |
CREATE TABLE party ( |
1190 | 1190 |
party_id int(11) NOT NULL, |
1191 | 1191 |
source_id int(11) NOT NULL, |
1192 |
sourceaccessioncode varchar(255), |
|
1192 | 1193 |
fullname varchar(255), |
1193 | 1194 |
salutation varchar(255), |
1194 | 1195 |
givenname varchar(255), |
... | ... | |
5107 | 5108 |
|
5108 | 5109 |
|
5109 | 5110 |
-- |
5110 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
5111 |
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
5111 | 5112 |
-- |
5112 | 5113 |
|
5113 | 5114 |
|
5114 | 5115 |
|
5115 | 5116 |
|
5116 | 5117 |
-- |
5118 |
-- Name: party_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
5119 |
-- |
|
5120 |
|
|
5121 |
|
|
5122 |
|
|
5123 |
|
|
5124 |
-- |
|
5117 | 5125 |
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
5118 | 5126 |
-- |
5119 | 5127 |
|
schemas/vegbien.sql | ||
---|---|---|
1961 | 1961 |
CREATE TABLE party ( |
1962 | 1962 |
party_id integer NOT NULL, |
1963 | 1963 |
source_id integer NOT NULL, |
1964 |
sourceaccessioncode text, |
|
1964 | 1965 |
fullname text, |
1965 | 1966 |
salutation text, |
1966 | 1967 |
givenname text, |
... | ... | |
6182 | 6183 |
|
6183 | 6184 |
|
6184 | 6185 |
-- |
6185 |
-- Name: party_unique; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
6186 |
-- Name: party_unique_name; Type: INDEX; Schema: public; Owner: -; Tablespace:
|
|
6186 | 6187 |
-- |
6187 | 6188 |
|
6188 |
CREATE UNIQUE INDEX party_unique ON party USING btree (source_id, (COALESCE(organizationname, '\N'::text)), (COALESCE(fullname, '\N'::text)), (COALESCE(surname, '\N'::text)), (COALESCE(givenname, '\N'::text)), (COALESCE(middlename, '\N'::text)), (COALESCE(suffix, '\N'::text)));
|
|
6189 |
CREATE UNIQUE INDEX party_unique_name ON party USING btree (source_id, (COALESCE(organizationname, '\N'::text)), (COALESCE(fullname, '\N'::text)), (COALESCE(surname, '\N'::text)), (COALESCE(givenname, '\N'::text)), (COALESCE(middlename, '\N'::text)), (COALESCE(suffix, '\N'::text))) WHERE (sourceaccessioncode IS NULL);
|
|
6189 | 6190 |
|
6190 | 6191 |
|
6191 | 6192 |
-- |
6193 |
-- Name: party_unique_sourceaccessioncode; Type: INDEX; Schema: public; Owner: -; Tablespace: |
|
6194 |
-- |
|
6195 |
|
|
6196 |
CREATE UNIQUE INDEX party_unique_sourceaccessioncode ON party USING btree (source_id, (COALESCE(sourceaccessioncode, '\N'::text))) WHERE (sourceaccessioncode IS NOT NULL); |
|
6197 |
|
|
6198 |
|
|
6199 |
-- |
|
6192 | 6200 |
-- Name: place_matched_place_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: |
6193 | 6201 |
-- |
6194 | 6202 |
|
Also available in: Unified diff
schemas/vegbien.sql: party: Added sourceaccessioncode and uniquify on it instead when provided. vegbien.ERD.mwb: Rearranged party-related tables to allow the tables to be fully expanded.