# ServiceTrade schema ERD

Table and field reference for the Fivetran ServiceTrade connector.

## Table & Field Reference

### invoice_recurrence_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| invoice_recurrence_id | Unknown | PK, FK |
| cost | Unknown |  |
| description | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| uri | Unknown |  |

### invoice_recurrence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | FK |
| location_id | Unknown | FK |
| service_line_id | Unknown | FK |
| created | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| customer_status | Unknown |  |
| customer_uri | Unknown |  |
| description | Unknown |  |
| ends_on | Unknown |  |
| frequency | Unknown |  |
| interval | Unknown |  |
| next_due | Unknown |  |
| uri | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |
| vendor_status | Unknown |  |
| vendor_uri | Unknown |  |

### service_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| abbr | Unknown |  |
| icon | Unknown |  |
| name | Unknown |  |
| trade | Unknown |  |

### account

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| name | Unknown |  |
| timezone | Unknown |  |
| uri | Unknown |  |
| feature_** |  |  |

### appointment_office

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | PK, FK |
| city | Unknown |  |
| email | Unknown |  |
| lat | Unknown |  |
| legacy_id | Unknown |  |
| lon | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| postal_code | Unknown |  |
| primary_contact | Unknown |  |
| ref_number | Unknown |  |
| state | Unknown |  |
| status | Unknown |  |
| street | Unknown |  |
| taxable | Unknown |  |
| uri | Unknown |  |

### appointment_service_request

| Column | Type | Keys |
| --- | --- | --- |
| appointment_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### appointment_tech

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | PK, FK |
| avatar | Json |  |
| email | Unknown |  |
| is_helper | Unknown |  |
| is_tech | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| uri | Unknown |  |

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| created | Unknown |  |
| due_by | Unknown |  |
| name | Unknown |  |
| released | Unknown |  |
| status | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |
| vendor_status | Unknown |  |
| vendor_uri | Unknown |  |
| window_end | Unknown |  |
| window_start | Unknown |  |

### quote_job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| quote_id | Unknown | PK, FK |

### quote_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| quote_id | Unknown | PK, FK |

### quote_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| quote_id | Unknown | PK, FK |
| name | Unknown |  |
| uri | Unknown |  |

### quote_service_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| quote_id | Unknown | PK, FK |

### quote_deficiency_job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| quote_id | Unknown | PK, FK |

### quote

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_office_id | Unknown | FK |
| assigned_to_id | Unknown | FK |
| contract_id | Unknown | FK |
| location_id | Unknown | FK |
| owner_id | Unknown | FK |
| quote_item_id | Unknown | FK |
| created | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| customer_po | Unknown |  |
| customer_po_required | Unknown |  |
| customer_status | Unknown |  |
| customer_uri | Unknown |  |
| deficiency_severity | Unknown |  |
| description | Unknown |  |
| expires_on | Unknown |  |
| external_ids | Json |  |
| job_type | Unknown |  |
| latest_accepted | Unknown |  |
| latest_submission | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| quote_link_attachment_visibility | Unknown |  |
| quote_link_comment_visibility | Unknown |  |
| quote_request_id | Unknown |  |
| quote_request_name | Unknown |  |
| quote_request_status | Unknown |  |
| quote_request_type | Unknown |  |
| quote_request_uri | Unknown |  |
| ref_number | Unknown |  |
| respond_by | Unknown |  |
| sales_avatar | Json |  |
| sales_email | Unknown |  |
| sales_id | Unknown |  |
| sales_is_helper | Unknown |  |
| sales_is_tech | Unknown |  |
| sales_name | Unknown |  |
| sales_status | Unknown |  |
| sales_uri | Unknown |  |
| section_visibilities | Unknown |  |
| status | Unknown |  |
| sub_status | Unknown |  |
| tasking_detail_level | Unknown |  |
| term_id | Unknown |  |
| term_name | Unknown |  |
| term_uri | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |
| vendor_status | Unknown |  |
| vendor_uri | Unknown |  |
| visibility | Json |  |

### contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| location_id | Unknown | FK |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| alternate_phone | Unknown |  |
| created | Unknown |  |
| email | Unknown |  |
| external_id_device_magic | Unknown |  |
| external_id_master_company | Unknown |  |
| external_id_migration | Unknown |  |
| external_id_new_partner_id | Unknown |  |
| external_id_sage | Unknown |  |
| external_id_sage_employee_id | Unknown |  |
| external_id_sage_test | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| mobile | Unknown |  |
| phone | Unknown |  |
| status | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| name | Unknown |  |

### user_service_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |

### user_activity

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| activity | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| account_id | Unknown | FK |
| company_id | Unknown | FK |
| location_id | Unknown | FK |
| manager_id | Unknown | FK |
| service_line_id | Unknown | FK |
| avatar | Json |  |
| created | Unknown |  |
| details | Unknown |  |
| email | Unknown |  |
| external_id | Json |  |
| first_name | Unknown |  |
| is_helper | Unknown |  |
| is_sales | Unknown |  |
| is_tech | Unknown |  |
| last_name | Unknown |  |
| mfa_required | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| status | Unknown |  |
| time_zone | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| user_name | Unknown |  |

### job_office

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |

### job_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| name | Unknown |  |
| uri | Unknown |  |

### job_appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| assigned_office_id | Unknown | FK |
| contract_id | Unknown | FK |
| current_appointment_id | Unknown | FK |
| location_id | Unknown | FK |
| owner_id | Unknown | FK |
| budgeted | Unknown |  |
| completed_on | Unknown |  |
| created | Unknown |  |
| custom_name | Unknown |  |
| customer_email | Unknown |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| customer_po | Unknown |  |
| customer_status | Unknown |  |
| customer_uri | Unknown |  |
| description | Unknown |  |
| display_status | Unknown |  |
| display_sub_status | Unknown |  |
| due_after | Unknown |  |
| due_by | Unknown |  |
| estimated_price | Unknown |  |
| external_id | Json |  |
| is_project | Unknown |  |
| ivr_activity | Unknown |  |
| ivr_open | Unknown |  |
| job_type_weight | Unknown |  |
| latest_clock_in | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| percent_complete | Unknown |  |
| primary_contact | Unknown |  |
| project | Unknown |  |
| ref_number | Unknown |  |
| sales_avatar | Json |  |
| sales_email | Unknown |  |
| sales_id | Unknown |  |
| sales_is_helper | Unknown |  |
| sales_is_tech | Unknown |  |
| sales_name | Unknown |  |
| sales_status | Unknown |  |
| sales_uri | Unknown |  |
| scheduled_date | Unknown |  |
| section_visibilities | Unknown |  |
| service_line | Unknown |  |
| service_link_attachment_category_visibility | Unknown |  |
| service_link_attachment_visibility | Unknown |  |
| service_link_comment_visibility | Unknown |  |
| status | Unknown |  |
| sub_status | Unknown |  |
| terms | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |
| vendor_status | Unknown |  |
| vendor_uri | Unknown |  |
| visibility | Json |  |

### service_recurrence_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| service_recurrence_id | Unknown | PK, FK |
| description | Unknown |  |
| uri | Unknown |  |

### service_recurrence_preferred_tech

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| service_recurrence_id | Unknown | PK, FK |
| avatar | Json |  |
| email | Unknown |  |
| is_helper | Unknown |  |
| is_tech | Unknown |  |
| name | Unknown |  |
| status | Unknown |  |
| uri | Unknown |  |

### service_recurrence

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| contract_id | Unknown | FK |
| location_id | Unknown | FK |
| service_line_id | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| ends_on | Unknown |  |
| estimated_price | Unknown |  |
| first_end | Unknown |  |
| first_start | Unknown |  |
| frequency | Unknown |  |
| frequency_category | Unknown |  |
| interval | Unknown |  |
| parent | Unknown |  |
| preferred_start_time | Unknown |  |
| preferred_vendor | Unknown |  |
| repeat_weekday | Unknown |  |
| scheduling_type | Unknown |  |
| tasking_duration | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

### lib_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| service_line_id | Unknown | FK |
| active | Unknown |  |
| code | Unknown |  |
| cost | Unknown |  |
| created | Unknown |  |
| external_id | Json |  |
| is_generic | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| price_rule_type | Unknown |  |
| taxable | Unknown |  |
| type | Unknown |  |
| type_id | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

### company_service_line_provided

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | PK, FK |
| abbr | Unknown |  |
| icon | Unknown |  |
| name | Unknown |  |
| trade | Unknown |  |

### company

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| created | Unknown |  |
| customer | Unknown |  |
| default_brand | Unknown |  |
| external_id_device_magic | Unknown |  |
| external_id_master_company | Unknown |  |
| external_id_migration | Unknown |  |
| external_id_new_partner_id | Unknown |  |
| external_id_sage | Unknown |  |
| external_id_sage_employee_id | Unknown |  |
| external_id_sage_test | Unknown |  |
| logo_aspect | Unknown |  |
| logo_content_url | Unknown |  |
| logo_id | Unknown |  |
| logo_uri | Unknown |  |
| managing_account | Unknown |  |
| name | Unknown |  |
| parts_vendor | Unknown |  |
| phone_number | Unknown |  |
| prime_contractor | Unknown |  |
| ref_number | Unknown |  |
| share_id | Unknown |  |
| status | Unknown |  |
| tags | Json |  |
| updated | Unknown |  |
| uri | Unknown |  |
| vendor | Unknown |  |

### service_request_preferred_vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| service_request_id | Unknown | PK, FK |

### service_request_preferred_tech

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| service_request_id | Unknown | PK, FK |

### service_request

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| contract_id | Unknown | FK |
| deficiency_id | Unknown | FK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| service_line_id | Unknown | FK |
| service_recurrence_id | Unknown | FK |
| budget | Unknown |  |
| change_order | Unknown |  |
| change_order_id | Unknown |  |
| change_order_reference_number | Unknown |  |
| change_order_status | Unknown |  |
| change_order_type | Unknown |  |
| change_order_uri | Unknown |  |
| closed_on | Unknown |  |
| created | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| estimated_price | Unknown |  |
| original_window_end | Unknown |  |
| original_window_start | Unknown |  |
| preferred_start_time | Unknown |  |
| quote_link_attachment_visibility | Unknown |  |
| quote_link_comment_visibility | Unknown |  |
| quote_requests | Json |  |
| service_link_attachment_category_visibility | Unknown |  |
| service_link_attachment_visibility | Unknown |  |
| service_link_comment_visibility | Unknown |  |
| status | Unknown |  |
| task_instances | Json |  |
| task_lists | Json |  |
| updated | Unknown |  |
| uri | Unknown |  |
| visibility | Json |  |
| window_end | Unknown |  |
| window_start | Unknown |  |

### deficiency

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| owner_id | Unknown | FK |
| service_line_id | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| external_id | Json |  |
| last_reported_status | Unknown |  |
| proposed_fix | Unknown |  |
| ref_number | Unknown |  |
| report_source | Unknown |  |
| reported_on | Unknown |  |
| reporter_avatar | Json |  |
| reporter_email | Unknown |  |
| reporter_id | Unknown |  |
| reporter_is_helper | Unknown |  |
| reporter_is_tech | Unknown |  |
| reporter_name | Unknown |  |
| reporter_status | Unknown |  |
| reporter_uri | Unknown |  |
| resolution | Unknown |  |
| sales_avatar | Json |  |
| sales_email | Unknown |  |
| sales_id | Unknown |  |
| sales_is_helper | Unknown |  |
| sales_is_tech | Unknown |  |
| sales_name | Unknown |  |
| sales_status | Unknown |  |
| sales_uri | Unknown |  |
| severity | Unknown |  |
| status | Unknown |  |
| title | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| visibility | Json |  |

### location_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | PK, FK |
| name | Unknown |  |
| uri | Unknown |  |

### location_office

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |

### location

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_id | Unknown | FK |
| primary_contact_id | Unknown | FK |
| address_city | Unknown |  |
| address_postal_code | Unknown |  |
| address_state | Unknown |  |
| address_street | Unknown |  |
| brand | Unknown |  |
| created | Unknown |  |
| distance | Unknown |  |
| email | Unknown |  |
| external_id | Json |  |
| general_manager | Unknown |  |
| geo_code_quality | Unknown |  |
| lat | Unknown |  |
| legacy_id | Unknown |  |
| lon | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| ref_number | Unknown |  |
| remit_to_address_city | Unknown |  |
| remit_to_address_email | Unknown |  |
| remit_to_address_phone | Unknown |  |
| remit_to_address_postal_code | Unknown |  |
| remit_to_address_state | Unknown |  |
| remit_to_address_street | Unknown |  |
| remit_to_source | Unknown |  |
| status | Unknown |  |
| store_number | Unknown |  |
| tax_group_code | Unknown |  |
| tax_group_combined_rate | Unknown |  |
| tax_group_id | Unknown |  |
| tax_group_name | Unknown |  |
| tax_group_state | Unknown |  |
| tax_group_uri | Unknown |  |
| taxable | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | FK |
| location_id | Unknown | FK |
| assigned_office_city | Unknown |  |
| assigned_office_id | Unknown |  |
| assigned_office_lat | Unknown |  |
| assigned_office_legacy_id | Unknown |  |
| assigned_office_lon | Unknown |  |
| assigned_office_name | Unknown |  |
| assigned_office_phone_number | Unknown |  |
| assigned_office_postal_code | Unknown |  |
| assigned_office_primary_contact | Unknown |  |
| assigned_office_ref_number | Unknown |  |
| assigned_office_state | Unknown |  |
| assigned_office_status | Unknown |  |
| assigned_office_street | Unknown |  |
| assigned_office_taxable | Unknown |  |
| assigned_office_uri | Unknown |  |
| assigned_user | Unknown |  |
| contract | Unknown |  |
| created | Unknown |  |
| customer_external_id | Json |  |
| customer_id | Unknown |  |
| customer_name | Unknown |  |
| customer_po | Unknown |  |
| customer_status | Unknown |  |
| customer_uri | Unknown |  |
| due_date | Unknown |  |
| invoice_number | Unknown |  |
| name | Unknown |  |
| notes | Unknown |  |
| paid | Unknown |  |
| partial | Unknown |  |
| payment_terms | Unknown |  |
| ref_number | Unknown |  |
| sent | Unknown |  |
| status | Unknown |  |
| sub_status | Unknown |  |
| tags | Json |  |
| tax_amount | Unknown |  |
| term_id | Unknown |  |
| term_name | Unknown |  |
| term_uri | Unknown |  |
| transaction_date | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |
| vendor_status | Unknown |  |
| vendor_uri | Unknown |  |
| visibility | Json |  |

### contract_rule_lib_item

| Column | Type | Keys |
| --- | --- | --- |
| contract_rule_id | Unknown | PK, FK |
| id | Unknown | PK, FK |

### contract_rule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | FK |
| service_line_id | Unknown | FK |
| created | Unknown |  |
| name | Unknown |  |
| price | Unknown |  |
| threshold | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

### asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| location_id | Unknown | FK |
| service_line_id | Unknown | FK |
| asset_definition_display | Unknown |  |
| asset_definition_id | Unknown |  |
| asset_definition_type | Unknown |  |
| asset_definition_uri | Unknown |  |
| created | Unknown |  |
| display | Unknown |  |
| external_id_device_magic | Unknown |  |
| external_id_master_company | Unknown |  |
| external_id_migration | Unknown |  |
| external_id_new_partner_id | Unknown |  |
| external_id_sage | Unknown |  |
| external_id_sage_employee_id | Unknown |  |
| external_id_sage_test | Unknown |  |
| has_active_task_list | Unknown |  |
| is_abstract_group | Unknown |  |
| legacy_id | Unknown |  |
| name | Unknown |  |
| order_index | Unknown |  |
| parent_id | Unknown |  |
| parent_name | Unknown |  |
| parent_type | Unknown |  |
| parent_uri | Unknown |  |
| properties_area | Unknown |  |
| properties_barcode | Unknown |  |
| properties_device_manufacturer | Unknown |  |
| properties_device_model | Unknown |  |
| properties_device_number | Unknown |  |
| properties_device_range | Unknown |  |
| properties_device_type | Unknown |  |
| properties_device_zone_address | Unknown |  |
| properties_location_in_site | Unknown |  |
| properties_serial | Unknown |  |
| properties_system_name | Unknown |  |
| status | Unknown |  |
| task_list | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

### quote_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lib_item_id | Unknown | FK |
| quote_id | Unknown | FK |
| service_line_id | Unknown | FK |
| service_request_id | Unknown | FK |
| cost | Unknown |  |
| description | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| tax_rate | Unknown |  |
| tax_rate_details | Json |  |
| uri | Unknown |  |
| visibility | Json |  |

### clock_event_unpaired_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| clock_event_id | Unknown | PK, FK |
| appointment_id | Unknown | FK |
| job_id | Unknown | FK |
| user_id | Unknown | FK |
| activity | Unknown |  |
| caller_id_name | Unknown |  |
| caller_id_num | Unknown |  |
| completed | Unknown |  |
| deficiency | Unknown |  |
| event_time | Unknown |  |
| event_type | Unknown |  |
| lat | Unknown |  |
| lon | Unknown |  |
| other_trade_deficiency | Unknown |  |
| red_tag | Unknown |  |
| source | Unknown |  |
| started | Unknown |  |
| uri | Unknown |  |

### clock_event

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| appointment_id | Unknown | FK |
| end_job_id | Unknown | FK |
| end_user_id | Unknown | FK |
| job_id | Unknown | FK |
| user_id | Unknown | FK |
| activity | Unknown |  |
| caller_id_name | Unknown |  |
| caller_id_num | Unknown |  |
| completed | Unknown |  |
| created | Unknown |  |
| deficiency | Unknown |  |
| elapsed_time | Unknown |  |
| end_activity | Unknown |  |
| end_appointment | Json |  |
| end_caller_id_name | Unknown |  |
| end_caller_id_num | Unknown |  |
| end_completed | Unknown |  |
| end_deficiency | Unknown |  |
| end_event_time | Unknown |  |
| end_event_type | Unknown |  |
| end_id | Unknown |  |
| end_lat | Unknown |  |
| end_lon | Unknown |  |
| end_other_trade_deficiency | Unknown |  |
| end_red_tag | Unknown |  |
| end_source | Unknown |  |
| end_started | Unknown |  |
| end_uri | Unknown |  |
| event_time | Unknown |  |
| event_type | Unknown |  |
| lat | Unknown |  |
| lon | Unknown |  |
| other_trade_deficiency | Unknown |  |
| red_tag | Unknown |  |
| source | Unknown |  |
| started | Unknown |  |
| uri | Unknown |  |

### contract_tag

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | PK, FK |
| name | Unknown |  |
| uri | Unknown |  |

### contract

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| owner_id | Unknown | FK |
| active | Unknown |  |
| actual_margin | Unknown |  |
| agreement_type | Unknown |  |
| all_items_have_costs | Unknown |  |
| complexity | Unknown |  |
| created | Unknown |  |
| customer | Unknown |  |
| customer_po | Unknown |  |
| description | Unknown |  |
| entity_filter | Unknown |  |
| expected_margin | Unknown |  |
| expected_revenue | Unknown |  |
| expires_on | Unknown |  |
| external_id | Json |  |
| invoice_detail_level | Unknown |  |
| invoice_notes | Unknown |  |
| invoice_terms | Unknown |  |
| job_terms | Unknown |  |
| job_type | Unknown |  |
| location | Unknown |  |
| location_context | Unknown |  |
| name | Unknown |  |
| office | Unknown |  |
| owner | Unknown |  |
| parent | Unknown |  |
| payment_terms_id | Unknown |  |
| payment_terms_name | Unknown |  |
| payment_terms_order_index | Unknown |  |
| payment_terms_uri | Unknown |  |
| quote_detail_level | Unknown |  |
| quote_terms | Unknown |  |
| region | Unknown |  |
| revenue | Unknown |  |
| revenue_as_of | Unknown |  |
| review_on | Unknown |  |
| sales | Unknown |  |
| starts_on | Unknown |  |
| type | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| vendor_id | Unknown |  |
| vendor_name | Unknown |  |
| vendor_status | Unknown |  |
| vendor_uri | Unknown |  |

### job_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | FK |
| lib_item_id | Unknown | FK |
| quote_item_id | Unknown | FK |
| service_line_id | Unknown | FK |
| service_request_id | Unknown | FK |
| cost | Unknown |  |
| created | Unknown |  |
| external_id | Json |  |
| name | Unknown |  |
| quantity | Unknown |  |
| source | Unknown |  |
| time_used | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| used_on | Unknown |  |
| visibility | Json |  |

### service_request_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| lib_item_id | Unknown | FK |
| service_line_id | Unknown | FK |
| service_recurrence_id | Unknown | FK |
| service_request_id | Unknown | FK |
| description | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| uri | Unknown |  |

### invoice_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | FK |
| invoice_recurrence_id | Unknown | FK |
| job_item_id | Unknown | FK |
| lib_item_id | Unknown | FK |
| service_line_id | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| job_item | Unknown |  |
| order_index | Unknown |  |
| price | Unknown |  |
| quantity | Unknown |  |
| service_request | Unknown |  |
| sub_total | Unknown |  |
| tax_amount | Unknown |  |
| tax_group | Unknown |  |
| tax_rate | Unknown |  |
| tax_rate_detail | Json |  |
| total_price | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |
| window_end | Unknown |  |
| window_start | Unknown |  |

### deficiency_report

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| asset_id | Unknown | FK |
| deficiency_id | Unknown | FK |
| job_id | Unknown | FK |
| service_line_id | Unknown | FK |
| created | Unknown |  |
| description | Unknown |  |
| proposed_fix | Unknown |  |
| report_source | Unknown |  |
| reporter_avatar | Json |  |
| reporter_email | Unknown |  |
| reporter_id | Unknown |  |
| reporter_is_helper | Unknown |  |
| reporter_is_tech | Unknown |  |
| reporter_name | Unknown |  |
| reporter_status | Unknown |  |
| reporter_uri | Unknown |  |
| severity | Unknown |  |
| status | Unknown |  |
| updated | Unknown |  |
| uri | Unknown |  |

## Relationships

- invoice_recurrence_item(id) → lib_item(id)
- invoice_recurrence_item(invoice_recurrence_id) → invoice_recurrence(id)
- invoice_recurrence(service_line_id) → service_line(id)
- invoice_recurrence(contract_id) → contract(id)
- invoice_recurrence(location_id) → location(id)
- account(company_id) → company(id)
- appointment_office(appointment_id) → appointment(id)
- appointment_service_request(id) → service_request(id)
- appointment_service_request(appointment_id) → appointment(id)
- appointment_tech(appointment_id) → appointment(id)
- appointment(job_id) → job(id)
- appointment(location_id) → location(id)
- quote_job(id) → job(id)
- quote_job(quote_id) → quote(id)
- quote_line(id) → service_line(id)
- quote_line(quote_id) → quote(id)
- quote_tag(quote_id) → quote(id)
- quote_service_request(id) → service_request(id)
- quote_service_request(quote_id) → quote(id)
- quote_deficiency_job(id) → job(id)
- quote_deficiency_job(quote_id) → quote(id)
- quote(assigned_to_id) → users(id)
- quote(owner_id) → users(id)
- quote(contract_id) → contract(id)
- quote(location_id) → location(id)
- quote(assigned_office_id) → location(id)
- quote(quote_item_id) → quote_item(id)
- contact(location_id) → location(id)
- contact(company_id) → company(id)
- user_role(users_id) → users(id)
- user_service_line(id) → service_line(id)
- user_service_line(users_id) → users(id)
- user_activity(users_id) → users(id)
- users(manager_id) → users(id)
- users(location_id) → location(id)
- users(company_id) → company(id)
- users(account_id) → account(id)
- users(service_line_id) → service_line(id)
- job_office(id) → location(id)
- job_office(job_id) → job(id)
- job_tag(job_id) → job(id)
- job_appointment(id) → appointment(id)
- job_appointment(job_id) → job(id)
- job(current_appointment_id) → appointment(id)
- job(owner_id) → users(id)
- job(contract_id) → contract(id)
- job(location_id) → location(id)
- job(assigned_office_id) → location(id)
- service_recurrence_item(service_recurrence_id) → service_recurrence(id)
- service_recurrence_preferred_tech(service_recurrence_id) → service_recurrence(id)
- service_recurrence(service_line_id) → service_line(id)
- service_recurrence(asset_id) → asset(id)
- service_recurrence(contract_id) → contract(id)
- service_recurrence(location_id) → location(id)
- lib_item(service_line_id) → service_line(id)
- lib_item(company_id) → company(id)
- company_service_line_provided(company_id) → company(id)
- service_request_preferred_vendor(id) → company(id)
- service_request_preferred_vendor(service_request_id) → service_request(id)
- service_request_preferred_tech(id) → users(id)
- service_request_preferred_tech(service_request_id) → service_request(id)
- service_request(service_line_id) → service_line(id)
- service_request(deficiency_id) → deficiency(id)
- service_request(asset_id) → asset(id)
- service_request(contract_id) → contract(id)
- service_request(job_id) → job(id)
- service_request(service_recurrence_id) → service_recurrence(id)
- service_request(location_id) → location(id)
- deficiency(service_line_id) → service_line(id)
- deficiency(owner_id) → users(id)
- deficiency(asset_id) → asset(id)
- deficiency(job_id) → job(id)
- deficiency(location_id) → location(id)
- location_tag(location_id) → location(id)
- location_office(id) → location(id)
- location(primary_contact_id) → contact(id)
- location(company_id) → company(id)
- invoice(job_id) → job(id)
- invoice(location_id) → location(id)
- contract_rule_lib_item(id) → lib_item(id)
- contract_rule_lib_item(contract_rule_id) → contract_rule(id)
- contract_rule(service_line_id) → service_line(id)
- contract_rule(contract_id) → contract(id)
- asset(service_line_id) → service_line(id)
- asset(location_id) → location(id)
- quote_item(service_line_id) → service_line(id)
- quote_item(quote_id) → quote(id)
- quote_item(lib_item_id) → lib_item(id)
- quote_item(service_request_id) → service_request(id)
- clock_event_unpaired_event(user_id) → users(id)
- clock_event_unpaired_event(appointment_id) → appointment(id)
- clock_event_unpaired_event(job_id) → job(id)
- clock_event_unpaired_event(clock_event_id) → clock_event(id)
- clock_event(user_id) → users(id)
- clock_event(appointment_id) → appointment(id)
- clock_event(job_id) → job(id)
- clock_event(end_user_id) → users(id)
- clock_event(end_job_id) → job(id)
- contract_tag(contract_id) → contract(id)
- contract(owner_id) → users(id)
- job_item(service_line_id) → service_line(id)
- job_item(lib_item_id) → lib_item(id)
- job_item(job_id) → job(id)
- job_item(quote_item_id) → quote_item(id)
- job_item(service_request_id) → service_request(id)
- service_request_item(service_line_id) → service_line(id)
- service_request_item(lib_item_id) → lib_item(id)
- service_request_item(service_recurrence_id) → service_recurrence(id)
- service_request_item(service_request_id) → service_request(id)
- invoice_item(service_line_id) → service_line(id)
- invoice_item(lib_item_id) → lib_item(id)
- invoice_item(job_item_id) → job_item(id)
- invoice_item(invoice_id) → invoice(id)
- invoice_item(invoice_recurrence_id) → invoice_recurrence(id)
- deficiency_report(service_line_id) → service_line(id)
- deficiency_report(deficiency_id) → deficiency(id)
- deficiency_report(asset_id) → asset(id)
- deficiency_report(job_id) → job(id)