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