# Proofpoint Security Awareness schema ERD

Table and field reference for the Fivetran Proofpoint Security Awareness connector.

## Table & Field Reference

### training_enrollment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| email_address | Unknown | FK |
| assignment_creation | Unknown |  |
| assignment_due_date | Unknown |  |
| assignment_id | Unknown |  |
| assignment_name | Unknown |  |
| assignment_start_date | Unknown |  |
| assignment_type | Unknown |  |
| enrollment_removal_date | Unknown |  |
| enrollment_removal_reason | Unknown |  |
| is_auto_enroll | Unknown |  |
| manager_emailaddress | Unknown |  |
| module_attempt_status | Unknown |  |
| module_due_date | Unknown |  |
| module_enrollment_date | Unknown |  |
| module_id | Unknown |  |
| module_name_admin | Unknown |  |
| module_name_user | Unknown |  |
| user_assignment_completion_date_time | Unknown |  |
| user_assignment_status | Unknown |  |
| user_module_completion_date_time | Unknown |  |

### phish_alarm

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_address | Unknown | FK |
| action | Unknown |  |
| assessment_soft_deleted_date | Unknown |  |
| campaign_name | Unknown |  |
| elapsed_hour | Unknown |  |
| email_client_version | Unknown |  |
| emailtype | Unknown |  |
| id | Unknown |  |
| os | Unknown |  |
| received_date | Unknown |  |
| reported_date | Unknown |  |

### knowledge_assessment

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_address | Unknown | FK |
| assessment_name | Unknown |  |
| assessment_status | Unknown |  |
| assessment_type | Unknown |  |
| assignment_average_score | Unknown |  |
| assignment_deleted_date | Unknown |  |
| assignment_due_date | Unknown |  |
| assignment_name | Unknown |  |
| assignment_start_date | Unknown |  |
| assignment_status | Unknown |  |
| attempt_date | Unknown |  |
| category | Unknown |  |
| category_benchmark_all | Unknown |  |
| category_benchmark_industry | Unknown |  |
| company_average_score | Unknown |  |
| correct | Unknown |  |
| id | Unknown |  |
| is_ae_enabled | Unknown |  |
| is_custom_question | Unknown |  |
| question_date | Unknown |  |
| question_id | Unknown |  |
| question_latency | Unknown |  |
| question_text | Unknown |  |
| question_type | Unknown |  |
| questions_in_category | Unknown |  |
| seconds_in_attempt | Unknown |  |
| selected_answer | Unknown |  |
| user_answered_on_assignment | Unknown |  |
| user_assignment_status | Unknown |  |
| user_correcton_assignment | Unknown |  |
| user_removed_from_assignment | Unknown |  |
| user_score_on_assignment | Unknown |  |

### phishing_extended

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_address | Unknown | FK |
| afr | Unknown |  |
| assessment_is_archived | Unknown |  |
| auto_enrollment | Unknown |  |
| browser | Unknown |  |
| browser_version | Unknown |  |
| campaign_end_date | Unknown |  |
| campaign_guid | Unknown |  |
| campaign_name | Unknown |  |
| campaign_start_date | Unknown |  |
| campaign_status | Unknown |  |
| campaign_type | Unknown |  |
| event_timestamp | Unknown |  |
| event_type | Unknown |  |
| id | Unknown |  |
| ip_address | Unknown |  |
| mobile_device_used | Unknown |  |
| os | Unknown |  |
| os_version | Unknown |  |
| sent_timestamp | Unknown |  |
| template_name | Unknown |  |
| template_subject | Unknown |  |
| user_agent | Unknown |  |
| user_guid | Unknown |  |
| who_is_city | Unknown |  |
| who_is_continent | Unknown |  |
| who_is_country | Unknown |  |
| who_is_domain | Unknown |  |
| who_is_isp | Unknown |  |
| who_is_latitude | Unknown |  |
| who_is_longitude | Unknown |  |
| who_is_organization | Unknown |  |
| who_is_state | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| email_address | Unknown | PK |
| activeflag | Unknown |  |
| data_last_updated | Unknown |  |
| deleted_date | Unknown |  |
| first_name | Unknown |  |
| id | Unknown |  |
| last_name | Unknown |  |
| locale | Unknown |  |
| sso_id | Unknown |  |
| tags | Unknown |  |
| timezone | Unknown |  |

### phishing

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_address | Unknown | FK |
| assessment_is_archived | Unknown |  |
| auto_enrollment | Unknown |  |
| campaign_end_date | Unknown |  |
| campaign_name | Unknown |  |
| campaign_start_date | Unknown |  |
| campaign_status | Unknown |  |
| campaign_type | Unknown |  |
| event_timestamp | Unknown |  |
| event_type | Unknown |  |
| id | Unknown |  |
| sent_timestamp | Unknown |  |
| template_name | Unknown |  |
| template_subject | Unknown |  |

### training

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| email_address | Unknown | FK |
| assignment_deleted | Unknown |  |
| assignment_deleted_date | Unknown |  |
| assignment_due_date | Unknown |  |
| assignment_method | Unknown |  |
| assignment_name | Unknown |  |
| assignment_start_date | Unknown |  |
| assignment_status | Unknown |  |
| duration | Unknown |  |
| force_completed_date | Unknown |  |
| id | Unknown |  |
| is_auto_enroll | Unknown |  |
| is_free_play | Unknown |  |
| module_attempt_date | Unknown |  |
| module_attempt_end_status | Unknown |  |
| module_attempt_score | Unknown |  |
| module_attempt_score_answered | Unknown |  |
| module_attempt_score_correct | Unknown |  |
| module_attempt_status | Unknown |  |
| module_last_action | Unknown |  |
| module_name_admin | Unknown |  |
| module_name_user | Unknown |  |
| module_type | Unknown |  |
| seconds_in_module_attempt | Unknown |  |
| user_assignment_status | Unknown |  |
| user_removed_from_assignment | Unknown |  |

## Relationships

- training_enrollment(email_address) → users(email_address)
- phish_alarm(email_address) → users(email_address)
- knowledge_assessment(email_address) → users(email_address)
- phishing_extended(email_address) → users(email_address)
- phishing(email_address) → users(email_address)
- training(email_address) → users(email_address)