ERD-0806
Tables (33)
ai_operation_changes
- id — BIGINT — Primary key — NOT NULL
- operation_id — VARCHAR(255) — Foreign key → ai_operation_logs.operation_id — NOT NULL
- resource_type — VARCHAR(20) — NOT NULL
- resource_id — VARCHAR(255) — NOT NULL
- before_revision — BIGINT
- after_revision — BIGINT
- change_type — VARCHAR(20) — NOT NULL
- change_summary — LONGTEXT
- additions — INT
- deletions — INT
ai_operation_logs
- operation_id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- operation_type — VARCHAR(20) — NOT NULL
- target_document_id — VARCHAR(255) — Foreign key → documents.id
- status — VARCHAR(20) — NOT NULL
- summary — LONGTEXT
- changed_resource_count — INT — NOT NULL
- restored_from — VARCHAR(255) — Foreign key → ai_operation_logs.operation_id
- restore_manifest — JSON
- payload_hash — VARCHAR(64)
- created_at — DATETIME(6) — NOT NULL
- completed_at — DATETIME(6)
chat_message_references
- id — BIGINT — Primary key — NOT NULL
- chat_message_id — VARCHAR(255) — Foreign key → chat_messages.id — NOT NULL
- reference_type — VARCHAR(255) — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id
- rank — INT
- source_block_ids — LONGTEXT
- source_refs — LONGTEXT
- quote — LONGTEXT
chat_message_related_pages
- id — BIGINT — Primary key — NOT NULL
- chat_message_id — VARCHAR(255) — Foreign key → chat_messages.id — NOT NULL
- wiki_page_id — VARCHAR(255) — Foreign key → wiki_pages.id
- page_type — VARCHAR(255)
- title — VARCHAR(255)
- slug — VARCHAR(255)
- relevance_score — DOUBLE
- role — VARCHAR(255)
- depth — INT
- rank — INT
chat_messages
- id — VARCHAR(255) — Primary key — NOT NULL
- session_id — VARCHAR(255) — Foreign key → chat_sessions.id — NOT NULL
- pair_id — VARCHAR(255) — NOT NULL
- role — VARCHAR(255) — NOT NULL
- content — LONGTEXT — NOT NULL
- status — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- error_message — VARCHAR(255)
- wiki_page_id — VARCHAR(255) — Foreign key → wiki_pages.id
chat_partial_wiki
- id — VARCHAR(255) — Primary key — NOT NULL
- session_id — VARCHAR(255) — Foreign key → chat_sessions.id — NOT NULL
- pair_id — VARCHAR(255) — NOT NULL
- wiki_page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
chat_sessions
- id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- title — VARCHAR(255)
- context_summary — LONGTEXT
- context_summary_updated_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- last_message_at — DATETIME(6)
- wiki_page_id — VARCHAR(255) — Foreign key → wiki_pages.id
- wiki_export_document_id — VARCHAR(255) — Foreign key → documents.id
document_asset_orphans
- id — CHAR(36) — Primary key — NOT NULL
- asset_id — CHAR(36) — NOT NULL
- storage_key — VARCHAR(512) — NOT NULL
- failed_at — DATETIME(6) — NOT NULL
- retry_count — INT — NOT NULL
- last_error — VARCHAR(1000)
document_asset_references
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- asset_id — CHAR(36) — Foreign key → document_assets.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
document_assets
- id — CHAR(36) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- uploaded_by — VARCHAR(255) — Foreign key → users.id
- original_filename — VARCHAR(255) — NOT NULL
- content_type — VARCHAR(64) — NOT NULL
- byte_size — BIGINT — NOT NULL
- width — INT — NOT NULL
- height — INT — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- storage_key — VARCHAR(512) — NOT NULL
- unreferenced_since — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
document_content_versions
- version — BIGINT — Primary key — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- markdown — LONGTEXT — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- created_by — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- operation_id — VARCHAR(255) — Foreign key → ai_operation_logs.operation_id
document_edit_states
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- markdown — LONGTEXT — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
document_processing_queue
- id — BIGINT — Primary key — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- status — VARCHAR(255) — NOT NULL
document_wiki_links
- relation_type — VARCHAR(255) — Primary key — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- wiki_page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- confidence — DOUBLE
- created_at — DATETIME(6) — NOT NULL
documents
- id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- filename — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255) — NOT NULL
- normalized_filename — VARCHAR(255) — NOT NULL
- mime_type — VARCHAR(255) — NOT NULL
- byte_size — BIGINT — NOT NULL
- status — VARCHAR(255) — NOT NULL
- source_uri — VARCHAR(255)
- extracted_text_uri — VARCHAR(255)
- content_hash — VARCHAR(255)
- source_document_id — VARCHAR(255) — Foreign key → documents.id
- current_content_hash — VARCHAR(64)
- current_version — BIGINT — NOT NULL
- document_role — VARCHAR(16) — NOT NULL
- folder_id — CHAR(36) — Foreign key → folders.id
- sort_order — BIGINT — NOT NULL
- uploaded_at — DATETIME(6) — NOT NULL
- processed_at — DATETIME(6)
- error_message — LONGTEXT
- pipeline_run_id — VARCHAR(255)
- processing_started_at — DATETIME(6)
- processing_updated_at — DATETIME(6)
- processing_stage — VARCHAR(255)
- reconciled_at — DATETIME(6)
- origin — VARCHAR(255)
- selection_mode — VARCHAR(255)
- pipeline_input_markdown — LONGTEXT
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted_by — VARCHAR(255) — Foreign key → users.id
- delete_operation_id — CHAR(36)
email_verifications
- id — VARCHAR(64) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- purpose — VARCHAR(32) — NOT NULL
- code_hash — VARCHAR(128) — NOT NULL
- code_expires_at — DATETIME(6) — NOT NULL
- attempt_count — INT — NOT NULL
- confirmed_at — DATETIME(6)
- token_hash — VARCHAR(128)
- token_expires_at — DATETIME(6)
- consumed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
folders
- id — CHAR(36) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- parent_folder_id — CHAR(36) — Foreign key → folders.id
- name — VARCHAR(255) — NOT NULL
- sort_order — BIGINT — NOT NULL
- current_version — BIGINT — NOT NULL
- deleted_at — DATETIME(6)
- deleted_by — VARCHAR(255) — Foreign key → users.id
- delete_operation_id — CHAR(36)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
idempotency_records
- id — CHAR(36) — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- endpoint_scope — VARCHAR(255) — NOT NULL
- idempotency_key — VARCHAR(255) — NOT NULL
- request_hash — VARCHAR(64) — NOT NULL
- response_status — INT — NOT NULL
- resource_id — VARCHAR(255)
- response_body — JSON
- created_at — DATETIME(6) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
pipeline_runs
- id — CHAR(36) — Primary key — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id
- input_source — LONGTEXT — NOT NULL
- output_dir — LONGTEXT — NOT NULL
- mode — LONGTEXT — NOT NULL
- status — LONGTEXT — NOT NULL
- manifest — JSON
- error — LONGTEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- finished_at — DATETIME(6)
source_blocks
- block_id — VARCHAR(255) — Primary key — NOT NULL
- document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- text — LONGTEXT — NOT NULL
user_oauth_accounts
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- provider — VARCHAR(255) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
user_refresh_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- revoked_at — DATETIME(6)
users
- id — VARCHAR(255) — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- display_name — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wiki_embedding_units
- id — VARCHAR(255) — Primary key — NOT NULL
- embedding_vector_id — VARCHAR(255) — Foreign key → wiki_embedding_vectors.id — NOT NULL
- page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- source_document_id — VARCHAR(255) — Foreign key → documents.id — NOT NULL
- unit_type — LONGTEXT — NOT NULL
- block_refs — LONGTEXT — NOT NULL
- text — LONGTEXT — NOT NULL
- weight — DOUBLE — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wiki_embedding_vectors
- id — VARCHAR(255) — Primary key — NOT NULL
- embedding_model — VARCHAR(255) — NOT NULL
- representation_hash — VARCHAR(255) — NOT NULL
- representation_text — LONGTEXT — NOT NULL
- embedding_vector — LONGTEXT
- embedding_dimension — INT — NOT NULL
- status — LONGTEXT — NOT NULL
- error — LONGTEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wiki_page_contributions
- page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- ingest_operation_id — VARCHAR(255) — Foreign key → ai_operation_logs.operation_id — NOT NULL
- source_document_id — VARCHAR(255) — Foreign key → documents.id
- sequence_revision — BIGINT — NOT NULL
- object_key — LONGTEXT — NOT NULL
- active — BOOLEAN — NOT NULL
- deactivated_by — VARCHAR(255) — Foreign key → ai_operation_logs.operation_id
- created_at — DATETIME(6) — NOT NULL
wiki_page_embeddings
- embedding_model — VARCHAR(255) — Primary key — NOT NULL
- page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- representation_hash — LONGTEXT — NOT NULL
- embedding_vector — LONGTEXT — NOT NULL
- embedding_dimension — INT — NOT NULL
- status — LONGTEXT — NOT NULL
- error — LONGTEXT
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wiki_page_links
- link_type — VARCHAR(255) — Primary key — NOT NULL
- from_page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- to_page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- label — VARCHAR(255)
- confidence — DOUBLE
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wiki_page_versions
- revision — BIGINT — Primary key — NOT NULL
- page_id — VARCHAR(255) — Foreign key → wiki_pages.id — NOT NULL
- operation_id — VARCHAR(255) — Foreign key → ai_operation_logs.operation_id
- contribution_count — INT — NOT NULL
- markdown — LONGTEXT — NOT NULL
- markdown_key — LONGTEXT — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- created_by — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
wiki_pages
- id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- page_type — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- slug — VARCHAR(255) — NOT NULL
- summary — LONGTEXT
- markdown_uri — VARCHAR(255)
- status — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wiki_schemas
- id — VARCHAR(255) — Primary key — NOT NULL
- workspace_id — VARCHAR(255) — NOT NULL
- user_id — VARCHAR(255) — NOT NULL
- name — LONGTEXT — NOT NULL
- raw_markdown — LONGTEXT — NOT NULL
- sanitized_global_markdown — LONGTEXT — NOT NULL
- sanitized_query_markdown — LONGTEXT — NOT NULL
- sanitized_ingest_markdown — LONGTEXT — NOT NULL
- sanitized_edit_markdown — LONGTEXT — NOT NULL
- sanitized_concept_markdown — LONGTEXT — NOT NULL
- sanitized_template_markdown — LONGTEXT — NOT NULL
- preview_markdown — LONGTEXT — NOT NULL
- lint_result — JSON — NOT NULL
- status — LONGTEXT — NOT NULL
- schema_version — LONGTEXT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- activated_at — DATETIME(6)
workspace_members
- workspace_id — VARCHAR(255) — Foreign key → workspaces.id — NOT NULL
- user_id — VARCHAR(255) — Foreign key → users.id — NOT NULL
- role — VARCHAR(255) — NOT NULL
- joined_at — DATETIME(6) — NOT NULL
workspaces
- id — VARCHAR(255) — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- deleted_at — DATETIME(6)
- deleted_by — VARCHAR(255)