Database update

[ReneRanzinger]

• datatype.description should be varchar(4000)
• metadata table add value_uri (varchar4000) and value_id (varchar255)
• new namespace table with namespaceid (serial), name (varchar255), dictionary (varchar4000). dictionary can be null
• datatype.namespace if foreign key to namespace table
• dataype add column multiple (boolean)

Default table values
Namespace:

• x, String, null
• x, Integer, null
• x, Double, null
• x, NCBI Taxonomy, https://www.ncbi.nlm.nih.gov/taxonomy
• x, Paper, null
• x, UBERON, http://purl.obolibrary.org/obo/uberon.owl
• x, Cellosaurus, https://www.cellosaurus.org/
• x, Disease, http://purl.obolibrary.org/obo/doid.owl
• x, Boolean, null
• x, Glycan Function, https://www.glygen.org/dictionary/glycan_function
• x, Experimental technique, https://www.glygen.org/dictionary/experimental_technique
• x, Human Phenotype, https://hpo.jax.org/app/
• x, BCO contributor, null

Category:

• x, GlyGen Glycomics Data, Metadata required for the data export into the GlyGen Glycomics Data format.

[senaarpinar]

changes are done

[senaarpinar]

@ReneRanzinger Do we have a list of default datatypes for GlyGen Glycomics Data category. Should we create some default datatypes at startup?

Also, the categories are user-specific, right? Do we need userid in datatype category table? What about GlyGen Glycomics Data category in such a case?

[ReneRanzinger]

This is the GlyGen format we want to export.

GlyGen format.docx

We need these columns and a "GlyGen Glycomics Data" category.

[senaarpinar]

@ReneRanzinger can you assign descriptions for each field