Skip to content

sop_doctors

Source: src/db/doctor-schema/schema.ts

Columns

TypeScript key	SQL column	Notes
`userId`	`user_id`
`classificationId`	`classification_id`
`subSpecialityId`	`sub_speciality_id`
`subSpecialityEn`	`sub_speciality_en`
`subSpecialityAr`	`sub_speciality_ar`
`classificationEn`	`classification_en`
`classificationAr`	`classification_ar`
`doctorNameEn`	`doctor_name_en`
`doctorNameAr`	`doctor_name_ar`
`image`	`image`
`isCoordinatorAvailable`	`is_coordinator_available`
`isDoctorAvailable`	`is_doctor_available`

Notes

@deprecated Use SOP_DOCTORS_TABLE.
@deprecated Use SOP_DOCTORS_COLUMNS.
Profile fields for admin display / persistence sync; excludes availability flags.
@deprecated Use SopDoctorRow.