Definition of table contact

Table Description

Table Dump Name: contact

Alphabetical Field Summary

• comments: (CHAR) Comments about contact
• contact-active: (LOGC) Is contact active?
• contact-addr[2]: (CHAR) Contacts street address
• contact-city: (CHAR) Contacts City
• contact-email: (CHAR) Contact's Email address, if any
• contact-fax: (CHAR) Contact's FAX #
• contact-id: (INTG) Internally assigned contact ID
• contact-name: (CHAR) Name of this contact
• contact-nickname: (CHAR) Nickname for contact (for Browsers/Listers)
• contact-phone: (CHAR) Contacts Phone #
• contact-state: (CHAR) Contacts State
• contact-zip: (CHAR) Contacts Zip/Postal Code
• cre-date: (DATE) Date of record creation
• cre-time: (CHAR) Time of record creation
• cre-user-name: (CHAR) Login name of user who created the record
• site-id: (INTG) Contacts site ID
• upd-date: (DATE) Date of records last modification
• upd-time: (CHAR) Time of records last modification
• upd-user-name: (CHAR) Login name of user who last modified the record
• web-user-name: (CHAR) User Name person uses for Web access

Alphabetical Index Summary

• contact-by-web-id: web-user-name, site-id, contact-id
• contact-id: (UNIQUE, PRIMARY) site-id, contact-id
• contact-name: site-id, contact-name

Alphabetical Trigger Summary

• CREATE: Overridable, Procedure is tr-c-con.p
• DELETE: Overridable, Procedure is tr-d-con.p
• WRITE: Overridable, Procedure is tr-u-con.p

Other tables who reference contact

• call-browse - Denormalized Call Log Browsing table
• call-event - One entry per event for a call
• dev-request-vote - Tracking for development request votes
• site - Installed Sites
• site-product - Products Installed at a site

Tables contact references

• site - Installed Sites

Detailed Alphabetical Field Listing

contact-active Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Is contact active?

contact-addr Data type: CHARACTER (Extent: 2)
Format: x(32)
Help: Contacts street address

contact-city Data type: CHARACTER
Format: x(20)
Help: Contacts City

contact-email Data type: CHARACTER
Format: x(32)
Help: Contact's Email address, if any

contact-fax Data type: CHARACTER
Format: (xxx) 999-9999 ~xxxxx
Help: Contact's FAX #

contact-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Internally assigned contact ID
Attributes: Index Component

contact-name Data type: CHARACTER
Format: x(32)
Help: Name of this contact
Attributes: Index Component

contact-nickname Data type: CHARACTER
Format: X(8)
Help: Nickname for contact (for Browsers/Listers)

contact-phone Data type: CHARACTER
Format: (xxx) 999-9999 ~xxxxx
Help: Contacts Phone #

contact-state Data type: CHARACTER
Format: !!
Help: Contacts State

contact-zip Data type: CHARACTER
Format: x(10)
Help: Contacts Zip/Postal Code

cre-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of record creation

cre-time Data type: CHARACTER
Format: X(8)
Description: Time of record creation

cre-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who created the record

site-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Contacts site ID
Attributes: Index Component

upd-date Data type: DATE
Format: 99/99/9999 (Initial Value: TODAY)
Description: Date of records last modification

upd-time Data type: CHARACTER
Format: X(8)
Description: Time of records last modification

upd-user-name Data type: CHARACTER
Format: x(16)
Description: Login name of user who last modified the record

web-user-name Data type: CHARACTER
Format: x(16)
Help: User Name person uses for Web access
Attributes: Index Component

Created on 04/03/2003 by DBHTML V1.1c