client
| # |
Имя |
Тип |
Null |
Описание |
| 1 |
id |
bigint(20) |
UNSIGNED |
|
| 2 |
created_at |
timestamp |
NULL |
|
| 3 |
updated_at |
timestamp |
NULL |
|
| 4 |
name |
varchar(255) |
COLLATE |
|
| 5 |
second_name |
varchar(255) |
COLLATE |
|
| 6 |
last_name |
varchar(255) |
COLLATE |
|
| 7 |
source_id |
bigint(20) |
NOT NULL, |
|
| 8 |
city_id |
bigint(20) |
DEFAULT |
|
| 9 |
createdby |
bigint(20) |
DEFAULT |
|
| 10 |
modify_by_id |
bigint(20) |
DEFAULT |
|
| 11 |
closed_by_id |
bigint(20) |
DEFAULT |
|
| 12 |
date_closed |
timestamp |
NULL |
|
| 13 |
phone |
varchar(255) |
COLLATE |
|
| 14 |
email |
varchar(255) |
COLLATE |
|
| 15 |
company_id |
bigint(20) |
DEFAULT |
|
| 16 |
source_type_id |
bigint(20) |
NOT NULL, |
|
| 17 |
birthday |
varchar(255) |
COLLATE |
|
| 18 |
homeland |
varchar(255) |
COLLATE |
|
| 19 |
series_passport |
varchar(255) |
COLLATE |
|
| 20 |
number_passport |
varchar(255) |
COLLATE |
|
| 21 |
date_passport |
varchar(255) |
COLLATE |
|
| 22 |
code_passport |
varchar(255) |
COLLATE |
|
| 23 |
name_passport |
varchar(255) |
COLLATE |
|
| 24 |
residence_passport |
varchar(255) |
COLLATE |
|
| 25 |
img |
longtext |
COLLATE |
|
| 26 |
region_id |
bigint(20) |
UNSIGNED |
|
| 27 |
developer_id |
bigint(20) |
DEFAULT |
|
| 28 |
assigned_by_id |
bigint(20) |
DEFAULT |
|
| 29 |
assigned_by_developer_id |
bigint(20) |
DEFAULT |
|