SCORM

Explore the interactive ERD

Table & Field Reference

course_asset

Column	Type	Keys
`path`	Unknown	PK
`course_id`	Unknown	FK
`modified`	Unknown
`size`	Unknown

dispatch_tag

Column	Type	Keys
`tags`	Unknown	PK
`dispatch_id`	Unknown	PKFK

dispatch

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`destination_id`	Unknown	FK
`allow_new_registrations`	Unknown
`created`	Unknown
`enabled`	Unknown
`expiration_date`	Unknown
`instanced`	Unknown
`notes`	Unknown
`registration_cap`	Unknown
`registration_count`	Unknown
`updated`	Unknown

destination_tag

Column	Type	Keys
`tags`	Unknown	PK
`destination_id`	Unknown	PKFK

destination

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`email`	Unknown
`launch_auth_expiry`	Unknown
`launch_auth_fingerprint`	Unknown
`launch_auth_ip_address`	Unknown
`launch_auth_sliding_expiry`	Unknown
`launch_auth_type`	Unknown
`lti_13_access_token_url`	Unknown
`lti_13_client_id`	Unknown
`lti_13_deployment_id`	Unknown
`lti_13_json_web_key_set_url`	Unknown
`lti_13_oidc_authorization_endpoint`	Unknown
`lti_13_platform_issuer_identifier`	Unknown
`name`	Unknown
`notes`	Unknown
`updated`	Unknown

registration_statement_attachment

Column	Type	Keys
`file_url`	Unknown	PK
`registration_statement_id`	Unknown	PKFK
`content_type`	Unknown
`description_additional_prop_1`	Unknown
`description_additional_prop_2`	Unknown
`description_additional_prop_3`	Unknown
`display_additional_prop_1`	Unknown
`display_additional_prop_2`	Unknown
`display_additional_prop_3`	Unknown
`length`	Unknown
`sha_2`	Unknown
`usage_type`	Unknown

registration_verb

Column	Type	Keys
`id`	Unknown	PK
`registration_statement_id`	Unknown	PKFK
`additional_prop_1`	Unknown
`additional_prop_2`	Unknown
`additional_prop_3`	Unknown

registration_object_activity

Column	Type	Keys
`id`	Unknown	PK
`registration_statement_id`	Unknown	PKFK
`definition_correct_responses_pattern`	Json
`definition_interaction_type`	Unknown
`definition_more_info`	Unknown
`definition_type`	Unknown
`extensions_additional_prop_1`	Unknown
`extensions_additional_prop_2`	Unknown
`extensions_additional_prop_3`	Unknown
`object_type`	Unknown
`description_`
`name_`

registration_statement

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	FK
`actor_account_home_page`	Unknown
`actor_account_name`	Unknown
`actor_mbox`	Unknown
`actor_mbox_sha_1_sum`	Unknown
`actor_member`	Json
`actor_name`	Unknown
`actor_object_type`	Unknown
`actor_openid`	Unknown
`authority_account_home_page`	Unknown
`authority_account_name`	Unknown
`authority_mbox`	Unknown
`authority_mbox_sha_1_sum`	Unknown
`authority_member`	Json
`authority_name`	Unknown
`authority_object_type`	Unknown
`authority_openid`	Unknown
`context_extensions_additional_prop_1`	Unknown
`context_extensions_additional_prop_2`	Unknown
`context_extensions_additional_prop_3`	Unknown
`context_instructor_account_home_page`	Unknown
`context_instructor_account_name`	Unknown
`context_instructor_mbox`	Unknown
`context_instructor_mbox_sha_1_sum`	Unknown
`context_instructor_member`	Json
`context_instructor_name`	Unknown
`context_instructor_object_type`	Unknown
`context_instructor_openid`	Unknown
`context_language`	Unknown
`context_platform`	Unknown
`context_registration`	Unknown
`context_revision`	Unknown
`context_statement_id`	Unknown
`context_statement_object_type`	Unknown
`context_team_account_home_page`	Unknown
`context_team_account_name`	Unknown
`context_team_mbox`	Unknown
`context_team_mbox_sha_1_sum`	Unknown
`context_team_member`	Json
`context_team_name`	Unknown
`context_team_object_type`	Unknown
`context_team_openid`	Unknown
`object_agent_group_account_home_page`	Unknown
`object_agent_group_account_name`	Unknown
`object_agent_group_mbox`	Unknown
`object_agent_group_mbox_sha_1_sum`	Unknown
`object_agent_group_member`	Json
`object_agent_group_name`	Unknown
`object_agent_group_object_type`	Unknown
`object_agent_group_openid`	Unknown
`object_reference_id`	Unknown
`result_completion`	Unknown
`result_duration`	Unknown
`result_extensions_additional_prop_1`	Json
`result_extensions_additional_prop_2`	Json
`result_extensions_additional_prop_3`	Json
`result_response`	Unknown
`result_score_max`	Unknown
`result_score_min`	Unknown
`result_score_raw`	Unknown
`result_score_scaled`	Unknown
`result_success`	Unknown
`stored`	Unknown
`timestamps`	Unknown

registration_object_activity_definition

Column	Type	Keys
`id`	Unknown	PK
`registration_object_activity_id`	Unknown	PKFK
`description_und`	Unknown
`type`	Unknown

course_tag

Column	Type	Keys
`tags`	Unknown	PK
`course_id`	Unknown	PKFK

course_keyword

Column	Type	Keys
`index`	Unknown	PK
`course_id`	Unknown	PKFK
`keyword`	Unknown

course

Column	Type	Keys
`id`	Unknown	PK
`activity_id`	Unknown
`course_learning_standard`	Unknown
`created`	Unknown
`dispatched`	Unknown
`metadata_description`	Unknown
`metadata_description_language`	Unknown
`metadata_duration`	Unknown
`metadata_title`	Unknown
`metadata_title_language`	Unknown
`metadata_typical_time`	Unknown
`registration_count`	Unknown
`root_activity_children`	Json
`root_activity_external_identifier`	Unknown
`root_activity_item_identifier`	Unknown
`root_activity_resource_identifier`	Unknown
`root_activity_scaled_passing_score`	Unknown
`root_activity_title`	Unknown
`root_activity_type`	Unknown
`title`	Unknown
`updated`	Unknown
`version`	Unknown
`x_api_activity_id`	Unknown

course_configuration

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`effective_value`	Unknown
`effective_value_source`	Unknown
`explicit_value`	Unknown

learner_tag

Column	Type	Keys
`tags`	Unknown	PK
`learner_id`	Unknown	PKFK

registration_launch_history

Column	Type	Keys
`id`	Unknown	PKFK
`completion_status`	Unknown
`exit_time`	Unknown
`history_log`	Unknown
`instance`	Unknown
`last_runtime_update`	Unknown
`launch_time`	Unknown
`success_status`	Unknown
`total_seconds_tracked`	Unknown

registered_learner

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	FK
`course_id`	Unknown
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown

registration_tag

Column	Type	Keys
`tags`	Unknown	PK
`registration_id`	Unknown	PKFK

registration_shared_data

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	FK
`value`	Unknown

registration_activity_runtime_interaction

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	FK
`correct_responses`	Json
`description`	Unknown
`latency`	Unknown
`learner_response`	Unknown
`objectives`	Json
`result`	Unknown
`timestamp_utc`	Unknown
`timestamps`	Unknown
`type`	Unknown
`weighting`	Unknown

registration_global_objective

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	PKFK
`first_score_scaled`	Unknown
`first_success_timestamp`	Unknown
`is_primary`	Unknown
`objective_completion`	Unknown
`objective_success`	Unknown
`previous_objective_success`	Unknown
`previous_score_scaled`	Unknown
`progress_measure`	Unknown
`score_max`	Unknown
`score_min`	Unknown
`score_raw`	Unknown
`score_scaled`	Unknown

registration_activity_objective

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	PKFK
`first_score_scaled`	Unknown
`first_success_timestamp`	Unknown
`is_primary`	Unknown
`objective_completion`	Unknown
`objective_success`	Unknown
`previous_objective_success`	Unknown
`previous_score_scaled`	Unknown
`progress_measure`	Unknown
`score_max`	Unknown
`score_min`	Unknown
`score_raw`	Unknown
`score_scaled`	Unknown

registration_activity_runtime_objective

Column	Type	Keys
`id`	Unknown	PK
`registration_id`	Unknown	FK
`description`	Unknown
`progress_measure`	Unknown
`runtime_objective_completion_status`	Unknown
`runtime_objective_success_status`	Unknown
`score_max`	Unknown
`score_min`	Unknown
`score_raw`	Unknown
`score_scaled`	Unknown

registration_activity_learner_comment

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`date_time`	Unknown
`location`	Unknown
`value`	Unknown

registration_activity_lms_comment

Column	Type	Keys
`index`	Unknown	PK
`registration_id`	Unknown	PKFK
`date_time`	Unknown
`location`	Unknown
`value`	Unknown

registration

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`dispatch_id`	Unknown	FK
`activity_completion_amount`	Unknown
`activity_details_activity_completion`	Unknown
`activity_details_activity_success`	Unknown
`activity_details_attempts`	Unknown
`activity_details_children`	Json
`activity_details_id`	Unknown
`activity_details_suspended`	Unknown
`activity_details_time_tracked`	Unknown
`activity_details_title`	Unknown
`activity_runtime_completion_status`	Unknown
`activity_runtime_credit`	Unknown
`activity_runtime_entry`	Unknown
`activity_runtime_exit`	Unknown
`activity_runtime_learner_audio_captioning`	Unknown
`activity_runtime_learner_audio_level`	Unknown
`activity_runtime_learner_delivery_speed`	Unknown
`activity_runtime_learner_language`	Unknown
`activity_runtime_location`	Unknown
`activity_runtime_mode`	Unknown
`activity_runtime_progress_measure`	Unknown
`activity_runtime_runtime_success_status`	Unknown
`activity_runtime_score_max`	Unknown
`activity_runtime_score_min`	Unknown
`activity_runtime_score_raw`	Unknown
`activity_runtime_score_scaled`	Unknown
`activity_runtime_suspend_data`	Unknown
`activity_runtime_time_tracked`	Unknown
`activity_runtime_total_time`	Unknown
`activity_score`	Unknown
`activity_static_properties_completion_threshold`	Unknown
`activity_static_properties_launch_data`	Unknown
`activity_static_properties_max_time_allowed`	Unknown
`activity_static_properties_scaled_passing_score`	Unknown
`activity_static_properties_scaled_passing_score_used`	Unknown
`activity_static_properties_time_limit_action`	Unknown
`completed_date`	Unknown
`created_date`	Unknown
`first_access_date`	Unknown
`instance`	Unknown
`last_access_date`	Unknown
`registration_completion`	Unknown
`registration_completion_amount`	Unknown
`registration_success`	Unknown
`score_scaled`	Unknown
`suspended_activity_id`	Unknown
`total_seconds_tracked`	Unknown
`updated`	Unknown
`xapi_registration_id`	Unknown