user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('system.user_id_seq'::regclass)
acknowledgednotification.user_id fk_acknowledgeddevices_user C
dashboard.user_id fk_dashboard_user C
dataview.user_id fk_dataview_user C
notificationsubscription.user_id fk_nsubscription_user C
session.user_id fk_session_user C
user_apikey.user_id fk_apikey_user C
user_certificate.user_id fk_cert_user C
user_role.user_id fk_ur_user C
acknowledgeddevice.user_id fk_acknowledgeddevices_user C
map.user_id fk_map_user C
acknowledgeddevice.user_id fk_acknowledgeddevices_user C
map.user_id fk_map_user C
name text 2147483647 √ null
fullname text 2147483647 √ null
superuser bool 1 false
hidden bool 1 false
updatenotes hstore 2147483647 √ null
aduser bool 1 √ false

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
pk_user_id Primary key Asc id
idx_user_hidden Performance Asc hidden
idx_user_superuser Performance Asc superuser
uk_user_name Must be unique Asc name

Relationships

Close relationships within degrees of separation