Commits table cmt_ght_author_id not getting populated

> [!NOTE]
> Migrated from [augurlabs/augur#3692](https://github.com/augurlabs/augur/issues/3692)
> Originally opened by `@cdolfi` on 2026-02-13

---

To my understanding, cmt_ght_author_id should be the cntrb_id (uuid unique to augur) for the author of the commit. Right now, that is not getting populated.

If that is not the case, there should be a column in the commits table for the cntrb_id of the author and cmt_ght_author_id falls into the category I have below

If my understanding is correct, cmt_ght_author_id should be changed to author_ctrb_id or something more clear to what it is but thats probably a separate issue.

This same line of reasoning applies to cmt_ght_committer_id in my POV.

Columns from commit table I recommend removing:
- cmt_author_platform_username - no need to have information in two spots, in the contributor table
- cmt_committer_affiliation - no need to have information in two spots, info in the contributor table
- cmt_author_affiliation - no need to have information in two spots, info in the contributor table
- cmt_author_raw_email - same information as cmt_author_email
- cmt_ght_committed_at - all nulls, and that info is in cmt_committer_timestamp