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 #333 (comment)

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