Docebo

Explore the interactive ERD

Table & Field Reference

root_category

Column	Type	Keys
`id`	Unknown	PK
`i_left`	Unknown
`i_right`	Unknown
`id_parent`	Unknown
`is_root`	Unknown
`lev`	Unknown
`root_node_id`	Unknown
`title`	Unknown
`title_parent`	Unknown

course_enrollment_details

Column	Type	Keys
`course_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`assignment_type`	Unknown
`enrollment_completion_date`	LocalDate
`enrollment_create_by`	Unknown
`enrollment_created_at`	LocalDate
`enrollment_date_last_updated`	LocalDate
`enrollment_level`	Unknown
`enrollment_score`	Unknown
`enrollment_status`	Unknown
`enrollment_validity_begin_date`	LocalDate
`enrollment_validity_begin_datetime`	LocalDate
`enrollment_validity_end_date`	LocalDate
`enrollment_validity_end_datetime`	LocalDate

audience_user

Column	Type	Keys
`audience_uuid`	Unknown	PKFK
`idst`	Unknown	PKFK
`relation_type`	Unknown

session_additional_field

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`fivetran_id`	Unknown	PKFK
`title`	Unknown
`type`	Unknown
`value`	Unknown
`visible_to_user`	Unknown

session_instructor

Column	Type	Keys
`username`	Unknown	PK
`course_id`	Unknown	PKFK
`fivetran_id`	Unknown	PKFK
`session_id`	Unknown	PKFK

datewise_instructor

Column	Type	Keys
`username`	Unknown	PK
`course_id`	Unknown	PKFK
`fivetran_id`	Unknown	PKFK
`session_event_id`	Unknown	PKFK
`session_id`	Unknown	PKFK

session_event

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`fivetran_id`	Unknown	PKFK
`session_id`	Unknown	PKFK
`classroom_id`	Unknown	FK
`location_id`	Unknown	FK
`allowed_api_grab`	Unknown
`allowed_api_link`	Unknown
`collaboration_tool`	Unknown
`day`	Unknown
`description`	Unknown
`duration`	Unknown
`effective_duration`	Unknown
`has_recording`	Unknown
`is_instructor`	Unknown
`join_in_advance_instructor`	Unknown
`join_in_advance_user`	Unknown
`name`	Unknown
`recording_status`	Unknown
`start_hour`	Unknown
`time_begin`	Unknown
`time_end`	Unknown
`timezone`	Unknown
`tool`	Unknown
`tool_mapping_field_lms`	Unknown
`url`	Unknown
`user_status`	Unknown
`webinar_tool`	Unknown
`webinar_tool_sync_failed`	Unknown

session

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`fivetran_id`	Unknown	PKFK
`begin_day`	Unknown
`begin_time`	Unknown
`begin_timezone`	Unknown
`can_manage`	Unknown
`description`	Unknown
`end_date`	Unknown
`end_time`	Unknown
`end_timezone`	Unknown
`evaluation_type`	Unknown
`is_instructor`	Unknown
`migrated_webinar_session_id`	Unknown
`min_dates_for_completion`	Unknown
`name`	Unknown
`score_base`	Unknown
`slug_name`	Unknown
`start_date`	Unknown

session_enrollment

Column	Type	Keys
`_fivetran_id`	String	PK
`course_id`	Unknown	PKFK
`comment`	Unknown
`current_location`	Unknown
`evaluation_date`	Unknown
`evaluation_name`	Unknown
`evaluation_status`	Unknown
`evaluation_url`	Unknown
`evaluator_avatar`	Unknown
`evaluator_firstname`	Unknown
`evaluator_lastname`	Unknown
`evaluator_username`	Unknown
`is_enrolled`	Unknown
`score`	Unknown

channel_item

Column	Type	Keys
`id`	Unknown	PK
`channel_id`	Unknown	FK
`inviter_id`	Unknown	FK
`owner_id`	Unknown	FK
`assets_count`	Unknown
`can_enter`	Unknown
`can_enter_reason`	Unknown
`content_type`	Unknown
`courses_count`	Unknown
`created`	Unknown
`description`	Unknown
`domain`	Unknown
`duration`	Unknown
`expiration_date`	Unknown
`external_type`	Unknown
`hidden`	Unknown
`image_url`	Unknown
`inviter_avatar`	Unknown
`inviter_full_name`	Unknown
`inviter_short_name`	Unknown
`is_asset_downloadable`	Unknown
`is_error`	Unknown
`is_loading`	Unknown
`is_new`	Unknown
`is_private`	Unknown
`is_watched`	Unknown
`language_code`	Unknown
`language_label`	Unknown
`languages`	Unknown
`level`	Unknown
`level_label`	Unknown
`link_url`	Unknown
`outdated_already_marked`	Unknown
`outdated_total_users`	Unknown
`publish_date`	Unknown
`rating`	Unknown
`rating_option`	Unknown
`shared_asset_id`	Unknown
`status`	Unknown
`status_id`	Unknown
`status_label`	Unknown
`title`	Unknown
`type`	Unknown
`type_id`	Unknown
`uri`	Unknown
`views`	Unknown

channel

Column	Type	Keys
`id`	Unknown	PK
`created`	Unknown
`description`	Unknown
`icon_background`	Unknown
`icon_color`	Unknown
`icon_font`	Unknown
`is_enabled`	Unknown
`is_followed`	Unknown
`name`	Unknown
`notification`	Unknown
`predefined_uid`	Unknown

manager_subordinate_relation

Column	Type	Keys
`id`	Unknown	PK
`manager_id`	Unknown	PK
`manager_subordinate_id`	Unknown	PKFK

subordinate_manager_type

Column	Type	Keys
`manager_type_id`	Unknown	PK
`relation_id`	Unknown	PK
`manager_subordinate_id`	Unknown	FK
`last_update`	Unknown
`name`	Unknown
`status`	Unknown

manager_subordinate

Column	Type	Keys
`manager_id`	Unknown	PK
`id`	Unknown	PKFK
`actions`	Json
`active_subordinates_count`	Unknown
`expertise`	Unknown
`has_dashboard`	Unknown
`is_manager`	Unknown
`is_new`	Unknown
`kpi_expired_certification`	Unknown
`kpi_overdue_course`	Unknown
`kpi_status`	Unknown
`occupation_canonical_code`	Unknown
`occupation_canonical_name`	Unknown
`occupation_code`	Unknown
`occupation_id`	Unknown
`occupation_is_custom`	Unknown
`occupation_name`	Unknown
`pending_subordinates_count`	Unknown
`skills_count`	Unknown
`skills_suggestion_count`	Unknown
`trend`	Unknown
`uuid`	Unknown

user_field

Column	Type	Keys
`id`	Unknown	PK
`enabled`	Unknown
`inherited`	Unknown
`invisible_to_user`	Unknown
`mandatory`	Unknown
`settings`	Json
`system_field`	Unknown
`title`	Unknown
`type`	Unknown

learning_plan_enrollment

Column	Type	Keys
`learning_plan_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`assignment_type`	Unknown
`enrollment_completion_date`	Unknown
`enrollment_completion_percentage`	Unknown
`enrollment_created_at`	Unknown
`enrollment_created_by`	Unknown
`enrollment_date_last_updated`	Unknown
`enrollment_status`	Unknown
`enrollment_time_spent`	Unknown
`enrollment_validity_begin_date`	Unknown
`enrollment_validity_begin_datetime`	Unknown
`enrollment_validity_end_date`	Unknown
`enrollment_validity_end_datetime`	Unknown
`learning_plan_code`	Unknown
`learning_plan_name`	Unknown
`username`	Unknown

enrollment_approval_pending

Column	Type	Keys
`user_id`	Unknown	PKFK
`course_id`	Unknown	FK
`session_id`	Unknown	FK
`subscription_date`	Unknown
`username`	Unknown

user_associated_skill

Column	Type	Keys
`_fivetran_id`	String	PK
`id`	Unknown	FK
`skill_id`	Unknown	FK
`expertise`	Unknown

skill

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`content_number`	Unknown
`description`	Unknown
`is_custom`	Unknown
`name`	Unknown
`predefined_uid`	Unknown
`skillsets_number`	Unknown
`source`	Unknown
`title`	Unknown
`users_number`	Unknown

external_training_additional_field

Column	Type	Keys
`id`	Unknown	PK
`external_training_id`	Unknown	PKFK
`title`	Unknown
`type`	Unknown
`value`	Unknown

external_training

Column	Type	Keys
`training_id`	Unknown	PK
`course_code`	Unknown	FK
`user_id`	Unknown	FK
`ceus`	Unknown
`from_date`	Unknown
`score`	Unknown
`to_date`	Unknown
`training_institute`	Unknown
`training_institute_code`	Unknown
`uuid`	Unknown

partner

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	PKFK
`updated_by`	Unknown	FK
`active`	Unknown
`address`	Unknown
`affiliate_code`	Unknown
`catalog_visible`	Unknown
`city`	Unknown
`country`	Unknown
`course_visible`	Unknown
`description`	Unknown
`discount`	Unknown
`email`	Unknown
`enable_affiliate`	Unknown
`logo`	Unknown
`logo_full_path`	Unknown
`name`	Unknown
`phone`	Unknown
`referral_code`	Unknown
`state`	Unknown
`updated_at`	Unknown
`website`	Unknown

course

Column	Type	Keys
`id`	Unknown	PK
`category_id`	Unknown	FK
`affiliate_price`	Unknown
`available_seats`	Unknown
`can_rate`	Unknown
`can_self_unenroll`	Unknown
`category_name`	Unknown
`code`	Unknown
`credits`	Unknown
`current_rating`	Unknown
`date_last_updated`	Unknown
`description`	Unknown
`duration`	Unknown
`end_date`	Unknown
`enrollment_policy`	Unknown
`image`	Unknown
`img_url`	Unknown
`is_affiliate`	Unknown
`is_new`	Unknown
`is_opened`	Unknown
`language_label`	Unknown
`languages`	Unknown
`max_attempts`	Unknown
`name`	Unknown
`partner_fileds`	Unknown
`partner_id`	Unknown
`price`	Unknown
`rating_option`	Unknown
`selling`	Unknown
`slug_name`	Unknown
`start_date`	Unknown
`type`	Unknown
`uid`	Unknown

channel_expert

Column	Type	Keys
`channel_id`	Unknown	PKFK
`user_id`	Unknown	PKFK

course_enrollment

Column	Type	Keys
`course_id`	Unknown	PKFK
`username`	Unknown	PKFK
`code`	Unknown
`completion_date`	Unknown
`enrollment_date`	Unknown
`first_name`	Unknown
`has_esignature_enabled`	Unknown
`last_access`	Unknown
`last_name`	Unknown
`name`	Unknown
`score`	Unknown
`status`	Unknown
`time_in_course`	Unknown
`type`	Unknown

audience_labels

Column	Type	Keys
`index`	Unknown	PK
`audience_uuid`	Unknown	PKFK
`label`	Unknown

audience_rule_set

Column	Type	Keys
`id`	Unknown	PK
`audience_uuid`	Unknown	PKFK
`rules`	Json
`rules_operator`	Unknown

audience

Column	Type	Keys
`uuid`	Unknown	PK
`created_by_idst`	Unknown	FK
`updated_by_idst`	Unknown	FK
`description`	Unknown
`exclude_deactivated_users`	Unknown
`name`	Unknown
`rule_set_operator`	Unknown
`rule_set_status`	Unknown
`type`	Unknown
`updated_at`	Unknown

learning_plan_course

Column	Type	Keys
`id`	Unknown	PKFK
`learning_plan_id`	Unknown	PKFK
`all_courses`	Unknown
`category`	Unknown
`code`	Unknown
`courses_to_be_completed`	Unknown
`create_date`	Unknown
`is_published`	Unknown
`is_required`	Unknown
`language_browser_code`	Unknown
`language_code`	Unknown
`language_name`	Unknown
`postpone_access`	Unknown
`prerequisites_count`	Unknown
`sequence`	Unknown
`time`	Unknown
`time_unit`	Unknown
`title`	Unknown
`type`	Unknown
`uid`	Unknown

ilt_session

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`user_id`	Unknown	FK
`attendance`	Unknown
`completion_date`	Unknown
`enrollment_date`	Unknown
`evaluation_comment`	Unknown
`evaluation_date`	Unknown
`evaluation_score`	Unknown
`evaluation_status`	Unknown
`evaluator_id`	Unknown
`level`	Unknown
`status`	Unknown

test

Column	Type	Keys
`id`	Unknown	PK
`course_id`	Unknown	FK
`user_id`	Unknown	FK
`fullname`	Unknown
`title`	Unknown

catalog_content

Column	Type	Keys
`id`	Unknown	PK
`item_category`	Unknown	FK
`access_status`	Unknown
`affiliate_price`	Unknown
`course_type`	Unknown
`course_user_status`	Unknown
`duration`	Unknown
`is_affiliate`	Unknown
`is_new`	Unknown
`is_opened`	Unknown
`is_user_enrolled`	Unknown
`is_user_subscribed`	Unknown
`item_can_enroll`	Unknown
`item_code`	Unknown
`item_create_date`	Unknown
`item_date_end`	Unknown
`item_description`	Unknown
`item_ecommerce`	Json
`item_language`	Unknown
`item_language_code`	Unknown
`item_language_label`	Unknown
`item_name`	Unknown
`item_policy`	Unknown
`item_price`	Unknown
`item_rating`	Unknown
`item_slug`	Unknown
`item_type`	Unknown
`item_type_int`	Unknown
`item_visibility`	Unknown
`number_of_course`	Unknown
`partner_field`	Json
`price_currency_code`	Unknown
`price_status`	Unknown
`quick_course_launch`	Unknown
`selling`	Unknown
`total_duration`	Unknown
`waiting`	Unknown

classroom

Column	Type	Keys
`id`	Unknown	PK
`location_id`	Unknown	FK
`details`	Unknown
`equipment`	Unknown
`name`	Unknown
`seats`	Unknown

subscription_plan

Column	Type	Keys
`id`	Unknown	PK
`bundle_id`	Unknown	FK
`actions`	Unknown
`availability`	Unknown
`code`	Unknown
`duration`	Unknown
`ecommerce_pricing_system_default`	Unknown
`enforce_limit`	Unknown
`field_1111`	Unknown
`name`	Unknown
`price`	Unknown
`renewal_type`	Unknown
`validity_period`	Unknown
`validity_units`	Unknown

users_manager

Column	Type	Keys
`_fivetran_id`	String	PK
`users_id`	Unknown	PKFK
`username`	Unknown	FK
`name`	Unknown
`title`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`actions`	Json
`authenticator_app_pair_date`	Unknown
`avatar`	Unknown
`confirmed`	Unknown
`country`	Unknown
`create_by_admin`	Unknown
`creation_date`	Unknown
`currently_logged_users_count`	Unknown
`date_format`	Unknown
`email`	Unknown
`email_validation_status`	Unknown
`encoded_username`	Unknown
`expiration_date`	Unknown
`expired`	Unknown
`field_1111`	Unknown
`first_name`	Unknown
`fullname`	Unknown
`is_manager`	Unknown
`lang_code`	Unknown
`languages`	Unknown
`last_access_date`	Unknown
`last_name`	Unknown
`last_update`	Unknown
`level`	Unknown
`multi_domains`	Json
`name`	Unknown
`newsletter_optout`	Unknown
`newsletter_optout_date`	Unknown
`request_on`	Unknown
`send_notification`	Unknown
`status`	Unknown
`timezone`	Unknown
`uuid`	Unknown
`version`	Unknown
`custom_`

gamification_leaderboard_position

Column	Type	Keys
`position`	Unknown	PK
`gamification_leaderboard_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`is_me`	Unknown
`last_assign`	Unknown
`percentage`	Unknown
`points`	Unknown

gamification_leaderboard

Column	Type	Keys
`id`	Unknown	PK
`users_id`	Unknown	PKFK
`anonymity`	Unknown
`defaults`	Unknown
`is_active`	Unknown
`is_visible`	Unknown
`name`	Unknown
`visible_by`	Json

subscription_bundle

Column	Type	Keys
`id`	Unknown	PK
`actions`	Unknown
`code`	Unknown
`description`	Unknown
`name`	Unknown
`published`	Unknown
`sub_items_id`	Unknown
`sub_items_name`	Unknown
`type`	Unknown
`type_id`	Unknown

course_learning_plan

Column	Type	Keys
`course_id`	Unknown	PKFK
`learning_plan_id`	Unknown	PKFK

learning_plan

Column	Type	Keys
`id`	Unknown	PK
`code`	Unknown
`create_date`	Unknown
`date_last_updated`	Unknown
`description`	Unknown
`image`	Unknown
`name`	Unknown

gamification_badge

Column	Type	Keys
`_fivetran_id`	String	PK
`users_id`	Unknown	FK
`badge_description`	Unknown
`badge_name`	Unknown
`id`	Unknown
`is_shareable`	Unknown
`issued_on`	Unknown
`total_badges_count`	Unknown
`total_score`	Unknown

location

Column	Type	Keys
`id`	Unknown	PK
`accommodations`	Unknown
`address`	Unknown
`country`	Unknown
`directions`	Unknown
`email`	Unknown
`images`	Unknown
`name`	Unknown
`other_info`	Unknown
`telephone`	Unknown

course_learning_objective

Column	Type	Keys
`org_id`	Unknown	PK
`course_id`	Unknown	PKFK
`item_id`	Unknown
`object_type`	Unknown
`parent_id`	Unknown
`resource_id`	Unknown
`status`	Unknown
`title`	Unknown