ICMUT00301001 (Base text table)

Primary Key

(CompKey)

Indexes

Unique Index = (ItemID ascending, VersionID ascending)
Unique Index = (ItemID ascending, ComponentID ascending, 
                VersionID ascending)
For z/OS only:
Unique Index = (CompKey ascending)

Referential Constraints

Foreign key = (RMCode, SmsCollCode)
  references ICMSTCOLLNAME
    on delete restrict

Foreign key = MIMETYPEID
  references ICMSTMIMETYPES
    on delete restrict

Column Definitions

CompClusterID

This is reserved.

ComponentID

Current timestamp when the item was created. For the bit values, see Table 3.

This column cannot be updated by your application.

ItemID

Item identifier.

The value for ItemID is generated in the content manager that the application requests to create an item.

This column cannot be updated by your application. For details, see Table 2.

VersionID

The version ID of the item. Default is 1. If a new version is created, the VersionID is incremented by one.

ACLCode

The ACL code that the Item binds to. This column is replicated from Items table (ICMSTITEMSnnnsss) for performance reasons.

SemanticType

The semantic type of the item, which describes its basic classification. It can be used to indicate the kind of thing the item is; such as folder, document, resource, memo, picture, and contract.

For example, suppose you have a book that is available in both the English and the French language. You might set the SemanticType to be 'book' in the Items table. Then you could set the RepType (could be selected by user as an user defined attribute) in the Item Resources table to 'English' for the resource that represents the English version of the book and to 'French' for the resource that represents the French version of the book.

This field is set and interpreted by your application.

This field has set definitions that are used by the system. Your application can use these values with the defined meanings.

For the definitions, see Table 2.

CompKey

Concatenate ComponentID (18 bytes timestamp) and VersionID (5 digits number) to form a single column in order to support TIE's single column index.

This column cannot be updated by your application.

CreateTS

The timestamp when the entry was created.

CreateUserID

The user who created the entry.

LastChangedTS

The timestamp when the entry was last updated.

LastChangedUserID

The user who last updated the entry.

RMCode

A unique identifier of the resource manager where the BLOB is stored.

SmsCollCode

The systems management criteria used to manage the BLOB on resource manager storage.

Your application cannot update this field.

ResourceLength

The BLOB size in bytes.

Your application cannot update this field.

MIMETypeID

The MIME type of the resource. When you store an object, your application can update this field.

ObjectUpdated

The timestamp when the object was last updated.

ResourceFlag

The internal status of the resource.

Bit positions are counted from right to left. Counting starts with number 0, so the rightmost bit is bit number 0 and the leftmost bit is bit number 15. Flags using multiple bits are read from left to right within the bit positions they occupy. For example, if bits 0 and 1 are said to have the value 10, that indicates that bit 1 is 1 and bit 0 is 0.

The default value is CM Managed on and No Content on (0x00000006). Your application cannot update this field except as a side effect of other actions. For the bit settings, see Table 1.

XDOClassID

The XDO class ID. Your application provides this ID. The name and description are defined in the XDO Objects table.

ExtObjectName

The external object name.

For resources that are migrated from other image products and do not follow the Content Manager naming convention, the value is the original object name from the migrated products.

For resources that are not stored in an resource manager defined to the content manager, the value is any user-defined location specified by your application.

For z/OS®, the value is the object name stored in OAM.

ObjectCreated

The timestamp when the object was created.

OriFName

The object's original file name.