[GUSDEV] parentList definitions in table object layer

[Mark S. H. <mh...@ug...>]

My GUS3.5 DoTS::TranslatedAAFeature_Table has two entries for  
TranslatedAASequence its parentList:

['GUS::Model::DoTS::TranslatedAASequence','aa_sequence_id','aa_sequence_ 
id'],
['GUS::Model::DoTS::TranslatedAASequence','motif_aa_sequence_id','aa_seq 
uence_id']

(there are also many other parent tables defined)

I'm having problems with this definition (while running the  
DoTS::DotsBuild::Plugin::UpdateDotsAssembliesWithCap4 plugin). When a  
new TranslatedAAFeature (taf) is being created as a child of  
TranslatedAASequence (tas) the tas.aa_sequence_id is being passed to  
taf.motif_aa_sequence_id instead of the non-nullable taf.aa_sequence_id

The end result is the error "cannot insert NULL into  
("DOTS"."AAFEATUREIMP"."AA_SEQUENCE_ID")"

If I swap the order of the two TAS parents (or delete the problem  
one) then the TAF child is created fine.

My old GUS3.0  DoTS::TranslatedAAFeature_Table has only one parent  
link to TranslatedAASequence. Why does my GUS3.5 table object define  
multiple parents? (There are multiple parentList entries for other  
tables as well but so far I've only had problems with this one.) Are  
my table constraints mucked up or is there some other problem?


-M