Denvi

Tables (9)

ai_job

  • id — BIGINT — Primary key — NOT NULL
  • case_id — BIGINT — Foreign key → analysis_case.id — NOT NULL
  • requested_by — BIGINT — Foreign key → users.id — NOT NULL
  • task_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • error_message — TEXT
  • requested_at — DATETIME — NOT NULL
  • started_at — DATETIME
  • completed_at — DATETIME

ai_result

  • id — BIGINT — Primary key — NOT NULL
  • job_id — BIGINT — Foreign key → ai_job.id — NOT NULL
  • result_type — VARCHAR(50) — NOT NULL
  • result_data — TEXT
  • model_name — VARCHAR(100)
  • model_version — VARCHAR(50)
  • created_at — DATETIME — NOT NULL

analysis_case

  • id — BIGINT — Primary key — NOT NULL
  • patient_id — BIGINT — Foreign key → patient.id — NOT NULL
  • created_by — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

audit_log

  • id — BIGINT — Primary key — NOT NULL
  • clinic_id — BIGINT — Foreign key → clinic.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id
  • action — VARCHAR(50) — NOT NULL
  • resource_type — VARCHAR(50)
  • resource_id — BIGINT
  • created_at — DATETIME — NOT NULL

clinic

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

external_patient_mapping

  • id — BIGINT — Primary key — NOT NULL
  • patient_id — BIGINT — Foreign key → patient.id — NOT NULL
  • external_system — VARCHAR(50) — NOT NULL
  • external_patient_id — VARCHAR(100) — NOT NULL
  • created_at — DATETIME — NOT NULL

media_asset

  • id — BIGINT — Primary key — NOT NULL
  • job_id — BIGINT — Foreign key → ai_job.id — NOT NULL
  • asset_type — VARCHAR(30) — NOT NULL
  • storage_key — VARCHAR(500)
  • mime_type — VARCHAR(100)
  • file_size — BIGINT
  • expires_at — DATETIME
  • deleted_at — DATETIME
  • created_at — DATETIME — NOT NULL

patient

  • id — BIGINT — Primary key — NOT NULL
  • clinic_id — BIGINT — Foreign key → clinic.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • sex — VARCHAR(10)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • clinic_id — BIGINT — Foreign key → clinic.id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • license_number — VARCHAR(50) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL