SELECT
table_schema,
table_name,
column_name,
data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
AND table_name IN (
'operation',
'ops_assignee_decision_payment'
)
AND (
column_name ILIKE '%assignee%'
OR column_name ILIKE '%decision%'
OR column_name ILIKE '%operation%'
)
ORDER BY table_name, ordinal_position;