Fivetran documentation

Search the docs

/

Lessonly

Explore the interactive ERD

Table & Field Reference

path_tag

Column	Type	Keys
`id`	Long	PKFK
`path_id`	Long	PKFK
`name`	Unknown
`resource_type`	Unknown

content_in_path_content

Column	Type	Keys
`id`	Long	PK
`path_content_id`	Long	PKFK
`path_id`	Long	PKFK
`amount`	Unknown
`archived_at`	Unknown
`archived_by_user_id`	Unknown
`condition`	Unknown
`description`	Unknown
`effect`	Unknown
`resource_type`	Unknown
`title`	Unknown
`unit`	Unknown

path_content

Column	Type	Keys
`id`	Long	PKFK
`path_id`	Long	PKFK
`amount`	Unknown
`archived_at`	Unknown
`archived_by_user_id`	Unknown
`condition`	Unknown
`description`	Unknown
`effect`	Unknown
`resource_type`	Unknown
`title`	Unknown
`unit`	Unknown

path

Column	Type	Keys
`id`	Long	PK
`archived_at`	Unknown
`archived_by_user_id`	Unknown
`created_at`	Instant
`is_certification`	Boolean
`last_updated_at`	Instant
`links_overview`	String
`links_shareable`	String
`public`	Boolean
`published_at`	Instant
`publisher_id`	Long
`resource_type`	String
`title`	String

group_member

Column	Type	Keys
`group_id`	Long	PKFK
`id`	Long	PKFK
`should_receive_email`	Boolean

group_manager

Column	Type	Keys
`group_id`	Long	PKFK
`id`	Long	PKFK

group_detail

Column	Type	Keys
`group_id`	Long	PKFK
`resource_type`	String
`type`	String

groups

Column	Type	Keys
`id`	Long	PK
`archived_at`	Unknown
`archived_by_user_id`	Unknown
`name`	String

group_assignment

Column	Type	Keys
`group_id`	Long	PKFK
`id`	Long	PKFK
`assignable_id`	Long
`assignable_type`	String

path_assignment

Column	Type	Keys
`id`	Long	PKFK
`path_id`	Long	FK

user_learning_library

Column	Type	Keys
`_fivetran_id`	String	PK
`users_id`	Long	FK
`total_completed`	Long
`total_views`	Long
`unique_learning_content_views`	Long

user_assignment

Column	Type	Keys
`id`	Unknown	PKFK
`users_id`	Long	FK

assignment_content

Column	Type	Keys
`id`	Long	PK
`assignment_id`	Long	PKFK
`completed_at`	Instant
`resource_type`	String
`score`	Long
`started_at`	Instant
`status`	String

assignment

Column	Type	Keys
`id`	Long	PK
`assignee_id`	Long	FK
`assignable_id`	Long
`assignable_type`	String
`assigned_at`	Instant
`completed_at`	Instant
`due_by`	Instant
`ext_uid`	String
`is_certification`	Boolean
`reassigned_at`	Instant
`resource_type`	String
`score`	Long
`started_at`	Instant
`status`	String
`updated_at`	Instant

lesson_assignment

Column	Type	Keys
`id`	Long	PKFK
`lesson_id`	Long	FK

lesson_tag

Column	Type	Keys
`id`	Long	PKFK
`lesson_id`	Long	PKFK

lesson

Column	Type	Keys
`id`	Long	PK
`archived_at`	Unknown
`archived_by_user_id`	Unknown
`created_at`	Instant
`last_updated_at`	Instant
`links_overview`	String
`links_shareable`	String
`public`	Boolean
`resource_type`	String
`retake_score`	Long
`title`	String

lesson_completion_breakdown

Column	Type	Keys
`_fivetran_id`	String	PK
`lesson_id`	Long	FK
`total`	Long
`type`	String
`via_assignment`	Long
`via_other`	Long

custom_user_field_data

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Long	PKFK
`custom_user_field_id`	Long
`id`	Long
`name`	String
`value`	String

users

Column	Type	Keys
`id`	Long	PK
`archived_at`	Unknown
`archived_by_user_id`	Unknown
`business_unit`	Unknown
`department`	Unknown
`email`	String
`ext_uid`	Unknown
`hire_date`	Unknown
`job_title`	String
`locale`	String
`location`	Unknown
`manager_name`	String
`mobile_phone_number`	Unknown
`name`	String
`resource_type`	String
`role`	String
`role_id`	Long

tags

Column	Type	Keys
`id`	Long	PK
`name`	String
`resource_type`	String