Legend
🔑 = primary key
➤ = foreign key relation
⇱ = external link
VENDOR_BILL_LINE ⇱
id 🔑
vendor_bill_id 🔑 ▶ VENDOR_BILL
account_id ▶ ACCOUNT
linked_resource_id ▶ PROPERTY
property_id ▶ PROPERTY
unit_id ▶ UNIT
amount
balance
memo
VENDOR_BILL ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
vendor_id ▶ VENDOR
batch
created_at
date
due_date
memo
reference
register
total_amount
total_balance
updated_at
LEASE_REVERSED_PAYMENT_LINE ⇱
id 🔑
lease_reversed_payment_id 🔑 ▶ LEASE_REVERSED_PAYMENT
account_id ▶ ACCOUNT
amount
balance
memo
LEASE_REVERSED_PAYMENT ⇱
id 🔑
lease_id ▶ LEASE
lease_payment_id ▶ LEASE_PAYMENT
batch
created_at
date
deposit_status
memo
processor_fee
reference
register
updated_at
REPORT_CASH_FLOW_STATEMENT ⇱
_fivetran_id 🔑
account_id ▶ ACCOUNT
parent_account_id ▶ ACCOUNT
abs_total_with_sub_accounts
group_by
root_account
total
total_with_sub_accounts
type
OWNER_EMAIL ⇱
index 🔑
owner_id 🔑 ▶ OWNER
address
type
OWNER_PHONE ⇱
index 🔑
owner_id 🔑 ▶ OWNER
number
type
OWNER ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
active
company
company_name
created_at
date_of_birth
federal_tax_info_address_city
federal_tax_info_address_country
federal_tax_info_address_for_1099_same_as_primary_address
federal_tax_info_address_latitude
federal_tax_info_address_longitude
federal_tax_info_address_street_1
federal_tax_info_address_street_2
federal_tax_info_address_zip
federal_tax_info_payer_id
federal_tax_info_payer_name
first_name
full_name
gender
job_title
last_name
management_end_date
management_start_date
middle_name
name
notes
picture_url
portal_info_allow_access
portal_info_login_email
portal_info_mobile_phone
primary_address_city
primary_address_country
primary_address_latitude
primary_address_longitude
primary_address_street_1
primary_address_street_2
primary_address_zip
properties
timezone
updated_at
ACCOUNT ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
active
cash_flow_activity
class
created_at
description
fully_qualified_name
name
system_account
type
updated_at
LEASE_CHARGE_LINE ⇱
id 🔑
lease_charge_id 🔑 ▶ LEASE_CHARGE
account_id ▶ ACCOUNT
amount
balance
memo
DEFAULT_ACCOUNT_FOR ⇱
index 🔑
account_id 🔑 ▶ ACCOUNT
account_action
LEASE_CHARGE ⇱
id 🔑
created_by_id ▶ USERS
lease_id ▶ LEASE
updated_by_id ▶ USERS
batch
created_at
date
last_late_fees_processed_date
memo
recurring_transaction
reference
register
total_amount
total_balance
updated_at
TASK_ASSIGNED_TO_USER ⇱
assigned_to_user_id 🔑 ▶ USERS
task_id 🔑 ▶ TASK
TASK ⇱
id 🔑
created_by_id ▶ USERS
linked_resource_id ▶ UNIT
property_id ▶ PROPERTY
requested_by_owner_id ▶ OWNER
requested_by_tenant_id ▶ TENANT
requested_by_user_id ▶ USERS
unit_id ▶ UNIT
updated_by_id ▶ USERS
vendor_bill_id ▶ VENDOR_BILL
vendor_id ▶ VENDOR
work_order_assigned_vendor_id ▶ VENDOR
work_order_vendor_bill_id ▶ VENDOR_BILL
completed_at
created_at
date_type
description
due_date
entry_notes
entry_permission
notify_assignees
notify_tenant
priority
reference
status
subject
type
updated_at
work_order_approved_by_owner
work_order_billed
work_order_instructions_to_vendor
UNIT_PICTURE ⇱
index 🔑
unit_id 🔑 ▶ UNIT
rank
url
UNIT_AMENITY ⇱
index 🔑
unit_id 🔑 ▶ UNIT
amenity
UNIT ⇱
id 🔑
created_by_id ▶ USERS
property_id ▶ PROPERTY
updated_by_id ▶ USERS
active
active_listing
address_same_as_property
batch
baths
beds
created_at
description
in_eviction
listing_contact
listing_date_available
listing_deposit
listing_lease_length
listing_listing
listing_rent
market_rent
name
size
updated_at
address_*
PROPERTY_OWNER ⇱
index 🔑
property_id 🔑 ▶ PROPERTY
owner_id ▶ OWNER
ownership_percentage
PROPERTY_PICTURE ⇱
file_id 🔑
property_id 🔑 ▶ PROPERTY
rank
url
PROPERTY_AMENITY ⇱
index 🔑
property_id 🔑 ▶ PROPERTY
amenity
PROPERTY ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
active
batch
class
created_at
description
name
num_active_units
type
updated_at
address_*
REPORT_RENT_ROLL_PICTURE ⇱
id 🔑
_fivetran_id 🔑 ▶ REPORT_RENT_ROLL
file
rank
url
REPORT_RENT_ROLL ⇱
_fivetran_id 🔑
lease_id ▶ LEASE
next_lease_id ▶ LEASE
property_id ▶ PROPERTY
unit_id ▶ UNIT
active
baths
beds
end_date
last_payment_amount
last_payment_date
last_returned_payment_amount
last_returned_payment_date
market_rent
occupied
renewal_stage
rent_per_size
rollover_to_at_will
size
start
term
total_balance_due
total_deposits_held
total_recurring_charges
total_recurring_credits
total_recurring_payments
total_recurring_rent
custom_*
USER_EMAIL ⇱
index 🔑
user_id 🔑 ▶ USERS
address
type
USER_PHONE ⇱
index 🔑
user_id 🔑 ▶ USERS
number
type
USERS ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
active
bank_accounts
company
company_name
created_at
date_of_birth
first_name
full_name
gender
invitation_last_sent_at
job_title
last_name
last_seen_at
login_email
middle_name
name
notes
owner
picture_url
primary_address_city
primary_address_country
primary_address_latitude
primary_address_longitude
primary_address_street_1
primary_address_street_2
primary_address_zip
properties
property_groups
role
status
timezone
updated_at
COMMUNICATION_CLICKED_AT ⇱
index 🔑
communication_id 🔑 ▶ COMMUNICATION
clicked_at
COMMUNICATION_OPENED_AT ⇱
index 🔑
communication_id 🔑 ▶ COMMUNICATION
opened_at
COMMUNICATION_BCC ⇱
communication_id 🔑 ▶ COMMUNICATION
linked_to_id 🔑 ▶ USERS
address
display_name
COMMUNICATION_CC ⇱
communication_id 🔑 ▶ COMMUNICATION
linked_to_id 🔑 ▶ USERS
address
display_name
COMMUNICATION_TO ⇱
communication_id 🔑 ▶ COMMUNICATION
linked_to_id 🔑 ▶ USERS
address
display_name
COMMUNICATION ⇱
id 🔑
announcement
body_html
body_preview
bounced_at
created_at
external_id
sent_at
status
subject
thread_id
type
updated_at
from_*
REPORT_BALANCE_SHEET_SUMMARY ⇱
_fivetran_id 🔑
account_id ▶ ACCOUNT
parent_account_id ▶ ACCOUNT
abs_total_with_sub_accounts
group_by
root_account
total
total_with_sub_accounts
type
REPORT_PROFIT_AND_LOSS_SUMMARY ⇱
_fivetran_id 🔑
account_id ▶ ACCOUNT
parent_account_id ▶ ACCOUNT
abs_total_with_sub_accounts
group_by
root_account
total
total_with_sub_accounts
type
LEASE_CREDIT_LINE ⇱
id 🔑
lease_credit_id 🔑 ▶ LEASE_CREDIT
account_id ▶ ACCOUNT
amount
balance
memo
LEASE_CREDIT ⇱
id 🔑
created_by_id ▶ USERS
lease_id ▶ LEASE
updated_by_id ▶ USERS
batch
created_at
date
memo
reference
register
total_amount
total_balance
updated_at
LEASE_TENANT_UNIT ⇱
lease_tenant_id 🔑 ▶ LEASE_TENANT
unit_id 🔑 ▶ UNIT
LEASE_TENANT ⇱
id 🔑
lease_id ▶ LEASE
property_id ▶ PROPERTY
tenant_id ▶ TENANT
move_in_at
move_out_at
move_out_notice_at
name
portal_enabled
status
NOTE_TAG ⇱
index 🔑
note_id 🔑 ▶ NOTE
tags
NOTE ⇱
id 🔑
linked_resource_id ▶ [TYPE]
linked_resource_type
body
created_at
created_by
title
PORTFOLIO_PROPERTY ⇱
portfolio_id 🔑 ▶ PORTFOLIO
property_id 🔑 ▶ PROPERTY
PORTFOLIO ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
created_at
name
updated_at
VENDOR_CREDIT_LINE ⇱
id 🔑
vendor_credit_id 🔑 ▶ VENDOR_CREDIT
account_id ▶ ACCOUNT
linked_resource_id ▶ PROPERTY
amount
balance
memo
VENDOR_CREDIT ⇱
id 🔑
vendor_id ▶ VENDOR
batch
date
due_date
memo
reference
total_amount
total_balance
TENANT_DEPENDANT ⇱
index 🔑
tenant_id 🔑 ▶ TENANT
date_of_birth
first_name
last_name
middle_name
relationship
TENANT_EMAIL ⇱
index 🔑
tenant_id 🔑 ▶ TENANT
address
type
TENANT_EMERGENCY_CONTACT ⇱
index 🔑
tenant_id 🔑 ▶ TENANT
name
phone
relationship
TENANT_PET ⇱
index 🔑
tenant_id 🔑 ▶ TENANT
age
breed
color
gender
is_service_animal
is_spayed_or_neutered
name
notes
type
weight
TENANT_PHONE ⇱
index 🔑
tenant_id 🔑 ▶ TENANT
number
type
TENANT_PROSPECT_INFO_INTEREST ⇱
property_id 🔑 ▶ PROPERTY
tenant_id 🔑 ▶ TENANT
unit_id 🔑 ▶ UNIT
TENANT_VEHICLE ⇱
index 🔑
tenant_id 🔑 ▶ TENANT
color
license_platae
make
model
notes
state
year
TENANT_UNIT ⇱
tenant_id 🔑 ▶ TENANT
unit_id 🔑 ▶ UNIT
TENANT ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
batch
company
company_name
created_at
date_of_birth
first_name
gender
job_title
last_name
middle_name
name
notes
picture_url
portal_info_allow_access
portal_info_invitation_last_sent_at
portal_info_last_seen_at
portal_info_login_email
portal_info_mobile_phone
portal_info_status
primary_address_city
primary_address_country
primary_address_latitude
primary_address_longitude
primary_address_street_1
primary_address_street_2
primary_address_zip
prospect_info_assigned_to_user
prospect_info_campaign_content
prospect_info_campaign_medium
prospect_info_campaign_name
prospect_info_campaign_source
prospect_info_campaign_term
prospect_info_credit_score
prospect_info_expected_move_in_date
prospect_info_lead_source
prospect_info_max_rent
prospect_info_min_bathrooms
prospect_info_min_bedrooms
prospect_info_monthly_income
prospect_info_next_task_date
prospect_info_status
timezone
type
updated_at
LEASE_PAYMENT_LINKED_CHARGE ⇱
index 🔑
lease_payment_id 🔑 ▶ LEASE_PAYMENT
account_id ▶ ACCOUNT
amount
linked_transaction
linked_transaction_line
LEASE_PAYMENT ⇱
id 🔑
created_by_id ▶ USERS
deposit_to_account_id ▶ TENANT
lease_id ▶ LEASE
received_from_tenant_id ▶ TENANT
updated_by_id ▶ USERS
amount_applied_to_charges
amount_applied_to_credits
amount_not_applied_to_charges
amount_received
auto_apply_payment_on_charges
auto_deposit
check_info
created_at
deposit_entry
deposit_status
is_files_shared_with_tenant
linked_credits
payment_method
reference
register
reversed_payment
updated_at
LEASE_PAYMENT_E_PAY ⇱
name 🔑
lease_payment_id 🔑 ▶ LEASE_PAYMENT
value
LEASE_UNIT ⇱
lease_id 🔑 ▶ LEASE
unit_id 🔑 ▶ UNIT
LEASE ⇱
id 🔑
created_by_id ▶ USERS
property_id ▶ PROPERTY
updated_by_id ▶ USERS
created_at
ends
evicton_pending
last_late_fees_processed_date
name
notes
proof_of_insurance_required
recurring_rent_frequency
reference
renewal_stage
rollover_to_at_will
start
status
term
total_balance_due
total_deposits_held
total_recurring_charges
total_recurring_credits
total_recurring_payments
total_recurring_rent
updated_at
EXPENSE_LINE ⇱
id 🔑
expense_id 🔑 ▶ EXPENSE
account_id ▶ ACCOUNT
linked_resource_id ▶ PROPERTY
property_id ▶ PROPERTY
amount
balance
EXPENSE ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
batch
check_info
created_at
date
memo
pay_from_account
pay_to_resource_id
pay_to_resource_type
payment_method
recurring_transaction
reference
total_amount
total_balance
updated_at
VENDOR_EMAIL ⇱
index 🔑
vendor_id 🔑 ▶ VENDOR
address
type
VENDOR_PHONE ⇱
index 🔑
vendor_id 🔑 ▶ VENDOR
number
type
VENDOR_PROPERTY ⇱
property_id 🔑 ▶ PROPERTY
vendor_id 🔑 ▶ VENDOR
VENDOR ⇱
id 🔑
created_by_id ▶ USERS
updated_by_id ▶ USERS
active
balance
company
company_name
created_at
date_of_birth
federal_tax_info_address_city
federal_tax_info_address_country
federal_tax_info_address_for_1099_same_as_primary_address
federal_tax_info_address_latitude
federal_tax_info_address_longitude
federal_tax_info_address_street_1
federal_tax_info_address_street_2
federal_tax_info_address_zip
federal_tax_info_payer_id
federal_tax_info_payer_name
first_name
full_name
gender
insurance_info_coverage
insurance_info_effective_date
insurance_info_expiration_date
insurance_info_policy_number
insurance_info_provider
job_title
last_name
management_end_date
management_start_date
middle_name
name
notes
picture_url
primary_address_city
primary_address_country
primary_address_latitude
primary_address_longitude
primary_address_street_1
primary_address_street_2
primary_address_zip
timezone
updated_at
PROPERTY_SETTING ⇱
name 🔑
property_id 🔑 ▶ PROPERTY
value
LEASE_RENEWAL_HISTORY ⇱
index 🔑
lease_id 🔑 ▶ LEASE
unit_id ▶ UNIT
new_rent
previous_rent
renewal_date
LEASE_SETTING ⇱
name 🔑
lease_id 🔑 ▶ LEASE
value
EXPENSE_REGISTER ⇱
index 🔑
expense_id 🔑 ▶ EXPENSE
cleared
plaid_transaction
Note: Multiple tables in our data model have associated notes that provide additional details and explanations. These notes are linked to each table using a unique identifier (linked_resource_id)