1. Doctors
1.1. Doctor ID
1.2. Name
1.3. DOB
1.4. Age
1.5. Gender
1.6. Address
1.7. Speciality
1.8. Department
1.9. Dr. Hadeel Alfaras
1.9.1. Doctor ID
1.9.2. Name
1.9.3. DOB
1.9.4. Age
1.9.5. Gender
1.9.6. Address
1.9.7. Speciality
1.9.8. Department
2. Appointment Information
2.1. Appointment ID
2.2. Date
2.3. Time
2.4. Patient Information
2.5. Doctor
2.6. Payment
2.6.1. Payment ID
2.6.2. Amount
2.6.3. Description
2.6.4. Payment Type
2.6.4.1. Debit
2.6.4.2. Credit
2.6.4.3. Cash
3. Deparments
3.1. Dental
3.1.1. Deparment ID
3.1.2. Department Description
3.1.3. Department Name
3.2. Pediatric
3.2.1. Deparment ID
3.2.2. Department Description
3.2.3. Department Name
3.3. Dermatology
3.3.1. Deparment ID
3.3.2. Department Description
3.3.3. Department Name
3.4. Gyne
3.4.1. Deparment ID
3.4.2. Department Description
3.4.3. Department Name
3.5. Family Medicine
3.5.1. Deparment ID
3.5.2. Department Description
3.5.3. Department Name
3.6. Child Devlopment
3.6.1. Deparment ID
3.6.2. Department Description
3.6.3. Department Name
3.7. Labatory
3.7.1. Deparment ID
3.7.2. Department Description
3.7.3. Department Name
3.8. Beautician
3.8.1. Deparment ID
3.8.2. Department Description
3.8.3. Department Name
3.9. laser & TrioShape
3.9.1. Deparment ID
3.9.2. Department Description
3.9.3. Department Name
3.10. Medical SPA
3.10.1. Deparment ID
3.10.2. Department Description
3.10.3. Department Name
3.11. Nutrition
4. Prescription
4.1. Prescription ID
4.2. Description
4.3. Amount
5. Equipments
5.1. Equipment ID
5.2. Name
5.3. Description
6. Rooms Numbers
6.1. Floor One
6.1.1. Section A
6.1.1.1. 1-
6.1.1.2. 2-
6.1.1.3. 3-
6.1.2. Section B
6.1.3. Section C
6.2. Floor Two
6.3. Floor Three
7. Patients
7.1. Patient ID
7.2. Name
7.3. DOB
7.4. Age
7.5. Gender
7.6. Address
8. Budget Information
8.1. Salary
8.2. Total Income
8.2.1. All the information about the incomes
8.3. Total Expense
8.3.1. All the information about the expenses
9. Staffs
9.1. Staff ID
9.2. Name
9.3. DOB
9.4. Gender
9.5. Address
9.6. Job
9.7. Management
9.7.1. Staff ID
9.7.2. Name
9.7.3. DOB
9.7.4. Gender
9.7.5. Address
9.7.6. Job