- Columns
Legend:
Primary key columns
Columns with indexes
 

Table Column Type Size Nulls Auto Default
share_pass activated bool 1
qti_assessment_item adaptive bool 1  √  null
workflow_node allow_editing bool 1  √  null
store_front allow_free bool 1
store_front allow_purchase bool 1
store_front allow_subscription bool 1
drm_settings allow_sum bool 1  √  null
bookmark always_latest bool 1
comments anonymous bool 1
drm_settings aoo bool 1  √  null
history_event applies bool 1
cla_portion artistic_works bpchar 1  √  null
workflow_node auto_action bool 1  √  null
notification batched bool 1
catalogue_assignment blacklisted bool 1
migration_log can_retry bool 1
portlet closeable bool 1
portlet_preference closed bool 1
course_info course_type bpchar 1  √  null
purchased_content deleted bool 1  √  null
moderation_status deleted_moderating bool 1  √  null
item_definition deny_direct_contribution bool 1
base_entity disabled bool 1
access_expression dynamic bool 1
drm_settings ea bool 1  √  null
harvester_profile enabled bool 1  √  null
institution enabled bool 1
kaltura_server enabled bool 1
portlet enabled bool 1
price enabled bool 1
workflow_node escalate bool 1  √  null
pricing_tier_assignment free_item bool 1
access_entry grant_revoke bpchar 1
report hide_report bool 1  √  null
hierarchy_topic hide_subtopics_with_no_result bool 1  √  null
drm_settings hlfo bool 1  √  null
cal_section illustration bool 1  √  null
cla_section illustration bool 1  √  null
hierarchy_topic inherit_freetext bool 1
portlet institutional bool 1
audit_log_lms latest bool 1
item manual_navigation bool 1
portlet minimisable bool 1
portlet_preference minimised bool 1
item moderating bool 1
workflow movelive bool 1
workflow_node movelive bool 1  √  null
workflow_node movelive_accept bool 1  √  null
migration_log must_exist bool 1
moderation_status needs_reset bool 1
harvester_profile new_version_on_harvest bool 1  √  null
drm_settings oma bool 1  √  null
sys_database_schema online bool 1  √  null
cal_holding out_of_print bool 1
cla_holding out_of_print bool 1
workflow_node_status overdue bool 1  √  null
drm_settings pa bool 1  √  null
purchase paid bool 1
order_item per_user bool 1  √  null
attachment preview bool 1
notification processed bool 1
pricing_tier purchase bool 1
cla_portion reason bpchar 1  √  null
thumbnail_request recreate bool 1  √  null
catalogue region_restricted bool 1
workflow_node reject_point bool 1
oauth_client requires_approval bool 1
attachment restricted bool 1
moderation_status resume_moderating bool 1  √  null
drm_settings rts bool 1  √  null
external_tool share_email bool 1  √  null
external_tool share_name bool 1  √  null
hierarchy_topic show_results bool 1
item show_split_option bool 1  √  null
drm_settings slc bool 1  √  null
drm_settings smaiic bool 1  √  null
cla_portion source bpchar 1  √  null
workflow_node_status status bpchar 1
referencedurl success bool 1
base_entity system_type bool 1
qti_assessment_item time_dependent bool 1  √  null
audit_log_lms type bpchar 1
workflow_message type bpchar 1
workflow_node type bpchar 1
workflow_node unanimousacceptance bool 1  √  null
moderation_status unarchive_moderating bool 1  √  null
connector use_logged_in_username bool 1
sys_database_schema use_system bool 1
tomcat_sessions valid bpchar 1
store_front country varchar 4
notification reason varchar 8
activate_request type varchar 8
item rating float4 8,8
tax_type pct numeric 9,4
sale tax_percent numeric 9,4  √  null
access_entry acl_order int4 10
access_entry acl_priority int4 10
workflow_node action_days int4 10  √  null
portlet_recent_contrib age_days int4 10
pss_callback_log attempt_number int4 10
attachment attindex int4 10
workflow_node child_index int4 10
tax_type code varchar 10
drm_settings cuc int4 10  √  null
order_item currency varchar 10  √  null
order_store_part currency varchar 10  √  null
price currency varchar 10
purchase currency varchar 10
sale currency varchar 10
subscription_period duration int4 10
subscription_period duration_unit int4 10
workflow_node escalationdays int4 10  √  null
item_history histindex int4 10
order_history histindex int4 10
item_navigation_node index int4 10  √  null
order_item item_version int4 10
purchased_content item_version int4 10
sale_item item_version int4 10
thumbnail_request item_version int4 10  √  null
kaltura_server kdp_ui_conf_id int4 10
qti_assessment_item lang varchar 10  √  null
term lft int4 10  √  null
hierarchy_topic list_position int4 10
hierarchy_topic_all_parents list_position int4 10
qti_assessment_item_ref list_position int4 10
tlegroup_all_parents list_position int4 10
tomcat_sessions maxinactive int4 10
drm_settings muc int4 10  √  null
qti_assessment_test navigation_mode int4 10
custom_link order int4 10
portlet_preference order int4 10
order_item orderitempos int4 10
order_store_part paid int4 10
sale paid_status int4 10
kaltura_server partner_id int4 10
portlet_preference position int4 10
language_string priority int4 10
workflow_node priority int4 10  √  null
purchase_item purchitempos int4 10
sale_item quantity int4 10
comments rating int4 10
qti_item_result resindex int4 10
item_definition reviewperiod int4 10
term rht int4 10  √  null
sale_item saleitempos int4 10
qti_item_result sequence_index int4 10  √  null
qti_abstract_result session_status int4 10
purchase_item source_item_version int4 10
purchased_content source_item_version int4 10
activate_request status int4 10
migration_log status int4 10
order status int4 10
order_history status int4 10
referencedurl status int4 10
course_info students int4 10
kaltura_server sub_partner_id int4 10
qti_assessment_test submission_mode int4 10
item_navigation_tab tabindex int4 10
order_item tax_code varchar 10  √  null
order_store_part tax_code varchar 10  √  null
purchase tax_code varchar 10  √  null
purchase_item tax_code varchar 10  √  null
sale tax_code varchar 10  √  null
sale_item tax_code varchar 10  √  null
thumbnail_request thumbnail_types int4 10
federated_search timeout int4 10
pss_callback_log tracking_number int4 10
referencedurl tries int4 10
lti_consumer unknown_user int4 10  √  null
order_item users int4 10
purchase_item users int4 10
qti_item_variable variable_type int4 10
qti_item_variable varindex int4 10
audit_log_lms version int4 10
hierarchy_topic_dynamic_key_re version int4 10
item version int4 10
store_harvest_info version int4 10
access_entry aggregate_ordering varchar 12
language country varchar 15
language language varchar 15
language variant varchar 15
payment_gateway gateway_type varchar 16
connector lms_type varchar 16
user_script script_type varchar 16
item status varchar 16  √  null
portlet type varchar 16
qti_item_variable normal_maximum float8 17,17  √  null
qti_item_variable normal_minimum float8 17,17  √  null
institution quota float8 17,17  √  null
access_expression_expression_p access_expression_id int8 19
hierarchy_topic advanced_search_id int8 19  √  null
hierarchy_topic_all_parents all_parents_id int8 19
tlegroup_all_parents all_parents_id int8 19
qti_item_result assessment_result_id int8 19
item_navigation_tab attachment_id int8 19  √  null
base_entity_attributes base_entity_id int8 19
bookmark_keywords bookmark_id int8 19
language_string bundle_id int8 19
cal_holding_authors cal_holding_id int8 19
cal_holding_ids cal_holding_id int8 19
cal_portion_authors cal_portion_id int8 19
cal_portion_topics cal_portion_id int8 19
catalogue_assignment catalogue_id int8 19
catalogue_regions catalogue_id int8 19
price catalogue_id int8 19  √  null
workflow_node_status cause_id int8 19  √  null
cla_holding_authors cla_holding_id int8 19
cla_holding_ids cla_holding_id int8 19
cla_portion_authors cla_portion_id int8 19
cla_portion_topics cla_portion_id int8 19
oauth_token client_id int8 19
store_front client_id int8 19
portlet_recent_contrib_collect collections_id int8 19
activate_request course_info_id int8 19
base_entity description_id int8 19  √  null
item description_id int8 19  √  null
workflow_node description_id int8 19  √  null
item drm_settings_id int8 19  √  null
dyna_collection_item_defs dyna_collection_id int8 19
dyna_collection_schemas dyna_collection_id int8 19
dyna_collection_usage_ids dyna_collection_id int8 19
catalogue dynamic_collection_id int8 19  √  null
hierarchy_topic_key_resources element int8 19
dyna_collection_item_defs entity_id int8 19
dyna_collection_schemas entity_id int8 19
entity_lock entity_id int8 19  √  null
hierarchy_topic_add_idefs entity_id int8 19
hierarchy_topic_add_schemas entity_id int8 19
hierarchy_topic_inh_idefs entity_id int8 19
hierarchy_topic_inh_schemas entity_id int8 19
access_entry expression_id int8 19
relation first_item_id int8 19
hierarchy_topic_add_idefs hierarchy_topic_id int8 19
hierarchy_topic_add_schemas hierarchy_topic_id int8 19
hierarchy_topic_all_parents hierarchy_topic_id int8 19
hierarchy_topic_attributes hierarchy_topic_id int8 19
hierarchy_topic_inh_idefs hierarchy_topic_id int8 19
hierarchy_topic_inh_schemas hierarchy_topic_id int8 19
hierarchy_topic_key_resources hierarchy_topic_id int8 19
item_history history_id int8 19
cal_portion holding_id int8 19  √  null
cla_portion holding_id int8 19  √  null
access_entry id int8 19
access_expression id int8 19
activate_request id int8 19
attachment id int8 19
audit_log_entry id int8 19
audit_log_lms id int8 19
base_entity id int8 19
bookmark id int8 19
cached_value id int8 19
cal_holding id int8 19
cal_portion id int8 19
cal_section id int8 19
catalogue id int8 19
catalogue_assignment id int8 19
cla_holding id int8 19
cla_portion id int8 19
cla_section id int8 19
comments id int8 19
connector id int8 19
course_info id int8 19
custom_link id int8 19
drm_acceptance id int8 19
drm_settings id int8 19
dyna_collection id int8 19
echo_server id int8 19
entity_lock id int8 19
external_tool id int8 19
favourite_search id int8 19
federated_search id int8 19
harvester_profile id int8 19
hierarchy_topic id int8 19
hierarchy_topic_dynamic_key_re id int8 19
history_event id int8 19
html_editor_plugin id int8 19
institution id int8 19
item id int8 19
item_definition id int8 19
item_lock id int8 19
item_navigation_node id int8 19
item_navigation_tab id int8 19
item_xml id int8 19
itemdef_blobs id int8 19
kaltura_server id int8 19
language id int8 19
language_bundle id int8 19
language_string id int8 19
lti_consumer id int8 19
lti_consumer_custom_role id int8 19
mime_entry id int8 19
moderation_status id int8 19
notification id int8 19
oauth_client id int8 19
oauth_token id int8 19
order id int8 19
order_history id int8 19
order_item id int8 19
order_store_part id int8 19
payment_gateway id int8 19
portlet id int8 19
portlet_preference id int8 19
portlet_recent_contrib id int8 19
power_search id int8 19
price id int8 19
pricing_tier id int8 19
pricing_tier_assignment id int8 19
pss_callback_log id int8 19
purchase id int8 19
purchase_item id int8 19
purchased_content id int8 19
qti_abstract_result id int8 19
qti_assessment_item id int8 19
qti_assessment_item_ref id int8 19
qti_assessment_result id int8 19
qti_assessment_test id int8 19
qti_item_result id int8 19
qti_item_variable id int8 19
referencedurl id int8 19
region id int8 19
relation id int8 19
report id int8 19
sale id int8 19
sale_item id int8 19
store id int8 19
store_front id int8 19
store_harvest_info id int8 19
subscription_period id int8 19
sys_database_schema id int8 19
task_history id int8 19
tax_type id int8 19
taxonomy id int8 19
term id int8 19
term_attributes id int8 19
thumbnail_request id int8 19
tlegroup id int8 19
tleschemas id int8 19
tleuser id int8 19
user_script id int8 19
workflow id int8 19
workflow_message id int8 19
workflow_node id int8 19
workflow_node_status id int8 19
user_preference institution int8 19
access_entry institution_id int8 19
audit_log_entry institution_id int8 19  √  null
audit_log_lms institution_id int8 19  √  null
base_entity institution_id int8 19
bookmark institution_id int8 19
cached_value institution_id int8 19
configuration_property institution_id int8 19
entity_lock institution_id int8 19  √  null
favourite_search institution_id int8 19
hierarchy_topic institution_id int8 19
hierarchy_topic_dynamic_key_re institution_id int8 19
item institution_id int8 19
item_lock institution_id int8 19  √  null
language institution_id int8 19
mime_entry institution_id int8 19
notification institution_id int8 19
oauth_token institution_id int8 19
order institution_id int8 19
pss_callback_log institution_id int8 19
purchase institution_id int8 19
purchased_content institution_id int8 19
qti_assessment_item institution_id int8 19
qti_assessment_test institution_id int8 19
sale institution_id int8 19
share_pass institution_id int8 19
subscription_period institution_id int8 19
thumbnail_request institution_id int8 19
tlegroup institution_id int8 19
tleuser institution_id int8 19
item item_definition_id int8 19
activate_request item_id int8 19
attachment item_id int8 19
bookmark item_id int8 19
cal_holding item_id int8 19  √  null
cal_portion item_id int8 19
catalogue_assignment item_id int8 19
cla_holding item_id int8 19  √  null
cla_portion item_id int8 19
comments item_id int8 19
drm_acceptance item_id int8 19
item_collaborators item_id int8 19
item_history item_id int8 19
item_lock item_id int8 19  √  null
item_navigation_node item_id int8 19
item_notifications item_id int8 19
item_referenced_urls item_id int8 19
pricing_tier_assignment item_id int8 19
pss_callback_log item_id int8 19  √  null
qti_assessment_test item_id int8 19
share_pass item_id int8 19
task_history item_id int8 19  √  null
qti_item_result item_ref_id int8 19
item item_xml_id int8 19
power_search_itemdefs itemdefs_id int8 19
tomcat_sessions lastaccess int8 19
hierarchy_topic long_description_id int8 19  √  null
lti_consumer_custom_role lti_consumer_id int8 19  √  null
lti_consumer_instructor_roles lti_consumer_id int8 19
lti_consumer_other_roles lti_consumer_id int8 19
lti_consumer_unknown_groups lti_consumer_id int8 19
subscription_period magnitude int8 19
mime_entry_attributes mime_entry_id int8 19
mime_entry_extensions mime_entry_id int8 19
workflow_node_status mod_status_id int8 19
item moderation_id int8 19  √  null
base_entity name_id int8 19  √  null
hierarchy_topic name_id int8 19  √  null
item name_id int8 19  √  null
subscription_period name_id int8 19  √  null
workflow_node name_id int8 19  √  null
item_navigation_tab node_id int8 19
workflow_message node_id int8 19
oauth_client_permissions oauth_client_id int8 19
oauth_token_permissions oauth_token_id int8 19
order_history order_id int8 19
order_store_part order_id int8 19
order_item order_store_part_id int8 19
hierarchy_topic parent_id int8 19  √  null
item_navigation_node parent_id int8 19  √  null
term parent_id int8 19  √  null
tlegroup parent_id int8 19  √  null
workflow_node parent_id int8 19  √  null
payment_gateway_regions payment_gateway_id int8 19
price period_id int8 19  √  null
sale_item period_id int8 19  √  null
cal_section portion_id int8 19
cla_section portion_id int8 19
portlet_preference portlet_id int8 19
portlet_recent_contrib portlet_id int8 19
portlet_recent_contrib_collect portlet_recent_contrib_id int8 19
power_search_itemdefs power_search_id int8 19
order_item price int8 19
order_store_part price int8 19
purchase price int8 19
purchase_item price int8 19
sale price int8 19
sale_item price int8 19
purchase_item purchase_id int8 19
pricing_tier_assignment purchase_pricing_tier_id int8 19  √  null
qti_item_variable_value qti_item_variable_id int8 19
qti_assessment_item_ref question_id int8 19
item_referenced_urls referenced_urls_id int8 19
price region_id int8 19  √  null
region_countries region_id int8 19
catalogue_regions regions_id int8 19
payment_gateway_regions regions_id int8 19
qti_item_variable result_id int8 19
hierarchy_topic results_section_name_id int8 19  √  null
sale_item sale_id int8 19
store_harvest_info sale_id int8 19
item_definition schema_id int8 19  √  null
power_search schema_id int8 19  √  null
schema_citations schema_id int8 19
schema_exp_transforms schema_id int8 19
schema_imp_transforms schema_id int8 19
relation second_item_id int8 19
hierarchy_topic short_description_id int8 19  √  null
item_definition slow_id int8 19  √  null
order_store_part store_id int8 19  √  null
purchase store_id int8 19
purchased_content store_id int8 19  √  null
sale storefront_id int8 19
pricing_tier_assignment subscription_pricing_tier_id int8 19  √  null
hierarchy_topic subtopics_section_name_id int8 19  √  null
task_history task_id int8 19  √  null
order_item tax int8 19
order_store_part tax int8 19
purchase tax int8 19
purchase_item tax int8 19
sale tax int8 19
sale_item tax int8 19
store_front tax_type_id int8 19  √  null
term taxonomy_id int8 19
term_attributes term_id int8 19
qti_assessment_item_ref test_id int8 19
qti_assessment_result test_id int8 19
price tier_id int8 19
tlegroup_all_parents tlegroup_id int8 19
tlegroup_users tlegroup_id int8 19
item total_file_size int8 19
institution unique_id int8 19
order_item unit_price int8 19
purchase_item unit_price int8 19
sale_item unit_price int8 19
order_item unit_tax int8 19
sale_item unit_tax int8 19
price value int8 19
workflow_node_status wnode_id int8 19
item_definition workflow_id int8 19  √  null
workflow_node workflow_id int8 19
workflow_node_auto_assigns workflow_node_id int8 19
workflow_node_groups workflow_node_id int8 19
workflow_node_roles workflow_node_id int8 19
workflow_node_users workflow_node_id int8 19
workflow_node_status_accepted workflow_node_status_id int8 19
mime_entry_extensions element varchar 20  √  null
audit_log_entry event_category varchar 20  √  null
audit_log_entry event_type varchar 20  √  null
language_string locale varchar 20
share_pass privilege varchar 20
cal_holding pub_date varchar 20  √  null
cla_holding pub_date varchar 20  √  null
cla_section range_end varchar 20  √  null
cla_section range_start varchar 20  √  null
institution short_name varchar 20
institution time_zone varchar 20  √  null
cal_holding type varchar 20  √  null
cla_holding type varchar 20  √  null
html_editor_plugin type varchar 20
item_definition scorm_packaging_transformat varchar 25  √  null
history_event state varchar 25  √  null
history_event type varchar 25  √  null
order_item added_date timestamp 29,6  √  null
purchase checkout_date timestamp 29,6
oauth_token created timestamp 29,6
order created_date timestamp 29,6  √  null
sale creation_date timestamp 29,6
drm_acceptance date timestamp 29,6  √  null
history_event date timestamp 29,6  √  null
notification date timestamp 29,6
order_history date timestamp 29,6
store_harvest_info date timestamp 29,6
workflow_message date timestamp 29,6
base_entity date_created timestamp 29,6
comments date_created timestamp 29,6  √  null
hierarchy_topic_dynamic_key_re date_created timestamp 29,6
item date_created timestamp 29,6
workflow_node_status date_due timestamp 29,6  √  null
item date_for_index timestamp 29,6
base_entity date_modified timestamp 29,6
bookmark date_modified timestamp 29,6  √  null
favourite_search date_modified timestamp 29,6
item date_modified timestamp 29,6
thumbnail_request date_requested timestamp 29,6
qti_abstract_result datestamp timestamp 29,6
task_history entry_date timestamp 29,6  √  null
migration_log executed timestamp 29,6
task_history exit_date timestamp 29,6  √  null
access_entry expiry timestamp 29,6  √  null
oauth_token expiry timestamp 29,6  √  null
share_pass expiry timestamp 29,6  √  null
activate_request from timestamp 29,6  √  null
course_info from timestamp 29,6  √  null
cal_holding issue_date timestamp 29,6  √  null
cla_holding issue_date timestamp 29,6  √  null
moderation_status last_action timestamp 29,6  √  null
order last_action_date timestamp 29,6  √  null
notification last_attempt timestamp 29,6  √  null
pss_callback_log last_attempt timestamp 29,6
referencedurl last_checked timestamp 29,6
store last_harvest timestamp 29,6  √  null
referencedurl last_indexed timestamp 29,6
harvester_profile last_run timestamp 29,6  √  null
moderation_status live_approval_date timestamp 29,6  √  null
order_store_part paid_date timestamp 29,6  √  null
purchase paid_date timestamp 29,6  √  null
sale paid_date timestamp 29,6  √  null
moderation_status review_date timestamp 29,6  √  null
moderation_status start timestamp 29,6  √  null
share_pass started timestamp 29,6  √  null
workflow_node_status started timestamp 29,6  √  null
purchase_item subscription_end_date timestamp 29,6  √  null
sale_item subscription_end_date timestamp 29,6  √  null
order_item subscription_start_date timestamp 29,6  √  null
purchase_item subscription_start_date timestamp 29,6  √  null
sale_item subscription_start_date timestamp 29,6  √  null
activate_request time timestamp 29,6  √  null
audit_log_entry timestamp timestamp 29,6  √  null
audit_log_lms timestamp timestamp 29,6  √  null
cached_value ttl timestamp 29,6  √  null
activate_request until timestamp 29,6  √  null
course_info until timestamp 29,6  √  null
store_front contact_phone varchar 30  √  null
share_pass password varchar 30  √  null
access_entry privilege varchar 30  √  null
course_info version_selection varchar 30  √  null
workflow_node_status acttype varchar 31
attachment type varchar 31
attachment md5sum varchar 32  √  null
referencedurl url_hash varchar 32  √  null
term value_hash varchar 32  √  null
notification attempt_id varchar 36  √  null
workflow_node_status assigned_to varchar 40  √  null
cal_section attachment varchar 40  √  null
cla_section attachment varchar 40  √  null
store_harvest_info attachment_uuid varchar 40  √  null
workflow_node auto_assign_schema_uuid varchar 40  √  null
order_item cat_uuid varchar 40
purchase_item catalogue_uuid varchar 40
sale_item catalogue_uuid varchar 40
order_store_part checkout_uuid varchar 40  √  null
oauth_token code varchar 40  √  null
workflow_node collection_uuid varchar 40  √  null
sale customer_reference varchar 40
drm_settings drm_page_uuid varchar 40
workflow_node due_date_schema_uuid varchar 40  √  null
share_pass id varchar 40
order_item item_uuid varchar 40
purchased_content item_uuid varchar 40
sale_item item_uuid varchar 40
store_harvest_info item_uuid varchar 40
order original_order_uuid varchar 40  √  null
sale payment_gateway_uuid varchar 40  √  null
order_item period_uuid varchar 40  √  null
user_preference preferenceid varchar 40
sale_item pricing_tier_uuid varchar 40  √  null
order_item purchase_tier_uuid varchar 40  √  null
moderation_status rejected_step varchar 40  √  null
relation relation_type varchar 40  √  null
audit_log_entry session_id varchar 40  √  null
audit_log_lms session_id varchar 40  √  null
purchase_item source_item_uuid varchar 40
purchased_content source_item_uuid varchar 40
staging stagingid varchar 40
history_event step varchar 40  √  null
order_item subscription_tier_uuid varchar 40  √  null
workflow_node_auto_assigns task varchar 40  √  null
history_event to_step varchar 40  √  null
portlet_preference user_id varchar 40
workflow_node user_schema_uuid varchar 40  √  null
entity_lock user_session varchar 40  √  null
item_lock user_session varchar 40  √  null
staging user_session varchar 40  √  null
activate_request uuid varchar 40
attachment uuid varchar 40
audit_log_lms uuid varchar 40  √  null
base_entity uuid varchar 40
comments uuid varchar 40
hierarchy_topic uuid varchar 40
hierarchy_topic_dynamic_key_re uuid varchar 40  √  null
item uuid varchar 40  √  null
item_navigation_node uuid varchar 40  √  null
order uuid varchar 40
order_item uuid varchar 40
order_store_part uuid varchar 40
purchase uuid varchar 40
purchase_item uuid varchar 40
qti_assessment_item uuid varchar 40
qti_assessment_item_ref uuid varchar 40
qti_assessment_test uuid varchar 40
sale uuid varchar 40
sale_item uuid varchar 40
subscription_period uuid varchar 40
sys_schema_id uuid varchar 40
term uuid varchar 40
thumbnail_request uuid varchar 40
tlegroup uuid varchar 40
tleuser uuid varchar 40
workflow_node uuid varchar 40
activate_request attachment varchar 45
qti_item_variable base_type varchar 50  √  null
qti_item_variable cardinality varchar 50
notification itemid_only varchar 50
lti_consumer postfix varchar 50  √  null
lti_consumer prefix varchar 50  √  null
external_tool consumer_key varchar 64  √  null
base_entity_attributes key varchar 64
hierarchy_topic_attributes key varchar 64
term_attributes key varchar 64
user_script module_name varchar 64  √  null
sys_database_schema password varchar 64  √  null
store_front product_version varchar 64
sys_database_schema reporting_password varchar 64  √  null
sys_database_schema reporting_username varchar 64  √  null
external_tool shared_secret varchar 64  √  null
federated_search type varchar 64  √  null
harvester_profile type varchar 64  √  null
sys_database_schema username varchar 64  √  null
drm_settings usages varchar 70  √  null
access_entry target_object varchar 80  √  null
thumbnail_request task_id varchar 80  √  null
oauth_client client_id varchar 100
store client_id varchar 100
oauth_client client_secret varchar 100
taxonomy data_source_plugin_id varchar 100  √  null
thumbnail_request filename_hash varchar 100
hierarchy_topic freetext varchar 100  √  null
dyna_collection freetext_query varchar 100  √  null
item_navigation_node icon varchar 100  √  null
tomcat_sessions id varchar 100
mime_entry_attributes mapkey varchar 100
institution name varchar 100
tlegroup name varchar 100  √  null
html_editor_plugin plugin_id varchar 100
history_event step_name varchar 100  √  null
history_event to_step_name varchar 100  √  null
mime_entry type varchar 100
institution url varchar 100  √  null
item_navigation_tab viewer varchar 100  √  null
dyna_collection virtualisation_id varchar 100  √  null
hierarchy_topic virtualisation_id varchar 100  √  null
item_definition wizardcategory varchar 100  √  null
audit_log_lms content_type varchar 120  √  null
activate_request citation varchar 128  √  null
course_info code varchar 128  √  null
share_pass email_address varchar 150
cal_portion chapter varchar 200  √  null
cla_portion chapter varchar 200  √  null
item_navigation_node identifier varchar 200  √  null
institution admin_password varchar 255
kaltura_server admin_secret varchar 255  √  null
lti_consumer allowed_expression varchar 255  √  null
tomcat_sessions app varchar 255
echo_server application_url varchar 255  √  null
order approvers_expression varchar 255  √  null
html_editor_plugin author varchar 255  √  null
cached_value cache_id varchar 255  √  null
purchase checkout_by varchar 255
course_info citation varchar 255  √  null
federated_search collection_uuid varchar 255  √  null
echo_server consumer_key varchar 255  √  null
lti_consumer consumer_key varchar 255
echo_server consumer_secret varchar 255  √  null
lti_consumer consumer_secret varchar 255
echo_server content_url varchar 255  √  null
cal_section copyright_status varchar 255  √  null
cla_section copyright_status varchar 255  √  null
region_countries countries varchar 255  √  null
order created_by varchar 255
share_pass creator varchar 255
audit_log_entry data1 varchar 255  √  null
audit_log_entry data2 varchar 255  √  null
audit_log_entry data3 varchar 255  √  null
moderation_status deleted_status2 varchar 255  √  null
echo_server echo_systemid varchar 255  √  null
access_expression_expression_p element varchar 255  √  null
bookmark_keywords element varchar 255  √  null
cal_holding_authors element varchar 255  √  null
cal_holding_ids element varchar 255  √  null
cal_portion_authors element varchar 255  √  null
cal_portion_topics element varchar 255  √  null
cla_holding_authors element varchar 255  √  null
cla_holding_ids element varchar 255  √  null
cla_portion_authors element varchar 255  √  null
cla_portion_topics element varchar 255  √  null
dyna_collection_usage_ids element varchar 255  √  null
item_collaborators element varchar 255  √  null
item_notifications element varchar 255  √  null
tlegroup_users element varchar 255  √  null
tleuser email_address varchar 255  √  null
lti_consumer_custom_role equella_role varchar 255  √  null
schema_exp_transforms fil varchar 255  √  null
schema_imp_transforms fil varchar 255  √  null
report filename varchar 255  √  null
tleuser first_name varchar 255
relation first_resource varchar 255  √  null
thumbnail_request global_task_id varchar 255  √  null
workflow_node_groups group varchar 255  √  null
thumbnail_request handle varchar 255
qti_assessment_item_ref identifier varchar 255
qti_item_variable identifier varchar 255
lti_consumer_instructor_roles instructor_roles varchar 255  √  null
tleschemas item_description_path varchar 255  √  null
tleschemas item_name_path varchar 255  √  null
thumbnail_request item_uuid varchar 255
notification itemid varchar 255
cached_value key varchar 255  √  null
sys_system_config key varchar 255
order last_action_user varchar 255  √  null
tleuser last_name varchar 255
qti_assessment_result lms_instance_id varchar 255  √  null
course_info lmsid varchar 255  √  null
lti_consumer_custom_role lti_role varchar 255  √  null
referencedurl message varchar 255  √  null
migration_log migration_id varchar 255
favourite_search name varchar 255
schema_citations name varchar 255  √  null
lti_consumer_other_roles other_roles varchar 255  √  null
base_entity owner varchar 255  √  null
bookmark owner varchar 255
comments owner varchar 255  √  null
favourite_search owner varchar 255
item owner varchar 255
purchase paid_for_by varchar 255  √  null
tleuser password varchar 255
order payers_expression varchar 255  √  null
oauth_client_permissions permissions varchar 255  √  null
oauth_token_permissions permissions varchar 255  √  null
configuration_property property varchar 255
portlet_recent_contrib query varchar 255  √  null
cal_section range varchar 255  √  null
cla_section range varchar 255  √  null
purchase receipt varchar 255  √  null
sale receipt varchar 255  √  null
moderation_status rejected_by varchar 255  √  null
moderation_status resume_status2 varchar 255  √  null
workflow_node_roles role varchar 255  √  null
relation second_resource varchar 255  √  null
audit_log_lms selected varchar 255  √  null
cla_portion source_institution varchar 255  √  null
oauth_token token varchar 255
store token varchar 255  √  null
purchase transaction_uuid varchar 255
schema_citations transfo varchar 255  √  null
schema_exp_transforms typ varchar 255  √  null
schema_imp_transforms typ varchar 255  √  null
lti_consumer_unknown_groups unknown_groups varchar 255  √  null
drm_acceptance user varchar 255  √  null
history_event user varchar 255  √  null
workflow_message user varchar 255
workflow_node_status_accepted user varchar 255  √  null
workflow_node_users user varchar 255  √  null
audit_log_entry user_id varchar 255
audit_log_lms user_id varchar 255
oauth_client user_id varchar 255  √  null
oauth_token user_id varchar 255
order_history user_id varchar 255
portlet_recent_contrib user_id varchar 255  √  null
qti_assessment_result user_id varchar 255
kaltura_server user_secret varchar 255  √  null
notification user_to varchar 255
entity_lock userid varchar 255  √  null
item_lock userid varchar 255  √  null
user_preference userid varchar 255
tleuser username varchar 255
qti_item_variable_value value varchar 255  √  null
attachment viewer varchar 255  √  null
dyna_collection virtualisation_path varchar 255  √  null
hierarchy_topic virtualisation_path varchar 255  √  null
cal_holding issue_number varchar 256  √  null
cla_holding issue_number varchar 256  √  null
qti_assessment_item label varchar 256  √  null
activate_request location_id varchar 256  √  null
activate_request location_name varchar 256  √  null
qti_assessment_test test_part_identifier varchar 256
activate_request user varchar 256  √  null
cal_holding volume varchar 256  √  null
cla_holding volume varchar 256  √  null
store store_url varchar 500
workflow_node auto_assign_node varchar 512  √  null
course_info department_name varchar 512  √  null
mime_entry description varchar 512  √  null
workflow_node due_date_path varchar 512  √  null
cal_holding length varchar 512  √  null
cla_holding length varchar 512  √  null
item metadata_security_targets varchar 512  √  null
favourite_search query varchar 512  √  null
sys_database_schema reporting_url varchar 512  √  null
audit_log_lms resource varchar 512  √  null
item thumb varchar 512
attachment thumbnail varchar 512  √  null
sys_database_schema url varchar 512  √  null
workflow_node user_path varchar 512  √  null
favourite_search within varchar 512  √  null
qti_assessment_item_ref category varchar 1024  √  null
qti_item_variable choice_sequence varchar 1024  √  null
attachment description varchar 1024  √  null
hierarchy_topic_dynamic_key_re dynamic_hierarchy_id varchar 1024  √  null
kaltura_server end_point varchar 1024
access_expression expression varchar 1024  √  null
qti_assessment_item identifier varchar 1024
qti_assessment_test identifier varchar 1024
store_front product varchar 1024
oauth_client redirect_url varchar 1024
qti_assessment_result resource_link_id varchar 1024
connector server_url varchar 1024
attachment url varchar 1024  √  null
oauth_token username varchar 1024
base_entity_attributes value varchar 1024  √  null
hierarchy_topic_attributes value varchar 1024  √  null
term value varchar 1024
attachment value1 varchar 1024  √  null
attachment value2 varchar 1024  √  null
attachment value3 varchar 1024  √  null
qti_assessment_item_ref xml_path varchar 1024
qti_assessment_test xml_path varchar 1024
term full_value varchar 4000  √  null
federated_search advanced_search_fields text 2147483647  √  null
cal_holding author_list text 2147483647  √  null
cal_portion author_list text 2147483647  √  null
cla_holding author_list text 2147483647  √  null
cla_portion author_list text 2147483647  √  null
external_tool baseurl text 2147483647  √  null
html_editor_plugin buttons text 2147483647  √  null
qti_item_result candidate_comment text 2147483647  √  null
html_editor_plugin client_js text 2147483647  √  null
comments comment text 2147483647  √  null
history_event comment text 2147483647  √  null
order_history comment text 2147483647  √  null
cal_holding comments text 2147483647  √  null
cla_holding comments text 2147483647  √  null
html_editor_plugin config text 2147483647  √  null
portlet config text 2147483647  √  null
drm_settings content_owners text 2147483647  √  null
favourite_search criteria text 2147483647  √  null
item curricula text 2147483647  √  null
external_tool custom_params text 2147483647  √  null
attachment data text 2147483647  √  null
sale data text 2147483647  √  null
tomcat_sessions data bytea 2147483647
user_preference data text 2147483647  √  null
audit_log_entry data4 text 2147483647  √  null
activate_request description text 2147483647  √  null
cal_holding description text 2147483647  √  null
cla_holding description text 2147483647  √  null
sys_database_schema description text 2147483647  √  null
tlegroup description text 2147483647  √  null
itemdef_blobs dynamic_metadata_rules text 2147483647  √  null
mime_entry_attributes element text 2147483647
migration_log error_message text 2147483647  √  null
html_editor_plugin extra text 2147483647  √  null
thumbnail_request filename text 2147483647
cal_holding id_list text 2147483647  √  null
cla_holding id_list text 2147483647  √  null
qti_assessment_item item_body text 2147483647  √  null
itemdef_blobs item_metadata_rules text 2147483647  √  null
itemdef_blobs item_summary_sections text 2147483647  √  null
migration_log message text 2147483647  √  null
pss_callback_log message text 2147483647  √  null
workflow_message message text 2147483647
itemdef_blobs metadata_mapping text 2147483647  √  null
item_navigation_node name text 2147483647  √  null
item_navigation_tab name text 2147483647  √  null
order_item name text 2147483647  √  null
activate_request override_reason text 2147483647  √  null
cal_holding publisher text 2147483647  √  null
cla_holding publisher text 2147483647  √  null
drm_settings raf text 2147483647  √  null
moderation_status rejected_message text 2147483647  √  null
drm_settings rtodates text 2147483647  √  null
drm_settings rtoips text 2147483647  √  null
drm_settings rtorecip text 2147483647  √  null
dyna_collection_item_defs script text 2147483647  √  null
dyna_collection_schemas script text 2147483647  √  null
hierarchy_topic_add_idefs script text 2147483647  √  null
hierarchy_topic_add_schemas script text 2147483647  √  null
hierarchy_topic_inh_idefs script text 2147483647  √  null
hierarchy_topic_inh_schemas script text 2147483647  √  null
user_script script text 2147483647  √  null
workflow_node script text 2147483647  √  null
item search_details text 2147483647  √  null
itemdef_blobs search_details text 2147483647  √  null
tleschemas serialised_definition text 2147483647  √  null
html_editor_plugin server_js text 2147483647  √  null
pss_callback_log status text 2147483647  √  null
drm_settings terms text 2147483647  √  null
qti_assessment_result test_session_state text 2147483647  √  null
language_string text text 2147483647  √  null
cal_holding title text 2147483647  √  null
cal_portion title text 2147483647  √  null
cla_holding title text 2147483647  √  null
cla_portion title text 2147483647  √  null
qti_assessment_item title text 2147483647
qti_assessment_test title text 2147483647
custom_link url text 2147483647
favourite_search url text 2147483647
referencedurl url text 2147483647  √  null
connector username_script text 2147483647  √  null
cached_value value text 2147483647  √  null
configuration_property value text 2147483647  √  null
sys_system_config value text 2147483647  √  null
term_attributes value text 2147483647  √  null
itemdef_blobs wizard text 2147483647  √  null
power_search wizard text 2147483647  √  null
item_xml xml text 2147483647