dashboard

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 √ null
prop_id int4 10 null
property.id fk_dashboard_prop_id C
user_group_id int4 10 √ null
user_id int4 10 √ null
users.id fk_dashboard_user_id C
user_group.id fk_dashboard_user_group_id C
url text 2147483647 null
uid text 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
dashboard_pkey Primary key Asc id
idx_dashboard_prop_id Performance Asc prop_id
idx_dashboard_user_group_id Performance Asc user_group_id
idx_dashboard_user_id Performance Asc user_id
unq_dashboard Must be unique Asc/Asc/Asc prop_id + user_group_id + user_id

Relationships

Close relationships within degrees of separation