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