mercredi 25 février 2015

Check attribute table referenced foreign key


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