mpdb - Laravel Schema Designer

sitemaps

id increments
module_id ^FK integer
website_id ^FK integer
timestamps timestamps
softDeletes softDeletes
category enum

sitemap_details

id increments
sitemap_id ^FK integer
language_id ^FK integer
name string
slug string

languages

id increments
code string
name string
alphabet string
native string
regional string
flag string
direction enum
active enum
default enum
sort integer
timestamps timestamps
softDeletes softDeletes

websites

id increments
name string
slug string
type enum
sort string
website_id integer
default enum
hide_default_language enum
ssl enum
timestamps timestamps
softDeletes softDeletes

pages

id increments
sitemap_id ^FK integer
page_id ^FK integer
timestamps timestamps
softDeletes softDeletes

page_details

id increments
page_id ^FK integer
language_id ^FK integer
name string
detail text
slug string

page_detail_extras

page_detail_id ^FK integer
key string
value text

extras

model_type string
model_id integer
key string
value text

categories

id increments
sitemap_id ^FK integer
category_id ^FK integer
timestamps timestamps
softDeletes softDeletes
_lft integer
_rgt integer
_dpt integer

category_details

id increments
category_id ^FK integer
language_id ^FK integer
name string
slug string
detail text

criterias

id increments
sitemap_id ^FK integer
criteria_id ^FK integer
timestamps timestamps
softDeletes softDeletes

criteria_details

id increments
criteria_id ^FK integer
name string
slug string
detail text

properties

id increments
sitemap_id ^FK integer
property_id ^FK integer
timestamps timestamps
softDeletes softDeletes

property_details

id increments
property_id ^FK integer
name string
slug string
detail text

category_page

category_id ^FK integer
page_id ^FK integer

criteria_page

criteria_id ^FK integer
page_id ^FK integer

page_detail_property_detail

page_detail_id ^FK integer
property_detail_id ^FK integer
value text

modules

id increments
name string
type string
module_id ^FK integer
timestamps timestamps
softDeletes softDeletes

language_website

language_id ^FK integer
website_id ^FK integer
default enum

urls

id increments
url string
model_type string
model_id integer
type enum
timestamps timestamps
softDeletes softDeletes

category_criteria

category_id ^FK integer
criteria_id ^FK integer

category_property

category_id ^FK integer
property_id ^FK integer

admins

id increments
group_id ^FK integer
name string (50)
surname string (50)
email string (100)
phone string (50)
password string (100)
remember_token string
timestamps timestamps
softDeletes softDeletes

groups

id increments
name string

roles

id increments
name string
sort integer
timestamps timestamps
group_id ^FK integer
role_id ^FK integer

routes

id increments
name string
role_id ^FK integer
slug string
timestamps timestamps

role_route

group_id ^FK integer
role_id ^FK integer

settings

id increments
name string

medias

id increments
model_id integer
model_type string
image_id ^FK integer
name string
timestamps timestamps
softDeletes softDeletes

images

id increments
gallery_id ^FK integer
file_name string
delete_name string
size integer
timestamps timestamps
softDeletes softDeletes

galleries

id increments
name string (100)
folder_name string
delete_name string
disk string
path string
timestamps timestamps
softDeletes softDeletes