---

AND CAST(EXTRACT(YEAR FROM o.operation_date) AS integer) = p.target_year





SELECT
    kcu.column_name,
    ccu.table_schema AS referenced_schema,
    ccu.table_name AS referenced_table,
    ccu.column_name AS referenced_column
FROM information_schema.table_constraints tc
JOIN information_schema.key_column_usage kcu
    ON kcu.constraint_name = tc.constraint_name
   AND kcu.constraint_schema = tc.constraint_schema
JOIN information_schema.constraint_column_usage ccu
    ON ccu.constraint_name = tc.constraint_name
   AND ccu.constraint_schema = tc.constraint_schema
WHERE tc.constraint_type = 'FOREIGN KEY'
  AND tc.table_schema = 'ourpension'
  AND tc.table_name = 'contract'
ORDER BY kcu.column_name;





SELECT
    COUNT(*) FILTER (
        WHERE accepted IS NULL
          AND rejected IS NULL
          AND canceled IS NULL
    ) AS draft_count,

    COUNT(*) FILTER (
        WHERE accepted IS NOT NULL
          AND canceled IS NULL
    ) AS accepted_active_count,

    COUNT(*) FILTER (
        WHERE rejected IS NOT NULL
          AND canceled IS NULL
    ) AS rejected_count,

    COUNT(*) FILTER (
        WHERE canceled IS NOT NULL
    ) AS canceled_count
FROM ourpension.application_death_info;