시사독해

테이블 (7)

final_results

  • id — BIGINT
  • text_id — BIGINT — NOT NULL
  • final_text — TEXT
  • final_questions — LONGTEXT
  • text_attempt_count — INT
  • questions_attempt_count — INT
  • created_at — TIMESTAMP

question_reviews

  • id — BIGINT
  • question_id — BIGINT — NOT NULL
  • attempt — INT — NOT NULL
  • approved — BOOLEAN
  • feedback — TEXT
  • created_at — TIMESTAMP

questions

  • id — BIGINT
  • text_id — BIGINT — NOT NULL
  • generated_questions — LONGTEXT
  • current_step — DECIMAL(3,1)
  • retry_count — INT
  • max_iterations — INT
  • created_at — TIMESTAMP

text_reviews

  • id — BIGINT
  • text_id — BIGINT — NOT NULL
  • attempt — INT — NOT NULL
  • approved — BOOLEAN
  • feedback — TEXT
  • created_at — TIMESTAMP

text_source

  • id — INT
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • source — VARCHAR(255)
  • url — VARCHAR(2083)

texts

  • id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT
  • original_data — LONGTEXT — NOT NULL
  • generated_text — TEXT
  • current_step — DECIMAL(3,1)
  • retry_count — INT
  • max_iterations — INT
  • created_at — TIMESTAMP

users

  • id — BIGINT
  • username — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • created_at — TIMESTAMP