house
| # | Имя | Тип | Null | Описание |
|---|---|---|---|---|
| 1 | id | bigint(20) | UNSIGNED | |
| 2 | created_at | timestamp | NULL | |
| 3 | updated_at | timestamp | NULL | |
| 4 | active | int(11) | NOT NULL, | |
| 5 | street | varchar(255) | COLLATE | |
| 6 | coordinates | varchar(255) | COLLATE | |
| 7 | district | int(11) | DEFAULT | |
| 8 | complex_id | int(11) | NOT NULL, | |
| 9 | house_number | varchar(255) | COLLATE | |
| 10 | stage | varchar(255) | COLLATE | |
| 11 | floors_count | int(11) | NOT NULL, | |
| 12 | entrances | int(11) | NOT NULL, | |
| 13 | ceiling_height | decimal(8,2) | NOT NULL, | |
| 14 | developer_id | int(11) | NOT NULL, | |
| 15 | img | longtext | COLLATE | |
| 16 | createdby | int(11) | NOT NULL, | |
| 17 | stock_id | longtext | COLLATE | |
| 18 | program_id | longtext | COLLATE | |
| 19 | colItemPl | int(11) | DEFAULT | |
| 20 | building_class | varchar(255) | COLLATE | |
| 21 | type_finish | varchar(255) | COLLATE | |
| 22 | year_const | varchar(255) | COLLATE | |
| 23 | date | varchar(255) | COLLATE | |
| 24 | type_house | varchar(255) | COLLATE | |
| 25 | description | text | COLLATE | |
| 26 | quarter | varchar(255) | COLLATE | |
| 27 | link_nash_dom | varchar(255) | COLLATE | |
| 28 | corps | bigint(20) | DEFAULT | |
| 29 | id_widget_catalog | bigint(20) | DEFAULT | |
| 30 | phone | varchar(255) | COLLATE | |
| 31 | view_price | tinyint(1) | NOT NULL | |
| 32 | quarter_number | varchar(255) | COLLATE | |
| 33 | area | varchar(255) | COLLATE | |
| 34 | address_house_type | varchar(255) | COLLATE | |
| 35 | style | longtext | COLLATE | |
| 36 | img_preview | longtext | COLLATE | |
| 37 | deleted_at | timestamp | NULL | |
| 38 | type | varchar(255) | COLLATE | |
| 39 | sale_type | varchar(255) | COLLATE | |
| 40 | passenger_lifts_count | bigint(20) | DEFAULT | |
| 41 | cargo_lifts_count | bigint(20) | DEFAULT | |
| 42 | parking | tinyint(1) | NOT NULL | |
| 43 | parking_type | varchar(255) | COLLATE | |
| 44 | legal_entity | varchar(255) | COLLATE | |
| 45 | cadastral_number | varchar(255) | COLLATE |