Pilgrimage - Laravel Schema Designer

users

id increments
first_name string (20)
last_name string (20)
user_type enum
email string (20)
phone string (20)
password string (50)
is_ban boolean
ban_reason text
is_active boolean
gender enum
timestamps timestamps
softDeletes softDeletes

roles

id increments
status string
timestamps timestamps
softDeletes softDeletes

role_translations

id increments
locale string (2)
name string (20)
slug string (20)
role_id ^FK integer

permissions

id increments
timestamps timestamps
softDeletes softDeletes

permission_translations

id increments
title string (20)
locale string (2)
permission_id ^FK integer

services

id increments
status enum
timestamps timestamps
softDeletes softDeletes

service_translations

id increments
service_id ^FK integer
locale string (2)
name string (20)
description longText

sliders

id increments
status enum
link text
link_type enum
display_order integer
timestamps timestamps
softDeletes softDeletes

news

id increments
status enum
category_id ^FK integer
publish_date timestamps
timestamps timestamps
softDeletes softDeletes

new_translations

id increments
news_id ^FK integer
locale string (2)
title string (20)
description longText

partners

id increments
link string (50)
status enum
timestamps timestamps
softDeletes softDeletes

partner_translations

id increments
partner_id ^FK integer
locale string (2)
name string (20)

previousWork

id increments
status enum
timestamps timestamps
softDeletes softDeletes

previousWork_translations

id increments
previousWork_id ^FK integer
locale string (2)
title string (20)
description longText

images

id increments
imageable_id integer
imageable_type text
timestamps timestamps
softDeletes softDeletes

information_center

id increments
timestamps timestamps
softDeletes softDeletes

informationCenter_translations

id increments
informationCenter_id ^FK integer
locale string (2)
title string (20)
description longText

attachments

id increments
informationCenter_id ^FK integer
path string (50)
type string (20)
timestamps timestamps
softDeletes softDeletes

testimonials

id increments
name string
position string
status enum
image string
timestamps timestamps
softDeletes softDeletes

testimonial_translations

id increments
testimonial_id ^FK integer
locale string (2)
text longText

countries

id increments
status enum
timestamps timestamps
softDeletes softDeletes

country_translations

id increments
country_id ^FK integer
locale string (2)
name string (20)
info string

branches

id increments
lat string
lng string
location longText
timestamps timestamps
softDeletes softDeletes

branch_translations

id increments
branch_id ^FK integer
locale string (2)
name string (20)

daysOfWeek

id increments
timestamps timestamps
softDeletes softDeletes

daysOfWeek_translations

id increments
dayOfWeek_id ^FK integer
locale string (2)
name string (20)

work_times

id increments
branch_id ^FK integer
dayOfWeek_id ^FK integer
start_time time
end_time time
timestamps timestamps
softDeletes softDeletes

contact_us

id increments
sender_name string (20)
sender_email string
sender_phone string
content longText
status enum
timestamps timestamps
softDeletes softDeletes

contactUs_replies

id increments
contact_us_id ^FK integer
sender enum
content longText
read_at datetime
timestamps timestamps
softDeletes softDeletes

notifications

id increments
timestamps timestamps
softDeletes softDeletes

social_media_links

id increments
name string (20)
link string (50)
timestamps timestamps
softDeletes softDeletes

permission_role

id increments
permission_id ^FK integer
role_id ^FK integer

about

id increments
timestamps timestamps
softDeletes softDeletes

about_translations

id increments
text longText
about_id ^FK integer
locale string (2)

settings

id increments
key string (50)
value longText
timestamps timestamps
softDeletes softDeletes

slider_translations

id increments
text longText
slider_id ^FK integer
locale string (2)

news_categories

id increments
status string
timestamps timestamps
softDeletes softDeletes

newsCategory_translations

id increments
newCategory_id ^FK integer
locale string (2)
name string (20)
description string (100)

phones

id increments
branch_id ^FK integer
phone string (20)
timestamps timestamps
softDeletes softDeletes

emails

id increments
branch_id ^FK integer
email string (20)
timestamps timestamps
softDeletes softDeletes

directors

id increments
job_title_id ^FK integer
timestamps timestamps
softDeletes softDeletes

director_translations

id increments
dirctor_id ^FK integer
name string (100)
locale string (2)

job_titles

id increments
timestamps timestamps
softDeletes softDeletes

job_title_translations

id increments
job_title_id ^FK integer
name string (100)
locale string (2)

speeches

id increments
director_id ^FK integer
timestamps timestamps
softDeletes softDeletes

SpeechTranslation

id increments
speechId ^FK integer
text text
locale string (2)