I have two tables a and b like this:
a: id, type
b: a_id, ...
There is a limitation for which the references of a in b can only be those which have type equal to a limited set of values.
Is it possible to include a CHECK for an attribute of the referenced table or do you have a better design idea?
Aucun commentaire:
Enregistrer un commentaire