Datenschema: Unterschied zwischen den Versionen

Aktuelle Version vom 9. September 2011, 08:47 Uhr

Struktur der Datentabelle in POSTGRESQL:

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),
  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),
  )
WITH (
  OIDS=TRUE
);

SELECT AddGeometryColumn('','fd_kitas','the_geom','2398','POINT',2);

Erläuterungen zu den Spalteninhalten: