---

SELECT
    tc.table_schema           AS dependent_schema,
    tc.table_name             AS dependent_table,
    kcu.column_name           AS dependent_column,
    ccu.table_schema          AS referenced_schema,
    ccu.table_name            AS referenced_table,
    ccu.column_name           AS referenced_column,
    rc.delete_rule
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
JOIN information_schema.referential_constraints rc
    ON rc.constraint_name = tc.constraint_name
   AND rc.constraint_schema = tc.constraint_schema
WHERE tc.constraint_type = 'FOREIGN KEY'
  AND (
        (ccu.table_schema = 'report'
         AND ccu.table_name IN (
             'fns_reference_request_journal',
             'smev_register'
         ))
        OR
        (ccu.table_schema = 'dev'
         AND ccu.table_name = 'model_file_to_verification')
      )
ORDER BY
    ccu.table_schema,
    ccu.table_name,
    tc.table_schema,
    tc.table_name;