Project Data Tables Database > td Schema : td.ANALYSIS_ITEM_RESULTS Table |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
AIR_ID | The record ID. | int | 4 | ||||
AIR_ANALYSIS_ITEM_ID | The graph whose result is stored in this record. | int | 4 | ||||
AIR_ANALYSIS_ITEM_VER_STAMP | The version number of this record. | int | 4 | ||||
AIR_RESULT_TYPE | The type. For example, Graph or ProjectReport. | varchar | 15 | ||||
AIR_CONTEXT_KEY | The context in which the result was generated. For example, users belonging to groups with different permission may see different results. | varchar | 36 | ||||
AIR_EXPIRATION_DATE | After this date, the data is not used and may be automatically purged. | datetime | 4 | ||||
AIR_RESULT_DATA_PATH | The location of the results in the repository. | varchar | 50 | ||||
AIR_DATA | The result data as a binary stream. | image | 16 |
Index | Description | Primary | Unique |
---|---|---|---|
ANALYSIS_ITEM_RESULTS_LWR_UIX | |||
ANALYSIS_ITEM_RESULTS_PK | |||
ANALYSIS_ITEM_RESULTS_UIX2 |