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 |