ChangesetMD icon indicating copy to clipboard operation
ChangesetMD copied to clipboard

Schema changes

Open pnorman opened this issue 9 years ago • 0 comments

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

pnorman avatar Jan 06 '16 03:01 pnorman