Page History
...
- ontology_create_user.sql
- ontology_create_tables.sql
- db_lookups.sql
ontology table access
Code Block | ||||
---|---|---|---|---|
| ||||
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