rbac_user_locations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id uuid 2147483647 null
rbac_users.id rbac_user_locations_user_id_fkey C
practice_location_id text 2147483647 null
is_active bool 1 true
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
rbac_user_locations_pkey Primary key Asc/Asc user_id + practice_location_id
rbac_user_locations_active_idx Performance Asc/Asc practice_location_id + is_active

Check Constraints

Constraint Name Constraint
rbac_user_locations_practice_location_id_check ((practice_location_id <> ''::text))

Relationships

Close relationships within degrees of separation