Versions Compared

Old Version 10

changes.mady.by.user Sam Tsoi

Saved on

compared with

New Version 11

changes.mady.by.user Sam Tsoi

Saved on

Key

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

...

  1. ontology_create_user.sql
  2. ontology_create_tables.sql
  3. db_lookups.sql

 

ontology table access

 

 

Code Block
languagesql
themerdark
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')
;