---

SELECT 
    ets.operation_id,
    o.id as operation_id,
    ets.incoming_order_id
FROM back_office.eps_transaction et
JOIN back_office.eps_transaction_source ets
    ON ets.id = et.eps_transaction_source_id
LEFT JOIN back_office.operation o
    ON o.id = ets.operation_id
LIMIT 10





SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
  AND table_name = 'pension_calculation'
  AND column_name ILIKE '%contract%'