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