Database Table Schemas

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:

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 **

 

 

AliasId Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
alias_id GUID 16 false
class_id GUID 16 false

 

Annotation Table

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 OBJECT 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 OBJECT 16 true
indexation_id GUID 16 true
u1b_annotidhi LONG 4 true
u1c_annotidlow LONG 4 true

 

AuditDefinition Table

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

 

CISequence Table

Column Name Data Type Size Allows Null
sn Long 4 false
val Boolean 1 true

 

ClassDefinition Table

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

 

ColumnDefinition Table

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

 

ComponentRelation Table

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

 

Container Table

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

 

Content Table

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

 

ContentQueueTable

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

 

ContentSearch Table

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

 

ContentUpload Table

ColumnName DataType ColumnSize AllowsNull
element_id STRING 46 false
offset LONG 4 false
create_date DATE 8 true
content BINARY 16 true

 

Cvl Table

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

 

CvlElement Table

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

 

DDState Table

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

 

DocumentState Table

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

 

DocVersion Table

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

 

Event Table

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

 

FNGCD Table

Column Name Data Type Size Allows Null
epoch_id Long 4 false
gcd_blob Binary 16 false
modify_data Date 8 false

 

FNGCD_ADDON Table

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

 

Generic Table

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

 

GlobalPropAliasId Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
alias_id GUID 16 false

 

GlobalPropertyDef Table

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

 

HierarchyIndex Table

ColumnName DataType ColumnSize AllowsNull
parent_id GUID 16 false
child_id GUID 16 false

 

IndexArea Table

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

 

IndexJob Table

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

 

IndexJobItem Table

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

 

IndexRequest Table

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

 

Link Table

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

 

ListOfBinary Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value BINARY 16 false

 

ListOfBoolean Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value BOOLEAN 1 false

 

ListOfDateTime Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value DATE 8 false

 

ListOfFloat64 Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value DOUBLE 8 false

 

ListOfId Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value GUID 16 false

 

ListOfInteger32 Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value LONG 4 false

 

ListOfString Table

ColumnName DataType ColumnSize AllowsNull
parent_id OBJECT 16 false
parent_prop_id GUID 16 false
ordinal LONG 4 false
element_value STRING 4000 false

 

LocalizedString Table

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

 

PropertyDefinition Table

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

 

PublishRequest Table

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

 

QueueItem Table

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

 

Relationship Table

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

 

SecurityDesc Table

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

 

SecurityPolicy Table

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

 

SecurityTemplate Table

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

 

StorageClass Table

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

 

SubscribedEvent Table

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

 

Subscription Table

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

 

TableDefinition Table

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

 

VerityCollection Table

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

 

WorkQueue Table

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