Difference between revisions of "Contact Table (Shared)"
m |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | __NOTOC__ | ||
| + | [[Category:Tables]] | ||
| + | {{Global Header}} | ||
| + | {{Global Announcement}} | ||
| + | |||
| + | == Overview == | ||
'''Logical Name:''' ca_contact | '''Logical Name:''' ca_contact | ||
| Line 37: | Line 43: | ||
| Physical || ca_contact.type => ca_contact_type.id | | Physical || ca_contact.type => ca_contact_type.id | ||
|} | |} | ||
| − | |||
{| align="center" border="1" cellpadding="4" cellspacing="0" style="text-align:left; width:90%" | {| align="center" border="1" cellpadding="4" cellspacing="0" style="text-align:left; width:90%" | ||
Latest revision as of 03:57, 27 July 2008
To discuss or ask questions about this article, select the discussion tab above.
Overview
Logical Name: ca_contact
Object Name: cnt
Physical Name: ca_contact
Description: Contact data that is shared among Unicenter applications. Contacts include customers, employees, analysts, vendors, and groups.
| Field | Layer | Relationship |
|---|---|---|
| Administrative Organization | Logical | ca_contact.admin_org => ca_organization.id |
| Object | cnt.admin_org => org.id | |
| Physical | ca_contact.admin_organization_uuid => ca_organization.organization_uuid | |
| Company | Logical | ca_contact.company => ca_cmpny.id |
| Object | cnt.company => org.id | |
| Physical | ca_contact.company_uuid => ca_company.id | |
| Type | Logical | ca_contact.type => ca_contact_type.id |
| Object | cnt.type => ctp.id | |
| Physical | ca_contact.type => ca_contact_type.id |
| Layer | Relationship |
|---|---|
| Logical |
Call_Req.assignee => ca_contact.id |
| Object |
chg.affected_contact => cnt.id |
| Physical |
call_req.assignee => ca_contact.id |
