PLOBI

Tables (42)

attempt_recognition_token

  • token_id — BIGSERIAL — Primary key — NOT NULL
  • attempt_id — BIGINT — Foreign key → problem_attempt.attempt_id — NOT NULL
  • token_text — VARCHAR(50) — NOT NULL
  • confidence — NUMERIC(5,4)
  • start_ms — INTEGER
  • end_ms — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

attempt_stroke

  • stroke_id — BIGSERIAL — Primary key — NOT NULL
  • attempt_id — BIGINT — Foreign key → problem_attempt.attempt_id — NOT NULL
  • stroke_order — SMALLINT — NOT NULL
  • path_data — JSONB — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

audit_log

  • log_id — BIGSERIAL — Primary key — NOT NULL
  • table_name — VARCHAR(63) — NOT NULL
  • record_id — BIGINT — NOT NULL
  • action_type — VARCHAR(10) — NOT NULL
  • changed_columns — JSONB
  • changed_by — BIGINT — Foreign key → user_account.user_id
  • changed_at — TIMESTAMPTZ — NOT NULL

badge

  • badge_id — BIGSERIAL — Primary key — NOT NULL
  • badge_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • icon_url — VARCHAR(500)
  • condition_type — VARCHAR(30) — NOT NULL
  • condition_value — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

code

  • code_id — BIGSERIAL — Primary key — NOT NULL
  • group_code — VARCHAR(40) — NOT NULL
  • code — VARCHAR(40) — NOT NULL
  • code_name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(300)
  • sort_order — SMALLINT — NOT NULL
  • is_active — BOOLEAN — NOT NULL

curriculum_day

  • curriculum_day_id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • day_no — INTEGER — NOT NULL
  • scheduled_date — DATE
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

daily_assignment

  • assignment_id — BIGSERIAL — Primary key — NOT NULL
  • curriculum_day_id — BIGINT — Foreign key → curriculum_day.curriculum_day_id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.subject_id — NOT NULL
  • story_id — BIGINT — Foreign key → story.story_id
  • status — VARCHAR(20) — NOT NULL
  • is_locked — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

daily_study_stat

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.subject_id
  • stat_date — DATE — NOT NULL
  • is_attended — BOOLEAN — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • session_cnt — SMALLINT — NOT NULL
  • problem_cnt — INTEGER — NOT NULL
  • correct_cnt — INTEGER — NOT NULL
  • total_score — INTEGER — NOT NULL
  • accuracy_rate — NUMERIC(5,2)
  • elapsed_sec — INTEGER — NOT NULL
  • effective_sec — INTEGER — NOT NULL
  • first_session_at — TIMESTAMPTZ
  • last_session_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

device_push_token

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • device_type — VARCHAR(20) — NOT NULL
  • push_token — VARCHAR(500) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

guardian_link

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • guardian_id — BIGINT — Foreign key → guardian_profile.guardian_id — NOT NULL
  • relation_type — VARCHAR(20)
  • is_primary — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

guardian_profile

  • guardian_id — BIGINT — Foreign key → user_account.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • phone_url — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL

interest_tag

  • tag_id — BIGSERIAL — Primary key — NOT NULL
  • tag_name — VARCHAR(50) — NOT NULL
  • category — VARCHAR(30)
  • is_active — BOOLEAN — NOT NULL

level_policy

  • policy_id — BIGSERIAL — Primary key — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.subject_id — NOT NULL
  • level_no — SMALLINT — NOT NULL
  • level_name — VARCHAR(30) — NOT NULL
  • description — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

mission

  • mission_id — BIGSERIAL — Primary key — NOT NULL
  • mission_type — VARCHAR(20) — NOT NULL
  • description — VARCHAR(300) — NOT NULL
  • condition_code — VARCHAR(40) — NOT NULL
  • condition_value — INTEGER — NOT NULL
  • reward_type — VARCHAR(20) — NOT NULL
  • reward_value — INTEGER — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

notification

  • notification_id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • body — VARCHAR(1000)
  • link_url — VARCHAR(500)
  • is_read — BOOLEAN — NOT NULL
  • read_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

organization

  • org_id — BIGSERIAL — Primary key — NOT NULL
  • org_name — VARCHAR(100) — NOT NULL
  • org_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

point_transaction

  • tx_id — BIGSERIAL — Primary key — NOT NULL
  • wallet_id — BIGINT — Foreign key → point_wallet.wallet_id — NOT NULL
  • tx_type — VARCHAR(20) — NOT NULL
  • amount — INTEGER — NOT NULL
  • balance_after — INTEGER — NOT NULL
  • ref_type — VARCHAR(30)
  • ref_id — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL

point_wallet

  • wallet_id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • current_point — INTEGER — NOT NULL
  • total_earned — INTEGER — NOT NULL
  • total_spent — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

problem

  • problem_id — BIGSERIAL — Primary key — NOT NULL
  • problem_set_id — BIGINT — Foreign key → problem_set.problem_set_id — NOT NULL
  • seq — SMALLINT — NOT NULL
  • question_text — TEXT
  • answer_text — TEXT
  • answer_meta — JSONB
  • guide_meta — JSONB
  • max_score — SMALLINT — NOT NULL
  • illust_asset_id — VARCHAR(300)
  • created_at — TIMESTAMPTZ — NOT NULL

problem_attempt

  • attempt_id — BIGSERIAL — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → study_session.session_id — NOT NULL
  • problem_id — BIGINT — Foreign key → problem.problem_id — NOT NULL
  • try_no — SMALLINT — NOT NULL
  • is_review — BOOLEAN — NOT NULL
  • recognized_text — TEXT
  • auto_score — SMALLINT
  • final_score — SMALLINT
  • max_score — SMALLINT — NOT NULL
  • is_correct — BOOLEAN
  • solve_time_sec — INTEGER — NOT NULL
  • media_asset_id — VARCHAR(300)
  • submitted_at — TIMESTAMPTZ — NOT NULL

problem_set

  • problem_set_id — BIGSERIAL — Primary key — NOT NULL
  • story_id — BIGINT — Foreign key → story.story_id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.subject_id — NOT NULL
  • problem_type — VARCHAR(40) — NOT NULL
  • tower_extent — SMALLINT
  • total_problem_cnt — SMALLINT — NOT NULL
  • max_score — SMALLINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

score_revision

  • revision_id — BIGSERIAL — Primary key — NOT NULL
  • attempt_id — BIGINT — Foreign key → problem_attempt.attempt_id — NOT NULL
  • teacher_id — BIGINT — Foreign key → teacher_profile.teacher_id — NOT NULL
  • changed_score — SMALLINT — NOT NULL
  • reason — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

session_pause

  • pause_id — BIGSERIAL — Primary key — NOT NULL
  • session_id — BIGINT — Foreign key → study_session.session_id — NOT NULL
  • paused_at — TIMESTAMPTZ — NOT NULL
  • resumed_at — TIMESTAMPTZ
  • reason — VARCHAR(30)

shop_item

  • item_id — BIGSERIAL — Primary key — NOT NULL
  • item_type — VARCHAR(20) — NOT NULL
  • item_name — VARCHAR(100) — NOT NULL
  • price — INTEGER — NOT NULL
  • icon_url — VARCHAR(500)
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

story

  • story_id — BIGSERIAL — Primary key — NOT NULL
  • template_id — BIGINT — Foreign key → story_template.template_id
  • student_id — BIGINT — Foreign key → student_profile.student_id
  • title — VARCHAR(200) — NOT NULL
  • cover_asset_id — VARCHAR(300)
  • level_no — SMALLINT — NOT NULL
  • total_sentence_cnt — SMALLINT — NOT NULL
  • read_complete_cnt — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

story_sentence

  • sentence_id — BIGSERIAL — Primary key — NOT NULL
  • story_id — BIGINT — Foreign key → story.story_id — NOT NULL
  • seq — SMALLINT — NOT NULL
  • sentence_text — TEXT — NOT NULL
  • tts_url — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

story_template

  • template_id — BIGSERIAL — Primary key — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • level_no — SMALLINT — NOT NULL
  • interest_tags — JSONB
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

student_badge

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • badge_id — BIGINT — Foreign key → badge.badge_id — NOT NULL
  • earned_at — TIMESTAMPTZ — NOT NULL

student_interest

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • tag_id — BIGINT — Foreign key → interest_tag.tag_id — NOT NULL
  • selected_at — TIMESTAMPTZ — NOT NULL

student_item

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • item_id — BIGINT — Foreign key → shop_item.item_id — NOT NULL
  • acquired_at — TIMESTAMPTZ — NOT NULL
  • acquired_by — VARCHAR(20) — NOT NULL
  • paid_price — INTEGER — NOT NULL
  • is_equipped — BOOLEAN — NOT NULL
  • equipped_slot — VARCHAR(20)
  • equipped_at — TIMESTAMPTZ

student_learning_config

  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • daily_goal_minutes — SMALLINT — NOT NULL
  • use_name_in_story — BOOLEAN — NOT NULL
  • notification_enabled — BOOLEAN — NOT NULL
  • push_enabled — BOOLEAN — NOT NULL
  • study_alarm_time — TIME
  • quiet_start — TIME
  • quiet_end — TIME
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

student_login_qr

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • qr_code — VARCHAR(255) — NOT NULL
  • expires_at — TIMESTAMPTZ
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

student_mission

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • mission_id — BIGINT — Foreign key → mission.mission_id — NOT NULL
  • mission_date — DATE — NOT NULL
  • progress — INTEGER — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • completed_at — TIMESTAMPTZ

student_profile

  • student_id — BIGINT — Foreign key → user_account.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • photo_url — VARCHAR(500)
  • use_name_in_story — BOOLEAN — NOT NULL
  • anonymized_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

student_subject_level

  • id — BIGSERIAL — Primary key — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.subject_id — NOT NULL
  • level_no — SMALLINT — NOT NULL
  • source — VARCHAR(20) — NOT NULL
  • changed_by — BIGINT — Foreign key → user_account.user_id
  • valid_from — TIMESTAMPTZ — NOT NULL
  • valid_to — TIMESTAMPTZ
  • is_current — BOOLEAN — NOT NULL
  • reason — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

study_session

  • session_id — BIGSERIAL — Primary key — NOT NULL
  • assignment_id — BIGINT — Foreign key → daily_assignment.assignment_id — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • subject_id — BIGINT — Foreign key → subject.subject_id — NOT NULL
  • attempt_round — SMALLINT — NOT NULL
  • is_first_completion — BOOLEAN — NOT NULL
  • started_at — TIMESTAMPTZ — NOT NULL
  • ended_at — TIMESTAMPTZ
  • elapsed_sec — INTEGER — NOT NULL
  • effective_sec — INTEGER — NOT NULL
  • total_score — SMALLINT
  • max_score — SMALLINT
  • accuracy_rate — NUMERIC(5,2)
  • error_rate — NUMERIC(5,2)
  • status — VARCHAR(20) — NOT NULL
  • review_status — VARCHAR(20) — NOT NULL
  • study_date — DATE — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

subject

  • subject_id — BIGSERIAL — Primary key — NOT NULL
  • code — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

teacher_profile

  • teacher_id — BIGINT — Foreign key → user_account.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE
  • photo_url — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL

teacher_student

  • id — BIGSERIAL — Primary key — NOT NULL
  • teacher_id — BIGINT — Foreign key → teacher_profile.teacher_id — NOT NULL
  • student_id — BIGINT — Foreign key → student_profile.student_id — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • assigned_from — DATE — NOT NULL
  • assigned_to — DATE

terms

  • terms_id — BIGSERIAL — Primary key — NOT NULL
  • terms_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • version — VARCHAR(20) — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

terms_agreement

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → user_account.user_id — NOT NULL
  • terms_id — BIGINT — Foreign key → terms.terms_id — NOT NULL
  • agreed_at — TIMESTAMPTZ — NOT NULL
  • version — VARCHAR(20) — NOT NULL

user_account

  • user_id — BIGSERIAL — Primary key — NOT NULL
  • org_id — BIGINT — Foreign key → organization.org_id
  • role — VARCHAR(20) — NOT NULL
  • login_id — VARCHAR(100)
  • password_hash — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ