Soarian Clinicals Schema Documentation
  Return to Table-Index

Table Name Table Comment
DdcPath Contains info about the unique path of the node in a document. Defines the relationship between the question and the answer.
Column Name Column Datatype Column Null Option Column Comment
DdcPath_OIDBIGINTNOT NULL Primary Key
PubSessionIdBIGINTNOT NULL Foreign Key(FK) into DdcPubSession
DisplayNameVARCHAR(255)NOT NULL Name of the display
ConceptIdPathVARCHAR(550)NOT NULL ConceptId path of the concept in a document.
LeafConceptIdVARCHAR(32)NOT NULL Leaf conceptID.(End of the path to the question or the answer.)
CreateDTimeDATETIMENOT NULL Created Date Time(wall clock)
LastCngDTimeDATETIMENOT NULL Last time row was changed(UTC)

Return to Table-Index

  Soarian Clinicals Schema Documentation  
Copyright © 2023, Oracle and/or its affiliates