nawi_db - Laravel Schema Designer

user

id increments
timestamps timestamps
username string
password string
email string
phone string
last_modified date
role_id ^FK integer

role

id increments
timestamps timestamps
name string

broker

id increments
timestamps timestamps
user_id ^FK integer
license_number text
image string
description text

ad_broker

id increments
timestamps timestamps
user_id ^FK integer
property_id ^FK integer
vehicle_id ^FK integer
description text
request_ad_id ^FK integer

earnings_broker

id increments
timestamps timestamps
amount string
description text
date datetime
source_type string
source_id integer

request_ad_broker

id increments
timestamps timestamps
broker_id ^FK integer
user_id ^FK integer
status string

influencer

timestamps timestamps
id increments
user_id ^FK integer
bio text
instagram text
snapchat text
image string

earnings_influencer

id increments
timestamps timestamps
influencer_id ^FK integer
amount string
date datetime
description text
source_type string
source_id integer

ad_influencer

id increments
timestamps timestamps
influncer_id ^FK integer
type string
content_type string
description text

qr_code

id increments
timestamps timestamps
content_type string
content_id integer
qr_code_date datetime

property

id increments
timestamps timestamps
owner_id ^FK integer
locution_id ^FK integer
property_type ^FK integer
property_status ^FK integer
price float
is_price_negotiable string
age string
orientation string
number_of_streets_around integer
number_of_rooms integer
number_of_bathroom integer
number_of_dining integer
number_of_windows integer
square_footage string
availibility_date date
has_built_in_kitchen string
has_air_conditioning string
has_helper_room string
furnisheh string
has_pool string
has_driving string
has_basement string
has_garage string
has_garden string
has_elevator string
has_terrace string
has_fireplace string
has_ularm string
has_gym string
has_swimming string
payment_option string
allow_buy_or_sell string
image string
description text

vehicle

id increments
timestamps timestamps
owner_id ^FK integer
vechicle_category_id ^FK integer
vechicle_model_id ^FK integer
year integer
price float
mileage float
color string
fuel_type string
transmission string
body_type text
engine_size string
horsepower string
condition string
is_price string
negotiable string
registration_status string
number_of_owners float
vechicle_features string
safety_rating string
servicehistory string
description string
parment_option string
has_been_in_accidents string
has_loan_or_lien string

rateing

timestamps timestamps
id increments
user_id ^FK integer
score string
subject_id integer
type_id integer

location

id increments
timestamps timestamps
country string
state string
city string
neighorhoad string
latitud string
longitude string
currency_id ^FK integer

admin

id increments
timestamps timestamps
user_id ^FK integer
role_id ^FK integer

chat

timestamps timestamps
id increments
sender_id ^FK integer
message_content text
recipient_id ^FK integer

post

timestamps timestamps
id increments
chat_id ^FK integer
content_type string

travel_officee

id increments
timestamps timestamps
license_number text
bio text
instagram text
facebook text

order_travel

id increments
travel_officee_id ^FK integer
timestamps timestamps
price float
image string
start_time datetime
end_time datetime
description text
city_id ^FK integer

country

id increments
timestamps timestamps
name string

city

id increments
timestamps timestamps
name string
country_id ^FK integer

favorite

id increments
timestamps timestamps
user_id ^FK integer
ad_type string
ad_id string

session

id increments
timestamps timestamps
title string
description text
start_time datetime
end_time datetime
url text
status string
admin_id ^FK integer

category

id increments
timestamps timestamps
name string
image string

notafication

id increments
timestamps timestamps
user_id ^FK integer
read_status string
message_type string
message text

property_category

id increments
timestamps timestamps
name string
description text

vehicle_category

id increments
timestamps timestamps
name string
description text

session_view

timestamps timestamps
id increments
session_id ^FK integer
user_id ^FK integer
join_time datetime
leave_time datetime

permession

id increments
timestamps timestamps
name string
content_type string
content_id integer

currency

id increments
timestamps timestamps
currency_code string
name string
exchange_rate string

property_state

id increments
timestamps timestamps
name string
description text

property_type

id increments
timestamps timestamps
property_category_id ^FK integer
name string
description text

tax

id increments
timestamps timestamps
price float
tax_rate string

vehicle_make

id increments
timestamps timestamps
name string
description text

vehicle_model

timestamps timestamps
id increments
name string
description text
vehicle_make_id ^FK integer

transaction

timestamps timestamps
user_id ^FK integer
category_id ^FK integer
currency_id ^FK integer

location_user

id increments
timestamps timestamps

travel_office_user

id increments
timestamps timestamps
user_id ^FK integer
travel_officee_id ^FK integer

favorite_user

id increments
timestamps timestamps
user_id ^FK integer
location_id ^FK integer

chat_user

id increments
timestamps timestamps
user_id ^FK integer
chat_id ^FK integer

rateing_user

id increments
timestamps timestamps
user_id ^FK integer
rateing_id ^FK integer

permession_role

id increments
timestamps timestamps
role_id ^FK integer
permession_id ^FK integer

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01