Scribd
Upload
17 views1 page

Doctor Patient Tables

The document outlines the structure of two database tables: tblDoctor and tblPatient, detailing their respective columns and data types. Key attributes include identifiers, personal information, medical history, and specialization for doctors, while patients have additional fields for allergies and emergency contacts. Both tables utilize foreign keys to link to a login table for user authentication.

Uploaded by

akyee791
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
17 views1 page

Doctor Patient Tables

The document outlines the structure of two database tables: tblDoctor and tblPatient, detailing their respective columns and data types. Key attributes include identifiers, personal information, medical history, and specialization for doctors, while patients have additional fields for allergies and emergency contacts. Both tables utilize foreign keys to link to a login table for user authentication.

Uploaded by

akyee791
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Column Name Data Type

07 April 2025 09:34 AM


Doc_id Int (PK) Column Name Data Type
Sp_id Int(PK)
Login_id Int (FK tblLogin)
Name Varchar(30) Specialization Varchar(30)
Table : tblSpecialization
Email Varchar(30)
Phone Varchar(15)
DOB Date
Gender Varchar(10) Column Name Data Type
Specialization_id Int(FK tblSpecialization) Id Int(PK)
Years_of_Experience int userName Varchar(20)
Clinic_Hospital_Address Varchar(200) Password Varchar(30)
tblLogin
Medical_License_Number Varchar(25)
Is_working Bit
Table: TblDoctor Column Data Type
Name
Column Name Data Type Id Int(PK)
P_id Int Login_id Int(FK tblLogin)
Login_id Int (FK tblLogin) User_Role Varchar(20)
Name Varchar(30) (Doctor/Patient)
Email Varchar(30) tblUsers
Phone Varchar(15)
DOB Date
Gender Varchar(10)
Blood Group Varchar(6)
Allergies_Peanut bit
Allergies_Dust bit
Allergies_Medicine bit
Allergies_Pollen Bit
Preferred_Doctor_id Int(FK TblDoctor)
Address Varchar(100)
Emergency Contact Varchar(15)
Medical_History Varchar(300)
Tbl_Patient

New Section 4 Page 1

You might also like