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