REDCAB_ERD
Tables (7)
Activity_logs
- log_id — UUID
- user_id — UUID — Foreign key → Users.user_id
- action — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
Analysis_results
- result_id — UUID
- case_id — UUID — Foreign key → Cases.case_id
- prediction — VARCHAR(20)
- msi_prob — FLOAT
- attention_score — FLOAT
- top_variant — VARCHAR(100)
- result_json — JSONB
- report_json_path — VARCHAR(500)
- report_pdf_path — VARCHAR(500)
- created_at — TIMESTAMP
Cases
- case_id — UUID
- examination_id — UUID — Foreign key → Examinations.examination_id
- status — case_status — NOT NULL
- is_success — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- started_at — TIMESTAMP
- completed_at — TIMESTAMP
Examinations
- examination_id — UUID
- patient_id — UUID — Foreign key → Patients.patient_id
- user_id — UUID — Foreign key → Users.user_id
- exam_date — DATE — NOT NULL
- note — TEXT
- created_at — TIMESTAMP
Files
- file_id — UUID
- case_id — UUID — Foreign key → Cases.case_id
- wsi_path — VARCHAR(500) — NOT NULL
- vector_path — VARCHAR(500)
- uploaded_at — TIMESTAMP
Patients
- patient_id — UUID
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- created_at — TIMESTAMP
Users
- user_id — UUID
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- employee_id — VARCHAR(50) — NOT NULL
- license_number — VARCHAR(50)
- created_at — TIMESTAMP