garas - Laravel Schema Designer

categories

id increments
name_en string
name_ar string
keys_ar json
timestamps timestamps
key_en json

apartments

id increments
type tinyInteger
neighborhood string
map_location string
rent_time tinyInteger
floor integer
building_age string
living_rooms integer
bedrooms integer
bathrooms integer
street_width string
furnished tinyInteger
kitchen_availability tinyInteger
extra_unit_availability string
water_availability tinyInteger
car_entrance tinyInteger
elevator_availability tinyInteger
size string
length string
additional_fields string
timestamps timestamps

villas

id increments
number_of_rooms tinyInteger
car_entrance boolean
driver_room boolean
servant_room boolean
elevator_availability boolean
timestamps timestamps

lands

id increments
size integer
street_width integer
length integer
timestamps timestamps

buildings

id increments
number_of_apartments integer
number_of_shops integer
number_of_elevator integer
timestamps timestamps

stores

id increments
size integer
street_width integer
length integer
building_age string
timestamps timestamps

rests

id increments
playground_availability boolean
mashab_availability boolean
pool_availability boolean
timestamps timestamps

chalets

id increments
playground_availability boolean
mashab_availability boolean
pool_availability boolean
timestamps timestamps

farms

id increments
size integer
timestamps timestamps

offices

id increments
size integer
street_width integer
length integer
building_age string
timestamps timestamps

warehouse

id increments
size integer
street_width integer
length integer
building_age string
timestamps timestamps

exhibitions

id increments
size integer
street_width integer
length integer
building_age string
timestamps timestamps

factories

id increments
size integer
street_width integer
length integer
building_age string
timestamps timestamps

compounds

id increments
compound_type string
size integer
property_side string
street_width integer
type_number string
building_age string
timestamps timestamps

malls

id increments
mall_type string
size integer
street_width integer
property_side string
type_number string
building_age string
cellar_availability boolean
timestamps timestamps

towers

id increments
tower_type string
size integer
street_width integer
property_side string
building_age string
type_number string
floors_number integer
cellar_availability boolean
timestamps timestamps

event_halls

id increments
rent_type tinyInteger
size integer
street_width integer
property_side string
building_age string
attendees_number integer
kitchen_availability boolean
women_section boolean
timestamps timestamps

ads

id increments
user_id ^FK integer
cat_id ^FK integer
ad_type tinyInteger
license_number string
width integer
height integer
price bigInteger
discription text
is_rent boolean
map_latitude string
map_longitude string
region string
city string
city_side string
district string
video_priority boolean
stared boolean
active boolean
timestamps timestamps

images

id increments
imagable_id ^FK integer
imagable_type ^FK integer
path string
timestamps timestamps

videos

id increments
videoable_id ^FK integer
videoable_type ^FK integer
path string
timestamps timestamps

ads_rules

id increments
conditions text
buy_conditions text
rent_conditions text
honisty_conditions text
timestamps timestamps

reviews

id increments
review integer
user_id ^FK integer
timestamps timestamps

users

id increments
f_name string
l_name string
title string
discription text
phone bigInteger
avatar string
active boolean
phone_verified_at date
marketer_code string
role tinyInteger
password string
remember_token string
timestamps timestamps
estate_license string

reports

id increments
user_id ^FK integer
ads_id ^FK integer
discription text
timestamps timestamps

terms

id increments
name_ar string
name_en string
discription_ar longText
discription_en longText
timestamps timestamps

followers

id increments
user_id ^FK integer
follower_id ^FK integer
timestamps timestamps

payments

id increments
timestamps timestamps
details string
name string
reason string
reference_number bigInteger
image_path string

website

id increments
timestamps timestamps

favorites

id increments
timestamps timestamps
user_id ^FK integer
ads_id ^FK integer