Datenschema: Unterschied zwischen den Versionen

Version vom 9. September 2011, 07:06 Uhr

CREATE TABLE fd_kitas ( id integer NOT NULL DEFAULT nextval('fd_kitas_gid_seq'::regclass), "name" character varying(50), strasse character varying(50), plz_ort character varying(50), traeger character varying(50), open character varying(50), angebote character varying(150), art_traeger character varying(50), the_geom geometry, art character varying(11) NOT NULL, krippe integer, kindergarten integer, hort integer, ap text, tel text, fax text, email text, amt text, bild character varying(255), oeffentlich character varying(4) NOT NULL DEFAULT 'nein'::character varying, copyright character varying(50), bilddatum date, portal_eintrag character varying(4) NOT NULL DEFAULT 'ja'::character varying, CONSTRAINT fd_kitas_pkey PRIMARY KEY (id), CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2), CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) = 'POINT'::text OR the_geom IS NULL), CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 2398) ) WITH ( OIDS=TRUE );