Leap CRM
Explore the interactive ERD
Table & Field Reference
sub_contractor_additional_phone
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
sub_contractor_id | Unknown | PKFK |
ext | Unknown | |
label | Unknown | |
phone | Unknown |
sub_contractor_trade
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
sub_contractor_id | Unknown | PKFK |
sub_contractor_work_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
sub_contractor_id | Unknown | PKFK |
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 | PKFK |
schedule_id | Unknown | PKFK |
schedule_work_crew_note
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_id | Unknown | PKFK |
job_id | Unknown | FK |
note | Unknown |
schedule_reminder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_id | Unknown | PKFK |
minutes | Unknown | |
type | Unknown |
schedule_work_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
schedule_id | Unknown | PKFK |
trade_id | Unknown | FK |
color | Unknown | |
name | Unknown |
schedule_sub_contractor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
schedule_id | Unknown | PKFK |
schedule_representative
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
schedule_id | Unknown | PKFK |
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 | PKFK |
color | Unknown | |
name | Unknown |
company_trade_sub_attribute
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_trade_attribute_id | Unknown | PKFK |
company_trade_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
id | Unknown | PKFK |
appointment_reminder
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | PKFK |
minutes | Unknown | |
type | Unknown |
appointment_attendee
| Column | Type | Keys |
|---|---|---|
appointment_id | Unknown | PKFK |
id | Unknown | PKFK |
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 | PKFK |
first_name | Unknown | |
last_name | Unknown |
customer_phone
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
customer_id | Unknown | PKFK |
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 | PKFK |
job_id | Unknown | PKFK |
job_sub_contractor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_trade
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_work_type
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
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 | PKFK |
vendor_bill_id | Unknown | PKFK |
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 | PKFK |
vendor_bill_id | Unknown | PKFK |
display_name | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
origin | Unknown |
vendor_bill_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
vendor_bill_id | Unknown | PKFK |
account_id | Unknown | |
description | Unknown | |
quantity | Unknown | |
rate | Unknown |
vendor_bill
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
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 | PKFK |
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 | PKFK |
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 | PKFK |
job_id | Unknown | PKFK |
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 | PKFK |
job_id | Unknown | PKFK |
created_at | Unknown | |
tax_rate | Unknown | |
title | Unknown | |
updated_at | Unknown |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
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 | PKFK |
modified_by | Unknown | FK |
completed_date | Unknown | |
created_at | Unknown | |
stage | Unknown | |
start_date | Unknown | |
updated_at | Unknown |