Table sola.system.approle_appgroup
Associates the application security roles to the groups. One role can exist in many groups.
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
approle_code varchar 20
approle.code approle_appgroup_approle_code_fk117 C
Code for the security role.
appgroup_id varchar 40 approle_appgroup_appgroup_id_fk118 C
Identifier for the group the role is associated to.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the system.approle_appgroup_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
approle_code + appgroup_id Primary key Asc/Asc approle_appgroup_pkey
appgroup_id Performance Asc approle_appgroup_appgroup_id_fk118_ind
approle_code Performance Asc approle_appgroup_approle_code_fk117_ind

Close relationships  within of separation:

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