PostGIS-Implementierung: backup_xe_mini_ds_schema.backup

--
-- PostgreSQL database dump
--

-- Dumped from database version 8.3.3
-- Dumped by pg_dump version 9.5.1

-- Started on 2016-04-05 11:11:54

SET statement_timeout = 0;
SET lock_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;
SET row_security = off;

SET search_path = xe_mini_ds, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = true;

--
-- TOC entry 1539 (class 1259 OID 886477739)
-- Name: xe_mini_ovi_tb; Type: TABLE; Schema: xe_mini_ds; Owner: gdp
--

CREATE TABLE xe_mini_ovi_tb (
    gid integer NOT NULL,
    objektuuid character varying(254),
    objektname character varying(254),
    objektcode integer,
    objektfunktion character varying(254),
    objektkategorie character varying(254),
    metainfoquelle character varying(254),
    metapflegendestelle character varying(254),
    metalebenszeitstart date,
    metazuletztbearbeitetam date,
    lageanfasspunkt public.geometry,
    objektthesaurusversion character varying(254),
    besuchoeffnungtext character varying(254),
    infobeschreibung character varying(254),
    infoexterneinfo1externeinfo character varying(254),
    infoexterneinfo1titel character varying(254),
    infoexterneinfo1beschreibung character varying(254),
    infoexterneinfo1infoart character varying(254),
    infoexterneinfo1mimetype character varying(254),
    infoexterneinfo1namensraum character varying(254),
    klassifizierungbedeutung character varying(254),
    klassifizierungtourismus character varying(254),
    lageanfasspunktostwert integer,
    lageanfasspunktnordwert integer,
    metalebenszeitende date,
    objektadresseland character varying(254),
    objektadresseort character varying(254),
    objektadresseortsteil character varying(254),
    objektadresseplz character varying(254),
    objektadressestrasse character varying(254),
    objektadressehausnr character varying(254),
    objektemail character varying(254),
    objekttelefonvorwahlinternational integer,
    objekttelefonvorwahl integer,
    objekttelefonortsanschluss integer,
    CONSTRAINT enforce_dims_anfasspkt CHECK ((public.ndims(lageanfasspunkt) = 2)),
    CONSTRAINT enforce_geotype_anfasspkt CHECK (((public.geometrytype(lageanfasspunkt) = 'POINT'::text) OR (lageanfasspunkt IS NULL))),
    CONSTRAINT enforce_srid_anfasspkt CHECK ((public.srid(lageanfasspunkt) = 25832)),
    CONSTRAINT xe_mini_ovi_code_nn CHECK ((objektcode IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_extinfoart_ch CHECK (((infoexterneinfo1infoart IS NULL) OR ((infoexterneinfo1infoart)::text = ANY ((ARRAY['Geometrie'::character varying, 'Bild'::character varying, 'Video'::character varying, 'Audio'::character varying, 'Dokument'::character varying, 'Buchung'::character varying, 'Website'::character varying, 'Datenbankobjekt'::character varying, 'Sonstiges'::character varying])::text[])))),
    CONSTRAINT xe_mini_ovi_funktion_nn CHECK ((objektfunktion IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_kategorie_nn CHECK ((objektkategorie IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_klass_bed_ch CHECK (((klassifizierungbedeutung IS NULL) OR ((klassifizierungbedeutung)::text = ANY ((ARRAY['Lokal'::character varying, 'Regional'::character varying, 'Ueberregional'::character varying])::text[])))),
    CONSTRAINT xe_mini_ovi_klass_tms_ch CHECK (((klassifizierungtourismus IS NULL) OR ((klassifizierungtourismus)::text = ANY ((ARRAY['Lokalsehenswert'::character varying, 'Regionalsehenswert'::character varying, 'Ueberregionalsehenswert'::character varying])::text[])))),
    CONSTRAINT xe_mini_ovi_metalzst_nn CHECK ((metalebenszeitstart IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_metapfst_nn CHECK ((metapflegendestelle IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_metazlba_nn CHECK ((metazuletztbearbeitetam IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_name_nn CHECK ((objektname IS NOT NULL)),
    CONSTRAINT xe_mini_ovi_uuid_nn CHECK ((objektuuid IS NOT NULL))
);


ALTER TABLE xe_mini_ovi_tb OWNER TO gdp;

--
-- TOC entry 1538 (class 1259 OID 886477737)
-- Name: xe_mini_ovi_tb_gid_seq; Type: SEQUENCE; Schema: xe_mini_ds; Owner: gdp
--

CREATE SEQUENCE xe_mini_ovi_tb_gid_seq
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE xe_mini_ovi_tb_gid_seq OWNER TO gdp;

--
-- TOC entry 7070 (class 0 OID 0)
-- Dependencies: 1538
-- Name: xe_mini_ovi_tb_gid_seq; Type: SEQUENCE OWNED BY; Schema: xe_mini_ds; Owner: gdp
--

ALTER SEQUENCE xe_mini_ovi_tb_gid_seq OWNED BY xe_mini_ovi_tb.gid;


--
-- TOC entry 6880 (class 2604 OID 886477742)
-- Name: gid; Type: DEFAULT; Schema: xe_mini_ds; Owner: gdp
--

ALTER TABLE ONLY xe_mini_ovi_tb ALTER COLUMN gid SET DEFAULT nextval('xe_mini_ovi_tb_gid_seq'::regclass);


--
-- TOC entry 6899 (class 2606 OID 886477761)
-- Name: xe_mini_ovi_gid_pkey; Type: CONSTRAINT; Schema: xe_mini_ds; Owner: gdp
--

ALTER TABLE ONLY xe_mini_ovi_tb
    ADD CONSTRAINT xe_mini_ovi_gid_pkey PRIMARY KEY (gid);


--
-- TOC entry 6895 (class 1259 OID 886477762)
-- Name: xe_mini_ovi_anfasspunkt_gist; Type: INDEX; Schema: xe_mini_ds; Owner: gdp
--

CREATE INDEX xe_mini_ovi_anfasspunkt_gist ON xe_mini_ovi_tb USING gist (lageanfasspunkt);


--
-- TOC entry 6896 (class 1259 OID 886477763)
-- Name: xe_mini_ovi_code_ix; Type: INDEX; Schema: xe_mini_ds; Owner: gdp
--

CREATE INDEX xe_mini_ovi_code_ix ON xe_mini_ovi_tb USING btree (objektcode);


--
-- TOC entry 6897 (class 1259 OID 886477764)
-- Name: xe_mini_ovi_funktion_ix; Type: INDEX; Schema: xe_mini_ds; Owner: gdp
--

CREATE INDEX xe_mini_ovi_funktion_ix ON xe_mini_ovi_tb USING btree (objektfunktion);


--
-- TOC entry 6900 (class 1259 OID 886477765)
-- Name: xe_mini_ovi_kategorie_ix; Type: INDEX; Schema: xe_mini_ds; Owner: gdp
--

CREATE INDEX xe_mini_ovi_kategorie_ix ON xe_mini_ovi_tb USING btree (objektkategorie);


-- Completed on 2016-04-05 11:11:55

--
-- PostgreSQL database dump complete
--