I am writing a script to sync points from a site and amenity=recycling tags in OSM so I need to store OSM `id`, `version` and `type` in local database. What are the best column types? `UNSIGNED BIGINT`, `UNSIGNED INT` and `SET`?`SET`? Bonus points for other metadata fields info. Extra bonus points for PostgreSQL info.

I am writing a script to sync points from a site and amenity=recycling tags in OSM so I need to store OSM id, version `id`, `version` and type `type` in local database. What are the best column types? UNSIGNED BIGINT, INT `UNSIGNED BIGINT`, `UNSIGNED INT` and SET? Bonus points for other metadata fields info. Extra bonus points for PostgreSQL info.`SET`?

I am writing a script to sync points from a site and amenity=recycling tags in OSM so I need to store OSM id, version and type in local database. What are the best column types? UNSIGNED BIGINT, INT and SET?SET? Bonus points for other metadata fields info. Extra bonus points for PostgreSQL info.

I am writing a script to sync points from a site and amenity=recycling tags in OSM so I need to store OSM id, version and type in local database. What are the best column types? UNSIGNED BIGINT, INT and SET?