Buildium
Explore the interactive ERD
Table & Field Reference
listing_property_feature
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
listing_id | Unknown | PKFK |
feature | Unknown |
listing_include_in_rent
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
listing_id | Unknown | PKFK |
include_in_rent | Unknown |
listing_property_file
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
listing_id | Unknown | PKFK |
name | Unknown | |
type | Unknown | |
url | Unknown |
listing_unit_feature
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
listing_id | Unknown | PKFK |
feature | Unknown |
listing_unit_file
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
listing_id | Unknown | PKFK |
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 | PKFK |
lease_renewal_id | Unknown | PKFK |
tenant_id | Unknown | PKFK |
lease_renewal
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_id | Unknown | PKFK |
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 | PKFK |
lease_rent_schedule_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
bank_account_transaction_id | Unknown | PKFK |
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 | PKFK |
bank_account_transaction_id | Unknown | PKFK |
href | Unknown | |
name | Unknown | |
type | Unknown |
bank_account_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
bank_account_id | Unknown | PKFK |
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 | PKFK |
gl_account_id | Unknown | PKFK |
total_balance | Unknown |
all_outstanding_lease_balance
| Column | Type | Keys |
|---|---|---|
lease_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
gl_transaction_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
tenant_id | Unknown | PKFK |
move_out_date | Unknown | |
notice_given_date | Unknown |
lease_cosigner_phone_number
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
lease_cosigner_id | Unknown | PKFK |
lease_id | Unknown | PKFK |
number | Unknown | |
type | Unknown |
lease_cosigner
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_id | Unknown | PKFK |
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 | PKFK |
lease_id | Unknown | PKFK |
number | Unknown | |
type | Unknown |
lease_current_tenant
| Column | Type | Keys |
|---|---|---|
lease_id | Unknown | PKFK |
tenant_id | Unknown | PKFK |
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 | PKFK |
tenant_id | Unknown | PKFK |
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 | PKFK |
lease_transaction_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
accounting_entity_href | Unknown | |
accounting_entity_type | Unknown | |
accounting_entity_unit | Unknown | |
balance | Unknown |
gl_account_balance
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
total_balance | Unknown |
lease_recurring_transaction_line
| Column | Type | Keys |
|---|---|---|
gl_account_id | Unknown | PKFK |
lease_id | Unknown | PKFK |
lease_recurring_transaction_id | Unknown | PKFK |
amount | Unknown |
lease_recurring_transaction
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lease_id | Unknown | PKFK |
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 | PKFK |
number | Unknown | |
type | Unknown |
rental_owner_property
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
rental_owner_id | Unknown | PKFK |
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 |