---

SELECT
    annual_deduction_flag,
    COUNT(*) AS record_count
FROM report.unv_registry_item
GROUP BY annual_deduction_flag
ORDER BY annual_deduction_flag;





SELECT
    to_regclass('report.unv_annual_setting') AS annual_setting_table;

SELECT
    c.conname AS constraint_name,
    c.contype AS constraint_type,
    pg_get_constraintdef(c.oid) AS constraint_definition
FROM pg_constraint c
WHERE c.conrelid = 'report.unv_registry_item'::regclass
ORDER BY c.conname;

SELECT
    indexname,
    indexdef
FROM pg_indexes
WHERE schemaname = 'report'
  AND tablename = 'unv_registry_item'
ORDER BY indexname;