# VTS schema ERD

Table and field reference for the Fivetran VTS connector.

## Table & Field Reference

### approval_approver

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| approval_id | Unknown | PK, FK |
| approver_user_id | Unknown | FK |
| comment | Unknown |  |
| description | Unknown |  |
| reviewed_at | Unknown |  |
| status | Unknown |  |
| step_number | Unknown |  |

### approval

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| proposal_id | Unknown | FK |
| requester_id | Unknown | FK |
| active | Unknown |  |
| created_at | Unknown |  |
| requested_at | Unknown |  |
| requester_comment | Unknown |  |
| updated_at | Instant |  |

### proposal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| discount_rate | Unknown |  |
| entered_date | Unknown |  |
| latest | Unknown |  |
| ner_to_termination_area_unit | Unknown |  |
| ner_to_termination_magnitude | Unknown |  |
| ner_to_termination_money_unit | Unknown |  |
| ner_to_termination_period_unit | Unknown |  |
| ner_to_termination_type | Unknown |  |
| ner_to_termination_unit | Unknown |  |
| ner_vs_budget_magnitude | Unknown |  |
| ner_vs_budget_money_unit | Unknown |  |
| ner_vs_budget_type | Unknown |  |
| ner_vs_budget_unit | Unknown |  |
| ner_with_downtime_area_unit | Unknown |  |
| ner_with_downtime_magnitude | Unknown |  |
| ner_with_downtime_money_unit | Unknown |  |
| ner_with_downtime_period_unit | Unknown |  |
| ner_with_downtime_type | Unknown |  |
| ner_with_downtime_unit | Unknown |  |
| net_effective_rent_area_unit | Unknown |  |
| net_effective_rent_magnitude | Unknown |  |
| net_effective_rent_money_unit | Unknown |  |
| net_effective_rent_period_unit | Unknown |  |
| net_effective_rent_type | Unknown |  |
| net_effective_rent_unit | Unknown |  |
| net_rent_area_unit | Unknown |  |
| net_rent_magnitude | Unknown |  |
| net_rent_money_unit | Unknown |  |
| net_rent_period_unit | Unknown |  |
| net_rent_type | Unknown |  |
| net_rent_unit | Unknown |  |
| proposal_date | Unknown |  |
| proposal_label | Unknown |  |
| proposal_type | Unknown |  |
| total_base_rent_area_unit | Unknown |  |
| total_base_rent_magnitude | Unknown |  |
| total_base_rent_money_unit | Unknown |  |
| total_base_rent_period_unit | Unknown |  |
| total_base_rent_type | Unknown |  |
| total_base_rent_unit | Unknown |  |
| total_capital_magnitude | Unknown |  |
| total_capital_money_unit | Unknown |  |
| total_capital_type | Unknown |  |
| total_capital_unit | Unknown |  |
| total_net_cash_flow_magnitude | Unknown |  |
| total_net_cash_flow_money_unit | Unknown |  |
| total_net_cash_flow_type | Unknown |  |
| total_net_cash_flow_unit | Unknown |  |
| updated_at | Instant |  |

### tenant_update_contact

| Column | Type | Keys |
| --- | --- | --- |
| tenant_contact_id | Unknown | PK, FK |
| tenant_update_id | Unknown | PK, FK |

### tenant_update

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| created_by_id | Unknown | FK |
| owner_id | Unknown | FK |
| tenant_id | Unknown | FK |
| comment | Unknown |  |
| created_at | Unknown |  |
| important | Unknown |  |
| interaction_date | Unknown |  |
| interaction_type | Unknown |  |
| sentiment | Unknown |  |
| updated_at | Instant |  |

### coordination_project_milestone

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| completed_by_id | Unknown | FK |
| category_description | Unknown |  |
| completed_at | Unknown |  |
| completed_by_type | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| notes | Unknown |  |
| target_date | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### appraisal_reimbursable_expense

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_id | Unknown | PK, FK |
| description | Unknown |  |
| expense_amount_area_unit | Unknown |  |
| expense_amount_magnitude | Unknown |  |
| expense_amount_money_unit | Unknown |  |
| expense_amount_period_unit | Unknown |  |
| expense_amount_type | Unknown |  |
| expense_amount_unit | Unknown |  |
| expense_growth_rate_magnitude | Unknown |  |
| expense_growth_rate_period_unit | Unknown |  |
| expense_growth_rate_type | Unknown |  |
| expense_growth_rate_unit | Unknown |  |
| expense_stop_area_unit | Unknown |  |
| expense_stop_magnitude | Unknown |  |
| expense_stop_money_unit | Unknown |  |
| expense_stop_period_unit | Unknown |  |
| expense_stop_type | Unknown |  |
| expense_stop_unit | Unknown |  |
| expense_type | Unknown |  |
| recovery_amount_area_unit | Unknown |  |
| recovery_amount_magnitude | Unknown |  |
| recovery_amount_money_unit | Unknown |  |
| recovery_amount_period_unit | Unknown |  |
| recovery_amount_type | Unknown |  |
| recovery_amount_unit | Unknown |  |
| recovery_method | Unknown |  |

### appraisal_base_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| start_month | Unknown |  |

### appraisal_commission_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_commission_index | Unknown | PK, FK |
| appraisal_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| start_date | Unknown |  |
| start_month | Unknown |  |

### appraisal_commission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_id | Unknown | PK, FK |
| broker | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| free_rent | Unknown |  |
| net_or_gross | Unknown |  |
| type | Unknown |  |

### appraisal_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| description | Unknown |  |
| occurrence_month | Unknown |  |
| type | Unknown |  |

### appraisal_free_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| duration_iso_8601 | Unknown |  |
| duration_magnitude | Unknown |  |
| duration_period_unit | Unknown |  |
| duration_type | Unknown |  |
| duration_unit | Unknown |  |
| start_month | Unknown |  |
| type | Unknown |  |

### appraisal_rent_escalation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| appraisal_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| occurs | Unknown |  |
| start_month | Unknown |  |

### appraisal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| analysis_type | Unknown |  |
| commencement_date | Unknown |  |
| concession | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| entered_date | Unknown |  |
| internal_rate_of_return | Unknown |  |
| ner_override_area_unit | Unknown |  |
| ner_override_magnitude | Unknown |  |
| ner_override_money_unit | Unknown |  |
| ner_override_period_unit | Unknown |  |
| ner_override_type | Unknown |  |
| ner_override_unit | Unknown |  |
| net_effective_rent_area_unit | Unknown |  |
| net_effective_rent_magnitude | Unknown |  |
| net_effective_rent_money_unit | Unknown |  |
| net_effective_rent_period_unit | Unknown |  |
| net_effective_rent_type | Unknown |  |
| net_effective_rent_unit | Unknown |  |
| npv_discount_rate | Unknown |  |
| npv_per_area_magnitude | Unknown |  |
| npv_per_area_money_unit | Unknown |  |
| npv_per_area_type | Unknown |  |
| npv_per_area_unit | Unknown |  |
| payback | Unknown |  |
| rentable_size_area_unit | Unknown |  |
| rentable_size_magnitude | Unknown |  |
| rentable_size_type | Unknown |  |
| rentable_size_unit | Unknown |  |
| security_deposit_magnitude | Unknown |  |
| security_deposit_money_unit | Unknown |  |
| security_deposit_type | Unknown |  |
| security_deposit_unit | Unknown |  |
| structure | Unknown |  |
| total_deal_value_area_unit | Unknown |  |
| total_deal_value_magnitude | Unknown |  |
| total_deal_value_money_unit | Unknown |  |
| total_deal_value_period_unit | Unknown |  |
| total_deal_value_type | Unknown |  |
| total_deal_value_unit | Unknown |  |
| total_lease_term_iso_8601 | Unknown |  |
| total_lease_term_magnitude | Unknown |  |
| total_lease_term_period_unit | Unknown |  |
| total_lease_term_type | Unknown |  |
| total_lease_term_unit | Unknown |  |
| total_net_cash_flow_magnitude | Unknown |  |
| total_net_cash_flow_money_unit | Unknown |  |
| total_net_cash_flow_type | Unknown |  |
| total_net_cash_flow_unit | Unknown |  |
| total_rent_area_unit | Unknown |  |
| total_rent_magnitude | Unknown |  |
| total_rent_money_unit | Unknown |  |
| total_rent_period_unit | Unknown |  |
| total_rent_type | Unknown |  |
| total_rent_unit | Unknown |  |

### blended_budget

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| base_rent_area_unit | Unknown |  |
| base_rent_magnitude | Unknown |  |
| base_rent_money_unit | Unknown |  |
| base_rent_period_unit | Unknown |  |
| base_rent_type | Unknown |  |
| base_rent_unit | Unknown |  |
| building_improvement_area_unit | Unknown |  |
| building_improvement_magnitude | Unknown |  |
| building_improvement_money_unit | Unknown |  |
| building_improvement_type | Unknown |  |
| building_improvement_unit | Unknown |  |
| created_at | Unknown |  |
| net_effective_rent_area_unit | Unknown |  |
| net_effective_rent_magnitude | Unknown |  |
| net_effective_rent_money_unit | Unknown |  |
| net_effective_rent_period_unit | Unknown |  |
| net_effective_rent_type | Unknown |  |
| net_effective_rent_unit | Unknown |  |
| net_present_value_area_unit | Unknown |  |
| net_present_value_magnitude | Unknown |  |
| net_present_value_money_unit | Unknown |  |
| net_present_value_type | Unknown |  |
| net_present_value_unit | Unknown |  |
| recovered_income_area_unit | Unknown |  |
| recovered_income_magnitude | Unknown |  |
| recovered_income_money_unit | Unknown |  |
| recovered_income_period_unit | Unknown |  |
| recovered_income_type | Unknown |  |
| recovered_income_unit | Unknown |  |
| reimbrusable_expense_area_unit | Unknown |  |
| reimbrusable_expense_magnitude | Unknown |  |
| reimbrusable_expense_money_unit | Unknown |  |
| reimbrusable_expense_period_unit | Unknown |  |
| reimbrusable_expense_type | Unknown |  |
| reimbrusable_expense_unit | Unknown |  |
| rentable_size_area_unit | Unknown |  |
| rentable_size_magnitude | Unknown |  |
| rentable_size_type | Unknown |  |
| rentable_size_unit | Unknown |  |
| tenant_improvement_area_unit | Unknown |  |
| tenant_improvement_magnitude | Unknown |  |
| tenant_improvement_money_unit | Unknown |  |
| tenant_improvement_type | Unknown |  |
| tenant_improvement_unit | Unknown |  |
| total_commission_magnitude | Unknown |  |
| total_commission_money_unit | Unknown |  |
| total_commission_type | Unknown |  |
| total_commission_unit | Unknown |  |
| total_free_rent_magnitude | Unknown |  |
| total_free_rent_money_unit | Unknown |  |
| total_free_rent_type | Unknown |  |
| total_free_rent_unit | Unknown |  |
| total_other_revenue_area_unit | Unknown |  |
| total_other_revenue_magnitude | Unknown |  |
| total_other_revenue_money_unit | Unknown |  |
| total_other_revenue_period_unit | Unknown |  |
| total_other_revenue_type | Unknown |  |
| total_other_revenue_unit | Unknown |  |
| total_percentage_rent_magnitude | Unknown |  |
| total_percentage_rent_money_unit | Unknown |  |
| total_percentage_rent_type | Unknown |  |
| total_percentage_rent_unit | Unknown |  |
| updated_at | Instant |  |

### deal_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assignee_id | Unknown | FK |
| completed_by_id | Unknown | FK |
| deal_id | Unknown | FK |
| completed | Unknown |  |
| completed_at | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| required | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### deal_comment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| iteration_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| latest | Unknown |  |
| occurred_at | Unknown |  |
| text | Unknown |  |
| updated_at | Instant |  |

### option_target

| Column | Type | Keys |
| --- | --- | --- |
| option_id | Unknown | PK, FK |
| space_id | Unknown | PK, FK |
| type | Unknown |  |

### option

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_term_id | Unknown | FK |
| proposal_id | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| effective_date | Unknown |  |
| minimum_size | Unknown |  |
| notice_end_date | Unknown |  |
| notice_start_date | Unknown |  |
| number_of_option | Unknown |  |
| option_type | Unknown |  |
| rate_note | Unknown |  |
| rate_type | Unknown |  |
| term_iso_8601 | Unknown |  |
| term_magnitude | Unknown |  |
| term_period_unit | Unknown |  |
| term_type | Unknown |  |
| term_unit | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### budget_commission_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_commission_index | Unknown | PK, FK |
| budget_id | Unknown | PK, FK |
| periods_area_unit | Unknown |  |
| periods_magnitude | Unknown |  |
| periods_money_unit | Unknown |  |
| periods_period_unit | Unknown |  |
| periods_type | Unknown |  |
| periods_unit | Unknown |  |
| start_date | Unknown |  |
| start_month | Unknown |  |

### budget_commission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| broker | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| free_rent | Unknown |  |
| net_or_gross | Unknown |  |
| type | Unknown |  |

### budget_rent_escalation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| occurs | Unknown |  |
| start_month | Unknown |  |

### budget_base_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| begin_in | Unknown |  |
| start_month | Unknown |  |

### budget_free_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount_free_magnitude | Unknown |  |
| amount_free_period_unit | Unknown |  |
| amount_free_type | Unknown |  |
| amount_free_unit | Unknown |  |
| duration | Unknown |  |
| duration_iso_8601 | Unknown |  |
| duration_magnitude | Unknown |  |
| duration_period_unit | Unknown |  |
| duration_type | Unknown |  |
| duration_unit | Unknown |  |
| precent_free | Unknown |  |
| recovery_type | Unknown |  |
| start_month | Unknown |  |
| type | Unknown |  |

### budget_percentage_rent_sales_overage_breakpoint

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| budget_percentage_rent_index | Unknown | PK, FK |
| breakpoint_magnitude | Unknown |  |
| breakpoint_money_unit | Unknown |  |
| breakpoint_period_unit | Unknown |  |
| breakpoint_type | Unknown |  |
| breakpoint_unit | Unknown |  |
| percent_rent_magnitude | Unknown |  |
| percent_rent_period_unit | Unknown |  |
| percent_rent_type | Unknown |  |
| percent_rent_unit | Unknown |  |

### budget_percentage_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| minimum_guarantee_area_unit | Unknown |  |
| minimum_guarantee_magnitude | Unknown |  |
| minimum_guarantee_money_unit | Unknown |  |
| minimum_guarantee_period_unit | Unknown |  |
| minimum_guarantee_type | Unknown |  |
| minimum_guarantee_unit | Unknown |  |
| sales_overage_breakpoints_type | Unknown |  |
| start_month | Unknown |  |

### budget_other_income

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| quantity | Unknown |  |
| start_month | Unknown |  |
| type | Unknown |  |

### budget_reimbursabl_expense

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| description | Unknown |  |
| expense_amount_area_unit | Unknown |  |
| expense_amount_magnitude | Unknown |  |
| expense_amount_money_unit | Unknown |  |
| expense_amount_period_unit | Unknown |  |
| expense_amount_type | Unknown |  |
| expense_amount_unit | Unknown |  |
| expense_growth_rate_magnitude | Unknown |  |
| expense_growth_rate_period_unit | Unknown |  |
| expense_growth_rate_type | Unknown |  |
| expense_growth_rate_unit | Unknown |  |
| expense_stop_area_unit | Unknown |  |
| expense_stop_magnitude | Unknown |  |
| expense_stop_money_unit | Unknown |  |
| expense_stop_period_unit | Unknown |  |
| expense_stop_type | Unknown |  |
| expense_stop_unit | Unknown |  |
| expense_type | Unknown |  |
| recovery_amount_area_unit | Unknown |  |
| recovery_amount_magnitude | Unknown |  |
| recovery_amount_money_unit | Unknown |  |
| recovery_amount_period_unit | Unknown |  |
| recovery_amount_type | Unknown |  |
| recovery_amount_unit | Unknown |  |
| recovery_method | Unknown |  |

### budget_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| description | Unknown |  |
| occurrence_month | Unknown |  |
| typek | Unknown |  |

### budget_rent_schedule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| budget_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| end_month | Unknown |  |
| start_month | Unknown |  |

### budget

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| blended_budget_id | Unknown | FK |
| space_id | Unknown | FK |
| budget_year | Unknown |  |
| commencement_date | Unknown |  |
| commission_month | Unknown |  |
| concession | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| downtime_magnitude | Unknown |  |
| downtime_period_unit | Unknown |  |
| downtime_type | Unknown |  |
| downtime_unit | Unknown |  |
| entered_date | Unknown |  |
| execution_date | Unknown |  |
| gross_rent_area_unit | Unknown |  |
| gross_rent_magnitude | Unknown |  |
| gross_rent_money_unit | Unknown |  |
| gross_rent_period_unit | Unknown |  |
| gross_rent_type | Unknown |  |
| gross_rent_unit | Unknown |  |
| internal_rate_of_return | Unknown |  |
| label | Unknown |  |
| lock_in_end_date | Unknown |  |
| minimum_guarantee_area_unit | Unknown |  |
| minimum_guarantee_magnitude | Unknown |  |
| minimum_guarantee_money_unit | Unknown |  |
| minimum_guarantee_period_unit | Unknown |  |
| minimum_guarantee_type | Unknown |  |
| minimum_guarantee_unit | Unknown |  |
| ner_override_magnitude | Unknown |  |
| ner_override_money_unit | Unknown |  |
| ner_override_period_unit | Unknown |  |
| ner_override_type | Unknown |  |
| ner_override_unit | Unknown |  |
| net_cash_flow_magnitude | Unknown |  |
| net_cash_flow_money_unit | Unknown |  |
| net_cash_flow_type | Unknown |  |
| net_cash_flow_unit | Unknown |  |
| net_effective_rent_area_unit | Unknown |  |
| net_effective_rent_magnitude | Unknown |  |
| net_effective_rent_money_unit | Unknown |  |
| net_effective_rent_period_unit | Unknown |  |
| net_effective_rent_type | Unknown |  |
| net_effective_rent_unit | Unknown |  |
| net_rent_area_unit | Unknown |  |
| net_rent_magnitude | Unknown |  |
| net_rent_money_unit | Unknown |  |
| net_rent_period_unit | Unknown |  |
| net_rent_type | Unknown |  |
| net_rent_unit | Unknown |  |
| npv_discount_rate | Unknown |  |
| npv_per_area_magnitude | Unknown |  |
| npv_per_area_money_unit | Unknown |  |
| npv_per_area_type | Unknown |  |
| npv_per_area_unit | Unknown |  |
| other_fee | Json |  |
| payback | Unknown |  |
| proposal_type | Unknown |  |
| rentable_size_area_unit | Unknown |  |
| rentable_size_magnitude | Unknown |  |
| rentable_size_type | Unknown |  |
| rentable_size_unit | Unknown |  |
| security_deposit_magnitude | Unknown |  |
| security_deposit_money_unit | Unknown |  |
| security_deposit_type | Unknown |  |
| security_deposit_unit | Unknown |  |
| structure | Unknown |  |
| tenant_risk_description | Unknown |  |
| total_deal_value_area_unit | Unknown |  |
| total_deal_value_magnitude | Unknown |  |
| total_deal_value_money_unit | Unknown |  |
| total_deal_value_period_unit | Unknown |  |
| total_deal_value_type | Unknown |  |
| total_deal_value_unit | Unknown |  |
| total_lease_term | Unknown |  |
| total_rent_area_unit | Unknown |  |
| total_rent_magnitude | Unknown |  |
| total_rent_money_unit | Unknown |  |
| total_rent_period_unit | Unknown |  |
| total_rent_type | Unknown |  |
| total_rent_unit | Unknown |  |
| updated_at | Instant |  |

### deal_tour_space

| Column | Type | Keys |
| --- | --- | --- |
| deal_tour_id | Unknown | PK, FK |
| space_id | Unknown | PK, FK |

### deal_tour

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| user_id | Unknown | FK |
| comment | Unknown |  |
| created_at | Unknown |  |
| tour_datetime | Unknown |  |
| updated_at | Instant |  |
| users_id | Unknown |  |

### deal_iteration

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| user_id | Unknown | FK |
| created_at | Unknown |  |
| duration_in_days | Unknown |  |
| ended_at | Unknown |  |
| latest | Unknown |  |
| occurred_at | Unknown |  |
| reason | Unknown |  |
| stage | Unknown |  |
| updated_at | Instant |  |

### deal_term_commission_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_commission_index | Unknown | PK, FK |
| deal_term_id | Unknown | PK, FK |
| amount_measure_money_area_area_unit | Unknown |  |
| amount_measure_money_area_magnitude | Unknown |  |
| amount_measure_money_area_money_unit | Unknown |  |
| amount_measure_money_area_type | Unknown |  |
| amount_measure_money_area_unit | Unknown |  |
| amount_measure_money_magnitude | Unknown |  |
| amount_measure_money_money_unit | Unknown |  |
| amount_measure_money_period_magnitude | Unknown |  |
| amount_measure_money_period_money_unit | Unknown |  |
| amount_measure_money_period_period_unit | Unknown |  |
| amount_measure_money_period_type | Unknown |  |
| amount_measure_money_period_unit | Unknown |  |
| amount_measure_money_type | Unknown |  |
| amount_measure_money_unit | Unknown |  |
| amount_measure_percentage_magnitude | Unknown |  |
| amount_measure_percentage_period_unit | Unknown |  |
| amount_measure_percentage_type | Unknown |  |
| amount_measure_percentage_unit | Unknown |  |
| start_date | Unknown |  |
| start_month | Unknown |  |

### deal_term_commission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| broker | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| free_rent | Unknown |  |
| net_or_gross | Unknown |  |
| type | Unknown |  |

### deal_term_rent_escalation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_percentage | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| occur | Unknown |  |
| start_month | Unknown |  |

### deal_term_base_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| start_month | Unknown |  |

### deal_term_free_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| amount_free_magnitude | Unknown |  |
| amount_free_percentage | Unknown |  |
| amount_free_period_unit | Unknown |  |
| amount_free_type | Unknown |  |
| amount_free_unit | Unknown |  |
| duration_iso_8601 | Unknown |  |
| duration_magnitude | Unknown |  |
| duration_period_unit | Unknown |  |
| duration_type | Unknown |  |
| duration_unit | Unknown |  |
| start_month | Unknown |  |
| type | Unknown |  |

### deal_term_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| description | Unknown |  |
| occurrence_month | Unknown |  |
| type | Unknown |  |

### deal_term_rent_schedule

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| end_month | Unknown |  |
| magnitude | Unknown |  |
| start_month | Unknown |  |
| unit | Unknown |  |

### deal_term_other_income

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| measure_money_area_period_area_unit | Unknown |  |
| measure_money_area_period_magnitude | Unknown |  |
| measure_money_area_period_period_unit | Unknown |  |
| measure_money_area_period_type | Unknown |  |
| measure_money_area_period_unit | Unknown |  |
| measure_money_period_magnitude | Unknown |  |
| measure_money_period_money_unit | Unknown |  |
| measure_money_period_period_unit | Unknown |  |
| measure_money_period_type | Unknown |  |
| measure_money_period_unit | Unknown |  |
| quantity | Unknown |  |
| start_month | Unknown |  |
| type | Unknown |  |

### deal_term_remaining_lease_obligation

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| duration_iso_8601 | Unknown |  |
| duration_magnitude | Unknown |  |
| duration_period_unit | Unknown |  |
| duration_type | Unknown |  |
| duration_unit | Unknown |  |
| measure_money_area_period_area_unit | Unknown |  |
| measure_money_area_period_magnitude | Unknown |  |
| measure_money_area_period_money_unit | Unknown |  |
| measure_money_area_period_period_unit | Unknown |  |
| measure_money_area_period_type | Unknown |  |
| measure_money_area_period_unit | Unknown |  |
| measure_money_period_magnitude | Unknown |  |
| measure_money_period_money_unit | Unknown |  |
| measure_money_period_period_unit | Unknown |  |
| measure_money_period_type | Unknown |  |
| measure_money_period_unit | Unknown |  |
| start_month | Unknown |  |

### deal_term_reimbursabl_expense

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_term_id | Unknown | PK, FK |
| description | Unknown |  |
| expense_amount_area_unit | Unknown |  |
| expense_amount_magnitude | Unknown |  |
| expense_amount_money_unit | Unknown |  |
| expense_amount_period_unit | Unknown |  |
| expense_amount_type | Unknown |  |
| expense_amount_unit | Unknown |  |
| expense_amount_with_unit | Unknown |  |
| expense_growth_rate_magnitude | Unknown |  |
| expense_growth_rate_period_unit | Unknown |  |
| expense_growth_rate_type | Unknown |  |
| expense_growth_rate_unit | Unknown |  |
| expense_stop_area_unit | Unknown |  |
| expense_stop_magnitude | Unknown |  |
| expense_stop_money_unit | Unknown |  |
| expense_stop_period_unit | Unknown |  |
| expense_stop_type | Unknown |  |
| expense_stop_unit | Unknown |  |
| expense_type | Unknown |  |
| recovery_amount_area_unit | Unknown |  |
| recovery_amount_magnitude | Unknown |  |
| recovery_amount_money_unit | Unknown |  |
| recovery_amount_period_unit | Unknown |  |
| recovery_amount_type | Unknown |  |
| recovery_amount_unit | Unknown |  |
| recovery_method | Unknown |  |

### deal_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | FK |
| proposal_id | Unknown | FK |
| space_id | Unknown | FK |
| calculated_metrics_internal_rate_of_return | Unknown |  |
| calculated_metrics_leasing_spread | Unknown |  |
| calculated_metrics_payback | Unknown |  |
| calculated_metrics_tenant_possession_date | Unknown |  |
| commencement_date | Unknown |  |
| created_at | Unknown |  |
| description | Unknown |  |
| downtime_iso_8609 | Unknown |  |
| downtime_magnitude | Unknown |  |
| downtime_period_unit | Unknown |  |
| downtime_type | Unknown |  |
| downtime_unit | Unknown |  |
| entered_date | Unknown |  |
| execution_date | Unknown |  |
| expiration_date | Unknown |  |
| gaap_rent_area_unit | Unknown |  |
| gaap_rent_magnitude | Unknown |  |
| gaap_rent_money_unit | Unknown |  |
| gaap_rent_period_unit | Unknown |  |
| gaap_rent_type | Unknown |  |
| gaap_rent_unit | Unknown |  |
| landlord_commission_magnitude | Unknown |  |
| landlord_commission_money_unit | Unknown |  |
| landlord_commission_type | Unknown |  |
| landlord_commission_unit | Unknown |  |
| ner_override_area_unit | Unknown |  |
| ner_override_magnitude | Unknown |  |
| ner_override_money_unit | Unknown |  |
| ner_override_period_unit | Unknown |  |
| ner_override_type | Unknown |  |
| ner_override_unit | Unknown |  |
| ner_to_termination_area_unit | Unknown |  |
| ner_to_termination_magnitude | Unknown |  |
| ner_to_termination_money_unit | Unknown |  |
| ner_to_termination_period_unit | Unknown |  |
| ner_to_termination_type | Unknown |  |
| ner_to_termination_unit | Unknown |  |
| ner_with_downtime_area_unit | Unknown |  |
| ner_with_downtime_magnitude | Unknown |  |
| ner_with_downtime_money_unit | Unknown |  |
| ner_with_downtime_period_unit | Unknown |  |
| ner_with_downtime_type | Unknown |  |
| ner_with_downtime_unit | Unknown |  |
| net_effective_rent_area_unit | Unknown |  |
| net_effective_rent_magnitude | Unknown |  |
| net_effective_rent_money_unit | Unknown |  |
| net_effective_rent_period_unit | Unknown |  |
| net_effective_rent_type | Unknown |  |
| net_effective_rent_unit | Unknown |  |
| net_present_value_magnitude | Unknown |  |
| net_present_value_money_unit | Unknown |  |
| net_present_value_type | Unknown |  |
| net_present_value_unit | Unknown |  |
| net_rent_area_unit | Unknown |  |
| net_rent_magnitude | Unknown |  |
| net_rent_money_unit | Unknown |  |
| net_rent_period_unit | Unknown |  |
| net_rent_type | Unknown |  |
| net_rent_unit | Unknown |  |
| npv_per_area_magnitude | Unknown |  |
| npv_per_area_money_unit | Unknown |  |
| npv_per_area_type | Unknown |  |
| npv_per_area_unit | Unknown |  |
| percentage_rents | Json |  |
| rent_commencement_date | Unknown |  |
| rentable_size_area_unit | Unknown |  |
| rentable_size_magnitude | Unknown |  |
| rentable_size_type | Unknown |  |
| rentable_size_unit | Unknown |  |
| retail_decription | Unknown |  |
| retail_estimated_sales | Unknown |  |
| retail_growth_rate | Unknown |  |
| retail_percent_rent | Unknown |  |
| retail_unnatural_breakpoint | Unknown |  |
| straight_line_balance | Unknown |  |
| straight_line_balance_magnitude | Unknown |  |
| straight_line_balance_money_unit | Unknown |  |
| straight_line_balance_type | Unknown |  |
| straight_line_balance_unit | Unknown |  |
| structure | Unknown |  |
| tenant_buildout_period_iso_8609 | Unknown |  |
| tenant_buildout_period_magnitude | Unknown |  |
| tenant_buildout_period_period_unit | Unknown |  |
| tenant_buildout_period_type | Unknown |  |
| tenant_buildout_period_unit | Unknown |  |
| tenant_commission_magnitude | Unknown |  |
| tenant_commission_money_unit | Unknown |  |
| tenant_commission_type | Unknown |  |
| tenant_commission_unit | Unknown |  |
| term_duration_iso_8609 | Unknown |  |
| term_duration_magnitude | Unknown |  |
| term_duration_period_unit | Unknown |  |
| term_duration_type | Unknown |  |
| term_duration_unit | Unknown |  |
| term_type | Unknown |  |
| total_capital_magnitude | Unknown |  |
| total_capital_money_unit | Unknown |  |
| total_capital_per_size_area_unit | Unknown |  |
| total_capital_per_size_magnitude | Unknown |  |
| total_capital_per_size_money_unit | Unknown |  |
| total_capital_per_size_type | Unknown |  |
| total_capital_per_size_unit | Unknown |  |
| total_capital_type | Unknown |  |
| total_capital_unit | Unknown |  |
| total_commission_magnitude | Unknown |  |
| total_commission_money_unit | Unknown |  |
| total_commission_type | Unknown |  |
| total_commission_unit | Unknown |  |
| total_net_cash_flow_magnitude | Unknown |  |
| total_net_cash_flow_money_unit | Unknown |  |
| total_net_cash_flow_type | Unknown |  |
| total_net_cash_flow_unit | Unknown |  |
| total_net_rent_magnitude | Unknown |  |
| total_net_rent_money_unit | Unknown |  |
| total_net_rent_type | Unknown |  |
| total_net_rent_unit | Unknown |  |
| total_term_free_rent_magnitude | Unknown |  |
| total_term_free_rent_money_unit | Unknown |  |
| total_term_free_rent_type | Unknown |  |
| total_term_free_rent_unit | Unknown |  |
| updated_at | Instant |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| current_sign_in_at | Unknown |  |
| disabled | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_account_user | Unknown |  |
| is_company_admin | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| phone_extension | Unknown |  |
| title | Unknown |  |

### global_tenant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| globel_tenant_id | Unknown | FK |
| address | Unknown |  |
| cap_iq_id | Unknown |  |
| created_at | Unknown |  |
| industry | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### tenant_contact_lease

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

### tenant_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tenant_id | Unknown | FK |
| company_name | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| phone | Unknown |  |
| phone_extension | Unknown |  |
| title | Unknown |  |
| updated_at | Instant |  |

### space_external_system_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| space_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |

### space

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| committed_lease_id | Unknown | FK |
| in_place_lease_id | Unknown | FK |
| last_expired_lease_id | Unknown | FK |
| archived_date | Unknown |  |
| availability_date | Unknown |  |
| availability_type | Unknown |  |
| ceiling_height | Unknown |  |
| clear_height | Unknown |  |
| column_spacing | Unknown |  |
| created_at | Unknown |  |
| current_size_area_unit | Unknown |  |
| current_size_magnitude | Unknown |  |
| current_size_type | Unknown |  |
| current_size_unit | Unknown |  |
| depth | Unknown |  |
| description | Unknown |  |
| dock_height | Unknown |  |
| electrical | Unknown |  |
| floor | Unknown |  |
| floor_composition | Unknown |  |
| floor_name | Unknown |  |
| floor_position | Unknown |  |
| ground_level_door | Unknown |  |
| hvac | Unknown |  |
| hypothetical_space | Unknown |  |
| internal_note | Unknown |  |
| lease_type | Unknown |  |
| listing_date | Unknown |  |
| market_rent_magnitude | Unknown |  |
| market_rent_money_unit | Unknown |  |
| market_rent_type | Unknown |  |
| market_rent_unit | Unknown |  |
| maximum_contiguous_size_area_unit | Unknown |  |
| maximum_contiguous_size_magnitude | Unknown |  |
| maximum_contiguous_size_type | Unknown |  |
| maximum_contiguous_size_unit | Unknown |  |
| minimum_divisible_size_area_unit | Unknown |  |
| minimum_divisible_size_magnitude | Unknown |  |
| minimum_divisible_size_type | Unknown |  |
| minimum_divisible_size_unit | Unknown |  |
| occupancy_status | Unknown |  |
| office_portion | Unknown |  |
| parking | Unknown |  |
| position | Unknown |  |
| price_is_negotiable | Unknown |  |
| public | Unknown |  |
| remeasured_space_available | Unknown |  |
| rental_pay_type | Unknown |  |
| rental_rate_max_magnitude | Unknown |  |
| rental_rate_max_money_unit | Unknown |  |
| rental_rate_max_period_unit | Unknown |  |
| rental_rate_max_type | Unknown |  |
| rental_rate_max_unit | Unknown |  |
| rental_rate_min_magnitude | Unknown |  |
| rental_rate_min_money_unit | Unknown |  |
| rental_rate_min_period_unit | Unknown |  |
| rental_rate_min_type | Unknown |  |
| rental_rate_min_unit | Unknown |  |
| roof | Unknown |  |
| sale_price_magnitude | Unknown |  |
| sale_price_money_unit | Unknown |  |
| sale_price_type | Unknown |  |
| sale_price_unit | Unknown |  |
| source_id | Unknown |  |
| space_condition | Unknown |  |
| space_type | Unknown |  |
| sprinkler | Unknown |  |
| subtitle | Unknown |  |
| suite | Unknown |  |
| term_duration | Unknown |  |
| trailer_parking | Unknown |  |
| transaction_type | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |
| vacant_on_date | Unknown |  |
| yard | Unknown |  |

### finance

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_term_id | Unknown | FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| end_duration | Unknown |  |
| start_date | Unknown |  |
| start_month | Unknown |  |
| type | Unknown |  |
| updated_at | Instant |  |

### coordination_project

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tenant_id | Unknown | FK |
| created_at | Unknown |  |
| current_rent_commencement_date | Unknown |  |
| target_rent_commencement_date | Unknown |  |
| updated_at | Instant |  |

### lease_term_other_income

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |

### lease_term_free_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |

### lease_term_base_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |

### lease_term_commission_period

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_commission_index | Unknown | PK, FK |
| lease_term_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| start_date | Unknown |  |
| start_month | Unknown |  |

### lease_term_commission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| broker | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| free_rent | Unknown |  |
| net_or_gross | Unknown |  |
| type | Unknown |  |

### lease_term_cost

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| description | Unknown |  |
| occurrence_month | Unknown |  |
| type | Unknown |  |

### lease_term_reimbursable_expense

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |
| type | Unknown |  |

### lease_term_percentage_rent

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| amount_area_unit | Unknown |  |
| amount_magnitude | Unknown |  |
| amount_money_unit | Unknown |  |
| amount_period_unit | Unknown |  |
| amount_type | Unknown |  |
| amount_unit | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |

### lease_term_space

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| lease_term_id | Unknown | PK, FK |
| id | Unknown | FK |
| space_id | Unknown |  |

### lease_term

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | FK |
| commencement_date | Unknown |  |
| created_at | Unknown |  |
| deal_type | Unknown |  |
| description | Unknown |  |
| downtime_iso_8601 | Unknown |  |
| downtime_magnitude | Unknown |  |
| downtime_period_unit | Unknown |  |
| downtime_type | Unknown |  |
| downtime_unit | Unknown |  |
| entered_date | Unknown |  |
| estimated_sale_magnitude | Unknown |  |
| estimated_sale_money_unit | Unknown |  |
| estimated_sale_period_unit | Unknown |  |
| estimated_sale_type | Unknown |  |
| estimated_sale_unit | Unknown |  |
| execution_date | Unknown |  |
| expiration_date | Unknown |  |
| expiring_base_rent_area_unit | Unknown |  |
| expiring_base_rent_magnitude | Unknown |  |
| expiring_base_rent_money_unit | Unknown |  |
| expiring_base_rent_period_unit | Unknown |  |
| expiring_base_rent_type | Unknown |  |
| expiring_base_rent_unit | Unknown |  |
| expiring_gross_rent_area_unit | Unknown |  |
| expiring_gross_rent_magnitude | Unknown |  |
| expiring_gross_rent_money_unit | Unknown |  |
| expiring_gross_rent_period_unit | Unknown |  |
| expiring_gross_rent_type | Unknown |  |
| expiring_gross_rent_unit | Unknown |  |
| gaap_rent_magnitude | Unknown |  |
| gaap_rent_money_unit | Unknown |  |
| gaap_rent_type | Unknown |  |
| gaap_rent_unit | Unknown |  |
| in_place_base_rent_area_unit | Unknown |  |
| in_place_base_rent_magnitude | Unknown |  |
| in_place_base_rent_money_unit | Unknown |  |
| in_place_base_rent_period_unit | Unknown |  |
| in_place_base_rent_type | Unknown |  |
| in_place_base_rent_unit | Unknown |  |
| in_place_gross_rent_area_unit | Unknown |  |
| in_place_gross_rent_magnitude | Unknown |  |
| in_place_gross_rent_money_unit | Unknown |  |
| in_place_gross_rent_period_unit | Unknown |  |
| in_place_gross_rent_type | Unknown |  |
| in_place_gross_rent_unit | Unknown |  |
| is_month_to_month | Unknown |  |
| lease_type | Unknown |  |
| lock_in_end_date | Unknown |  |
| move_out_date | Unknown |  |
| natural_breakpoint_magnitude | Unknown |  |
| natural_breakpoint_money_unit | Unknown |  |
| natural_breakpoint_period_unit | Unknown |  |
| natural_breakpoint_type | Unknown |  |
| natural_breakpoint_unit | Unknown |  |
| possession_date | Unknown |  |
| rent_commencement_date | Unknown |  |
| rentable_size_area_unit | Unknown |  |
| rentable_size_magnitude | Unknown |  |
| rentable_size_type | Unknown |  |
| rentable_size_unit | Unknown |  |
| retail_description | Unknown |  |
| retail_growth_rate | Unknown |  |
| retail_percent_rent | Unknown |  |
| source_id | Unknown |  |
| structure | Unknown |  |
| tenant_buildout_period_iso_8601 | Unknown |  |
| tenant_buildout_period_magnitude | Unknown |  |
| tenant_buildout_period_period_unit | Unknown |  |
| tenant_buildout_period_type | Unknown |  |
| tenant_buildout_period_unit | Unknown |  |
| term_duration_iso_8601 | Unknown |  |
| term_duration_magnitude | Unknown |  |
| term_duration_period_unit | Unknown |  |
| term_duration_type | Unknown |  |
| term_duration_unit | Unknown |  |
| term_type | Unknown |  |
| unnatural_breakpoint_magnitude | Unknown |  |
| unnatural_breakpoint_money_unit | Unknown |  |
| unnatural_breakpoint_period_unit | Unknown |  |
| unnatural_breakpoint_type | Unknown |  |
| unnatural_breakpoint_unit | Unknown |  |
| updated_at | Instant |  |

### retail_sale

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| end_date | Unknown |  |
| start_date | Unknown |  |
| updated_at | Instant |  |

### tenant_industry

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| name | Unknown |  |
| sector | Unknown |  |
| updated_at | Instant |  |

### asset_property_fund

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| property_fund | Unknown |  |

### asset_external_system_info

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| id | Unknown |  |
| name | Unknown |  |

### asset_year_renovated

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| year_renovated | Unknown |  |

### asset_asset_manager

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| asset_manager | Unknown |  |

### asset_jv_partner

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| jv_partner | Unknown |  |

### asset_client

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| asset_id | Unknown | PK, FK |
| client | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown |  |
| account_name | Unknown |  |
| address_country | Unknown |  |
| address_formatted | Unknown |  |
| address_locality | Unknown |  |
| address_postal_code | Unknown |  |
| address_region | Unknown |  |
| address_street | Unknown |  |
| building_class | Unknown |  |
| building_region | Unknown |  |
| created_at | Unknown |  |
| currency | Unknown |  |
| description | Unknown |  |
| has_industrial_space | Unknown |  |
| has_office_space | Unknown |  |
| has_retail_space | Unknown |  |
| lease_roll | Unknown |  |
| lease_vacant_area_magnitude | Unknown |  |
| lease_vacant_area_type | Unknown |  |
| lease_vacant_area_unit | Unknown |  |
| leasing_company | Unknown |  |
| legal_entity | Unknown |  |
| managing_company | Unknown |  |
| market | Unknown |  |
| multi_building_asset_id | Unknown |  |
| multi_building_asset_type | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| number_of_floors | Unknown |  |
| owner | Unknown |  |
| owning_company | Unknown |  |
| photo_url | Unknown |  |
| rentable_building_area_magnitude | Unknown |  |
| rentable_building_area_type | Unknown |  |
| rentable_building_area_unit | Unknown |  |
| size_area_unit | Unknown |  |
| size_magnitude | Unknown |  |
| size_type | Unknown |  |
| size_unit | Unknown |  |
| source_id | Unknown |  |
| space_available_area_unit | Unknown |  |
| space_available_magnitude | Unknown |  |
| space_available_type | Unknown |  |
| space_available_unit | Unknown |  |
| sub_market | Unknown |  |
| updated_at | Instant |  |
| video_thumbnail | Unknown |  |
| year_built | Unknown |  |

### tenant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| global_tenant_id | Unknown | FK |
| primary_tenant_id | Unknown | FK |
| tenant_industry_id | Unknown | FK |
| created_at | Unknown |  |
| global_tenant_name | Unknown |  |
| name | Unknown |  |
| updated_at | Instant |  |

### delinquency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lease_id | Unknown | FK |
| charge_date | Unknown |  |
| charge_type | Unknown |  |
| created_at | Unknown |  |
| current_amount | Unknown |  |
| payment_date | Unknown |  |
| total_amount | Unknown |  |
| updated_at | Instant |  |

### deal_asset

| Column | Type | Keys |
| --- | --- | --- |
| asset_id | Unknown | PK, FK |
| deal_id | Unknown | PK, FK |

### deal_space

| Column | Type | Keys |
| --- | --- | --- |
| deal_id | Unknown | PK, FK |
| space_id | Unknown | PK, FK |

### deal_broker

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| deal_id | Unknown | PK, FK |
| company | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| phone_extension | Unknown |  |

### deal_contact

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_id | Unknown | PK, FK |
| company | Unknown |  |
| email | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |

### deal_target_location

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| deal_id | Unknown | PK, FK |
| country | Unknown |  |
| formatted | Unknown |  |
| locality | Unknown |  |
| postal_code | Unknown |  |
| region | Unknown |  |

### deal

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| comparative_lease_term_id | Unknown | FK |
| coordination_project_id | Unknown | FK |
| created_by_id | Unknown | FK |
| latest_proposal_id | Unknown | FK |
| tenant_id | Unknown | FK |
| tenant_industry_id | Unknown | FK |
| comment | Unknown |  |
| competitive_set | Unknown |  |
| created_at | Unknown |  |
| deal_type | Unknown |  |
| is_private | Unknown |  |
| probability | Unknown |  |
| requirement_commencement_date | Unknown |  |
| requirement_inquiry_type | Unknown |  |
| requirement_retail_deal_type | Unknown |  |
| requirement_size_area_unit | Unknown |  |
| requirement_size_maximum | Unknown |  |
| requirement_size_minimum | Unknown |  |
| requirement_size_type | Unknown |  |
| requirement_size_unit | Unknown |  |
| requirement_space_type | Unknown |  |
| stage | Unknown |  |
| target_rent_maximum | Unknown |  |
| target_rent_minimum | Unknown |  |
| target_rent_money_unit | Unknown |  |
| target_rent_type | Unknown |  |
| target_rent_unit | Unknown |  |
| total_size_area_unit | Unknown |  |
| total_size_magnitude | Unknown |  |
| total_size_type | Unknown |  |
| total_size_unit | Unknown |  |
| updated_at | Instant |  |

### lease

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| tenant_id | Unknown | FK |
| commencement_date | Unknown |  |
| created_at | Unknown |  |
| execution_date | Unknown |  |
| expiration_date | Unknown |  |
| industry | Unknown |  |
| renewal_status | Unknown |  |
| source_id | Unknown |  |
| structure | Unknown |  |
| updated_at | Instant |  |

## Relationships

- approval_approver(approver_user_id) → users(id)
- approval_approver(approval_id) → approval(id)
- approval(deal_id) → deal(id)
- approval(requester_id) → users(id)
- approval(proposal_id) → proposal(id)
- proposal(deal_id) → deal(id)
- tenant_update_contact(tenant_contact_id) → tenant_contact(id)
- tenant_update_contact(tenant_update_id) → tenant_update(id)
- tenant_update(owner_id) → users(id)
- tenant_update(tenant_id) → tenant(id)
- tenant_update(created_by_id) → users(id)
- tenant_update(asset_id) → asset(id)
- coordination_project_milestone(completed_by_id) → users(id)
- appraisal_reimbursable_expense(appraisal_id) → appraisal(id)
- appraisal_base_rent(appraisal_id) → appraisal(id)
- appraisal_commission_period(appraisal_commission_index) → appraisal_commission(index)
- appraisal_commission_period(appraisal_id) → appraisal_commission(appraisal_id)
- appraisal_commission(appraisal_id) → appraisal(id)
- appraisal_cost(appraisal_id) → appraisal(id)
- appraisal_free_rent(appraisal_id) → appraisal(id)
- appraisal_rent_escalation(appraisal_id) → appraisal(id)
- blended_budget(deal_id) → deal(id)
- deal_task(deal_id) → deal(id)
- deal_task(assignee_id) → users(id)
- deal_task(completed_by_id) → users(id)
- deal_comment(deal_id) → deal(id)
- deal_comment(iteration_id) → deal_iteration(id)
- deal_comment(user_id) → users(id)
- option_target(space_id) → space(id)
- option_target(option_id) → option(id)
- option(lease_term_id) → lease_term(id)
- option(proposal_id) → proposal(id)
- budget_commission_period(budget_commission_index) → budget_commission(index)
- budget_commission_period(budget_id) → budget_commission(budget_id)
- budget_commission(budget_id) → budget(id)
- budget_rent_escalation(budget_id) → budget(id)
- budget_base_rent(budget_id) → budget(id)
- budget_free_rent(budget_id) → budget(id)
- budget_percentage_rent_sales_overage_breakpoint(budget_id) → budget_percentage_rent(budget_id)
- budget_percentage_rent_sales_overage_breakpoint(budget_percentage_rent_index) → budget_percentage_rent(index)
- budget_percentage_rent(budget_id) → budget(id)
- budget_other_income(budget_id) → budget(id)
- budget_reimbursabl_expense(budget_id) → budget(id)
- budget_cost(budget_id) → budget(id)
- budget_rent_schedule(budget_id) → budget(id)
- budget(asset_id) → asset(id)
- budget(space_id) → space(id)
- budget(blended_budget_id) → blended_budget(id)
- deal_tour_space(space_id) → space(id)
- deal_tour_space(deal_tour_id) → deal_tour(id)
- deal_tour(deal_id) → deal(id)
- deal_tour(user_id) → users(id)
- deal_iteration(user_id) → users(id)
- deal_iteration(deal_id) → deal(id)
- deal_term_commission_period(deal_term_commission_index) → deal_term_commission(index)
- deal_term_commission_period(deal_term_id) → deal_term_commission(deal_term_id)
- deal_term_commission(deal_term_id) → deal_term(id)
- deal_term_rent_escalation(deal_term_id) → deal_term(id)
- deal_term_base_rent(deal_term_id) → deal_term(id)
- deal_term_free_rent(deal_term_id) → deal_term(id)
- deal_term_cost(deal_term_id) → deal_term(id)
- deal_term_rent_schedule(deal_term_id) → deal_term(id)
- deal_term_other_income(deal_term_id) → deal_term(id)
- deal_term_remaining_lease_obligation(deal_term_id) → deal_term(id)
- deal_term_reimbursabl_expense(deal_term_id) → deal_term(id)
- deal_term(deal_id) → deal(id)
- deal_term(proposal_id) → proposal(id)
- deal_term(space_id) → space(id)
- global_tenant(globel_tenant_id) → global_tenant(id)
- tenant_contact_lease(lease_id) → lease(id)
- tenant_contact_lease(tenant_contact_id) → tenant_contact(id)
- tenant_contact(tenant_id) → tenant(id)
- space_external_system_info(space_id) → space(id)
- space(in_place_lease_id) → lease(id)
- space(committed_lease_id) → lease(id)
- space(last_expired_lease_id) → lease(id)
- space(asset_id) → asset(id)
- finance(deal_term_id) → deal_term(id)
- coordination_project(tenant_id) → tenant(id)
- lease_term_other_income(lease_term_id) → lease_term(id)
- lease_term_free_rent(lease_term_id) → lease_term(id)
- lease_term_base_rent(lease_term_id) → lease_term(id)
- lease_term_commission_period(lease_term_commission_index) → lease_term_commission(index)
- lease_term_commission_period(lease_term_id) → lease_term_commission(lease_term_id)
- lease_term_commission(lease_term_id) → lease_term(id)
- lease_term_cost(lease_term_id) → lease_term(id)
- lease_term_reimbursable_expense(lease_term_id) → lease_term(id)
- lease_term_percentage_rent(lease_term_id) → lease_term(id)
- lease_term_space(lease_term_id) → lease_term(id)
- lease_term_space(id) → space(id)
- lease_term(lease_id) → lease(id)
- retail_sale(lease_id) → lease(id)
- asset_property_fund(asset_id) → asset(id)
- asset_external_system_info(asset_id) → asset(id)
- asset_year_renovated(asset_id) → asset(id)
- asset_asset_manager(asset_id) → asset(id)
- asset_jv_partner(asset_id) → asset(id)
- asset_client(asset_id) → asset(id)
- tenant(primary_tenant_id) → tenant(id)
- tenant(global_tenant_id) → global_tenant(id)
- tenant(tenant_industry_id) → tenant_industry(id)
- delinquency(lease_id) → lease(id)
- deal_asset(asset_id) → asset(id)
- deal_asset(deal_id) → deal(id)
- deal_space(space_id) → space(id)
- deal_space(deal_id) → deal(id)
- deal_broker(deal_id) → deal(id)
- deal_contact(deal_id) → deal(id)
- deal_target_location(deal_id) → deal(id)
- deal(comparative_lease_term_id) → lease_term(id)
- deal(latest_proposal_id) → proposal(id)
- deal(tenant_id) → tenant(id)
- deal(tenant_industry_id) → tenant_industry(id)
- deal(created_by_id) → users(id)
- deal(coordination_project_id) → coordination_project(id)
- lease(tenant_id) → tenant(id)