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 |
|