Gravit!

Tables (32)

answer

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (problem_id) — bigint — Foreign key → problem.Key — NOT NULL
  • Field (content) — varchar — NOT NULL
  • Field (explanation) — varchar — NOT NULL

audit_log

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (admin_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (action) — varchar — NOT NULL
  • Field (target_id) — varchar — NOT NULL
  • Field (before_value) — varchar
  • Field (after_value) — varchar
  • Field (created_at) — timestamp — NOT NULL

badge

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (category_id) — bigint — Foreign key → badge_category.Key — NOT NULL
  • Field (code) — varchar — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (description) — varchar — NOT NULL
  • Field (criteria_type) — varchar — NOT NULL — 5 types
  • Field (criteria_params) — jsonb — NOT NULL
  • Field (icon_id) — integer — NOT NULL
  • Field (display_order) — integer — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

badge_category

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (description) — varchar — NOT NULL
  • Field (display_order) — integer — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

bookmark

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (problem_id) — bigint — Foreign key → problem.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL

chapter

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (title) — varchar — NOT NULL — unique
  • Field (description) — varchar — NOT NULL

congratulation

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Key (actor_id) — bigint — Foreign key → users.Key — NOT NULL
  • Key (feed_id) — bigint — Foreign key → social_feed.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

daily_learning_record

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (solved_date) — date — NOT NULL
  • Field (solved_lesson_count) — integer — NOT NULL

fcm_token

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (device_id) — varchar — NOT NULL — unique
  • Field (token) — varchar — NOT NULL
  • Field (platform) — varchar — ANDRIOD, WEB
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

friends

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (follower_id) — bigint — Foreign key → users.Key — NOT NULL
  • Key (followee_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

inquiry

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (type) — varchar — NOT NULL — 4 types
  • Field (content) — text — NOT NULL
  • Field (status) — varchar — NOT NULL — PENDING, RESOLVED
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (deleted_at) — timestamp — NOT NULL — soft delete

inquiry_answer

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (inquiry_id) — bigint — Foreign key → inquiry.Key — NOT NULL — unique
  • Field (content) — text — NOT NULL
  • Field (admin_id) — bigint — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

league

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (min_lp) — integer — NOT NULL
  • Field (max_lp) — integer — NOT NULL
  • Field (sort_order) — integer — NOT NULL — unique

learning

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL — unique
  • Field (consecutive_solved_days) — integer — NOT NULL
  • Field (planet_conquest_rate) — integer — NOT NULL
  • Field (today_solved) — boolean — NOT NULL
  • Field (recent_solved_chapter_id) — bigint — NOT NULL
  • Field (version) — bigint — NOT NULL

lesson

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (unit_id) — bigint — Foreign key → unit.Key — NOT NULL
  • Field (title) — varchar — NOT NULL

lesson_submission

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (lesson_id) — bigint — Foreign key → lesson.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (learning_time) — integer — NOT NULL
  • Field (try_count) — integer — NOT NULL

mission

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (mission_type) — varchar — NOT NULL — 10 types
  • Field (is_completed) — boolean — NOT NULL
  • Field (progress_rate) — double — NOT NULL
  • Field (version) — bigint — NOT NULL

notice

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (content) — varchar — NOT NULL
  • Field (status) — varchar — NOT NULL — DRAFT, PUBLISHED, ARCHIVED
  • Field (pinned) — boolean — NOT NULL
  • Field (published_at) — timestamp
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

notification

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (uesr_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (type) — varchar — NOT NULL — 11 types
  • Field (message) — varchar — NOT NULL
  • Field (sub_text) — varchar
  • Field (target_id) — bigint
  • Field (is_read) — boolean — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

option

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (problem_id) — bigint — Foreign key → problem.Key — NOT NULL
  • Field (content) — varchar — NOT NULL
  • Field (explanation) — varchar — NOT NULL
  • Field (is_answer) — boolean — NOT NULL

problem

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (lesson_id) — bigint — Foreign key → lesson.Key — NOT NULL
  • Field (content) — text — NOT NULL
  • Field (instruction) — varchar — NOT NULL
  • Field (problem_type) — varchar — NOT NULL — SUBJECTIVE, OBJECTIVE

problem_submission

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (problem_id) — bigint — Foreign key → problem.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (is_correct) — boolean — NOT NULL

report (Untitled)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (problem_id) — bigint — Foreign key → problem.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (report_type) — varchar — NOT NULL — 4 types
  • Field (content) — text — NOT NULL
  • Field (is_resolved) — boolean — NOT NULL
  • Field (submitted_at) — timestamp — NOT NULL

season

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (seacon_key) — varchar — NOT NULL — unique
  • Field (starts_at) — timestamp — NOT NULL
  • Field (ends_at) — timestamp — NOT NULL
  • Field (status) — varchar — NOT NULL — PREP, ACTIVE, FINALIZING, CLOSED
  • Field (tz) — varchar — NOT NULL

social_feed

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (actor_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (event_type) — varchar — NOT NULL — 4 types
  • Field (event_value) — varchar — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

unit

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (chapter_id) — bigint — Foreign key → chapter.Key — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (description) — varchar — NOT NULL

user_badge

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (badge_id) — bigint — Foreign key → badge.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

user_feed

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (feed_id) — bigint — Foreign key → social_feed.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (is_hidden) — boolean — NOT NULL
  • Field (congratulated_at) — timestamp
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

user_league

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (league_id) — bigint — Foreign key → league.Key — NOT NULL
  • Key (season_id) — bigint — Foreign key → season.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (league_point) — integer — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

user_league_history

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (final_league_id) — bigint — Foreign key → league.Key — NOT NULL
  • Key (season_id) — bigint — Foreign key → season.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL
  • Field (final_lp) — integer — NOT NULL
  • Field (final_rank) — integer
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL

users

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (handle) — varchar — unique
  • Field (nickname) — varchar — NOT NULL
  • Field (provider_id) — varchar — NOT NULL — unique
  • Field (role) — varchar — NOT NULL — ADMIN, USER
  • Field (status) — varchar — NOT NULL — ACTIVE, SUSPENDED, DELETE
  • Field (level) — integer — NOT NULL
  • Field (xp) — integer — NOT NULL
  • Field (profile_img_number) — integer — NOT NULL
  • Field (is_onboarded) — boolean — NOT NULL
  • Field (created_at) — timestamp — NOT NULL
  • Field (updated_at) — timestamp — NOT NULL
  • Field (deleted_at) — timestamp

wrong_answer_note

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (problem_id) — bigint — Foreign key → problem.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → users.Key — NOT NULL