Learn Amp
Explore the interactive ERD
Table & Field Reference
sub_team_user
| Column | Type | Keys |
|---|---|---|
team_id | Unknown | PK |
user_id | Unknown | PKFK |
manager_id | Unknown | FK |
parent_team_id | Unknown | FK |
team_user_tag
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
team_id | Unknown | PKFK |
user_id | Unknown | PKFK |
tags | Unknown |
team_user
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
team_id | Unknown | PKFK |
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 | PKFK |
team_id | Unknown | PKFK |
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 | PKFK |
user_id | Unknown | PKFK |
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 |