After doing some change As Mr Vérace told me here in this question, by changing the id names of each table into
table_name_id and using the singular notation, I still need your opinion about this database and if it is ok to start with for a dentists application.
Here is some information about it
I added a table called dentist_info to add information about each dentist.
Login Table contain login information for dentists (it may be used by multiple dentists online)
The id_logged column is a foreign key of the id of logged in dentists, and it should be in all tables. (To let dentists see only their own patient info and details).
The patient_id column is a foreign key too. And it is taken from patient table and used as foreign key in med_history that represents the general medical information of the patients, patient_info that represents the general information, and the reason of visit and what tasks to do, and in the appointment table.
I have 2 questions:
1- Is there more than that information to add for a dentist database?
2- Is this database correct? Or are there errors?