This table maintains a catalog of folder fields.
Table 1. Folder field table (ARSFOLFLD)
| Column Name |
Data Type |
Description |
| fid |
INTEGER |
Folder identifier |
| field |
SMALLINT |
Folder field identifier |
| name |
VARCHAR(60) |
Folder field name |
| description |
VARCHAR(120) |
Folder field description |
| type |
CHAR(1) FOR BIT DATA (Db2®), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Folder field type |
| qual |
CHAR(1) FOR BIT DATA (Db2), BINARY(1) (SQL Server), RAW(1)
(Oracle) |
Folder field type qualifier |
| map_type |
SMALLINT |
Type of field mapping |
Table 2. Indexes for folder field table
(ARSFOLFLD)
| Index name |
Columns in index |
Type of index |
| arsfolfid_idx |
fid, field |
Unique cluster index for Db2; Unique index for Oracle and SQL Server |