Definition of table component

Table Description

Table Dump Name: componen

Alphabetical Field Summary

• comments: (CHAR) Comments about this component
• component-description: (CHAR) Descrption of this component
• component-id: (INTG) Internally assigned component ID
• component-shortname: (CHAR) Shorthand name for compnent (for browsers, usually the objec
• 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
• product-id: (INTG) Components Product ID 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

• component-description: product-id, component-description
• component-id: (UNIQUE, PRIMARY) product-id, component-id

Alphabetical Trigger Summary

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

Other tables who reference component

• call-browse - Denormalized Call Log Browsing table
• call-log - Log of customer calls
• dev-request - A request of development for resources to fix a bug and/or e

Tables component references

• product - (no description available)
• site-product - Products Installed at a site

Detailed Alphabetical Field Listing

component-description Data type: CHARACTER
Format: x(32)
Help: Descrption of this component
Attributes: Index Component

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

component-shortname Data type: CHARACTER
Format: X(8)
Help: Shorthand name for compnent (for browsers, usually the objec

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

product-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Components Product ID code
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

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