-- Name: party_datasource_id_self_ref(); Type: FUNCTION; Schema: public; Owner: -

--

CREATE FUNCTION party_datasource_id_self_ref() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

BEGIN

    IF new.party_id IS NULL THEN -- prepopulate party_id

        new.party_id = nextval('party_party_id_seq'::regclass);

    END IF;

    IF new.datasource_id = 0 THEN -- make self-reference

        new.datasource_id = new.party_id;

    END IF;

    RETURN new;

END;

$$;

--

    datasource_id integer NOT NULL,

-- Name: COLUMN party.datasource_id; Type: COMMENT; Schema: public; Owner: -

--

COMMENT ON COLUMN party.datasource_id IS 'A datasource should point to itself in this field. This will happen automatically by setting it to the special value 0.';

--

CREATE UNIQUE INDEX party_unique ON party USING btree (datasource_id, (COALESCE(organizationname, '\\N'::text)), (COALESCE(surname, '\\N'::text)), (COALESCE(givenname, '\\N'::text)), (COALESCE(middlename, '\\N'::text)));

-- Name: party_datasource_id_self_ref; Type: TRIGGER; Schema: public; Owner: -

--

CREATE TRIGGER party_datasource_id_self_ref BEFORE INSERT OR UPDATE ON party FOR EACH ROW EXECUTE PROCEDURE party_datasource_id_self_ref();

--

-- Name: party_datasource_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -

--

ALTER TABLE ONLY party

    ADD CONSTRAINT party_datasource_id_fkey FOREIGN KEY (datasource_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;

--