| Project Data Tables Database > td Schema : td.FAVORITES Table |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| FAV_ID | The record ID. | int | 4 | |||
| FAV_PARENT_ID | The FAVORITE_FOLDERS.FF_ID of the folder that contains this item. | int | 4 | ||||
| FAV_NAME | The name of the item. | varchar | 255 | ||||
| FAV_FILTER_DATA | An XML string containing the filter. | varchar | 16 | ![]() | |||
| FAV_LAYOUT_DATA | An XML containing the display attributes. | varchar | 16 | ![]() | |||
| FAV_IS_PUBLIC | Y if the item is public. | varchar | 1 | ||||
| FAV_OWNER | For private items, user name of the user who created the item. | varchar | 60 | ||||
| FAV_MODULE | The ALM context of the item. | varchar | 50 | ||||
| FAV_VER_STAMP | The version number of this record. | int | 4 | ![]() | |||
| FAV_FORMAT_VERSION | For internal use by HP. | int | 4 | ||||
| FAV_WORKSPACE_DATA | For internal use by HP. | varchar | 16 | ![]() |
| Index | Description | Primary | Unique |
|---|---|---|---|
| FAVORITES_FORMAT_VER_IDX | |||
| FAVORITES_NAME_LWR_UK | ![]() | ||
| FAVORITES_PK | ![]() | ![]() |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
![]() | td.VF_FAVORITE_HAS_SHARES | View | 1 |