Security Journey
Explore the interactive ERD
Table & Field Reference
public_reporting_progress
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email | Unknown | FK |
all_lessons | Long | |
created_at | Instant | |
last_engagement | Instant | |
lessons_passed | Long | |
level_name | Unknown | |
path_archived | Boolean | |
path_archived_at | Instant | |
path_name | Unknown | |
required_lessons | Long | |
required_lessons_passed | Long | |
started_at | Instant | |
status | Unknown | |
time_spent | Unknown | |
updated_at | Instant |
lesson_attempt
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email | Unknown | FK |
assessments | Unknown | |
created | Unknown | |
experiment_passed | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
last_updated | Unknown | |
module_name | Unknown | |
read_transcript | Unknown | |
status | Unknown | |
time_spent | Unknown | |
user_id | Unknown | |
watched_video | Unknown |
assignment
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
email | Unknown | FK |
assignment_name | Unknown | |
due_date | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
passed | Unknown | |
progress | Unknown | |
status | Unknown | |
total | Unknown |
users
| Column | Type | Keys |
|---|---|---|
email | Unknown | PK |
ad_id | Unknown | |
business_unit | Unknown | |
business_unit_description | Unknown | |
company | Unknown | |
country | Unknown | |
deleted_at | Unknown | |
department_number | Unknown | |
employee_number | Unknown | |
employee_secondary_number | Unknown | |
first_name | Unknown | |
initial | Unknown | |
job_role | Unknown | |
last_name | Unknown | |
managers_employee_number | Unknown | |
managers_name | Unknown | |
phone_number | Unknown | |
security_champion | Unknown | |
team | Unknown | |
time_spent | Unknown | |
title | Unknown | |
total_points | Unknown |
enrollment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
email | Unknown | FK |
alls | Unknown | |
archived | Unknown | |
completed_at | Unknown | |
created_at | Unknown | |
deleted_at | Unknown | |
first_name | Unknown | |
last_engagement | Unknown | |
last_name | Unknown | |
level_name | Unknown | |
passed | Unknown | |
passed_lessons | Unknown | |
progress | Unknown | |
progress_percent | Unknown | |
public_id | Unknown | |
required | Unknown | |
required_passed | Unknown | |
required_progress_percent | Unknown | |
required_total | Unknown | |
role_name | Unknown | |
started_at | Unknown | |
status | Unknown | |
time_spent | Unknown | |
total | Unknown | |
total_lessons | Unknown | |
updated_at | Unknown | |
user_id | Unknown |