Thank you for your input.

In terms of database normalization, doesn't that usually require redundancy (repeated columns / records)? We have that once over two columns, but otherwise there are no repeats - each entry is unique.

Pardon my ignorance, not much experience with database software as is clearly evident haha.