Currently we have a name column in the Author table which is almost certainly redundant. Queries on this column should be using Authorships instead.
Say I have a user "chrisca", name "Chris Cannam". I have publications in the names "C Cannam" and "Christopher Cannam".
When I type "can.." "chr.." into the author field for a new publication, I expect to see the autocomplete options
Chris Cannam [at my institution]
C Cannam [at instition I was at when I published first paper]
Christopher Cannam [likewise for second]
the latter two are entirely Authorship records, not Author records (since we have a 1-1 relationship between the purely nominal Author object and the User).