Project

General

Profile

« Previous | Next » 

Revision 6789

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.

View differences:

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