myWIKI
Tables (18)
artifacts
- id — UUID — Primary key — NOT NULL
- artifact_type — VARCHAR(20) — NOT NULL — CHECK IN ('markdown','pdf','pptx','docx')
- object_key — TEXT — NOT NULL — UNIQUE(object_key)
- version — INTEGER — NOT NULL — UNIQUE(report_id, artifact_type, version), CHECK version >= 1
- file_size — INTEGER
- mime_type — VARCHAR(100)
- created_by — UUID
- created_at — TIMESTAMPTZ — NOT NULL
- report_id — UUID — Foreign key → reports.id — NOT NULL
chat_messages
- id — UUID — Primary key — NOT NULL
- session_id — UUID — Foreign key → chat_sessions.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- model_name — VARCHAR(100)
- prompt_version — VARCHAR(50)
- created_at — TIMESTAMPTZ — NOT NULL
chat_sessions
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → profiles.id — NOT NULL
- title — VARCHAR(500)
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
document_versions
- id — UUID — Primary key — NOT NULL
- document_id — UUID — Foreign key → documents.id — NOT NULL
- version_no — INTEGER — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- raw_object_key — TEXT
- markdown_object_key — TEXT — NOT NULL
- parser_version — VARCHAR(50)
- language — VARCHAR(10)
- created_at — TIMESTAMPTZ — NOT NULL
documents
- id — UUID — Primary key — NOT NULL
- source_id — UUID — Foreign key → sources.id
- title — VARCHAR(500) — NOT NULL
- canonical_url — TEXT — UNIQUE(workspace_id, canonical_url)
- published_at — TIMESTAMPTZ
- status — VARCHAR(30) — NOT NULL
- uploaded_by — UUID — Foreign key → profiles.id
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
message_citations
- id — UUID — Primary key — NOT NULL
- message_id — UUID — Foreign key → chat_messages.id — NOT NULL
- document_version_id — UUID — Foreign key → document_versions.id — NOT NULL
- qmd_uri — TEXT
- source_start_line — INTEGER
- source_end_line — INTEGER
- quoted_text — TEXT
- relevance_score — DECIMAL(5,4)
- citation_order — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
pipeline_jobs
- id — UUID — Primary key — NOT NULL
- job_type — VARCHAR(50) — NOT NULL
- target_type — VARCHAR(50)
- target_id — UUID
- status — VARCHAR(30) — NOT NULL
- progress — INTEGER — NOT NULL — CHECK BETWEEN 0 AND 100
- error_message — TEXT
- requested_by — UUID — Foreign key → profiles.id
- payload — JSONB — NOT NULL
- result — JSONB
- retry_count — INTEGER — NOT NULL — CHECK >= 0
- idempotency_key — VARCHAR(200)
- started_at — TIMESTAMPTZ
- completed_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
profiles
- id — UUID — Primary key — NOT NULL
- display_name — VARCHAR(100) — NOT NULL
- department — VARCHAR(100)
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
qmd_index_entries
- id — UUID — Primary key — NOT NULL
- document_version_id — UUID — Foreign key → document_versions.id
- wiki_version_id — UUID — Foreign key → wiki_page_versions.id
- report_id — UUID — Foreign key → reports.id
- collection_name — VARCHAR(100) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- qmd_uri — TEXT
- qmd_docid — VARCHAR(20)
- index_generation — INTEGER — NOT NULL
- indexed_at — TIMESTAMPTZ
- last_error — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
report_citations
- id — UUID — Primary key — NOT NULL
- section_id — UUID — Foreign key → report_sections.id — NOT NULL
- document_version_id — UUID — Foreign key → document_versions.id — NOT NULL
- source_start_line — INTEGER
- source_end_line — INTEGER
- quoted_text — TEXT
- relevance_score — DECIMAL(5,4)
- citation_order — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
report_sections
- id — UUID — Primary key — NOT NULL
- report_id — UUID — Foreign key → reports.id — NOT NULL
- section_order — INTEGER — NOT NULL
- title — VARCHAR(500) — NOT NULL
- content — TEXT
- status — VARCHAR(30) — NOT NULL
- model_name — VARCHAR(100)
- prompt_version — VARCHAR(50)
- generation_run_id — UUID — Foreign key → pipeline_jobs.id
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
reports
- id — UUID — Primary key — NOT NULL
- requested_by — UUID — Foreign key → profiles.id
- title — VARCHAR(500) — NOT NULL
- report_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- request_config — JSONB — NOT NULL
- report_key — VARCHAR(200) — NOT NULL — UNIQUE(workspace_id, report_key, version), CHECK version >= 1
- version — INTEGER — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
sources
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL — UNIQUE(workspace_id, name)
- source_type — VARCHAR(30) — NOT NULL
- base_url — TEXT
- reliability_score — DECIMAL(5,4)
- config — JSONB — NOT NULL
- enabled — BOOLEAN — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
wiki_page_sources
- id — UUID — Primary key — NOT NULL
- wiki_version_id — UUID — Foreign key → wiki_page_versions.id — NOT NULL
- document_version_id — UUID — Foreign key → document_versions.id — NOT NULL
- claim_text — TEXT
- source_start_line — INTEGER
- source_end_line — INTEGER
- support_type — VARCHAR(20)
- citation_order — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
wiki_page_versions
- id — UUID — Primary key — NOT NULL
- page_id — UUID — Foreign key → wiki_pages.id — NOT NULL
- version_no — INTEGER — NOT NULL
- markdown_object_key — TEXT — NOT NULL
- content_hash — VARCHAR(64) — NOT NULL
- change_summary — TEXT
- created_by — UUID — Foreign key → profiles.id
- review_status — VARCHAR(30) — NOT NULL
- reviewed_by — UUID — Foreign key → profiles.id
- reviewed_at — TIMESTAMPTZ
- generated_by — VARCHAR(20) — NOT NULL
- generator_model — VARCHAR(100)
- generator_prompt_version — VARCHAR(50)
- generation_run_id — UUID — Foreign key → pipeline_jobs.id
- validation_status — VARCHAR(30) — NOT NULL
- confidence_score — DECIMAL(5,4)
- created_at — TIMESTAMPTZ — NOT NULL
wiki_pages
- id — UUID — Primary key — NOT NULL
- parent_page_id — UUID — Foreign key → wiki_pages.id
- slug — VARCHAR(300) — NOT NULL — UNIQUE(workspace_id, slug)
- title — VARCHAR(500) — NOT NULL
- page_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- review_policy — VARCHAR(20) — NOT NULL
- current_version_id — UUID — Foreign key → wiki_page_versions.id
- published_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
workspace_members
- id — UUID — Primary key — NOT NULL
- workspace_id — UUID — Foreign key → workspaces.id — NOT NULL
- role — VARCHAR(20) — NOT NULL — CHECK IN ('owner','admin','editor','viewer')
- created_at — TIMESTAMPTZ — NOT NULL
- user_id — UUID — Foreign key → profiles.id — NOT NULL — UNIQUE(workspace_id, user_id)
workspaces
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(200) — NOT NULL
- slug — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL