Table arcasys.goldberg_system_settings Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int 10  √ 
site_name_de varchar 255  √  null
site_subtitle_de varchar 255  √  null
footer_message_en varchar 255  √  null
public_role_id int 10  √  null
session_timeout int 10 0
site_default_page_id int 10  √  null
not_found_page_id int 10  √  null
permission_denied_page_id int 10  √  null
session_expired_page_id int 10  √  null
menu_depth int 10 0
start_path varchar 255  √  null
site_url_prefix varchar 255  √  null
self_reg_enabled bit 0  √  null
self_reg_role_id int 10  √  null
self_reg_confirmation_required bit 0  √  null
self_reg_confirmation_error_page_id int 10  √  null
self_reg_send_confirmation_email bit 0  √  null
site_name_en varchar 255  √  null
site_subtitle_en varchar 255  √  null
footer_message_de varchar 255  √  null

Table contained 1 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
not_found_page_id Performance Asc fk_system_settings_not_found_page_id
permission_denied_page_id Performance Asc fk_system_settings_permission_denied_page_id
public_role_id Performance Asc fk_system_settings_public_role_id
session_expired_page_id Performance Asc fk_system_settings_session_expired_page_id
site_default_page_id Performance Asc fk_system_settings_site_default_page_id