|
id
|
int(10) unsigned
|
|
|
|
|
entities_id
|
int(10) unsigned
|
|
|
0
|
|
is_recursive
|
tinyint(4)
|
|
|
0
|
|
name
|
varchar(255)
|
|
|
|
|
firstname
|
varchar(255)
|
|
|
|
|
registration_number
|
varchar(255)
|
|
|
|
|
phone
|
varchar(255)
|
|
|
|
|
phone2
|
varchar(255)
|
|
|
|
|
mobile
|
varchar(255)
|
|
|
|
|
fax
|
varchar(255)
|
|
|
|
|
email
|
varchar(255)
|
|
|
|
|
contacttypes_id
|
int(10) unsigned
|
|
|
0
|
|
comment
|
text
|
|
|
|
|
is_deleted
|
tinyint(4)
|
|
|
0
|
|
usertitles_id
|
int(10) unsigned
|
|
|
0
|
|
address
|
text
|
|
|
|
|
postcode
|
varchar(255)
|
|
|
|
|
town
|
varchar(255)
|
|
|
|
|
state
|
varchar(255)
|
|
|
|
|
country
|
varchar(255)
|
|
|
|
|
date_mod
|
timestamp
|
|
|
|
|
date_creation
|
timestamp
|
|
|
|
|
pictures
|
text
|
|
|
|