onlyvibe

Tables (5)

ai_recommendations

  • recommendation_id — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • recommendation_type — ENUM('activity', 'food', 'transport', 'weather_action', 'productivity', 'health') — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • recommendation_time — DATETIME — NOT NULL
  • context_data — JSON
  • priority — ENUM('low', 'medium', 'high')
  • is_viewed — BOOLEAN
  • is_accepted — BOOLEAN
  • user_feedback — TEXT
  • created_at — TIMESTAMP

schedules

  • schedule_id — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • location_id — INT — Foreign key → user_locations.location_id
  • custom_location — VARCHAR(255)
  • start_time — DATETIME — NOT NULL
  • end_time — DATETIME — NOT NULL
  • reminder_minutes — INT
  • weather_sensitive — BOOLEAN
  • is_completed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_activity_logs

  • activity_id — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • activity_type — ENUM('location_change', 'schedule_complete', 'widget_interaction', 'app_open', 'recommendation_action') — NOT NULL
  • activity_data — JSON
  • latitude — DECIMAL(10, 8)
  • longitude — DECIMAL(11, 8)
  • weather_condition — VARCHAR(50)
  • temperature — DECIMAL(5, 2)
  • activity_timestamp — DATETIME — NOT NULL
  • created_at — TIMESTAMP

user_locations

  • location_id — INT
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • location_name — VARCHAR(100) — NOT NULL
  • location_type — ENUM('home', 'work', 'cafe', 'gym', 'custom') — NOT NULL
  • latitude — DECIMAL(10, 8) — NOT NULL
  • longitude — DECIMAL(11, 8) — NOT NULL
  • address — VARCHAR(255)
  • arrival_action — TEXT
  • visit_count — INT
  • last_visited — TIMESTAMP
  • created_at — TIMESTAMP

users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • home_latitude — DECIMAL(10, 8)
  • home_longitude — DECIMAL(11, 8)
  • work_latitude — DECIMAL(10, 8)
  • work_longitude — DECIMAL(11, 8)
  • preferred_weather_unit — ENUM('celsius', 'fahrenheit')
  • notification_enabled — BOOLEAN
  • created_at — TIMESTAMP
  • last_login — TIMESTAMP