# Security Journey schema ERD

Table and field reference for the Fivetran Security Journey connector.

## 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 |  |

## Relationships

- public_reporting_progress(email) → users(email)
- lesson_attempt(email) → users(email)
- assignment(email) → users(email)
- enrollment(email) → users(email)