KB-3595
HC-TRIGGER enforcement gap query
1 min read Revision 1
health-checksqllaw-22fix25
-- HC-TRIGGER: Bảng governed có cột description nhưng thiếu trigger trg_desc_guard_* -- DB: directus | Schema: public | Read-only SELECT cr.collection_name FROM collection_registry cr JOIN information_schema.columns c ON c.table_name = cr.collection_name AND c.column_name = 'description' AND c.table_schema = 'public' WHERE cr.governance_role = 'governed' AND c.table_name IN ( SELECT table_name FROM information_schema.tables WHERE table_schema = 'public' AND table_type = 'BASE TABLE' ) AND cr.collection_name NOT IN ( SELECT DISTINCT event_object_table FROM information_schema.triggers WHERE trigger_name LIKE 'trg_desc_guard_%' AND trigger_schema = 'public' );