---

SELECT column_name, data_type
FROM information_schema.columns
WHERE table_schema = 'back_office'
  AND table_name = 'contract'
  AND column_name ILIKE '%scheme%'
ORDER BY ordinal_position