lead
| # | Имя | Тип | Null | Описание |
|---|---|---|---|---|
| 1 | id | bigint(20) | UNSIGNED | |
| 2 | created_at | timestamp | NULL | |
| 3 | updated_at | timestamp | NULL | |
| 4 | title | varchar(255) | COLLATE | |
| 5 | name | varchar(255) | COLLATE | |
| 6 | second_name | varchar(255) | COLLATE | |
| 7 | last_name | varchar(255) | COLLATE | |
| 8 | source_id | bigint(20) | NOT NULL, | |
| 9 | source_description | varchar(255) | COLLATE | |
| 10 | status_id | bigint(20) | NOT NULL, | |
| 11 | status_description | varchar(255) | COLLATE | |
| 12 | city_id | bigint(20) | DEFAULT | |
| 13 | opportunity | bigint(20) | DEFAULT | |
| 14 | createdby | bigint(20) | DEFAULT | |
| 15 | modify_by_id | bigint(20) | DEFAULT | |
| 16 | closed_by_id | bigint(20) | DEFAULT | |
| 17 | assigned_by_id | bigint(20) | DEFAULT | |
| 18 | date_closed | timestamp | NULL | |
| 19 | phone | varchar(255) | COLLATE | |
| 20 | varchar(255) | COLLATE | ||
| 21 | client_id | bigint(20) | DEFAULT | |
| 22 | item_id | bigint(20) | DEFAULT | |
| 23 | deal_id | bigint(20) | DEFAULT | |
| 24 | body | text | COLLATE | |
| 25 | history_changes | longtext | COLLATE | |
| 26 | pre_complex_id | varchar(255) | COLLATE | |
| 27 | pre_flat_rooms_count | varchar(255) | COLLATE | |
| 28 | pre_price | bigint(20) | DEFAULT | |
| 29 | house_id | bigint(20) | DEFAULT | |
| 30 | developer_id | bigint(20) | DEFAULT | |
| 31 | source_type_id | bigint(20) | DEFAULT | |
| 32 | assigned_by_developer_id | bigint(20) | DEFAULT | |
| 33 | status_description_developer | text | COLLATE | |
| 34 | call_id | varchar(255) | COLLATE | |
| 35 | agency_id | bigint(20) | DEFAULT | |
| 36 | agency_user_id | bigint(20) | DEFAULT | |
| 37 | complex_id | bigint(20) | DEFAULT | |
| 38 | region_id | bigint(20) | DEFAULT | |
| 39 | type | bigint(20) | DEFAULT | |
| 40 | developer_send | bigint(20) | DEFAULT | |
| 41 | developer_accepted | tinyint(4) | NOT NULL | |
| 42 | close | tinyint(4) | NOT NULL |