SQL reference: 002_ledger

Production API: https://asi-database-node-api.arybit.co.ke

Source: Database/postgresql/002_ledger.sql

Engine: PostgreSQL. Status: enabled; experimental.

Migration ID: 002_ledger. SHA-256 (LF): e1e09894c4da921e76b9ca377efa489dd098af84e6fa5f9bb976104ad1e09c49.

Source overview

Tenant-scoped append-only balanced ledger. Transactions commit as a unit. Serialize entries belonging to a transaction and reject partial journals.

Declared objects

• asi.check_ledger_balance
• asi.ledger_entries
• asi.ledger_transactions
• asi.require_atomic_ledger
• atomic_entries
• entries_no_truncate
• immutable_entries
• immutable_transactions
• ledger_entries_transaction
• transactions_no_truncate

This is a static source reference, not a runtime qualification. Object extraction does not interpret SQL semantics. Review the source and manifest before any schema change.

Connection guide · Migration qualification · SQL catalog