Table sola.system.approle
Contains the list of application security roles used to restrict access to different parts of the application, both on the server and client side.
Tags: FLOSS SOLA Extension, Reference Table, 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
code varchar 20
approle_appgroup.approle_code approle_appgroup_approle_code_fk117 C
Code for the security role. Must match exactly the code value used within the SOLA source code to reference the role.
display_value varchar 500 The text value that will be displayed to the user.
status bpchar 1 The status of the role.
description varchar 5000  √  null Describes the purpose of the role and should also indicate when it applies.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name
code Primary key Asc approle_pkey
display_value Must be unique Asc approle_display_value_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