|
|
|
|
The Table Versions table contains an entry for each database table in the system, including itself. Each entry contains a name and description of the table, its current version and the data-time the version last changed.
Structure name: tblVersions_t. Table base file name: Versions. Table define:TBL_VERSIONS.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| tv_TableID | Unique | 0 to TBL_COUNT-1 | WORD | Table ID number. Used by PICS applications to specify SDB tables in data requests. |
| tv_Version | Any | DWORD | Table Version. Should be updated every time any content in this table has changed. Used by programs to determine if their cached copies are out of date. | |
| tv_Time | millisecond in a day | DWORD | Time of the last version update. Used for record keeping only. | |
| tv_Date | Any | WORD | Date of the last version update. Used for record keeping only. | |
| tv_Name | Yes |
Pointname Characters
|
CHAR(16) | Table Name. Used for record reporting only. |
| tv_Desc | Description Characters | CHAR(256) | Table Description. Used for record reporting only. |
The Display Sets table contains an entry for each display set. Each entry contains a name and description of the set. This table is currently unused by any application in PICS.
Structure name: dispSet_t. Table base file name: dispsets. Table define:TBL_DISPSET.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| ds_Mask | Unique |
Any
|
DWORD | A bit mask that may be used to determine when a point is to be displayed (or printed, or logged, etc). This feature is not currently used by any PICS applications. Links from pnt_SetMask. |
| ds_Revision | Any | WORD | Current revision of this record. | |
| ds_TableRevision | Any | DWORD | Current table version, when this record was last updated. | |
| ds_name | Pointname Characters | CHAR(16) | Name of this display set | |
| ds_Desc | Description Characters | CHAR(128) | Description of this display set |
The PICS colors table contains an entry for each user defined color. This table is intended for use by display applications to provide a common coloring scheme for alarm limits, display colors for points, and color selections for various elements of displays. Each entry contains data to produce one of the standard 16 colors of yesteryear or a full rgb description for 24-bit color.
Structure name: picscolor_t. Table base file name: picscolr. Table define:TBL_PICSCOLOR.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| pc_Level | Unique |
1 to 32767
|
SHORT | Alarm level or other color identifier. Links from pnt_Display_Color, but is used and saved internally by various programs for reasons other then displaying a point. |
| pc_Revision | Any | WORD | Current revision of this record. | |
| pc_TableRevision | Any | DWORD | Current table version, when this record was last updated. | |
| pc_useRGB | 0 or 1 | WORD | When non-zero, this indicates that the RGB triple (alc_rgb) from this record in to be used. When zero, the standard color value (alc_color) will be used. | |
| pc_color | 0 to 15 | WORD | Standard color value (0..15) | |
| pc_rgb | 0 to 255 | WORD(3) | RGB triple defining a custom color. This is a three element array with each element storing a color level from 0..255 for (in order) red, blue and green. | |
| pc_comment | Description Characters | CHAR(32) | Description of this color, what it is used for, etc. |
The Message table contains an entry for each defined message. Each entry contains display text when this message id is specified. Currently, this table is not used by any program in PICS.
Structure name: msgTable_t. Table base file name: message. Table define:TBL_MESSAGES.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| mt_MsgId | Unique | 1 to 65535 | WORD | The message id. Links from many tables. All the field names which link to this table end with _Msg. |
| mt_Revision | Any | WORD | Current revision of this record. | |
| mt_TableRevision | Any | DWORD | Current table version, when this record was last updated. | |
| mt_msgText | TBD | CHAR(256) | Text to be displayed. Note that this text may contain escape sequences which need to be interpreted. |
The Curve table contains an entry for each defined static curve. Each entry contains display text when this message id is specified. Currently, this table is not used by any program in PICS.
Structure name: curve_t. Table base file name: curves. Table define:TBL_CURVES.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| crv_id | Unique |
0 to 32767
|
SHORT | Curve ID number. Not linked from or to any other database field. A program which using a curve must remember the specific ids it requires. |
| crv_Legend | Unique |
Text
|
CHAR(8) | Legend text, for display with the curve. |
| crv_name | Yes | Text | CHAR(32) | Curve name |
| crv_Revision | Any | WORD | Current revision of this record. | |
| crv_TableRevision | Any | DWORD | Current table version, when this record was last updated. | |
| crv_smooth | 0 | SHORT | Number of intermediate points to generate between two explicite points using a curve fitting algorithm. (Not implemented) | |
| crv_numPoints | 1 to 100 | SHORT | Number of coordinate pairs in the curve | |
| crv_width | 0 to 3 | SHORT | Width of the lines used to render the curve | |
| crv_color | 0 to 32767 | SHORT | Color of the curve. Links to pc_Level. | |
| crv_x | Any | FLOAT(100) | A 100 element array of X coordinates (crv_numPoints determines how many are actually used) | |
| crv_y | Any | FLOAT(100) | A 100 element array of Y coordinates (crv_numPoints determines how many are actually used) |
|
|
|
|