Refactor SQL types

[ShreyBana]

          why are we changing these particularly to `TEXT` ?

if there is some valid reason then, why is this kept different ?

Originally posted by @ayushjain17 in https://github.com/juspay/superposition/pull/333#discussion_r1917927189

PS: There are type aliases in postgres, with support for some DB side validation: https://www.postgresql.org/docs/current/domains.html