LeeTaxi - Laravel Schema Designer

application_categories

id increments
title json
key string
timestamps timestamps
softDeletes softDeletes

sliders

id increments
timestamps timestamps
title json
type string
active string
reference_type string
reference_id string

orders

id increments
timestamps timestamps
user_id ^FK bigInteger
store_id ^FK bigInteger
subtotal_price integer
total_price integer
type string (225)
status string
payment_method string
source_coordinates char
distination_coordinates string
user_address json
note string
points string
coupon string
zakat string
tax string

order_infos

id increments
car_class json
products json
min_price double
status string
max_price double
full_name string
order_id ^FK integer
quantity string
total_distances integer

car_classes

id increments
timestamps timestamps
title json

car_models

id increments
title json
timestamps timestamps
brand_id ^FK bigInteger

car_brands

id increments
title json
timestamps timestamps

products

id increments
title json
descriptions json
price integer
timestamps timestamps
product_category_id bigInteger
store_id string
currency string
discount_percentage char

product_rates

id increments
product_id ^FK integer
timestamps timestamps
stars float
comment string
user_id ^FK integer

captains

id increments
store_id ^FK integer
timestamps timestamps
name string
phone string
email string
active string
type string
password string
online string

captain_infos

id increments
identification_number string
timestamps timestamps
license_number string
driving_license_number string
car_model_id ^FK integer
car_class_id ^FK integer
name_bank string
account_number string
gender string
nationality string
captain_id ^FK integer

stores

id increments
timestamps timestamps
name string
city_id ^FK bigInteger
address string
coordinates string
email string
phone string
type string
password string
commercial_register string

captain_rates

id increments
captain_id ^FK integer
user_id integer
stars float
comment string

users

id increments
timestamps timestamps
name string
email string
phone string
active boolean
phone_verified_at string
email_verified_at string
password string

user_infos

id increments
timestamps timestamps
coordinates string
language_code string
currency_code string
gender string
user_id ^FK integer

store_user_subscriptions

id increments
timestamps timestamps
user_id ^FK integer
store_package_id ^FK integer

employees

id increments
timestamps timestamps
name string
email string
phone string
password string
active boolean
store_id ^FK integer

store_advertisements

id increments
timestamps timestamps
store_id ^FK integer
details json
points double
start_at timestamp
period string

chats

id increments
timestamps timestamps
last_message_id string
user_id ^FK integer
store_id integer
captain_id ^FK integer

chat_messages

id increments
timestamps timestamps
sender string
message_text text
readed_at string
chat_id ^FK integer
created_by_id string
created_by_type string
order_id string

contact_us

id increments
timestamps timestamps
name string
email string
phone string
message text
type string
reply string
subject string

currencies

id increments
timestamps timestamps
title json
symbol string
exchange_rate float
auto_update_rate boolean
active boolean
code string
default string
slug string

roles

id increments
timestamps timestamps
name string
guard_name string
reference_type string
reference_id string

role_has_permissions

id increments
timestamps timestamps

user_addresses

id increments
timestamps timestamps
user_id ^FK integer
address string
coordinates string
radius string
notes string

order_driver_offers

id increments
timestamps timestamps
order_id ^FK integer
captain_id ^FK integer
user_id ^FK integer
status string

order_schedul_repeats

id increments
timestamps timestamps
order_id ^FK integer
start_at datetime
is_repeat boolean
duration string
duration_type string

payment_methods

id increments
timestamps timestamps
title json
description json
data string
slug string
active string

product_categories

id increments
timestamps timestamps
title json

application_category_services

id increments
timestamps timestamps
title json
application_category_id ^FK bigInteger

store_packages

id increments
timestamps timestamps
title json
points string
store_id string

wallets

id increments
timestamps timestamps
current string
steps string
balance string
transaction_type string
wallettable_type string
wallettable_id string
data string
transaction_reasons string