Nested CDTs vs Non Nested CDTs

Hi everyone,

I am trying to understand in terms of Appian's best practice as to which way to go when creating CDTs and maintaining their relationships, and the use of nested CDTs.  Is it recommended to use nested CDTs per best practice, or is it better to stay away from that?  From my understanding, it's easier and better to create the tables in the database first then create CDTs from db where the relationship is maintained strictly in db and not necessarily in Appian.  Then there is the other way, in which the cdts are created in Appian, with the relationships maintained through the use of Nested CDTs for the foreign key etc..  Is it a matter of preference to create the CDTs from db vs the other way with nested CDTs, or is it Appian recommended? 

Any thoughts on this?

Regards,

Jerry