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

--

CREATE TABLE locationdetermination (

    locationdetermination_id integer NOT NULL,

    location_id integer NOT NULL,

    calculated boolean,

    namedplace_id integer NOT NULL,

    identifier_id integer

);

--

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

--

CREATE SEQUENCE locationdetermination_locationdetermination_id_seq

    START WITH 1

    INCREMENT BY 1

    NO MINVALUE

    NO MAXVALUE

    CACHE 1;

--

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

--

ALTER SEQUENCE locationdetermination_locationdetermination_id_seq OWNED BY locationdetermination.locationdetermination_id;

--

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

--

ALTER TABLE locationdetermination ALTER COLUMN locationdetermination_id SET DEFAULT nextval('locationdetermination_locationdetermination_id_seq'::regclass);

--

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

--

ALTER TABLE ONLY locationdetermination

    ADD CONSTRAINT locationdetermination_keys UNIQUE (location_id, namedplace_id);

--

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

--

ALTER TABLE ONLY locationdetermination

    ADD CONSTRAINT locationdetermination_pkey PRIMARY KEY (locationdetermination_id);

--

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

--

CREATE INDEX fki_locationdetermination_identifier_id ON locationdetermination USING btree (identifier_id);

--

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

--

CREATE INDEX locationdetermination_location_id_x ON locationdetermination USING btree (location_id);

--

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

--

CREATE INDEX locationdetermination_namedplace_id_x ON locationdetermination USING btree (namedplace_id);

--

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

--

ALTER TABLE ONLY locationdetermination

    ADD CONSTRAINT locationdetermination_identifier_id FOREIGN KEY (identifier_id) REFERENCES party(party_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

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

--

ALTER TABLE ONLY locationdetermination

    ADD CONSTRAINT locationdetermination_location_id FOREIGN KEY (location_id) REFERENCES location(location_id) ON UPDATE CASCADE ON DELETE CASCADE;

--

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

--

ALTER TABLE ONLY locationdetermination

    ADD CONSTRAINT locationdetermination_namedplace_id FOREIGN KEY (namedplace_id) REFERENCES namedplace(namedplace_id) ON UPDATE CASCADE ON DELETE CASCADE;

--