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