# DoorLoop schema ERD

Table and field reference for the Fivetran DoorLoop connector.

## Table & Field Reference

### vendor_bill_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_bill_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| linked_resource_id | Unknown | FK |
| property_id | Unknown | FK |
| unit_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| memo | Unknown |  |

### vendor_bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| vendor_id | Unknown | FK |
| batch | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| memo | Unknown |  |
| reference | Unknown |  |
| register | Json |  |
| total_amount | Unknown |  |
| total_balance | Unknown |  |
| updated_at | Unknown |  |

### lease_reversed_payment_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_reversed_payment_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| memo | Unknown |  |

### lease_reversed_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | FK |
| lease_payment_id | Unknown | FK |
| batch | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| deposit_status | Unknown |  |
| memo | Unknown |  |
| processor_fee | Unknown |  |
| reference | Unknown |  |
| register | Json |  |
| updated_at | Unknown |  |

### report_cash_flow_statement

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| account_id | Unknown | FK |
| parent_account_id | Unknown | FK |
| abs_total_with_sub_accounts | Unknown |  |
| group_by | Unknown |  |
| root_account | Unknown |  |
| total | Unknown |  |
| total_with_sub_accounts | Unknown |  |
| type | Unknown |  |

### owner_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| owner_id | Unknown | PK, FK |
| address | Unknown |  |
| type | Unknown |  |

### owner_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| owner_id | Unknown | PK, FK |
| number | Unknown |  |
| type | Unknown |  |

### owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| company | Unknown |  |
| company_name | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| federal_tax_info_address_city | Unknown |  |
| federal_tax_info_address_country | Unknown |  |
| federal_tax_info_address_for_1099_same_as_primary_address | Unknown |  |
| federal_tax_info_address_latitude | Unknown |  |
| federal_tax_info_address_longitude | Unknown |  |
| federal_tax_info_address_street_1 | Unknown |  |
| federal_tax_info_address_street_2 | Unknown |  |
| federal_tax_info_address_zip | Unknown |  |
| federal_tax_info_payer_id | Unknown |  |
| federal_tax_info_payer_name | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| management_end_date | Unknown |  |
| management_start_date | Unknown |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| picture_url | Unknown |  |
| portal_info_allow_access | Unknown |  |
| portal_info_login_email | Unknown |  |
| portal_info_mobile_phone | Unknown |  |
| primary_address_city | Unknown |  |
| primary_address_country | Unknown |  |
| primary_address_latitude | Unknown |  |
| primary_address_longitude | Unknown |  |
| primary_address_street_1 | Unknown |  |
| primary_address_street_2 | Unknown |  |
| primary_address_zip | Unknown |  |
| properties | Json |  |
| timezone | Unknown |  |
| updated_at | Unknown |  |

### default_account_for

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| account_id | Unknown | PK, FK |
| account_action | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| cash_flow_activity | Unknown |  |
| class | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| fully_qualified_name | Unknown |  |
| name | Unknown |  |
| system_account | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### lease_charge_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_charge_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| memo | Unknown |  |

### lease_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| lease_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| batch | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| last_late_fees_processed_date | Unknown |  |
| memo | Unknown |  |
| recurring_transaction | Unknown |  |
| reference | Unknown |  |
| register | Json |  |
| total_amount | Unknown |  |
| total_balance | Unknown |  |
| updated_at | Unknown |  |

### task_assigned_to_user

| Column | Type | Keys |
| --- | --- | --- |
| assigned_to_user_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |

### task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| linked_resource_id | Unknown | FK |
| property_id | Unknown | FK |
| requested_by_owner_id | Unknown | FK |
| requested_by_tenant_id | Unknown | FK |
| requested_by_user_id | Unknown | FK |
| unit_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| vendor_bill_id | Unknown | FK |
| vendor_id | Unknown | FK |
| work_order_assigned_vendor_id | Unknown | FK |
| work_order_vendor_bill_id | Unknown | FK |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| date_type | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| entry_notes | Unknown |  |
| entry_permission | Unknown |  |
| notify_assignees | Unknown |  |
| notify_tenant | Unknown |  |
| priority | Unknown |  |
| reference | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |
| work_order_approved_by_owner | Unknown |  |
| work_order_billed | Unknown |  |
| work_order_instructions_to_vendor | Unknown |  |
| work_order_vendor_id | Unknown |  |

### unit_picture

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| unit_id | Unknown | PK, FK |
| rank | Unknown |  |
| url | Unknown |  |

### unit_amenity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| unit_id | Unknown | PK, FK |
| amenity | Unknown |  |

### unit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| property_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| active_listing | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_latitude | Unknown |  |
| address_longitude | Unknown |  |
| address_same_as_property | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_zip | Unknown |  |
| batch | Unknown |  |
| baths | Unknown |  |
| beds | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| in_eviction | Unknown |  |
| listing_contact | Unknown |  |
| listing_date_available | Unknown |  |
| listing_deposit | Unknown |  |
| listing_lease_length | Unknown |  |
| listing_listing | Unknown |  |
| listing_rent | Unknown |  |
| market_rent | Unknown |  |
| name | Unknown |  |
| size | Unknown |  |
| updated_at | Unknown |  |

### property_owner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| property_id | Unknown | PK, FK |
| user_id | Unknown | FK |
| ownership_percentage | Unknown |  |

### property_picture

| Column | Type | Keys |
| --- | --- | --- |
| file_id | Unknown | PK |
| property_id | Unknown | PK, FK |
| rank | Unknown |  |
| url | Unknown |  |

### property_amenity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| property_id | Unknown | PK, FK |
| amenity | Unknown |  |

### property_setting

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| property_id | Unknown | PK, FK |
| value | Unknown |  |

### property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| address_city | Unknown |  |
| address_country | Unknown |  |
| address_latitude | Unknown |  |
| address_longitude | Unknown |  |
| address_street_1 | Unknown |  |
| address_street_2 | Unknown |  |
| address_zip | Unknown |  |
| batch | Unknown |  |
| class | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |
| num_active_units | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### report_rent_roll_picture

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| _fivetran_id | Unknown | PK, FK |
| file | Unknown |  |
| rank | Unknown |  |
| url | Unknown |  |

### report_rent_roll

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| lease_id | Unknown | FK |
| next_lease_id | Unknown | FK |
| property_id | Unknown | FK |
| unit_id | Unknown | FK |
| active | Unknown |  |
| baths | Unknown |  |
| beds | Unknown |  |
| end_date | Unknown |  |
| last_payment_amount | Unknown |  |
| last_payment_date | Unknown |  |
| last_returned_payment_amount | Unknown |  |
| last_returned_payment_date | Unknown |  |
| market_rent | Unknown |  |
| occupied | Unknown |  |
| renewal_stage | Unknown |  |
| rent_per_size | Unknown |  |
| rollover_to_at_will | Unknown |  |
| size | Unknown |  |
| start | Unknown |  |
| term | Unknown |  |
| total_balance_due | Unknown |  |
| total_deposits_held | Unknown |  |
| total_recurring_charges | Unknown |  |
| total_recurring_credits | Unknown |  |
| total_recurring_payments | Unknown |  |
| total_recurring_rent | Unknown |  |
| custom_** |  |  |

### user_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| address | Unknown |  |
| type | Unknown |  |

### user_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| number | Unknown |  |
| type | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| bank_accounts | Json |  |
| company | Unknown |  |
| company_name | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| invitation_last_sent_at | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| last_seen_at | Unknown |  |
| login_email | Unknown |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| owner | Unknown |  |
| picture_url | Unknown |  |
| primary_address_city | Unknown |  |
| primary_address_country | Unknown |  |
| primary_address_latitude | Unknown |  |
| primary_address_longitude | Unknown |  |
| primary_address_street_1 | Unknown |  |
| primary_address_street_2 | Unknown |  |
| primary_address_zip | Unknown |  |
| properties | Json |  |
| property_groups | Json |  |
| role | Unknown |  |
| status | Unknown |  |
| timezone | Unknown |  |
| updated_at | Unknown |  |

### communication_clicked_at

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| communication_id | Unknown | PK, FK |
| clicked_at | Unknown |  |

### communication_opened_at

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| communication_id | Unknown | PK, FK |
| opened_at | Unknown |  |

### communication_bcc

| Column | Type | Keys |
| --- | --- | --- |
| communication_id | Unknown | PK, FK |
| linked_to_id | Unknown | PK, FK |
| address | Unknown |  |
| display_name | Unknown |  |

### communication_cc

| Column | Type | Keys |
| --- | --- | --- |
| communication_id | Unknown | PK, FK |
| linked_to_id | Unknown | PK, FK |
| address | Unknown |  |
| display_name | Unknown |  |

### communication_to

| Column | Type | Keys |
| --- | --- | --- |
| communication_id | Unknown | PK, FK |
| linked_to_id | Unknown | PK, FK |
| address | Unknown |  |
| display_name | Unknown |  |

### communication

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| announcement | Unknown |  |
| body_html | Unknown |  |
| body_preview | Unknown |  |
| bounced_at | Unknown |  |
| created_at | Unknown |  |
| external_id | Unknown |  |
| from_address | Unknown |  |
| from_display_name | Unknown |  |
| from_linked_to_type | Unknown |  |
| sent_at | Unknown |  |
| status | Unknown |  |
| subject | Unknown |  |
| thread_id | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### report_balance_sheet_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| account_id | Unknown | FK |
| parent_account_id | Unknown | FK |
| abs_total_with_sub_accounts | Unknown |  |
| group_by | Unknown |  |
| root_account | Unknown |  |
| total | Unknown |  |
| total_with_sub_accounts | Unknown |  |
| type | Unknown |  |

### report_profit_and_loss_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | Unknown | PK |
| account_id | Unknown | FK |
| parent_account_id | Unknown | FK |
| abs_total_with_sub_accounts | Unknown |  |
| group_by | Unknown |  |
| root_account | Unknown |  |
| total | Unknown |  |
| total_with_sub_accounts | Unknown |  |
| type | Unknown |  |

### lease_credit_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_credit_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| memo | Unknown |  |

### lease_credit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| lease_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| batch | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| memo | Unknown |  |
| reference | Unknown |  |
| register | Json |  |
| total_amount | Unknown |  |
| total_balance | Unknown |  |
| updated_at | Unknown |  |

### lease_tenant_unit

| Column | Type | Keys |
| --- | --- | --- |
| lease_tenant_id | Unknown | PK, FK |
| unit_id | Unknown | PK, FK |

### lease_tenant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | FK |
| property_id | Unknown | FK |
| tenant_id | Unknown | FK |
| move_in_at | Unknown |  |
| move_out_at | Unknown |  |
| move_out_notice_at | Unknown |  |
| name | Unknown |  |
| portal_enabled | Unknown |  |
| status | Unknown |  |

### note_tag

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| note_id | Unknown | PK, FK |
| tags | Unknown |  |

### note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| linked_resource_id | Unknown | FK |
| body | Unknown |  |
| created_at | Unknown |  |
| created_by | Unknown |  |
| linked_resource_type | Unknown |  |
| title | Unknown |  |

### portfolio_property

| Column | Type | Keys |
| --- | --- | --- |
| portfolio_id | Unknown | PK, FK |
| property_id | Unknown | PK, FK |

### portfolio

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| created_at | Unknown |  |
| name | Unknown |  |
| updated_at | Unknown |  |

### vendor_credit_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_credit_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| linked_resource_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |
| memo | Unknown |  |

### vendor_credit

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| vendor_id | Unknown | FK |
| batch | Unknown |  |
| date | Unknown |  |
| due_date | Unknown |  |
| memo | Unknown |  |
| reference | Unknown |  |
| total_amount | Unknown |  |
| total_balance | Unknown |  |

### tenant_dependant

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tenant_id | Unknown | PK, FK |
| date_of_birth | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| relationship | Unknown |  |

### tenant_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tenant_id | Unknown | PK, FK |
| address | Unknown |  |
| type | Unknown |  |

### tenant_emergency_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tenant_id | Unknown | PK, FK |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| relationship | Unknown |  |

### tenant_pet

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tenant_id | Unknown | PK, FK |
| age | Unknown |  |
| breed | Unknown |  |
| color | Unknown |  |
| gender | Unknown |  |
| is_service_animal | Unknown |  |
| is_spayed_or_neutered | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| type | Unknown |  |
| weight | Unknown |  |

### tenant_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tenant_id | Unknown | PK, FK |
| number | Unknown |  |
| type | Unknown |  |

### tenant_prospect_info_interest

| Column | Type | Keys |
| --- | --- | --- |
| property_id | Unknown | PK, FK |
| tenant_id | Unknown | PK, FK |
| unit_id | Unknown | PK, FK |

### tenant_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| tenant_id | Unknown | PK, FK |
| color | Unknown |  |
| license_platae | Unknown |  |
| make | Unknown |  |
| model | Unknown |  |
| notes | Unknown |  |
| state | Unknown |  |
| year | Unknown |  |

### tenant_unit

| Column | Type | Keys |
| --- | --- | --- |
| tenant_id | Unknown | PK, FK |
| unit_id | Unknown | PK, FK |

### tenant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| batch | Unknown |  |
| company | Unknown |  |
| company_name | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| picture_url | Unknown |  |
| portal_info_allow_access | Unknown |  |
| portal_info_invitation_last_sent_at | Unknown |  |
| portal_info_last_seen_at | Unknown |  |
| portal_info_login_email | Unknown |  |
| portal_info_mobile_phone | Unknown |  |
| portal_info_status | Unknown |  |
| primary_address_city | Unknown |  |
| primary_address_country | Unknown |  |
| primary_address_latitude | Unknown |  |
| primary_address_longitude | Unknown |  |
| primary_address_street_1 | Unknown |  |
| primary_address_street_2 | Unknown |  |
| primary_address_zip | Unknown |  |
| prospect_info_assigned_to_user | Unknown |  |
| prospect_info_campaign_content | Unknown |  |
| prospect_info_campaign_medium | Unknown |  |
| prospect_info_campaign_name | Unknown |  |
| prospect_info_campaign_source | Unknown |  |
| prospect_info_campaign_term | Unknown |  |
| prospect_info_credit_score | Unknown |  |
| prospect_info_expected_move_in_date | Unknown |  |
| prospect_info_lead_source | Unknown |  |
| prospect_info_max_rent | Unknown |  |
| prospect_info_min_bathrooms | Unknown |  |
| prospect_info_min_bedrooms | Unknown |  |
| prospect_info_monthly_income | Unknown |  |
| prospect_info_next_task_date | Unknown |  |
| prospect_info_status | Unknown |  |
| timezone | Unknown |  |
| type | Unknown |  |
| updated_at | Unknown |  |

### lease_payment_linked_charge

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_payment_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| amount | Unknown |  |
| linked_transaction | Unknown |  |
| linked_transaction_line | Unknown |  |

### lease_payment_e_pay

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| lease_payment_id | Unknown | PK, FK |
| value | Unknown |  |

### lease_payment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| deposit_to_account_id | Unknown | FK |
| lease_id | Unknown | FK |
| received_from_tenant_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| amount_applied_to_charges | Unknown |  |
| amount_applied_to_credits | Unknown |  |
| amount_not_applied_to_charges | Unknown |  |
| amount_received | Unknown |  |
| auto_apply_payment_on_charges | Unknown |  |
| auto_deposit | Unknown |  |
| check_info | Json |  |
| created_at | Unknown |  |
| deposit_entry | Unknown |  |
| deposit_status | Unknown |  |
| is_files_shared_with_tenant | Unknown |  |
| linked_credits | Json |  |
| payment_method | Unknown |  |
| reference | Unknown |  |
| register | Json |  |
| reversed_payment | Unknown |  |
| updated_at | Unknown |  |

### lease_unit

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK, FK |
| unit_id | Unknown | PK, FK |

### lease_renewal_history

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_id | Unknown | PK, FK |
| unit_id | Unknown | FK |
| new_rent | Unknown |  |
| previous_rent | Unknown |  |
| renewal_date | Unknown |  |

### lease_setting

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| lease_id | Unknown | PK, FK |
| value | Unknown |  |

### lease

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| property_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| created_at | Unknown |  |
| ends | Unknown |  |
| evicton_pending | Unknown |  |
| last_late_fees_processed_date | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| proof_of_insurance_required | Unknown |  |
| recurring_rent_frequency | Unknown |  |
| reference | Unknown |  |
| renewal_stage | Unknown |  |
| rollover_to_at_will | Unknown |  |
| start | Unknown |  |
| status | Unknown |  |
| term | Unknown |  |
| total_balance_due | Unknown |  |
| total_deposits_held | Unknown |  |
| total_recurring_charges | Unknown |  |
| total_recurring_credits | Unknown |  |
| total_recurring_payments | Unknown |  |
| total_recurring_rent | Unknown |  |
| updated_at | Unknown |  |

### expense_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| expense_id | Unknown | PK, FK |
| account_id | Unknown | FK |
| linked_resource_id | Unknown | FK |
| property_id | Unknown | FK |
| amount | Unknown |  |
| balance | Unknown |  |

### expense_register

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| expense_id | Unknown | PK, FK |
| cleared | Unknown |  |
| plaid_transaction | Unknown |  |

### expense

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| batch | Unknown |  |
| check_info | Json |  |
| created_at | Unknown |  |
| date | Unknown |  |
| memo | Unknown |  |
| pay_from_account | Unknown |  |
| pay_to_resource_id | Unknown |  |
| pay_to_resource_type | Unknown |  |
| payment_method | Unknown |  |
| recurring_transaction | Unknown |  |
| reference | Unknown |  |
| register | Json |  |
| total_amount | Unknown |  |
| total_balance | Unknown |  |
| updated_at | Unknown |  |

### vendor_email

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| address | Unknown |  |
| type | Unknown |  |

### vendor_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| vendor_id | Unknown | PK, FK |
| number | Unknown |  |
| type | Unknown |  |

### vendor_property

| Column | Type | Keys |
| --- | --- | --- |
| property_id | Unknown | PK, FK |
| vendor_id | Unknown | PK, FK |

### vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_id | Unknown | FK |
| updated_by_id | Unknown | FK |
| active | Unknown |  |
| balance | Unknown |  |
| company | Unknown |  |
| company_name | Unknown |  |
| created_at | Unknown |  |
| date_of_birth | Unknown |  |
| federal_tax_info_address_city | Unknown |  |
| federal_tax_info_address_country | Unknown |  |
| federal_tax_info_address_for_1099_same_as_primary_address | Unknown |  |
| federal_tax_info_address_latitude | Unknown |  |
| federal_tax_info_address_longitude | Unknown |  |
| federal_tax_info_address_street_1 | Unknown |  |
| federal_tax_info_address_street_2 | Unknown |  |
| federal_tax_info_address_zip | Unknown |  |
| federal_tax_info_payer_id | Unknown |  |
| federal_tax_info_payer_name | Unknown |  |
| first_name | Unknown |  |
| full_name | Unknown |  |
| gender | Unknown |  |
| insurance_info_coverage | Unknown |  |
| insurance_info_effective_date | Unknown |  |
| insurance_info_expiration_date | Unknown |  |
| insurance_info_policy_number | Unknown |  |
| insurance_info_provider | Unknown |  |
| job_title | Unknown |  |
| last_name | Unknown |  |
| management_end_date | Unknown |  |
| management_start_date | Unknown |  |
| middle_name | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| picture_url | Unknown |  |
| primary_address_city | Unknown |  |
| primary_address_country | Unknown |  |
| primary_address_latitude | Unknown |  |
| primary_address_longitude | Unknown |  |
| primary_address_street_1 | Unknown |  |
| primary_address_street_2 | Unknown |  |
| primary_address_zip | Unknown |  |
| timezone | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- vendor_bill_line(account_id) → account(id)
- vendor_bill_line(property_id) → property(id)
- vendor_bill_line(unit_id) → unit(id)
- vendor_bill_line(linked_resource_id) → property(id)
- vendor_bill_line(vendor_bill_id) → vendor_bill(id)
- vendor_bill(vendor_id) → vendor(id)
- vendor_bill(updated_by_id) → users(id)
- vendor_bill(created_by_id) → users(id)
- lease_reversed_payment_line(account_id) → account(id)
- lease_reversed_payment_line(lease_reversed_payment_id) → lease_reversed_payment(id)
- lease_reversed_payment(lease_id) → lease(id)
- lease_reversed_payment(lease_payment_id) → lease_payment(id)
- report_cash_flow_statement(account_id) → account(id)
- report_cash_flow_statement(parent_account_id) → account(id)
- owner_email(owner_id) → owner(id)
- owner_phone(owner_id) → owner(id)
- owner(updated_by_id) → users(id)
- owner(created_by_id) → users(id)
- default_account_for(account_id) → account(id)
- account(updated_by_id) → users(id)
- account(created_by_id) → users(id)
- lease_charge_line(account_id) → account(id)
- lease_charge_line(lease_charge_id) → lease_charge(id)
- lease_charge(lease_id) → lease(id)
- lease_charge(updated_by_id) → users(id)
- lease_charge(created_by_id) → users(id)
- task_assigned_to_user(assigned_to_user_id) → users(id)
- task_assigned_to_user(task_id) → task(id)
- task(requested_by_owner_id) → owner(id)
- task(linked_resource_id) → unit(id)
- task(requested_by_tenant_id) → tenant(id)
- task(property_id) → property(id)
- task(updated_by_id) → users(id)
- task(created_by_id) → users(id)
- task(unit_id) → unit(id)
- task(requested_by_user_id) → users(id)
- task(work_order_assigned_vendor_id) → vendor(id)
- task(work_order_vendor_bill_id) → vendor_bill(id)
- task(vendor_id) → vendor(id)
- task(vendor_bill_id) → vendor_bill(id)
- unit_picture(unit_id) → unit(id)
- unit_amenity(unit_id) → unit(id)
- unit(property_id) → property(id)
- unit(updated_by_id) → users(id)
- unit(created_by_id) → users(id)
- property_owner(user_id) → users(id)
- property_owner(property_id) → property(id)
- property_picture(property_id) → property(id)
- property_amenity(property_id) → property(id)
- property_setting(property_id) → property(id)
- property(updated_by_id) → users(id)
- property(created_by_id) → users(id)
- report_rent_roll_picture(_fivetran_id) → report_rent_roll(_fivetran_id)
- report_rent_roll(lease_id) → lease(id)
- report_rent_roll(property_id) → property(id)
- report_rent_roll(unit_id) → unit(id)
- report_rent_roll(next_lease_id) → lease(id)
- user_email(user_id) → users(id)
- user_phone(user_id) → users(id)
- users(updated_by_id) → users(id)
- users(created_by_id) → users(id)
- communication_clicked_at(communication_id) → communication(id)
- communication_opened_at(communication_id) → communication(id)
- communication_bcc(linked_to_id) → users(id)
- communication_bcc(communication_id) → communication(id)
- communication_cc(linked_to_id) → users(id)
- communication_cc(communication_id) → communication(id)
- communication_to(linked_to_id) → users(id)
- communication_to(communication_id) → communication(id)
- report_balance_sheet_summary(account_id) → account(id)
- report_balance_sheet_summary(parent_account_id) → account(id)
- report_profit_and_loss_summary(account_id) → account(id)
- report_profit_and_loss_summary(parent_account_id) → account(id)
- lease_credit_line(account_id) → account(id)
- lease_credit_line(lease_credit_id) → lease_credit(id)
- lease_credit(lease_id) → lease(id)
- lease_credit(updated_by_id) → users(id)
- lease_credit(created_by_id) → users(id)
- lease_tenant_unit(unit_id) → unit(id)
- lease_tenant_unit(lease_tenant_id) → lease_tenant(id)
- lease_tenant(lease_id) → lease(id)
- lease_tenant(property_id) → property(id)
- lease_tenant(tenant_id) → tenant(id)
- note_tag(note_id) → note(id)
- note(linked_resource_id) → task(id)
- portfolio_property(property_id) → property(id)
- portfolio_property(portfolio_id) → portfolio(id)
- portfolio(created_by_id) → users(id)
- portfolio(updated_by_id) → users(id)
- vendor_credit_line(account_id) → account(id)
- vendor_credit_line(linked_resource_id) → property(id)
- vendor_credit_line(vendor_credit_id) → vendor_credit(id)
- vendor_credit(vendor_id) → vendor(id)
- tenant_dependant(tenant_id) → tenant(id)
- tenant_email(tenant_id) → tenant(id)
- tenant_emergency_contact(tenant_id) → tenant(id)
- tenant_pet(tenant_id) → tenant(id)
- tenant_phone(tenant_id) → tenant(id)
- tenant_prospect_info_interest(property_id) → property(id)
- tenant_prospect_info_interest(unit_id) → unit(id)
- tenant_prospect_info_interest(tenant_id) → tenant(id)
- tenant_vehicle(tenant_id) → tenant(id)
- tenant_unit(unit_id) → unit(id)
- tenant_unit(tenant_id) → tenant(id)
- tenant(updated_by_id) → users(id)
- tenant(created_by_id) → users(id)
- lease_payment_linked_charge(account_id) → account(id)
- lease_payment_linked_charge(lease_payment_id) → lease_payment(id)
- lease_payment_e_pay(lease_payment_id) → lease_payment(id)
- lease_payment(lease_id) → lease(id)
- lease_payment(received_from_tenant_id) → tenant(id)
- lease_payment(updated_by_id) → users(id)
- lease_payment(created_by_id) → users(id)
- lease_payment(deposit_to_account_id) → tenant(id)
- lease_unit(unit_id) → unit(id)
- lease_unit(lease_id) → lease(id)
- lease_renewal_history(unit_id) → unit(id)
- lease_renewal_history(lease_id) → lease(id)
- lease_setting(lease_id) → lease(id)
- lease(property_id) → property(id)
- lease(updated_by_id) → users(id)
- lease(created_by_id) → users(id)
- expense_line(account_id) → account(id)
- expense_line(property_id) → property(id)
- expense_line(linked_resource_id) → property(id)
- expense_line(expense_id) → expense(id)
- expense_register(expense_id) → expense(id)
- expense(updated_by_id) → users(id)
- expense(created_by_id) → users(id)
- vendor_email(vendor_id) → vendor(id)
- vendor_phone(vendor_id) → vendor(id)
- vendor_property(property_id) → property(id)
- vendor_property(vendor_id) → vendor(id)
- vendor(updated_by_id) → users(id)
- vendor(created_by_id) → users(id)