Move accession column out of rnc_sequence_features, to work better with storing Rfam hits and corrects the representation of the features.
Rename rnc_sequence_features_id to rnc_sequence_feature_id. That name is weird and reads wrong
Rename start/stop to start_index/stop_index. I think we should start using something like _index or some other term to indicate that this is a zero based field
Renames the column upi to urs. We should use this id every where and this is just one step to that.
It's worth discussing if these are good ideas for our database.
This does several things:
Move accession column out of rnc_sequence_features, to work better with storing Rfam hits and corrects the representation of the features.
Rename rnc_sequence_features_id to rnc_sequence_feature_id. That name is weird and reads wrong
Rename start/stop to start_index/stop_index. I think we should start using something like _index or some other term to indicate that this is a zero based field
Renames the column upi to urs. We should use this id every where and this is just one step to that.
It's worth discussing if these are good ideas for our database.