Database Schema Overview

{
  "id": "db-schema-overview",
  "wikiId": "E1054",
  "path": "/internal/db-schema-overview/",
  "filePath": "internal/db-schema-overview.mdx",
  "title": "Database Schema Overview",
  "quality": 0,
  "readerImportance": null,
  "researchImportance": null,
  "tacticalValue": null,
  "contentFormat": "dashboard",
  "causalLevel": null,
  "lastUpdated": "2026-03-12",
  "dateCreated": null,
  "summary": null,
  "description": "Complete reference for the wiki-server PostgreSQL schema — tables, relationships, ER diagrams, and migration history",
  "ratings": null,
  "category": "internal",
  "subcategory": "architecture",
  "clusters": [
    "ai-safety"
  ],
  "metrics": {
    "wordCount": 1094,
    "tableCount": 6,
    "diagramCount": 9,
    "internalLinks": 1,
    "externalLinks": 1,
    "footnoteCount": 0,
    "bulletRatio": 0.02,
    "sectionCount": 18,
    "hasOverview": false,
    "structuralScore": 10
  },
  "suggestedQuality": 0,
  "updateFrequency": null,
  "evergreen": true,
  "wordCount": 1094,
  "unconvertedLinks": [],
  "unconvertedLinkCount": 0,
  "convertedLinkCount": 0,
  "backlinkCount": 2,
  "hallucinationRisk": {
    "level": "medium",
    "score": 50,
    "factors": [
      "no-citations",
      "low-quality-score",
      "few-external-sources",
      "structured-format"
    ]
  },
  "entityType": "internal",
  "redundancy": {
    "maxSimilarity": 0,
    "similarPages": []
  },
  "coverage": {
    "passing": 2,
    "total": 12,
    "targets": {
      "tables": 1,
      "diagrams": 0,
      "internalLinks": 9,
      "externalLinks": 2,
      "footnotes": 0,
      "references": 1
    },
    "actuals": {
      "tables": 6,
      "diagrams": 9,
      "internalLinks": 1,
      "externalLinks": 1,
      "footnotes": 0,
      "references": 0,
      "quotesWithQuotes": 0,
      "quotesTotal": 0,
      "accuracyChecked": 0,
      "accuracyTotal": 0
    },
    "items": {
      "summary": "red",
      "schedule": "red",
      "entity": "red",
      "editHistory": "red",
      "tables": "green",
      "diagrams": "green",
      "internalLinks": "amber",
      "externalLinks": "amber",
      "footnotes": "red",
      "references": "red",
      "quotes": "red",
      "accuracy": "red"
    }
  },
  "recommendedScore": 4.61
}

No external links