💊 Pharma & Life Sciences · Database ERD
Electronic Batch Record Schema
A schema for electronic batch records in pharmaceutical manufacturing: products, master recipes, batches, steps, materials used and deviations.
Drawing diagram…
What this diagram shows
- Each batch follows an approved master recipe version
- Every step records who did it and when (GMP)
- Deviations are linked to the batch for QA release
Prompt used
ERD for electronic batch records: Product has MasterRecipes with versions and approval status; Batch is produced from a MasterRecipe with batch number and quantity; BatchStep records each executed step with operator, verifier and timestamps; MaterialConsumption links raw material lots used in steps; Deviation is raised against a Batch; QaRelease records the final release decision.
Mermaid code
erDiagram
PRODUCT ||--o{ MASTER_RECIPE : "made by"
MASTER_RECIPE ||--o{ BATCH : "executed as"
BATCH ||--|{ BATCH_STEP : records
BATCH_STEP ||--o{ MATERIAL_CONSUMPTION : uses
MATERIAL_LOT ||--o{ MATERIAL_CONSUMPTION : "consumed in"
BATCH ||--o{ DEVIATION : raises
BATCH ||--o| QA_RELEASE : "released by"
MASTER_RECIPE {
int id PK
int product_id FK
string version
string status
}
BATCH {
int id PK
int recipe_id FK
string batch_no
decimal quantity
}
BATCH_STEP {
int id PK
int batch_id FK
string step_name
string operator
string verifier
datetime done_at
}
DEVIATION {
int id PK
int batch_id FK
string classification
string status
}Related templates
Lab Sample Lifecycle (LIMS)
The states of a laboratory sample in a LIMS, from collection to reporting and disposal, with rejection and re-testing.
Adverse Drug Event Reporting
How a suspected side effect reported by a doctor or patient is captured, assessed and reported to the regulator on time (pharmacovigilance).
Clinical Trial Management Architecture
The systems that run a clinical trial: trial management, electronic data capture, randomisation, drug supply and safety reporting.
Drug Track-and-Trace Data Flow
How medicine packs are serialised and traced from factory to pharmacy to stop counterfeits: unique codes, aggregation and verification.
Regulatory Submission Workflow
How a pharmaceutical company prepares and files a marketing application (dossier) with regulators and handles their queries.
GxP Deviation and CAPA Workflow
How a pharmaceutical plant handles a manufacturing deviation: report, impact assessment, root cause, CAPA and batch disposition.