In the Companion Relationships Table there's a column called other_companion_names, where the values are other possible identifiers of the companions. There needs to be an ingest function to be able to add to the lists of other names.
Because other_companion_names are strings in the table, the function will need to pull the old value, check the new name isn't a duplicate, append it to the previous string, and then place it back in the table.
In the Companion Relationships Table there's a column called other_companion_names, where the values are other possible identifiers of the companions. There needs to be an ingest function to be able to add to the lists of other names.
Because other_companion_names are strings in the table, the function will need to pull the old value, check the new name isn't a duplicate, append it to the previous string, and then place it back in the table.