VTS

Explore the interactive ERD

Table & Field Reference

approval_approver

Column	Type	Keys
`index`	Unknown	PK
`approval_id`	Unknown	PKFK
`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	PKFK
`tenant_update_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`appraisal_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`space_id`	Unknown	PKFK
`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	PKFK
`budget_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`budget_percentage_rent_index`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`space_id`	Unknown	PKFK

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	PKFK
`deal_term_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`end_month`	Unknown
`magnitude`	Unknown
`start_month`	Unknown
`unit`	Unknown

deal_term_other_income

Column	Type	Keys
`index`	Unknown	PK
`deal_term_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`tenant_contact_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`lease_term_id`	Unknown	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`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	PKFK
`property_fund`	Unknown

asset_external_system_info

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`id`	Unknown
`name`	Unknown

asset_year_renovated

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`year_renovated`	Unknown

asset_asset_manager

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`asset_manager`	Unknown

asset_jv_partner

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`jv_partner`	Unknown

asset_client

Column	Type	Keys
`index`	Unknown	PK
`asset_id`	Unknown	PKFK
`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	PKFK
`deal_id`	Unknown	PKFK

deal_space

Column	Type	Keys
`deal_id`	Unknown	PKFK
`space_id`	Unknown	PKFK

deal_broker

Column	Type	Keys
`id`	Unknown	PK
`deal_id`	Unknown	PKFK
`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	PKFK
`company`	Unknown
`email`	Unknown
`name`	Unknown
`phone`	Unknown

deal_target_location

Column	Type	Keys
`index`	Unknown	PK
`deal_id`	Unknown	PKFK
`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