Table sola.system.appuser
The list of users that can have access to the SOLA application.
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
application.assignee_id application_assignee_id_fk15 R
appuser_appgroup.appuser_id appuser_appgroup_appuser_id_fk119 C
appuser_setting.user_id appuser_setting_user_id_fk103 C
The SOLA user identifier.
username varchar 40 The user name assigned to the SOLA user.
first_name varchar 30 The first name of the SOLA user.
last_name varchar 30 The last name of the SOLA user.
email varchar 40  √  null
mobile_number varchar 20  √  null
activation_code varchar 40  √  null
passwd varchar 100 uuid_generate_v1()
active bool 1 true
description varchar 255  √  null
rowidentifier varchar 40 uuid_generate_v1()
rowversion int4 10 0
change_action bpchar 1 'i'::bpchar
change_user varchar 50  √  null
change_time timestamp 29,6 now()
activation_expiration timestamp 29,6  √  null Account activation timeout. It can be used to delete account if it was not activated in time.

Analyzed at Tue May 31 09:59 NZST 2016

Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc appuser_pkey  
email Must be unique Asc appuser_email_unique This unique column is also nullable
rowidentifier Performance Asc appuser_index_on_rowidentifier  
username Must be unique Asc appuser_username_unique  

Close relationships  within of separation:

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