Revision 5599
Added by Aaron Marcuse-Kubitza about 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 843 | 843 |
CREATE TABLE party ( |
| 844 | 844 |
party_id int(11) NOT NULL, |
| 845 | 845 |
creator_id int(11) NOT NULL, |
| 846 |
fullname text, |
|
| 846 | 847 |
salutation text, |
| 847 | 848 |
givenname text, |
| 848 | 849 |
middlename text, |
| schemas/vegbien.sql | ||
|---|---|---|
| 1277 | 1277 |
CREATE TABLE party ( |
| 1278 | 1278 |
party_id integer NOT NULL, |
| 1279 | 1279 |
creator_id integer NOT NULL, |
| 1280 |
fullname text, |
|
| 1280 | 1281 |
salutation text, |
| 1281 | 1282 |
givenname text, |
| 1282 | 1283 |
middlename text, |
| ... | ... | |
| 1289 | 1290 |
partypublic boolean DEFAULT true, |
| 1290 | 1291 |
d_obscount integer, |
| 1291 | 1292 |
accessioncode text, |
| 1292 |
CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((creator_id <> party_id) AND (surname IS NOT NULL))))
|
|
| 1293 |
CONSTRAINT party_required_key CHECK (((organizationname IS NOT NULL) OR ((creator_id <> party_id) AND ((fullname IS NOT NULL) OR (surname IS NOT NULL)))))
|
|
| 1293 | 1294 |
); |
| 1294 | 1295 |
|
| 1295 | 1296 |
|
| ... | ... | |
| 4576 | 4577 |
-- Name: party_unique_within_creator; Type: INDEX; Schema: public; Owner: -; Tablespace: |
| 4577 | 4578 |
-- |
| 4578 | 4579 |
|
| 4579 |
CREATE UNIQUE INDEX party_unique_within_creator ON party USING btree (creator_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text))); |
|
| 4580 |
CREATE UNIQUE INDEX party_unique_within_creator ON party USING btree (creator_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(fullname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text)));
|
|
| 4580 | 4581 |
|
| 4581 | 4582 |
|
| 4582 | 4583 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: party: Added fullname