logo
ExamplesEditorPricingDocs
37.1kSign in

Clinic appointment scheduling database schema

Outpatient scheduling in MySQL: recurring availability templates that generate slots, appointments that consume exactly one slot, waitlists that backfill cancellations, two-way reminders, referrals, and a dated no-show policy.

Clinic Appointments ER diagram

Clinic appointment scheduling database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 11 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 clinics idBIGINT nameVARCHAR codeVARCHAR timezoneVARCHAR address_lineVARCHAR phoneVARCHAR is_activeBOOLEAN rooms idBIGINT clinic_idBIGINT nameVARCHAR room_typeVARCHAR is_activeBOOLEAN providers idBIGINT full_nameVARCHAR credentialVARCHAR specialtyVARCHAR default_clinic_idBIGINT is_activeBOOLEAN patients idBIGINT medical_record_nu…VARCHAR given_nameVARCHAR family_nameVARCHAR date_of_birthDATE phoneVARCHAR emailVARCHAR preferred_channelVARCHAR no_show_countSMALLINT created_atDATETIME appointment_types idBIGINT clinic_idBIGINT nameVARCHAR duration_minutesSMALLINT buffer_minutesSMALLINT requires_roomBOOLEAN room_typeVARCHAR default_price_cen…INTEGER currency_codeCHAR is_activeBOOLEAN availability_templa… idBIGINT provider_idBIGINT clinic_idBIGINT weekdayTINYINT start_timeTIME end_timeTIME slot_interval_min…SMALLINT appointment_type_…BIGINT room_idBIGINT valid_fromDATE valid_toDATE slots idBIGINT provider_idBIGINT clinic_idBIGINT room_idBIGINT template_idBIGINT appointment_type_…BIGINT starts_atDATETIME ends_atDATETIME statusVARCHAR hold_expires_atDATETIME generated_atDATETIME appointments idBIGINT slot_idBIGINT patient_idBIGINT provider_idBIGINT clinic_idBIGINT appointment_type_…BIGINT referral_idBIGINT statusVARCHAR booking_channelVARCHAR booked_atDATETIME cancelled_atDATETIME cancelled_byVARCHAR cancellation_reas…VARCHAR fee_charged_centsINTEGER currency_codeCHAR waitlist_entries idBIGINT patient_idBIGINT clinic_idBIGINT provider_idBIGINT appointment_type_…BIGINT earliest_dateDATE latest_dateDATE preferred_weekdaysVARCHAR priorityTINYINT statusVARCHAR offered_slot_idBIGINT offer_expires_atDATETIME created_atDATETIME cancellation_polici… idBIGINT clinic_idBIGINT appointment_type_…BIGINT notice_hoursSMALLINT late_cancel_fee_c…INTEGER no_show_fee_centsINTEGER currency_codeCHAR no_shows_before_b…TINYINT window_daysSMALLINT effective_fromDATE effective_toDATE referrals idBIGINT patient_idBIGINT referring_provide…VARCHAR referred_to_provi…BIGINT clinic_idBIGINT appointment_type_…BIGINT reasonVARCHAR urgencyVARCHAR statusVARCHAR received_onDATE expires_onDATE reminders idBIGINT appointment_idBIGINT channelVARCHAR scheduled_forDATETIME sent_atDATETIME delivery_statusVARCHAR responseVARCHAR responded_atDATETIME template_keyVARCHAR

Related database schemas

PostgreSQL
Healthcare

Hospital / EHR database schema

The core of an electronic health record: patients and providers, appointments versus encounters, coded conditions and observations, prescriptions against a drug catalogue, allergies and insurance coverage over time.

PostgreSQL
Healthcare

Telemedicine platform database schema

How a virtual care product models its data: clinician licences per state with expiry dates driving who may treat whom, bookable slots, video consultations with a waiting room, intake forms, e-prescriptions routed to a pharmacy, and per-region pricing.

MySQL
Travel

Hotel booking & reservation database schema

A reservation system that actually handles availability: room types versus rooms, rate plans, a per-night rate and inventory calendar, reservations broken down by night, payments and verified reviews.

SQL Server
Healthcare

Health insurance claims processing database schema

Payer-side claims processing in SQL Server: plans with benefit rules, policies covering members and dependents, provider network tiers, claims with service lines, per-line adjudication, coded denials, appeals, explanations of benefits and remittance to providers.