UHHU

Tables (26)

admin

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • department — VARCHAR(50)

adviser

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • hospital_id — BIGINT — Foreign key → hospital.hospital_id
  • specialty — VARCHAR(100)
  • license_number — VARCHAR(50) — NOT NULL

ai_pre_diagnosis

  • pre_diagnosis_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • input_symptoms — TEXT
  • priority_diseases — TEXT
  • reasoning — TEXT
  • recommended_hospital_type — VARCHAR(50)
  • created_at — TIMESTAMP

appointment

  • appointment_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • hospital_id — BIGINT — Foreign key → hospital.hospital_id
  • appointment_time — TIMESTAMP — NOT NULL
  • appointment_type — VARCHAR(50)
  • status — VARCHAR(20)
  • notes — TEXT

community_comment

  • comment_id — BIGSERIAL — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_post.post_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → community_comment.comment_id
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMP

community_post

  • post_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • disease_category — VARCHAR(100)
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_anonymous — BOOLEAN
  • post_status — VARCHAR(20)
  • created_at — TIMESTAMP
  • view_count — INT
  • like_count — INT

diagnosis_image

  • image_id — BIGSERIAL — Primary key — NOT NULL
  • pre_diagnosis_id — BIGINT — Foreign key → ai_pre_diagnosis.pre_diagnosis_id — NOT NULL
  • image_url — TEXT
  • image_type — VARCHAR(50)
  • uploaded_at — TIMESTAMP
  • ai_analysis_result — TEXT

emergency_event

  • event_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • event_type — VARCHAR(50)
  • latitude — VARCHAR(50)
  • longitude — VARCHAR(50)
  • vital_log — TEXT
  • detected_at — TIMESTAMP
  • alert_sent — BOOLEAN

emr

  • emr_id — BIGSERIAL — Primary key — NOT NULL
  • consultation_id — BIGINT — Foreign key → video_consultation.consultation_id — NOT NULL
  • adviser_user_id — BIGINT — Foreign key → adviser.user_id — NOT NULL
  • patient_user_id — BIGINT — Foreign key → patient.user_id — NOT NULL
  • patient_statement — TEXT
  • test_results — TEXT
  • prescription_details — TEXT
  • ai_generated_draft — TEXT
  • final_record — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

health_survey

  • survey_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • survey_type — VARCHAR(50)
  • questions — TEXT
  • created_at — TIMESTAMP

hospital

  • hospital_id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(50)
  • address — TEXT
  • latitude — VARCHAR(50)
  • longitude — VARCHAR(50)
  • phone — VARCHAR(20)
  • specialties — TEXT
  • emergency_bed_count — INT
  • emergency_wait_status — VARCHAR(50)

hospital_recommendation

  • recommendation_id — BIGSERIAL — Primary key — NOT NULL
  • pre_diagnosis_id — BIGINT — Foreign key → ai_pre_diagnosis.pre_diagnosis_id — NOT NULL
  • hospital_id — BIGINT — Foreign key → hospital.hospital_id
  • recommended_department — VARCHAR(100)
  • match_score — NUMERIC(5,4)
  • reasoning — TEXT
  • distance_km — NUMERIC(10,2)
  • created_at — TIMESTAMP

iot_data

  • data_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • device_type — VARCHAR(50)
  • vital_type — VARCHAR(50)
  • value — NUMERIC(10,2)
  • is_abnormal — BOOLEAN
  • measured_at — TIMESTAMP
  • encrypted_data — TEXT

medical_statistics

  • stat_id — BIGSERIAL — Primary key — NOT NULL
  • disease_name — VARCHAR(255)
  • age_group — VARCHAR(50)
  • gender — VARCHAR(10)
  • incidence_rate — NUMERIC(10,4)
  • mortality_rate — NUMERIC(10,4)
  • year — INT
  • data_source — VARCHAR(100)

medication

  • medication_id — BIGSERIAL — Primary key — NOT NULL
  • prescription_id — BIGINT — Foreign key → prescription.prescription_id — NOT NULL
  • medication_name — VARCHAR(255) — NOT NULL
  • dosage — VARCHAR(100)
  • frequency — VARCHAR(100)
  • precautions — TEXT
  • intake_time — TIME

notification

  • notification_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(50)
  • title — VARCHAR(255)
  • message — TEXT
  • is_read — BOOLEAN
  • related_id — BIGINT
  • scheduled_time — TIMESTAMP
  • created_at — TIMESTAMP

patient

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • dob — DATE
  • gender — VARCHAR(10)
  • address — TEXT
  • medical_history — TEXT
  • lifestyle_habits — TEXT

patient_schedule

  • schedule_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255)
  • event_time — TIMESTAMP — NOT NULL
  • event_type — VARCHAR(50)
  • related_id — BIGINT

post_report

  • report_id — BIGSERIAL — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → community_post.post_id — NOT NULL
  • reporter_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • reason — TEXT
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • processed_at — TIMESTAMP

prescription

  • prescription_id — BIGSERIAL — Primary key — NOT NULL
  • consultation_id — BIGINT — Foreign key → video_consultation.consultation_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • diagnosis — TEXT
  • prescription_details — TEXT
  • issued_date — TIMESTAMP

search_log

  • log_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id
  • search_keyword — VARCHAR(255) — NOT NULL
  • search_type — VARCHAR(50)
  • searched_at — TIMESTAMP

survey_response

  • response_id — BIGSERIAL — Primary key — NOT NULL
  • survey_id — BIGINT — Foreign key → health_survey.survey_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • answers — TEXT
  • submitted_at — TIMESTAMP

user_sanction

  • sanction_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • admin_user_id — BIGINT — Foreign key → admin.user_id — NOT NULL
  • sanction_type — VARCHAR(20) — NOT NULL
  • reason — TEXT
  • start_date — TIMESTAMP
  • end_date — TIMESTAMP

users

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • login_id — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • email — VARCHAR(100) — NOT NULL
  • user_type — VARCHAR(20) — NOT NULL
  • account_status — VARCHAR(20)
  • use_voice_interface — BOOLEAN
  • language_preference — VARCHAR(10)
  • created_at — TIMESTAMP

video_consultation

  • consultation_id — BIGSERIAL — Primary key — NOT NULL
  • appointment_id — BIGINT — Foreign key → appointment.appointment_id — NOT NULL
  • adviser_user_id — BIGINT — Foreign key → adviser.user_id — NOT NULL
  • patient_user_id — BIGINT — Foreign key → patient.user_id — NOT NULL
  • session_start_time — TIMESTAMP
  • session_end_time — TIMESTAMP
  • session_url — TEXT
  • recording_url — TEXT
  • status — VARCHAR(20)

voice_chat_log

  • log_id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • transcribed_text — TEXT
  • intent — VARCHAR(100)
  • response_text — TEXT
  • created_at — TIMESTAMP