|
id
|
int(10) unsigned
|
|
|
|
|
type
|
varchar(255)
|
|
|
|
|
sub_type
|
varchar(255)
|
|
|
|
|
Name
|
varchar(40)
|
|
|
|
|
Street
|
varchar(40)
|
|
|
|
|
PLZ
|
int(11)
|
|
|
0
|
|
Town
|
varchar(40)
|
|
|
|
|
POBox
|
varchar(50)
|
|
|
|
|
Email
|
varchar(40)
|
|
|
|
|
Phone
|
varchar(40)
|
|
|
|
|
Fax
|
varchar(40)
|
|
|
|
|
status
|
int(11)
|
|
|
1
|
|
deleted
|
int(11)
|
|
|
0
|
|
addedOn
|
datetime
|
|
|
2026-02-10 09:34:18.000000
|
|
addedBy
|
int(11)
|
|
|
|
|
modifiedBy
|
int(11)
|
|
|
|
|
modifiedOn
|
timestamp
|
|
|
current_timestamp()
|
|
bank_name
|
varchar(255)
|
|
|
|
|
bank_iban
|
varchar(255)
|
|
|
|
|
contacts
|
longtext
|
|
|
|