Description
Folders for release records.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | RF_ID | The record ID. | int | 4 | |||
| RF_PARENT_ID | The RF_ID of the containing folder. The root folder's parent ID is -1. | int | 4 | ||||
| RF_NAME | The folder name. | varchar | 255 | ||||
| RF_VER_STAMP | The record version. | int | 4 |  | |||
| RF_DESCRIPTION | The description of the folder. | varchar | 16 | | |||
| RF_HAS_ATTACHMENTS | A value of Y indicates that the folder has attachments. | varchar | 1 | | |||
| RF_PATH | The highest level node has path AAA. Each child node down the tree inherits the parent path and adds three letters,where the current level numeration is concatenated to the inherited path. For example, the child requirements of the first node (AAA) have paths of AAAAAA, AAAAAB, AAAAAC, and so on. The characters V and W are not used. | varchar | 255 | ||||
| RF_USER_01 | User defined field. | varchar | 40 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| RF_PATH_IDX | | ||
| RF_PRIMARYKEY | | | |
| RF_UNIQUE_NAME_IDX | |
See Also