limcms - Laravel Schema Designer

lim_settings

id increments
timestamps timestamps
table_type string (64)
table_id integer
system_name string

lim_setting_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_setting_id ^FK integer
label string (32)
value string (128)
description string (128)

lim_languages

id increments
timestamps timestamps
status enum
code string (3)

lim_content_types

id increments
timestamps timestamps
use_type_page enum
type_template string (128)
use_breadcrumb_prefix enum
content_template string (128)
pagination integer
use_category enum
use_branch enum
use_content enum
cache_time integer

lim_content_type_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_content_type_id ^FK integer
name string (32)
plural_name string (32)
uri string (32)

lim_contents

id increments
timestamps timestamps
lim_content_type_id ^FK integer
lim_category_id ^FK integer
cache_time integer
lim_branch_id ^FK integer

lim_content_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_content_id ^FK integer
uri string (128)
name string (128)
summary text
content string

lim_categories

id increments
timestamps timestamps
lim_content_type_id ^FK integer
lim_category_id ^FK integer
rank integer
lft integer
rgt integer
depth integer

lim_category_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_category_id ^FK integer
name string (128)
summary text
content text

lim_fields

id increments
timestamps timestamps
table_id integer
table_type string (128)
type enum
rank integer
system_name string
icon string (64)

lim_field_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_field_id ^FK integer
name string (32)
description string (128)

lim_field_items

id increments
timestamps timestamps
lim_field_id ^FK integer
status enum
rank integer
icon string (64)

lim_field_item_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_field_item_id ^FK integer
name string (32)
description string (128)

lim_widgets

id increments
timestamps timestamps
type string (32)
settings text

lim_widget_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_widget_id ^FK integer
title string (32)

lim_field_values

id increments
timestamps timestamps
lim_field_id ^FK integer

lim_field_value_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_field_value_id ^FK integer
value text

lim_widget_relations

id increments
timestamps timestamps
lim_widget_id ^FK integer
table_id integer
table_type string (128)
rank integer
position string (32)

lim_seo_templates

id increments
timestamps timestamps
template string

lim_seo_template_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_seo_template_id ^FK integer
name string (32)

lim_seo_fields

id increments
timestamps timestamps
lim_seo_template_id ^FK integer
table_id integer
table_type string (64)
rank integer

lim_seo_field_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_seo_field_id ^FK integer
value string (300)

lim_empty

id increments
timestamps timestamps

lim_language_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
name string (32)

lim_galleries

id increments
timestamps timestamps
lim_gallery_template_id ^FK integer
template_setting_json text

lim_gallery_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_gallery_id ^FK integer
name string (64)
content text

lim_gallery_templates

id increments
timestamps timestamps
template_file string (128)

lim_gallery_template_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_gallery_template_id ^FK integer
name string (32)

lim_branches

id increments
timestamps timestamps
lim_content_type_id ^FK integer
rank integer

lim_branch_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_branch_id ^FK integer
name string (64)
content text

lim_images

id increments
timestamps timestamps
table_type string (64)
table_id integer
rank integer
path string (64)

lim_image_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_image_id ^FK integer
name string (64)
alt string (64)
title string

lim_properties

id increments
timestamps timestamps
table_type string (64)
table_id integer
lim_property_group_id ^FK integer
rank integer
icon string (64)

lim_property_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_property_id ^FK integer
name string (32)
content string (256)

lim_property_groups

id increments
timestamps timestamps
table_type string (64)
table_id integer
rank integer

lim_property_group_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_property_group_id ^FK integer
name string (32)
content text

lim_property_templates

id increments
timestamps timestamps
template_file_path string (64)

lim_property_template_languages

id increments
timestamps timestamps
lim_language_id ^FK integer
lim_property_template_id ^FK integer
name string (32)