Persona
Explore the interactive ERD
Table & Field Reference
case_account
| Column | Type | Keys |
|---|---|---|
case_id | Unknown | PKFK |
id | Unknown | PKFK |
case_inquiry
| Column | Type | Keys |
|---|---|---|
case_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
type | Unknown |
inquiry_document
| Column | Type | Keys |
|---|---|---|
inquiry_id | Unknown | PK |
id | Unknown | PKFK |
type | Unknown |
list_item_data
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
list_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 |