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