final
Tables (10)
ADMIN
- user_id — BIGINT
- department — VARCHAR(100)
AI_PRE_DIAGNOSIS
- pre_diagnosis_id — BIGINT
- user_id — BIGINT — NOT NULL
- input_symptoms — TEXT — NOT NULL
- priority_diseases — TEXT
- reasoning — TEXT
- recommended_hospital_type — VARCHAR(100)
- created_at — TIMESTAMP
APPOINTMENT
- appointment_id — BIGINT
- user_id — BIGINT — NOT NULL
- hospital_id — BIGINT
- appointment_time — TIMESTAMP — NOT NULL
- appointment_type — VARCHAR(50)
- status — VARCHAR(50)
- notes — TEXT
DOCTOR
- user_id — BIGINT
- hospital_id — BIGINT
- specialty — VARCHAR(100)
- license_number — VARCHAR(100)
HOSPITAL
- hospital_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- type — VARCHAR(100)
- address — VARCHAR(255) — NOT NULL
- latitude — VARCHAR(50)
- longitude — VARCHAR(50)
- phone — VARCHAR(50)
- specialties — TEXT
IOT_DATA
- data_id — BIGINT
- user_id — BIGINT — NOT NULL
- device_type — VARCHAR(100) — NOT NULL
- value — VARCHAR(255) — NOT NULL
- measured_at — TIMESTAMP — NOT NULL
- encrypted_data — TEXT
PATIENT
- user_id — BIGINT
- dob — DATE
- gender — VARCHAR(10)
- address — VARCHAR(255)
- medical_history — TEXT
- lifestyle_habits — TEXT
PATIENT_SCHEDULE
- schedule_id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- event_time — TIMESTAMP — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- related_id — BIGINT
USERS
- user_id — BIGINT
- login_id — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(50) — NOT NULL
- email — VARCHAR(150)
- user_type — VARCHAR(20) — NOT NULL
- use_voice_interface — BOOLEAN
- language_preference — VARCHAR(10)
- created_at — TIMESTAMP
VOICE_CHAT_LOG
- log_id — BIGINT
- user_id — BIGINT — NOT NULL
- transcribed_text — TEXT
- intent — VARCHAR(255)
- response_text — TEXT
- created_at — TIMESTAMP