I want to design a database for a hospital management system I have in the system: Doctors, Nurses, patients, accountants, department, and booking .....

what is the best practice for design: first option: user_info table contain: ID, name, age, user_type .....

second option: doctors_table contain : ID, name, age ....., patients_table contain : ID, name, age .....,

third option: you can suggest another one

CodePudding user response：

If the fields are the same, then use one table (option one) and add a type field for if they are doctor, accountant, etc.

You can then also have other tables for specific fields that you join, based on those type fields.