Sakan - Laravel Schema Designer

types

id increments
timestamps timestamps

type_translations

id increments
timestamps timestamps
type_id ^FK integer
locale string
title string

periods

id increments
timestamps timestamps
days integer

period_transaltions

id increments
timestamps timestamps
period_id ^FK integer
locale string
title string

taskeen_types

id increments
timestamps timestamps

taskeen_type_transaltions

id increments
timestamps timestamps
taskeen_type_translations ^FK integer
locale string
title string

facilities

id increments
timestamps timestamps
icon string

facility_tranlsations

id increments
timestamps timestamps
facility_id ^FK integer
locale string
title string

marks

id increments
timestamps timestamps

mark_translations

id increments
timestamps timestamps
mark_id ^FK integer
locale string
title string

countries

id increments
timestamps timestamps

country_tanslations

id increments
timestamps timestamps
country_id ^FK integer
locale string
title string

cities

id increments
timestamps timestamps
country_id ^FK integer

city_tranlsations

id increments
timestamps timestamps
city_id ^FK integer
locale string
title string

ticket_types

id increments
timestamps timestamps

ticket_type_translations

id increments
timestamps timestamps
ticket_type_id ^FK integer
locale string
title string

payment_methods

id increments
timestamps timestamps
number string
link string
image string

payment_method_translations

id increments
timestamps timestamps
account_id ^FK integer

instructions

id increments
timestamps timestamps
type_id ^FK integer

instruction_translations

id increments
timestamps timestamps
instruction_id ^FK integer
locale string
title string

questions

id increments
timestamps timestamps

question_translations

id increments
timestamps timestamps
question_id ^FK integer
locale string
answer string
question string

blogs

id increments
timestamps timestamps
watches integer

blog_translations

id increments
timestamps timestamps
blog_id ^FK integer
locale string
title string
content longText

blog_images

id increments
timestamps timestamps
blog_id ^FK integer
image string
is_master boolean

money_points

id increments
timestamps timestamps
from_money string
to_points string
from_points string
to_many string

units

id increments
timestamps timestamps
type_id ^FK integer
city_id ^FK integer
country_id ^FK integer
publisher_id integer
availability boolean
address string
order integer
status string
price integer
code string

unit_periods

id increments
timestamps timestamps
unit_id ^FK integer
period_id ^FK integer

unit_taskeen_types

id increments
timestamps timestamps
unit_id ^FK integer
taskeen_type_id ^FK integer

unit_images

id increments
timestamps timestamps
unit_id ^FK integer
image string

unit_facilites

id increments
timestamps timestamps
facility_id ^FK integer
unit_id ^FK integer

unit_marks

id increments
timestamps timestamps
mark_id ^FK integer
unit_id ^FK integer
is_master boolean
title string
distance string
order string

clients

id increments
timestamps timestamps
name string
password string
email string
country_id ^FK integer
api_token string
device_token string
country_code string
total_money string
currrent_money string
total_points string
current_points string
client_type integer
status boolean

unit_reservations

id increments
timestamps timestamps
client_id ^FK integer
unit_id ^FK integer
period_id ^FK integer
price integer

unit_payments

id increments
timestamps timestamps
unit_id ^FK integer
price integer
payment_method_id ^FK integer
reciet integer
status boolean

wallet_history

id increments
timestamps timestamps
type string
amount string
amount_type string

admins

id increments
timestamps timestamps
name string
phone string
password string
image string
type string
status string
fcm_token string