Laboratory specimen chain of custody
Preserves specimen-to-aliquot identity and distinguishes assay results from quality-control results. Original worked design example; adapt responsibilities, thresholds and assumptions to your system.
Rendering…
What this template contains
- Diagram type
- Entity-relationship diagram
- Source
- 54 lines
Make it your own.
erDiagram
PARTICIPANT ||--o{ SPECIMEN : provides
SPECIMEN ||--o{ ALIQUOT : divided_into
ALIQUOT ||--o{ CUSTODY_EVENT : transferred
LOCATION ||--o{ CUSTODY_EVENT : receives
ALIQUOT ||--o{ ASSAY_RUN : analyzed_by
ASSAY_PROTOCOL ||--o{ ASSAY_RUN : governs
ASSAY_RUN ||--o{ ASSAY_RESULT : produces
ASSAY_RUN ||--o{ QC_RESULT : checked
PARTICIPANT {
string participant_id PK
string pseudonym
}
SPECIMEN {
string specimen_id PK
string participant_id FK
string collected_at
}
ALIQUOT {
string aliquot_id PK
string specimen_id FK
string volume
}
CUSTODY_EVENT {
string event_id PK
string aliquot_id FK
string location_id FK
string timestamp
}
LOCATION {
string location_id PK
string storage_condition
}
ASSAY_PROTOCOL {
string protocol_id PK
string version
}
ASSAY_RUN {
string run_id PK
string aliquot_id FK
string protocol_id FK
}
ASSAY_RESULT {
string result_id PK
string run_id FK
string analyte
string value
string unit
}
QC_RESULT {
string qc_id PK
string run_id FK
string status
}