[GUSDEV] Regarding comment tables in the DoTS

[Jian Lu <jl...@vb...>]

Hi GUS folks,

I am new in GUS schema. This might not be a new question, but I just 
want to understand more about GUS. It would be great  if someone already 
has had answers.

I realize that there are different comment tables at DoTS:

COMMENTS (COMMENTS_ID, COMMENT_STRING, REVIEW_STATUS_ID, ...)

AACOMMENT (AA_COMMENT_ID, AA_SEQUENCE_ID, COMMENT_NAME_ID, 
COMMENT_STRING, ...)

NACOMMENT (NA_COMMENT_ID, NA_SEQUENCE_ID, COMMENT_STRING, ...)

They have all common attributes (comment_id and comment_string), and AA 
and NA groups have their associated sequence_ids. However, the 
differences are obvious that REVIEW_STATUS_ID only at the COMMENTS 
table, and COMMENT_NAME_ID only exists at the AACOMMENT table.

Also, there is a NAFEATURECOMMENT table associated with NAFEATUREIMP 
table. But there is no such table for AAFEATUREIMP.
If there would be comments on a feature, where should they go?

The reason I brought this issue is we are considering to use comment 
tables to store curation evidence and knowledge content, and we want to 
make our development consistent.

Thanks,

Jian Lu
VBI