users

31 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
features_locks.created_by FK_features_locks_users_created_by C
groups_users.user_id FK_groups_users_users_user_id C

Unique identifier.
tenant_id uuid 2147483647 null
tenants.id FK_users_tenants_tenant_id C

Tenant identifier.
role_id uuid 2147483647 null
roles.id FK_users_roles_role_id R
username text 2147483647 null
email text 2147483647 null
password text 2147483647 null
fullname varchar 256 null
locale text 2147483647 null
last_seen timestamptz 35,6 √ null
last_client int4 10 0
status int4 10 0
time_zone text 2147483647 √ null
created_at timestamptz 35,6 now()

DateTime the record was created.
created_by uuid 2147483647 √ null

User who create the record. Null if System.
updated_at timestamptz 35,6 √ null

DateTime the record was last updated.
updated_by uuid 2147483647 √ null

User who last updated the record.
is_system bool 1 false

A system-generated record. Default = false

Indexes

Constraint Name Type Sort Column(s)
PK_users Primary key Asc id
IX_users_created_at Performance Asc created_at
IX_users_email Performance Asc email
IX_users_id Must be unique Asc id
IX_users_is_system Performance Asc is_system
IX_users_role_id Performance Asc role_id
IX_users_status Performance Asc status
IX_users_tenant_id Performance Asc tenant_id
UQ_users_tenantid_username Must be unique Asc/Asc tenant_id + username

Relationships

Close relationships within degrees of separation