JLLM2

Tables (9)

analysis_results

  • analysis_id — BIGSERIAL
  • image_id — BIGINT — NOT NULL
  • solution_name — VARCHAR(255)
  • result_data — JSONB
  • status — VARCHAR(50)
  • created_at — TIMESTAMP
  • completed_at — TIMESTAMP

conversations

  • conversation_id — BIGSERIAL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255)
  • created_at — TIMESTAMP

hospitals

  • hospital_id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255)
  • created_at — TIMESTAMP

medical_images

  • image_id — BIGSERIAL
  • patient_id — BIGINT — NOT NULL
  • dicom_uid — VARCHAR(255) — NOT NULL
  • modality — VARCHAR(50)
  • s3_object_key — VARCHAR(500)
  • classification — VARCHAR(255)
  • upload_at — TIMESTAMP

patients

  • patient_id — BIGSERIAL
  • hospital_id — BIGINT — NOT NULL
  • date_of_birth — VARCHAR(20)
  • gender — VARCHAR(10)
  • vector_id — VARCHAR(255)
  • created_at — TIMESTAMP

queries

  • query_id — BIGSERIAL
  • conversation_id — BIGINT — NOT NULL
  • input_image_id — BIGINT
  • query_text — TEXT
  • agent_plan — JSONB
  • created_at — TIMESTAMP

response_evidences

  • response_id — BIGINT — Primary key — NOT NULL
  • evidence_id — BIGINT — Primary key — NOT NULL
  • evidence_type — VARCHAR(50) — Primary key — NOT NULL

responses

  • response_id — BIGSERIAL
  • query_id — BIGINT — NOT NULL
  • report_text — TEXT
  • visualization_data — JSONB
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

users

  • user_id — BIGSERIAL
  • hospital_id — BIGINT — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • full_name — VARCHAR(255)
  • role — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP
  • last_login_at — TIMESTAMP