---

SELECT table_name, column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
  AND table_name IN ('transaction', 'account')
  AND (
      column_name IN ('id', 'operation_id')
      OR column_name LIKE '%sharer%'
      OR column_name LIKE '%account%'
      OR column_name LIKE '%contract%'
  )
ORDER BY table_name, ordinal_position;