This topic 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 has been 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 presented in this topic.
The set of database tables described in this topic are created for one object store. If multiple object stores share a database connection, then there will be a separate set of tables in the database for each object store that shares the same connection. To distinguish identical table names between object stores, the table names are prepended with a unique schema name.
The schemas are based on the 5.2.0 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, with the exception of 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 |
|---|---|
| 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 |
| ContentQueue | No direct mapping to a Content Engine class. |
| ContentSearch | ContentSearch |
| ContentUpload | No direct mapping to a Content Engine class. |
| Cvl | ChoiceList |
| CvlElement | Choice |
| DDState | No direct mapping to a Content Engine class. |
| 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) |
| 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) |
| StorageClass | StorageArea and its subclasses (DatabaseStorageArea, FileStorageArea) |
| SubscribedEvent | SubscribedEvent |
| Subscription | DocumentClassificationAction, DocumentLifecycleAction, DocumentLifecyclePolicy, EventAction and its subclasses (WorkflowEventAction), Subscription and its subclasses (ClassSubscription, ClassWorkflowSubscription, InstanceSubscription, InstanceWorkflowSubscription) |
| Sweep | CmThumbnailRequestSweep, CmCustomSweepJob, CmBulkMoveContentJob, CmPolicyControlledSweep, CmThumbnailGenerationJob, CmCustomQueueSweep, CmCustomQueueSweep, CmSweep, CmQueueSweep |
| SweepPolicy | CmRetentionUpdatePolicy, CmDisposalPolicy, CmSweepPolicy |
| SweepRelationship | CmSweepPolicyRelationship, CmSweepRelationship |
| SweepResult | CmSweepResult, 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 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 resides. |
| 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 this is a ClassDefinition.AliasIds or PropertyDefinition.AliasIds value. |
| class_id | GUID | 16 | false | Identifies the class of object being aliased. If the aliased object is a ClassDefinition, this will identify the ClassDefinition itself, otherwise this identifies the ClassDefinition of the aliased PropertyDefinition. 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 listing the MIME types of each content element 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 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 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 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 or not the Content Element is a Content Transfer or a Content Reference and whether or not 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 indicating 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 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 resides. |
| 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 | 512M | 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| 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 ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| 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 ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore identified by this column's value. |
| last_processed | DOUBLE | 8 | false | Used by property: LastProcessed |
Used by classes: CmQueueEntryClassDefinition, ReplicableClassDefinition, VersionableClassDefinition, ClassDefinition, DocumentClassDefinition, SubscribableClassDefinition, EventClassDefinition
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 will match object_id. For subclass definitions, this value will point 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 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 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 resides. |
| 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 containing 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 will allow a user index index (true) or not (false). This value is a function of the underlying database and the column's datatype. Generally speaking all datatypes 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 will correspond 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 identified by the child_component_id column in this row is located. If this column is null, the Document resides in the same object store as this row. |
| child_version_series_id_home | OBJECT | 16 | true | Identifies a foreign object store where the Version Series object identified by the child_version_series_id column in this row is located. If this column is null, the Version Series resides 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 consisting of the UUID of the owning document or annotation concatenated with an integer indicating 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 only used when the content duplication suppression feature is enabled for database content. |
| scf_data | BINARY | 32 | true | Cryptographic nonce used when content encryption is enabled for database storage. |
Holds queued content operations for content 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 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 identified by object_id. |
| lease_expiry_date | DATE | 10 | false | A timestamp that determines how long a busy queue request will be allowed to processed before another thread attempts to reexcute 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 an executing content engine server. Each server instance generates its own session_id at start up 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 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 finalizing content upload. |
| 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 associated with this content request. |
| serialized_data | BLOB | 1G | false | A serialized property collection that contains parameters associated with the request type. |
| create_date | DATE | 10 | false | The date this queue item was created. |
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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| 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 | ERROR: no description for this column |
Used temporarily to store chunked content 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 class: ChoiceList
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 resides. |
| 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 will always correspond 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 will be null for string choices. |
| val_string | STRING | 1024 | true | Choice.StringValue. This value will be 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 located 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 will be 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 will be 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 will be 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 will be 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 will be changed whenever a StoragePolicy is created, modified or deleted. |
| async_upgrade_state | INTEGER | 4 | true | Contains the current status of any asynchronous upgrade tasks. This value will be 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 | 512M | true | Contains the database script used to create the object store. |
| external_md_epoch | GUID | 16 | true | Identifies the current epoch of the external metadata cache. This value will be 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 will be 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 currently using this table. It is used to determine if a given schema name is currently 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 if the active workload for full-text indexing needs to be rebalanced. |
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 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 given 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 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 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 listing the MIME types of each content element 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 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 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 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 or not the Content Element is a Content Transfer or a Content Reference and whether or not 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 indicating 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 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 via an exclusive check-out operation. If the row is not a reservation, or the check-out was not exclusive, this will be 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 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | 512M | 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 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 resides. |
| 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 this object corresponds to 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 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 resides. |
| 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 resides. |
| 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 PropertyTemplate to which this Property is aliased depending on whether this 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 |
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 descendent folder. There is one row for every (parent) to (descendent) 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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: IndexJob
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Identifies the last max sequence number, 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 identifying 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 | 512M | true | Used by property: LastFailureReason |
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 resides. |
| 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. |
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 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 | Indirectly identifies the class of the object stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| security_id | GUID | 16 | true | Indirectly identifies the permissions of the object 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | 512M | 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 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 resides. |
| 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. |
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 resides. |
| 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. |
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 resides. |
| 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. |
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 resides. |
| 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. |
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 resides. |
| 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. |
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 resides. |
| 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. |
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 resides. |
| 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. |
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 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 resides. |
| 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 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 resides. |
| 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 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 resides. |
| 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 containing 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 will be null for system-defined properties and corresponds to the object_id column in the GlobalPropertyDef table for PropertyTemplates (i.e., 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 will typically be true, but is 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 |
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 | Indirectly identifies the class of the object stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| epoch_id | INTEGER | 4 | false | Indirectly identifies the permissions of the object 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | 512M | 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 indicating that a request is being processed; this mechanism is used to ensure that only one server is processing any given item at any 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 | Indirectly identifies the class of the object stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| security_id | GUID | 16 | true | Indirectly identifies the permissions of the object 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 indicating 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 | 80 | true | The principal name of the user that initiated an asynchronous event. On upgrades this 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| 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 ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| 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 ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 identified by the column head_id in this row should inherit security from the object 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 | Indirectly identifies the class of the object stored in this row. This value will always correspond to the class id of ReplicationJournalEntry. |
| security_id | GUID | 16 | true | This column is not used by the server. Its value will be null or the zero Id and exists for consistency. |
| epoch_id | INTEGER | 4 | false | Identifies the UpdateSequenceNumber of the object stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore identified by this column's value. Some (lock) records will set this value to the local ObjectStore 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 will be 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 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 assigned to process this replication entry. |
| lease_count | INTEGER | 4 | true | Indicates the number of times processing of this row has been attempted. |
| status | INTEGER | 4 | true | Used by property: ReplicationStatus |
| last_failure_desc | CLOB | 512M | 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. |
Holds cryptographic keys when content encryption is enabled for a file storage area.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| scf_id | INTEGER | 4 | false | The refcountKey from the content_info column for the associated document or annotation. |
| binary_data | BINARY | 64 | true | Cryptographic nonce used when content encryption is enabled for file storage. |
Used by internal server class SecurityDescriptor.
| ColumnName | DataType | DB2 ColumnSize | AllowsNull | Description |
|---|---|---|---|---|
| security_id | GUID | 16 | false | Indirectly identifies the permissions of the object stored in this row. |
| reference_count | INTEGER | 4 | false | Unused |
| hash | INTEGER | 4 | false | Hash of the nt_security_descriptor blob. This is used to quickly lookup 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. Since this is a packed structure, it cannot be used for queries. The permission list is in canonical order since the blob will be 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 resides. |
| 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 showing whether this template is enabled or not. |
| apply_state_id | GUID | 16 | false | Special Id used when applying the template. This 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 stored in this row. This value corresponds to the security_id column of the SecurityDesc table. |
Used by classes: StoragePolicy, FixedStorageArea, FileStorageArea, DatabaseStorageArea, StorageArea
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | 512M | 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 associated with this storage area. |
| original_filestore_id | GUID | 16 | true | Used to record the original id of a file store before upgrading from 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 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 |
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 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 given subscription. |
| event_class_id | OBJECT | 16 | false | The Id of the event to trigger the subscription (CreationEvent, UpdateEvent, etc.). |
Used by classes: DocumentLifecycleAction, CmThumbnailGenerationSubscription, WorkflowEventAction, ClassWorkflowSubscription, DocumentLifecyclePolicy, InstanceWorkflowSubscription, 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 will be the class of the instance; for subscriptions on a class, it will be 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 | 512M | true | Used by property: ScriptText |
| reset_lifecycle_on_checkin | BOOLEAN | 2 | true | Used by property: ResetLifecycleOnCheckin |
| classify_mime_type | STRING | 96 | true | Used by property: 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 | 512M | 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 |
Used by classes: CmThumbnailRequestSweep, CmCustomSweepJob, CmSweepJob, CmBulkMoveContentJob, CmPolicyControlledSweep, CmThumbnailGenerationJob, CmCustomQueueSweep, CmRetentionUpdateJob, CmSweep, CmQueueSweep
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | The unique identifier of the last object processed by the sweep associated with this row. |
| 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 | 512M | true | Used by property: FilterExpression |
| lease_holder_id | GUID | 16 | true | A unique id that is used by an executor thread to claim exclusive access to the associated Sweep Job or Queue Sweep for a limited period of time. |
| 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 |
Used by classes: CmRetentionUpdatePolicy, CmDisposalPolicy, CmSweepPolicy
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 |
| filter_expression | CLOB | 512M | 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 |
| 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 |
| 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 unique identifier of the class of which the source object is a member. The source object is identified in the source_object_id column. |
| controlling_object_id | GUID | 16 | true | Used by property: ControllingObject |
| controlling_object_id_class | GUID | 16 | true | The unique identifier of the class of which the controlling object is a member. The controlling object is identified in the controlling_object_id column. |
| 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 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 | 512M | 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 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 resides. |
| 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 currently 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 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 resides. |
| 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. The value of it is aproperty 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 UTC format, of the date range of a date partitioned index. Objects indexed in this Index will 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 UTC format, of the date range of a date partitioned index. Objects indexed in this Index will 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 | Indirectly identifies the class of the object 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 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | Indirectly identifies the class of the object stored in this row. This value corresponds to the object_id column of the ClassDefinition table. |
| security_id | GUID | 16 | true | Indirectly identifies the permissions of the object 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 stored in this row. Each time the object is updated, this value increases by one. |
| home_id | GUID | 16 | true | Identifies the foreign ObjectStore in which this object is stored. If non-null, most of the information pertaining to this object will be located in the ObjectStore 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 | 512M | true | Used by property: LastFailureReason |
| entry_status | INTEGER | 4 | true | Used by property: QueueEntryStatus |
| 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 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 resides. |
| 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 performing 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 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 completing 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 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 resides. |
| 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 UTC format, of the date range of a date partitioned index. Objects indexed in this Index will 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 UTC format, of the date range of a date partitioned index. Objects indexed in this Index will have partitioning dates no earlier than this date. The property is set when this index is created. |
Column size is expressed in bytes, with the exception of the STRING type, which is expressed as the character size. For more details on column sizes, and for information 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 datatype.
For column sizes, see SQL Server documentation. |
BLOB columns are stored with the BLOB datatype.
For column sizes, see Oracle documentation. |
| BOOLEAN | 2 | 1 | varies |
| CLOB | 512M | CLOB columns are stored as the NTEXT datatype.
For column sizes, see SQL Server documentation. |
CLOB columns are stored with the CLOB datatype.
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.
Note that the Oracle STRING type is limited to 1333 characters (3999 bytes). |