ㅁ

Tables (17)

admin

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

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
  • 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
  • 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

doctor

  • 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

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

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)
  • value — TEXT
  • 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)

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

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
  • 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
  • doctor_user_id — BIGINT — Foreign key → doctor.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