ChangesetMD
ChangesetMD copied to clipboard
Schema changes
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 fromosm_changeset_comment
column names - Perhaps drop the osm_ prefix from all table names