Too generic names (foreign key columns)

Copy SQL

select target_schema as table_schema, target_table as table_name, a.attname as suspected_column_name
from (select 
(select nspname from pg_namespace where oid=m.relnamespace) as target_schema,
m.relname as target_table, 
m.oid as target_table_oid,
unnest(o.conkey) AS target_col
from pg_constraint o inner join pg_class c on c.oid = o.conrelid
inner join pg_class m on m.oid = o.conrelid
where o.contype='f'
and o.conrelid in (select oid from pg_class c where c.relkind = 'r')) t
inner join pg_attribute a on t.target_col = a.attnum and t.target_table_oid = a.attrelid and a.attisdropped = false
where a.attname~*'^[_]*(id|kood|identifikaator|identifier|code|number)[_]*$'
order by target_schema, target_table, attname;