Does sqlserver have anything like union foreign keys

sparkcj20

such as:
I have three tables, the product table, the enterprise table, and the publication activity table. The user has to comment on these three tables that are not related and have different structures, so I have a review table.
Comment form details:
F_Id int identiy (1,1), primary key
Entity_Id int, or product ID, or enterprise ID, or publishing activity ID ------- Question?
F_Bound tinyint, the scope of the review, is the product, business or event
User_Id varchar (20), user ID
F_Title varchar (50), comment title
F_DateTime datetime, comment time
F_Content varchar (500)

How can I set the foreign key of this table? If a foreign key is set, there is a master-slave table relationship, but the Entity_Id does not correspond to only one table. How to make it a foreign key for three tables ???????

fanfan1980

Entity_Id int, or product ID, or enterprise ID, or release event ID
Entity_Type int, or 1- commodity table, 2- enterprise table, 3- release activity table

--Can I add a field?

wgfxman

Doesn't seem to work

To achieve this, it can be verified by trigger, insert or update

sparkcj20

fanfan1980
 
 
   Entity_Id int, or product ID, or enterprise ID, or release event ID
Entity_Type int, or 1- commodity table, 2- enterprise table, 3- release activity table

--Can I add a field?
____________________________________________________________________________
Of course, but there is still no relationship. My table already has such a field.

sparkcj20

wgfxman
 
 
   Doesn't seem to work

To achieve this, it can be verified by trigger, insert or update
_______________________________________________________________________
Really? Can this only be done? ? I'm so disappointed. I want to listen to the opinions of the authorities.
Does MS have no scientific plan

sparkcj20

If it doesn’t work, I don’t have any constraints or write it.

vgf10002

Establish relationships with the Entity_Id of the comment table on the other three tables