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