如何在不使用触发器的情况下为1到多个关系设置额外的约束?

I have come across a database in my current position that needs allot of TLC to say the least, there are many cross reference tables all having the same structure schema wise, and all using triggers to enforce business logic, or domain integrity it would seem. I am trying to figure out if I can replace some of the triggers with constraints. Below is a typical table definition meeting this pattern. There are about 400 of these tables that exist all using the same trigger based solution.I have come across a database in my current pos