Relationship Diagram
Click the diagram to manipulate and zoom. Traverse the diagram using Click-and-Drag motions.
Model Details
Location in Model: Logical View::MetaModel::Curam::Advisor::Entity::AdviceCaseIssue::AdviceCaseIssue
Controlling File: Advisor\model\Packages\Entity\AdviceCaseIssue\AdviceCaseIssue.efx
Attributes (5)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
adviceCaseIssueIDkeynoThe key of the AdviceCaseIssue entity.ADVICE_CASE_ISSUE_ID SVR_INT64
adviceXMLResultIDdetailsnoThe foreign key link to the AdviceXMLResult entity.ADVICE_XML_RESULT_ID SVR_INT64
evidenceIDdetailsyesIdentifies the evidence which a piece of advice is being linked to. Used in conjunction with the evidenceType to identify the evidence record.EVIDENCE_ID SVR_INT64
evidenceTypedetailsyesThe type of evidence which a piece of advice is being linked to. Used in conjunction with the evidenceID to identify the evidence record.EVIDENCE_TYPE_CODEEvidenceTypeSVR_STRING<10>
caseIDdetailsyesThe case to which a piece of advice is being linked to.CASE_ID SVR_INT64
Foreign Keys (3)
ChildParent
AdviceCaseIssue.adviceXMLResultIDAdviceXMLResult.adviceXMLResultID
AdviceCaseIssue.caseIDCaseHeader.caseID
AdviceCaseIssueSuppression.adviceCaseIssueIDAdviceCaseIssue.adviceCaseIssueID
Indices (3)
Index NameAttributes
AdvIssCaseEvidIdxcaseID, evidenceType
AdviceIssueCaseIdxcaseID
IssueXMLResultIdxadviceXMLResultID
Operations (6)
OperationStereotypeOptionsDescriptionSQL
insertinsertAUTO_ID: adviceCaseIssueID
Standard Operation 
readread Standard Operation 
searchByAdviceXMLResultIDreadmulti   
removeByAdviceXMLResultIDnsremove   
searchByCaseIDreadmulti   
searchByCaseIDAndEvidenceTypereadmulti   
Related Pages (16)