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