user_property

230 rows


Description

Authorized properties for each user

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
users.id fk_user_property_user_id C
prop_id int4 10 null
property.id fk_user_property_prop_id C
work_log_id int4 10 √ null
work_shift varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
user_property_pkey Primary key Asc/Asc user_id + prop_id

Relationships

Close relationships within degrees of separation