# Database Documentation

This directory contains the production database review snapshot for MySQL host `10.0.0.11`.

## Documents

- [Production Host Review](./production-host-10.0.0.11.md)
- [Trigger Integration Map](./trigger-map-10.0.0.11.md)
- [ICAP Schema Compare: 10.0.0.11 vs 10.0.0.15](./icapv2-schema-compare-10.0.0.11-vs-10.0.0.15.md)

## Schema Reviews

- [automatedmail](./schemas/automatedmail.md)
- [cficore](./schemas/cficore.md)
- [cfidebtors](./schemas/cfidebtors.md)
- [conscficore](./schemas/conscficore.md)
- [consfmscreditors](./schemas/consfmscreditors.md)
- [debtors_test](./schemas/debtors_test.md)
- [filemaker_portal](./schemas/filemaker_portal.md)
- [fmscashbook](./schemas/fmscashbook.md)
- [fmscashbooktest](./schemas/fmscashbooktest.md)
- [fmscreditors](./schemas/fmscreditors.md)
- [general_ledger](./schemas/general_ledger.md)
- [icapimport](./schemas/icapimport.md)
- [icapv2](./schemas/icapv2.md)
- [iimsstats](./schemas/iimsstats.md)
- [raw_source](./schemas/raw_source.md)
- [restapi_portal](./schemas/restapi_portal.md)

## Source

- Generated from the metadata capture under `artifacts/db-review-10.0.0.11/`.
- Generated by `scripts/generate-db-review.mjs` so the markdown and Mermaid output can be reproduced locally from the captured metadata without re-querying production.