I don't think such a thing is possible. The foreign key of a child table references the primary key of the parent table. In this case, a single column foreign key of one of the child table will be the same for the other child table, in which case, it does not make sense to have a composite foreign key.