[M-Gerling]

Hallo Stephan,

hier die Tabellendefinition:

-- Table: public.adressen

-- DROP TABLE public.adressen;

CREATE TABLE public.adressen
(
schuelernr integer,
erzanrede1 character varying(200) COLLATE pg_catalog."default",
erzname1 character varying(200) COLLATE pg_catalog."default",
erzrufname1 character varying(200) COLLATE pg_catalog."default",
erztelefon1 character varying(200) COLLATE pg_catalog."default",
erzart1 character varying(200) COLLATE pg_catalog."default",
erzanrede2 character varying(200) COLLATE pg_catalog."default",
erzname2 character varying(200) COLLATE pg_catalog."default",
erzrufname2 character varying(200) COLLATE pg_catalog."default",
erztelefon2 character varying(200) COLLATE pg_catalog."default",
erzart2 character varying(200) COLLATE pg_catalog."default",
anrede character varying(255) COLLATE pg_catalog."default",
name character varying(255) COLLATE pg_catalog."default",
strasse character varying(200) COLLATE pg_catalog."default",
plz character varying(5) COLLATE pg_catalog."default",
ort character varying(200) COLLATE pg_catalog."default",
telefon character varying(200) COLLATE pg_catalog."default",
gilt1 character varying(200) COLLATE pg_catalog."default",
gilt2 character varying(200) COLLATE pg_catalog."default",
winsvsnr integer,
adressen_id integer NOT NULL DEFAULT nextval('adressen_adressen_id_seq'::regclass),
im_verteiler boolean DEFAULT false,
briefanrede character varying(255) COLLATE pg_catalog."default",
hauptansprechpartner boolean DEFAULT false,
auskunftsberechtigt boolean DEFAULT false,
anschrift_wessen character varying(2) COLLATE pg_catalog."default" DEFAULT 1,
staat character varying(255) COLLATE pg_catalog."default",
last_update timestamp without time zone DEFAULT now(),
CONSTRAINT adressen_pkey PRIMARY KEY (adressen_id)
)
WITH (
OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.adressen
OWNER to nmsv0718;


Gruß

Michael