Help with creating a complex app using the advanced template

I’d create separate models w/o inheritance. These are alike but not the same.

Can’t say anything about your ER model since it’s really application dependant.

btw., it’s better to create separate threads for separate questions. Easier for others to follow, discuss and find it later.