page
id
bigint unsigned
++
template
bigint unsigned
seo_id
bigint unsigned
social_media_id
bigint unsigned
status
int unsigned
entry
id
bigint unsigned
++
seo_id
bigint unsigned
social_media_id
bigint unsigned
status
int unsigned
publish_after
timestamp
page_i18n
page_id
bigint unsigned
language_id
int unsigned
route
varchar (120)
title
varchar (120)
content
text
raw_content
text
revision
timestamp
entry_i18n
entry_id
bigint unsigned
language_id
int unsigned
revision
timestamp
nn
slug
varchar (120)
nn, uniq
title
varchar (120)
nn
description
text
nn
content
text
nn
raw_content
text
nn
media_id
bigint unsigned
nn
media_caption
varchar (200)
alt
varchar (120)
seo_media_title
varchar (120)
created_at
timestamp
nn
updated_at
timestamp
type
varchar (120)
media
id
bigint unsigned
++
name
varchar (120)
nn
path
varchar (255)
nn
file_name
varchar (160)
mime_type
int unsigned
size
int unsigned
type
int unsigned
status
int unsigned
created_at
timestamp
created_by
bigint unsigned
updated_at
timestamp
updated_by
bigint unsigned
gallery
id
bigint unsigned
++
status
int unsigned
slider
id
bigint unsigned
++
machine_name
varchar (120)
uniq
status
int unsigned
nn
slider_i18n
slider_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
description
text
gallery_i18n
gallery_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
description
text
media_i18n
media_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
description
text
language
id
int unsigned
++
name
varchar (120)
code
varchar (6)
uniq
product
id
bigint unsigned
++
status
int unsigned
product_i18n
product_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
nn
description
text
price
decimal unsigned
nn
tag
id
bigint unsigned
++
status
int unsigned
tag_i18n
tag_id
bigint unsigned
language_id
int unsigned
name
varchar (120)
nn
file
id
bigint unsigned
++
mime_type
int unsigned
nn
size
bigint unsigned
created_at
timestamp
updated_at
timestamp
file_i18n
file_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
description
text
status
int unsigned
category
id
bigint unsigned
++
parent_id
bigint unsigned
status
int unsigned
category_i18n
category_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
description
text
slider_entry
slider_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
description
text
url
varchar (255)
resource
varchar (255)
image_path
varchar (255)
image_title
varchar (120)
image_alt
varchar (120)
position
int
created_at
timestamp
created_by
bigint unsigned
updated_at
timestamp
updated_by
bigint unsigned
revision
timestamp
gallery_entry
gallery_id
bigint unsigned
media_id
bigint unsigned
position
int unsigned
entry_tag
entry_id
bigint unsigned
tag_id
bigint unsigned
weight
int
category_entry
entry_id
bigint unsigned
category_id
bigint unsigned
seo
id
bigint unsigned
++
status
int unsigned
seo_i18n
seo_id
bigint unsigned
language_id
int unsigned
seo_page_title
varchar (160)
seo_page_description
text
seo_page_keywords
varchar (200)
social_media
id
bigint unsigned
++
status
int unsigned
social_media_i18n
social_media_id
bigint unsigned
language_id
int unsigned
og_title
varchar (120)
og_description
text
og_media_id
bigint unsigned
twitter_title
varchar (120)
twitter_description
text
twitter_media_id
bigint unsigned
gplus_name
varchar (120)
gplus_description
text
gplus_media_id
bigint unsigned
entry_relation
primary_entry_id
bigint unsigned
secondary_entry_id
bigint unsigned
relation
int unsigned
template
id
bigint unsigned
++
path
varchar (120)
nn
socket
id
bigint unsigned
++
template_id
bigint unsigned
widget
id
bigint unsigned
++
machine_name
varchar (255)
nn
status
int unsigned
socket_has_widget
id
bigint unsigned
++
page_id
bigint unsigned
socket_id
bigint unsigned
widget_id
bigint unsigned
position
bigint unsigned
widget_i18n
widget_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
nn
description
text
settings
text
content_before
text
content_before_raw
text
content_after
text
content_after_raw
text
socket_i18n
socket_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
nn
description
text
template_i18n
template_id
bigint unsigned
language_id
int unsigned
title
varchar (120)
nn
description
text
user
id
bigint unsigned
++
username
varchar (40)
nn, uniq
email
varchar (80)
nn, uniq
auth_key
varchar (32)
uniq
password_hash
varchar (255)
nn
password_reset_token
varchar (255)
status
smallint
nn
created_at
timestamp
updated_at
timestamp
gallery_access_token
token
varchar (20)
uniq
gallery_id
bigint unsigned
title
varchar (120)

SQL Table columns

Zoom:

Offset(left, top): ,

Size(width, height): ,

Viewport (width, height): ,

Mouse (left, top): ,

viewport mouse (left, top): ,

mouse keys: left: right:

App context menu

SQL table context menu

SQL table column context menu

Menu kontekstowe drag and dropa