thehyve/transmart-core-db — pull request #12 by haarts (2014-01-30 16:03:28+00:00)
Title: Issues/uat 71 add uniprot name to annotations

Please take a careful look at this. I believe it is correct.

You'll notice some values for uniprotName being hard coded in the test data. This is intentional as these values are inserted during ETL.

I've also updated the [wiki page](https://wiki.thehyve.nl/display/SAN/Database+setup+for+new+datatypes) to reflect the new schema. In addition to this these are the queries I ran on CI to add the columns:
```
alter table deapp.de_protein_annotation add (uniprot_name VARCHAR2(200 CHAR));
comment on column deapp.de_protein_annotation.uniprot_name is 'UniProt name for this analyte.';
```
And for RBM:
```
alter table deapp.de_rbm_annotation add (uniprot_name VARCHAR2(200 CHAR));
comment on column deapp.de_rbm_annotation.uniprot_id is 'UniProtID for this analyte. Refers to the uniprot database (www.uniprot.org), which is loaded as a dictionary in the biomarker table.';
```