Table Description
Contact Phone Number: A phone number for a contact.
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::Core::Reference Model::Concern::Entity Objects::ContactPhoneNumber::ContactPhoneNumber
Controlling File: core\model\Packages\Concern\ContactPhoneNumber_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contactPhoneNumberIDkeynoUnique reference number assigned to the contact phone number.CONTACT_PHONE_NUMBER_ID SVR_INT64
contactIDdetailsnoUnique reference number assigned to the contact.CONTACT_ID SVR_INT64
phoneNumberIDdetailsnoUnique reference number assigned to the phone number.PHONE_NUMBER_ID SVR_INT64
typeCodedetails Code describing the type of phone number.PHONE_TYPE_CODEPhoneTypeSVR_STRING<10>
startDatedetails Start date of a phone number.CURAM_DATE SVR_DATE
endDatedetails End date of a phone number.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
ContactPhoneNumber.contactIDConcernRoleContact.contactID
ContactPhoneNumber.phoneNumberIDPhoneNumber.phoneNumberID
Indices (2)
Index NameAttributes
CtactPhoneNumIndexcontactID
IND__1534601814phoneNumberID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByContactIDnsmulti Returns a list of phone numbers used by a specified contactSQL
Related Pages (0)