Definition of table site

Table Description

Table Dump Name: site

Alphabetical Field Summary

• comments: (CHAR)
• contact-id: (INTG) Sites Primary Contact ID
• 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-active: (LOGC) Is this an active site?
• site-addr[2]: (CHAR) Street Address for site
• site-city: (CHAR) Sites City
• site-domain: (CHAR) Domain name site is recognized by/as
• site-fax: (CHAR) Site's FAX # (if any)
• site-id: (INTG) Sites interally assigned ID
• site-name: (CHAR) Name of site
• site-phone: (CHAR) Sites Main Phone #
• site-shortname: (CHAR) Shorthand name for site (for browsers/listers)
• site-state: (CHAR) Sites State
• site-zip: (CHAR) Sites Zip/Postal code
• 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

Alphabetical Index Summary

• site-id: (UNIQUE, PRIMARY) site-id
• site-name: site-name

Alphabetical Trigger Summary

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

Other tables who reference site

• call-browse - Denormalized Call Log Browsing table
• call-log - Log of customer calls
• contact - Site Contacts
• course-pupil - (no description available)
• dev-request-vote - Tracking for development request votes
• site-note - Notes for a site
• site-product - Products Installed at a site
• site-www-access - Other sites this site can access for html

Tables site references

• contact - Site Contacts

Detailed Alphabetical Field Listing

contact-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Sites Primary Contact ID

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-active Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is this an active site?

site-addr Data type: CHARACTER (Extent: 2)
Format: x(32)
Help: Street Address for site

site-city Data type: CHARACTER
Format: x(32)
Help: Sites City

site-domain Data type: CHARACTER
Format: x(32)
Help: Domain name site is recognized by/as

site-fax Data type: CHARACTER
Format: (xxx) 999-9999
Help: Site's FAX # (if any)

site-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Sites interally assigned ID
Attributes: Index Component

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

site-phone Data type: CHARACTER
Format: (xxx) 999-9999
Help: Sites Main Phone #

site-shortname Data type: CHARACTER
Format: x(10)
Help: Shorthand name for site (for browsers/listers)

site-state Data type: CHARACTER
Format: !!
Help: Sites State

site-zip Data type: CHARACTER
Format: x(10)
Help: Sites Zip/Postal code

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

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