Add `other_name` to Photometry table

It might be nice to have a `catalog_id` column in the photometry table. E.g., the 2MASS identifier along with the 2MASS photometry. (Same for Gaia, WISE, etc.). This would also allow for the use case of having multiple matches in in the catalog. E.g., I have a list of candidates and I do a 2MASS search and I'm not sure which 2MASS source is the same as my candidate so I ingest the photometry from both 2MASS matches. (This use case would also motivate having `ignore` and/or `adopted` columns in the Photometry table.)

could also imagine having this in the proper motions and parallaxes table. Could contain Gaia and Rubin catalog designations.

Start by reviewing the Photometry table and the related proper motions and parallaxes tables. Clarify whether the requested field is `other_name` or `catalog_id`, and whether `ignore` and `adopted` are in scope. Done means an agreed schema that supports catalog designations and multiple catalog matches.

Written by the indexing model from the issue text.