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