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)