360Learning
Explore the interactive ERD
Table & Field Reference
custom_link
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
custom_link_id | Unknown | |
url | Unknown |
user_certificate
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
path_id | Unknown | FK |
path_session_id | Unknown | FK |
certificate_outline_id | Unknown | |
delivery_date | Unknown | |
expiration_date | Unknown | |
title | Unknown | |
type | Unknown | |
validity_period | Unknown |
classroom_slot_registration
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
classroom_slot_id | Unknown | PKFK |
path_id | Unknown | FK |
user_id | Unknown | FK |
archived_at | Instant | |
attendance_duration | Unknown | |
created_at | Instant | |
has_attended | Unknown | |
modified_at | Instant | |
rsvp_going | Unknown | |
rsvp_last_updated_at | Instant | |
status | Unknown |
user_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
user_id | Unknown | PKFK |
type | Unknown | |
value | Unknown |
path_step
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
path_id | Unknown | PKFK |
attempts_limit | Unknown | |
auto_registration | Unknown | |
availability_mode | Unknown | |
availability_relative_unit | Unknown | |
availability_relative_value | Unknown | |
is_examination | Unknown | |
min_score | Unknown | |
optional | Unknown | |
recipient_type | Unknown | |
relative_date_unit | Unknown | |
relative_date_value | Unknown | |
scheduling_condition | Unknown | |
scheduling_relative_to | Unknown | |
scheduling_relativity | Unknown | |
show_correction | Unknown | |
show_forum | Unknown | |
subtype | Unknown | |
time_limit_mode | Unknown | |
time_limit_value | Unknown | |
type | Unknown |
path_translator
| Column | Type | Keys |
|---|---|---|
translator_id | Unknown | PK |
path_id | Unknown | PKFK |
path_translation_index | Unknown | PKFK |
path_translation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
path_id | Unknown | PKFK |
lang | Unknown | |
published | Unknown | |
translated_description | Unknown | |
translated_name | Unknown |
path
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
group_id | Unknown | FK |
additional_information | Unknown | |
automated_reminders | Unknown | |
certificate_id | Unknown | |
created_at | Unknown | |
default_lang | Unknown | |
description | Unknown | |
display_classroom_messages | Unknown | |
display_forum | Unknown | |
estimated_commitment_max | Unknown | |
estimated_commitment_min | Unknown | |
estimated_duration_unit | Unknown | |
estimated_duration_value | Unknown | |
linear_progression | Unknown | |
mandatory_replay | Unknown | |
modified_at | Unknown | |
name | Unknown | |
notification_on_step_create | Unknown | |
source_lang | Unknown | |
status | Unknown |
path_tag
| Column | Type | Keys |
|---|---|---|
path_id | Unknown | PKFK |
tag_id | Unknown | PKFK |
attendance_sheet
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
classroom_slot_id | Unknown | PKFK |
check_in_code | Unknown | |
name | Unknown | |
organization_logo_id | Unknown | |
personalized_fields | Unknown | |
status | Unknown |
classroom_slot_trainer
| Column | Type | Keys |
|---|---|---|
classroom_slot_id | Unknown | PKFK |
trainer_id | Unknown | PKFK |
classroom_slot_media
| Column | Type | Keys |
|---|---|---|
media_id | Unknown | PK |
classroom_slot_id | Unknown | PKFK |
classroom_slot
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
classroom_id | Unknown | PKFK |
context_id | Unknown | |
context_type | Unknown | |
created_at | Instant | |
end_date | Instant | |
location | Unknown | |
max_capacity | Unknown | |
modified_at | Instant | |
name | Unknown | |
reported_duration | Unknown | |
self_registration_cutoff_date | Instant | |
self_registration_enabled | Unknown | |
start_date | Instant | |
timezone | Unknown | |
virtual | Unknown | |
webinar_provider | Unknown |
custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
name | Unknown | |
target_type | Unknown | |
type | Unknown |
path_session_stat
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
path_id | Unknown | PK |
path_session_id | Unknown | PKFK |
certificate_id | Unknown | FK |
user_id | Unknown | FK |
completed_at | Unknown | |
due_date | Unknown | |
enrolled_at | Unknown | |
progress | Unknown | |
score | Unknown | |
self_enrolled | Unknown | |
started_at | Unknown | |
status_type | Unknown | |
time_spent | Unknown | |
unenrolled_at | Unknown |
path_session_instructor
| Column | Type | Keys |
|---|---|---|
instructor_id | Unknown | PK |
path_session_id | Unknown | PKFK |
path_session_translator
| Column | Type | Keys |
|---|---|---|
translator_id | Unknown | PK |
path_session_id | Unknown | PKFK |
path_session_translation_index | Unknown | PKFK |
path_session_translation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
path_session_id | Unknown | PKFK |
lang | Unknown | |
published | Unknown | |
translated_name | Unknown |
path_session
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
group_id | Unknown | FK |
path_id | Unknown | FK |
additional_information | Unknown | |
auto_reenroll_delay_days | Unknown | |
auto_reenroll_type | Unknown | |
created_at | Unknown | |
end_date | Unknown | |
ip_filtering_active | Unknown | |
ip_filtering_authorized_addr | Unknown | |
is_audience_builder | Unknown | |
main_instructor_id | Unknown | |
modified_at | Unknown | |
name | Unknown | |
registration_request_validation | Unknown | |
root_session_id | Unknown | |
start_date | Unknown | |
user_limit | Unknown |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_group_id | Unknown | FK |
background_image_id | Unknown | |
banner_image_id | Unknown | |
custom | Unknown | |
favicon_image_id | Unknown | |
logo_image_id | Unknown | |
moderation_charter_explicit_consent | Unknown | |
moderation_charter_url | Unknown | |
name | Unknown | |
privacy_policy_explicit_consent | Unknown | |
privacy_policy_url | Unknown | |
public | Unknown | |
subdomain | Unknown | |
terms_of_use_explicit_consent | Unknown | |
terms_of_use_url | Unknown | |
url | Unknown |
classroom_media
| Column | Type | Keys |
|---|---|---|
media_id | Unknown | PK |
classroom_id | Unknown | PKFK |
classroom
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
group_id | Unknown | FK |
created_at | Unknown | |
message | Unknown | |
modified_at | Unknown | |
name | Unknown | |
training_objective | Unknown |
user_reactivated_at
| Column | Type | Keys |
|---|---|---|
reactivated_at | Unknown | PK |
user_id | Unknown | PKFK |
user_deleted_at
| Column | Type | Keys |
|---|---|---|
deleted_at | Unknown | PK |
user_id | Unknown | PKFK |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
custom | Unknown | |
first_name | Unknown | |
job | Unknown | |
lang | Unknown | |
last_login_date | Unknown | |
last_name | Unknown | |
mail | Unknown | |
organization | Unknown | |
phone | Unknown | |
status | Unknown | |
to_be_deactivated_at | Instant | |
username | Unknown |
tags
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
external_id | Unknown | |
is_main | Unknown | |
name | Unknown | |
source | Unknown |
path_statistics
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
certificate_id | Unknown | FK |
path_id | Unknown | FK |
user_id | Unknown | FK |
completed_at | Instant | |
due_date | Instant | |
enrolled_at | Instant | |
progress | Unknown | |
score | Unknown | |
self_enrolled | Unknown | |
session_id | Unknown | |
started_at | Instant | |
status_reason | Unknown | |
status_type | Unknown | |
time_spent | Unknown | |
unenrolled_at | Instant |
course_stat
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
course_id | Unknown | FK |
path_id | Unknown | FK |
path_session_id | Unknown | FK |
user_id | Unknown | FK |
completed_at | Unknown | |
first_activity_at | Unknown | |
lang | Unknown | |
last_activity_at | Unknown | |
progress | Unknown | |
score | Unknown | |
time_spent | Unknown | |
version_number | Unknown |
group_user
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
user_id | Unknown | PKFK |
role | Unknown |
attendance
| Column | Type | Keys |
|---|---|---|
attendance_sheet_id | Unknown | PKFK |
classroom_slot_id | Unknown | PKFK |
user_id | Unknown | PKFK |
status | Unknown |
skill_parent
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
skill_id | Unknown | PKFK |
external_id | Unknown |
skill_translation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
skill_id | Unknown | PKFK |
lang | Unknown | |
translated_description | Unknown | |
translated_name | Unknown |
skill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creation_date | Unknown | |
description | Unknown | |
external_id | Unknown | |
library_id | Unknown | |
modification_date | Unknown | |
name | Unknown | |
status | Unknown |
course_co_author
| Column | Type | Keys |
|---|---|---|
co_author_id | Unknown | PKFK |
course_id | Unknown | PKFK |
course_translator
| Column | Type | Keys |
|---|---|---|
translator_id | Unknown | PK |
course_id | Unknown | PKFK |
course_translation_index | Unknown | PKFK |
course_translation
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
course_id | Unknown | PKFK |
description | Unknown | |
lang | Unknown | |
name | Unknown | |
published | Unknown |
course
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
author_id | Unknown | FK |
group_id | Unknown | FK |
creation_date | Unknown | |
current_version_number | Unknown | |
default_lang | Unknown | |
description | Unknown | |
duration | Unknown | |
external_platform | Unknown | |
modification_date | Unknown | |
name | Unknown | |
source_lang | Unknown | |
status | Unknown | |
type | Unknown |
course_tag
| Column | Type | Keys |
|---|---|---|
course_id | Unknown | PKFK |
tag_id | Unknown | PKFK |