NOTE Content Engine database table schemas are provided for informational purposes only; do not attempt to directly alter the contents of any Content Engine database table.
Each database table in the Content Engine database has a corresponding TableDefinition
object that is publicly exposed by the API. In addition, each TableDefinition
object has a ColumnDefinitions property that allows access to the individual ColumnDefinition
objects representing information about the fields in a table.
You can access a TableDefinition
object from the following properties:
ObjectStore
object. This property returns a collection containing all of the TableDefinition
objects in an object store. ClassDefinition
, DocumentClassDefinition
, SubscribableClassDefinition
, or VersionableClassDefinition
object. This TableDefinition
object maps to a Content Engine database table that contains information about a specific persistable class. PropertyDefinitionBinary
, PropertyDefinitionBoolean
, and so on). This TableDefinition
object maps to a Content Engine database table that contains information about a specific queryable property. Those 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. Tables that do not map directly to a class are reserved for internal use by the Content Engine server.
With the exception of the the CISequence, FNGCD, and FNGCD_ADDON tables, the listed database table schemas contain the values of the ColumnName
, DataType
, ColumnSize
, and AllowsNull
properties of each ColumnDefinition
object contained in the collection returned by each TableDefinition
object's ColumnDefinitions property.
The following table lists each Content Engine database table and the object types that it stores, if any ("**" signifies that the table does not map directly to a Content Engine class, "++" signifies that the table is not represented by a TableDefinition
object) and provides a link to its database table schema.
Table Name | Object Type |
---|---|
AliasId | IdList |
Annotation | Annotation |
AuditDefinition | AuditDefinition |
CISequence | ** ++ |
ClassDefinition | ClassDefinition , DocumentClassDefinition , EventClassDefinition , SubscribableClassDefinition , VersionableClassDefinition |
ColumnDefinition | ColumnDefinition |
ComponentRelation | ComponentRelationship |
Container | Folder |
Content | ContentTransfer |
ContentQueue | ** |
ContentSearch | ** |
ContentUpload | ** |
Cvl | ChoiceList |
CvlElement | Choice |
DDState | ** |
DocumentState | DocumentState |
DocVersion | Document , VersionSeries , WorkflowDefinition , XMLPropertyMappingScript |
Event | AuditConfigurationEvent , CancelCheckoutEvent , ChangeClassEvent , ChangeStateEvent , CheckinEvent , CheckoutEvent , ClassifyCompleteEvent , CreationEvent , CustomEvent , DeletionEvent , DemoteVersionEvent , FileEvent , GetContentEvent , GetObjectEvent , ObjectChangeEvent , PromoteVersionEvent , QueryEvent , RetrievalEvent , UnfileEvent , UpdateEvent , UpdateSecurityEvent |
FNGCD | GCD objects (Domain , VirtualServer , etc.) ++ |
FNGCD_ADDON | GCD objects (Domain , VirtualServer , etc.) ++ |
Generic | CustomObject |
GlobalPropAliasId | IdList |
GlobalPropertyDef | PropertyTemplateBinary , PropertyTemplateBoolean , PropertyTemplateDateTime , PropertyTemplateFloat64 , PropertyTemplateId , PropertyTemplateInteger32 , PropertyTemplateObject , PropertyTemplateString |
HierarchyIndex | ** |
IndexArea | IndexArea |
IndexJob | IndexJob |
IndexJobItem | IndexJobItem |
IndexRequest | ** |
Link | Link |
ListOfBinary | PropertyBinaryList |
ListOfBoolean | PropertyBooleanList |
ListOfDateTime | PropertyDateTimeList |
ListOfFloat64 | PropertyFloat64List |
ListOfId | PropertyIdList |
ListOfInteger32 | PropertyInteger32List |
ListOfString | PropertyStringList |
LocalizedString | LocalizedString |
PropertyDefinition | PropertyDefinitionBinary , PropertyDefinitionBoolean , PropertyDefinitionDateTime , PropertyDefinitionFloat64 , PropertyDefinitionId , PropertyDefinitionInteger32 , PropertyDefinitionObject , PropertyDefinitionString |
PublishRequest | PublishRequest |
QueueItem | DocumentClassificationQueueItem , EventQueueItem , SecurityPropagationQueueItem |
Relationship | DynamicReferentialContainmentRelationship , ReferentialContainmentRelationship |
SecurityDesc | ** |
SecurityPolicy | SecurityPolicy |
SecurityTemplate | ApplicationSecurityTemplate , VersioningSecurityTemplate |
StorageClass | DatabaseStoragePolicy , FileStoragePolicy |
SubscribedEvent | SubscribedEvent |
Subscription | ClassSubscription , ClassWorkflowSubscription , DocumentClassificationAction , DocumentLifecycleAction , DocumentLifecyclePolicy , EventAction , InstanceSubscription , InstanceWorkflowSubscription , WorkflowEventAction |
TableDefinition | TableDefinition |
VerityCollection | VerityCollection |
WorkQueue | ** |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id |
|
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
alias_id | GUID |
16 | false |
class_id | GUID |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | GUID |
16 | false |
object_class_id | GUID |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
storage_class |
|
16 | true |
content_size | DOUBLE |
8 | true |
annotated_id | GUID |
16 | false |
annotated_id_class | GUID |
16 | false |
annotated_element | LONG |
4 | true |
description | STRING |
255 | true |
storage_location | STRING |
64 | true |
component_types | BINARY |
100 | true |
retrieval_names | BINARY |
200 | true |
component_types_2 | BINARY |
16 | true |
retrieval_names_2 | BINARY |
16 | true |
mime_type | STRING |
64 | true |
content_info | BINARY |
96 | true |
content_info_2 | BINARY |
16 | true |
next_content_unique_id | LONG |
4 | true |
content_last_accessed_date | DATE |
8 | true |
storage_area_id |
|
16 | true |
indexation_id | GUID |
16 | true |
u1b_annotidhi | LONG |
4 | true |
u1c_annotidlow | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
event_class_id | OBJECT |
16 | false |
audit_success | BOOLEAN |
1 | false |
audit_failure | BOOLEAN |
1 | false |
include_subclasses | BOOLEAN |
1 | false |
Column Name | Data Type | Size | Allows Null |
---|---|---|---|
sn | Long | 4 | false |
val | Boolean | 1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
superclass_id | OBJECT |
16 | true |
root_class_id | GUID |
16 | false |
sup_user_instances | BOOLEAN |
1 | false |
persistent_bool | BOOLEAN |
1 | false |
sys_owned_bool | BOOLEAN |
1 | false |
table_id | OBJECT |
16 | true |
sup_user_subclasses | BOOLEAN |
1 | false |
default_instance_security_id | GUID |
16 | false |
sup_user_props | BOOLEAN |
1 | false |
symbolic_name | STRING |
64 | true |
is_hidden | BOOLEAN |
1 | true |
is_cbr_enabled | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
dbg_table_name | STRING |
20 | true |
column_name | STRING |
30 | false |
column_datatype | LONG |
4 | false |
column_size | LONG |
4 | true |
allows_null_bool | BOOLEAN |
1 | false |
allows_user_index | BOOLEAN |
1 | true |
prop_id | GUID |
16 | true |
is_single_indexed | BOOLEAN |
1 | true |
is_system_owned | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | false |
create_date | DATE |
8 | false |
modify_user | STRING |
80 | false |
modify_date | DATE |
8 | false |
child_component_id | OBJECT |
16 | true |
child_version_series_id | OBJECT |
16 | true |
parent_component_id | OBJECT |
16 | false |
copy_to_reservation | BOOLEAN |
1 | false |
name | STRING |
255 | true |
label_bind_value | STRING |
64 | true |
component_relationship_type | LONG |
4 | false |
uri_value | STRING |
2083 | true |
component_sort_order | LONG |
4 | false |
version_bind_type | LONG |
4 | true |
cascade_delete | LONG |
4 | false |
prevent_delete | LONG |
4 | false |
child_component_id_home | OBJECT |
16 | true |
child_version_series_id_home | OBJECT |
16 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | OBJECT |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
parent_container_id | OBJECT |
16 | true |
name | STRING |
255 | true |
init_container_bool | BOOLEAN |
1 | true |
lock_token | GUID |
16 | true |
lock_timeout | LONG |
4 | true |
lock_owner | STRING |
64 | true |
lock_sid | BINARY |
16 | true |
security_policy_id | OBJECT |
16 | true |
u11_ishiddencontainer | BOOLEAN |
1 | true |
u12_containertype | STRING |
64 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
element_id | STRING |
46 | false |
extension | STRING |
3 | true |
content | BINARY |
7000 | true |
content_size | LONG |
4 | false |
create_date | DATE |
8 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | GUID |
16 | false |
seqnum_identity | LONG |
4 | false |
object_class_id | GUID |
16 | false |
lease_expiry_date | DATE |
8 | false |
session_id | GUID |
16 | false |
element_sequence_number | LONG |
4 | false |
command_type | LONG |
4 | false |
process_attempts | LONG |
4 | true |
source_object_id | GUID |
16 | true |
storage_area_id | GUID |
16 | false |
content_size | DOUBLE |
8 | false |
serialized_data | BINARY |
16 | false |
create_date | DATE |
8 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | OBJECT |
16 | false |
epoch_id | LONG |
4 | false |
queried_object_id | OBJECT |
16 | false |
content | STRING |
10 | true |
rank | DOUBLE |
8 | true |
hitcount | LONG |
4 | true |
content_size | DOUBLE |
8 | true |
seq_number | LONG |
4 | true |
summary | STRING |
512 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
element_id | STRING |
46 | false |
offset | LONG |
4 | false |
create_date | DATE |
8 | true |
content | BINARY |
16 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
display_name | STRING |
64 | false |
cvl_data_type | LONG |
4 | true |
description | STRING |
255 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
parent_cvl_id | GUID |
16 | false |
val_integer | LONG |
4 | true |
val_string | STRING |
1024 | true |
choice_type | LONG |
4 | false |
nesting_level | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
id | GUID |
16 | false |
schema_revision_string | STRING |
64 | true |
folder_cache_epoch | LONG |
4 | false |
last_good_ci_sn | LONG |
4 | false |
last_good_pi_sn | LONG |
4 | false |
last_good_anno_pi_sn | LONG |
4 | false |
index_host_name | STRING |
15 | true |
index_lease_expiry | DATE |
8 | true |
index_area_epoch | LONG |
4 | true |
storage_area_epoch | LONG |
4 | true |
storage_policy_epoch | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
state_name | STRING |
4000 | true |
can_be_demoted | BOOLEAN |
1 | true |
enable_state_permissions | BOOLEAN |
1 | true |
security_id | GUID |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
storage_class | OBJECT |
16 | true |
is_reserved | BOOLEAN |
1 | false |
is_current | BOOLEAN |
1 | false |
is_frozen | BOOLEAN |
1 | false |
version_series_id | OBJECT |
16 | false |
content_size | DOUBLE |
8 | true |
lock_token | GUID |
16 | true |
lock_timeout | LONG |
4 | true |
lock_owner | STRING |
64 | true |
doc_lifecycle_policy | OBJECT |
16 | true |
doc_state | STRING |
64 | true |
is_in_exception_state | BOOLEAN |
1 | true |
storage_location | STRING |
64 | true |
component_types | BINARY |
100 | true |
retrieval_names | BINARY |
200 | true |
component_types_2 | BINARY |
16 | true |
retrieval_names_2 | BINARY |
16 | true |
mime_type | STRING |
64 | true |
content_info | BINARY |
96 | true |
content_info_2 | BINARY |
16 | true |
next_content_unique_id | LONG |
4 | true |
vw_version | STRING |
255 | true |
versioning_enabled | BOOLEAN |
1 | false |
xml_doc_type | STRING |
256 | true |
xml_target_class | OBJECT |
16 | true |
classification_state | LONG |
4 | true |
lock_sid | BINARY |
16 | true |
major_version_number | LONG |
4 | false |
minor_version_number | LONG |
4 | false |
version_status | LONG |
4 | false |
security_policy_id | OBJECT |
16 | true |
reservation_type | LONG |
4 | true |
reservation_owner_sid | BINARY |
16 | true |
content_last_accessed_date | DATE |
8 | true |
content_referral_blob | BINARY |
16 | true |
content_retention_date | DATE |
8 | true |
storage_area_id | OBJECT |
16 | true |
indexation_id | GUID |
16 | true |
compound_document_state | LONG |
4 | true |
dynamic_cr_update_status | LONG |
4 | true |
u31_documenttitle | STRING |
255 | true |
u32_componentbindinglabel | STRING |
64 | true |
u33_scenariodescription | STRING |
256 | true |
u34_simulationdescription | STRING |
256 | true |
u35_simulationstatus | STRING |
256 | true |
u36_publishingenabled | BOOLEAN |
1 | true |
u37_simulationlifespaninhours | LONG |
4 | true |
u38_scenariodefinitiondocid | STRING |
64 | true |
u39_simulationguid | STRING |
64 | true |
u3a_description | STRING |
255 | true |
u3b_searchtype | LONG |
4 | true |
u3c_searchingobjecttype | LONG |
4 | true |
u3d_searchingobjectstores | STRING |
255 | true |
u3e_applicationname | STRING |
64 | true |
u3f_publicationsource | OBJECT |
16 | true |
u40_ownerdocument | OBJECT |
16 | true |
u41_publicationinfo | BINARY |
16 | true |
u42_publishingsubsidiaryfolder | OBJECT |
16 | true |
u43_styletemplate | OBJECT |
16 | true |
u44_ignoreredirect | BOOLEAN |
1 | true |
u45_preferencetype | STRING |
64 | true |
u46_entrytemplateobjectstorena | STRING |
64 | true |
u47_entrytemplatelaunchedworkf | STRING |
64 | true |
u48_entrytemplateid | GUID |
16 | true |
u49_description | STRING |
300 | true |
u4a_targetobjecttype | STRING |
64 | true |
u4b_targetobjectclassid | GUID |
16 | true |
u4c_targetobjectstorename | STRING |
64 | true |
u4d_targetsiteid | STRING |
64 | true |
u4e_layoutid | STRING |
64 | true |
u4f_layoutversionseriesid | STRING |
64 | true |
u50_from | STRING |
255 | true |
u51_subject | STRING |
255 | true |
u52_senton | DATE |
8 | true |
u53_receivedon | DATE |
8 | true |
u54_formpolicylaunchedworkflow | STRING |
64 | true |
u55_formpolicystepdescriptor | STRING |
64 | true |
u56_formpolicy | OBJECT |
16 | true |
u57_itxformtemplate | OBJECT |
16 | true |
u58_formdescription | STRING |
64 | true |
u59_formpolicyworkflowobjectst | STRING |
64 | true |
u5a_formpolicyworkflowid | STRING |
64 | true |
u5b_formtemplate | OBJECT |
16 | true |
u5c_formtype | STRING |
64 | true |
u5d_formpolicydescription | STRING |
64 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
source_object_id | GUID |
16 | true |
source_object_class_id | GUID |
16 | true |
status | LONG |
4 | true |
serialized_source_object | BINARY |
16 | true |
query_text | STRING |
1073741823 | true |
version_series_id | GUID |
16 | true |
lifecycle_change | LONG |
4 | true |
element_name | STRING |
255 | true |
audit_level | LONG |
4 | true |
initiating_user | STRING |
255 | true |
sequence_number | LONG |
4 | true |
serialized_orig_object | BINARY |
16 | true |
Column Name | Data Type | Size | Allows Null |
---|---|---|---|
epoch_id | Long | 4 | false |
gcd_blob | Binary | 16 | false |
modify_data | Date | 8 | false |
Column Name | Data Type | Size | Allows Null |
---|---|---|---|
object_id | Object | 16 | false |
creator | String | 80 | true |
create_date | Date | 8 | true |
modify_user | String | 80 | true |
modify_date | Date | 8 | true |
xml_manifest | String | 16 | true |
pre_import_script | String | 16 | true |
post_import_script | String | 16 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
lock_token | GUID |
16 | true |
lock_timeout | LONG |
4 | true |
lock_owner | STRING |
64 | true |
lock_sid | BINARY |
16 | true |
security_policy_id | OBJECT |
16 | true |
indexation_id | GUID |
16 | true |
uf_propertylookupname | STRING |
64 | true |
u10_associatedpropertyid | GUID |
16 | true |
u11_docclassandpropertymapping | STRING |
1073741823 | true |
u12_ismappingobjectname | STRING |
64 | true |
u13_outputformat | STRING |
64 | true |
u14_providerid | STRING |
64 | true |
u15_title | STRING |
255 | true |
u16_description | STRING |
255 | true |
u17_transformationoptions | BINARY |
16 | true |
u18_pdfmasterpassword | BINARY |
16 | true |
u19_pdfuserpassword | BINARY |
16 | true |
u1a_customobjecttype | STRING |
64 | true |
u1b_rolename | STRING |
64 | true |
u1c_roletype | STRING |
64 | true |
u1d_applicationname | STRING |
64 | true |
u1e_unsecuredrole | OBJECT |
16 | true |
u1f_securedrole | OBJECT |
16 | true |
u20_securedroleid | GUID |
16 | true |
u21_formpolicylaunchedworkflow | STRING |
64 | true |
u22_formpolicy | OBJECT |
16 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
alias_id | GUID |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
datatype | LONG |
4 | false |
cardinality | LONG |
4 | false |
value_required_bool | BOOLEAN |
1 | true |
hidden_bool | BOOLEAN |
1 | true |
persistent_bool | BOOLEAN |
1 | false |
name_property_bool | BOOLEAN |
1 | true |
max_length_string | LONG |
4 | true |
max_length_binary | LONG |
4 | true |
default_binary | BINARY |
16 | true |
default_bool | BOOLEAN |
1 | true |
default_datetime | DATE |
8 | true |
default_id | GUID |
16 | true |
default_int32 | LONG |
4 | true |
default_float64 | DOUBLE |
8 | true |
default_string | STRING |
4000 | true |
minimum_datetime | DATE |
8 | true |
minimum_int32 | LONG |
4 | true |
minimum_float64 | DOUBLE |
8 | true |
maximum_datetime | DATE |
8 | true |
maximum_int32 | LONG |
4 | true |
maximum_float64 | DOUBLE |
8 | true |
cvl_id | OBJECT |
16 | true |
list_is_set_bool | BOOLEAN |
1 | true |
symbolic_name | STRING |
64 | true |
settability | LONG |
4 | true |
display_category | STRING |
64 | true |
modification_access | LONG |
4 | true |
allows_foreign_object | BOOLEAN |
1 | true |
security_proxy_type | LONG |
4 | true |
marking_set_id | OBJECT |
16 | true |
use_long_column | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | GUID |
16 | false |
child_id | GUID |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | GUID |
16 | false |
object_class_id | GUID |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
display_name | STRING |
64 | false |
description | STRING |
255 | true |
area_status | LONG |
4 | false |
site_id | GUID |
16 | true |
template_type | STRING |
128 | true |
search_servers_to_attach | LONG |
4 | true |
root_directory_path | STRING |
255 | true |
max_collections | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | GUID |
16 | false |
object_class_id | GUID |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
description | STRING |
255 | true |
time_last_processed | DATE |
8 | true |
time_all_submitted | DATE |
8 | true |
job_status | LONG |
4 | false |
job_abort_requested | BOOLEAN |
1 | false |
submitted_count | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id |
OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
indexation_id | GUID |
16 | true |
index_area_id | GUID |
16 | true |
class_definition_id | GUID |
16 | true |
single_item_id | GUID |
16 | true |
single_item_id_class | GUID |
16 | true |
include_subclasses | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | GUID |
16 | false |
target_id | GUID |
16 | false |
target_id_class | GUID |
16 | false |
operation | LONG |
4 | false |
indexation_id | GUID |
16 | true |
status | LONG |
4 | false |
request_time | DATE |
8 | false |
seqnum_identity | LONG |
4 | false |
retry_count | LONG |
4 | false |
element_sequence_number | LONG |
4 | true |
retrieval_name_ext | STRING |
64 | true |
index_job_id | GUID |
16 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
head_id | OBJECT |
16 | true |
head_id_class | OBJECT |
16 | true |
tail_id | OBJECT |
16 | false |
tail_id_class | OBJECT |
16 | true |
ud_title | STRING |
255 | true |
ue_description | STRING |
255 | true |
uf_emaildependentreference | OBJECT |
16 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | BINARY |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | BOOLEAN |
1 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | DATE |
8 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | DOUBLE |
8 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | GUID |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | LONG |
4 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
element_value | STRING |
4000 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
locale_name | STRING |
16 | false |
text | STRING |
4000 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
dbg_display_name | STRING |
32 | true |
dbg_class_name | STRING |
32 | true |
sys_owned_bool | BOOLEAN |
1 | false |
primary_id | GUID |
16 | false |
global_prop_id | OBJECT |
16 | true |
inherited_bool | BOOLEAN |
1 | false |
datatype | LONG |
4 | false |
cardinality | LONG |
4 | false |
value_required_bool | BOOLEAN |
1 | false |
hidden_bool | BOOLEAN |
1 | false |
persistent_bool | BOOLEAN |
1 | false |
name_property_bool | BOOLEAN |
1 | false |
max_length | LONG |
4 | true |
default_binary | BINARY |
16 | true |
default_bool | BOOLEAN |
1 | true |
default_datetime | DATE |
8 | true |
default_id | GUID |
16 | true |
default_int32 | LONG |
4 | true |
default_float64 | DOUBLE |
8 | true |
default_object_id | OBJECT |
16 | true |
default_object_id_class | OBJECT |
16 | true |
default_string | STRING |
4000 | true |
minimum_datetime | DATE |
8 | true |
minimum_int32 | LONG |
4 | true |
minimum_float64 | DOUBLE |
8 | true |
maximum_datetime | DATE |
8 | true |
maximum_int32 | LONG |
4 | true |
maximum_float64 | DOUBLE |
8 | true |
cvl_id | OBJECT |
16 | true |
required_class_id | OBJECT |
16 | true |
reflective_prop_id | GUID |
16 | true |
deletion_action | LONG |
4 | true |
security_propagation | LONG |
4 | true |
table_id | OBJECT |
16 | true |
column_id | GUID |
16 | true |
list_is_set_bool | BOOLEAN |
1 | true |
required_access | LONG |
4 | true |
allowed_changes | LONG |
4 | false |
settability | LONG |
4 | true |
copy_to_reservation | BOOLEAN |
1 | true |
modification_access | LONG |
4 | true |
allows_foreign_object | BOOLEAN |
1 | true |
marking_set_id | OBJECT |
16 | true |
use_long_column | BOOLEAN |
1 | true |
is_cbr_enabled | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
epoch_id | LONG |
4 | false |
security_id | GUID |
16 | true |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
publishing_status | LONG |
4 | false |
status_description | STRING |
255 | true |
input_document | OBJECT |
16 | false |
output_folder | OBJECT |
16 | false |
publish_request_type | LONG |
4 | true |
publish_template | OBJECT |
16 | false |
publication_document | OBJECT |
16 | true |
publish_style_template | OBJECT |
16 | true |
apply_definition | STRING |
1073741823 | true |
initiating_user | STRING |
255 | true |
error_code | STRING |
255 | true |
error_description | STRING |
255 | true |
retry_count | LONG |
4 | false |
next_retry_date | DATE |
8 | true |
dequeue_host | STRING |
15 | true |
lease_expiry_date | DATE |
8 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | true |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
dequeue_host | STRING |
15 | true |
retry_count | LONG |
4 | false |
queued_object_id | OBJECT |
16 | true |
queued_object_id_class | OBJECT |
16 | true |
serialized_data | BINARY |
16 | true |
event_operation | LONG |
4 | true |
next_retry_date | DATE |
8 | true |
lease_expiry_date | DATE |
8 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
head_id | OBJECT |
16 | true |
head_id_class | OBJECT |
16 | true |
tail_id | OBJECT |
16 | false |
version_series_id | GUID |
16 | true |
propagate_security | BOOLEAN |
1 | true |
name | STRING |
255 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
security_id | GUID |
16 | false |
reference_count | LONG |
4 | false |
hash | LONG |
4 | false |
nt_security_descriptor | BINARY |
4096 | false |
cache_pre_load | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
display_name | STRING |
64 | true |
description | STRING |
255 | true |
preserve_direct_permissions | BOOLEAN |
1 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | GUID |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
display_name | STRING |
64 | true |
is_enabled | BOOLEAN |
1 | false |
apply_state_id | GUID |
16 | false |
security_id | GUID |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
retention_period | LONG |
4 | true |
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
display_name | STRING |
64 | false |
description | STRING |
255 | true |
repository_type | STRING |
16 | true |
fs_ads_path | STRING |
1200 | true |
db_opt_hint | LONG |
4 | true |
content_cached | LONG |
4 | true |
area_status | LONG |
4 | true |
closure_date | DATE |
8 | true |
element_count | DOUBLE |
8 | true |
elements_created | DOUBLE |
8 | true |
elements_deleted | DOUBLE |
8 | true |
element_kbytes | DOUBLE |
8 | true |
max_elements | DOUBLE |
8 | true |
max_size | DOUBLE |
8 | true |
database_type | LONG |
4 | true |
jndi_data_source | STRING |
64 | true |
jndi_xa_data_source | STRING |
64 | true |
delete_method | LONG |
4 | true |
free_threshold | LONG |
4 | true |
free_warning | LONG |
4 | true |
filter_expression | STRING |
1073741823 | true |
fixed_content_device_id | OBJECT |
16 | true |
site_id | GUID |
16 | true |
resource_string | STRING |
512 | true |
allows_delete | BOOLEAN |
1 | true |
index_area_id | GUID |
16 | true |
original_filestore_id | GUID |
16 | true |
directory_structure | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
event_class_id | OBJECT |
16 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
display_name | STRING |
64 | true |
description | STRING |
255 | true |
target_id | GUID |
16 | true |
target_id_class | GUID |
16 | true |
include_subclasses | BOOLEAN |
1 | true |
priority | LONG |
4 | true |
action_id | OBJECT |
16 | true |
is_enabled | BOOLEAN |
1 | true |
is_synchronous | BOOLEAN |
1 | true |
user_string | STRING |
250 | true |
prog_id_string | STRING |
255 | true |
script_text | STRING |
1073741823 | true |
reset_lifecycle_on_checkin | BOOLEAN |
1 | true |
classify_mime_type | STRING |
64 | true |
workflow_definition_id | OBJECT |
16 | true |
isolated_region | LONG |
4 | true |
expression | STRING |
255 | true |
subject | STRING |
80 | true |
vw_version | STRING |
255 | true |
enable_manual_launch | BOOLEAN |
1 | true |
filter_expression | STRING |
1073741823 | true |
filtered_property_name | STRING |
64 | true |
compiled_filter | BINARY |
16 | true |
preserve_direct_permissions | BOOLEAN |
1 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | false |
epoch_id | LONG |
4 | false |
home_id | GUID |
16 | true |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
table_name | STRING |
20 | false |
table_type | LONG |
4 | false |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
parent_id | OBJECT |
16 | false |
parent_prop_id | GUID |
16 | false |
ordinal | LONG |
4 | false |
collection_name | STRING |
100 | false |
status | LONG |
4 | false |
original_ordinal | LONG |
4 | true |
ColumnName | DataType | ColumnSize | AllowsNull |
---|---|---|---|
object_id | OBJECT |
16 | false |
object_class_id | OBJECT |
16 | false |
security_id | GUID |
16 | true |
epoch_id | LONG |
4 | false |
creator | STRING |
80 | true |
create_date | DATE |
8 | true |
modify_user | STRING |
80 | true |
modify_date | DATE |
8 | true |
entry_status | STRING |
15 | true |
is_locked | BOOLEAN |
1 | true |
event_operation | STRING |
20 | true |
source_id | OBJECT |
16 | true |
source_id_class | OBJECT |
16 | true |
source_class_name | STRING |
64 | true |
dbg_object_name | STRING |
40 | true |
locker_server | STRING |
15 | true |
locker_process | LONG |
4 | true |
locker_thread | LONG |
4 | true |
date_locked | DATE |
8 | true |
connector_name | STRING |
64 | true |
retry_count | LONG |
4 | true |
serialized_data | BINARY |
16 | true |