Isn’t it the case that a Writer can only have one Manuscript Share? If so, there is really no reason to have a separate MAN record since the the relevant MAN properties (pr, mr, and sr manuscript shares) are really just properties of the Writer. Suggest removing the MAN record and bringing the pr, mr, sr manuscript shares “up a level” to the writer. We can also ditch the writer_ip_number since that’s already defined at the writer level
Isn’t it the case that a Writer can only have one Manuscript Share? If so, there is really no reason to have a separate MAN record since the the relevant MAN properties (pr, mr, and sr manuscript shares) are really just properties of the Writer. Suggest removing the MAN record and bringing the pr, mr, sr manuscript shares “up a level” to the writer. We can also ditch the writer_ip_number since that’s already defined at the writer level