Still Writer
Tables (17)
auth_identities
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — ENUM('LOCAL','GOOGLE') — NOT NULL
- provider_user_id — VARCHAR(191) — NOT NULL
- provider_email — VARCHAR(191)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
daily_writing_stats
- stat_date — DATE — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- chars_written — INT — NOT NULL
- documents_created — INT — NOT NULL
- documents_updated — INT — NOT NULL
- writing_seconds — INT — NOT NULL
- goal_char_count — INT
- goal_achieved — TINYINT(1) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
document_materials
- document_id — BIGINT — Primary key — NOT NULL
- material_id — BIGINT — Primary key — NOT NULL
- created_at — DATETIME(6) — NOT NULL
document_shares
- id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → documents.id — NOT NULL
- created_by — BIGINT — Foreign key → users.id — NOT NULL
- share_token_hash — CHAR(64) — NOT NULL
- permission — ENUM('READ') — NOT NULL
- expires_at — DATETIME(6)
- revoked_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
document_tags
- document_id — BIGINT — Foreign key → documents.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
document_versions
- id — BIGINT — Primary key — NOT NULL
- document_id — BIGINT — Foreign key → documents.id — NOT NULL
- version_no — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content_json — JSON — NOT NULL
- plain_text — LONGTEXT — NOT NULL
- char_count — INT — NOT NULL
- save_type — ENUM('AUTO','MANUAL') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
documents
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- folder_id — BIGINT — Foreign key → folders.id
- type — ENUM('NOVEL','DIARY','MEMO','GENERAL') — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content_json — JSON — NOT NULL
- plain_text — LONGTEXT — NOT NULL
- char_count — INT — NOT NULL
- word_count — INT — NOT NULL
- sentence_count — INT — NOT NULL
- target_char_count — INT
- diary_date — DATE
- status — ENUM('DRAFT','IN_PROGRESS','COMPLETED') — NOT NULL
- completed_at — DATETIME(6)
- last_opened_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- purge_after — DATETIME(6)
external_storage_accounts
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — ENUM('GOOGLE_DRIVE') — NOT NULL
- provider_account_id — VARCHAR(191) — NOT NULL
- account_email — VARCHAR(191)
- access_token_encrypted — VARBINARY(4096)
- refresh_token_encrypted — VARBINARY(4096)
- token_expires_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- disconnected_at — DATETIME(6)
favorites
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- document_id — BIGINT — Foreign key → documents.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
folders
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- parent_id — BIGINT — Foreign key → folders.id
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- category — ENUM('NOVEL','DIARY','MEMO','GENERAL') — NOT NULL
- color — CHAR(7)
- target_char_count — INT
- diary_auto_date — TINYINT(1) — NOT NULL
- sort_order — INT — NOT NULL
- last_used_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- purge_after — DATETIME(6)
material_tags
- material_id — BIGINT — Foreign key → materials.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
materials
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- source_document_id — BIGINT — Foreign key → documents.id
- type — ENUM('DOCUMENT','FILE','IMAGE') — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(1000)
- content_snapshot — JSON
- original_file_name — VARCHAR(255)
- storage_provider — ENUM('APP_STORAGE','GOOGLE_DRIVE','S3')
- storage_key — VARCHAR(1024)
- mime_type — VARCHAR(191)
- file_size — BIGINT
- checksum_sha256 — CHAR(64)
- metadata — JSON
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
password_reset_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- token_hash — CHAR(64) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- used_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
tags
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(50) — NOT NULL
- color — CHAR(7)
- created_at — DATETIME(6) — NOT NULL
user_sessions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- refresh_token_hash — CHAR(64) — NOT NULL
- device_name — VARCHAR(100)
- ip_address — VARBINARY(16)
- user_agent — VARCHAR(500)
- expires_at — DATETIME(6) — NOT NULL
- revoked_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
user_settings
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- theme — ENUM('SYSTEM','LIGHT','DARK') — NOT NULL
- font_family — VARCHAR(100) — NOT NULL
- font_size — TINYINT — NOT NULL
- auto_indent — TINYINT(1) — NOT NULL
- show_word_count — TINYINT(1) — NOT NULL
- export_format — ENUM('TXT','DOCX','PDF','MARKDOWN') — NOT NULL
- locale — VARCHAR(10) — NOT NULL
- timezone — VARCHAR(50) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(191) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(2048)
- email_verified_at — DATETIME(6)
- status — ENUM('ACTIVE','SUSPENDED','WITHDRAWN') — NOT NULL
- last_login_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- withdrawn_at — DATETIME(6)