Object Store Table Schemas
Important:
- Content Engine database table schemas are provided for informational purposes only. Do not attempt to directly modify the contents of a Content Engine database. Such action can result in a corrupted system and is not supported. Use of database triggers, functions, or other runtime procedural code is likewise unsupported on Content Engine tables.
- Database table schemas are subject to change with or without notice.
- Information is intentionally restricted for columns that are described as a composite of multiple items (for example, Annotation.component_types).
The following table describes the database table schemas for an object store. Database tables that map directly to a persistable class store information about the state of each persistable object that is instantiated from that class. The database tables that do not map directly to a class are reserved for internal use by the Content Engine server.
Tables in an object store database have a corresponding TableDefinition object, from which you can retrieve much of the schema information that is presented.
The set of database tables that are described are created for one object store. If multiple object stores share a database connection, then there is a separate set of tables in the database for each object store that shares the connection. To distinguish identical table names between object stores, the table names are prefixed with a unique schema name.
The schemas are based on the 5.5.x version of the Content Engine server, with no addons installed. Some column names correspond with system properties created at object store initialization time. Column sizes are shown for the Db2® database system. Column size is expressed in bytes, except for the STRING type, which is expressed as the character size. On Db2, the STRING byte size is 2X the character size. To see column sizes for other database systems, see Column Size Vendor Differences.
Index of Database Tables
| Table Name | Object Type |
|---|---|
| AddOnRecord | AddOnInstallationRecord |
| AE1 | No direct mapping to a Content Engine class. |
| AliasId | IdList |
| Annotation | Annotation |
| AuditDefinition | AuditDefinition |
| AuditPolicy | CmAuditDispositionPolicy |
| AuditProcessing | CmAuditProcessingBookmark |
| ClassDefinition | ClassDefinition and its subclasses
(DocumentClassDefinition, EventClassDefinition,
ReplicableClassDefinition, SubscribableClassDefinition,
VersionableClassDefinition) |
| ColumnDefinition | ColumnDefinition |
| ColumnDefinition | No direct mapping to a Content Engine class. |
| ComponentRelation | ComponentRelationship |
| Container | Folder |
| Content | No direct mapping to a Content Engine class. |
| ContentBackoutQueue | CmContentBackoutQueueEntry |
| ContentDeletionQueue | CmContentDeletionQueueEntry |
| ContentQueue | No direct mapping to a Content Engine class. |
| ContentReplicationQueue | CmContentReplicationQueueEntry |
| ContentSearch | ContentSearch |
| ContentUpload | No direct mapping to a Content Engine class. |
| ConversionSettings | CmContentConversionSettings and its subclass
(CmTextExtractionSettings) |
| Cvl | ChoiceList |
| CvlElement | Choice |
| DDState | No direct mapping to a Content Engine class. |
| DeviceConnection | CmStorageDeviceConnection |
| DocumentState | DocumentState |
| DocVersion | Document and its subclasses (WorkflowDefinition,
XMLPropertyMappingScript), VersionSeries |
| Event | Event and its subclasses |
| ExternalAlias | ExternalAlias and its subclasses (ExternalClassAlias,
ExternalPropertyAlias) |
| ExternalIdentity | ExternalIdentity |
| Generic | CustomObject |
| GlobalPropAliasId | IdList |
| GlobalPropertyDef | PropertyTemplate and its subclasses
(PropertyTemplateBinary, PropertyTemplateBoolean,
PropertyTemplateDateTime, PropertyTemplateFloat64,
PropertyTemplateId, PropertyTemplateInteger32,
PropertyTemplateObject, PropertyTemplateString) |
| HierarchyIndex | No direct mapping to a Content Engine class. |
| HoldObject | CmHold |
| HoldRelationship | CmHoldRelationship |
| IndexArea | IndexArea and its subclasses (CmTextSearchIndexArea,
VerityIndexArea) |
| IndexDefinition | CmIndexDefinition |
| IndexedColumn | CmIndexedColumn |
| IndexJob | IndexJob |
| IndexJobItem | IndexJobItem and its subclasses (IndexJobClassItem,
IndexJobCollectionItem, IndexJobSingleItem) |
| IndexRequests | CmVerityIndexRequest, CmTextSearchIndexRequest |
| Link | Link |
| ListOfBinary | No direct mapping to a Content Engine class. |
| ListOfBoolean | No direct mapping to a Content Engine class. |
| ListOfDateTime | No direct mapping to a Content Engine class. |
| ListOfFloat64 | No direct mapping to a Content Engine class. |
| ListOfId | No direct mapping to a Content Engine class. |
| ListOfInteger32 | No direct mapping to a Content Engine class. |
| ListOfString | No direct mapping to a Content Engine class. |
| LocalizedString | LocalizedString |
| PreprocessorDefinition | ChangePreprocessorDefinition |
| PropertyDefinition | PropertyDefinition and its subclasses
(PropertyDefinitionBinary, PropertyDefinitionBoolean,
PropertyDefinitionDateTime, PropertyDefinitionFloat64,
PropertyDefinitionId, PropertyDefinitionInteger32,
PropertyDefinitionObject, PropertyDefinitionString) |
| QueueItem | QueueItem and its subclasses (AsyncUpgradeQueueItem,
DocumentClassificationQueueItem, EventQueueItem,
SecurityPropagationQueueItem) |
| RecoveryBin | CmRecoveryBin |
| RecoveryItem | CmRecoveryItem |
| Relationship | DynamicReferentialContainmentRelationship,
ReferentialContainmentRelationship |
| ReplicationQueue | ReplicationJournalEntry |
| RoleAccessDef | CmRoleAccessDefinition |
| RoleCacheUSN | No direct mapping to a Content Engine class. |
| RoleObject | CmRole and its subclasses |
| ScfData | No direct mapping to a Content Engine class. |
| SecurityDesc | No direct mapping to a Content Engine class. |
| SecurityPolicy | SecurityPolicy |
| SecurityTemplate | SecurityTemplate and its subclasses
(ApplicationSecurityTemplate, VersioningSecurityTemplate) |
| SidToGuid | No direct mapping to a Content Engine class. |
| SiteSettings | SiteSettings and its subclasses (CenteraSiteSettings,
CFSSiteSettings, CmReplicaSynchronizationSiteSettings, ImageServicesSiteSettings) |
| StorageClass | StorageArea and its subclasses (CmAdvancedStorageArea,
DatabaseStorageArea, FileStorageArea, FixedStorageArea),
StoragePolicy |
| StorageDevice | CmStorageDevice and its subclasses (CmCustomStorageDevice,
CmFileSystemStorageDevice, CmSecuredStorageDevice) |
| SubscribedEvent | SubscribedEvent |
| Subscription | DocumentClassificationAction, DocumentLifecycleAction,
DocumentLifecyclePolicy, EventAction and its subclasses
(WorkflowEventAction), Subscription and its subclasses
(ClassSubscription, ClassWorkflowSubscription,
InstanceSubscription, InstanceWorkflowSubscription) |
| Sweep | CmSweep and its subclasses (CmBackgroundSearch,
CmBulkMoveContentJob, CmContentBackoutQueueSweep, CmContentDeletionQueueSweep,
CmContentReplicationQueueSweep, CmCustomQueueSweep, CmCustomSweepJob, CmPolicyControlledSweep,
CmQueueSweep, CmRetentionUpdateJob, CmSweepJob, CmThumbnailGenerationJob,
CmThumbnailRequestSweep) |
| SweepPolicy | CmSweepPolicy and its subclasses (CmContentMigrationPolicy,
CmCustomSweepPolicy, CmDisposalPolicy, CmRetentionUpdatePolicy) |
| SweepRelationship | CmSweepRelationship and its subclass
(CmSweepPolicyRelationship) |
| SweepResult | CmSweepResult and its subclasses (CmPolicySweepResult,
CmJobSweepResult) |
| TableDefinition | TableDefinition |
| Task | CmTask |
| TaskRelationship | CmTaskRelationship |
| TextIndex | CmTextSearchIndex |
| TextIndexPartition | CmTextSearchPartitionProperty |
| Thumbnail | CmThumbnail |
| ThumbnailRequest | CmThumbnailRequest |
| Timeslot | CmTimeslot |
| Upgrade | No direct mapping to a Content Engine class. |
AddOnRecord Table
Used by class: AddOnInstallationRecord
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the object store into which this AddOn was installed. |
| parent_prop_id | GUID |
16 | false | The AddOnInstallationRecords property on object store, in which this entry can be found. |
| ordinal | INTEGER |
4 | false | Identifies the position of this item relative to others in the same list of items. |
| parent_id_class | GUID | 16 | true | Identifies the ID of the parent class. |
| installer | STRING |
80 | true | Used by property: Installer |
| install_date | DATE |
10 | true | Used by property: InstallationDate |
| install_status | INTEGER |
4 | true | Used by property: InstallationStatus |
| install_report | CLOB |
512 M | true | Used by property: InstallationReport |
| addon_id | OBJECT |
16 | true | The ID of the addon. |
AE1 Table
Used internally by the server, this is the Area Element table for an Advanced Storage Area. A new table is created for each Advanced Storage Area, that is AE1 for the first area created, AE2 for the second area created, and so on.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| content_sig | BINARY |
N | false | Computed hash of the content used for de-duplication. |
| object_id | GUID |
16 | false | Used by property: Id Unique identifier for the content item, also known as the upload ID. Each content item stored by Content Platform Engine has a unique content ID. The content ID can be referenced by multiple documents when de-duplication is in use. |
| hash_sequence | BINARY |
8 | false | A value extracted from the object_Id that is used by the file system storage device to control how files are distributed across the directory structure. |
| batch_id | GUID |
16 | false | ID of the batch of generated content ids (a batch is always generated for a single advanced storage area), used by abandoned content cleanup. |
| content_hash | BINARY |
36 | true | Computed hash of the content used for content validation. |
| refcount | INTEGER |
4 | true | The number of content items (for a given advanced storage area) that reference this content, note that this unrelated to how many replicas the content is stored in. |
| scf_data | BINARY |
32 | true | Cryptographic nonce that is used when content encryption is enabled |
| compressed_size | INTEGER |
8 | true | Size of the content when compressed. |
| deletion_time | DATE |
10 | true | Time the content was deleted (null indicates content has not yet been deleted). |
| content_size | INTEGER |
8 | false | The size of the content (if the content is compressed, this will be the compressed size, not the uncompressed size). |
| sync_replicas | BINARY |
192 | false | Serialized set of synchronous replicas that the content was originally uploaded to (used during replication). |
| ref_object_id | GUID |
16 | false | Object Id of the parent Document or Annotation. |
| content_identity | BLOB |
1G | true | For storage devices that generate the id (not currently used). |
AliasId Table
Used by classes: ClassDefinition, PropertyDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| alias_id | GUID |
16 | false | Identifies the class or property to which this ClassDefinition or PropertyDefinition is aliased depending on whether it is a ClassDefinition.AliasIds or PropertyDefinition.AliasIds value. |
| class_id | GUID |
16 | false | Identifies the class of object that is being aliased. If the aliased object is a class definition, this object identifies the class definition itself, otherwise this value identifies the class definition of the aliased property definition. This value corresponds to the object_id column of the ClassDefinition table. |
Annotation Table
Used by class: Annotation
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | GUID |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| storage_class | OBJECT |
16 | true | Used by property: StoragePolicy |
| content_size | DOUBLE |
8 | true | Used by property: ContentSize |
| annotated_id | GUID |
16 | false | Used by property: AnnotatedObject |
| annotated_id_class | GUID |
16 | true | Indirectly identifies the class of the object that is being annotated by the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| annotated_element | INTEGER |
4 | true | Used by property: AnnotatedContentElement |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| storage_location | STRING |
1 | true | Used by property: StorageLocation |
| component_types | BINARY |
100 | true | An encoded string that lists the MIME types of each content element that is associated with the document. Each string is preceded by its length in bytes and the repeat count. |
| retrieval_names | BINARY |
200 | true | Maps indirectly to the Retrieval Name property on the Content Transfer objects that are associated with the Annotation represented by a single row in this table |
| component_types_2 | BLOB |
1G | true | A continuation of the component_types string if it exceeds the column length provided. |
| retrieval_names_2 | BLOB |
1G | true | Contains the overflow from the retrieval_names column when the number of bytes required for the retrieval names of all the content transfer objects exceeds the maximum that is allowed by the retrieval_names column. |
| mime_type | STRING |
96 | true | Used by property: MimeType |
| content_info | BINARY |
96 | true | This column is overloaded to serve multiple purposes. In general, it contains serialized data that is related to the content elements associated with the annotation represented by a single row in this table. The nature of the data depends on whether the content element is a content transfer or a content reference and whether it is federated. It also depends on whether either (or both) of the content encryption or content single instance storage features are enabled. For each content element associated with this annotation, the possible serialized data includes the sequence number, size, signature, key index, nonce, refcountKey, and a Boolean that indicates whether the content element is a content transfer, a content reference, or federated. |
| content_info_2 | BLOB |
1G | true | Contains the overflow from content_info. |
| next_content_unique_id | INTEGER |
4 | true | Contains an integer value that will be used as the sequence number for the next content element added to this Annotation |
| content_last_accessed_date | DATE |
10 | true | Used by property: DateContentLastAccessed |
| storage_area_id | OBJECT |
16 | true | Used by property: StorageArea |
| indexation_id | GUID |
16 | true | Used by property: IndexationId |
| index_failure_code | INTEGER |
4 | true | Used by property: CmIndexingFailureCode |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| retention_date | DATE |
10 | true | Used by property: CmRetentionDate |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
AuditDefinition Table
Used by class: AuditDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| event_class_id | OBJECT |
16 | false | Used by property: EventClass |
| audit_success | BOOLEAN |
2 | false | Used by property: AuditSuccess |
| audit_failure | BOOLEAN |
2 | false | Used by property: AuditFailure |
| include_subclasses | BOOLEAN |
2 | false | Used by property: IncludeSubclassesRequested |
| recording_level | INTEGER |
4 | true | Used by property: ObjectStateRecordingLevel |
| filter_expression | CLOB |
512 M | true | Used by property: FilterExpression |
| filtered_property_name | STRING |
64 | true | Used by property: FilteredPropertyId |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| enabled_bool | BOOLEAN |
2 | true | Used by property: IsEnabled |
AuditPolicy Table
Used by class: CmAuditDispositionPolicy
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| disposition_rule | STRING |
255 | true | Used by property: DispositionRule |
| enabled_bool | BOOLEAN |
2 | false | Used by property: IsEnabled |
| completion_wait_interval | INTEGER |
4 | true | Used by property: CompletionWaitInterval |
AuditProcessing Table
Used by class: CmAuditProcessingBookmark
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| last_processed | DOUBLE |
8 | false | Used by property: LastProcessed |
ClassDefinition Table
Used by classes: CmQueueEntryClassDefinition, ReplicableClassDefinition, VersionableClassDefinition, ClassDefinition, DocumentClassDefinition, CmConversionSettingsClassDefinition, SubscribableClassDefinition, EventClassDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| superclass_id | OBJECT |
16 | true | Used by property: SuperclassDefinition |
| root_class_id | GUID |
16 | false | Identifies the root class definition of this class definition. If the class definition is already the root class, this value matches object_id. For subclass definitions, this value points at the top-most class definition of this class definition's hierarchy. |
| sup_user_instances | BOOLEAN |
2 | false | Used by property: AllowsInstances |
| persistent_bool | BOOLEAN |
2 | false | Used by property: IsPersistent |
| sys_owned_bool | BOOLEAN |
2 | false | Used by property: IsSystemOwned |
| table_id | OBJECT |
16 | true | Used by property: TableDefinition |
| sup_user_subclasses | BOOLEAN |
2 | false | Used by property: AllowsSubclasses |
| default_instance_security_id | GUID |
16 | false | Indirectly identifies the default instance permissions that are used during the creation of instances of objects of this class. This value corresponds to the security_id column of the SecurityDesc table. |
| sup_user_props | BOOLEAN |
2 | false | Used by property: AllowsPropertyAdditions |
| symbolic_name | STRING |
64 | true | Used by property: SymbolicName |
| is_hidden | BOOLEAN |
2 | true | Used by property: IsHidden |
| is_cbr_enabled | BOOLEAN |
2 | true | Used by property: IsCBREnabled |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| addon_id | GUID |
16 | true | Used by property: InstalledByAddOn |
| retention_period | INTEGER |
4 | true | Used by property: DefaultRetentionPeriod |
| retention_units | INTEGER |
4 | true | Used by property: RetentionPeriodUnits |
| action_id | GUID |
16 | true | Stores the object id of the object referenced by CmRoleClassDefinition.RoleMembershipAction. |
ColumnDefinition Table
Used by class: ColumnDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| dbg_table_name | STRING |
30 | true | Contains the table name that contains this column. |
| column_name | STRING |
30 | false | Used by property: ColumnName |
| column_datatype | INTEGER |
4 | false | Used by property: Datatype |
| column_size | INTEGER |
4 | true | Used by property: ColumnSize |
| allows_null_bool | BOOLEAN |
2 | false | Used by property: AllowsNull |
| allows_user_index | BOOLEAN |
2 | true | Indicates whether this column allows a user index (true) or not (false). This value is a function of the underlying database and the column's data type. Generally speaking all data types other than binary and long strings are indexable. (SQLServer has a limit of 900 byte strings.) |
| prop_id | GUID |
16 | true | Identifies the property to which this ColumnDefinition applies. For user-defined properties, this value corresponds to the object_id column of GlobalPropertyDef. |
| is_single_indexed | BOOLEAN |
2 | true | Used by property: IsSingleIndexed |
| is_system_owned | BOOLEAN |
2 | true | Indicates whether this ColumnDefinition is generated by the system or not. |
ContentQueueLock Table
No direct mapping to a Content Engine class. This table is used by the Content Queue Dispatcher to serialize Content Queue update and deletion statements.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| instance_name | STRING |
80 | false | Each Content Platform Engine instance inserts a row with the local hostname. These rows are used to provide various levels of serialization across the set of Content Platform Engine instances. |
ComponentRelation Table
Used by class: ComponentRelationship
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | false | Used by property: Creator |
| create_date | DATE |
10 | false | Used by property: DateCreated |
| modify_user | STRING |
80 | false | Used by property: LastModifier |
| modify_date | DATE |
10 | false | Used by property: DateLastModified |
| child_component_id | OBJECT |
16 | true | Used by property: ChildComponent |
| child_version_series_id | OBJECT |
16 | true | Used by property: ChildVersionSeries |
| parent_component_id | OBJECT |
16 | false | Used by property: ParentComponent |
| copy_to_reservation | BOOLEAN |
2 | false | Used by property: CopyToReservation |
| name | STRING |
255 | true | Used by property: Name |
| label_bind_value | STRING |
64 | true | Used by property: LabelBindValue |
| component_relationship_type | INTEGER |
4 | false | Used by property: ComponentRelationshipType |
| uri_value | STRING |
2083 | true | Used by property: URIValue |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| component_sort_order | INTEGER |
4 | false | Used by property: ComponentSortOrder |
| version_bind_type | INTEGER |
4 | true | Used by property: VersionBindType |
| cascade_delete | INTEGER |
4 | false | Used by property: ComponentCascadeDelete |
| prevent_delete | INTEGER |
4 | false | Used by property: ComponentPreventDelete |
| child_component_id_home | OBJECT |
16 | true | Identifies a foreign object store where the Document object that is identified by the child_component_id column in this row is located. If this column is null, the Document is in the same object store as this row. |
| child_version_series_id_home | OBJECT |
16 | true | Identifies a foreign object store where the VersionSeries object that is
identified by the child_version_series_id column in this row is located. If this column is null, the
VersionSeries object is in the same object store as this row. |
Container Table
Used by class: Folder
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | OBJECT |
16 | false | Used by property: ClassDescription |
| security_id | OBJECT |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| parent_container_id | OBJECT |
16 | true | Used by property: Parent |
| name | STRING |
255 | true | Used by property: FolderName |
| init_container_bool | BOOLEAN |
2 | true | This column is no longer used by the server. |
| lock_token | GUID |
16 | true | Used by property: LockToken |
| lock_timeout | INTEGER |
4 | true | Used by property: LockTimeout |
| lock_owner | STRING |
64 | true | Used by property: LockOwner |
| lock_sid | BLOB |
1G | true | If the object that is identified by this row is locked, this column contains the SID of the locking user. |
| security_policy_id | OBJECT |
16 | true | Used by property: SecurityPolicy |
| indexation_id | GUID |
16 | true | Used by property: IndexationId |
| index_failure_code | INTEGER |
4 | true | Used by property: CmIndexingFailureCode |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| retention_date | DATE |
10 | true | Used by property: CmRetentionDate |
| recovery_item_id | OBJECT |
16 | true | Not supported in this release. |
Content Table
Stores document and annotation content in the database storage area.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| element_id | STRING |
48 | false | The unique identifier for this content element. The identifier is a UTF8 string that consists of the UUID of the owning document or annotation that is concatenated with an integer that indicates the content element sequence number. |
| extension | STRING |
3 | true | Unused. |
| content | BLOB |
1G | true | Contains the content data for this database content element. |
| content_size | INTEGER |
4 | false | The size of the content in bytes. |
| create_date | DATE |
10 | true | The date this content element was created. |
| refcount | INTEGER |
4 | true | The number of times this content is referenced by documents. This value is used only when the content duplication suppression feature is enabled for database content. |
| scf_data | BINARY |
32 | true | Cryptographic nonce that is used when content encryption is enabled for database storage. |
ContentBackoutQueue Table
Used by class: CmContentBackoutQueueEntry
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| held_until_date | DATE |
10 | true | Used by property: HeldUntilDate |
| lease_holder_id | GUID |
16 | true | Used by property: LeaseHolderId |
| failure_count | INTEGER |
4 | true | Used by property: FailureCount |
| last_failure_reason | CLOB |
512 M | true | Used by property: LastFailureReason |
| entry_status | INTEGER |
4 | true | Used by property: QueueEntryStatus |
| deferral_count | INTEGER |
4 | true | Used by property: DeferralCount |
| deferral_data | BLOB |
1G | true | Used by property: DeferralData |
| expiration_time | DATE |
10 | true | Used by property: IdBatchExpiryTime |
| storage_area_id | OBJECT |
16 | true | Used by property: StorageArea |
| batch_id | GUID |
16 | true | Used by property: BatchId |
| operation_data | BLOB |
1G | true | Used by property: OperationData |
| replica_data | BLOB |
1G | true | Used by property: ReplicationData |
ContentDeletionQueue Table
Used by class: CmContentDeletionQueueEntry
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| held_until_date | DATE |
10 | true | Used by property: HeldUntilDate |
| lease_holder_id | GUID |
16 | true | Used by property: LeaseHolderId |
| failure_count | INTEGER |
4 | true | Used by property: FailureCount |
| last_failure_reason | CLOB |
512 M | true | Used by property: LastFailureReason |
| entry_status | INTEGER |
4 | true | Used by property: QueueEntryStatus |
| deferral_count | INTEGER |
4 | true | Used by property: DeferralCount |
| deferral_data | BLOB |
1G | true | Used by property: DeferralData |
| replica_data | BLOB |
1G | true | Used by property: ReplicationData |
| operation_data | BLOB |
1G | true | Used by property: OperationData |
| storage_area_id | OBJECT |
16 | true | Used by property: StorageArea |
ContentQueue Table
Holds queued content operations for content that is stored in a file storage area.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | GUID |
16 | false | The unique identifier for the object to which this content request applies. |
| seqnum_identity | BINARY |
8 | false | A system generated sequence number that is used to determine the proper order in which to process queue entries. |
| object_class_id | GUID |
16 | false | The unique identifier of the class of object that is identified by object_id. |
| lease_expiry_date | DATE |
10 | false | A time stamp that determines how long a busy queue request is allowed to processed before another thread attempts to run the request. |
| session_id | GUID |
16 | false | A unique ID that identifies the server instance that queued this request. A server instance is an occurrence of a running Content Engine server. Each server instance generates its own session_id at start and uses it to tag content operations that it adds to the content queue. |
| element_sequence_number | INTEGER |
4 | false | An integer that identifies the specific content element that is associated with this request. |
| command_type | INTEGER |
4 | false | A code that identifies the type of this queued request. |
| process_attempts | INTEGER |
4 | true | The number of times a thread has claimed and attempted to process this request. |
| source_object_id | GUID |
16 | true | This column is overloaded to serve multiple purposes. It contains the migration ID when the request type is for migrating fixed content. It contains information that, when combined with the object ID, is used to locate upload file in the inbound directory when the content upload is finalized. |
| storage_area_id | GUID |
16 | false | Contains the unique identifier of the content storage area where the content associated with this queued request is stored. |
| content_size | DOUBLE |
8 | false | Contains the number of bytes of content that is associated with this content request. |
| serialized_data | BLOB |
1G | false | A serialized property collection that contains parameters that are associated with the request type. |
| create_date | DATE |
10 | false | The date this queue item was created. |
ContentReplicationQueue Table
Used by class: CmContentReplicationQueueEntry
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| held_until_date | DATE |
10 | true | Used by property: HeldUntilDate |
| lease_holder_id | GUID |
16 | true | Used by property: LeaseHolderId |
| failure_count | INTEGER |
4 | true | Used by property: FailureCount |
| last_failure_reason | CLOB |
512 M | true | Used by property: LastFailureReason |
| entry_status | INTEGER |
4 | true | Used by property: QueueEntryStatus |
| deferral_count | INTEGER |
4 | true | Used by property: DeferralCount |
| deferral_data | BLOB |
1G | true | Used by property: DeferralData |
| content_id | GUID |
16 | true | Used by property: ContentId |
| hash_sequence | DOUBLE |
8 | true | Used by property: HashSequenceNumber |
| storage_area_id | OBJECT |
16 | true | Used by property: StorageArea |
| replica_data | BLOB |
1G | true | Used by property: ReplicationData |
| content_size | DOUBLE |
8 | true | Used by property: ContentSize |
| signature | BINARY |
32 | true | Used by property: ContentSignature |
| operation_data | BLOB |
1G | true | Used by property: OperationData |
ContentSearch Table
Used by class: ContentSearch
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | OBJECT |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| security_id | OBJECT |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| queried_object_id | OBJECT |
16 | false | Mapped to the QueriedObject property of the ContentSearch class. |
| content | STRING |
10 | true | Not used |
| rank | DOUBLE |
8 | true | Mapped to the Rank property of the ContentSearch class. |
| hitcount | INTEGER |
4 | true | Not used |
| content_size | DOUBLE |
8 | true | Not used |
| seq_number | INTEGER |
4 | true | Not used |
| summary | STRING |
512 | true | Summary text of the content search result. |
| highlight_blob | BLOB |
1G | true | Highlighted terms that are used in the content search. |
ContentUpload Table
Used temporarily to store chunked content that is uploaded to the database storage area.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| element_id | STRING |
48 | false | Unique identifier for this chunk of database content while it is temporarily stored during the process of upload. |
| offset | INTEGER |
4 | false | Offset from beginning of the content data stream where this chunk of content starts. |
| create_date | DATE |
10 | true | The date this temporary content chunk was created. |
| content | BLOB |
1G | true | The sequence of content bytes for this temporary chunk. |
ConversionSettings Table
Used by classes: CmTextExtractionSettings, CmContentConversionSettings
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
Cvl Table
Used by class: ChoiceList
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| cvl_data_type | INTEGER |
4 | true | Used by property: DataType |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| addon_id | GUID |
16 | true | Used by property: InstalledByAddOn |
CvlElement Table
Used by class: Choice
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_cvl_id | GUID |
16 | false | Identifies the parent ChoiceList of this Choice. This value always corresponds to an object_id in the Cvl table. That is, it identifies this choice's top-most choice list. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| val_integer | INTEGER |
4 | true | Choice.IntegerValue. This value is null for string choices. |
| val_string | STRING |
1024 | true | Choice.StringValue. This value is null for integer choices. |
| choice_type | INTEGER |
4 | false | Used by property: ChoiceType |
| nesting_level | INTEGER |
4 | true | Indicates the depth at which this Choice is in the choice hierarchy. |
DDState Table
Used internally by the CE server to store states of various parts of the system.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| id | GUID |
16 | false | Identifies the current epoch of the object store metadata. This value is changed whenever the system metadata is modified. |
| schema_revision_string | STRING |
64 | true | Contains the value corresponding to the object store schema. This value is updated when new releases are installed and the upgrade has applied the appropriate changes to the schema to get it to its expected level. |
| folder_cache_epoch | INTEGER |
4 | false | Identifies the current epoch of the folder cache. This value is changed whenever a folder is created or deleted. |
| last_good_ci_sn | INTEGER |
4 | false | Not used. |
| last_good_pi_sn | INTEGER |
4 | false | Not used. |
| last_good_anno_pi_sn | INTEGER |
4 | false | Not used. |
| index_host_name | STRING |
15 | true | Not used. |
| index_lease_expiry | DATE |
10 | true | Not used. |
| index_area_epoch | INTEGER |
4 | true | Identifies the current epoch of the index area cache. This value is changed whenever an IndexArea is created, modified, or deleted. |
| storage_area_epoch | INTEGER |
4 | true | Identifies the current epoch of the storage area cache. This value is changed whenever a StorageArea is created, modified, or deleted. |
| storage_policy_epoch | INTEGER |
4 | true | Identifies the current epoch of the storage policy cache. This value is changed whenever a StoragePolicy is created, modified, or deleted. |
| async_upgrade_state | INTEGER |
4 | true | Contains the status of any asynchronous upgrade tasks. This value is zero when no tasks are running. |
| is_custom_schema | BOOLEAN |
2 | true | Indicates whether the schema creation script stored in the schema_script column was provided by the user or not. |
| schema_script | CLOB |
512 M | true | Contains the database script that is used to create the object store. |
| external_md_epoch | GUID |
16 | true | Identifies the current epoch of the external metadata cache. This value is changed whenever an ExternalAlias is created, modified, or deleted. |
| sql_translation_epoch | INTEGER |
4 | true | This value is incremented when the SQL translation facility is needed to solve query optimization issues, but only if instructed to do so by IBM Support. |
| last_purge_time | DATE |
10 | true | This column is no longer used by the server. |
| event_action_epoch | INTEGER |
4 | true | Identifies the current epoch of the action cache. This value is changed whenever a subclass of Action is created, modified, or deleted. |
| audit_disp_lease_expiry | DATE |
10 | true | Indicates when the lease expires for the current AuditDisposition processing task. |
| audit_disp_restart | INTEGER64 |
8 | true | Corresponds to the value of Event.audit_sequence from which the AuditDispostion processing task left off. |
| continuity_data | BLOB |
1G | true | Used during content persistence. |
| store_id | GUID |
16 | true | The ID of the object store that is using this table. It is used to determine whether a schema name is in use by another object store. |
| subscription_epoch | INTEGER |
4 | true | Used by subscription caching to track the current epoch of the cached values. Whenever subscriptions are added, deleted, or modified, the cache is reloaded and this epoch is incremented. |
| indexing_balancing_time | DATE |
10 | true | The time interval between server checks to see whether the active workload for full-text indexing needs to be rebalanced. |
DeviceConnection Table
Used by class: CmStorageDeviceConnection
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the CmAdvancedStorageArea on which this connection is defined. |
| parent_prop_id | GUID |
16 | false | The CmStorageDeviceConnections property on CmAdvancedStorageArea, in which this entry can be found. |
| ordinal | INTEGER |
4 | false | Identifies the position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| device_id | OBJECT |
16 | true | Used by property: StorageDevice |
| replica_type | INTEGER |
4 | true | Used by property: ReplicaSynchronizationType |
DocumentState Table
Used by class: DocumentState
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the DocumentState psuedo-class, which exists in metadata but not in the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | The ID of the Lifecycle Policy object to which this particular state belongs (note that Lifecycle Policy objects are stored in the Subscription table, along with Subscription objects and Event Action objects). |
| parent_prop_id | GUID |
16 | false | The ID of the Document States property on the Document Lifecycle Policy class. |
| ordinal | INTEGER |
4 | false | A sequential numbering of the states for a lifecycle policy. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| state_name | STRING |
4000 | true | The name of the lifecycle state. |
| can_be_demoted | BOOLEAN |
2 | true | Interpreted as a Boolean; if true, documents can be demoted from this state to a prior lifecycle state. |
| enable_state_permissions | BOOLEAN |
2 | true | Interpreted as a Boolean; if true, the security descriptor that is associated with this state is applied to documents when they are promoted or demoted to this state. |
| security_id | GUID |
16 | false | The ID of the security descriptor that is associated with this lifecycle state. |
DocVersion Table
Used by classes: XMLPropertyMappingScript, CodeModule, Document, VersionSeries, WorkflowDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| storage_class | OBJECT |
16 | true | Used by property: StoragePolicy |
| is_reserved | BOOLEAN |
2 | false | Used by property: IsReserved |
| is_current | BOOLEAN |
2 | false | Used by property: IsCurrentVersion |
| is_frozen | BOOLEAN |
2 | false | Used by property: IsFrozenVersion |
| version_series_id | OBJECT |
16 | false | Used by properties: VersionSeries, Id |
| content_size | DOUBLE |
8 | true | Used by property: ContentSize |
| lock_token | GUID |
16 | true | Used by property: LockToken |
| lock_timeout | INTEGER |
4 | true | Used by property: LockTimeout |
| lock_owner | STRING |
64 | true | Used by property: LockOwner |
| doc_lifecycle_policy | OBJECT |
16 | true | Used by property: DocumentLifecyclePolicy |
| doc_state | STRING |
64 | true | Used by property: CurrentState |
| is_in_exception_state | BOOLEAN |
2 | true | Used by property: IsInExceptionState |
| storage_location | STRING |
1 | true | Used by property: StorageLocation |
| component_types | BINARY |
100 | true | An encoded string that lists the MIME types of each content element that is associated with the document. Each string is preceded by its length in bytes and the repeat count. |
| retrieval_names | BINARY |
200 | true | Maps indirectly to the Retrieval Name property on the Content Transfer objects that are associated with the Document represented by a single row in this table. |
| component_types_2 | BLOB |
1G | true | A continuation of the component_types string if it exceeds the column length provided. |
| retrieval_names_2 | BLOB |
1G | true | Contains the overflow from the retrieval_names column when the number of bytes required for the retrieval names of all the content transfer objects exceeds the maximum that is allowed by the retrieval_names column. |
| mime_type | STRING |
96 | true | Used by property: MimeType |
| content_info | BINARY |
96 | true | This column is overloaded to serve multiple purposes. In general, it contains serialized data that is related to the content elements associated with the document represented by a single row in this table. The nature of the data depends on whether the content element is a content transfer or a content reference and whether it is federated. It also depends on whether either (or both) of the content encryption or content single instance storage features are enabled. For each content element associated with this document, the possible serialized data includes the sequence number, size, signature, key index, nonce, refcountKey, and a Boolean that indicates whether the content element is a content transfer, a content reference, or federated. |
| content_info_2 | BLOB |
1G | true | Contains the overflow from content_info. |
| next_content_unique_id | INTEGER |
4 | true | Contains an integer value that will be used as the sequence number for the next content element added to this Document. |
| vw_version | STRING |
255 | true | Used by property: VWVersion |
| versioning_enabled | BOOLEAN |
2 | false | Used by property: IsVersioningEnabled |
| xml_doc_type | STRING |
256 | true | Used by property: XMLDocumentType |
| xml_target_class | OBJECT |
16 | true | Used by property: TargetClass |
| classification_state | INTEGER |
4 | true | Used by property: ClassificationStatus |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, either due to a direct API call or as the result of cascade from the parent, this column contains the ID of the CmRecoveryItem object that references this object. |
| lock_sid | BLOB |
1G | true | If the object that is identified by this row is locked, this column contains the SID of the locking user. |
| major_version_number | INTEGER |
4 | false | Used by property: MajorVersionNumber |
| minor_version_number | INTEGER |
4 | false | Used by property: MinorVersionNumber |
| version_status | INTEGER |
4 | false | Used by property: VersionStatus |
| security_policy_id | OBJECT |
16 | true | Used by property: SecurityPolicy |
| reservation_type | INTEGER |
4 | true | Used by property: ReservationType |
| reservation_owner_sid | BLOB |
1G | true | The security ID of the user that created this reservation object with an exclusive check-out operation. If the row is not a reservation, or the check-out was not exclusive, this value is null. |
| content_last_accessed_date | DATE |
10 | true | Used by property: DateContentLastAccessed |
| content_referral_blob | BLOB |
1G | true | Contains the unique identifier of federated content in the source repository. Only applies to documents that have federated content. Format consists of a common 44 byte header followed by variable number of bytes that make up repository-specific data. Header format consists of a 4 byte version number, 4 byte checksum, 2 byte mode, 2 byte flags, 16 byte document ID, 4 byte size, 8 byte retention period, and 4 byte count. |
| content_retention_date | DATE |
10 | true | Used by properties: ContentRetentionDate, CmRetentionDate |
| storage_area_id | OBJECT |
16 | true | Used by property: StorageArea |
| indexation_id | GUID |
16 | true | Used by property: IndexationId |
| index_failure_code | INTEGER |
4 | true | Used by property: CmIndexingFailureCode |
| compound_document_state | INTEGER |
4 | true | Used by property: CompoundDocumentState |
| dynamic_cr_update_status | INTEGER |
4 | true | If this column contains a value of 1, that identifies the Document version that is defined by this row as a child component of another Document, where the Component Relationship object (which defines the parent-child relationship) requires dynamic updates on versioning of the child component. |
| security_folder_id | OBJECT |
16 | true | Used by property: SecurityFolder |
| checked_in_date | DATE |
10 | true | Used by property: DateCheckedIn |
Event Table
Used by classes: UnfileEvent, RetrievalEvent, ClassifyCompleteEvent, CmRecoverEvent, UpdateSecurityEvent, LockEvent, ChangeStateEvent, UpdateEvent, ChangeClassEvent, FileEvent, AuditConfigurationEvent, CheckoutEvent, QueryEvent, CreationEvent, Event, CancelCheckoutEvent, GetObjectEvent, PromoteVersionEvent, CustomEvent, GetContentEvent, DeletionEvent, CmMarkForDeletionEvent, DemoteVersionEvent, TakeFederatedOwnershipEvent, ObjectChangeEvent, CheckinEvent, UnlockEvent, FreezeEvent, CmMoveContentEvent
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| source_object_id | GUID |
16 | true | Used by property: SourceObjectId |
| source_object_class_id | GUID |
16 | true | Used by property: SourceClassId |
| status | INTEGER |
4 | true | Used by property: EventStatus |
| serialized_source_object | BLOB |
1G | true | Contains the serialized form of the SourceObject property on many subclasses of ObjectChangeEvent. |
| query_text | CLOB |
512 M | true | Used by property: QueryText |
| version_series_id | GUID |
16 | true | Used by property: VersionSeriesId |
| lifecycle_change | INTEGER |
4 | true | Used by property: LifecycleOperation |
| element_name | STRING |
255 | true | Used by property: ContainmentName |
| audit_level | INTEGER |
4 | true | Used by property: AuditLevel |
| initiating_user | STRING |
255 | true | Used by property: InitiatingUser |
| sequence_number | INTEGER |
4 | true | Used by property: ElementSequenceNumber |
| serialized_orig_object | BLOB |
1G | true | Contains the serialized form of the OriginalObject property on many subclasses of ObjectChangeEvent. |
| audit_sequence | BINARY |
8 | true | Used by property: CmAuditSequence |
| source_storage_area_id | GUID |
16 | true | Used by property: CmSourceStorageArea |
| target_storage_area_id | GUID |
16 | true | Used by property: CmTargetStorageArea |
| recovery_item_id | GUID |
16 | true | Used by property: CmRecoveryItem |
| source_retained | BOOLEAN |
2 | true | Used by property SourceContentRetained. |
ExternalAlias Table
Used by classes: ExternalAlias, ExternalClassAlias, ExternalPropertyAlias
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | GUID |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | GUID |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| external_repo_id | GUID |
16 | false | Used by property: ExternalRepository |
| alias_direction | INTEGER |
4 | false | Used by property: AliasDirection |
| class_identity | STRING |
128 | false | ExternalClassAlias.ClassIdentity or ExternalPropertyAlias.ClassIdentity depending on which of the two classes to which this object corresponds, based on the value in object_class_id. |
| property_identity | STRING |
128 | true | Used by property: PropertyIdentity |
ExternalIdentity Table
Used by class: ExternalIdentity
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| repository_id | GUID |
16 | false | Used by property: ExternalRepository |
| external_id | STRING |
256 | false | Used by property: ExternalIdentity |
| replication_data | BLOB |
1G | true | Used by property: ReplicationData |
Generic Table
Used by class: CustomObject
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| lock_token | GUID |
16 | true | Used by property: LockToken |
| lock_timeout | INTEGER |
4 | true | Used by property: LockTimeout |
| lock_owner | STRING |
64 | true | Used by property: LockOwner |
| lock_sid | BLOB |
1G | true | If the object that is identified by this row is locked, this column contains the SID of the locking user. |
| security_policy_id | OBJECT |
16 | true | Used by property: SecurityPolicy |
| indexation_id | GUID |
16 | true | Used by property: IndexationId |
| index_failure_code | INTEGER |
4 | true | Used by property: CmIndexingFailureCode |
| security_folder_id | OBJECT |
16 | true | Used by property: SecurityFolder |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| retention_date | DATE |
10 | true | Used by property: CmRetentionDate |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, either due to a direct API call or as the result of a
cascade from the parent, this column contains the ID of the CmRecoveryItem object
that references this object. |
GlobalPropAliasId Table
Used by classes: ClassDefinition, PropertyDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| alias_id | GUID |
16 | false | Identifies the property template to which this property is aliased depending on whether this value is a ClassDefinition.AliasIds or PropertyDefinition.AliasIds value. |
GlobalPropertyDef Table
Used by classes: PropertyTemplate, PropertyTemplateBoolean, PropertyTemplateBinary, PropertyTemplateDateTime, PropertyTemplateFloat64, PropertyTemplateId, PropertyTemplateInteger32, PropertyTemplateObject, PropertyTemplateString
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| datatype | INTEGER |
4 | false | Used by property: DataType |
| cardinality | INTEGER |
4 | false | Used by property: Cardinality |
| value_required_bool | BOOLEAN |
2 | true | Used by property: IsValueRequired |
| hidden_bool | BOOLEAN |
2 | true | Used by property: IsHidden |
| name_property_bool | BOOLEAN |
2 | true | Used by property: IsNameProperty |
| max_length_string | INTEGER |
4 | true | Used by property: MaximumLengthString |
| max_length_binary | INTEGER |
4 | true | Used by property: MaximumLengthBinary |
| default_binary | BLOB |
1G | true | Used by property: PropertyDefaultBinary |
| default_bool | BOOLEAN |
2 | true | Used by property: PropertyDefaultBoolean |
| default_datetime | DATE |
10 | true | Used by property: PropertyDefaultDateTime |
| default_id | GUID |
16 | true | Used by property: PropertyDefaultId |
| default_int32 | INTEGER |
4 | true | Used by property: PropertyDefaultInteger32 |
| default_float64 | DOUBLE |
8 | true | Used by property: PropertyDefaultFloat64 |
| default_string | STRING |
4000 | true | Used by property: PropertyDefaultString |
| minimum_datetime | DATE |
10 | true | Used by property: PropertyMinimumDateTime |
| minimum_int32 | INTEGER |
4 | true | Used by property: PropertyMinimumInteger32 |
| minimum_float64 | DOUBLE |
8 | true | Used by property: PropertyMinimumFloat64 |
| maximum_datetime | DATE |
10 | true | Used by property: PropertyMaximumDateTime |
| maximum_int32 | INTEGER |
4 | true | Used by property: PropertyMaximumInteger32 |
| maximum_float64 | DOUBLE |
8 | true | Used by property: PropertyMaximumFloat64 |
| cvl_id | OBJECT |
16 | true | Used by property: ChoiceList |
| list_is_set_bool | BOOLEAN |
2 | true | Used by property: RequiresUniqueElements |
| symbolic_name | STRING |
64 | true | Used by property: SymbolicName |
| settability | INTEGER |
4 | true | Used by property: Settability |
| display_category | STRING |
64 | true | Used by property: PropertyDisplayCategory |
| modification_access | INTEGER |
4 | true | Used by property: ModificationAccessRequired |
| allows_foreign_object | BOOLEAN |
2 | true | Used by property: AllowsForeignObject |
| security_proxy_type | INTEGER |
4 | true | Used by property: SecurityProxyType |
| marking_set_id | OBJECT |
16 | true | Used by property: MarkingSet |
| use_long_column | BOOLEAN |
2 | true | Used by property: UsesLongColumn |
| persistence_type | INTEGER |
4 | true | Used by property: PersistenceType |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| addon_id | GUID |
16 | true | Used by property: InstalledByAddOn |
| audit_as_id | OBJECT |
16 | true | Used by property: AuditAs |
| long_default_string | CLOB |
512 M | true | The long-string default in the property template. Used if the UsesLongColumn property is true. |
| date_only_bool | BOOLEAN |
2 | true | Used by property: IsDateOnly |
| read_protected_bool | BOOLEAN |
2 | true | Used by property: IsReadProtected |
| cbr_propagation | INTEGER |
4 | true | Used by property: CBRPropagationType |
HierarchyIndex Table
Used internally to optimize folder persistence and retrieval.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the ancestor (parent) folder in a folder hierarchy. Used for INSUBFOLDER searches only. |
| child_id | OBJECT |
16 | false | Identifies the descendant folder. There is 1 row for every (parent) to (descendant) subfolder (at every level). |
HoldObject Table
Used by class: CmHold
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
HoldRelationship Table
Used by class: CmHoldRelationship
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| hold_id | OBJECT |
16 | false | Used by property: Hold |
| held_object_id | OBJECT |
16 | false | Used by property: HeldObject |
| held_object_id_class | GUID |
16 | false | The class ID corresponding to CmHoldRelationship.HeldObject. |
IndexArea Table
Used by classes: CmTextSearchIndexArea, IndexArea
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | GUID |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| area_status | INTEGER |
4 | false | Used by property: ResourceStatus |
| site_id | GUID |
16 | true | Used by property: Site |
| template_type | STRING |
128 | true | Used by property: TemplateType |
| root_directory_path | STRING |
255 | true | Used by property: RootDirectoryPath |
| search_servers_to_attach | INTEGER |
4 | true | Used by property: SearchServersToAttach |
| max_collections | INTEGER |
4 | true | Used by properties: MaxIndexes, MaxCollections |
| temp_directory_path | STRING |
255 | true | Used by property: TempDirectoryPath |
| max_objects_per_index | DOUBLE |
8 | true | Used by property: MaxObjectsPerIndex |
| max_size_per_index_kb | DOUBLE |
8 | true | Used by property: MaxSizePerIndexKbytes |
| standby_activation_priority | INTEGER |
4 | true | Used by property: CmStandbyActivationPriority |
| affinity_group_id | OBJECT |
16 | true | Used by property: AffinityGroup |
IndexDefinition Table
Used by class: CmIndexDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| index_name | STRING |
128 | false | Used by property: IndexName |
| sys_owned_bool | BOOLEAN |
2 | false | Used by property: IsSystemOwned |
| storage_location | STRING |
128 | true | Used by property: DatabaseIndexStorageLocation |
| unique_bool | BOOLEAN |
2 | false | Used by property: RequiresUniqueElements |
| case_insensitive | BOOLEAN |
2 | true | Used by property: ForCaseInsensitiveSearch |
IndexedColumn Table
Used by class: CmIndexedColumn
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| table_id | GUID |
16 | false | Identifies the database table's index for the indexed columns. |
| column_name | STRING |
30 | false | Used by property: ColumnName |
| sort_order | INTEGER |
4 | false | Used by property: SortOrder |
IndexJob Table
Used by class: IndexJob
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | GUID |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| time_last_processed | DATE |
10 | true | Used by property: TimeLastProcessed |
| time_all_submitted | DATE |
10 | true | Used by property: TimeAllSubmitted |
| job_status | INTEGER |
4 | false | Used by property: JobStatus |
| job_abort_requested | BOOLEAN |
2 | false | Used by property: JobAbortRequested |
| submitted_count | INTEGER |
4 | true | Used by property: SubmittedCount |
| phase_num | INTEGER |
4 | true | Identifies the different phases of the Index Job. |
| item_num | INTEGER |
4 | true | Identifies the Index Job Item number. |
| prior_object_id | GUID |
16 | true | Identifies the object ID of the previous object that was indexed. |
| last_max_seq_num | INTEGER64 |
8 | true | Use for the calculation of outstanding number of index requests. |
| active_server | STRING |
128 | true | Identifies the active indexing server, where this index job is running on. |
| serialized_data | BLOB |
1G | true | Binary data that identifies the set of items to update. |
| job_pause_requested | BOOLEAN |
2 | true | Used by property: JobPauseRequested |
| is_migration_job | BOOLEAN |
2 | true | Used by property: IsMigrationJob |
| last_failure_desc | CLOB |
512 M | true | Used by property: LastFailureReason |
| max_request_queue_size | INTEGER |
4 | true | Used by property: MaxRequestQueueSize |
IndexJobItem Table
Used by classes: IndexJobItem, IndexJobClassItem, IndexJobCollectionItem, IndexJobSingleItem
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Mapped to the Id property of IndexJobItem class. |
| object_class_id | GUID |
16 | false | Mapped to the ClassDescription property of IndexJobItem class. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| indexation_id | GUID |
16 | true | Mapped to the IndexationId property of IndexJobCollectionItem class. |
| index_area_id | GUID |
16 | true | Mapped to the IndexArea property of IndexJobCollectionItem class. |
| class_definition_id | GUID |
16 | true | Mapped to the ClassDefinition property of IndexJobClassItem class. |
| single_item_id | GUID |
16 | true | Specifies the ID of the SingleItem property of IndexJobSingleItem class. |
| single_item_id_class | GUID |
16 | true | Specifies the class type of the SingleItem property of IndexJobSingleItem class. |
| include_subclasses | BOOLEAN |
2 | true | Mapped to the IncludeSubclassesRequested property of IndexJobClassItem class. |
| resync_modification_date | DATE |
10 | true | Mapped to the ResyncModificationDate property of the CmIndexJobResyncItem class. |
IndexRequests Table
Used by classes: CmTextSearchIndexRequest
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| target_id | GUID |
16 | false | Used by property: SourceObject |
| target_id_class | GUID |
16 | false | Identifies the ID of the class of the target object that is being indexed. |
| operation | INTEGER |
4 | false | Used by property: IndexingOperation |
| indexation_id | GUID |
16 | true | Used by property: IndexationId |
| status | INTEGER |
4 | false | Used by property: IndexRequestStatus |
| request_time | DATE |
10 | false | Used by property: DateRequested |
| seqnum_identity | BINARY |
8 | false | Used by property: SequenceNumber |
| retry_count | INTEGER |
4 | false | Used by property: RetryCount |
| element_sequence_number | INTEGER |
4 | true | Used by property: ElementSequenceNumber |
| retrieval_name_ext | STRING |
64 | true | Used by property: RetrievalNameExtension |
| index_job_id | GUID |
16 | true | Used by property: IndexJob |
| index_area_id | GUID |
16 | false | Used by property: IndexArea |
| object_id | OBJECT |
16 | true | Used by property: Id |
| object_class_id | GUID |
16 | true | Used by property: ClassDescription |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | true | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| last_failure_reason | CLOB |
512 M | true | Used by property: LastFailureReason |
| indexing_failure_code | INTEGER |
4 | true | Used by property: CmIndexingFailureCode |
| removal_indexation_id | GUID |
16 | true | Used by property: RemovalIndexationId |
Link Table
Used by class: Link
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| head_id | OBJECT |
16 | true | Used by property: Head |
| head_id_class | GUID |
16 | true | Identifies the class of the object that is identified by the head_id column in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| tail_id | OBJECT |
16 | false | Used by property: Tail |
| tail_id_class | GUID |
16 | true | Identifies the class of the object that is identified by the tail_id column in this row. This value corresponds to the object_id column of the ClassDefinition table |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
ListOfBinary Table
Used by various classes that have multi-valued Binary properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | BLOB |
1G | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
ListOfBoolean Table
Used by various classes that have multi-valued Boolean properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | BOOLEAN |
2 | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
ListOfDateTime Table
Used by various classes that have multi-valued DateTime properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | DATE |
10 | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
ListOfFloat64 Table
Used by various classes that have multi-valued Float64 properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | DOUBLE |
8 | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
ListOfId Table
Used by various classes that have multi-valued ID properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | GUID |
16 | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
ListOfInteger32 Table
Used by various classes that have multi-valued Integer32 properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | INTEGER |
4 | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
ListOfString Table
Used by various classes that have multi-valued String properties. This table holds the MVP values.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| element_value | STRING |
4000 | false | Holds the list property value for the parent object. |
| create_date | DATE |
10 | true | The date this property was created. |
| parent_id_class | OBJECT |
16 | true | Identifies the class of the parent object. |
LocalizedString Table
Used by class: LocalizedString
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| locale_name | STRING |
16 | false | Used by property: LocaleName |
| text | STRING |
4000 | false | Used by property: LocalizedText |
PreprocessorDefinition Table
Used by class: CmChangePreprocessorDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| enabled_bool | BOOLEAN |
2 | false | Used by property: IsEnabled |
| action_id | OBJECT |
16 | false | Used by property: ChangePreprocessorAction |
PropertyDefinition Table
Used by classes: PropertyDefinition, PropertyDefinitionBinary, PropertyDefinitionBoolean, PropertyDefinitionDateTime, PropertyDefinitionFloat64, PropertyDefinitionId, PropertyDefinitionInteger32, PropertyDefinitionObject, PropertyDefinitionString
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| dbg_display_name | STRING |
32 | true | Contains the display name for this property. |
| dbg_class_name | STRING |
32 | true | Contains the class name that includes this property. |
| sys_owned_bool | BOOLEAN |
2 | false | Used by property: IsSystemOwned |
| primary_id | GUID |
16 | false | Identifies the PropertyTemplate or System property from which this PropertyDefinition is derived. |
| global_prop_id | OBJECT |
16 | true | Identifies the PropertyTemplate from which this PropertyDefinition is derived. This value is null for system-defined properties and corresponds to the object_id column in the GlobalPropertyDef table for PropertyTemplates (that is, user-defined properties). |
| inherited_bool | BOOLEAN |
2 | false | Identifies whether this PropertyDefinition is inherited (true) or not (false). |
| datatype | INTEGER |
4 | false | Used by property: DataType |
| cardinality | INTEGER |
4 | false | Used by property: Cardinality |
| value_required_bool | BOOLEAN |
2 | false | Used by property: IsValueRequired |
| hidden_bool | BOOLEAN |
2 | false | Used by property: IsHidden |
| name_property_bool | BOOLEAN |
2 | false | Used by property: IsNameProperty |
| max_length | INTEGER |
4 | true | Used by properties: MaximumLengthBinary, MaximumLengthString |
| default_binary | BLOB |
1G | true | Used by property: PropertyDefaultBinary |
| default_bool | BOOLEAN |
2 | true | Used by property: PropertyDefaultBoolean |
| default_datetime | DATE |
10 | true | Used by property: PropertyDefaultDateTime |
| default_id | GUID |
16 | true | Used by property: PropertyDefaultId |
| default_int32 | INTEGER |
4 | true | Used by property: PropertyDefaultInteger32 |
| default_float64 | DOUBLE |
8 | true | Used by property: PropertyDefaultFloat64 |
| default_object_id | OBJECT |
16 | true | Used by property: PropertyDefaultObject |
| default_object_id_class | GUID |
16 | true | Indirectly identifies the class of the object to be used as the default value. This value corresponds to the object_id column of the ClassDefinition table. |
| default_string | STRING |
4000 | true | Used by property: PropertyDefaultString |
| minimum_datetime | DATE |
10 | true | Used by property: PropertyMinimumDateTime |
| minimum_int32 | INTEGER |
4 | true | Used by property: PropertyMinimumInteger32 |
| minimum_float64 | DOUBLE |
8 | true | Used by property: PropertyMinimumFloat64 |
| maximum_datetime | DATE |
10 | true | Used by property: PropertyMaximumDateTime |
| maximum_int32 | INTEGER |
4 | true | Used by property: PropertyMaximumInteger32 |
| maximum_float64 | DOUBLE |
8 | true | Used by property: PropertyMaximumFloat64 |
| cvl_id | OBJECT |
16 | true | Used by property: ChoiceList |
| required_class_id | OBJECT |
16 | true | Used by property: RequiredClassId |
| reflective_prop_id | GUID |
16 | true | Used by property: ReflectivePropertyId |
| deletion_action | INTEGER |
4 | true | Used by property: DeletionAction |
| security_propagation | INTEGER |
4 | true | This value is an internal value that is a function of PropertyDefinition.SecurityProxyType. |
| table_id | OBJECT |
16 | true | Used by property: TableDefinition |
| column_id | GUID |
16 | true | Used by property: ColumnId |
| list_is_set_bool | BOOLEAN |
2 | true | Used by property: RequiresUniqueElements |
| required_access | INTEGER |
4 | true | Used by property: TargetAccessRequired |
| allowed_changes | INTEGER |
4 | false | Indicates whether changes can be applied to this PropertyDefinition's default value. This value is typically true, but can be false for a number of system-owned properties. |
| settability | INTEGER |
4 | true | Used by property: Settability |
| copy_to_reservation | BOOLEAN |
2 | true | Used by property: CopyToReservation |
| modification_access | INTEGER |
4 | true | Used by property: ModificationAccessRequired |
| allows_foreign_object | BOOLEAN |
2 | true | Used by property: AllowsForeignObject |
| marking_set_id | OBJECT |
16 | true | Used by property: MarkingSet |
| use_long_column | BOOLEAN |
2 | true | Used by property: UsesLongColumn |
| is_cbr_enabled | BOOLEAN |
2 | true | Used by property: IsCBREnabled |
| persistence_type | INTEGER |
4 | true | Used by property: PersistenceType |
| audit_as_id | OBJECT |
16 | true | Used by property: AuditAs |
| long_default_string | CLOB |
512 M | true | The long-string default in the property definition. Used if the UsesLongColumn property is true. |
| date_only_bool | BOOLEAN |
2 | true | Used by property: IsDateOnly |
| read_protected_bool | BOOLEAN |
2 | true | Used by property: IsReadOnly |
| cbr_propagation | INTEGER |
4 | true | Used by property: CBRPropagationType |
QueueItem Table
Used by classes: AsyncUpgradeQueueItem, DocumentClassificationQueueItem, EventQueueItem
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| dequeue_host | STRING |
15 | true | Used by property: DequeueHost |
| retry_count | INTEGER |
4 | false | Used by property: RetryCount |
| queued_object_id | OBJECT |
16 | true | Used by property: QueuedObject |
| queued_object_id_class | GUID |
16 | true | The ID of the class of the queued object referred to by queued_object_id. |
| serialized_data | BLOB |
1G | true | A binary representation of the event object that is being queued for asynchronous execution. |
| event_operation | INTEGER |
4 | true | Used by property: AsyncUpgradeType |
| next_retry_date | DATE |
10 | true | Used by property: NextRetryDate |
| lease_expiry_date | DATE |
10 | true | A datetime value that indicates that a server is processing async events in the QueueItem table; this mechanism is used to ensure that only one server is processing a particular item at any given time. |
| impersonation_user | STRING |
4000 | true | The principal name of the user that initiated an asynchronous event. On upgrades, this value is null and the initiating_user value on the Event table is used. |
RecoveryBin Table
Used by class: CmRecoveryBin
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
RecoveryItem Table
Used by class: CmRecoveryItem
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| recovery_bin_id | GUID |
16 | true | Used by property: RecoveryBin |
| deleted_object_blob | BLOB |
1G | true | The original object that was deleted plus any objects that are referenced by OVPs. |
| cleanup_commands | BLOB |
1G | true | Not supported in this release. |
| recoverable_count | INTEGER |
4 | true | Used by property: RecoverableObjectsCount |
| original_object_id | OBJECT |
16 | true | Used by properties: OriginalObject, OriginalId |
| original_class_id | GUID |
16 | true | Used by property: OriginalClassId |
| original_name | STRING |
255 | true | Used by property: OriginalName |
| original_creator | STRING |
80 | true | Used by property: OriginalCreator |
| original_create_date | DATE |
10 | true | Used by property: OriginalDateCreated |
| original_modify_user | STRING |
80 | true | Used by property: OriginalLastModifier |
| original_modify_date | DATE |
10 | true | Used by property: OriginalDateLastModified |
| original_object_id_class | GUID |
16 | true | The class of the original object that was marked for deletion. |
Relationship Table
Used by classes: DynamicReferentialContainmentRelationship, ReferentialContainmentRelationship
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| head_id | OBJECT |
16 | true | Used by property: Head |
| head_id_class | GUID |
16 | true | Identifies the class of the object that is identified by the head_id column in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| tail_id | OBJECT |
16 | false | Used by property: Tail |
| version_series_id | GUID |
16 | true | Used by property: VersionSeries |
| propagate_security | BOOLEAN |
2 | true | If this column contains a value of 1, that signifies that the object that is identified by the column head_id in this row inherits security from the object that is identified by the tail_id column in this row. |
| name | STRING |
255 | true | Used by property: ContainmentName |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
ReplicationQueue Table
Used by class: ReplicationJournalEntry
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | true | This column is not used by the server. Its value is either null or the zero ID and it exists for consistency. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. Some (lock) records set this value to the local object store ID. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| source_object_id | OBJECT |
16 | true | Used by property: SourceObject |
| source_object_id_class | GUID |
16 | true | The class ID corresponding to ReplicationJournalEntry.SourceObject. |
| destination_id | OBJECT |
16 | false | Used by property: DestinationRepository |
| destination_id_class | GUID |
16 | true | The class ID corresponding to ReplicationJournalEntry.DestinationRepository. This value is a subclass ID of Repository. |
| replication_group_id | OBJECT |
16 | false | Used by property: ReplicationGroup |
| operation | INTEGER |
4 | true | Used by property: ReplicationOperation |
| serialized_data | BLOB |
1G | true | Contains additional data set by the replication provider and associated with the replication request. |
| seqnum_identity | BINARY |
8 | false | Sequence value that is used to order queue entries. |
| held_until_date | DATE |
10 | true | Used by property: HeldUntilDate |
| retry_count | INTEGER |
4 | true | Used by property: RetryCount |
| lease_holder_id | GUID |
16 | true | Identifies the replication task that is assigned to process this replication entry. |
| lease_count | INTEGER |
4 | true | Indicates the number of times that processing of this row has been attempted. |
| status | INTEGER |
4 | true | Used by property: ReplicationStatus |
| last_failure_desc | CLOB |
512 M | true | Used by property: LastFailureReason |
| exclusion_id | GUID |
16 | true | Used during the processing of replication entries and corresponds to the replicated object's ID or, in the case of documents, the object's version series ID. |
RoleAccessDef Table
Stores the elements of the RoleAccessDefinitions list of a CmRoleClassDefinition.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: ID (CmRoleAccessDefinition ID) |
| object_class_id | GUID |
16 | false | Used by property: ClassDefinition (CmRoleAccessDefinition) |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| access_class_id | GUID |
16 | false | Used by property: ControlledClass |
| access_mask | INTEGER |
4 | true | Used by property: AccessMask |
RoleCacheUSN Table
No direct mapping to a Content Engine class. Used by the active cache refresh mechanism for roles.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| usn_index | INTEGER |
4 | false | Update sequence number index. |
| cache_usn | INTEGER |
4 | false | Cache update sequence number. |
RoleObject Table
Object Type: CmRole. Stores instances of role objects (CmRole subclass instance).
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: ID (CmRole ID) |
| object_class_id | GUID |
16 | false | Used by property: ClassDefinition (CmRoleClassDefinition) |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| replication_group_id | GUID |
16 | true | Used by property: ReplicationGroup |
| recovery_item_id | GUID |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
| serialized_data | BLOB |
1G | false | Binary data that represents this role object. |
| cache_usn | INTEGER |
4 | false | Cache update sequence number. |
| usn_index | INTEGER |
4 | false | Update sequence number index. |
| description | STRING |
255 | true | Used by property: DescriptiveText |
ScfData Table
Used internally.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| scf_id | INTEGER |
4 | false | Used internally. |
| binary_data | BINARY |
64 | true | Used internally. |
SecurityDesc Table
Used by internal server class SecurityDescriptor.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. |
| reference_count | INTEGER |
4 | false | Unused |
| hash | INTEGER |
4 | false | Hash of the nt_security_descriptor blob. This value is used to quickly look up Security Descriptors based on value. |
| nt_security_descriptor | BLOB |
1G | false | Blob holding a serialized structure with the following members: protected flag, owner SID, current security template ID (if any), and a permission list. Because this value is a packed structure, it cannot be used for queries. The permission list is in canonical order because the blob is hashed for quick lookup by value. |
| cache_pre_load | BOOLEAN |
2 | true | Unused |
SecurityPolicy Table
Used by class: SecurityPolicy
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| preserve_direct_permissions | BOOLEAN |
2 | false | Used by property: PreserveDirectPermissions |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
SecurityTemplate Table
Used by class: SecurityTemplate
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | GUID |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id | GUID |
16 | true | Identifies the ID of the parent class. |
| display_name | STRING |
64 | true | SecurityTemplate.DisplayName |
| is_enabled | BOOLEAN |
2 | false | Boolean value that indicates whether this template is enabled or not. |
| apply_state_id | GUID |
16 | false | Special ID used when the template is applied. This ID can be a preset ID for Superseded, Released, In Process and Reservation, or the ID can be user-defined. |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
SidToGuid Table
Used internally by the server to map principal (user/group) SIDs (Security Identifiers) to GUIDs to implement Security Principal Valued Properties.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| sid | BINARY |
900 | false | Corresponds to the SID of the user or group. Used by property: Id (on User or Group). |
| object_id | GUID |
16 | false | Maps the value in the sid column to a GUID. This GUID is then used by various tables where the value of security-principal valued property is stored. |
SiteSettings Table
Used by class: SiteSettings
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the position of this item relative to others in the same list of items. |
| parent_id | GUID |
16 | true | Identifies the ID of the parent class. |
| site_id | OBJECT |
16 | true | Used by property: Site |
| replica_type | INTEGER |
4 | true | The type of the device that is overridden by site-specific properties, for example, file system or fixed content device. |
StorageClass Table
Used by classes: StoragePolicy, FixedStorageArea, FileStorageArea, DatabaseStorageArea, StorageArea, CmAdvancedStorageArea
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| repository_type | STRING |
16 | true | Obsolete |
| fs_ads_path | STRING |
1200 | true | Used by properties: StagingAreaPath, RootDirectoryPath |
| db_opt_hint | INTEGER |
4 | true | Obsolete |
| content_cached | INTEGER |
4 | true | Used by property: AllowsContentToBeCached |
| area_status | INTEGER |
4 | true | Used by property: ResourceStatus |
| closure_date | DATE |
10 | true | Used by property: ClosureDate |
| element_count | DOUBLE |
8 | true | Used by property: ContentElementCount |
| elements_created | DOUBLE |
8 | true | Used by property: ContentElementsCreated |
| elements_deleted | DOUBLE |
8 | true | Used by property: ContentElementsDeleted |
| element_kbytes | DOUBLE |
8 | true | Used by property: ContentElementKBytes |
| max_elements | DOUBLE |
8 | true | Used by property: MaximumContentElements |
| max_size | DOUBLE |
8 | true | Used by property: MaximumSizeKBytes |
| database_type | INTEGER |
4 | true | Used by property: DatabaseType |
| jndi_data_source | STRING |
64 | true | Used by property: JNDIDataSource |
| jndi_xa_data_source | STRING |
64 | true | Used by property: JNDIXADataSource |
| delete_method | INTEGER |
4 | true | Used by property: DeleteMethod |
| free_threshold | INTEGER |
4 | true | Obsolete |
| free_warning | INTEGER |
4 | true | Obsolete |
| filter_expression | CLOB |
512 M | true | Used by property: FilterExpression |
| fixed_content_device_id | OBJECT |
16 | true | Used by property: FixedContentDevice |
| site_id | GUID |
16 | true | Used by property: Site |
| resource_string | STRING |
512 | true | Used by property: ResourceString |
| allows_delete | BOOLEAN |
2 | true | Used by property: AllowsDelete |
| index_area_id | GUID |
16 | true | Unique identifier for the content based index that is associated with this storage area. |
| original_filestore_id | GUID |
16 | true | Used to record the original ID of a file store before it is upgraded from version 3.5.x. Unused otherwise. |
| directory_structure | INTEGER |
4 | true | Used by property: DirectoryStructure |
| standby_activation_priority | INTEGER |
4 | true | Used by property: CmStandbyActivationPriority |
| retention_period | INTEGER |
4 | true | Used by property: RetentionPeriod |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| sis_enabled | BOOLEAN |
2 | true | Used by property: DuplicateSuppressionEnabled |
| sis_table_name | STRING |
30 | true | Contains the name of the system-generated table that is used to store reference counts when single instance storage is enabled. |
| retention_mode | INTEGER |
4 | true | Used by property: CmDeviceRetentionMode |
| encryption_enabled | BOOLEAN |
2 | true | Used by property: EncryptionEnabled |
| scf_index | INTEGER |
4 | true | The index of the encryption key for this storage area in the ScfData table. |
| compression_enabled | BOOLEAN |
2 | true | Used by property: CmCompressionEnabled |
| compression_threshold | INTEGER |
4 | true | Used by property: CmCompressionThresholdPercent |
| verification_mode | INTEGER |
4 | true | Used by property: CmContentIntegrityOptions |
| id_batch_size | INTEGER |
4 | true | Used by property: CmContentIdBatchSize |
| sync_required | INTEGER |
4 | true | Used by property: CmSynchronousReplicasRequired |
| sync_desired | INTEGER |
4 | true | Used by property: CmSynchronousReplicasDesired |
| batch_ttl | INTEGER |
4 | true | Used by property: CmContentIdBatchTTL |
| open_time_limit | INTEGER |
4 | true | Used by property: CmOpenTimeLimit |
| encryption_method | INTEGER |
4 | true | Identifies the content encryption method used by a storage area: used by CmEncryptionMethod property, value can be none (0), AES 128 bit (1), AES 256 bit (2), SM4 128 bit (3), or AES Galois 256 bit (4). |
| use_device_hold | INTEGER |
4 | true | Identifies if storage device hold is enabled for a fixed content storage area. |
StorageDevice Table
Used by classes: CmCustomStorageDevice, CmSecuredStorageDevice, CmStorageDevice, CmFileSystemStorageDevice
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | false | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| site_id | OBJECT |
16 | true | Used by property: Site |
| prog_id_string | STRING |
255 | true | Used by property: ProgId |
| code_module_id | OBJECT |
16 | true | Used by property: CodeModule |
| fs_ads_path | STRING |
1200 | true | Used by property: RootDirectoryPath |
| top_nodes | INTEGER |
4 | true | Used by property: UpperDirectoryCount |
| bottom_nodes | INTEGER |
4 | true | Used by property: LowerDirectoryCount |
| username | STRING |
128 | true | Used by property: DeviceUserName |
| password | BINARY |
128 | true | Used by property: DevicePassword |
| device_url | STRING |
1024 | true | Used by property: DeviceConnectionURL |
| authentication_url | STRING |
1024 | true | Used by property: Reserved for future use |
| container_name | STRING |
128 | true | The container_name is also used by CmS3StorgaeDevice (Property S3BucketName) and CmAzureBlobStorageDevice (property AzureContainerName). |
| sync_repl_supported | BOOLEAN |
2 | true | Used by property: SynchronousReplicationSupported |
| delete_method_supported | INTEGER |
4 | true | Used by property: DeleteMethodSupported |
| cert_validation | BOOLEAN |
2 | true | Used by property: HttpsCertValidationEnabled |
| region_name | STRING |
128 | true | Identifies the region name for the S3 bucket of CmS3StorageDevice. |
| security_token | BLOB |
1G | true | Identifies the security token associated with S3 temporary credential; used by CmS3StorageDevice. |
| lock_method | STRING |
64 | true | Identifies the vendor-specific method (protocol) to be used for device lock. |
| lock_method_history | STRING |
1024 | true | A comma-separated list of non-null values assigned to the lock method property, in chronological order with the most recent first. |
SubscribedEvent Table
Used by class: SubscribedEvent
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the pseudo-class SubscribedEvent, which exists in the metadata but not the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | The ID of the Subscription object to which this belongs. |
| parent_prop_id | GUID |
16 | false | The ID of the SubscribedEvents property of the Subscription class. |
| ordinal | INTEGER |
4 | false | A sequential numbering of the subscribed events for a subscription. |
| parent_id_class | GUID |
16 | true | Identifies the ID of the parent class. |
| event_class_id | OBJECT |
16 | false | The ID of the event to trigger the subscription (CreationEvent, UpdateEvent, and so on). |
Subscription Table
Used by classes: DocumentLifecycleAction, CmThumbnailGenerationSubscription, WorkflowEventAction, ClassWorkflowSubscription, CmSearchFunctionDefinition, DocumentLifecyclePolicy, CmTextIndexingPreprocessorAction, InstanceWorkflowSubscription, CmContentConversionAction, DocumentClassificationAction, EventAction, CmSweepAction, ClassSubscription, CmChangePreprocessorAction, InstanceSubscription
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| target_id | GUID |
16 | true | Used by property: SubscriptionTarget |
| target_id_class | GUID |
16 | true | The ID of the class to which the subscription target belongs. For subscriptions on object instances, this ID is the class of the instance; for subscriptions on a class, it is the ID of the ClassDefinition class. |
| include_subclasses | BOOLEAN |
2 | true | Used by property: IncludeSubclassesRequested |
| priority | INTEGER |
4 | true | Used by properties: Priority, CmTransactionTimeout |
| action_id | OBJECT |
16 | true | Used by properties: CodeModule, EventAction, DocumentLifecycleAction |
| is_enabled | BOOLEAN |
2 | true | Used by property: IsEnabled |
| is_synchronous | BOOLEAN |
2 | true | Used by property: IsSynchronous |
| user_string | STRING |
250 | true | Used by property: UserString |
| prog_id_string | STRING |
255 | true | Used by property: ProgId |
| script_text | CLOB |
512 M | true | Used by property: ScriptText |
| reset_lifecycle_on_checkin | BOOLEAN |
2 | true | Used by property: ResetLifecycleOnCheckin |
| classify_mime_type | STRING |
96 | true | Used by properties: CmOutputContentType, MimeType |
| workflow_definition_id | OBJECT |
16 | true | Used by property: WorkflowDefinition |
| isolated_region | INTEGER |
4 | true | Used by property: IsolatedRegionNumber |
| expression | STRING |
255 | true | This column is no longer used by the server. |
| subject | STRING |
80 | true | Used by property: Subject |
| vw_version | STRING |
255 | true | Used by property: VWVersion |
| enable_manual_launch | BOOLEAN |
2 | true | Used by property: EnableManualLaunch |
| filter_expression | CLOB |
512 M | true | Used by property: FilterExpression |
| filtered_property_name | STRING |
64 | true | Used by property: FilteredPropertyId |
| compiled_filter | BLOB |
1G | true | This column is no longer used by the server. |
| preserve_direct_permissions | BOOLEAN |
2 | true | Used by property: PreserveDirectPermissions |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| search_function_name | STRING |
130 | true | Used by property: CmFunctionName |
| conversion_class_id | OBJECT |
16 | true | Used by property: CmOutputConversion |
Sweep Table
Used by classes: CmThumbnailRequestSweep, CmCustomSweepJob, CmSweepJob, CmBulkMoveContentJob, CmBackgroundSearch, CmPolicyControlledSweep, CmThumbnailGenerationJob, CmCustomQueueSweep, CmRetentionUpdateJob, CmSweep, CmContentDeletionQueueSweep, CmQueueSweep, CmContentBackoutQueueSweep, CmContentReplicationQueueSweep
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| last_object_id | GUID |
16 | true | Last object_id of the target base table processed. |
| held_until_date | DATE |
10 | true | The time when the lease on this sweep row expires. |
| start_date | DATE |
10 | true | Used by property: SweepStartDate |
| end_date | DATE |
10 | true | Used by property: SweepEndDate |
| next_start_time | DATE |
10 | true | Used by property: NextStartTime |
| maximum_workers | INTEGER |
4 | true | Used by property: MaxSweepWorkers |
| inter_sweep_delay | INTEGER |
4 | true | Used by property: InterSweepDelay |
| objects_examined | DOUBLE |
8 | true | Used by property: ExaminedObjectCount |
| objects_processed | DOUBLE |
8 | true | Used by property: ProcessedObjectCount |
| objects_failed | DOUBLE |
8 | true | Used by property: FailedObjectCount |
| is_enabled | BOOLEAN |
2 | true | Used by property: IsEnabled |
| maximum_failures | INTEGER |
4 | true | Used by property: MaximumFailures |
| effective_begin_date | DATE |
10 | true | Used by property: EffectiveStartDate |
| effective_end_date | DATE |
10 | true | Used by property: EffectiveEndDate |
| storage_policy_id | GUID |
16 | true | Used by property: StoragePolicy |
| sweep_target_id | OBJECT |
16 | true | Used by property: SweepTarget |
| include_subclasses | BOOLEAN |
2 | true | Used by property: IncludeSubclassesRequested |
| filter_expression | CLOB |
512 M | true | Used by property: FilterExpression |
| lease_holder_id | GUID |
16 | true | Identifies the sweep instance that is assigned to process this entry. |
| image_format | INTEGER |
4 | true | Used by property: ImageFormat |
| image_size | INTEGER |
4 | true | Used by property: ImageSize |
| image_color | INTEGER |
4 | true | Used by property: ImageColor |
| retry_wait_interval | INTEGER |
4 | true | Used by property: SweepRetryWaitInterval |
| batch_size | INTEGER |
4 | true | Used by property: SweepBatchSize |
| sweep_action_id | GUID |
16 | true | Used by property: SweepAction |
| current_objects_examined | DOUBLE |
8 | true | Used by property: CurrentExaminedObjectCount |
| current_objects_processed | DOUBLE |
8 | true | Used by property: CurrentProcessedObjectCount |
| current_objects_failed | DOUBLE |
8 | true | Used by property: CurrentFailedObjectCount |
| retention_duration | INTEGER |
4 | true | Used by property: RetentionDurationUpdate |
| retention_update_time_unit | INTEGER |
4 | true | Used by property: RetentionPeriodUnits |
| specific_date | DATE |
10 | true | Used by property: SpecificRetentionDate |
| base_date_property_name | STRING |
64 | true | Used by property: BaseDatePropertyName |
| completed_iterations | INTEGER |
4 | true | Used by property: CompletedIterations |
| record_failures | BOOLEAN |
2 | true | Used by property: RecordFailures |
| end_replication_after_move | BOOLEAN |
2 | true | Used by property: EndReplicationAfterMove |
| inter_batch_delay | INTEGER |
4 | true | Used by property: InterBatchDelay |
| sweep_mode | INTEGER |
4 | true | Used by property: SweepMode |
| query_timeout | INTEGER |
4 | true | Used by property: FilteredQueryTimeout |
| effective_sql | CLOB |
512 M | true | Used by property: EffectiveSQL |
| last_failure_reason | CLOB |
512 M | true | Used by property: LastFailureReason |
| failure_count | INTEGER |
4 | true | Used by property: FailureCount |
| search_continuation_cookie | CLOB |
512 M | true | Search continuation cookie for a paged search, which is stored by a background search. |
| search_object_store_id | OBJECT |
16 | true | Used by property: SearchObjectStore |
| maximum_row_count | INTEGER |
4 | true | Used by property: MaximumExaminedRowCount |
| current_objects_deferred | DOUBLE |
8 | true | Used by property: CurrentDeferredObjectCount |
| objects_deferred | DOUBLE |
8 | true | Used by property: DeferredObjectCount |
| copy_retained | BOOLEAN |
2 | true | Used by property: CopyRetainedContent |
| update_storage_policy | INTEGER |
4 | true | Indicates that a bulk move content job should update that storage policy of the Document or Annotation to the target policy after the content is moved. |
SweepPolicy Table
Used by classes: CmCustomSweepPolicy, CmRetentionUpdatePolicy, CmDisposalPolicy, CmContentMigrationPolicy, CmSweepPolicy
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| display_name | STRING |
64 | true | Used by property: DisplayName |
| description | STRING |
255 | true | Used by property: DescriptiveText |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| is_enabled | BOOLEAN |
2 | true | Used by property: IsEnabled |
| include_subclasses | BOOLEAN |
2 | true | Used by property: IncludeSubclassesRequested |
| effective_begin_date | DATE |
10 | true | Used by property: EffectiveStartDate |
| effective_end_date | DATE |
10 | true | Used by property: EffectiveEndDate |
| storage_policy_id | GUID |
16 | true | Used by property: StoragePolicy |
| filter_expression | CLOB |
512 M | true | Used by property: FilterExpression |
| retention_duration | INTEGER |
4 | true | Used by property: RetentionDurationUpdate |
| sweep_target_id | OBJECT |
16 | true | Used by property: SweepTarget |
| specific_date | DATE |
10 | true | Used by property: SpecificRetentionDate |
| base_date_property_name | STRING |
64 | true | Used by property: BaseDatePropertyName |
| retention_update_time_unit | INTEGER |
4 | true | Used by property: RetentionPeriodUnits |
| objects_examined | DOUBLE |
8 | true | Used by property: ExaminedObjectCount |
| objects_processed | DOUBLE |
8 | true | Used by property: ProcessedObjectCount |
| sweep_action_id | GUID |
16 | true | Used by property: SweepAction |
| objects_failed | DOUBLE |
8 | true | Used by property: FailedObjectCount |
| current_objects_examined | DOUBLE |
8 | true | Used by property: CurrentExaminedObjectCount |
| current_objects_processed | DOUBLE |
8 | true | Used by property: CurrentProcessedObjectCount |
| current_objects_failed | DOUBLE |
8 | true | Used by property: CurrentFailedObjectCount |
| completed_iterations | INTEGER |
4 | true | Used by property: CompletedIterations |
| fail_record_iteration_keep | INTEGER |
4 | true | Used by property: SweepResultIterationKeepCount |
| end_replication_after_move | BOOLEAN |
2 | true | Used by property: EndReplicationAfterMove |
| sweep_mode | INTEGER |
4 | true | Used by property: SweepMode |
| update_storage_policy | INTEGER |
4 | true | Indicates that a bulk move content job should update that storage policy of the Document or Annotation to the target policy after the content is moved. |
| authorization_mode | INTEGER |
4 | true | Stores the value of the CmDisposalPolicy.AuthorizationMode property. |
SweepRelationship Table
Used by classes: CmSweepPolicyRelationship, CmSweepRelationship
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| policy_id | OBJECT |
16 | true | Used by property: SweepSubscriber |
| policy_id_class | GUID |
16 | true | The class ID corresponding to CmSweepRelationship.SweepSubscriber. |
| sweep_id | OBJECT |
16 | false | Used by property: Sweep |
SweepResult Table
Used by classes: CmPolicySweepResult, CmSweepResult, CmJobSweepResult
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| source_object_id | GUID |
16 | true | Used by property: SourceObject |
| source_object_id_class | GUID |
16 | true | The class ID corresponding to SweepResult.SourceObject. |
| controlling_object_id | GUID |
16 | true | Used by property: ControllingObject |
| controlling_object_id_class | GUID |
16 | true | The class ID corresponding to SweepResult.ControllingObject. |
| failure_description | STRING |
1024 | true | Used by property: FailureDescription |
| iteration_number | INTEGER |
4 | true | Used by property: IterationNumber |
| sweep_result_type | INTEGER |
4 | true | Used by property: SweepResultType |
TableDefinition Table
Used by class: TableDefinition
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| table_name | STRING |
30 | false | Used by property: TableName |
| table_type | INTEGER |
4 | false | Indicates the type of table to which this TableDefinition corresponds. |
| overflow_table_id | OBJECT |
16 | true | Identifies the TableDefinition corresponding to the next overflow table associated with this TableDefinition. |
Task Table
Used by class: CmTask
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| state | INTEGER |
4 | true | Used by property: TaskState |
| coordinator_id | OBJECT |
16 | true | Used by property: Coordinator |
| coordinator_id_class | GUID |
16 | true | Identifies the class of the object that is identified by the coordinator_id column in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| start_date | DATE |
10 | true | Used by property: DateStarted |
| complete_date | DATE |
10 | true | Used by property: DateCompleted |
| last_failure_desc | CLOB |
512 M | true | Used by property: LastFailureReason |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
TaskRelationship Table
Used by class: CmTaskRelationship
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| predecessor_id | OBJECT |
16 | true | Used by property: PredecessorTask |
| successor_id | OBJECT |
16 | true | Used by property: SuccessorTask |
| defines_alt_predecessor | BOOLEAN |
2 | true | Used by property: CmDefinesAlternatePredecessor |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
TextIndex Table
Used by class: CmTextSearchIndex
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID | 16 | true | Identifies the ID of the parent class. |
| create_date | DATE |
10 | true | Identifies the date this Text Search index was created. |
| index_name | STRING |
4000 | false | Identifies the name of the Text Search Index |
| status | INTEGER |
4 | false | Identifies the status of the Text Search index. It can take one of the OPEN, CLOSE, and FULL states. |
| current_index_server | GUID |
16 | true | Identifies the ID of the TextSearch Server that is assigned to index into this index. |
| lease_expiry_time | DATE |
10 | true | Identifies the expiration time that the CurrentIndexServer has exclusive write access to this index. |
| index_object_count | DOUBLE |
8 | true | The number of objects in this Text Search index. |
| index_size_kb | DOUBLE |
8 | true | The size in KB of the Text Search Index. |
| indexing_status | INTEGER |
4 | true | Used to track when a full-text index is being rebalanced to a new indexing server, or when a full-text index is being replaced by an index job. |
| recent_ops_submitted | INTEGER |
4 | true | Used to load balance indexing server assignments to a full-text index based on the indexing workload activity. |
| recent_ops_duration | DOUBLE |
8 | true | Used to load balance indexing server assignments to a full-text index based on the indexing workload activity. |
TextIndexPartition Table
Used by class: CmTextSearchPartitionProperty
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID | 16 | true | Identifies the ID of the parent class. |
| partition_prop_name | STRING |
4000 | false | Identifies the property name for the Text search index partition, which is a property in the object store that is to be used as an index partitioning property. |
| datatype | INTEGER |
4 | false | Identifies the data type of the index partition. Only Date and String data types are valid. |
| partition_start_date | DATE |
10 | true | Identifies the start date, in Coordinated Universal Time format, of the date range of a date partitioned index. Objects that are indexed in this Index have partitioning dates no earlier than this date. The property is set when this index is created |
| partition_end_date | DATE |
10 | true | Identifies the end date, in Coordinated Universal Time format, of the date range of a date partitioned index. Objects that are indexed in this Index have partitioning dates no earlier than this date. The property is set when this index is created |
| partition_string_val | STRING |
4000 | true | Partition property name value for the String type partitioning. |
Thumbnail Table
Used by class: CmThumbnail
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | false | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| replication_group_id | OBJECT |
16 | true | Used by property: ReplicationGroup |
| input_document | OBJECT |
16 | true | Used by property: InputDocument |
| element_sequence_number | INTEGER |
4 | true | Used by property: ElementSequenceNumber |
| image | BLOB |
1G | true | Used by property: Image |
| image_size | INTEGER |
4 | true | Used by property: ImageByteCount |
| mime_type | STRING |
96 | true | Used by property: MimeType |
| is_system_generated | BOOLEAN |
2 | true | Used by property: IsSystemGenerated |
| recovery_item_id | OBJECT |
16 | true | If the object is marked for deletion, this column contains the ID of the CmRecoveryItem object that references this object. |
ThumbnailRequest Table
Used by class: CmThumbnailRequest
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Used by property: ClassDescription |
| security_id | GUID |
16 | true | Indirectly identifies the permissions of the object that is stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
| epoch_id | INTEGER |
4 | false | Identifies the UpdateSequenceNumber of the object that is stored in this row. Each time the object is updated, this value increases by 1. |
| home_id | GUID |
16 | true | Identifies the foreign object store in which this object is stored. If non-null, most of the information that pertains to this object is in the object store that is identified by this column's value. |
| creator | STRING |
80 | true | Used by property: Creator |
| create_date | DATE |
10 | true | Used by property: DateCreated |
| modify_user | STRING |
80 | true | Used by property: LastModifier |
| modify_date | DATE |
10 | true | Used by property: DateLastModified |
| held_until_date | DATE |
10 | true | Used by property: HeldUntilDate |
| lease_holder_id | GUID |
16 | true | Used by property: LeaseHolderId |
| failure_count | INTEGER |
4 | true | Used by property: FailureCount |
| last_failure_reason | CLOB |
512 M | true | Used by property: LastFailureReason |
| entry_status | INTEGER |
4 | true | Used by property: QueueEntryStatus |
| deferral_count | INTEGER |
4 | true | Used by property: DeferralCount |
| deferral_data | BLOB |
1G | true | Used by property: DeferralData |
| input_document | OBJECT |
16 | true | Used by property: InputDocument |
| element_sequence_number | INTEGER |
4 | true | Used by property: ElementSequenceNumber |
Timeslot Table
Used by class: CmTimeslot
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| object_id | OBJECT |
16 | false | Used by property: Id |
| object_class_id | GUID |
16 | false | Indirectly identifies the class of the object that is stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| parent_id | OBJECT |
16 | false | Identifies the parent object of this dependent object. This value corresponds to the object_id column in the table in which the parent object is located. |
| parent_prop_id | GUID |
16 | false | Identifies the property of the parent object to which this row applies. |
| ordinal | INTEGER |
4 | false | Identifies the relative position of this item relative to others in the same list of items. |
| parent_id_class | GUID | 16 | true | Identifies the ID of the parent class. |
| slot_weekday | INTEGER |
4 | true | Used by property: Weekday |
| start_mins_past_midnight | INTEGER |
4 | true | Used by property: StartMinutesPastMidnight |
| slot_duration | INTEGER |
4 | true | Used by property: Duration |
Upgrade Table
Used internally to manage locking between server instances and threads during an object store upgrade. A row is added at the successful completion of each phase of the upgrade.
This table is not represented by a TableDefinition object.
For upgrade status, go to the automatic upgrade status page: http://server_name:port/FileNet/AutomaticUpgradeStatus.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| row_id | GUID |
16 | false | A unique ID for upgrade-phase rows, and includes the zeroID for lock usage. |
| build_number | STRING |
64 | true | Indicates the build that performs the upgrade. |
| target_schema | STRING |
64 | true | Indicates the final, statically defined schema_revision_string for the set of upgrade phases. |
| phase_name | STRING |
64 | true | Indicates the name of the phase. This name is also stored in the DDState table as the upgrade
progresses. Note: Some phase names are duplicated, indicating that the phase repeated for
each UpgradeAddOn installed.
|
| phase_start_date | DATE |
10 | true | Indicates the date when the phase started. |
| phase_end_date | DATE |
10 | true | Indicates the date when the phase was completed. |
| server_instance | STRING |
64 | true | Indicates the name of the server instance that completes the phase. |
Column Size Vendor Differences
Column size is expressed in bytes, except for the STRING type, which is expressed as the character size. For more information about column sizes and about how database large objects (LOBs) are stored, see Database Engine Differences.
| Data Type | DB2 Server Size | SQL Server Size | Oracle Size |
|---|---|---|---|
BINARY |
varies | varies | varies |
BLOB |
1G | BLOB columns are stored as the IMAGE data type. For column sizes, see SQL Server documentation. |
BLOB columns are stored with the BLOB data type. For column sizes, see Oracle documentation. |
BOOLEAN |
2 | 1 | varies |
CLOB |
512 M | CLOB columns are stored as the NTEXT data type. For column sizes, see SQL Server documentation. |
CLOB columns are stored with the CLOB data type. For column sizes, see Oracle documentation. |
DATE |
10 | 8 | 6 |
DOUBLE |
8 | 8 | 8 |
GUID |
16 | 16 | 16 |
INTEGER |
4 | 4 | varies |
INTEGER64 |
8 | 8 | varies |
OBJECT |
16 | 16 | 16 |
STRING |
Byte size is 2X the character count. | Byte size is 2X the character count. | Byte size is 3X the character count. The Oracle STRING type is limited to 1333 characters (3999 bytes). |