affiliations columns in commits table seem unused

> [!NOTE]
> Migrated from [augurlabs/augur#3795](https://github.com/augurlabs/augur/issues/3795)
> Originally opened by `@MoralCode` on 2026-03-26

---

in my recent work looking at the commits table, i noticed that it contains some columns for affiliation
`cmt_author_affiliation` and `cmt_committer_affiliation`

The only reference I was able to find in the code to these columns were some unused or barely-used functions, some of which seemed intended to clear out these columns. Such as:

https://github.com/chaoss/augur/blob/75d99d35384983041d9362049e67a9ddc5c5d926/augur/tasks/git/util/facade_worker/facade_worker/rebuildcache.py#L36

a search in dbeaver for records where `cmt_author_affiliation IS NOT NULL and cmt_author_affiliation != 'NULL'` returned no results.

Can these columns be removed?