shafrah - Laravel Schema Designer

users

id bigInteger
name string (255)
email string (255)
mobile char (10)
type enum
slogan_ar string (255)
slogan_en string (255)
email_verified_at timestamp
password string (255)
remember_token string (100)
is_active tinyInteger
is_verified tinyInteger
otp char (4)
otp_expires_at datetime
photo string (255)
birth_date date
location string (255)
lat string (255)
lng string (255)
device_token string (255)
timestamps timestamps

stores

id increments
user_id bigInteger
gender enum
rate integer
pay_commission tinyInteger
money_password string (400)
timestamps timestamps

reservations

id increments
client_id integer
payment_method enum
is_paid tinyInteger
is_donation tinyInteger
status enum
tax double
commision double
wallet_amount double
sub_total double
total double
coupon_discount double
coupon_id bigInteger
other_amount double
payment_data text
store_id bigInteger
reservation_type enum
timestamps timestamps

coupons

id increments
code char (50)
number_of_use integer
expiration_date date
is_active tinyInteger
coupon_type enum
amount integer
all_stores tinyInteger
timestamps timestamps

categories

id increments
name_ar string (255)
name_en string (255)
is_active tinyInteger
description_ar text
timestamps timestamps

employees

id increments
store_id bigInteger
name char (255)
mobile char (10)
email string (255)
photo string (255)
is_active tinyInteger
rate integer
timestamps timestamps

employee_services

id increments
employee_id bigInteger
store_service_id bigInteger
timestamps timestamps

employee_sessions

id increments
employee_id bigInteger
session_date date
session_from time
reservation_id bigInteger
session_to time
timestamps timestamps

store_services

id increments
store_id bigInteger
service_id bigInteger
is_active tinyInteger
price double
session_time integer
category_id bigInteger
sub_category_id bigInteger
timestamps timestamps

store_timings

id increments
store_id bigInteger
day enum
start_from time
end_to time
type enum
start_from_2 time
end_to_2 time
timestamps timestamps

reviews

id increments
client_id bigInteger
comment text
rate integer
reservation_id bigInteger
store_id bigInteger
timestamps timestamps

payments

id increments
client_id bigInteger
TrackId integer
ResponseCode integer
PaymentId string
TranId string
Result string
cardBrand string
amount double (8,2)
timestamps timestamps

wallets

id increments
user_id bigInteger
amount double (8,2)
timestamps timestamps

notifications

id increments
title string
body text
item_id integer
is_read tinyInteger
send_from bigInteger
send_to bigInteger
notification_type enum
scheduled_date datetime
timestamps timestamps

discard_reservations

id increments
amount double (8,2)
reservation_id bigInteger
timestamps timestamps

reservation_items

id increments
reservation_id bigInteger
store_service_id bigInteger
employee_id bigInteger
price double (8,2)
reservation_date date
reservation_time time
reservation_end time
session_time integer
notified tinyInteger
timestamps timestamps

bulk_notifications

id bigInteger
title string (255)
body text
send_from bigInteger
send_to longText
sent_all tinyInteger
timestamps timestamps

coupon_stores

id increments
store_id bigInteger
coupon_id bigInteger
timestamps timestamps

employee_times

id increments
employee_id bigInteger
day enum
start_from time
end_to time
type enum
start_from_2 time
end_to_2 time
timestamps timestamps

failed_jobs

id increments
uuid string (255)
connection text
queue text
payload longText
timestamps timestamps
exception longText

galleries

id increments
store_id bigInteger
image_path string (255)
description_ar text
description_en text
timestamps timestamps

user_roles

id increments
timestamps timestamps
role_id bigInteger
user_id bigInteger

fcm_tokens

id increments
user_id bigInteger
value text
device_type enum
lang char
timestamps timestamps

pages

id increments
slug string (255)
name_ar string
name_en string (255)
body_ar text
body_en text
timestamps timestamps

password_resets

id increments
timestamps timestamps
email string (255)
token string (255)

transactions

id increments
timestamps timestamps
reservation_id bigInteger
addressLine string
city string
countryCode char
email string
name string
phone string (255)
zip char (5)
responseCode string (255)
responseMessage string (255)
responseStatus char
transactionTime datetime
transactionReference string (255)
cartCurrency char (5)
payResponseReturn string (255)
isPending char (5)
isOnHold char
cardScheme char (10)
cardType char (10)
paymentDescription text
isSuccess char (5)

role_permissions

timestamps timestamps
id increments
role_id bigInteger
permission string (255)

time_cashes

id increments
timestamps timestamps
client_id integer
store_id string
employee_id integer
service_id integer
date date
session_from time
session_to time
length_service integer
end_at timestamp

personal_access_tokens

id increments
tokenable_type string (255)
tokenable_id bigInteger
name string (255)
token string (255)
abilities text
last_used_at timestamp
expires_at timestamp
timestamps timestamps

favourites

id increments
timestamps timestamps
user_id bigInteger
store_id bigInteger

password_reset_tokens

id increments
timestamps timestamps
email string (255)
token string (255)

permissions

id increments
timestamps timestamps
section string (255)
name string (255)

reservation_cashes

id increments
timestamps timestamps
client_id integer
store_service_id integer
employee_id integer
price double (8,2)
reservation_date date
reservation_time time
reservation_end time
session_time integer
group_id integer
reservation_type enum

reservation_donations

id increments
timestamps timestamps
reservation_id bigInteger
name string (255)
mobile string

review_employees

id increments
timestamps timestamps
employee_id bigInteger
review_id bigInteger
rate integer

roles

id increments
timestamps timestamps
name_ar string (255)
name_en string (255)
is_active tinyInteger

services

id increments
timestamps timestamps
name_ar string (255)
name_en string (255)
is_active tinyInteger
category_id bigInteger
parent_id bigInteger

settings

id increments
timestamps timestamps
key string (255)
value text
group string
type string
sort integer

websockets_statistics_entries

id increments
timestamps timestamps
app_id string (255)
peak_connection_count integer
websocket_message_count integer
api_message_count integer