Share this page
ALM Project Database Reference
td.LIBRARIES Table
Description
Libraries.
Columns
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LIB_ID | The record ID. | int | 4 | |||
| LIB_PARENT_ID | The record ID of the folder that contains this item. | int | 4 | ||||
| LIB_NAME | The name of the item. | varchar | 255 | ||||
| LIB_VER_STAMP | The version number of this record. | int | 4 |  | |||
| LIB_DESCRIPTION | A free text description of this item. | varchar | 16 | | |||
| LIB_HAS_ATTACHMENTS | Y if this item has attachments. | varchar | 1 | | |||
| LIB_TYPE | 1 - Imported library 2 - Exported library | int | 4 | ||||
| LIB_CFR_PROJECT_UID | The unique ID of the project from which this library was imported. | varchar | 36 | | |||
| LIB_CFR_LIBRARY_ORIGNAME | The name of the library from which this library was imported. | varchar | 255 | | |||
| LIB_CFR_LIBRARY_ID | The LIB_ID of the library from which this library was imported. | int | 4 | | |||
| LIB_CFR_LAST_SYNC_DATE | The date of the last synchronization according to the server clock. | datetime | 4 | | |||
| LIB_CFR_CREATED_BY | The user name who created the library from which this library was imported. Applies only to imported libraries. | varchar | 60 | | |||
| LIB_CREATED_BY | The user name of the user who created this item. | varchar | 60 | | |||
| LIB_CREATION_DATE | The server date when this item was created. | datetime | 4 | | |||
| LIB_ASYNCH_STATUS | One of the following codes:
| int | 4 | | |||
| LIB_CFR_BASELINE_ORIGNAME | The name of the baseline from which the library was created. | varchar | 255 | | |||
| LIB_CFR_BASELINE_ID | The BASELINES.BL_ID of the baseline from which the library was created. | int | 4 | | |||
| LIB_CFR_DOMAIN_NAME | The domain that contains the project from which this library was imported. | varchar | 255 | | |||
| LIB_CFR_PROJECT_NAME | The project from which this library was imported. | varchar | 255 | | |||
| LIB_LAST_SYNC_TO_BASELINE_ID | If the library has been synchronized, the BASELINES.BL_ID to which the library was synchronizes. | int | 4 | | |||
| LIB_AUTOCOMPLETE_TYPE | 1 indicates that the covering tests are automatically added to the library. | int | 4 | | |||
| LIB_USER_01 | User-defined field. | varchar | 40 | |
Indexes
| Index | Description | Primary | Unique |
|---|---|---|---|
| LIB_PRIMARYKEY | | | |
| LIB_UNIQUE_NAME_IDX | |
See Also
Related Objects
