Using 'parent_id' as default parent role field name
Populating records based on the parent role identifier
Minor sync of the role entity (was using wrong column naming conventions)
Adding FKs to the suggested schema definitions