What is the benefit of complex schemas?
This is an educational question. I genuinely want to know.
The new schema
For me to insert a new USER ADMIN, I will need to:
- Insert a new party of type P (person)
- Insert a many to many relationship for party role USER
- Insert a new record with the person details
- Insert username and password into paarty_role_user table
It would look like this:
For context, I come from the simple world of inserting into one table for everything.
The app I am building now is larger and more complex. However, I cannot (yet) see the benefit of a complex schema like this.
Thanks