Datenschema: Unterschied zwischen den Versionen
Aus kvwmap
| Zeile 1: | Zeile 1: | ||
| + | Struktur der Datentabelle in POSTGRESQL: | ||
| + | |||
<nowiki> | <nowiki> | ||
CREATE TABLE fd_kitas | CREATE TABLE fd_kitas | ||
| Zeile 25: | Zeile 27: | ||
portal_eintrag character varying(4) NOT NULL DEFAULT 'ja'::character varying, | portal_eintrag character varying(4) NOT NULL DEFAULT 'ja'::character varying, | ||
CONSTRAINT fd_kitas_pkey PRIMARY KEY (id), | CONSTRAINT fd_kitas_pkey PRIMARY KEY (id), | ||
| − | + | ) | |
| − | + | ||
| − | + | ||
| − | ) | + | |
WITH ( | WITH ( | ||
OIDS=TRUE | OIDS=TRUE | ||
| − | );</nowiki> | + | ); |
| + | |||
| + | SELECT AddGeometryColumn('','fd_kitas','the_geom','2398','POINT',2); | ||
| + | </nowiki> | ||
| + | |||
| + | |||
| + | Erläuterungen zu den Spalteninhalten: | ||
Version vom 9. September 2011, 08:57 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:
