Harvest

Explore the interactive ERD

Table & Field Reference

estimate_item_category

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`created_at`	Unknown
`name`	Unknown

contact

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`created_at`	Unknown
`email`	Unknown
`fax`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`phone_mobile`	Unknown
`phone_office`	Unknown
`title`	Unknown

project_user_assignment

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`project_id`	Unknown	FK
`user_id`	Unknown	FK
`budget`	Unknown
`created_at`	Unknown
`hourly_rate`	Unknown
`is_active`	Unknown
`is_project_manager`	Unknown
`use_default_rates`	Unknown

role_user

Column	Type	Keys
`role_user_id`	Unknown	PK
`role_id`	Unknown	PKFK

role

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`created_at`	Unknown
`name`	Unknown

time_entry

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`invoice_id`	Unknown	FK
`project_id`	Unknown	FK
`task_assignment_id`	Unknown	FK
`task_id`	Unknown	FK
`user_assignment_id`	Unknown	FK
`user_id`	Unknown	FK
`billable`	Unknown
`billable_rate`	Unknown
`budgeted`	Unknown
`cost_rate`	Unknown
`created_at`	Unknown
`ended_time`	Unknown
`external_reference`	Unknown
`hours`	Unknown
`hours_without_timer`	Unknown
`is_billed`	Unknown
`is_closed`	Unknown
`is_locked`	Unknown
`is_running`	Unknown
`locked_reason`	Unknown
`notes`	Unknown
`rounded_hours`	Unknown
`spent_date`	Unknown
`started_time`	Unknown
`timer_started_at`	Unknown

project_task_assignment

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`project_id`	Unknown	FK
`task_id`	Unknown	FK
`billable`	Unknown
`budget`	Unknown
`created_at`	Unknown
`hourly_rate`	Unknown
`is_active`	Unknown

invoice_item_category

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`created_at`	Unknown
`name`	Unknown
`use_as_expense`	Unknown
`use_as_service`	Unknown

invoice_message_recipient

Column	Type	Keys
`email`	Unknown	PK
`invoice_message_id`	Unknown	PKFK
`name`	Unknown

invoice_message

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`invoice_id`	Unknown	FK
`attach_pdf`	Unknown
`body`	Unknown
`created_at`	Unknown
`event_type`	Unknown
`include_link_to_client_invoice`	Unknown
`reminder`	Unknown
`send_me_a_copy`	Unknown
`send_reminder_on`	Unknown
`sent_by`	Unknown
`sent_by_email`	Unknown
`sent_from`	Unknown
`sent_from_email`	Unknown
`subject`	Unknown
`thank_you`	Unknown

user_cost_rate

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`users_id`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`start_date`	Unknown

expense_category

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`created_at`	Unknown
`is_active`	Unknown
`name`	Unknown
`unit_name`	Unknown
`unit_price`	Unknown

user_project_assignment_task_assignment

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`task_id`	Unknown	FK
`users_id`	Unknown	FK
`billable`	Unknown
`budget`	Unknown
`created_at`	Unknown
`hourly_rate`	Unknown
`is_active`	Unknown

user_project_assignment

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`project_id`	Unknown	FK
`users_id`	Unknown	FK
`budget`	Unknown
`created_at`	Unknown
`hourly_rate`	Unknown
`is_active`	Unknown
`is_project_manager`	Unknown
`use_default_rates`	Unknown

task

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`billable_by_default`	Unknown
`created_at`	Unknown
`default_hourly_rate`	Unknown
`is_active`	Unknown
`is_default`	Unknown
`name`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`bill_by`	Unknown
`budget`	Unknown
`budget_by`	Unknown
`budget_is_monthly`	Unknown
`code`	Unknown
`cost_budget`	Unknown
`cost_budget_include_expenses`	Unknown
`created_at`	Unknown
`ends_on`	Unknown
`fee`	Unknown
`hourly_rate`	Unknown
`is_active`	Unknown
`is_billable`	Unknown
`is_fixed_fee`	Unknown
`name`	Unknown
`notes`	Unknown
`notify_when_over_budget`	Unknown
`over_budget_notification_date`	Unknown
`over_budget_notification_percentage`	Unknown
`show_budget_to_all`	Unknown
`starts_on`	Unknown

invoice_payment

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`invoice_id`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`notes`	Unknown
`paid_at`	Unknown
`paid_date`	Unknown
`payment_gateway_id`	Unknown
`payment_gateway_name`	Unknown
`recorded_by`	Unknown
`recorded_by_email`	Unknown
`transaction_id`	Unknown

invoice_line_item

Column	Type	Keys
`id`	Unknown	PK
`invoice_id`	Unknown	FK
`project_id`	Unknown	FK
`amount`	Unknown
`description`	Unknown
`kind`	Unknown
`quantity`	Unknown
`taxed`	Unknown
`taxed_2`	Unknown
`unit_price`	Unknown

invoice

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`creator_id`	Unknown	FK
`amount`	Unknown
`client_key`	Unknown
`closed_at`	Unknown
`created_at`	Unknown
`currency`	Unknown
`discount`	Unknown
`discount_amount`	Unknown
`due_amount`	Unknown
`due_date`	Unknown
`issue_date`	Unknown
`notes`	Unknown
`number`	Unknown
`paid_at`	Unknown
`paid_date`	Unknown
`payment_term`	Unknown
`period_end`	Unknown
`period_start`	Unknown
`purchase_order`	Unknown
`recurring_invoice_id`	Unknown
`sent_at`	Unknown
`state`	Unknown
`subject`	Unknown
`tax`	Unknown
`tax_2`	Unknown
`tax_2_amount`	Unknown
`tax_amount`	Unknown

client

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`address`	Unknown
`created_at`	Unknown
`currency`	Unknown
`is_active`	Unknown
`name`	Unknown
`statement_key`	Unknown

expense

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`expense_category_id`	Unknown	FK
`invoice_id`	Unknown	FK
`project_id`	Unknown	FK
`user_assignment_id`	Unknown	FK
`user_id`	Unknown	FK
`billable`	Unknown
`created_at`	Unknown
`is_billed`	Unknown
`is_closed`	Unknown
`is_locked`	Unknown
`locked_reason`	Unknown
`notes`	Unknown
`receipt_content_type`	Unknown
`receipt_file_name`	Unknown
`receipt_file_size`	Unknown
`receipt_url`	Unknown
`spent_date`	Unknown
`total_cost`	Unknown
`units`	Unknown

user_billable_rate

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`users_id`	Unknown	FK
`amount`	Unknown
`created_at`	Unknown
`end_date`	Unknown
`start_date`	Unknown

estimate_message_recipient

Column	Type	Keys
`email`	Unknown	PK
`estimate_message_id`	Unknown	PKFK
`name`	Unknown

estimate_message

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`estimate_id`	Unknown	FK
`body`	Unknown
`created_at`	Unknown
`event_type`	Unknown
`send_me_a_copy`	Unknown
`sent_by`	Unknown
`sent_by_email`	Unknown
`sent_from`	Unknown
`sent_from_email`	Unknown
`subject`	Unknown

users_permission_claim

Column	Type	Keys
`permission_claim_name`	Unknown	PK
`users_id`	Unknown	PKFK

users

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`avatar_url`	Unknown
`calendar_integration_enabled`	Unknown
`calendar_integration_source`	Unknown
`can_close_account`	Unknown
`can_create_invoices`	Unknown
`can_create_projects`	Unknown
`can_see_rates`	Unknown
`cost_rate`	Unknown
`created_at`	Unknown
`default_hourly_rate`	Unknown
`email`	Unknown
`first_name`	Unknown
`has_access_to_all_future_projects`	Unknown
`is_active`	Unknown
`is_admin`	Unknown
`is_contractor`	Unknown
`is_project_manager`	Unknown
`last_name`	Unknown
`telephone`	Unknown
`timezone`	Unknown
`weekly_capacity`	Unknown

estimate_line_item

Column	Type	Keys
`id`	Unknown	PK
`estimate_id`	Unknown	FK
`amount`	Unknown
`description`	Unknown
`kind`	Unknown
`quantity`	Unknown
`taxed`	Unknown
`taxed_2`	Unknown
`unit_price`	Unknown

estimate

Column	Type	Keys
`id`	Unknown	PK
`updated_at`	Unknown	PK
`client_id`	Unknown	FK
`creator_id`	Unknown	FK
`accepted_at`	Unknown
`amount`	Unknown
`client_key`	Unknown
`created_at`	Unknown
`currency`	Unknown
`declined_at`	Unknown
`discount`	Unknown
`discount_amount`	Unknown
`issue_date`	Unknown
`notes`	Unknown
`number`	Unknown
`purchase_order`	Unknown
`sent_at`	Unknown
`state`	Unknown
`subject`	Unknown
`tax`	Unknown
`tax_2`	Unknown
`tax_2_amount`	Unknown
`tax_amount`	Unknown