mixing char and varchar id column types is bad, making everything char
in postgres.