Table IWA_BusinessData

Business Data Objects as json

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true BusinessDataId VARCHAR 100 false
false Version BIGINT false Java Version is increased every time the ObjectValue is updated. It is used for optimistic locking.
false FormatVersion INTEGER false 63000 Version of the format in which the ObjectValue is written. Needed to use the correct deserializer version to read back the ObjectValue.
false ObjectType VARCHAR 255 false Full class name of the object that was serialized into ObjectValue
false ObjectValue CLOB false Java , MySql Serialized JSON formatted value of the business data object
false SecuritySystemId BIGINT false IWA_SecuritySystem(SecuritySystemId) References the security system this business data belongs to.
false CreatedAt DATETIME false
false CreatedByUserName VARCHAR 200 false
false CreatedByAppId BIGINT false
false ModifiedAt DATETIME false
false ModifiedByUserName VARCHAR 200 false
false ModifiedByAppId BIGINT false

Indexes

Name Columns Hints Comment
IWA_BusinessData_TypeIdx ObjectType
IWA_BusinessData_SecSysIdx SecuritySystemId
IWA_BusinessData_CrtdAtIdx CreatedAt
IWA_BusinessData_CrtdByUserIdx CreatedByUserName
IWA_BusinessData_CrtdByAppIdx CreatedByAppId
IWA_BusinessData_ModAtIdx ModifiedAt
IWA_BusinessData_ModByUserIdx ModifiedByUserName
IWA_BusinessData_ModByAppIdx ModifiedByAppId

Java

Object DataType FieldForOptimisticLocking
Version true
ObjectValue String

MySql

Object DataType
ObjectValue MEDIUMTEXT