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

--

CREATE TABLE referenceparty (

    referenceparty_id integer NOT NULL,

    type text,

    positionname text,

    salutation text,

    givenname text,

    surname text,

    suffix text,

    organizationname text,

    currentparty_id integer,

    accessioncode text

);

--

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

--

CREATE SEQUENCE referenceparty_referenceparty_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE referenceparty_referenceparty_id_seq OWNED BY referenceparty.referenceparty_id;

--

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

--

--

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

--

ALTER TABLE referenceparty ALTER COLUMN referenceparty_id SET DEFAULT nextval('referenceparty_referenceparty_id_seq'::regclass);

--

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

--

--

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

--

ALTER TABLE ONLY 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 USING btree (accessioncode);

--

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

--

ALTER TABLE ONLY referenceparty

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

--