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