|
id
|
int(11)
|
|
|
|
|
user_id
|
int(11)
|
|
|
|
|
owner_name
|
varchar(255)
|
|
|
|
|
phone
|
varchar(50)
|
|
|
|
|
email
|
varchar(255)
|
|
|
|
|
intent
|
varchar(50)
|
|
|
|
|
category
|
varchar(255)
|
|
|
|
|
location
|
varchar(255)
|
|
|
|
|
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
|
|
|
|
|
images_json
|
text
|
|
|
|
|
status
|
varchar(100)
|
|
|
جديد
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
deal_state
|
varchar(32)
|
|
|
|
|
badge_visible
|
tinyint(1)
|
|
|
1
|
|
is_deleted
|
tinyint(1)
|
|
|
0
|
|
extra_json
|
longtext
|
|
|
|
|
title
|
varchar(255)
|
|
|
|
|
city
|
varchar(120)
|
|
|
|
|
ptype
|
varchar(120)
|
|
|
|
|
main_image
|
varchar(1024)
|
|
|
|
|
is_featured
|
tinyint(1)
|
|
|
0
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|