|
id
|
int(11)
|
|
|
|
|
company
|
varchar(255)
|
|
|
|
|
salutation
|
varchar(255)
|
|
|
|
|
briefanrede
|
varchar(255)
|
|
|
|
|
title
|
varchar(255)
|
|
|
|
|
dateOfBirth
|
date
|
|
|
|
|
firstname
|
varchar(255)
|
|
|
|
|
surname
|
varchar(255)
|
|
|
|
|
addressBlock
|
text
|
|
|
|
|
street
|
varchar(255)
|
|
|
|
|
postcode
|
int(11)
|
|
|
|
|
city
|
varchar(255)
|
|
|
|
|
telephoneNo
|
varchar(255)
|
|
|
|
|
mobileNo
|
varchar(255)
|
|
|
|
|
email
|
varchar(255)
|
|
|
|
|
areas
|
varchar(255)
|
|
|
|
|
notNeedMoreInforming
|
int(11)
|
|
|
0
|
|
noEmailCheck
|
int(11)
|
|
|
0
|
|
emailCheckedDate
|
date
|
|
|
|
|
MemberType
|
enum
|
-- |
|
member
|
|
MemberFinalType
|
enum
|
-- |
|
member
|
|
BearbeitungsStatus
|
tinyint(3) unsigned
|
|
|
0
|
|
BriefSex
|
varchar(255)
|
|
|
|
|
MoneyPayerID
|
int(11)
|
|
|
-1
|
|
CountOfBed
|
int(10) unsigned
|
|
|
0
|
|
NewsletterLanguage
|
enum
|
-- |
|
german
|
|
StartExt
|
varchar(255)
|
|
|
|
|
StartFile
|
longblob
|
|
|
Binary - do not edit (0 B)
(Max: 4,096MiB)
|
|
TillDate
|
date
|
|
|
2030-01-01
|
|
FromDate
|
date
|
|
|
2030-01-01
|
|
FinishFile
|
longblob
|
|
|
Binary - do not edit (0 B)
(Max: 4,096MiB)
|
|
FinishExt
|
varchar(255)
|
|
|
|
|
StillToEdit
|
enum
|
-- |
|
Nein
|
|
BankInfoForStiillToEdit
|
varchar(255)
|
|
|
|
|
status
|
int(11)
|
|
|
1
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
2026-02-10 09:37:41.000000
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|