Database Schema Reference

{
  "id": "db-schema-reference",
  "wikiId": "E2581",
  "path": "/internal/db-schema-reference/",
  "filePath": "internal/db-schema-reference.mdx",
  "title": "Database Schema Reference",
  "quality": null,
  "readerImportance": null,
  "researchImportance": null,
  "tacticalValue": null,
  "contentFormat": "article",
  "causalLevel": null,
  "lastUpdated": "2026-06-15",
  "dateCreated": null,
  "summary": null,
  "description": "Auto-generated, complete reference for the wiki-server PostgreSQL schema — every table, column, and foreign key, derived from schema.ts.",
  "ratings": null,
  "category": "internal",
  "subcategory": "architecture",
  "clusters": [
    "ai-safety"
  ],
  "metrics": {
    "wordCount": 18668,
    "tableCount": 118,
    "diagramCount": 8,
    "internalLinks": 1,
    "externalLinks": 0,
    "footnoteCount": 0,
    "bulletRatio": 0,
    "sectionCount": 128,
    "hasOverview": false,
    "structuralScore": 10
  },
  "suggestedQuality": 67,
  "updateFrequency": null,
  "evergreen": true,
  "wordCount": 18668,
  "unconvertedLinks": [],
  "unconvertedLinkCount": 0,
  "convertedLinkCount": 0,
  "backlinkCount": 0,
  "hallucinationRisk": {
    "level": "medium",
    "score": 60,
    "factors": [
      "no-citations",
      "few-external-sources"
    ]
  },
  "entityType": "internal",
  "redundancy": {
    "maxSimilarity": 0,
    "similarPages": []
  },
  "coverage": {
    "passing": 2,
    "total": 13,
    "targets": {
      "tables": 75,
      "diagrams": 7,
      "internalLinks": 149,
      "externalLinks": 93,
      "footnotes": 56,
      "references": 56
    },
    "actuals": {
      "tables": 118,
      "diagrams": 8,
      "internalLinks": 1,
      "externalLinks": 0,
      "footnotes": 0,
      "references": 0,
      "quotesWithQuotes": 0,
      "quotesTotal": 0,
      "accuracyChecked": 0,
      "accuracyTotal": 0
    },
    "items": {
      "summary": "red",
      "schedule": "red",
      "entity": "red",
      "editHistory": "red",
      "overview": "red",
      "tables": "green",
      "diagrams": "green",
      "internalLinks": "amber",
      "externalLinks": "red",
      "footnotes": "red",
      "references": "red",
      "quotes": "red",
      "accuracy": "red"
    }
  },
  "recommendedScore": 9.67
}

No external links

No backlinks