I have a custom registration form, where users can sign up/sign in to my website. I have created database to store the users information, like First Name, Last Name, and Email.
Now I want create database, where I can display different private information for user member, this information are projects that members will be working it out with me, so I need to provide them with regular updates. The new database will consist of below:
- Project Name
- Project Start Date
- Project End Date
- Project photo gallery
- Project Documents
How can I relate the new database with the members database? Same may suggest to simply include this information in the members database instead of creating new database, but this will work only if each member is having 1 project, but for more projects It will not efficient.
I want to make my site more organized and have easy access to such information.
Appreciate your support.