# Lessonly schema ERD

Table and field reference for the Fivetran Lessonly connector.

## Table & Field Reference

### path_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK, FK |
| path_id | Long | PK, FK |
| name | Unknown |  |
| resource_type | Unknown |  |

### content_in_path_content

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| path_content_id | Long | PK, FK |
| path_id | Long | PK, FK |
| 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 | PK, FK |
| path_id | Long | PK, FK |
| 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 | PK, FK |
| id | Long | PK, FK |
| should_receive_email | Boolean |  |

### group_manager

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Long | PK, FK |
| id | Long | PK, FK |

### group_detail

| Column | Type | Keys |
| --- | --- | --- |
| group_id | Long | PK, FK |
| 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 | PK, FK |
| id | Long | PK, FK |
| assignable_id | Long |  |
| assignable_type | String |  |

### path_assignment

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

### assignment_content

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK |
| assignment_id | Long | PK, FK |
| 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 | PK, FK |
| lesson_id | Long | FK |

### lesson_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Long | PK, FK |
| lesson_id | Long | PK, FK |

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

## Relationships

- path_tag(id) → tags(id)
- path_tag(path_id) → path(id)
- content_in_path_content(path_id) → path(id)
- content_in_path_content(path_content_id) → path_content(id)
- path_content(id) → lesson(id)
- path_content(path_id) → path(id)
- group_member(id) → users(id)
- group_member(group_id) → group_detail(group_id)
- group_manager(id) → users(id)
- group_manager(group_id) → group_detail(group_id)
- group_detail(group_id) → groups(id)
- group_assignment(id) → assignment(id)
- group_assignment(group_id) → groups(id)
- path_assignment(id) → assignment(id)
- path_assignment(path_id) → path(id)
- user_learning_library(users_id) → users(id)
- user_assignment(id) → assignment(id)
- user_assignment(users_id) → users(id)
- assignment_content(assignment_id) → assignment(id)
- assignment(assignee_id) → users(id)
- lesson_assignment(id) → assignment(id)
- lesson_assignment(lesson_id) → lesson(id)
- lesson_tag(id) → tags(id)
- lesson_tag(lesson_id) → lesson(id)
- lesson_completion_breakdown(lesson_id) → lesson(id)
- custom_user_field_data(user_id) → users(id)