Readle
Tables (12)
content
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- input_type — VARCHAR(10) — NOT NULL
- original_url — VARCHAR(500)
- raw_text — LONGTEXT
- extracted_text — LONGTEXT
- crawl_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
content_tag
- id — BIGINT — Primary key — NOT NULL
- content_id — BIGINT — Foreign key → content.id — NOT NULL
- tag_id — BIGINT — Foreign key → tag.id — NOT NULL
- created_at — DATETIME — NOT NULL
content_validation
- id — BIGINT — Primary key — NOT NULL
- content_id — BIGINT — Foreign key → content.id — NOT NULL
- validation_method — VARCHAR(20) — NOT NULL
- status — VARCHAR(10) — NOT NULL
- validation_score — DECIMAL(5,2)
- reject_reason_code — VARCHAR(30)
- evidence_snippets — TEXT
- error_code — VARCHAR(30)
- created_at — DATETIME — NOT NULL
- validated_at — DATETIME
member
- id — BIGINT — Primary key — NOT NULL
- uuid — CHAR(36) — NOT NULL
- oauth_provider — VARCHAR(20) — NOT NULL
- oauth_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- nickname — VARCHAR(30) — NOT NULL
- profile_image_url — VARCHAR(300)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- last_login_at — DATETIME
member_refresh_token
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- revoked_at — DATETIME
quiz_answer
- id — BIGINT — Primary key — NOT NULL
- attempt_id — BIGINT — Foreign key → quiz_attempt.id — NOT NULL
- question_id — BIGINT — Foreign key → quiz_question.id — NOT NULL
- submitted_answer_text — TEXT
- submitted_choice_id — BIGINT — Foreign key → quiz_choice.id
- is_correct — BOOLEAN — NOT NULL
- ai_feedback — TEXT
- evaluated_at — DATETIME — NOT NULL
quiz_attempt
- id — BIGINT — Primary key — NOT NULL
- quiz_set_id — BIGINT — Foreign key → quiz_set.id — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME — NOT NULL
- submitted_at — DATETIME
quiz_choice
- id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → quiz_question.id — NOT NULL
- order_no — SMALLINT — NOT NULL
- choice_text — TEXT — NOT NULL
- is_correct — BOOLEAN — NOT NULL
quiz_question
- id — BIGINT — Primary key — NOT NULL
- quiz_set_id — BIGINT — Foreign key → quiz_set.id — NOT NULL
- question_type — VARCHAR(20) — NOT NULL
- order_no — SMALLINT — NOT NULL
- question_text — TEXT — NOT NULL
- code_snippet — TEXT
- correct_answer — TEXT
- explanation — TEXT
- source_excerpt — TEXT
quiz_result
- id — BIGINT — Primary key — NOT NULL
- attempt_id — BIGINT — Foreign key → quiz_attempt.id — NOT NULL
- accuracy_rate — DECIMAL(5,2) — NOT NULL
- correct_count — SMALLINT — NOT NULL
- total_count — SMALLINT — NOT NULL
- solve_duration_seconds — INT — NOT NULL
- completed_at — DATETIME — NOT NULL
quiz_set
- id — BIGINT — Primary key — NOT NULL
- content_id — BIGINT — Foreign key → content.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- question_count — SMALLINT
- created_at — DATETIME — NOT NULL
- completed_at — DATETIME
- is_bypassed — BOOLEAN — NOT NULL
- source_validation_id — BIGINT — Foreign key → content_validation.id
tag
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL