Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.


Chapter 14 TIBCO iProcess Tables : dbs_fields

dbs_fields
The dbs_fields table holds the field definitions for every field in every installed iProcess table.
Structure
The dbs_fields table has the following structure:
TABLE dbs_fields (
node_id
INTEGER NOT NULL,
dbs_id INTEGER NOT NULL,
field_id INTEGER NOT NULL,
field_name VARCHAR(15) NOT NULL,
field_type VARCHAR(1) NOT NULL,
field_length SMALLINT NOT NULL,
field_decimals SMALLINT NOT NULL)
Field type: Either ASCII (A), Numeric (R), Date (D) or Time (T).
Primary Key
The following primary key is defined for this table.
Triggers
The following DELETE CASCADE trigger is defined for this table.
Indexes
The following indexes are defined for this table.
Table Activity
The dbs_fields table contains one row for each field in each installed TIBCO iProcess table.
Rows are added, updated and deleted in the following situations.
a Move System Information is performed, if the flag_table indicates that the Tables data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_dbs_fields table.
a Move System Information is performed, if the flag_table indicates that the Tables data area has been modified.
Note: The table is purged and rewritten using the values from the tsys_dbs_fields table.

Copyright © TIBCO Software Inc. All rights reserved.
Copyright © TIBCO Software Inc. All rights reserved.