Database Schema

Tables

Users

Id, FullName, Email, PasswordHash, Role (User|Admin), CreatedAt

UserPreferences

UserId, UserGroup, PreferredLocation,
NotifyEnabled, NotifyChannel (telegram|email|both),
TelegramChatId, NotifyEmail, NotifyThreshold (0-500),
LastAlertSentAt, UpdatedAt

UserActivitySchedules

UserId, Name, Icon, HourOfDay, Minute, DurationMinutes,
IsOutdoor, Intensity (low|moderate|high),
DaysOfWeek (comma-separated 1-7), IsActive, CreatedAt

ChatConversations

Id, UserId, Title, IsPinned, HasUnread,
MessageCount, LastMessageAt, CreatedAt

ChatMessages

Id, ConversationId, Role (user|assistant),
Content, UserGroup, CurrentAqi, CurrentPm25,
SourceUserMessageId, RegeneratedCount, CreatedAt

AlertLogs

Id, UserId, Aqi, Pm25, Risk, Message,
Channel, SentToEmail, SentToTelegramChatId,
IsRead, Success, CreatedAt