Table sola.system.appgroup
Groups application security roles to simplify assignment of roles to individual system users.
Tags: FLOSS SOLA Extension, User Admin

Generated by
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 varchar 40
approle_appgroup.appgroup_id approle_appgroup_appgroup_id_fk118 C
appuser_appgroup.appgroup_id appuser_appgroup_appgroup_id_fk120 C
Identifier for the appgroup.
name varchar 600 The name assigned to the appgroup.
description varchar 1000  √  null Describes the purpose of the appgroup and should also indicate when it applies.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc appgroup_pkey
name Must be unique Asc appgroup_name_unique

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