-
Notifications
You must be signed in to change notification settings - Fork 0
Database Documentation
In this small project, we have two data tables comprising our MySQL database.
The users table keeps track of all the information about our site's users. The table contains a user's first and last name, email address, login, and password. Additionally, each user has a specific user ID that is used to ensure that users only see contacts registered to their account, and not from another user's account. There is some background logic running in the front end to ensure that every registered user has a unique login associated with an account.
The contacts table keeps track of all the contacts that are stored on our site. The table contains a contact's unique ID, first name, last name, phone, email address, and the userID of which the contact is registered to. The most important fields in this table for the communication between the frontend and backend are the ID and the userID. A contact's ID is used for passing contact information to the following API endpoints DeleteContact.php, SearchContact.php, and UpdateContact.php. The userID is essential to ensure that a logged in user only sees the contacts that have been made and registered to their account.