I’m looking for a way to restrict a foreign key filed to a subset of the target table. For example, in a Customer field, I want to allow only Partners that have a isCustomer attribute set to true:
So if I’m not misunderstanding, this will add a filter in the view, but will not enforce the constraint at the db level.
That might be enough for my use case, but it’s just to be sure.