Questions about aliases table
Posted: Fri Feb 16, 2024 10:04 am
1) aliases contains a column `release_seq`. Should this sequence be called `alias_seq` instead?
2) The values in this sequence seem odd sometimes. For example, some entries have many records with sequence 0. (see entry_id 9292)
I expected (entry_id, release_seq) to be unique. Is my assumption correct? If so, maybe we can fix the data and add a unique constraint on the table?
EDIT: or maybe I mis-understood what aliases is, and it really is aliases that relate to a particular release?
2) The values in this sequence seem odd sometimes. For example, some entries have many records with sequence 0. (see entry_id 9292)
I expected (entry_id, release_seq) to be unique. Is my assumption correct? If so, maybe we can fix the data and add a unique constraint on the table?
EDIT: or maybe I mis-understood what aliases is, and it really is aliases that relate to a particular release?