smoketest schema

Available on backends: TPP, EMIS

This tiny schema is used to write a minimal dataset definition that
can function as a basic end-to-end test (or "smoke test") of the OpenSAFELY platform
across all available backends.

from ehrql.tables.smoketest import (
    patients,
)

one row per patient

patients

Columns

date_of_birth 🔗 date: Patient's year and month of birth, provided in format YYYY-MM-01. The day will always be the first of the month.

Always the first day of a month

Never NULL