Page History

Versions Compared

Key

This line was added.
This line was removed.
Formatting was changed.

...

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')

;