ToeBee/ChangesetMD

Schema changes

Opened this issue · 0 comments

pnorman commented

Some suggested changes, based on writing a lot of queries

  • Normalize user IDs to have id-> name mapping in their own table. I do a lot of queries on a distinct user, and have to write SELECT DISTINCT user_id, user_name ...
  • Drop comment_ prefix from osm_changeset_comment column names
  • Perhaps drop the osm_ prefix from all table names