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.

enter image description here

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?

  • Why does it take 5 characters to say 'pregnant'? Do your patients have up to 4 billion teeth? Seems like TINYINT UNSIGNED is plenty big. Why are there 2 or more links between some pairs of tables? Do not split DATE and TIME into separate columns; it only cause trouble later.
    – Rick James
    Mar 3, 2016 at 22:31
  • You have some sensitive info; be sure to run it by someone with an eye for security. You will have hell to pay if someone hacks in.
    – Rick James
    Mar 3, 2016 at 22:33
  • What does "id_logged" mean?
    – Rick James
    Mar 3, 2016 at 22:33
  • 1
    I could pose as a Dentist, get a login, then rummage through all the tables, etc. A hacker could exploit ways to get through the client software and literally read the entire disk, or erase it. That's just a few things I worry about in what you have designed.
    – Rick James
    Mar 5, 2016 at 18:28
  • 1
    Date of birth is a key distinguishing factor. Pregnancy and prescriptions are touchy things.
    – Rick James
    Mar 7, 2016 at 17:45


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.