paper
Tables (6)
outline_sections
- id — INT
- outline_id — INT — Foreign key → outlines.id — NOT NULL
- section_id — VARCHAR(50) — NOT NULL
- section_title — VARCHAR(255) — NOT NULL
- level — INT — NOT NULL
- position — INT — NOT NULL
- created_at — DATETIME
outlines
- id — INT
- user_id — INT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- version — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
search_history
- id — INT
- user_id — INT — Foreign key → users.id
- query_text — VARCHAR(255)
- results_json — JSON
- created_at — DATETIME — NOT NULL
- PARTITION — p2024
- PARTITION — pmax
section_content
- id — INT
- outline_section_id — INT — Foreign key → outline_sections.id — NOT NULL
- version — INT — NOT NULL
- content — LONGTEXT — NOT NULL
- created_at — DATETIME
uploaded_pdfs
- id — INT
- user_id — INT — Foreign key → users.id — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- s3_key — VARCHAR(255) — NOT NULL
- file_size — BIGINT
- created_at — DATETIME
users
- id — INT
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME