Electronic Tenant Solutions

Explore the interactive ERD

Table & Field Reference

groups

Column	Type	Keys
`id`	Unknown	PK
`building_id`	Unknown	FK
`description`	Unknown
`name`	Unknown
`subscription_notification`	Unknown

reservation_communication_log

Column	Type	Keys
`_fivetran_id`	String	PK
`reservation_id`	Unknown	PKFK
`date`	Unknown
`message`	Unknown
`shared_with_user`	Unknown
`updated_by`	Unknown

reservation

Column	Type	Keys
`id`	Unknown	PK
`amenity_id`	Unknown	FK
`amenity_name`	Unknown	FK
`building_name`	Unknown	FK
`company_name`	Unknown	FK
`archived`	Unknown
`billable_status`	Unknown
`flagged`	Unknown
`name`	Unknown
`number_of_days`	Unknown
`shared`	Unknown
`start_date`	Unknown
`submitted_by`	Unknown
`updated`	Unknown

amenity_attachment

Column	Type	Keys
`_fivetran_id`	String	PK
`amenity_id`	Unknown	PKFK
`added_by`	Unknown
`date_added`	Unknown
`link`	Unknown
`name`	Unknown

equipment_comment

Column	Type	Keys
`equipment_id`	Unknown	PKFK
`task_id`	Unknown	PKFK
`job_id`	Unknown	FK
`comment`	Unknown
`date`	Unknown
`email`	Unknown
`job_status`	Unknown
`task_status`	Unknown

certificate_attachment

Column	Type	Keys
`_fivetran_id`	String	PK
`certificate_id`	Unknown	FK
`link`	Unknown
`name`	Unknown

task_designee

Column	Type	Keys
`id`	Unknown	PK
`task_id`	Unknown	PKFK
`job_id`	Unknown	FK
`assigned_date`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`notes`	Unknown
`status`	Unknown
`task_time`	Unknown
`updated_date`	Unknown
`user_type`	Unknown
`custom_`

request_designee

Column	Type	Keys
`request_id`	Unknown	PKFK
`user_id`	Unknown	PKFK
`date_assigned`	Unknown
`priority`	Unknown

job

Column	Type	Keys
`id`	Unknown	PK
`building_name`	Unknown	FK
`equipment_name`	Unknown	FK
`after_hours`	Unknown
`archived`	Unknown
`auto_renewal`	Unknown
`ends`	Unknown
`frequency`	Unknown
`job_type`	Unknown
`starts`	Unknown
`template`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`building_name`	Unknown	FK
`job_id`	Unknown	FK
`job_name`	Unknown	FK
`user_id`	Unknown	FK
`completed_date`	Unknown
`due_date`	Unknown
`equipment_name`	Unknown
`estimated_time`	Unknown
`systems`	Unknown
`task_priority`	Unknown
`task_status`	Unknown
`total_task_time`	Unknown

equipment_update

Column	Type	Keys
`equipment_id`	Unknown	PKFK
`job_id`	Unknown	PKFK
`task_id`	Unknown	FK
`date`	Unknown
`email`	Unknown
`status`	Unknown
`update`	Unknown

company

Column	Type	Keys
`id`	Unknown	PK
`building_id`	Unknown	FK
`identifier`	Unknown
`name`	Unknown

equipment_job

Column	Type	Keys
`equipment_id`	Unknown	PKFK
`job_id`	Unknown	PKFK
`frequency`	Unknown
`name`	Unknown

user_building

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`bid`	Unknown	FK
`is_primary`	Unknown
`name`	Unknown

user_mc_permission

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown
`permission`	Unknown
`value`	Unknown

user_mtm_permission

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`code`	Unknown
`html_name`	Unknown
`name`	Unknown
`permission`	Unknown
`value`	Unknown

user_tc_permission

Column	Type	Keys
`index`	Unknown	PK
`user_id`	Unknown	PKFK
`code`	Unknown
`name`	Unknown
`permission`	Unknown
`value`	Unknown

user_sms_message

Column	Type	Keys
`id`	Unknown	PK
`user_id`	Unknown	FK
`date_added`	Unknown
`message`	Unknown
`sms_number`	Unknown
`type`	Unknown
`viewed`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`building_id`	Unknown	FK
`company_id`	Unknown	FK
`emergency_phone`	Unknown
`fax`	Unknown
`first_name`	Unknown
`floor`	Unknown
`job_title`	Unknown
`last_name`	Unknown
`lease_id`	Unknown
`messages`	Json
`mobile_phone`	Unknown
`phone`	Unknown
`primary_email`	Unknown
`secondary_email`	Unknown
`suite`	Unknown
`tertiary_email`	Unknown
`timezone`	Unknown
`user_name`	Unknown
`user_photo`	Unknown
`user_type`	Unknown
`custom_`

job_update

Column	Type	Keys
`job_id`	Unknown	PKFK
`task_id`	Unknown	FK
`date`	Unknown
`email`	Unknown
`status`	Unknown
`update`	Unknown

job_task

Column	Type	Keys
`job_id`	Unknown	PKFK
`task_id`	Unknown	PKFK
`date`	Unknown
`designees`	Unknown
`frequency`	Unknown

reservation_attachment

Column	Type	Keys
`name`	Unknown	PK
`reservation_id`	Unknown	PKFK
`added_by`	Unknown
`date_added`	Unknown
`link`	Unknown
`shared_with_user`	Unknown

certificate

Column	Type	Keys
`id`	Unknown	PK
`building_name`	Unknown	FK
`company_name`	Unknown	FK
`associated`	Unknown
`compliant`	Unknown
`contact`	Unknown
`general_liability_expiration`	Unknown
`nearest_expiration`	Unknown
`needs_approval`	Unknown
`status`	Unknown
`type`	Unknown
`updated`	Unknown

equipment

Column	Type	Keys
`id`	Unknown	PK
`age`	Unknown
`anticipated_lifespan`	Unknown
`building`	Unknown
`cost`	Unknown
`description`	Unknown
`installation_cost`	Unknown
`installed_date`	Unknown
`location`	Unknown
`make`	Unknown
`name`	Unknown
`notes`	Unknown
`number`	Unknown
`purchase_date`	Unknown
`replacement_cost`	Unknown
`serial_number`	Unknown
`sub_location`	Unknown
`systems`	Unknown
`type`	Unknown
`updated`	Unknown
`updates`	Json
`warranty_expiration`	Unknown
`custom_`

amenity

Column	Type	Keys
`id`	Unknown	PK
`building_name`	Unknown	FK
`available`	Unknown
`name`	Unknown
`orders`	Unknown
`reservations`	Unknown
`shared`	Unknown

amenity_detail_scheduled_closing

Column	Type	Keys
`_fivetran_id`	String	PK
`amenity_detail_id`	Unknown	FK
`amenity_detail_name`	Unknown	FK
`closing`	Unknown

amenity_detail

Column	Type	Keys
`name`	Unknown	PK
`amenity_id`	Unknown	PKFK
`allow_for_vendor_details`	Unknown
`available_days`	Unknown
`description`	Unknown
`future_reservation_limitations`	Unknown
`location`	Unknown
`max_capacity`	Unknown
`max_requestable_days`	Unknown
`minimum_edit_cancel_time`	Unknown
`minimum_notice`	Unknown
`reservation_admin_contact`	Unknown
`reservation_alerts`	Unknown
`reservation_options`	Unknown
`reservation_times`	Unknown
`setup_options`	Unknown
`time_between_reservations`	Unknown

building

Column	Type	Keys
`id`	Unknown	PK
`city`	Unknown
`client_building_id`	Unknown
`country`	Unknown
`name`	Unknown
`state`	Unknown
`street_1`	Unknown
`street_2`	Unknown
`timezone`	Unknown
`url`	Unknown
`zipcode`	Unknown

job_detail_additional_information

Column	Type	Keys
`index`	Unknown	PK
`job_id`	Unknown	PKFK
`accounting_info`	Unknown
`additional_comments`	Unknown
`estimated_down_time`	Unknown
`instructions`	Unknown
`safety_notes`	Unknown
`tenant_related`	Unknown
`tools_required`	Unknown

job_custom

Column	Type	Keys
`name`	Unknown	PK
`job_id`	Unknown	PKFK
`selected`	Unknown
`type`	Unknown

job_detail

Column	Type	Keys
`job_id`	Unknown	PK
`client_bid`	Unknown	FK
`equipment_id`	Unknown	FK
`id`	Unknown	FK
`building`	Unknown
`created`	Unknown
`date_range`	Unknown
`estimated_time`	Unknown
`location`	Unknown
`name`	Unknown
`priority`	Unknown
`sub_location`	Unknown
`systems`	Unknown
`updated`	Unknown

certificate_detail

Column	Type	Keys
`certificate_id`	Unknown	PKFK
`additional_insured_company_1`	Unknown
`additional_insured_company_2`	Unknown
`additional_insured_company_3`	Unknown
`additional_insured_company_4`	Unknown
`additional_insured_endorsement`	Unknown
`archived`	Unknown
`authorized_representative`	Unknown
`automobile_liability_any_auto`	Unknown
`automobile_liability_bodily_injury_limit`	Unknown
`automobile_liability_bodily_injury_limit_met`	Unknown
`automobile_liability_bodily_injury_limit_minimum`	Unknown
`automobile_liability_combined_single_limit`	Unknown
`automobile_liability_combined_single_limit_met`	Unknown
`automobile_liability_combined_single_limit_minimum`	Unknown
`automobile_liability_expired`	Unknown
`automobile_liability_hired_autos`	Unknown
`automobile_liability_non_owned_autos`	Unknown
`automobile_liability_occur`	Unknown
`automobile_liability_policy_effective_date`	Unknown
`automobile_liability_policy_expiration_date`	Unknown
`automobile_liability_policy_number`	Unknown
`automobile_liability_property_damage_limit`	Unknown
`automobile_liability_property_damage_limit_met`	Unknown
`automobile_liability_property_damage_limit_minimum`	Unknown
`automobile_liability_scheduled_autos`	Unknown
`automobile_liability_waiver_of_subrogation`	Unknown
`companies_affording_coverage_am_best_rating_company_a`	Unknown
`companies_affording_coverage_am_best_rating_company_b`	Unknown
`companies_affording_coverage_am_best_rating_company_c`	Unknown
`companies_affording_coverage_am_best_rating_company_d`	Unknown
`companies_affording_coverage_am_best_rating_company_e`	Unknown
`companies_affording_coverage_am_best_rating_company_f`	Unknown
`companies_affording_coverage_company_a`	Unknown
`companies_affording_coverage_company_b`	Unknown
`companies_affording_coverage_company_c`	Unknown
`companies_affording_coverage_company_d`	Unknown
`companies_affording_coverage_company_e`	Unknown
`companies_affording_coverage_company_f`	Unknown
`crime_employee_dishonesty_limit`	Unknown
`crime_employee_dishonesty_limit_met`	Unknown
`crime_employee_dishonesty_limit_minimum`	Unknown
`crime_expired`	Unknown
`crime_policy_effective_date`	Unknown
`crime_policy_number`	Unknown
`crime_policyexpirationdate`	Unknown
`cyber_liability_aggregate_limit`	Unknown
`cyber_liability_aggregate_limit_met`	Unknown
`cyber_liability_aggregate_limit_minimum`	Unknown
`cyber_liability_each_occurrence_limit`	Unknown
`cyber_liability_each_occurrence_limit_met`	Unknown
`cyber_liability_each_occurrence_limit_minimum`	Unknown
`cyber_liability_expired`	Unknown
`cyber_liability_policy_effective_date`	Unknown
`cyber_liability_policy_expiration_date`	Unknown
`cyber_liability_policy_number`	Unknown
`date_added`	Unknown
`employee_practices_insuranceaggregate_limit`	Unknown
`employee_practices_insuranceaggregate_limit_met`	Unknown
`employee_practices_insuranceaggregate_limit_minimum`	Unknown
`employee_practices_insuranceeach_occurrence_limit`	Unknown
`employee_practices_insuranceeach_occurrence_limit_met`	Unknown
`employee_practices_insuranceeach_occurrence_limit_minimum`	Unknown
`employee_practices_insuranceexpired`	Unknown
`employee_practices_insurancepolicy_effective_date`	Unknown
`employee_practices_insurancepolicy_expiration_date`	Unknown
`employee_practices_insurancepolicy_number`	Unknown
`excess_liability_aggregate_limit`	Unknown
`excess_liability_aggregate_limit_met`	Unknown
`excess_liability_aggregate_limit_minimum`	Unknown
`excess_liability_each_occurrence_limit`	Unknown
`excess_liability_each_occurrence_limit_met`	Unknown
`excess_liability_each_occurrence_limit_minimum`	Unknown
`excess_liability_expired`	Unknown
`excess_liability_other_than_umbrella_form`	Unknown
`excess_liability_policy_effective_date`	Unknown
`excess_liability_policy_expiration_date`	Unknown
`excess_liability_policy_number`	Unknown
`excess_liability_umbrella_form`	Unknown
`excess_liability_waiver_of_subrogation`	Unknown
`garage_liability_aggregate_limit`	Unknown
`garage_liability_aggregate_limit_met`	Unknown
`garage_liability_aggregate_limit_minimum`	Unknown
`garage_liability_any_auto`	Unknown
`garage_liability_auto_only_ea_accident_limit`	Unknown
`garage_liability_auto_only_ea_accident_limit_met`	Unknown
`garage_liability_auto_only_ea_accident_limit_minimum`	Unknown
`garage_liability_each_accident_limit`	Unknown
`garage_liability_each_accident_limit_met`	Unknown
`garage_liability_each_accident_limit_minimum`	Unknown
`garage_liability_expired`	Unknown
`garage_liability_other_than_auto_only_limit`	Unknown
`garage_liability_other_than_auto_only_limit_met`	Unknown
`garage_liability_other_than_auto_only_limit_minimum`	Unknown
`garage_liability_policy_effective_date`	Unknown
`garage_liability_policy_expiration_date`	Unknown
`garage_liability_policy_number`	Unknown
`garage_liability_waiver_of_subrogation`	Unknown
`general_liability_claims_made`	Unknown
`general_liability_each_occurrence_limit`	Unknown
`general_liability_each_occurrence_limit_met`	Unknown
`general_liability_each_occurrence_limit_minimum`	Unknown
`general_liability_expired`	Unknown
`general_liability_fire_damage_limit`	Unknown
`general_liability_fire_damage_limit_met`	Unknown
`general_liability_fire_damage_limit_minimum`	Unknown
`general_liability_general_aggregate_limit`	Unknown
`general_liability_general_aggregate_limit_met`	Unknown
`general_liability_general_aggregate_limit_minimum`	Unknown
`general_liability_independent_contracts`	Unknown
`general_liability_med_exp_limit`	Unknown
`general_liability_med_exp_limit_met`	Unknown
`general_liability_med_exp_limit_minimum`	Unknown
`general_liability_occur`	Unknown
`general_liability_other_limit`	Unknown
`general_liability_policy_effective_date`	Unknown
`general_liability_policy_expiration_date`	Unknown
`general_liability_policy_number`	Unknown
`general_liability_products_comp_op_agg_limit`	Unknown
`general_liability_products_comp_op_agg_limit_met`	Unknown
`general_liability_products_comp_op_agg_limit_minimum`	Unknown
`general_liability_waiver_of_subrogation`	Unknown
`insured_city`	Unknown
`insured_contact_person`	Unknown
`insured_email`	Unknown
`insured_fax`	Unknown
`insured_secondary_email`	Unknown
`insured_state`	Unknown
`insured_street_1`	Unknown
`insured_street_2`	Unknown
`insured_telephone`	Unknown
`insured_zip`	Unknown
`limits`	Unknown
`manual_compliance`	Unknown
`notification_comments`	Unknown
`notifications`	Unknown
`other`	Unknown
`personal_advertising_injuryaggregate_limit`	Unknown
`personal_advertising_injuryaggregate_limit_met`	Unknown
`personal_advertising_injuryaggregate_limit_minimum`	Unknown
`personal_advertising_injuryeach_occurrence_limit`	Unknown
`personal_advertising_injuryeach_occurrence_limit_met`	Unknown
`personal_advertising_injuryeach_occurrence_limit_minimum`	Unknown
`personal_advertising_injuryexpired`	Unknown
`personal_advertising_injurypolicy_effective_date`	Unknown
`personal_advertising_injurypolicy_expiration_date`	Unknown
`personal_advertising_injurypolicy_number`	Unknown
`producer_am_best_rating`	Unknown
`producer_city`	Unknown
`producer_company`	Unknown
`producer_contact_person`	Unknown
`producer_email`	Unknown
`producer_fax`	Unknown
`producer_state`	Unknown
`producer_street_1`	Unknown
`producer_street_2`	Unknown
`producer_telephone`	Unknown
`producer_zip`	Unknown
`professional_liability_aggregate_limit`	Unknown
`professional_liability_aggregate_limit_met`	Unknown
`professional_liability_aggregate_limit_minimum`	Unknown
`professional_liability_each_occurrence_limit`	Unknown
`professional_liability_each_occurrence_limit_met`	Unknown
`professional_liability_each_occurrence_limit_minimum`	Unknown
`professional_liability_expired`	Unknown
`professional_liability_policy_effective_date`	Unknown
`professional_liability_policy_expiration_date`	Unknown
`professional_liability_policy_number`	Unknown
`property_insurance_business_interruption`	Unknown
`property_insurance_each_occurrence_limit`	Unknown
`property_insurance_each_occurrence_limit_met`	Unknown
`property_insurance_each_occurrence_limit_minimum`	Unknown
`property_insurance_expired`	Unknown
`property_insurance_leaseholdimprovements`	Unknown
`property_insurance_policy_effective_date`	Unknown
`property_insurance_policy_expiration_date`	Unknown
`property_insurance_policy_number`	Unknown
`property_insurance_waiver_of_subrogation`	Unknown
`workers_compensation_el_disease_ea_employee_limit`	Unknown
`workers_compensation_el_disease_ea_employee_limit_met`	Unknown
`workers_compensation_el_disease_ea_employee_limit_minimum`	Unknown
`workers_compensation_el_disease_policy_limit`	Unknown
`workers_compensation_el_disease_policy_limit_met`	Unknown
`workers_compensation_el_disease_policy_limit_minimum`	Unknown
`workers_compensation_el_ea_accident_limit`	Unknown
`workers_compensation_el_ea_accident_limit_met`	Unknown
`workers_compensation_el_ea_accident_limit_minimum`	Unknown
`workers_compensation_expired`	Unknown
`workers_compensation_policy_effective_date`	Unknown
`workers_compensation_policy_expiration_date`	Unknown
`workers_compensation_policy_number`	Unknown
`workers_compensation_statutory_limits`	Unknown

reservation_schedule

Column	Type	Keys
`vendor_name`	Unknown	PK
`reservation_id`	Unknown	PKFK
`date`	Unknown
`end_time`	Unknown
`flagged`	Unknown
`start_time`	Unknown
`vendor`	Unknown
`vendor_email`	Unknown
`vendor_end_time`	Unknown
`vendor_notes`	Unknown
`vendor_phone`	Unknown
`vendor_start_time`	Unknown

request_log

Column	Type	Keys
`id`	Unknown	PK
`request_id`	Unknown	PKFK
`date`	Unknown
`email`	Unknown
`message`	Unknown
`notify_tenant`	Unknown
`request_status`	Unknown
`sent_emails`	Unknown
`type`	Unknown
`update_location`	Unknown

request_billable_item

Column	Type	Keys
`id`	Unknown	PKFK
`accounting_id`	Unknown
`date`	Unknown
`labor_acct_code`	Unknown
`labor_ch_code`	Unknown
`labor_description`	Unknown
`labor_markup`	Unknown
`labor_markup_percent`	Unknown
`labor_rate`	Unknown
`labor_tax`	Unknown
`labor_tax_percent`	Unknown
`labor_time`	Unknown
`lease_id`	Unknown
`materials_acct_code`	Unknown
`materials_chc_code`	Unknown
`materials_cost`	Unknown
`materials_description`	Unknown
`materials_markup`	Unknown
`materials_markup_percent`	Unknown
`materials_quantity`	Unknown
`materials_tax`	Unknown
`materials_tax_percent`	Unknown
`name`	Unknown
`po_number`	Unknown
`sales_tax`	Unknown
`sales_tax_percent`	Unknown

request

Column	Type	Keys
`id`	Unknown	PK
`building_id`	Unknown	FK
`company_name`	Unknown	FK
`created_by_user_id`	Unknown	FK
`billable_status`	Unknown
`contact`	Unknown
`description`	Unknown
`email`	Unknown
`location`	Unknown
`phone`	Unknown
`request_status`	Unknown
`requested_date`	Unknown
`satisfaction_rating`	Unknown
`service_type`	Unknown
`staff_finalized_date`	Unknown
`staff_finalized_status`	Unknown
`staff_finalized_time`	Unknown
`staff_initial_response_date`	Unknown
`staff_initial_response_time`	Unknown
`suite_floor`	Unknown
`updated`	Unknown
`worked_time`	Unknown
`custom_`

job_comment

Column	Type	Keys
`job_id`	Unknown	PKFK
`task_id`	Unknown	FK
`comment`	Unknown
`date`	Unknown

reservation_detail

Column	Type	Keys
`reservation_id`	Unknown	PKFK
`attendee_list`	Unknown
`attendees`	Unknown
`contact_alt_phone`	Unknown
`contact_email`	Unknown
`contact_name`	Unknown
`contact_phone`	Unknown
`date_created`	Unknown
`reservation_contact_alt_phone`	Unknown
`reservation_contact_email`	Unknown
`reservation_contact_name`	Unknown
`reservation_contact_phone`	Unknown
`reservation_options`	Unknown
`setup_options`	Unknown
`special_requests`	Unknown
`status`	Unknown
`submitted_location`	Unknown

service_type

Column	Type	Keys
`id`	Unknown	PK
`accounting_id`	Unknown	FK
`active`	Unknown
`building`	Unknown
`designees`	Unknown
`display_order`	Unknown
`name`	Unknown

reservation_billable_item

Column	Type	Keys
`lease_id`	Unknown	PK
`reservation_id`	Unknown	PKFK
`billable_note`	Unknown
`date_added`	Unknown
`description`	Unknown
`hourly_rate`	Unknown
`mark_up_dollar`	Unknown
`mark_up_percent`	Unknown
`materials_cost`	Unknown
`po_number`	Unknown
`quantity`	Unknown
`status`	Unknown
`tax_dollar`	Unknown
`tax_percent`	Unknown
`time`	Unknown
`type`	Unknown
`view_markups`	Unknown

certificate_email_history

Column	Type	Keys
`_fivetran_id`	String	PK
`certificate_id`	Unknown	FK
`date_sent`	Unknown
`email_type`	Unknown
`message`	Unknown
`receiver`	Unknown
`sender`	Unknown
`subject`	Unknown

request_hold_time

Column	Type	Keys
`request_id`	Unknown	PK
`id`	Unknown	FK
`added_by`	Unknown
`added_date`	Unknown
`end_date`	Unknown
`note`	Unknown
`reason`	Unknown
`reason_other`	Unknown
`start_date`	Unknown

history

Column	Type	Keys
`note_id`	Unknown	PK
`added_by`	Unknown	FK
`company_name`	Unknown	FK
`user_id`	Unknown	FK
`application`	Unknown
`application_record_id`	Unknown
`building`	Unknown
`communication_sent`	Unknown
`communication_subject`	Unknown
`contact`	Unknown
`date_added`	Unknown
`message`	Unknown
`title`	Unknown
`user_live`	Unknown
`user_type`	Unknown