Harvest schema and ERD

35 tables

Loading diagram…

estimate

invoice

user_project_assignment

client

string

name

string

is_active

boolean

address

string

statement_key

string

created_at

date

updated_at

date

currency

string

_weld_synced

date

company

base_uri

string

full_domain

string

name

string

is_active

boolean

week_start_day

string

wants_timestamp_timers

boolean

time_format

string

date_format

string

contact

string

client_id

string

title

string

first_name

string

last_name

string

phone_office

string

phone_mobile

string

fax

string

created_at

date

updated_at

date

client_name

string

_weld_synced

date

estimate_item_category

string

name

string

created_at

date

updated_at

date

_weld_synced

date

estimate_message

string

parent_estimate_id

string

sent_by

string

sent_by_email

string

sent_from

string

sent_from_email

string

send_me_a_copy

boolean

created_at

date

updated_at

date

estimate

string

client_id

string

client_key

string

number

double

purchase_order

double

amount

double

tax

string

tax_amount

double

tax_2

string

tax_2_amount

double

estimate_line_items

string

estimate_id

string

kind

string

description

string

quantity

double

unit_price

double

amount

double

taxed

boolean

taxed_2

boolean

index

double

_weld_synced

date

expense_category

string

name

string

unit_name

string

unit_price

double

is_active

boolean

created_at

date

updated_at

date

_weld_synced

date

expense_categories_report

expense_category_id

string

expense_category_name

string

total_amount

double

billable_amount

double

currency

string

from

date

_weld_synced

date

expense_clients_report

client_id

string

client_name

string

total_amount

double

billable_amount

double

currency

string

from

date

_weld_synced

date

expense_projects_report

client_id

string

project_id

string

client_name

string

project_name

string

total_amount

double

billable_amount

double

currency

string

from

date

_weld_synced

date

expense_team_report

user_id

string

user_name

string

is_contractor

boolean

total_amount

double

billable_amount

double

currency

string

from

date

_weld_synced

date

expense

string

user_id

string

client_id

string

project_id

string

expense_category_id

string

spent_date

date

notes

string

total_cost

double

units

double

billable

boolean

receipt

string

is_closed

boolean

is_locked

boolean

invoice_item_category

string

name

string

use_as_service

boolean

use_as_expense

boolean

created_at

date

updated_at

date

_weld_synced

date

invoice_message

string

event_type

string

attach_pdf

boolean

parent_id

long

reminder

boolean

send_me_a_copy

boolean

send_reminder_on

string

sent_by

string

sent_by_email

string

invoice_payment

string

amount

long

paid_at

string

paid_date

string

recorded_by

string

recorded_by_email

string

notes

string

transaction_id

string

payment_gateway_id

long

payment_gateway_name

string

created_at

date

updated_at

date

_weld_synced

date

invoice

string

client_id

string

client_key

string

number

double

purchase_order

string

amount

double

due_amount

double

tax

string

tax_amount

double

tax_2

string

invoice_line_items

string

project_id

string

invoice_id

string

kind

string

description

string

quantity

double

unit_price

double

amount

double

taxed

boolean

taxed_2

boolean

project

string

index

double

project_name

string

project_code

string

_weld_synced

date

project_budget_report

project_id

string

client_id

string

project_name

string

client_name

string

budget_is_monthly

boolean

budget_by

string

is_active

boolean

budget

double

budget_spent

double

budget_remaining

double

_weld_synced

date

project_task_assignment

string

project_id

string

task_id

string

billable

boolean

is_active

boolean

created_at

date

updated_at

date

hourly_rate

string

budget

string

project_name

string

project_code

string

task_name

string

_weld_synced

date

project_user_assignment

string

project_id

string

user_id

string

is_project_manager

boolean

is_active

boolean

use_default_rates

boolean

created_at

date

updated_at

date

hourly_rate

string

budget

string

project_name

string

project_code

string

user_name

string

_weld_synced

date

project

string

client_id

string

name

string

code

string

is_active

boolean

is_billable

boolean

is_fixed_fee

boolean

bill_by

string

budget

double

budget_by

string

role

string

name

string

created_at

date

updated_at

date

user_ids

string

_weld_synced

date

task

string

name

string

billable_by_default

boolean

is_default

boolean

is_active

boolean

created_at

date

updated_at

date

default_hourly_rate

string

_weld_synced

date

time_clients_report

client_id

string

client_name

string

total_hours

double

billable_hours

double

currency

string

billable_amount

double

from

date

_weld_synced

date

time_entry

string

user_id

string

client_id

string

project_id

string

task_id

string

spent_date

date

hours

double

hours_without_timer

double

rounded_hours

double

notes

string

is_locked

boolean

locked_reason

string

is_closed

boolean

time_projects_report

project_id

string

client_id

string

project_name

string

client_name

string

total_hours

double

billable_hours

double

currency

string

billable_amount

double

from

date

_weld_synced

date

time_tasks_report

task_id

string

task_name

string

total_hours

double

billable_hours

double

currency

string

billable_amount

double

from

date

_weld_synced

date

time_team_report

user_id

string

user_name

string

is_contractor

boolean

weekly_capacity

double

avatar_url

string

total_hours

double

billable_hours

double

currency

string

billable_amount

double

from

date

_weld_synced

date

uninvoiced_report

client_id

string

project_id

string

client_name

string

project_name

string

currency

string

total_hours

double

uninvoiced_hours

double

uninvoiced_expenses

double

uninvoiced_amount

double

from

date

_weld_synced

date

user_billable_rate

string

parent_user_id

string

amount

double

start_date

string

end_date

string

created_at

date

updated_at

date

_weld_synced

date

user_cost_rate

string

parent_user_id

string

amount

double

start_date

string

end_date

string

created_at

date

updated_at

date

_weld_synced

date

user_project_assignment

string

project_id

string

client_id

string

parent_user_id

string

is_project_manager

boolean

is_active

boolean

use_default_rates

boolean

budget

string

created_at

date

updated_at

date

hourly_rate

string

user_project_assignment_task_assignments

string

project_id

string

task_id

string

user_project_assignment_id

string

project_name

string

project_code

string

task_name

string

billable

boolean

is_active

boolean

created_at

date

updated_at

date

hourly_rate

string

budget

string

index

double

_weld_synced

date

user

string

first_name

string

last_name

string

telephone

string

timezone

string

weekly_capacity

double

has_access_to_all_future_projects

boolean

is_contractor

boolean