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.