# Leap CRM schema ERD

Table and field reference for the Fivetran Leap CRM connector.

## Table & Field Reference

### sub_contractor_additional_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| sub_contractor_id | Unknown | PK, FK |
| ext | Unknown |  |
| label | Unknown |  |
| phone | Unknown |  |

### sub_contractor_trade

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

### sub_contractor_work_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| sub_contractor_id | Unknown | PK, FK |
| trade_id | Unknown | FK |
| color | Unknown |  |
| name | Unknown |  |

### sub_contractor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| address_line_1 | Unknown |  |
| city | Unknown |  |
| color | Unknown |  |
| company_name | Unknown |  |
| country_code | Unknown |  |
| country_currency_name | Unknown |  |
| country_currency_symbol | Unknown |  |
| country_id | Unknown |  |
| country_name | Unknown |  |
| country_phone_code | Unknown |  |
| created_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| group_id | Unknown |  |
| is_active | Unknown |  |
| last_name | Unknown |  |
| note | Unknown |  |
| profile_pic | Unknown |  |
| rating | Unknown |  |
| state_code | Unknown |  |
| state_country_id | Unknown |  |
| state_id | Unknown |  |
| state_name | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### referral

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

### supplier

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

### division

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| address | Unknown |  |
| address_country_code | Unknown |  |
| address_country_id | Unknown |  |
| address_country_name | Unknown |  |
| address_id | Unknown |  |
| address_line_1 | Unknown |  |
| address_state_code | Unknown |  |
| address_state_id | Unknown |  |
| address_state_name | Unknown |  |
| city | Unknown |  |
| color | Unknown |  |
| email | Unknown |  |
| lat | Unknown |  |
| long | Unknown |  |
| name | Unknown |  |
| phone | Unknown |  |
| phone_ext | Unknown |  |
| zip | Unknown |  |

### item_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_at | Unknown |  |
| is_default | Unknown |  |
| locked | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |
| updated_at | Unknown |  |

### schedule_trade

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

### schedule_work_crew_note

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

### schedule_reminder

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| minutes | Unknown |  |
| type | Unknown |  |

### schedule_work_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| schedule_id | Unknown | PK, FK |
| trade_id | Unknown | FK |
| color | Unknown |  |
| name | Unknown |  |

### schedule_sub_contractor

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

### schedule_representative

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

### schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| customer_id | Unknown | FK |
| job_id | Unknown | FK |
| modified_by | Unknown | FK |
| created_at | Unknown |  |
| description | Unknown |  |
| end_date_time | Unknown |  |
| full_day | Unknown |  |
| is_completed | Unknown |  |
| is_recurring | Unknown |  |
| occurence | Unknown |  |
| repeat | Unknown |  |
| series_id | Unknown |  |
| start_date_time | Unknown |  |
| subject_edited | Unknown |  |
| title | Unknown |  |
| updated_at | LocalDateTime |  |

### company_trade_work_type

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_trade_id | Unknown | PK, FK |
| color | Unknown |  |
| name | Unknown |  |

### company_trade_sub_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_trade_attribute_id | Unknown | PK, FK |
| company_trade_id | Unknown | PK, FK |
| locked | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |
| unit_display_name | Unknown |  |
| unit_id | Unknown |  |
| unit_name | Unknown |  |

### company_trade_attribute

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| company_trade_id | Unknown | PK, FK |
| locked | Unknown |  |
| name | Unknown |  |
| slug | Unknown |  |

### company_trade

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| color | Unknown |  |
| name | Unknown |  |

### payment_method

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| label | Unknown |  |
| method | Unknown |  |
| quickbook_id | Unknown |  |

### workflow_stage

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| code | Unknown |  |
| color | Unknown |  |
| created_at_date | Unknown |  |
| created_at_timezone | Unknown |  |
| created_at_timezone_type | Unknown |  |
| description | Unknown |  |
| jobs_count | Unknown |  |
| locked | Unknown |  |
| name | Unknown |  |
| position | Unknown |  |
| updated_at_date | Unknown |  |
| updated_at_timezone | Unknown |  |
| updated_at_timezone_type | Unknown |  |
| workflow_id | Unknown |  |

### user_role

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

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| active | Unknown |  |
| added_date | LocalDateTime |  |
| admin_privilege | Unknown |  |
| color | Unknown |  |
| company | Unknown |  |
| company_id | Unknown |  |
| company_name | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| group_id | Unknown |  |
| group_name | Unknown |  |
| last_name | Unknown |  |
| profile_pic | Unknown |  |

### appointment_job

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

### appointment_reminder

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

### appointment_attendee

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

### appointment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| user_id | Unknown | FK |
| by_day | Json |  |
| created_at | Unknown |  |
| description | Unknown |  |
| end_date_time | Unknown |  |
| full_day | Unknown |  |
| interval | Unknown |  |
| is_completed | Unknown |  |
| is_recurring | Unknown |  |
| lat | Unknown |  |
| location | Unknown |  |
| location_type | Unknown |  |
| long | Unknown |  |
| occurence | Unknown |  |
| repeat | Unknown |  |
| result | Json |  |
| result_option_id | Unknown |  |
| series_id | Unknown |  |
| start_date_time | Unknown |  |
| title | Unknown |  |
| until_date | Unknown |  |
| updated_at | LocalDateTime |  |

### customer_contact

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | PK, FK |
| first_name | Unknown |  |
| last_name | Unknown |  |

### customer_phone

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| customer_id | Unknown | PK, FK |
| ext | Unknown |  |
| label | Unknown |  |
| number | Unknown |  |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| rep_id | Unknown | FK |
| additional_emails | Json |  |
| address | Unknown |  |
| address_country_code | Unknown |  |
| address_country_currency_name | Unknown |  |
| address_country_currency_symbol | Unknown |  |
| address_country_id | Unknown |  |
| address_country_name | Unknown |  |
| address_country_phone_code | Unknown |  |
| address_id | Unknown |  |
| address_line_1 | Unknown |  |
| address_state_code | Unknown |  |
| address_state_id | Unknown |  |
| address_state_name | Unknown |  |
| appointment_required | Unknown |  |
| billing_address | Unknown |  |
| billing_address_line_1 | Unknown |  |
| billing_city | Unknown |  |
| billing_country_code | Unknown |  |
| billing_country_currency_name | Unknown |  |
| billing_country_currency_symbol | Unknown |  |
| billing_country_id | Unknown |  |
| billing_country_name | Unknown |  |
| billing_country_phone_code | Unknown |  |
| billing_id | Unknown |  |
| billing_lat | Unknown |  |
| billing_long | Unknown |  |
| billing_state_code | Unknown |  |
| billing_state_id | Unknown |  |
| billing_state_name | Unknown |  |
| billing_zip | Unknown |  |
| call_center_rep | Unknown |  |
| call_center_rep_type | Unknown |  |
| call_required | Unknown |  |
| canvasser | Unknown |  |
| canvasser_type | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| created_at | Unknown |  |
| deleted_at | Unknown |  |
| email | Unknown |  |
| first_name | Unknown |  |
| is_commercial | Unknown |  |
| last_name | Unknown |  |
| lat | Unknown |  |
| long | Unknown |  |
| management_company | Unknown |  |
| note | Unknown |  |
| property_name | Unknown |  |
| referred_by_note | Unknown |  |
| referred_by_type | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### job_representative

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

### job_sub_contractor

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

### job_trade

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

### job_work_type

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

### job

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| customer_id | Unknown | FK |
| division_id | Unknown | FK |
| address | Unknown |  |
| address_country_code | Unknown |  |
| address_country_currency_name | Unknown |  |
| address_country_currency_symbol | Unknown |  |
| address_country_id | Unknown |  |
| address_country_name | Unknown |  |
| address_country_phone_code | Unknown |  |
| address_id | Unknown |  |
| address_line_1 | Unknown |  |
| address_state_code | Unknown |  |
| address_state_id | Unknown |  |
| address_state_name | Unknown |  |
| alt_id | Unknown |  |
| appointment_required | Unknown |  |
| archived | Unknown |  |
| awarded_date | Unknown |  |
| call_required | Unknown |  |
| city | Unknown |  |
| completion_date | Unknown |  |
| contact_same_as_customer | Unknown |  |
| contract_signed_date | Unknown |  |
| created_at | Unknown |  |
| created_date | Unknown |  |
| current_stage_code | Unknown |  |
| current_stage_color | Unknown |  |
| current_stage_name | Unknown |  |
| deleted_at | Unknown |  |
| description | Unknown |  |
| duration | Unknown |  |
| hover_job_id | Unknown |  |
| insurance | Unknown |  |
| lat | Unknown |  |
| lead_number | Unknown |  |
| long | Unknown |  |
| multi_job | Unknown |  |
| name | Unknown |  |
| number | Unknown |  |
| other_trade_type_description | Unknown |  |
| same_as_customer_address | Unknown |  |
| stage_last_modified | Unknown |  |
| tax_rate | Unknown |  |
| updated_at | Unknown |  |
| zip | Unknown |  |

### vendor_bill_attactment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| vendor_bill_id | Unknown | PK, FK |
| meta | Unknown |  |
| mime_type | Unknown |  |
| name | Unknown |  |
| parent_id | Unknown |  |
| size | Unknown |  |
| url | Unknown |  |

### vendor_bill_vendor

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| vendor_bill_id | Unknown | PK, FK |
| display_name | Unknown |  |
| first_name | Unknown |  |
| last_name | Unknown |  |
| origin | Unknown |  |

### vendor_bill_line

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| vendor_bill_id | Unknown | PK, FK |
| account_id | Unknown |  |
| description | Unknown |  |
| quantity | Unknown |  |
| rate | Unknown |  |

### vendor_bill

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| address | Unknown |  |
| bill_date | Unknown |  |
| bill_number | Unknown |  |
| created_at | Unknown |  |
| due_date | Unknown |  |
| file_paths | Unknown |  |
| note | Unknown |  |
| origin | Unknown |  |
| tax_amount | Unknown |  |
| total_amount | Unknown |  |
| updated_at | Unknown |  |

### job_note

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| modified_by | Unknown | FK |
| created_at | Unknown |  |
| note | Unknown |  |
| stage_code | Unknown |  |
| updated_at | Unknown |  |

### financial_summary

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| job_id | Unknown | FK |
| total_amount_owed | Unknown |  |
| total_change_order_amount | Unknown |  |
| total_credit_amount | Unknown |  |
| total_job_price | Unknown |  |
| total_job_revenue | Unknown |  |
| total_payment_received | Unknown |  |
| total_refund_amount | Unknown |  |

### payment_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| customer_id | Unknown | FK |
| cancel_note | Unknown |  |
| canceled | Unknown |  |
| date | Unknown |  |
| echeque_number | Unknown |  |
| method | Unknown |  |
| payment | Unknown |  |
| ref_id | Unknown |  |
| ref_to | Unknown |  |
| reference_number | Unknown |  |
| serial_number | Unknown |  |
| status | Unknown |  |
| unapplied_amount | Unknown |  |

### invoice_line

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |
| trade_id | Unknown | FK |
| amount | Unknown |  |
| description | Unknown |  |
| is_chargeable | Unknown |  |
| product_id | Unknown |  |
| quantity | Unknown |  |
| trade_name | Unknown |  |
| work_type_color | Unknown |  |
| work_type_id | Unknown |  |
| work_type_name | Unknown |  |

### invoice_custom_tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| invoice_id | Unknown | PK, FK |
| job_id | Unknown | PK, FK |
| created_at | Unknown |  |
| tax_rate | Unknown |  |
| title | Unknown |  |
| updated_at | Unknown |  |

### invoice

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| customer_id | Unknown | FK |
| amount | Unknown |  |
| created_at | Unknown |  |
| date | Unknown |  |
| description | Unknown |  |
| due_date | Unknown |  |
| file_paths | Unknown |  |
| file_size | Unknown |  |
| invoice_number | Unknown |  |
| last_updated_origin | Unknown |  |
| name | Unknown |  |
| note | Unknown |  |
| open_balance | Unknown |  |
| origin | Unknown |  |
| status | Unknown |  |
| tax_rate | Unknown |  |
| taxable_amount | Unknown |  |
| title | Unknown |  |
| total_amount | Unknown |  |
| type | Unknown |  |
| unit_number | Unknown |  |
| updated_at | Unknown |  |

### workflow_history

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| job_id | Unknown | PK, FK |
| modified_by | Unknown | FK |
| completed_date | Unknown |  |
| created_at | Unknown |  |
| stage | Unknown |  |
| start_date | Unknown |  |
| updated_at | Unknown |  |

## Relationships

- sub_contractor_additional_phone(sub_contractor_id) → sub_contractor(id)
- sub_contractor_trade(id) → company_trade(id)
- sub_contractor_trade(sub_contractor_id) → sub_contractor(id)
- sub_contractor_work_type(trade_id) → company_trade(id)
- sub_contractor_work_type(sub_contractor_id) → sub_contractor(id)
- schedule_trade(id) → company_trade(id)
- schedule_trade(schedule_id) → schedule(id)
- schedule_work_crew_note(job_id) → job(id)
- schedule_work_crew_note(schedule_id) → schedule(id)
- schedule_reminder(schedule_id) → schedule(id)
- schedule_work_type(trade_id) → company_trade(id)
- schedule_work_type(schedule_id) → schedule(id)
- schedule_sub_contractor(id) → sub_contractor(id)
- schedule_sub_contractor(schedule_id) → schedule(id)
- schedule_representative(id) → users(id)
- schedule_representative(schedule_id) → schedule(id)
- schedule(created_by) → users(id)
- schedule(job_id) → job(id)
- schedule(customer_id) → customer(id)
- schedule(modified_by) → users(id)
- company_trade_work_type(company_trade_id) → company_trade(id)
- company_trade_sub_attribute(company_trade_id) → company_trade(id)
- company_trade_sub_attribute(company_trade_attribute_id) → company_trade_attribute(id)
- company_trade_attribute(company_trade_id) → company_trade(id)
- user_role(user_id) → users(id)
- appointment_job(id) → job(id)
- appointment_job(appointment_id) → appointment(id)
- appointment_reminder(appointment_id) → appointment(id)
- appointment_attendee(id) → users(id)
- appointment_attendee(appointment_id) → appointment(id)
- appointment(user_id) → users(id)
- appointment(customer_id) → customer(id)
- customer_contact(customer_id) → customer(id)
- customer_phone(customer_id) → customer(id)
- customer(rep_id) → users(id)
- job_representative(id) → users(id)
- job_representative(job_id) → job(id)
- job_sub_contractor(id) → sub_contractor(id)
- job_sub_contractor(job_id) → job(id)
- job_trade(id) → company_trade(id)
- job_trade(job_id) → job(id)
- job_work_type(trade_id) → company_trade(id)
- job_work_type(job_id) → job(id)
- job(created_by) → users(id)
- job(division_id) → division(id)
- job(customer_id) → customer(id)
- vendor_bill_attactment(vendor_bill_id) → vendor_bill(id)
- vendor_bill_attactment(job_id) → vendor_bill(job_id)
- vendor_bill_vendor(vendor_bill_id) → vendor_bill(id)
- vendor_bill_vendor(job_id) → vendor_bill(job_id)
- vendor_bill_line(vendor_bill_id) → vendor_bill(id)
- vendor_bill_line(job_id) → vendor_bill(job_id)
- vendor_bill(job_id) → job(id)
- job_note(modified_by) → users(id)
- job_note(created_by) → users(id)
- job_note(job_id) → job(id)
- financial_summary(job_id) → job(id)
- payment_history(customer_id) → customer(id)
- payment_history(job_id) → job(id)
- invoice_line(trade_id) → company_trade(id)
- invoice_line(job_id) → invoice(job_id)
- invoice_line(invoice_id) → invoice(id)
- invoice_custom_tax(job_id) → invoice(job_id)
- invoice_custom_tax(invoice_id) → invoice(id)
- invoice(customer_id) → customer(id)
- invoice(job_id) → job(id)
- workflow_history(modified_by) → users(id)
- workflow_history(job_id) → job(id)