# Buildium schema ERD

Table and field reference for the Fivetran Buildium connector.

## Table & Field Reference

### listing_property_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| listing_id | Unknown | PK, FK |
| feature | Unknown |  |

### listing_include_in_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| listing_id | Unknown | PK, FK |
| include_in_rent | Unknown |  |

### listing_property_file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| listing_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### listing_unit_feature

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| listing_id | Unknown | PK, FK |
| feature | Unknown |  |

### listing_unit_file

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| listing_id | Unknown | PK, FK |
| name | Unknown |  |
| type | Unknown |  |
| url | Unknown |  |

### listing

| Column | Type | Keys |
| --- | --- | --- |
| listing_id | Unknown | PK |
| property_id | Unknown | FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| available_date | Unknown |  |
| city | Unknown |  |
| contact_email | Unknown |  |
| contact_id | Unknown |  |
| contact_name | Unknown |  |
| contact_phone_number | Unknown |  |
| contact_website | Unknown |  |
| country | Unknown |  |
| deposit | Unknown |  |
| description | Unknown |  |
| lease_terms | Unknown |  |
| listing_date | Unknown |  |
| market_rent | Unknown |  |
| postal_code | Unknown |  |
| property_name | Unknown |  |
| property_number_units | Unknown |  |
| property_structure_description | Unknown |  |
| property_year_built | Unknown |  |
| rent | Unknown |  |
| state | Unknown |  |
| unit_address_line_1 | Unknown |  |
| unit_address_line_2 | Unknown |  |
| unit_address_line_3 | Unknown |  |
| unit_bathrooms | Unknown |  |
| unit_bedrooms | Unknown |  |
| unit_city | Unknown |  |
| unit_country | Unknown |  |
| unit_id | Unknown |  |
| unit_number | Unknown |  |
| unit_postal_code | Unknown |  |
| unit_size | Unknown |  |
| unit_state | Unknown |  |

### lease_renewal_tenant

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK, FK |
| lease_renewal_id | Unknown | PK, FK |
| tenant_id | Unknown | PK, FK |

### lease_renewal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | PK, FK |
| rent_id | Unknown | FK |
| lease_from_date | Unknown |  |
| lease_status | Unknown |  |
| lease_to_date | Unknown |  |
| lease_type | Unknown |  |
| rent | Unknown |  |

### lease_rent_schedule_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | PK, FK |
| lease_rent_schedule_id | Unknown | PK, FK |
| gl_account_id | Unknown | FK |
| amount | Unknown |  |
| due_on_day_of_the_month | Unknown |  |
| first_charge_date | Unknown |  |
| memo | Unknown |  |
| post_days_in_advance | Unknown |  |

### lease_rent_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | PK, FK |
| backdate_charge | Unknown |  |
| created_by_user_id | Unknown |  |
| created_date_time | Unknown |  |
| end_date | Unknown |  |
| rent_cycle | Unknown |  |
| start_date | Unknown |  |
| total_amount | Unknown |  |

### property

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| property_group_id | Unknown | PK, FK |
| href | Unknown |  |
| type | Unknown |  |

### property_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by_user_first_name | Unknown |  |
| created_by_user_href | Unknown |  |
| created_by_user_id | Unknown |  |
| created_by_user_last_name | Unknown |  |
| description | Unknown |  |
| name | Unknown |  |

### bank_account_transaction_paid_by

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_account_id | Unknown | PK, FK |
| bank_account_transaction_id | Unknown | PK, FK |
| accounting_entity_type | Unknown |  |
| amount | Unknown |  |
| href | Unknown |  |
| unit | Unknown |  |

### bank_account_transaction_paid_to

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_account_id | Unknown | PK, FK |
| bank_account_transaction_id | Unknown | PK, FK |
| href | Unknown |  |
| name | Unknown |  |
| type | Unknown |  |

### bank_account_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bank_account_id | Unknown | PK, FK |
| amount | Unknown |  |
| balance | Unknown |  |
| check_number | Unknown |  |
| entry_date | Unknown |  |
| memo | Unknown |  |
| reconciliation_status | Unknown |  |
| transaction_type | Unknown |  |

### lease_outstanding_balance

| Column | Type | Keys |
| --- | --- | --- |
| all_outstanding_lease_balance_lease_id | Unknown | PK, FK |
| gl_account_id | Unknown | PK, FK |
| total_balance | Unknown |  |

### all_outstanding_lease_balance

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK, FK |
| property_id | Unknown | FK |
| balance_0_to_30_day | Unknown |  |
| balance_31_to_60_day | Unknown |  |
| balance_61_to_90_day | Unknown |  |
| balance_over_90_day | Unknown |  |
| eviction_pending_date | Unknown |  |
| is_notice_given | Unknown |  |
| past_due_email_sent_date | Unknown |  |
| total_balance | Unknown |  |
| unit_id | Unknown |  |

### lease_transaction_recurring_charge

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_recurring_transaction_id | Unknown | PK, FK |
| gl_account_id | Unknown | FK |
| lease_id | Unknown | FK |
| rent_id | Unknown | FK |
| amount | Unknown |  |
| duration | Unknown |  |
| first_occurrence_date | Unknown |  |
| frequency | Unknown |  |
| memo | Unknown |  |
| next_occurrence_date | Unknown |  |
| occurrences_remaining | Unknown |  |
| post_days_in_advance | Unknown |  |

### gl_payment_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| gl_account_id | Unknown | PK, FK |
| gl_transaction_id | Unknown | PK, FK |
| accounting_entity_id | Unknown |  |
| accounting_entity_type | Unknown |  |
| href | Unknown |  |
| unit_href | Unknown |  |
| unit_id | Unknown |  |

### gl_transaction_journal_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| gl_transaction_id | Unknown | PK, FK |
| gl_account_id | Unknown | FK |
| accounting_entity_href | Unknown |  |
| accounting_entity_id | Unknown |  |
| accounting_entity_type | Unknown |  |
| accounting_entity_unit_href | Unknown |  |
| accounting_entity_unit_id | Unknown |  |
| amount | Unknown |  |
| is_cash_posting | Unknown |  |
| memo | Unknown |  |
| reference_number | Unknown |  |

### gl_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| gl_account_id | Unknown | PK, FK |
| check_number | Unknown |  |
| date | Unknown |  |
| deposit_details_bank_gl_account_id | Unknown |  |
| journal_memo | Unknown |  |
| last_updated_date_time | Unknown |  |
| payee_href | Unknown |  |
| payee_id | Unknown |  |
| payee_name | Unknown |  |
| payee_type | Unknown |  |
| payment_detail_internal_transaction_status | Unknown |  |
| payment_detail_is_internal_transaction | Unknown |  |
| payment_detail_payment_method | Unknown |  |
| total_amount | Unknown |  |
| transaction_type | Unknown |  |
| unit_agreement_href | Unknown |  |
| unit_agreement_id | Unknown |  |
| unit_agreement_type | Unknown |  |
| unit_id | Unknown |  |
| unit_number | Unknown |  |

### tenant_phone_number

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

### tenant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| alternaate_email | Unknown |  |
| alternate_address_line_1 | Unknown |  |
| alternate_address_line_2 | Unknown |  |
| alternate_address_line_3 | Unknown |  |
| alternate_city | Unknown |  |
| alternate_country | Unknown |  |
| alternate_postal_code | Unknown |  |
| alternate_state | Unknown |  |
| city | Unknown |  |
| comment | Unknown |  |
| country | Unknown |  |
| created_date_time | Unknown |  |
| date_of_birth | Unknown |  |
| email | Unknown |  |
| emergency_contact_email | Unknown |  |
| emergency_contact_name | Unknown |  |
| emergency_contact_phone | Unknown |  |
| emergency_contact_relationship_description | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| mailing_preference | Unknown |  |
| postal_code | Unknown |  |
| sms_opt_in_status | Unknown |  |
| state | Unknown |  |
| tax_id | Unknown |  |

### gl_account_balance_sub_account

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

### gl_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_number | Unknown |  |
| cash_flow_classification | Unknown |  |
| default_account_name | Unknown |  |
| description | Unknown |  |
| exclude_from_cash_balance | Unknown |  |
| is_active | Unknown |  |
| is_bank_account | Unknown |  |
| is_contra_account | Unknown |  |
| is_default_gl_account | Unknown |  |
| name | Unknown |  |
| parent_gl_account_id | Unknown |  |
| sub_type | Unknown |  |
| type | Unknown |  |

### bank_account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| account_number | Unknown |  |
| account_number_unmasked | Unknown |  |
| balance | Unknown |  |
| bank_account_type | Unknown |  |
| check_layout_type | Unknown |  |
| country | Unknown |  |
| credit_card_service_fee_percentage | Unknown |  |
| credit_monthly_limit | Unknown |  |
| credit_transaction_limit | Unknown |  |
| debit_monthly_limit | Unknown |  |
| debit_transaction_limit | Unknown |  |
| description | Unknown |  |
| enable_local_check_printing | Unknown |  |
| enable_remote_check_printing | Unknown |  |
| fractional_number | Unknown |  |
| is_active | Unknown |  |
| is_credit_card_service_fee_paid_by_resident | Unknown |  |
| name | Unknown |  |
| resident_credit_card_convenience_fee_amount | Unknown |  |
| resident_eft_convience_fee_amount | Unknown |  |
| routing_number | Unknown |  |
| signature_heading | Unknown |  |
| check_printing_info** |  |  |

### lease_move_out_data

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK, FK |
| tenant_id | Unknown | PK, FK |
| move_out_date | Unknown |  |
| notice_given_date | Unknown |  |

### lease_cosigner_phone_number

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

### lease_cosigner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| alternate_address_line_1 | Unknown |  |
| alternate_address_line_2 | Unknown |  |
| alternate_address_line_3 | Unknown |  |
| alternate_city | Unknown |  |
| alternate_country | Unknown |  |
| alternate_email | Unknown |  |
| alternate_postal_code | Unknown |  |
| alternate_state | Unknown |  |
| city | Unknown |  |
| country | Unknown |  |
| created_date_time | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| mailing_preference | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |

### lease_current_tenant_phone_number

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

### lease_current_tenant

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK, FK |
| tenant_id | Unknown | PK, FK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| alternate_address | Unknown |  |
| city | Unknown |  |
| comment | Unknown |  |
| country | Unknown |  |
| created_date_time | Unknown |  |
| current_number_of_occupant | Unknown |  |
| date_of_birth | Unknown |  |
| email | Unknown |  |
| emergency_contact_email | Unknown |  |
| emergency_contact_name | Unknown |  |
| emergency_contact_phone | Unknown |  |
| emergency_contact_relationship_description | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| lease | Unknown |  |
| mailing_preference | Unknown |  |
| postal_code | Unknown |  |
| sms_opt_in_status | Unknown |  |
| state | Unknown |  |
| tax_id | Unknown |  |

### lease_tenant

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK, FK |
| tenant_id | Unknown | PK, FK |
| move_in_date | Unknown |  |
| status | Unknown |  |

### lease

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| property_id | Unknown | FK |
| account_details_rent | Unknown |  |
| account_details_security_deposit | Unknown |  |
| automatically_move_out_tenant | Unknown |  |
| created_date_time | Unknown |  |
| current_number_of_occupant | Unknown |  |
| is_eviction_pending | Unknown |  |
| last_updated_date_time | Unknown |  |
| lease_from_date | Unknown |  |
| lease_status | Unknown |  |
| lease_to_date | Unknown |  |
| lease_type | Unknown |  |
| payment_due_day | Unknown |  |
| renewal_offer_status | Unknown |  |
| term_type | Unknown |  |
| unit_id | Unknown |  |
| unit_number | Unknown |  |

### lease_transaction_journal_line

| Column | Type | Keys |
| --- | --- | --- |
| lease_id | Unknown | PK |
| gl_account_id | Unknown | PK, FK |
| lease_transaction_id | Unknown | PK, FK |
| property_id | Unknown | FK |
| amount | Unknown |  |
| is_cash_posting | Unknown |  |
| memo | Unknown |  |
| reference_number | Unknown |  |
| unit_id | Unknown |  |

### lease_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | FK |
| check_number | Unknown |  |
| date | Unknown |  |
| journal_memo | Unknown |  |
| payee_tenant_id | Unknown |  |
| payment_method | Unknown |  |
| total_amount | Unknown |  |
| transaction_type | Unknown |  |
| transaction_type_enum | Unknown |  |

### lease_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | PK, FK |
| last_updated_by_user_first_name | Unknown |  |
| last_updated_by_user_href | Unknown |  |
| last_updated_by_user_id | Unknown |  |
| last_updated_by_user_last_name | Unknown |  |
| last_updated_by_user_updated_date_time | Unknown |  |
| note | Unknown |  |

### gl_accounting_entity_balance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| gl_account_balance_id | Unknown | PK, FK |
| accounting_entity_href | Unknown |  |
| accounting_entity_type | Unknown |  |
| accounting_entity_unit | Unknown |  |
| balance | Unknown |  |

### gl_account_balance

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

### lease_recurring_transaction_line

| Column | Type | Keys |
| --- | --- | --- |
| gl_account_id | Unknown | PK, FK |
| lease_id | Unknown | PK, FK |
| lease_recurring_transaction_id | Unknown | PK, FK |
| amount | Unknown |  |

### lease_recurring_transaction

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | PK, FK |
| offsetting_gl_account_id | Unknown | FK |
| rent_id | Unknown | FK |
| amount | Unknown |  |
| duration | Unknown |  |
| frequency | Unknown |  |
| is_expired | Unknown |  |
| memo | Unknown |  |
| next_occurrence_date | Unknown |  |
| post_days_in_advance | Unknown |  |
| transaction_type | Unknown |  |

### rental_owner_phone_number

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

### rental_owner_property

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

### rental_owner

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_line_1 | Unknown |  |
| address_line_2 | Unknown |  |
| address_line_3 | Unknown |  |
| alternate_email | Unknown |  |
| city | Unknown |  |
| comment | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| include_in_1099 | Unknown |  |
| is_active | Unknown |  |
| is_company | Unknown |  |
| last_name | Unknown |  |
| management_agreement_end_date | Unknown |  |
| management_agreement_start_date | Unknown |  |
| postal_code | Unknown |  |
| state | Unknown |  |
| tax_information_address_line_1 | Unknown |  |
| tax_information_address_line_2 | Unknown |  |
| tax_information_address_line_3 | Unknown |  |
| tax_information_city | Unknown |  |
| tax_information_country | Unknown |  |
| tax_information_postal_code | Unknown |  |
| tax_information_state | Unknown |  |
| tax_payer_id | Unknown |  |
| tax_payer_id_type | Unknown |  |
| tax_payer_name_1 | Unknown |  |
| tax_payer_name_2 | Unknown |  |

## Relationships

- listing_property_feature(listing_id) → listing(listing_id)
- listing_include_in_rent(listing_id) → listing(listing_id)
- listing_property_file(listing_id) → listing(listing_id)
- listing_unit_feature(listing_id) → listing(listing_id)
- listing_unit_file(listing_id) → listing(listing_id)
- listing(property_id) → property(id)
- lease_renewal_tenant(tenant_id) → tenant(id)
- lease_renewal_tenant(lease_id) → lease_renewal(lease_id)
- lease_renewal_tenant(lease_renewal_id) → lease_renewal(id)
- lease_renewal(rent_id) → lease_rent_schedule(id)
- lease_renewal(lease_id) → lease(id)
- lease_rent_schedule_charge(gl_account_id) → gl_account(id)
- lease_rent_schedule_charge(lease_id) → lease_rent_schedule(lease_id)
- lease_rent_schedule_charge(lease_rent_schedule_id) → lease_rent_schedule(id)
- lease_rent_schedule(lease_id) → lease(id)
- property(property_group_id) → property_group(id)
- bank_account_transaction_paid_by(bank_account_transaction_id) → bank_account_transaction(id)
- bank_account_transaction_paid_by(bank_account_id) → bank_account_transaction(bank_account_id)
- bank_account_transaction_paid_to(bank_account_transaction_id) → bank_account_transaction(id)
- bank_account_transaction_paid_to(bank_account_id) → bank_account_transaction(bank_account_id)
- bank_account_transaction(bank_account_id) → bank_account(id)
- lease_outstanding_balance(gl_account_id) → gl_account(id)
- lease_outstanding_balance(all_outstanding_lease_balance_lease_id) → all_outstanding_lease_balance(lease_id)
- all_outstanding_lease_balance(lease_id) → lease(id)
- all_outstanding_lease_balance(property_id) → property(id)
- lease_transaction_recurring_charge(lease_id) → lease_recurring_transaction(lease_id)
- lease_transaction_recurring_charge(rent_id) → lease_rent_schedule(id)
- lease_transaction_recurring_charge(gl_account_id) → gl_account(id)
- lease_transaction_recurring_charge(lease_recurring_transaction_id) → lease_recurring_transaction(id)
- gl_payment_transaction(gl_transaction_id) → gl_transaction(id)
- gl_payment_transaction(gl_account_id) → gl_transaction(gl_account_id)
- gl_transaction_journal_line(gl_account_id) → gl_account(id)
- gl_transaction_journal_line(gl_transaction_id) → gl_transaction(id)
- gl_transaction(gl_account_id) → gl_account(id)
- tenant_phone_number(tenant_id) → tenant(id)
- gl_account_balance_sub_account(gl_account_id) → gl_account(id)
- bank_account(id) → gl_account(id)
- lease_move_out_data(tenant_id) → tenant(id)
- lease_move_out_data(lease_id) → lease(id)
- lease_cosigner_phone_number(lease_id) → lease_cosigner(lease_id)
- lease_cosigner_phone_number(lease_cosigner_id) → lease_cosigner(id)
- lease_cosigner(lease_id) → lease(id)
- lease_current_tenant_phone_number(lease_id) → lease_current_tenant(lease_id)
- lease_current_tenant_phone_number(lease_current_tenent_id) → lease_current_tenant(tenant_id)
- lease_current_tenant(tenant_id) → tenant(id)
- lease_current_tenant(lease_id) → lease(id)
- lease_tenant(tenant_id) → tenant(id)
- lease_tenant(lease_id) → lease(id)
- lease(property_id) → property(id)
- lease_transaction_journal_line(gl_account_id) → gl_account(id)
- lease_transaction_journal_line(property_id) → property(id)
- lease_transaction_journal_line(lease_transaction_id) → lease_transaction(id)
- lease_transaction(lease_id) → lease(id)
- lease_note(lease_id) → lease(id)
- gl_accounting_entity_balance(gl_account_balance_id) → gl_account_balance(id)
- gl_account_balance(id) → gl_account(id)
- lease_recurring_transaction_line(gl_account_id) → gl_account(id)
- lease_recurring_transaction_line(lease_id) → lease_recurring_transaction(lease_id)
- lease_recurring_transaction_line(lease_recurring_transaction_id) → lease_recurring_transaction(id)
- lease_recurring_transaction(rent_id) → lease_rent_schedule(id)
- lease_recurring_transaction(offsetting_gl_account_id) → gl_account(id)
- lease_recurring_transaction(lease_id) → lease(id)
- rental_owner_phone_number(rental_owner_id) → rental_owner(id)
- rental_owner_property(property_id) → property(id)
- rental_owner_property(rental_owner_id) → rental_owner(id)