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.
Foreign Keys
The following foreign key is defined for this table.

1
This key enforces the DELETE CASCADE referential action.

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