Database Documentation
Database Documentation
Created: Tue 29 Jul 2025 06:49:39 CEST
Document Version: 1.0 - Initial documentation with timestamp
Security Classification: Internal Technical Documentation
Target Audience: Backend Developers, Database Administrators
Author: Paul Wisén
This directory contains database schema and design documentation.
🚨 CRITICAL: Always Verify Schema First
Before writing any database queries, read SCHEMA-VERIFICATION.md first!
We had a production bug caused by outdated documentation showing wrong column names. This verification document contains the actual, verified production schema.
Expected documents in this directory
This folder houses all database-related artefacts for both the Neo4j graph and Supabase Postgres stores.
- 🚨 Schema Verification (CRITICAL) – READ THIS FIRST
- Neo4j Core Schema – Primary graph data model
- Supabase Core Schema – PostgreSQL relational schema with wallet-first multi-wallet tables
- HD Wallet Schema – UPDATED: Wallet-first database design with multi-wallet support and incident response
- Legacy Graph Schema (Deprecated)
- Supabase DDL
- Migration Strategies
- Indexing Strategies
- Data Retention Policies
- Entity-Relationship Diagrams
- Predicate Catalogue – Functional & spatial predicate reference powered by Supabase
⚠️ Documentation Trust Levels
- 🔴 HIGH RISK: Old schema files may contain outdated column names
- 🟡 MEDIUM RISK: Code comments and documentation files can go stale
- 🟢 SAFE: SCHEMA-VERIFICATION.md - verified against production database