DBINDEX
|
int(11)
|
|
|
|
ART
|
int(11)
|
|
|
|
NUMMER
|
int(11)
|
|
|
|
ANREDE
|
char(30)
|
latin1_german1_ci
|
|
|
TITEL
|
char(30)
|
latin1_german1_ci
|
|
|
NACHNAMEFIRMA
|
char(50)
|
latin1_german1_ci
|
|
|
VORNAME
|
char(50)
|
latin1_german1_ci
|
|
|
ZUSATZ
|
char(50)
|
latin1_german1_ci
|
|
|
STRASSE
|
char(50)
|
latin1_german1_ci
|
|
|
LAND
|
char(5)
|
latin1_german1_ci
|
|
|
PLZ
|
char(10)
|
latin1_german1_ci
|
|
|
ORT
|
char(50)
|
latin1_german1_ci
|
|
|
TELEFON1
|
char(40)
|
latin1_german1_ci
|
|
|
TELEFON2
|
char(40)
|
latin1_german1_ci
|
|
|
FAX
|
char(40)
|
latin1_german1_ci
|
|
|
MOBILTELEFON
|
char(40)
|
latin1_german1_ci
|
|
|
EMAIL
|
char(50)
|
latin1_german1_ci
|
|
|
WEBSEITE
|
char(50)
|
latin1_german1_ci
|
|
|
DEBITORENNUMMER
|
char(10)
|
latin1_german1_ci
|
|
|
ANMERKUNGEN
|
blob
|
|
|
|
INDIVIDUELL1
|
char(50)
|
latin1_german1_ci
|
|
|
INDIVIDUELL2
|
char(50)
|
latin1_german1_ci
|
|
|
INDIVIDUELL3
|
char(50)
|
latin1_german1_ci
|
|
|
INDIVIDUELL4
|
char(50)
|
latin1_german1_ci
|
|
|
INDIVIDUELL5
|
char(50)
|
latin1_german1_ci
|
|
|
GEBURTSTAG
|
date
|
|
|
|
FAMILIENSTATUS
|
int(11)
|
|
|
|
EINTRITTSDATUM
|
date
|
|
|
|
AUSTRITTSDATUM
|
date
|
|
|
|
AKTIVVON
|
date
|
|
|
|
AKTIVBIS
|
date
|
|
|
|
ANSPRECHPARTNER_ANREDE
|
char(30)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_TITEL
|
char(30)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_NACHNAME
|
char(30)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_VORNAME
|
char(20)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_POSITION
|
char(30)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_TELEFON1
|
char(40)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_TELEFON2
|
char(40)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_FAX
|
char(40)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_MOBILTELEFON
|
char(40)
|
latin1_german1_ci
|
|
|
ANSPRECHPARTNER_EMAIL
|
char(50)
|
latin1_german1_ci
|
|
|
FUNKTION
|
varchar(30)
|
latin1_german1_ci
|
|
|