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