Table IWA_Blob

Blob Metadata

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
false BlobId BIGINT false Incremental ID (deprecated, use UUID)
true UUID VARCHAR 36 false Unique identifier
false ApplicationId BIGINT false IWA_Application(ApplicationId) ON DELETE CASCADE References to application to which this blob belongs to (deprecated, use SecuritySystemId)
false SecuritySystemId BIGINT false IWA_SecuritySystem(SecuritySystemId) References to security system to which this blob belongs to
false FileName VARCHAR 255 false Only the filename of this blob
false FilePath VARCHAR 750 false Relative file path of this blob (deprecated, use Path)
false Path VARCHAR 750 false Path of this document
false CreatorId VARCHAR 210 true IWA_SecurityMember(SecurityMemberId) Creator of this blob
false CreatedAt DATETIME false Creation timestamp
false Size BIGINT false Size in Bytes
false ModifierId VARCHAR 210 true IWA_SecurityMember(SecurityMemberId) Last user who has modified the blob
false ModifiedAt DATETIME false Last modification timestamp
false Description VARCHAR 1024 true Java User defined description

Constraints

Constraint Name Columns Hints Comment
UNIQUE IWA_Blob_BlobId BlobId
UNIQUE IWA_Blob_SecuritySystemPath SecuritySystemId , Path
UNIQUE IWA_Blob_ApplicationFilePath ApplicationId , FilePath

Indexes

Name Columns Hints Comment
IWA_Blob_FilePath FilePath
IWA_Blob_Path Path
IWA_Blob_CreatorId CreatorId
IWA_Blob_ModifierId ModifierId
IWA_Blob_CreatedAt CreatedAt
IWA_Blob_FileName FileName
IWA_Blob_ModifiedAt ModifiedAt
IWA_Blob_SecuritySystemId SecuritySystemId
IWA_Blob_ApplicationId ApplicationId

Java

Object BusinessClass DbDataClass QueryExecutorProviderClass Truncate
IWA_Blob ch.ivyteam.ivy.blob.storage.core.Blob ch.ivyteam.ivy.blob.storage.core.db.DbBlobData ch.ivyteam.ivy.blob.storage.core.impl.BlobQueryExecutorProvider
Description true

Cache

Object Strategy
IWA_Blob ALL_REMOVE_UNUSED