linkicare - Laravel Schema Designer

users

id increments
first_name string (255)
last_name string (255)
email string (255)
password text
image string (255)
whatsapp_phone string (255)
mobile_phone string (255)
home_phone string (255)
location string (255)
latitude decimal (12,10)
longitude decimal (12,10)
city_id ^FK bigInteger
social_id string
social_type tinyInteger
status tinyInteger
pin_code string
is_verified tinyInteger
timestamps timestamps

showrooms

id increments
user_id ^FK bigInteger
business_name string (255)
image string (255)
description text
open_hour time
close_hour time
location string (255)
latitude decimal (12,10)
longitude decimal (12,10)
city_id ^FK bigInteger
open_day date
timestamps timestamps
close_day date

brands

id increments
name string (255)
image string (255)
type tinyInteger
timestamps timestamps

models

id increments
brand_id ^FK bigInteger
name string (255)
timestamps timestamps

cars

id increments
admin_id bigInteger
city_id bigInteger
showroom_id ^FK bigInteger
user_id ^FK bigInteger
title string (255)
model_id ^FK bigInteger
description text
latitude decimal (12,10)
type tinyInteger
price float (10,2)
longitude decimal (12,10)
location string (255)
whatsapp_phone string
timestamps timestamps
status tinyInteger
stock integer

features

id increments
color string (255)
timestamps timestamps

ads_features

id increments
feature_id bigInteger
ad_id bigInteger
timestamps timestamps

cars_images

id increments
file string (255)
ad_id bigInteger
is_main boolean
type tinyInteger
timestamps timestamps

cities

id increments
timestamps timestamps
name_ar string (255)
name_ur string (255)
name_en string (255)
country_id ^FK bigInteger

countries

id increments
name_ur string (255)
name_en string (255)
name_ar string (255)
timestamps timestamps

licenses

id increments
type tinyInteger
file string
showroom_id ^FK bigInteger
timestamps timestamps

currencies

id increments
name_ar string (255)
name_en string (255)
name_ur string (255)
timestamps timestamps

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