# SCORM schema ERD

Table and field reference for the Fivetran SCORM connector.

## 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 | PK, FK |

### 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| description_und | Unknown |  |
| type | Unknown |  |

### course_tag

| Column | Type | Keys |
| --- | --- | --- |
| tags | Unknown | PK |
| course_id | Unknown | PK, FK |

### course_keyword

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| course_id | Unknown | PK, FK |
| 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 | PK, FK |

### registration_launch_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| 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 | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| date_time | Unknown |  |
| location | Unknown |  |
| value | Unknown |  |

### registration_activity_lms_comment

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| registration_id | Unknown | PK, FK |
| 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 |  |

## Relationships

- course_asset(course_id) → course(id)
- dispatch_tag(dispatch_id) → dispatch(id)
- dispatch(destination_id) → destination(id)
- dispatch(course_id) → course(id)
- destination_tag(destination_id) → destination(id)
- registration_statement_attachment(registration_statement_id) → registration_statement(id)
- registration_verb(registration_statement_id) → registration_statement(id)
- registration_object_activity(registration_statement_id) → registration_statement(id)
- registration_statement(registration_id) → registration(id)
- registration_object_activity_definition(registration_object_activity_id) → registration_object_activity(id)
- course_tag(course_id) → course(id)
- course_keyword(course_id) → course(id)
- course_configuration(course_id) → course(id)
- learner_tag(learner_id) → registered_learner(id)
- registration_launch_history(id) → registration(id)
- registered_learner(registration_id) → registration(id)
- registration_tag(registration_id) → registration(id)
- registration_shared_data(registration_id) → registration(id)
- registration_activity_runtime_interaction(registration_id) → registration(id)
- registration_global_objective(registration_id) → registration(id)
- registration_activity_objective(registration_id) → registration(id)
- registration_activity_runtime_objective(registration_id) → registration(id)
- registration_activity_learner_comment(registration_id) → registration(id)
- registration_activity_lms_comment(registration_id) → registration(id)
- registration(dispatch_id) → dispatch(id)
- registration(course_id) → course(id)