Field Details
Field name | Data type | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | Int | 17 | Yes | |
PROFILE_OPTION_ID | Int | 17 | Yes | |
LEVEL_ID | Int | 17 | Yes | |
LEVEL_VALUE | Int | 17 | Yes | |
LAST_UPDATE_DATE | DateTime | No | ||
LAST_UPDATED_BY | BigInt | 15 | No | |
CREATION_DATE | DateTime | 15 | No | yyyy-mm-dd hh:mi:ss:mmmm |
CREATED_BY | bigint | 15 | No | |
LAST_UPDATE_LOGIN | bigint | 15 | No | |
PROFILE_OPTION_VALUE | String | 240 | Yes | |
LEVEL_VALUE_APPLICATION_ID | bigint | 15 | Yes |
Note: The combination of APPLICATION_ID, PROFILE_OPTION_ID, LEVEL_ID,
LEVEL_VALUE and LEVEL_VALUE_APPLICATION_ID must be unique.