user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
uuid uuid 2147483647 gen_random_uuid()
connection.id_owned_by connection_id_owned_by_fkey R
dashboard.id_owned_by dashboard_id_owned_by_fkey R
database_info.id_owned_by database_info_id_owned_by_fkey R
macro.id_owned_by macro_id_owned_by_fkey R
managed_table.id_owned_by managed_table_id_owned_by_fkey R
role.id_owned_by role_id_owned_by_fkey R
saved_query.id_owned_by saved_query_id_owned_by_fkey R
schema_info.id_owned_by schema_info_id_owned_by_fkey R
shared_query.id_owned_by shared_query_id_owned_by_fkey R
user.id_owned_by user_id_owned_by_fkey R
user_roles.id_user user_roles_id_user_fkey C
user_security_filter.user_uuid user_security_filter_user_uuid_fkey C
user_session.id_owned_by user_session_id_owned_by_fkey R
user_session.user_id user_session_user_id_fkey R
name text 2147483647 null
comment text 2147483647 √ null
created_on timestamptz 35,6 now()
props jsonb 2147483647 √ null
tags jsonb 2147483647 √ null
updated_on timestamptz 35,6 now()
version int8 19 1
authservice text 2147483647 √ null
enabled bool 1 true
username text 2147483647 null
avatar text 2147483647 √ null
email text 2147483647 √ null
expirydate timestamptz 35,6 √ null
preferences jsonb 2147483647 √ null
is_default bool 1 false
id_owned_by uuid 2147483647 null
user.uuid user_id_owned_by_fkey R
source text 2147483647 √ null

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
user_pkey Primary key Asc uuid
uk_user Must be unique

Relationships

Close relationships within degrees of separation