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.2.1 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.
Table Name | Object Type |
---|---|
AddOnRecord | AddOnInstallationRecord |
AliasId | IdList |
Annotation | Annotation |
AuditDefinition | AuditDefinition |
AuditPolicy | CmAuditDispositionPolicy |
AuditProcessing | CmAuditProcessingBookmark |
ClassDefinition | ClassDefinition and its subclasses (DocumentClassDefinition, EventClassDefinition, ReplicableClassDefinition, SubscribableClassDefinition, VersionableClassDefinition) |
ColumnDefinition | ColumnDefinition |
ComponentRelation | ComponentRelationship |
Container | Folder |
Content | ContentTransfer |
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 | PropertyBinaryList |
ListOfBoolean | PropertyBooleanList |
ListOfDateTime | PropertyDateTimeList |
ListOfFloat64 | PropertyFloat64List |
ListOfId | PropertyIdList |
ListOfInteger32 | PropertyInteger32List |
ListOfString | PropertyStringList |
LocalizedString | LocalizedString |
PreprocessorDefinition | ChangePreprocessorDefinition |
PropertyDefinition | PropertyDefinition and its subclasses (PropertyDefinitionBinary, PropertyDefinitionBoolean, PropertyDefinitionDateTime, PropertyDefinitionFloat64, PropertyDefinitionId, PropertyDefinitionInteger32, PropertyDefinitionObject, PropertyDefinitionString) |
PublishRequest | PublishRequest |
QueueItem | QueueItem and its subclasses (AsyncUpgradeQueueItem, DocumentClassificationQueueItem, EventQueueItem, SecurityPropagationQueueItem) |
RecoveryBin Table | CmRecoveryBin |
RecoveryItem Table | CmRecoveryBin |
Relationship | DynamicReferentialContainmentRelationship, ReferentialContainmentRelationship |
ReplicationQueue | ReplicationJournalEntry |
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, CmOpenStackStorageDevice, 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. |
VerityCollection | VerityCollection |
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. |
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. |
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. |
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. |
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. |
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 |
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 |
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 |
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 |
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. |
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. |
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. |
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. |
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. |
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 |
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 |
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. |
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 |
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. |
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. |
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. |
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 |
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. |
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. |
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. |
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. |
device_id | OBJECT | 16 | true | Used by property: StorageDevice |
replica_type | INTEGER | 4 | true | Used by property: ReplicaSynchronizationType |
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. |
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. |
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 |
Used by classes: UnfileEvent, PublishRequestEvent, RetrievalEvent, ClassifyCompleteEvent, CmRecoverEvent, UpdateSecurityEvent, LockEvent, ChangeStateEvent, UpdateEvent, ChangeClassEvent, FileEvent, AuditConfigurationEvent, CheckoutEvent, QueryEvent, CreationEvent, Event, CancelCheckoutEvent, GetObjectEvent, PromoteVersionEvent, CustomEvent, PublishCompleteEvent, 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 |
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. |
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 |
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. |
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 |
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. |
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 property template to which this property is aliased depending on whether this value is a ClassDefinition.AliasIds or PropertyDefinition.AliasIds value. |
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 |
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). |
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 |
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. |
Used by classes: CmTextSearchIndexArea, VerityIndexArea, 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 |
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. |
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 |
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. |
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 |
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 |
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. |
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. |
Used by classes: CmVerityIndexRequest, 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 |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
locale_name | STRING | 16 | false | Used by property: LocaleName |
text | STRING | 4000 | false | Used by property: LocalizedText |
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. |
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 |
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. |
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 |
Used by class: PublishRequest
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 |
epoch_id | INTEGER | 4 | 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. |
security_id | GUID | 16 | 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 |
publishing_status | INTEGER | 4 | false | Used by property: PublishingStatus |
status_description | STRING | 255 | true | Used by property: StatusDescription |
input_document | OBJECT | 16 | false | Used by property: InputDocument |
output_folder | OBJECT | 16 | false | Used by property: OutputFolder |
publish_request_type | INTEGER | 4 | true | Used by property: PublishRequestType |
publish_template | OBJECT | 16 | false | Used by property: PublishTemplate |
publication_document | OBJECT | 16 | true | Used by property: PublicationDocument |
publish_style_template | OBJECT | 16 | true | Used by property: PublishStyleTemplate |
apply_definition | CLOB | 512 M | true | Used by property: ApplyDefinition |
initiating_user | STRING | 255 | true | Used by property: InitiatingUser |
error_code | STRING | 255 | true | Used by property: ErrorCode |
error_description | STRING | 255 | true | Used by property: ErrorDescription |
retry_count | INTEGER | 4 | false | Used by property: RetryCount |
next_retry_date | DATE | 10 | true | Used by property: NextRetryDate |
dequeue_host | STRING | 15 | true | Used by property: DequeueHost |
lease_expiry_date | DATE | 10 | true | A datetime value that indicates that a request is being processed; this mechanism is used to ensure that only one server is processing a particular item at a given time. |
Used by classes: SecurityPropagationQueueItem, 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. |
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. |
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. |
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. |
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. |
Used internally.
ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
---|---|---|---|---|
scf_id | INTEGER | 4 | false | Used internally. |
binary_data | BINARY | 64 | true | Used internally. |
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 |
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 |
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. |
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. |
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. |
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. |
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. |
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 |
Used by classes: CmCustomStorageDevice, CmOpenStackStorageDevice, CmSecuredStorageDevice, CmStorageDevice, CmFileSystemStorageDevice
ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
---|---|---|---|---|
object_id | OBJECT | 16 | false | Used by property: Id |
container_name | STRING | 128 | true | Used by property: OpenStackContainerName |
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: OpenStackAuthenticationURL |
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 |
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. |
event_class_id | OBJECT | 16 | false | The ID of the event to trigger the subscription (CreationEvent, UpdateEvent, and so on). |
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 |
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 |
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 |
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 |
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 |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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 |
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. |
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 |
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. |
Used by class: VerityCollection
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. |
collection_name | STRING | 100 | false | Identifies the name of the Verity Collection |
status | INTEGER | 4 | false | Identifies the status of the Verity collection. It can take one of the OPEN, CLOSE, and FULL states |
original_ordinal | INTEGER | 4 | true | Unused |
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. |
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. |
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). |