시사독해
테이블 (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