jpstudy.org

Tables (32)

blueprint_detail

  • id — BIGSERIAL
  • exam_blueprint_id — BIGINT — Foreign key → exam_blueprint.id
  • category_id — BIGINT — Foreign key → question_category.id
  • question_count — INTEGER — NOT NULL
  • sequence — INTEGER — NOT NULL

choice

  • id — BIGSERIAL
  • question_id — BIGINT — Foreign key → question.id
  • choice_text — VARCHAR(255)
  • is_correct — BOOLEAN — NOT NULL

comment

  • id — BIGSERIAL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • content — TEXT — NOT NULL
  • post_id — BIGINT — Foreign key → post.id — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • comment_status — VARCHAR(255) — NOT NULL
  • ip_address — VARCHAR(50)

exam

  • id — BIGSERIAL
  • level_id — BIGINT
  • title — VARCHAR(255)
  • total_time_minutes — INTEGER — NOT NULL

exam_blueprint

  • id — BIGSERIAL
  • title — VARCHAR(255)
  • description — VARCHAR(255)
  • level_id — BIGINT — Foreign key → level.id
  • total_time_minutes — INTEGER — NOT NULL

exam_question

  • exam_id — BIGINT — Foreign key → exam.id — NOT NULL
  • question_id — BIGINT — Foreign key → question.id — NOT NULL
  • question_number — INTEGER — NOT NULL

filter_log

  • id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — NOT NULL
  • reason_type — VARCHAR(255) — NOT NULL
  • result_status — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

image

  • id — BIGSERIAL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • unique_file_name — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

inquiry

  • id — BIGSERIAL
  • member_id — BIGINT
  • title — VARCHAR(255)
  • content — TEXT
  • status — VARCHAR(255)
  • created_at — TIMESTAMP
  • answer_content — TEXT
  • answered_at — TIMESTAMP

inquiry_attachment

  • id — BIGSERIAL
  • inquiry_id — BIGINT — Foreign key → inquiry.id
  • storage_key — VARCHAR(255)
  • original_file_name — VARCHAR(255)
  • file_size — BIGINT — NOT NULL
  • content_type — VARCHAR(255)

kanji

  • id — BIGSERIAL
  • character — VARCHAR(10) — NOT NULL
  • meaning — VARCHAR(255) — NOT NULL
  • meaning_en — VARCHAR(255)
  • onyomi — VARCHAR(255) — NOT NULL
  • kunyomi — VARCHAR(255) — NOT NULL
  • stroke_count — INTEGER — NOT NULL
  • radical — VARCHAR(255)
  • level — INTEGER
  • deleted_at — TIMESTAMP

level

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

login_history

  • id — BIGSERIAL
  • member_id — BIGINT — NOT NULL
  • ip_address — VARCHAR(50)
  • user_agent — VARCHAR(255)
  • login_at — TIMESTAMP

meaning

  • id — BIGSERIAL
  • meaning_kr — TEXT — NOT NULL
  • meaning_en — TEXT
  • word_id — BIGINT — Foreign key → word.id — NOT NULL

member

  • id — BIGSERIAL
  • auth_type — VARCHAR(31) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • email — VARCHAR(255)
  • username — VARCHAR(255)
  • role — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • provider — VARCHAR(255)
  • provider_id — VARCHAR(255)
  • experience — BIGINT — NOT NULL
  • grade_id — BIGINT — Foreign key → member_grade.id
  • level — INTEGER — NOT NULL
  • deleted_at — TIMESTAMP
  • language_preference — VARCHAR(5) — NOT NULL
  • status — VARCHAR(255) — NOT NULL
  • ban_expires_at — TIMESTAMP

member_answer

  • id — BIGSERIAL
  • attempt_id — BIGINT — Foreign key → test_attempt.id
  • question_id — BIGINT — Foreign key → question.id
  • selected_choice_id — BIGINT — Foreign key → choice.id
  • is_correct — BOOLEAN — NOT NULL

member_grade

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • icon_url — VARCHAR(255)
  • grade_order — INTEGER — NOT NULL

member_kanji_progress

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • kanji_id — BIGINT — Foreign key → kanji.id — NOT NULL
  • last_reviewed_at — TIMESTAMP
  • next_review_at — TIMESTAMP
  • mastery_level — VARCHAR(255) — NOT NULL
  • stability — DOUBLE — NOT NULL
  • difficulty — DOUBLE — NOT NULL

member_title

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.id
  • title_id — BIGINT — Foreign key → title.id
  • acquired_at — TIMESTAMP

member_word_progress

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • word_id — BIGINT — Foreign key → word.id — NOT NULL
  • last_reviewed_at — TIMESTAMP
  • next_review_at — TIMESTAMP
  • mastery_level — VARCHAR(255) — NOT NULL
  • stability — DOUBLE — NOT NULL
  • difficulty — DOUBLE — NOT NULL

notification

  • id — BIGSERIAL
  • recipient_id — BIGINT — NOT NULL
  • content — VARCHAR(255) — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • related_url — VARCHAR(255)

post

  • id — BIGSERIAL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • member_id — BIGINT — Foreign key → member.id — NOT NULL
  • category_id — BIGINT
  • post_type — VARCHAR(255) — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • ip_address — VARCHAR(50)
  • post_status — VARCHAR(255) — NOT NULL
  • view_count — INTEGER — NOT NULL

question

  • id — BIGSERIAL
  • level_id — BIGINT — Foreign key → level.id
  • category_id — BIGINT — Foreign key → question_category.id
  • question_text — TEXT
  • passage — TEXT
  • audio_url — VARCHAR(255)
  • explanation — TEXT
  • isaigenerated — BOOLEAN — NOT NULL

question_category

  • id — BIGSERIAL
  • section_id — BIGINT — Foreign key → section.id
  • name — VARCHAR(255) — NOT NULL

review_interval

  • id — BIGSERIAL
  • review_level — INTEGER — NOT NULL
  • interval_days — INTEGER — NOT NULL

section

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

tag

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL

test_attempt

  • id — BIGSERIAL
  • member_id — BIGINT — Foreign key → member.id
  • exam_id — BIGINT — Foreign key → exam.id
  • start_time — TIMESTAMP
  • end_time — TIMESTAMP
  • score — INTEGER
  • status — VARCHAR(255)

title

  • id — BIGSERIAL
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(255)
  • icon_url — VARCHAR(255)

word

  • id — BIGSERIAL
  • term — VARCHAR(255) — NOT NULL
  • reading — VARCHAR(255) — NOT NULL
  • deleted_at — TIMESTAMP
  • level — INTEGER — NOT NULL

word_kanji

  • id — BIGSERIAL
  • word_id — BIGINT — Foreign key → word.id
  • kanji_id — BIGINT — Foreign key → kanji.id

word_tag

  • id — BIGSERIAL
  • word_id — BIGINT — Foreign key → word.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tag.id — NOT NULL