timeout
Tables (15)
Bookmark
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- post_id — INT — Foreign key → Post.id — NOT NULL
- created_at — DATETIME — NOT NULL
Comment
- id — INT — Primary key — NOT NULL
- post_id — INT — Foreign key → Post.id — NOT NULL
- author_id — INT — Foreign key → User.id — NOT NULL
- parent_id — INT — Foreign key → Comment.id
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Conversation
- id — INT — Primary key — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
ConversationParticipant
- id — INT — Primary key — NOT NULL
- conversation_id — INT — Foreign key → Conversation.id — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
Event
- id — INT — Primary key — NOT NULL
- creator_id — INT — Foreign key → User.id
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- event_type — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- recurrence — VARCHAR(10) — NOT NULL
- allow_conflict — BOOLEAN — NOT NULL
- visibility — VARCHAR(10) — NOT NULL
- start_datetime — DATETIME — NOT NULL
- end_datetime — DATETIME — NOT NULL
- location — VARCHAR(200)
- is_all_day — BOOLEAN — NOT NULL
- is_global — BOOLEAN — NOT NULL
- is_completed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
FocusSession
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME — NOT NULL
- duration_seconds — INT — NOT NULL
FollowRequest
- id — INT — Primary key — NOT NULL
- from_user_id — INT — Foreign key → User.id — NOT NULL
- to_user_id — INT — Foreign key → User.id — NOT NULL
- created_at — DATETIME — NOT NULL
Like
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- post_id — INT — Foreign key → Post.id — NOT NULL
- created_at — DATETIME — NOT NULL
Message
- id — INT — Primary key — NOT NULL
- conversation_id — INT — Foreign key → Conversation.id — NOT NULL
- sender_id — INT — Foreign key → User.id — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
Note
- id — INT — Primary key — NOT NULL
- owner_id — INT — Foreign key → User.id — NOT NULL
- event_id — INT — Foreign key → Event.id
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- category — VARCHAR(20) — NOT NULL
- page_mode — VARCHAR(10) — NOT NULL
- is_pinned — BOOLEAN — NOT NULL
- due_date — DATETIME
- time_spent_minutes — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
Notification
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- conversation_id — INT — Foreign key → Conversation.id
- post_id — INT — Foreign key → Post.id
- deadline_id — INT — Foreign key → Event.id
- title — VARCHAR(255) — NOT NULL
- message — TEXT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- is_dismissed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
Post
- id — INT — Primary key — NOT NULL
- author_id — INT — Foreign key → User.id — NOT NULL
- event_id — INT — Foreign key → Event.id
- content — TEXT — NOT NULL
- privacy — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
StudyLog
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → User.id — NOT NULL
- date — DATE — NOT NULL
- pomodoros — SMALLINT — NOT NULL
- notes_created — SMALLINT — NOT NULL
- notes_edited — SMALLINT — NOT NULL
- focus_minutes — SMALLINT — NOT NULL
User
- id — INT — Primary key — NOT NULL
- username — VARCHAR(150) — NOT NULL
- password — VARCHAR(128) — NOT NULL
- email — VARCHAR(254) — NOT NULL
- first_name — VARCHAR(150)
- last_name — VARCHAR(150)
- middle_name — VARCHAR(50)
- bio — TEXT
- university — VARCHAR(150)
- year_of_study — INT
- profile_picture — VARCHAR(255)
- academic_interests — VARCHAR(300)
- status — VARCHAR(10) — NOT NULL
- focus_started_at — DATETIME
- privacy_private — BOOLEAN — NOT NULL
- management_style — VARCHAR(10) — NOT NULL
- theme — VARCHAR(10) — NOT NULL
- colorblind_mode — VARCHAR(15) — NOT NULL
- font_size — SMALLINT — NOT NULL
- notification_sounds — BOOLEAN — NOT NULL
- pomo_work_minutes — SMALLINT — NOT NULL
- pomo_short_break — SMALLINT — NOT NULL
- pomo_long_break — SMALLINT — NOT NULL
- default_note_category — VARCHAR(20)
- daily_study_reminder — TIME
- daily_pomo_goal — SMALLINT — NOT NULL
- daily_notes_goal — SMALLINT — NOT NULL
- daily_focus_goal — SMALLINT — NOT NULL
- auto_online — BOOLEAN — NOT NULL
- xp — INT — NOT NULL
- note_streak — INT — NOT NULL
- longest_note_streak — INT — NOT NULL
- last_note_date — DATE
UserFollowing
- id — INT — Primary key — NOT NULL
- from_user_id — INT — Foreign key → User.id — NOT NULL
- to_user_id — INT — Foreign key → User.id — NOT NULL