Table Description
Contact Email Address: An email address 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::ContactEmailAddress::ContactEmailAddress
Controlling File: core\model\Packages\Concern\ContactEmailAddress_cat.efx
Table Options
ALLOW_OPTIMISTIC_LOCKINGyes
Attributes (6)
AttributeStereotypeNullableDescriptionDomain DefinitionCodetableDDL Type
contactEmailAddressIDkeynoUnique reference number assigned to the contact email addressCONTACT_EMAIL_ADDRESS_ID SVR_INT64
contactIDdetailsnoUnique reference number assigned to the contact.CONTACT_ID SVR_INT64
emailAddressIDdetailsnoUnique reference number assigned to the email address.EMAIL_ADDRESS_ID SVR_INT64
typeCodedetails Code describing the type of email address.EMAIL_TYPE_CODEEmailTypeSVR_STRING<10>
startDatedetails Start date of an email address.CURAM_DATE SVR_DATE
endDatedetails End date of an email address.CURAM_DATE SVR_DATE
Foreign Keys (2)
ChildParent
ContactEmailAddress.contactIDConcernRoleContact.contactID
ContactEmailAddress.emailAddressIDEmailAddress.emailAddressID
Indices (2)
Index NameAttributes
IND__843685228contactID
IND__521449958emailAddressID
Operations (4)
OperationStereotypeOptionsDescriptionSQL
insertinsert Standard Operation 
readread Standard Operation 
modifymodifyOPTIMISTIC_LOCKING: yes
Standard Operation 
searchByContactIDnsmulti retrieves a list of contact email addresses for a contact.SQL
Related Pages (0)