B2B
Tables (8)
Admin (admin)
- Admin_Id (admin_id) — INT — Primary key — NOT NULL
- Clinic_Id (clinic_id) — INT — Foreign key → Clinic.Clinic_Id — NOT NULL
Analytics (analytics)
- Analytics_Id (analytics_id) — INT — Primary key — NOT NULL
- Reservation_Id (reservation_id) — INT — Foreign key → Reservation.Reservation_Id — NOT NULL
Clinic (clinic)
- Clinic_Id (clinic_id) — INT — Primary key — NOT NULL
Hospital_Specialty (hospital_specialty)
- Mapping_Id (mapping_id) — INT — Primary key — NOT NULL
- Clinic_Id (clinic_id) — INT — Foreign key → Clinic.Clinic_Id — NOT NULL
- Specialty_Id (specialty_id) — INT — Foreign key → Spectialty.Specialty_Id — NOT NULL
Notification (notification)
- Notification_Id (notification_id) — INT — Primary key — NOT NULL
- Admin_Id (admin_id) — INT — Foreign key → Admin.Admin_Id — NOT NULL
Patient (patient)
- Patient_Id (patient_id) — INT — Primary key — NOT NULL
Reservation (reservation)
- Reservation_Id (reservation_id) — INT — Primary key — NOT NULL
- Clinic_Id (clinic_id) — INT — Foreign key → Clinic.Clinic_Id — NOT NULL
- Patient_Id (patient_id) — INT — Foreign key → Patient.Patient_Id — NOT NULL
Spectialty (specialty)
- Specialty_Id (specialty_id) — INT — Primary key — NOT NULL