I'm building a site using a CMS that already holds user information such as userId, Username, Firstname, Lastname.
I want to build a system that holds additional user information such as the user's Title, Date of birth etc…
- Create a new table to hold the additional fields? This would prevent needing duplicate data, but it means data is split between the CMS tables, and my custom tables.
- Create a seperate table to hold all the user info I need and keep it in sync with the CMS user table? The advantage I see is that the two systems would be separate, but it requires keeping the data in Sync between my system and the CMS.
What are the advantages / disadvantages of each approach?