Table sola.system.appuser_setting
Software settings specific for a user within the SOLA application. Not used by SOLA.
Tags: FLOSS SOLA Extension, User Admin, Not Used

 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
user_id varchar 40
appuser.id appuser_setting_user_id_fk103 C
Identifier of the user the setting applies to.
name varchar 50 The name of the setting.
vl varchar 2000 The value of the setting
active bool 1 true Flag to indicate if the setting is active or not.

Analyzed at Tue May 31 09:59 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
user_id + name Primary key Asc/Asc appuser_setting_pkey
user_id Performance Asc appuser_setting_user_id_fk103_ind

Close relationships  within of separation:

Excluded from diagram's relationships: approle_appgroup.change_action  user_pword_expiry.pword_change_user  appuser.change_action  appuser_appgroup.change_action  appuser.change_user  appuser_appgroup.change_time  appuser.rowidentifier  approle_appgroup.rowidentifier  appuser_appgroup.change_user  extracted_rows.rowidentifier  appuser_appgroup.rowversion  approle_appgroup.change_user  appuser_appgroup.rowidentifier  approle_appgroup.rowversion  appuser.rowversion  approle_appgroup.change_time  appuser.change_time