punch_list_item_recipients_role_user


Columns

Column Type Size Nulls Auto Default Children Parents Comments
item_id BIGINT 19 null
punch_list_item.id FK35F87BEB49913482 R
user_id INT 10 √ null
sys_users.user_id FK35F87BEB28C762A3 R
id BIGINT 19 √ null
contact_id INT 10 √ null
contact.contact_id FK_punchlist_recipient_contact R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK35F87BEB28C762A3 Performance Asc user_id
FK35F87BEB49913482 Performance Asc item_id
FK_punchlist_recipient_contact_idx Performance Asc contact_id

Relationships

Close relationships within degrees of separation