Definition of table site-product

Table Description

Table Dump Name: site-prd

Alphabetical Field Summary

• comments: (CHAR) Comments regarding this sites installation of this product
• contact-id: (INTG) 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
• install-date: (DATE) Date of product installation
• installed: (LOGC) Is this product currently installed at this site?
• product-id: (INTG) Sites Product ID
• site-id: (INTG) Products Sites ID
• support-date: (DATE) Date Product was put under maintenance
• supported: (LOGC) Is this product under maintenance?
• 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
• version-id: (INTG) Installed version of the product at this site

Alphabetical Index Summary

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

Alphabetical Trigger Summary

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

Other tables who reference site-product

• call-browse - Denormalized Call Log Browsing table
• call-log - Log of customer calls
• component - Product Components
• dev-request - A request of development for resources to fix a bug and/or e
• product - (no description available)
• product-version - Version of the product

Tables site-product references

• contact - Site Contacts
• product - (no description available)
• product-version - Version of the product
• site - Installed Sites

Detailed Alphabetical Field Listing

contact-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: 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

install-date Data type: DATE
Format: 99/99/9999
Help: Date of product installation

installed Data type: LOGICAL
Format: Yes/No (Initial Value: No)
Help: Is this product currently installed at this site?

product-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Sites Product ID
Attributes: Index Component

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

support-date Data type: DATE
Format: 99/99/9999
Help: Date Product was put under maintenance

supported Data type: LOGICAL
Format: Yes/No (Initial Value: Yes)
Help: Is this product under maintenance?

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

version-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Installed version of the product at this site

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