user_app_access

680 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
users.id fk_user_app_access_user_id C
app_code text 2147483647 null
apps.code fk_user_app_access_app_code R
prop_id int4 10 √ null
property.id fk_user_app_access_prop_id C
enabled bool 1 true
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
unq_user_app_access Must be unique Asc/Asc/Asc user_id + app_code + prop_id

Check Constraints

Constraint Name Constraint
chk_user_app_access_app_lower (app_code = lower(app_code))

Relationships

Close relationships within degrees of separation