# Persona schema ERD

Table and field reference for the Fivetran Persona connector.

## Table & Field Reference

### case_account

| Column | Type | Keys |
| --- | --- | --- |
| case_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### case_inquiry

| Column | Type | Keys |
| --- | --- | --- |
| case_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### cases

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_at | Unknown |  |
| assignee_id | Unknown |  |
| created_at | Unknown |  |
| creator_id | Unknown |  |
| creator_type | Unknown |  |
| fields | Json |  |
| name | Unknown |  |
| redacted_at | Unknown |  |
| relationships_case_comments_data | Json |  |
| relationships_case_template_data_id | Unknown |  |
| relationships_case_template_data_type | Unknown |  |
| relationships_reports_data | Json |  |
| relationships_txns_data | Json |  |
| relationships_verifications_data | Json |  |
| resolution | Unknown |  |
| resolved_at | Unknown |  |
| resolver_id | Unknown |  |
| resolver_type | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| updater_id | Unknown |  |
| updater_type | Unknown |  |

### user_audit_log

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| get_params | Json |  |
| impersonator_email_address | Unknown |  |
| ip_address | Unknown |  |
| method | Unknown |  |
| path | Unknown |  |
| post_params | Json |  |
| relationships_user_data_id | Unknown |  |
| relationships_user_data_type | Unknown |  |
| type | Unknown |  |

### file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| document_id | Unknown | PK, FK |
| filename | Unknown |  |
| url | Unknown |  |

### document

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| inquiry_id | Unknown | FK |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_subdivision | Unknown |  |
| back_photo_byte_size | Unknown |  |
| back_photo_filename | Unknown |  |
| back_photo_url | Unknown |  |
| birthdate | Unknown |  |
| created_at | Unknown |  |
| designations | Json |  |
| document_files_data | Json |  |
| document_type | Unknown |  |
| endorsements | Unknown |  |
| front_photo_byte_size | Unknown |  |
| front_photo_filename | Unknown |  |
| front_photo_url | Unknown |  |
| id_class | Unknown |  |
| inquiry_template_id | Unknown |  |
| inquiry_template_version_id | Unknown |  |
| ip_address | Unknown |  |
| kind | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| processed_at | Unknown |  |
| processed_at_ts | Unknown |  |
| relationships_template_data | Unknown |  |
| restrictions | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| vehicle_class | Unknown |  |

### inquiry_relationship_verification

| Column | Type | Keys |
| --- | --- | --- |
| inquiry_id | Unknown | PK |
| id | Unknown | PK, FK |
| type | Unknown |  |

### inquiry_document

| Column | Type | Keys |
| --- | --- | --- |
| inquiry_id | Unknown | PK |
| id | Unknown | PK, FK |
| type | Unknown |  |

### list_item_data

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| list_id | Unknown | PK, FK |
| type | Unknown |  |

### list

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| archived_at | Unknown |  |
| created_at | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### inquiry_session

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| relationships_inquiry_data_id | Unknown | FK |
| browser_full_version | Unknown |  |
| browser_name | Unknown |  |
| country_code | Unknown |  |
| country_name | Unknown |  |
| created_at | Unknown |  |
| device_name | Unknown |  |
| device_type | Unknown |  |
| ip_address | Unknown |  |
| is_datacenter | Unknown |  |
| is_proxy | Unknown |  |
| is_tor | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| mobile_sdk_full_version | Unknown |  |
| mobile_sdk_name | Unknown |  |
| os_full_version | Unknown |  |
| os_name | Unknown |  |
| region_code | Unknown |  |
| region_name | Unknown |  |
| relationships_inquiry_data_type | Unknown |  |
| status | Unknown |  |
| threat_level | Unknown |  |
| type | Unknown |  |
| user_agent | Unknown |  |

### inquiry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| reference_id | Unknown | FK |
| account_type | Unknown |  |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_postal_code_abbr | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_subdivision | Unknown |  |
| address_subdivision_abbr | Unknown |  |
| autofill_cancels | Unknown |  |
| autofill_starts | Unknown |  |
| behavior_threat_level | Unknown |  |
| birthdate | Unknown |  |
| completed_at | Unknown |  |
| completion_time | Unknown |  |
| created_at | Unknown |  |
| creator | Unknown |  |
| decisioned_at | Unknown |  |
| devtools_open | Unknown |  |
| distraction_event | Unknown |  |
| email_address | Unknown |  |
| expired_at | Unknown |  |
| failed_at | Unknown |  |
| hesitation_baseline | Unknown |  |
| hesitation_count | Unknown |  |
| hesitation_percentage | Unknown |  |
| hesitation_time | Unknown |  |
| inquiry_template_id | Unknown |  |
| inquiry_template_type | Unknown |  |
| inquiry_template_version_id | Unknown |  |
| inquiry_template_version_type | Unknown |  |
| marked_for_review_at | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| next_step_name | Unknown |  |
| note | Unknown |  |
| phone_number | Unknown |  |
| previous_step_name | Unknown |  |
| redacted_at | Unknown |  |
| relationships_selfies_data | Json |  |
| request_spoof_attempt | Unknown |  |
| reviewer_comment | Unknown |  |
| reviewer_id | Unknown |  |
| reviewer_type | Unknown |  |
| shortcut_copies | Unknown |  |
| shortcut_pastes | Unknown |  |
| social_security_number | Unknown |  |
| started_at | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| template_data | Unknown |  |
| type | Unknown |  |
| user_agent_spoof_attempt | Unknown |  |
| custom_** |  |  |

### report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| relationships_account_data_id | Unknown | FK |
| relationships_inquiry_data_id | Unknown | FK |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_postal_code_abbr | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_subdivision | Unknown |  |
| address_subdivision_abbr | Unknown |  |
| birthdate | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| has_match | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| phone_number | Unknown |  |
| redacted_at | Unknown |  |
| relationships_account_data_type | Unknown |  |
| relationships_inquiry_data_type | Unknown |  |
| relationships_report_template_data_id | Unknown |  |
| relationships_report_template_data_type | Unknown |  |
| report_template_version_name | Unknown |  |
| social_security_number | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| type | Unknown |  |

### verification_photo_url

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| verification_id | Unknown | PK, FK |
| byte_size | Unknown |  |
| filename | Unknown |  |
| page | Unknown |  |
| url | Unknown |  |

### verification

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| accounts | Json |  |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_subdivision | Unknown |  |
| back_photo_url | Unknown |  |
| birth_date | Unknown |  |
| capture_method | Unknown |  |
| center_photo_face_coordinates | Json |  |
| center_photo_url | Unknown |  |
| checks | Json |  |
| completed_at | Unknown |  |
| completed_at_ts | Unknown |  |
| confirmation_code | Unknown |  |
| country_code | Unknown |  |
| created_at | Unknown |  |
| created_at_ts | Unknown |  |
| document_similarity_score | Unknown |  |
| email_address | Unknown |  |
| endorsement | Unknown |  |
| entity_confidence_reason | Json |  |
| entity_confidence_score | Unknown |  |
| expiration_date | Unknown |  |
| from_reusable_persona | Unknown |  |
| front_photo_url | Unknown |  |
| height | Unknown |  |
| id_class | Unknown |  |
| identification_number | Unknown |  |
| inquiry_id | Unknown |  |
| inquiry_template_id | Unknown |  |
| inquiry_template_type | Unknown |  |
| inquiry_template_version_id | Unknown |  |
| inquiry_template_version_type | Unknown |  |
| inquiry_type | Unknown |  |
| issue_date | Unknown |  |
| issuing_authority | Unknown |  |
| left_photo_url | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| name_middle | Unknown |  |
| normalized_address_city | Unknown |  |
| normalized_address_postal_code | Unknown |  |
| normalized_address_street_1 | Unknown |  |
| normalized_address_street_2 | Unknown |  |
| normalized_address_subdivision | Unknown |  |
| phone_number | Unknown |  |
| redacted_at | Unknown |  |
| restriction | Unknown |  |
| right_photo_url | Unknown |  |
| selfie_photo_url | Unknown |  |
| selfie_similarity_score_left | Unknown |  |
| selfie_similarity_score_right | Unknown |  |
| sex | Unknown |  |
| status | Unknown |  |
| submitted_at | Unknown |  |
| submitted_at_ts | Unknown |  |
| tags | Json |  |
| type | Unknown |  |
| vehicle_class | Unknown |  |
| verification_template_id | Unknown |  |
| verification_template_type | Unknown |  |
| verification_template_version_id | Unknown |  |
| verification_template_version_type | Unknown |  |
| video_url | Unknown |  |

### transaction_relationship_object

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| transaction_id | Unknown | PK, FK |
| type | Unknown |  |

### transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| reviewer_id | Unknown | FK |
| back_photo_byte_size | Unknown |  |
| back_photo_filename | Unknown |  |
| back_photo_mime_type | Unknown |  |
| back_photo_type | Unknown |  |
| back_photo_url | Unknown |  |
| country | Unknown |  |
| created_at | Unknown |  |
| front_photo_byte_size | Unknown |  |
| front_photo_filename | Unknown |  |
| front_photo_mime_type | Unknown |  |
| front_photo_type | Unknown |  |
| front_photo_url | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| reference_id | Unknown |  |
| reviewer_type | Unknown |  |
| selected_id_class | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| transaction_label_data | Json |  |
| transaction_type | Unknown |  |
| transaction_type_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### identification_number

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| identification_class | Unknown |  |
| identification_number | Unknown |  |
| issuing_country | Unknown |  |
| type | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_status | Unknown |  |
| address_city | Unknown |  |
| address_country_code | Unknown |  |
| address_postal_code | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_subdivision | Unknown |  |
| birthdate | Unknown |  |
| created_at | Unknown |  |
| email_address | Unknown |  |
| identification_number_type | Unknown |  |
| name_first | Unknown |  |
| name_last | Unknown |  |
| name_middle | Unknown |  |
| phone_number | Unknown |  |
| redacted_at | Unknown |  |
| reference_id | Unknown |  |
| selfie_phototype | Unknown |  |
| selfie_photovalue | Unknown |  |
| social_security_number | Unknown |  |
| tags | Json |  |
| type | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- case_account(id) → account(id)
- case_account(case_id) → cases(id)
- case_inquiry(id) → inquiry(id)
- case_inquiry(case_id) → cases(id)
- file(document_id) → document(id)
- document(inquiry_id) → inquiry(id)
- inquiry_relationship_verification(id) → verification(id)
- inquiry_document(id) → inquiry(id)
- list_item_data(list_id) → list(id)
- inquiry_session(relationships_inquiry_data_id) → inquiry(id)
- inquiry(reference_id) → account(reference_id)
- inquiry(account_id) → account(id)
- report(relationships_inquiry_data_id) → inquiry(id)
- report(relationships_account_data_id) → account(id)
- verification_photo_url(verification_id) → verification(id)
- transaction_relationship_object(transaction_id) → transaction(id)
- transaction(reviewer_id) → inquiry(reviewer_id)
- identification_number(account_id) → account(id)