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