Definition of table note-group

Table Description

Table Dump Name: note-crp

Alphabetical Field Summary

• 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
• description: (CHAR) Description of this note group
• note-group-id: (INTG) Internally assigned note group ID
• note-group-name: (CHAR) Name of this note group
• 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

• description: description
• note-group-id: (UNIQUE, PRIMARY) note-group-id
• note-group-name: note-group-name

Alphabetical Trigger Summary

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

Other tables who reference note-group

• note-code - Note Codes, one per note group
• site-note - Notes for a site

Detailed Alphabetical Field Listing

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

description Data type: CHARACTER
Format: x(32)
Help: Description of this note group
Attributes: Index Component

note-group-id Data type: INTEGER
Format: zzzzzzzzzzz9
Help: Internally assigned note group ID
Attributes: Index Component

note-group-name Data type: CHARACTER
Format: X(8)
Help: Name of this note group
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