Ontology scripts
ontology_create_user.sql - Creates the shrine_ont user, for loading the SHRINE ontology
ontology_create_tables.sql - Creates shrine_ont, creates SHRINE, TABLE_ACCESS, and SCHEMES tables, and sets up schemas within tables.
DB_Lookups script to add ontology to i2b2hive
- ontology_create_user.sql
- ontology_create_tables.sql
- db_lookups.sql
ontology table access
INSERT into {{ shrine_i2b2_ont.schema }}.TABLE_ACCESS ( C_TABLE_CD, C_TABLE_NAME, C_PROTECTED_ACCESS, C_HLEVEL, C_NAME, C_FULLNAME, C_SYNONYM_CD, C_VISUALATTRIBUTES, C_TOOLTIP, C_FACTTABLECOLUMN, C_DIMTABLENAME, C_COLUMNNAME, C_COLUMNDATATYPE, C_DIMCODE, C_OPERATOR) values ( 'SHRINE', 'SHRINE', 'N', 0, 'SHRINE Ontology', '\SHRINE\', 'N', 'CA', 'SHRINE Ontology', 'concept_cd', 'concept_dimension', 'concept_path', 'T', '\SHRINE\', 'LIKE');
psql i2b2.i2b2metadata < script.sql
Overview
Content Tools