DMRS_DESIGNS * Design_ID P * Design_OVID * Design_Name Date_Published Published_By * Persistence_Version Version_Comments
VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256) TIMESTAMP VARCHAR2 (80) NUMBER (5,2) VARCHAR2 (4000)
DMRS_DESIGNS_PK (Design_OVID) DESIGNS_PK_IDX (Design_OVID)
DMRS_DOMAINS P * Domain_ID * Domain_Name * OVID Synonyms * Logical_Type_ID F * Logical_Type_OVID T_Size T_Precision T_Scale Native_Type * LT_Name * DESIGN_ID F * Design_OVID * Design_Name DEFAULT_VALUE UNIT_OF_MEASURE Char_Units
DMRS_LOGICAL_TYPES
VARCHAR2 (70) VARCHAR2 (256) VARCHAR2 (36) VARCHAR2 (4000) VARCHAR2 (70) VARCHAR2 (36) NUMBER NUMBER NUMBER VARCHAR2 (60) VARCHAR2 (256) VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256) VARCHAR2 (256) VARCHAR2 (30) CHAR (4)
DMRS_LOGICAL_TO_NATIVE * F * * * F * *
DESIGN_ID Design_OVID Design_Name Logical_Type_ID Logical_Type_OVID LT_Name Native_Type * RDBMS_Type * RDBMS_Version Has_Size Has_Precision Has_Scale
VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256) VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256) VARCHAR2 (60) VARCHAR2 (60) VARCHAR2 (60) VARCHAR2 (1) VARCHAR2 (1) VARCHAR2 (1)
LOGICAL_TO_NATIVE_FK_IDX (Design_OVID) LOGICAL_TO_NATIVE_FK_IDXV1 (Logical_Type_OVID)
DMRS_DOMAINS_PK (Domain_ID) DOMAINS_PK_IDX (Domain_ID) DOMAINS_FK_IDX (Design_OVID) DOMAINS_FK_IDXV1 (Logical_Type_OVID) DMRS_NATIVE_TO_LOGICAL * RDBMS_Type * RDBMS_Version Native_Type * LT_Name * Logical_Type_ID F * Logical_Type_OVID * DESIGN_ID F * Design_OVID * DESIGN_NAME
DMRS_DOMAIN_AVT * F * * *
Domain_ID Domain_OVID Sequence Value Short_Description * Domain_Name * Design_OVID
VARCHAR2 (70) VARCHAR2 (70) NUMBER VARCHAR2 (256) VARCHAR2 (256) VARCHAR2 (256) VARCHAR2 (36)
VARCHAR2 (60) VARCHAR2 (60) VARCHAR2 (60) VARCHAR2 (256) VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256)
NATIVE_TO_LOGICAL_FK_IDX (Design_OVID) NATIVE_TO_LOGICAL_FK_IDXV1 (Logical_Type_OVID)
DOMAIN_AVT_FK_IDX (Domain_OVID)
DMRS_DOMAIN_VALUE_RANGES DMRS_DOMAIN_CHECK_CONSTRAINTS * F * * * * * *
Domain_ID Domain_OVID Sequence Text Database_Type Domain_Name Design_OVID
VARCHAR2 (70) VARCHAR2 (70) NUMBER VARCHAR2 (4000) VARCHAR2 (60) VARCHAR2 (256) VARCHAR2 (36)
DOMAIN_CHECK_CONSTR_FK_IDX (Domain_OVID)
* F * * *
Domain_ID Domain_OVID Sequence Begin_Value End_Value Short_Description * Domain_Name * Design_OVID
VARCHAR2 (70) VARCHAR2 (70) NUMBER VARCHAR2 (256) VARCHAR2 (256) VARCHAR2 (256) VARCHAR2 (256) VARCHAR2 (36)
DOMAIN_VALUE_RANGES_FK_IDX (Domain_OVID)
* F * * * P * *
DESIGN_ID Design_OVID Design_Name Logical_Type_ID OVID LT_Name
VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256) VARCHAR2 (70) VARCHAR2 (36) VARCHAR2 (256)
DMRS_LOGICAL_TYPES_PK (OVID) LOGICAL_TYPES_PK_IDX (OVID) LOGICAL_TYPES_FK_IDX (Design_OVID)