Skip to main content


persistent class %UMLS.meta.MRREL extends %Library.Persistent

SQL Table Name: %UMLS_meta.MRREL

Related Concepts

Property Inventory


parameter UMLSVERSION = 2014AA;


property AUI1 as %String (MAXLEN = 16);
Unique identifier for first atom // MAXLEN = 9
Property methods: AUI1DisplayToLogical(), AUI1Get(), AUI1GetStored(), AUI1IsValid(), AUI1LogicalToDisplay(), AUI1LogicalToOdbc(), AUI1Normalize(), AUI1Set()
property AUI2 as %String (MAXLEN = 16);
Unique identifier for second atom // MAXLEN = 9
Property methods: AUI2DisplayToLogical(), AUI2Get(), AUI2GetStored(), AUI2IsValid(), AUI2LogicalToDisplay(), AUI2LogicalToOdbc(), AUI2Normalize(), AUI2Set()
property CUI1 as %String (MAXLEN = 8);
Unique identifier for first concept // MAXLEN = 8
Property methods: CUI1DisplayToLogical(), CUI1Get(), CUI1GetStored(), CUI1IsValid(), CUI1LogicalToDisplay(), CUI1LogicalToOdbc(), CUI1Normalize(), CUI1Set()
property CUI2 as %String (MAXLEN = 8);
Unique identifier for second concept // MAXLEN = 8
Property methods: CUI2DisplayToLogical(), CUI2Get(), CUI2GetStored(), CUI2IsValid(), CUI2LogicalToDisplay(), CUI2LogicalToOdbc(), CUI2Normalize(), CUI2Set()
property CVF as %String (MAXLEN = 1);
Content view flag // MAXLEN = 0
Property methods: CVFDisplayToLogical(), CVFGet(), CVFGetStored(), CVFIsValid(), CVFLogicalToDisplay(), CVFLogicalToOdbc(), CVFNormalize(), CVFSet()
property DIR as %String (MAXLEN = 1);
Source asserted directionality flag // MAXLEN = 1
Property methods: DIRDisplayToLogical(), DIRGet(), DIRGetStored(), DIRIsValid(), DIRLogicalToDisplay(), DIRLogicalToOdbc(), DIRNormalize(), DIRSet()
property REL as %String (MAXLEN = 4);
Relationship label // MAXLEN = 3
Property methods: RELDisplayToLogical(), RELGet(), RELGetStored(), RELIsValid(), RELLogicalToDisplay(), RELLogicalToOdbc(), RELNormalize(), RELSet()
property RELA as %String (MAXLEN = 64);
Additional relationship label // MAXLEN = 54
Property methods: RELADisplayToLogical(), RELAGet(), RELAGetStored(), RELAIsValid(), RELALogicalToDisplay(), RELALogicalToOdbc(), RELANormalize(), RELASet()
property RG as %String (MAXLEN = 4);
Relationship group // MAXLEN = 4
Property methods: RGDisplayToLogical(), RGGet(), RGGetStored(), RGIsValid(), RGLogicalToDisplay(), RGLogicalToOdbc(), RGNormalize(), RGSet()
property RUI as %String (MAXLEN = 16) [ Required ];
Unique identifier for relationship // MAXLEN = 10
Property methods: RUIDisplayToLogical(), RUIGet(), RUIGetStored(), RUIIsValid(), RUILogicalToDisplay(), RUILogicalToOdbc(), RUINormalize(), RUISet()
property SAB as %String (MAXLEN = 16);
Source abbreviation // MAXLEN = 15
Property methods: SABDisplayToLogical(), SABGet(), SABGetStored(), SABIsValid(), SABLogicalToDisplay(), SABLogicalToOdbc(), SABNormalize(), SABSet()
property SL as %String (MAXLEN = 16);
Source of relationship labels // MAXLEN = 15
Property methods: SLDisplayToLogical(), SLGet(), SLGetStored(), SLIsValid(), SLLogicalToDisplay(), SLLogicalToOdbc(), SLNormalize(), SLSet()
property SRUI as %String (MAXLEN = 64);
Source attributed relationship identifier // MAXLEN = 36
Property methods: SRUIDisplayToLogical(), SRUIGet(), SRUIGetStored(), SRUIIsValid(), SRUILogicalToDisplay(), SRUILogicalToOdbc(), SRUINormalize(), SRUISet()
property STYPE1 as %String (MAXLEN = 4);
The name of the column in MRCONSO.RRF that contains the first identifier to which the relationship is attached // MAXLEN = 4
Property methods: STYPE1DisplayToLogical(), STYPE1Get(), STYPE1GetStored(), STYPE1IsValid(), STYPE1LogicalToDisplay(), STYPE1LogicalToOdbc(), STYPE1Normalize(), STYPE1Set()
property STYPE2 as %String (MAXLEN = 4);
The name of the column in MRCONSO.RRF that contains the second identifier to which the relationship is attached // MAXLEN = 4
Property methods: STYPE2DisplayToLogical(), STYPE2Get(), STYPE2GetStored(), STYPE2IsValid(), STYPE2LogicalToDisplay(), STYPE2LogicalToOdbc(), STYPE2Normalize(), STYPE2Set()
property SUPPRESS as %String (MAXLEN = 1);
Suppressible flag // MAXLEN = 1
Property methods: SUPPRESSDisplayToLogical(), SUPPRESSGet(), SUPPRESSGetStored(), SUPPRESSIsValid(), SUPPRESSLogicalToDisplay(), SUPPRESSLogicalToOdbc(), SUPPRESSNormalize(), SUPPRESSSet()


index ($MRREL on ) [Extent, Type = bitmap];
index (AUI1RELAIdx on AUI1,RELA);
Index methods: AUI1RELAIdxExists()
index (AUI1RELIdx on AUI1,REL,RELA);
Index methods: AUI1RELIdxExists()
index (CUI1RELAIdx on CUI1,RELA);
Index methods: CUI1RELAIdxExists()
index (CUI1RELIdx on CUI1,REL,RELA);
Index methods: CUI1RELIdxExists()
index (IDKEY on ) [IdKey, Type = key];
Index methods: IDKEYCheck(), IDKEYDelete(), IDKEYExists(), IDKEYOpen(), IDKEYSQLCheckUnique(), IDKEYSQLExists(), IDKEYSQLFindPKeyByConstraint(), IDKEYSQLFindRowIDByConstraint()
index (RELAIdx on RELA) [Type = bitmap];
index (RELIdx on REL) [Type = bitmap];
index (XMRRELAUI1 on AUI1) [SqlName = X_MRREL_AUI1];
Index methods: XMRRELAUI1Exists()
index (XMRRELAUI2 on AUI2) [SqlName = X_MRREL_AUI2];
Index methods: XMRRELAUI2Exists()
index (XMRRELCUI1 on CUI1) [SqlName = X_MRREL_CUI1];
Index methods: XMRRELCUI1Exists()
index (XMRRELCUI2 on CUI2) [SqlName = X_MRREL_CUI2];
Index methods: XMRRELCUI2Exists()
index (XMRRELPK on RUI) [PrimaryKey, SqlName = X_MRREL_PK, Unique];
Index methods: XMRRELPKCheck(), XMRRELPKCheckUnique(), XMRRELPKDelete(), XMRRELPKExists(), XMRRELPKOpen(), XMRRELPKSQLCheckUnique(), XMRRELPKSQLExists(), XMRRELPKSQLFindPKeyByConstraint(), XMRRELPKSQLFindRowIDByConstraint()
index (XMRRELSAB on SAB) [SqlName = X_MRREL_SAB];
Index methods: XMRRELSABExists()

Inherited Members

Inherited Methods


Storage Model: CacheStorage (%UMLS.meta.MRREL)

FeedbackOpens in a new tab