Update bcms_id relation from books, bookComponents, Collections, to errors, and notification Messages.
Right now we are based to bcms_id as a unique identifier for the whole app. Since bcmsid now may have the same value for the different versions of a book , we need to find another way to identify the errors and notification messages for the app and match them to the related Object.
we had previously changed the bookComponentId to bcmsid here: !655 (merged)
So now we need to change back the following things:
-
For ncbi_notification_messages tables we need to have back an ObjectId instead of the bcmsid that will related to a bookComponent.id or Book.id or toc.id depending on the case and the job (whole book case vs chapter based) whole book case should match the book.id and the chapter based should match the bookComponent.id or toc.id when it is a load to pmc for a TOC. -
For Errors we need to change the bcmsid field to an objectId again based on case whole book/ chapter based or if it is a toc or not .