KnowBe4

Explore the interactive ERD

Table & Field Reference

phishing_security_tests_group

Column	Type	Keys
`group_id`	Unknown	PKFK
`pst_id`	Unknown	PKFK
`name`	Unknown

phishing_security_tests_categories

Column	Type	Keys
`category_id`	Unknown	PK
`phishing_security_test_id`	Unknown	PKFK
`name`	Unknown

phishing_security_test

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`attachment_open_count`	Unknown
`bounced_count`	Unknown
`clicked_count`	Unknown
`data_entered_count`	Unknown
`delivered_count`	Unknown
`duration`	Unknown
`landing_page_id`	Unknown
`landing_page_name`	Unknown
`macro_enabled_count`	Unknown
`name`	Unknown
`opened_count`	Unknown
`phish_prone_percentage`	Unknown
`qr_code_scanned_count`	Unknown
`replied_count`	Unknown
`reported_count`	Unknown
`scheduled_count`	Unknown
`started_at`	Unknown
`status`	Unknown

groups

Column	Type	Keys
`id`	Unknown	PK
`current_risk_score`	Unknown
`group_type`	Unknown
`member_count`	Unknown
`name`	Unknown
`provisioning_guid`	Unknown
`status`	Unknown

store_purchase

Column	Type	Keys
`id`	Unknown	PK
`content_type`	Unknown
`description`	Unknown
`duration`	Unknown
`name`	Unknown
`policy_url`	Unknown
`publish_date`	Unknown
`publisher`	Unknown
`purchase_date`	Unknown
`retired`	Unknown
`retirement_date`	Unknown
`type`	Unknown

account_and_risk_score_history

Column	Type	Keys
`_fivetran_id`	String	PK
`date`	Unknown
`risk_score`	Unknown

specific_users_risk_score_history

Column	Type	Keys
`_fivetran_id`	String	PK
`users_id`	Unknown	FK
`date`	Unknown
`risk_score`	Unknown

phishing_campaign_group

Column	Type	Keys
`group_id`	Unknown	PKFK
`phishing_campaign_id`	Unknown	PKFK

phishing_campaign_psts

Column	Type	Keys
`phishing_campaign_id`	Unknown	PKFK
`pst_id`	Unknown	PKFK
`phish_prone_percentage`	Unknown
`start_date`	Unknown
`status`	Unknown
`users_count`	Unknown

phishing_campaign_difficulty_filter

Column	Type	Keys
`_fivetran_id`	String	PK
`phishing_campaign_id`	Unknown	FK
`difficulty_filter`	Unknown

phishing_campaign

Column	Type	Keys
`id`	Unknown	PK
`campaign_id`	Unknown	FK
`create_date`	Unknown
`frequency`	Unknown
`hidden`	Unknown
`last_phish_prone_percentage`	Unknown
`last_run`	Unknown
`name`	Unknown
`psts_count`	Unknown
`send_duration`	Unknown
`status`	Unknown
`track_duration`	Unknown

training_enrollment

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`campaign_name`	Unknown
`completion_date`	Unknown
`content_type`	Unknown
`enrollment_date`	Unknown
`module_name`	Unknown
`policy_acknowledged`	Unknown
`start_date`	Unknown
`status`	Unknown
`time_spent`	Unknown

account_domain

Column	Type	Keys
`domain`	Unknown	PK
`account_index`	Unknown	PKFK
`account_type`	Unknown	PKFK
`organization_name`	Unknown	PKFK

account_admin

Column	Type	Keys
`id`	Unknown	PK
`account_index`	Unknown	PKFK
`account_type`	Unknown	PKFK
`organization_name`	Unknown	PKFK
`email`	Unknown
`first_name`	Unknown
`last_name`	Unknown

account

Column	Type	Keys
`index`	Unknown	PK
`name`	Unknown	PK
`type`	Unknown	PK
`current_risk_score`	Unknown
`number_of_seat`	Unknown
`subscription_end_date`	Unknown
`subscription_level`	Unknown

training_campaign_group

Column	Type	Keys
`group_id`	Unknown	PKFK
`training_campaign_id`	Unknown	PKFK

training_campaign_content

Column	Type	Keys
`index`	Unknown	PK
`policy_id`	Unknown	FK
`store_purchase_id`	Unknown	FK
`training_campaign_id`	Unknown	FK
`content_type`	Unknown
`default_language`	Unknown
`description`	Unknown
`duration`	Unknown
`minimum_time`	Unknown
`name`	Unknown
`policy_url`	Unknown
`publish_date`	Unknown
`published`	Unknown
`publisher`	Unknown
`purchase_date`	Unknown
`retired`	Unknown
`retirement_date`	Unknown
`status`	Unknown
`type`	Unknown

training_campaign

Column	Type	Keys
`id`	Unknown	PK
`allow_multiple_enrollments`	Unknown
`auto_enroll`	Unknown
`completion_percentage`	Unknown
`duration_type`	Unknown
`end_date`	Unknown
`name`	Unknown
`relative_duration`	Unknown
`start_date`	Unknown
`status`	Unknown

specific_group_risk_score_history

Column	Type	Keys
`_fivetran_id`	String	PK
`groups_id`	Unknown	FK
`date`	Unknown
`risk_score`	Unknown

policy

Column	Type	Keys
`id`	Unknown	PK
`content_type`	Unknown
`default_language`	Unknown
`minimum_time`	Unknown
`name`	Unknown
`status`	Unknown

recipient_result_template

Column	Type	Keys
`id`	Unknown	PK
`index`	Unknown	PK
`recipient_result_id`	Unknown	FK
`difficulty`	Unknown
`name`	Unknown
`type`	Unknown

recipient_result

Column	Type	Keys
`id`	Unknown	PK
`pst_id`	Unknown	FK
`user_id`	Unknown	FK
`attachment_opened_at`	Unknown
`bounced_at`	Unknown
`browser`	Unknown
`browser_version`	Unknown
`clicked_at`	Unknown
`data_entered_at`	Unknown
`delivered_at`	Unknown
`ip`	Unknown
`ip_location`	Unknown
`macro_enabled_at`	Unknown
`opened_at`	Unknown
`os`	Unknown
`qr_code_scanned`	Unknown
`replied_at`	Unknown
`reported_at`	Unknown
`scheduled_at`	Unknown

user_groups

Column	Type	Keys
`group_id`	Unknown	PKFK
`users_id`	Unknown	PKFK

user_aliases

Column	Type	Keys
`_fivetran_id`	String	PK
`users_id`	Unknown	FK
`email_id`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`archived_at`	Unknown
`comment`	Unknown
`current_risk_score`	Unknown
`custom_date_1`	Unknown
`custom_date_2`	Unknown
`custom_field_1`	Unknown
`custom_field_2`	Unknown
`custom_field_3`	Unknown
`custom_field_4`	Unknown
`department`	Unknown
`division`	Unknown
`email`	Unknown
`employee_number`	Unknown
`employee_start_date`	Unknown
`extension`	Unknown
`first_name`	Unknown
`job_title`	Unknown
`joined_on`	Unknown
`languages`	Unknown
`last_name`	Unknown
`last_sign_in`	Unknown
`location`	Unknown
`manager_email`	Unknown
`manager_name`	Unknown
`mobile_phone_number`	Unknown
`organization`	Unknown
`phish_prone_percentage`	Unknown
`phone_number`	Unknown
`provisioning_guid`	Unknown
`provisioning_managed`	Unknown
`status`	Unknown