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