Evidence records, reports, studies and claims
Separates indexed records, published reports and underlying studies to prevent double counting. 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
STUDY ||--o{ STUDY_REPORT : described_in
REPORT ||--o{ STUDY_REPORT : reports
REPORT ||--o{ RECORD : indexed_as
RECORD ||--o{ SCREENING : receives
REPORT ||--o{ EXTRACT : supplies
EXTRACT ||--o{ CLAIM_SUPPORT : grounds
CLAIM ||--o{ CLAIM_SUPPORT : supported_by
REVIEWER ||--o{ SCREENING : decides
REVIEWER ||--o{ EXTRACT : extracts
STUDY {
string study_id PK
string design
}
REPORT {
string report_id PK
string title
}
RECORD {
string record_id PK
string report_id FK
string source_database
}
SCREENING {
string screening_id PK
string record_id FK
string reviewer_id FK
string decision
string reason
}
EXTRACT {
string extract_id PK
string report_id FK
string reviewer_id FK
string location
string value
}
CLAIM {
string claim_id PK
string text
}
CLAIM_SUPPORT {
string claim_id FK
string extract_id FK
string support_type
}
REVIEWER {
string reviewer_id PK
string name
}
STUDY_REPORT {
string study_id FK
string report_id FK
}