asd

Tables (15)

analysis_results

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • analysis_timestamp — timestamp — NOT NULL
  • gait_pattern — character
  • similarity_score — double
  • confidence_level — double
  • health_assessment — character
  • analysis_type — character
  • recommendations — ARRAY
  • risk_factors — ARRAY
  • pattern_description — text
  • characteristics — ARRAY
  • raw_data_reference — uuid
  • ai_model_version — character
  • created_at — timestamp

chat_history

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • message — text — NOT NULL
  • is_user — boolean — NOT NULL
  • timestamp — timestamp — NOT NULL
  • created_at — timestamp

embedding_data

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • timestamp — timestamp — NOT NULL
  • embedding_vector — ARRAY — NOT NULL
  • original_data_id — uuid
  • created_at — timestamp

emergency_events

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • event_type — character — NOT NULL
  • severity_level — character — NOT NULL
  • event_timestamp — timestamp — NOT NULL
  • location_info — jsonb
  • sensor_data — jsonb
  • response_status — character
  • response_time — timestamp
  • responder_info — jsonb
  • notes — text
  • created_at — timestamp

fall_data

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • timestamp — timestamp — NOT NULL
  • fall_detected — boolean — NOT NULL
  • confidence_score — double
  • sensor_data — jsonb
  • created_at — timestamp

gait_rag_data

  • id — uuid — Primary key — NOT NULL
  • pattern_name — character — NOT NULL
  • embedding_vector — ARRAY — NOT NULL
  • description — text
  • characteristics — ARRAY
  • severity_level — character
  • created_at — timestamp

imu_data

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • timestamp — timestamp — NOT NULL
  • acc_x — double — NOT NULL
  • acc_y — double — NOT NULL
  • acc_z — double — NOT NULL
  • gyr_x — double — NOT NULL
  • gyr_y — double — NOT NULL
  • gyr_z — double — NOT NULL
  • created_at — timestamp

langchain_analysis_sessions

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • session_start — timestamp
  • session_end — timestamp
  • analysis_count — integer
  • total_processing_time — double
  • session_status — character
  • created_at — timestamp

model_performance_logs

  • id — uuid — Primary key — NOT NULL
  • model_name — character — NOT NULL
  • model_version — character — NOT NULL
  • analysis_id — uuid
  • processing_time — double
  • accuracy_score — double
  • confidence_score — double
  • error_message — text
  • created_at — timestamp

notifications

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • notification_type — character
  • title — character — NOT NULL
  • message — text — NOT NULL
  • is_read — boolean
  • priority — character
  • created_at — timestamp
  • read_at — timestamp

user_feedback

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • analysis_id — uuid
  • feedback_type — character
  • rating — integer
  • comment — text — ex
  • created_at — timestamp

user_health_info

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • age — integer
  • gender — character
  • height — double
  • weight — double
  • bmi — double
  • activity_level — character
  • diseases — ARRAY
  • medications — ARRAY
  • medical_history — jsonb
  • emergency_contact — jsonb
  • created_at — timestamp
  • updated_at — timestamp

user_states

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • current_state — character — NOT NULL
  • confidence_score — double
  • last_activity — timestamp
  • location_info — jsonb
  • device_status — jsonb
  • created_at — timestamp
  • updated_at — timestamp

users

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • name — character — NOT NULL
  • email — character
  • created_at — timestamp
  • updated_at — timestamp

walking_sessions

  • id — uuid — Primary key — NOT NULL
  • user_id — character — NOT NULL
  • session_start — timestamp — NOT NULL
  • session_end — timestamp
  • duration_seconds — integer
  • step_count — integer
  • distance_meters — double
  • avg_speed — double
  • session_quality — character
  • notes — text
  • created_at — timestamp