# Electronic Tenant Solutions schema ERD

Table and field reference for the Fivetran Electronic Tenant Solutions connector.

## 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 | PK, FK |
| 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 | PK, FK |
| added_by | Unknown |  |
| date_added | Unknown |  |
| link | Unknown |  |
| name | Unknown |  |

### equipment_comment

| Column | Type | Keys |
| --- | --- | --- |
| equipment_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| job_id | Unknown | PK, FK |
| 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 | PK, FK |
| job_id | Unknown | PK, FK |
| frequency | Unknown |  |
| name | Unknown |  |

### user_building

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| bid | Unknown | FK |
| is_primary | Unknown |  |
| name | Unknown |  |

### user_mc_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| code | Unknown |  |
| name | Unknown |  |
| permission | Unknown |  |
| value | Unknown |  |

### user_mtm_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| code | Unknown |  |
| html_name | Unknown |  |
| name | Unknown |  |
| permission | Unknown |  |
| value | Unknown |  |

### user_tc_permission

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| user_id | Unknown | PK, FK |
| 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 | PK, FK |
| task_id | Unknown | FK |
| date | Unknown |  |
| email | Unknown |  |
| status | Unknown |  |
| update | Unknown |  |

### job_task

| Column | Type | Keys |
| --- | --- | --- |
| job_id | Unknown | PK, FK |
| task_id | Unknown | PK, FK |
| date | Unknown |  |
| designees | Unknown |  |
| frequency | Unknown |  |

### reservation_attachment

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| reservation_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| task_id | Unknown | FK |
| comment | Unknown |  |
| date | Unknown |  |

### reservation_detail

| Column | Type | Keys |
| --- | --- | --- |
| reservation_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 |  |

## Relationships

- groups(building_id) → building(id)
- reservation_communication_log(reservation_id) → reservation(id)
- reservation(amenity_name) → amenity(name)
- reservation(building_name) → building(name)
- reservation(company_name) → company(name)
- reservation(amenity_id) → amenity(id)
- amenity_attachment(amenity_id) → amenity(id)
- equipment_comment(task_id) → task(id)
- equipment_comment(job_id) → job(id)
- equipment_comment(equipment_id) → equipment(id)
- certificate_attachment(certificate_id) → certificate(id)
- task_designee(job_id) → job(id)
- task_designee(task_id) → task(id)
- request_designee(user_id) → users(id)
- request_designee(request_id) → request(id)
- job(equipment_name) → equipment(name)
- job(building_name) → building(name)
- task(user_id) → users(id)
- task(job_id) → job(id)
- task(building_name) → equipment(name)
- task(job_name) → job(id)
- equipment_update(job_id) → job(id)
- equipment_update(task_id) → task(id)
- equipment_update(equipment_id) → equipment(id)
- company(building_id) → building(id)
- equipment_job(job_id) → job(id)
- equipment_job(equipment_id) → equipment(id)
- user_building(bid) → building(id)
- user_building(user_id) → users(id)
- user_mc_permission(user_id) → users(id)
- user_mtm_permission(user_id) → users(id)
- user_tc_permission(user_id) → users(id)
- user_sms_message(user_id) → users(id)
- users(building_id) → building(id)
- users(company_id) → company(id)
- job_update(job_id) → job(id)
- job_update(task_id) → task(id)
- job_task(task_id) → task(id)
- job_task(job_id) → job(id)
- reservation_attachment(reservation_id) → reservation(id)
- certificate(building_name) → building(name)
- certificate(company_name) → company(name)
- amenity(building_name) → building(name)
- amenity_detail_scheduled_closing(amenity_detail_name) → amenity_detail(name)
- amenity_detail_scheduled_closing(amenity_detail_id) → amenity_detail(amenity_id)
- amenity_detail(amenity_id) → amenity(id)
- job_detail_additional_information(job_id) → job_detail(job_id)
- job_custom(job_id) → job(id)
- job_detail(client_bid) → building(client_building_id)
- job_detail(equipment_id) → equipment(id)
- job_detail(id) → job(id)
- certificate_detail(certificate_id) → certificate(id)
- reservation_schedule(reservation_id) → reservation(id)
- request_log(request_id) → request(id)
- request_billable_item(id) → request(id)
- request(created_by_user_id) → users(id)
- request(building_id) → building(id)
- request(company_name) → company(name)
- job_comment(job_id) → job(id)
- job_comment(task_id) → task(id)
- reservation_detail(reservation_id) → reservation(id)
- service_type(accounting_id) → request_billable_item(accounting_id)
- reservation_billable_item(reservation_id) → reservation(id)
- certificate_email_history(certificate_id) → certificate(id)
- request_hold_time(id) → request(id)
- history(user_id) → users(id)
- history(added_by) → users(user_name)
- history(company_name) → company(name)