This table contains the list of solutions. It includes the following:
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | varchar | 40 | No | Identifier; primary key. |
TITLE_EN | varchar | 1000 | Yes | Solution title. |
CLASS_ID | varchar | 40 | No | Foreign key to the KDW_SOLNCLASS_DIM.ID column. |
DATE_CREATED | datetime | No | Date and time the solution was created. | |
DATE_MODIFIED | datetime | Yes | Date and time the solution was last modified. | |
DATE_DELETED | datetime | Yes | Date and time the solution was deleted. | |
MODIFIED_BY_ID | varchar | 40 | Yes | User ID of the person who last modified the solution. Foreign key to the ARF_IU_USER.ID column. |
LAST_USE_DATE | timestamp | Yes | Date and time the solution was last used. | |
DELETED | one-digit | 1 | Yes | Indicates whether or not the solution has been deleted. |
STATUS_ID | varchar | 40 | No | Foreign key to the KDW_SOLNSTATUS_DIM.ID column. |
OWNING_GROUP_ID | varchar | 40 | Yes | Foreign key to the KDW_OWNGROUP_DIM.ID column. |
PROFILE_ID | varchar | 40 | No | Foreign key to the ARF_IU_USER.ID column. |
BEST_BET | one-digit | 1 | No | Indicates whether or not the solution is a Best Bet. |
LANGUAGE_ID | varchar | 40 | No | Foreign key to the SDW_LANG_DIM.ID column. |
USE_COUNT | integer | Yes | Use count property for solution. |