[GUSDEV] sres.author table

[Junmin L. <ju...@pc...>]

Hi, all
By looking at gus schema browser, I just realized that we have couple new 
tables in SRes: sres.author, sres.bibRefAuthor. I searched the GUS 
tracker to find the cause for this, but couldn't find any.

I have couple questions:
1. why we need this? what are the use cases? I understand the "authors" 
column in biblographRefernce may not be optimized, but I think 
practically it works well, even you want to search for authors.

2. what the difference between this author table and sres.contact table? 
Why we cann't use sres.contact table?

3. where is the documentation saying "when we use sres.contact and when 
we use sres.author"? I don't find any difference between these two, except 
the names.

4. please note in the FuGE uml model, or MAGE model, the developers simply 
user "authors" column too, and don't borther to create this author and 
linking table.

Thanks,
---junmin