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