enhancements suggested for the `users_companies` table

Thanks for sharing this!

https://bigquery.cloud.google.com/table/public-github-adobe:github_archive_query_views.users_companies?pli=1&tab=details


Suggestions:

- Add the field 'user_id', as people can change their nick (but not their id).
- Add the field 'crawled_at'. Account will have multiple companies through their lifetime, and this will allow you to attribute commits that happened x years ago to the right company.

With 'crawled_at' you'll have to allow multiple entries per user, and adjust queries later. For example, the easiest queries would go through a view that just gives the latest company per user.

Start with the linked BigQuery users_companies table and inspect the related views and queries that consume it. Confirm the schema changes for user_id and crawled_at, then verify that historical company records and the latest-company view can be represented without breaking existing queries.

Written by the indexing model from the issue text.