XML Representation
Insertion Order Deletion Order

Table Children Parents Columns Comments
access_entry 2 10 ACL entries. Maps privileges to targets
access_expression 2 3 Store expression targets for privileges (e.g. role or group targets)
access_expression_expression_p 1 2
activate_request 2 16 CAL and CLA activations
attachment 1 1 16 Item attachments
audit_log_entry 1 11 Stores logging information for EQUELLA
audit_log_lms 1 12 Stores logging information for EQUELLA when used in an integration
base_entity 29 3 10 All entities (schemas, collections, advanced searches etc., but not items) extend this table. Stores the common information for entities (e.g. uuid, institution)
base_entity_attributes 1 3 Child table of base entity, stores extra attributes as key-value
bookmark 1 2 6 Legacy name, actually references favourites
bookmark_keywords 1 2
cached_value 1 6
cal_holding 3 1 15
cal_holding_authors 1 2
cal_holding_ids 1 2
cal_portion 3 2 6
cal_portion_authors 1 2
cal_portion_topics 1 2
cal_section 1 6
catalogue 3 2 3
catalogue_assignment 2 4
catalogue_regions 2 2
cla_holding 3 1 15
cla_holding_authors 1 2
cla_holding_ids 1 2
cla_portion 3 2 10
cla_portion_authors 1 2
cla_portion_topics 1 2
cla_section 1 8
comments 1 8 Comments and ratings on items
configuration_property 3 Used to store various configuration properties as key-value
connector 1 5 External system connectors
course_info 1 1 10 Courses
custom_link 1 3 Custom links
drm_acceptance 1 4 DRM acceptances on items
drm_settings 1 20
dyna_collection 4 1 4 Dynamic collections
dyna_collection_item_defs 2 3
dyna_collection_schemas 2 3
dyna_collection_usage_ids 1 2
echo_server 1 6
entity_lock 2 5 Reference to entities currently being edited
external_tool 1 7 LTI external tools
favourite_search 1 9 Saved searches
federated_search 1 5 Legacy name, actually references remote repositories
harvester_profile 1 5
hierarchy_topic 9 8 17 Node in a hierarchy
hierarchy_topic_add_idefs 2 3 Collection scripts for hierarchy topics
hierarchy_topic_add_schemas 2 3 Schema scripts for hierarchy topics
hierarchy_topic_all_parents 2 3 Hierarchy topic parent mappings
hierarchy_topic_attributes 1 3
hierarchy_topic_dynamic_key_re 1 6 Reference for hierarchies' dynamic key resources
hierarchy_topic_inh_idefs 2 3 Inherited collection scripts for hierarchy topics
hierarchy_topic_inh_schemas 2 3 Inherited schema scripts for hierarchy topics
hierarchy_topic_key_resources 2 2 Reference for key resources in a hierarchy
history_event 1 11 Stores a reference to a workflow event
html_editor_plugin 1 9 TinyMCE plugins
institution 28 9 Institutions for this install
item 24 7 24 Items/resources. This is the main table for content stored in EQUELLA.
item_collaborators 1 2
item_definition 6 4 8 Legacy name, actually references collection definitions
item_history 2 3
item_lock 2 5 References to items currently being edited
item_navigation_node 2 2 8 Stores a node reference in an item with navigation
item_navigation_tab 2 6 Stores a tab reference for a node in an item with navigation
item_notifications 1 2
item_referenced_urls 2 2 Stores information about the health of urls found in EQUELLA items
item_xml 1 2 Item metadata
itemdef_blobs 1 7 Stores XML representation of extended collection information such as wizards
kaltura_server 1 8
language 1 5 Available language locales for institutions
language_bundle 13 1 Maps various language strings from different locales to a single id
language_string 1 5 Maps strings to language bundles
lti_consumer 4 1 7
lti_consumer_custom_role 1 4
lti_consumer_instructor_roles 1 2
lti_consumer_other_roles 1 2
lti_consumer_unknown_groups 1 2
migration_log 7 Migration logs, updated after every successful or failed upgrade
mime_entry 2 1 4 MIME types recognised by EQUELLA
mime_entry_attributes 1 3
mime_entry_extensions 1 2 Maps file extensions to MIME entries
moderation_status 2 14
notification 1 11
oauth_client 3 1 6
oauth_client_permissions 1 2
oauth_token 1 2 9
oauth_token_permissions 1 2
order 2 1 11
order_history 1 7
order_item 1 21
order_store_part 1 2 11
payment_gateway 1 1 2
payment_gateway_regions 2 2
portlet 2 1 7
portlet_preference 1 7
portlet_recent_contrib 1 1 5
portlet_recent_contrib_collect 2 2
power_search 2 2 3 Legacy name, actually references advanced searches
power_search_itemdefs 2 2 Maps advanced searches to collections
price 4 8
pricing_tier 3 1 2
pricing_tier_assignment 3 5
pss_callback_log 2 8 Pearson Scorm Services callback logs
purchase 1 2 15
purchase_item 1 14
purchased_content 2 8
qti_abstract_result 3 3
qti_assessment_item 1 1 10
qti_assessment_item_ref 1 2 8
qti_assessment_result 1 2 6
qti_assessment_test 2 2 10
qti_item_result 3 6
qti_item_variable 1 1 10
qti_item_variable_value 1 2
referencedurl 1 9 Stores information about the health of urls found in EQUELLA
region 4 1 1
region_countries 1 2
relation 2 6 Maps various relations between items
report 1 3 Reference to .rptdesign files known to EQUELLA
sale 2 2 16
sale_item 2 17
schema_citations 1 3 Available citations for schemas
schema_exp_transforms 1 3 Schema export transformations
schema_imp_transforms 1 3 Schema import transformations
share_pass 2 10 Stores temporary passes for items shared via email
staging 2 Used to map staging areas to sessions
store 3 1 5
store_front 1 3 10
store_harvest_info 1 6
subscription_period 2 2 7
sys_database_schema 10 Stores the reference to databases used by EQUELLA
sys_schema_id 1
sys_system_config 2 Admin information for EQUELLA
task_history 2 5
tax_type 1 1 3
taxonomy 1 1 2
term 2 2 9 Terms in a taxonomy
term_attributes 1 4
thumbnail_request 1 13
tlegroup 4 2 6 User management groups
tlegroup_all_parents 2 3 Group hierarchy
tlegroup_users 1 2 Group membership
tleschemas 8 1 4 Schema store
tleuser 1 8 Internal users table
tomcat_sessions 6 Used to store browser sessions
user_preference 4 Used to store various user preferences as key-value
user_script 1 4
workflow 2 1 2
workflow_message 1 6
workflow_node 7 4 26
workflow_node_auto_assigns 1 2
workflow_node_groups 1 2
workflow_node_roles 1 2
workflow_node_status 3 3 10
workflow_node_status_accepted 1 2
workflow_node_users 1 2
         
157 Tables     959  
0 Views     0