EVEP Medical Staff ER Diagram - Print Version

1. Core Medical Staff Entities

MEDICAL_STAFF

staff_id (String, UK) - Unique staff identifier (e.g., MST001234)
employee_number (String, UK) - Hospital employee number (e.g., EMP001234)
first_name, last_name (String) - Staff full name
email, phone (String) - Contact information
role (String) - doctor|nurse|technician|coordinator
specialization (String) - ophthalmology|optometry|pediatrics
license_number (String) - Medical license number
hospital_id (FK) - Reference to HOSPITAL
department (String) - Mobile Unit|Ophthalmology|Pediatrics
is_active (Boolean) - Active employment status

HOSPITAL

hospital_id (String, UK) - Unique hospital identifier
hospital_name (String) - Full hospital name
hospital_code (String) - Short hospital code
address, phone, email (String) - Contact information
type (String) - public|private
is_active (Boolean) - Active hospital status

2. Staff Credentials & Training

MEDICAL_CREDENTIALS

credential_id (String, UK) - Unique credential identifier
staff_id (FK) - Reference to MEDICAL_STAFF
credential_type (String) - medical_license|specialization|certification
credential_number (String) - License or certification number
issuing_authority (String) - Medical Council of Thailand
issue_date, expiry_date (Date) - Credential validity period
status (String) - active|expired|suspended

STAFF_TRAINING

training_id (String, UK) - Unique training identifier
staff_id (FK) - Reference to MEDICAL_STAFF
training_type (String) - equipment|protocol|safety|software
training_name (String) - Auto-refractor Operation
training_provider (String) - Equipment Manufacturer
training_date, expiry_date (Date) - Training validity period
status (String) - completed|in_progress|expired

3. Equipment & Calibration Management

EQUIPMENT

equipment_id (String, UK) - Unique equipment identifier
equipment_type (String) - auto_refractor|vision_chart|computer
model (String) - Topcon KR-8000
serial_number (String) - Equipment serial number
manufacturer (String) - Equipment manufacturer
status (String) - active|maintenance|retired
assigned_staff_id (FK) - Reference to MEDICAL_STAFF

EQUIPMENT_CALIBRATION

calibration_id (String, UK) - Unique calibration identifier
equipment_id (FK) - Reference to EQUIPMENT
staff_id (FK) - Calibrated by (Reference to MEDICAL_STAFF)
calibration_date (Date) - Date of calibration
next_calibration_date (Date) - Next scheduled calibration
calibration_status (String) - calibrated|needs_calibration|failed

4. Clinical Workflow Integration

MOBILE_SCREENING_SESSION

session_id (String, UK) - Unique session identifier
patient_id (FK) - Reference to patient
lead_staff_id (FK) - Lead medical staff (Reference to MEDICAL_STAFF)
assistant_staff_id (FK) - Assistant staff (Reference to MEDICAL_STAFF)
session_date (Date) - Date of screening session
session_status (String) - scheduled|in_progress|completed|cancelled
session_type (String) - initial|follow_up|emergency

SCREENING_ASSESSMENT

assessment_id (String, UK) - Unique assessment identifier
session_id (FK) - Reference to MOBILE_SCREENING_SESSION
staff_id (FK) - Assessed by (Reference to MEDICAL_STAFF)
assessment_type (String) - auto_refractor|manual_vision|eye_examination
assessment_data (Object) - Detailed assessment results
assessment_status (String) - completed|in_progress|cancelled

CLINICAL_DECISION

decision_id (String, UK) - Unique decision identifier
session_id (FK) - Reference to MOBILE_SCREENING_SESSION
staff_id (FK) - Decision made by (Reference to MEDICAL_STAFF)
decision_type (String) - normal|abnormal|referral|glasses_needed
decision_reason (String) - Clinical reasoning
decision_status (String) - pending|confirmed|implemented

5. Medical Staff Roles & Responsibilities

Lead Doctor (Ophthalmologist/Optometrist)

Conduct comprehensive eye examinations
Make clinical decisions and diagnoses
Create glasses prescriptions
Supervise screening sessions
Quality assurance oversight
Patient consultation and education

Nurse

Patient registration and preparation
Assist with screening procedures
Patient care and comfort
Equipment setup and calibration
Documentation and record keeping
Follow-up coordination

Technician

Equipment operation and maintenance
Auto-refractor calibration
Technical support during screening
Equipment troubleshooting
Data collection and entry
Quality control checks

Coordinator

Schedule management and coordination
School communication and liaison
Mobile unit logistics
Staff assignment and supervision
Report generation and distribution
Quality assurance coordination

6. Access Control Matrix

Role	School Screening	Mobile Unit	Equipment	Patient Data	Reports
Lead Doctor	Read	Full Access	Full Access	Full Access	Full Access
Nurse	Read	Full Access	Read/Update	Full Access	Read
Technician	Read	Limited	Full Access	Read	Read
Coordinator	Read	Read/Update	Read	Read	Full Access