Definition of table dev-request-vote

Table Description

Table Dump Name: dev-rvot

Alphabetical Field Summary

• comments: (CHAR)
• contact-id: (INTG) Internally assigned 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
• request-id: (INTG) Request these votes are associated with
• site-id: (INTG) Site this contacts vote is associated with
• 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
• vote-count: (INTG) Number of votes for this request

Alphabetical Index Summary

• request-by-contact: request-id, site-id, contact-id
• vote-by-contact: site-id, contact-id, vote-count
• vote-by-request: (PRIMARY) request-id, vote-count

Alphabetical Trigger Summary

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

Tables dev-request-vote references

• contact - Site Contacts
• dev-request - A request of development for resources to fix a bug and/or e
• site - Installed Sites

Detailed Alphabetical Field Listing

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

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

request-id Data type: INTEGER
Format: zzzzzzzzzzz9
Description: Request these votes are associated with
Attributes: Index Component

site-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Site this contacts vote is associated with
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

vote-count Data type: INTEGER
Format: z9 (Initial Value: 0)
Help: Number of votes for this request
Attributes: Index Component

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