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