-- Name: referenceparty; Type: TABLE; Schema: public; Owner: -; Tablespace: 

--

CREATE TABLE referenceparty (

    referenceparty_id int(11) NOT NULL,

    type text,

    positionname text,

    salutation text,

    givenname text,

    surname text,

    suffix text,

    organizationname text,

    currentparty_id int(11),

    accessioncode text

);

--

-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE; Schema: public; Owner: -

--

--

-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: -

--

--

-- Name: referenceparty_referenceparty_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -

--

--

-- Name: referenceparty_id; Type: DEFAULT; Schema: public; Owner: -

--

--

-- Data for Name: referenceparty; Type: TABLE DATA; Schema: public; Owner: -

--

--

-- Name: referenceparty_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 

--

ALTER TABLE referenceparty

    ADD CONSTRAINT referenceparty_pkey PRIMARY KEY (referenceparty_id);

--

-- Name: referenceparty_accessioncode_index; Type: INDEX; Schema: public; Owner: -; Tablespace: 

--

CREATE UNIQUE INDEX referenceparty_accessioncode_index ON referenceparty  (accessioncode);

--

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

--

ALTER TABLE referenceparty

    ADD CONSTRAINT referenceparty_currentparty_id_fkey FOREIGN KEY (currentparty_id) REFERENCES referenceparty(referenceparty_id) ON UPDATE CASCADE ON DELETE CASCADE;

--