# Learn Amp schema ERD

Table and field reference for the Fivetran Learn Amp connector.

## Table & Field Reference

### sub_team_user

| Column | Type | Keys |
| --- | --- | --- |
| team_id | Unknown | PK |
| user_id | Unknown | PK, FK |
| manager_id | Unknown | FK |
| parent_team_id | Unknown | FK |

### team_user_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| team_id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |
| tags | Unknown |  |

### team_user

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| team_id | Unknown | PK, FK |
| manager_id | Unknown | FK |
| parent_team_id | Unknown | FK |
| parent_team_manager_id | Unknown | FK |
| primary_team_id | Unknown | FK |

### item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| item_category | Unknown |  |
| item_type | Unknown |  |
| short_description | Unknown |  |
| title | Unknown |  |

### channel

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| title | Unknown |  |

### verb

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| name | Unknown |  |

### learn_list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| description | Unknown |  |
| name | Unknown |  |

### team_secondary_manager

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| team_id | Unknown | PK, FK |

### team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_id | Unknown | FK |
| name | Unknown |  |
| parent_team_id | Unknown |  |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigner_id | Unknown | FK |
| set_for_id | Unknown | FK |
| taskable_added_by_user_id | Unknown | FK |
| assigned_at | Unknown |  |
| certificate_awarded_at | Unknown |  |
| certificate_expires_at | Unknown |  |
| certificate_id | Unknown |  |
| completed | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| deadline | Unknown |  |
| expired | Unknown |  |
| expired_at | Unknown |  |
| lifecycle | Unknown |  |
| mandatory | Unknown |  |
| overdue | Unknown |  |
| started_at | Unknown |  |
| taskable_display_added_by | Unknown |  |
| taskable_id | Unknown |  |
| taskable_name | Unknown |  |
| taskable_short_description | Unknown |  |
| taskable_tags | Json |  |
| taskable_total_time_estimate | Unknown |  |
| taskable_type | Unknown |  |
| type_label | Unknown |  |

### event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| short_description | Unknown |  |
| updated_at | Unknown |  |

### enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| enrolled_by_id | Unknown | FK |
| event_id | Unknown | FK |
| host_id | Unknown | FK |
| user_id | Unknown | FK |
| attendance | Unknown |  |
| created_at | Unknown |  |
| enrolled_at | Unknown |  |
| enrollment_deadline | Unknown |  |
| enrollment_type | Unknown |  |
| event_session_created_at | Unknown |  |
| event_session_ends_at | Unknown |  |
| event_session_id | Unknown |  |
| event_session_location_address | Unknown |  |
| event_session_location_type | Unknown |  |
| event_session_starts_at | Unknown |  |
| event_session_updated_at | Unknown |  |
| is_host | Unknown |  |
| space | Unknown |  |
| status | Unknown |  |
| updated_at | Unknown |  |

### user_secondary_team

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| user_id | Unknown | PK, FK |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| manager_id | Unknown | FK |
| primary_team_id | Unknown | FK |
| department | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| hire_date | Unknown |  |
| job_title | Unknown |  |
| languages | Unknown |  |
| last_name | Unknown |  |
| location | Unknown |  |
| role | Unknown |  |
| status | Unknown |  |
| time | Unknown |  |
| time_zone | Unknown |  |
| custom_** |  |  |

### activity

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| activityable_added_by_user_id | Unknown | FK |
| user_id | Unknown | FK |
| activityable_display_added_by | Unknown |  |
| activityable_id | Unknown |  |
| activityable_name | Unknown |  |
| activityable_short_description | Unknown |  |
| activityable_tags | Json |  |
| activityable_total_time_estimate | Unknown |  |
| activityable_type | Unknown |  |
| certificate_awarded_at | Unknown |  |
| certificate_expires_at | Unknown |  |
| certificate_id | Unknown |  |
| completed | Unknown |  |
| created_at | Unknown |  |
| expired | Unknown |  |
| expired_at | Unknown |  |
| result | Unknown |  |
| score | Unknown |  |
| total_time | Unknown |  |
| verb | Unknown |  |

## Relationships

- sub_team_user(parent_team_id) → team(id)
- sub_team_user(manager_id) → users(id)
- sub_team_user(user_id) → team_user(id)
- team_user_tag(team_id) → team_user(team_id)
- team_user_tag(user_id) → team_user(id)
- team_user(manager_id) → users(id)
- team_user(parent_team_id) → team(id)
- team_user(primary_team_id) → team(id)
- team_user(parent_team_manager_id) → users(id)
- team_user(team_id) → team(id)
- team_secondary_manager(id) → users(id)
- team_secondary_manager(team_id) → team(id)
- team(manager_id) → users(id)
- task(assigner_id) → users(id)
- task(set_for_id) → users(id)
- task(taskable_added_by_user_id) → users(id)
- enrollment(event_id) → event(id)
- enrollment(user_id) → users(id)
- enrollment(enrolled_by_id) → users(id)
- enrollment(host_id) → users(id)
- user_secondary_team(id) → team(id)
- user_secondary_team(user_id) → users(id)
- users(primary_team_id) → team(id)
- users(manager_id) → users(id)
- activity(user_id) → users(id)
- activity(activityable_added_by_user_id) → users(id)