Multiple FK poiting to single column
You should choose a pattern for the FK name that respects the relationships between the tables.
My preference is FK_&lt;child entity&gt;_&lt;verb phrase&gt;_&lt;parent entity&gt;.
So fk_product_modified_by_user, fk_category_modified_by_user, etc.