Comment 21 for bug 1777675

Kathy, please note that we can't use a real foreign key against asset.copy.id, it needs to follow the same pattern as other tables that link to a copy and use the inheritance-aware custom trigger.

Kyle, please don't do that. All that is needed is a might_have linked virtual field in the IDL. There's no need for an actual column.