house_item

# Имя Тип Null Описание
1 id bigint(20) UNSIGNED  
2 house_id int(11) NOT NULL,  
3 created_at timestamp NULL  
4 updated_at timestamp NULL  
5 studio int(11) DEFAULT  
6 section_number int(11) DEFAULT  
7 floor_number int(11) DEFAULT  
8 flat_number varchar(255) COLLATE  
9 flat_rooms_count int(11) DEFAULT  
10 old_price bigint(20) DEFAULT  
11 price bigint(20) DEFAULT  
12 status varchar(255) COLLATE  
13 total_area decimal(8,2) NOT NULL,  
14 living_area decimal(8,2) DEFAULT  
15 area_without_balconies decimal(8,2) DEFAULT  
16 living_room decimal(8,2) DEFAULT  
17 room longtext COLLATE  
18 kitchen_area double(8,2) DEFAULT  
19 bathroom double(8,2) DEFAULT  
20 washroom varchar(255) COLLATE  
21 loggia_area longtext CHARACTER  
22 hallway longtext CHARACTER  
23 wardrobe_area double(8,2) DEFAULT  
24 img varchar(255) COLLATE  
25 createdby int(11) DEFAULT  
26 developer_id int(11) NOT NULL,  
27 price_area bigint(20) DEFAULT  
28 lead_id bigint(20) DEFAULT  
29 deal_id bigint(20) DEFAULT  
30 render varchar(255) COLLATE  
31 rotation varchar(255) COLLATE  
32 video varchar(255) COLLATE  
33 category_id tinyint(1) NOT NULL,  
34 count_additional_rooms tinyint(3) UNSIGNED  
35 floor_position tinyint(3) UNSIGNED  
36 count_tier tinyint(3) UNSIGNED  
37 type_washroom varchar(255) COLLATE  
38 count_loggia tinyint(3) UNSIGNED  
39 row double DEFAULT  
40 row_name longtext COLLATE  
41 svg longtext COLLATE  
42 map_area longtext COLLATE  
43 deleted_at timestamp NULL  
44 img_preview varchar(255) COLLATE