Commit Graph

2 Commits

Author SHA1 Message Date
Adrian Flores Cortes
a05f7595b4 [GAP-007] fix: Remove non-immutable generated column in change_log
PostgreSQL requires generated columns to use immutable expressions.
The executed_at::date cast is not immutable due to timezone dependencies.
Changed to a regular DATE column that can be populated by the trigger.

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-02-04 01:35:04 -06:00
Adrian Flores Cortes
efce73bdbd [GAP-006,007] feat: Add DDL for Digital Signatures and Audit Triggers
GAP-006: Digital Signatures
- documents.signature_type ENUM
- documents.signature_status ENUM
- documents.digital_signatures table with RLS

GAP-007: Audit Triggers
- audit schema
- audit.change_log table
- audit.log_changes() trigger function
- Triggers on 13 critical tables

Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
2026-02-04 01:15:16 -06:00