| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| owner_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| intent |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| location |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| map_lat |
decimal(10,7)
|
|
|
|
| map_lng |
decimal(10,7)
|
|
|
|
| price |
decimal(15,2)
|
|
|
|
| bedrooms |
int(11)
|
|
|
|
| bathrooms |
int(11)
|
|
|
|
| area |
decimal(10,2)
|
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| images_json |
text
|
utf8mb4_general_ci
|
|
|
| status |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| deal_state |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| badge_visible |
tinyint(1)
|
|
|
|
| is_deleted |
tinyint(1)
|
|
|
|
| extra_json |
longtext
|
utf8mb4_general_ci
|
|
|
| title |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| city |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| ptype |
varchar(120)
|
utf8mb4_general_ci
|
|
|
| main_image |
varchar(1024)
|
utf8mb4_general_ci
|
|
|
| is_featured |
tinyint(1)
|
|
|
|
| updated_at |
timestamp
|
|
|
|
