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