ERD
Schema browser
Loading diagram…
user_project_assignment
T
user_project_assignment
id
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
double
-
project_name
string
-
project_code
string
-
project_is_billable
boolean
-
client_name
string
-
client_currency
string
-
_weld_synced
date
S
task_assignments
id
string
task_id
string
user_project_assignment_id
string
-
billable
boolean
-
is_active
boolean
-
created_at
date
-
updated_at
date
-
hourly_rate
string
-
budget
string
-
task_name
string
-
index
double
estimate
T
estimate
id
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
-
discount
double
-
discount_amount
double
-
subject
string
-
notes
string
-
state
string
-
issue_date
date
-
sent_at
string
-
created_at
date
-
updated_at
date
-
accepted_at
date
-
declined_at
string
-
currency
string
-
client_name
string
-
creator_id
string
-
creator_name
string
-
_weld_synced
date
S
line_items
id
string
estimate_id
string
-
kind
string
-
description
string
-
quantity
double
-
unit_price
double
-
amount
double
-
taxed
boolean
-
taxed_2
boolean
-
index
double
invoice
T
invoice
id
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
-
tax_2_amount
double
-
discount
string
-
discount_amount
double
-
subject
string
-
notes
string
-
state
string
-
period_start
date
-
period_end
date
-
issue_date
date
-
due_date
date
-
payment_term
string
-
sent_at
string
-
paid_at
string
-
closed_at
string
-
recurring_invoice_id
string
-
created_at
date
-
updated_at
date
-
paid_date
string
-
currency
string
-
payment_options
string
-
client_name
string
-
estimate
string
-
retainer
string
-
creator_id
string
-
creator_name
string
-
_weld_synced
date
T
estimate_item_category
id
string
-
name
string
-
created_at
date
-
updated_at
date
-
_weld_synced
date
T
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
-
plan_type
string
-
expense_feature
boolean
-
invoice_feature
boolean
-
estimate_feature
boolean
-
team_feature
boolean
-
weekly_capacity
double
-
approval_feature
boolean
-
clock
string
-
currency
string
-
currency_code_display
string
-
currency_symbol_display
string
-
decimal_symbol
string
-
thousands_separator
string
-
color_scheme
string
-
saml_sign_in_required
boolean
-
day_entry_notes_required
boolean
-
_weld_synced
date
T
task
id
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
T
contact
-
_weld_synced
date
T
time_entry
id
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
-
is_billed
boolean
-
timer_started_at
date
-
started_time
string
-
ended_time
string
-
is_running
boolean
-
billable
boolean
-
budgeted
boolean
-
billable_rate
double
-
cost_rate
string
-
created_at
date
-
updated_at
date
-
user_name
string
-
client_name
string
-
client_currency
string
-
project_name
string
-
project_code
string
-
task_name
string
-
user_assignment_id
string
-
user_assignment_is_project_manager
boolean
-
user_assignment_is_active
boolean
-
user_assignment_use_default_rates
boolean
-
user_assignment_budget
string
-
user_assignment_created_at
date
-
user_assignment_updated_at
date
-
user_assignment_hourly_rate
double
-
task_assignment_id
string
-
task_assignment_billable
boolean
-
task_assignment_is_active
boolean
-
task_assignment_created_at
date
-
task_assignment_updated_at
date
-
task_assignment_hourly_rate
string
-
task_assignment_budget
double
-
invoice
string
-
external_reference
string
-
_weld_synced
date
T
user_billable_rate
id
string
-
parent_user_id
string
-
amount
double
-
start_date
string
-
end_date
string
-
created_at
date
-
updated_at
date
-
_weld_synced
date
T
invoice_payment
-
_weld_synced
date
T
invoice_message
-
_weld_synced
date
T
project_task_assignment
id
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
T
project
id
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
-
budget_is_monthly
boolean
-
notify_when_over_budget
boolean
-
over_budget_notification_percentage
double
-
show_budget_to_all
boolean
-
created_at
date
-
updated_at
date
-
starts_on
date
-
ends_on
date
-
over_budget_notification_date
string
-
notes
string
-
cost_budget
string
-
cost_budget_include_expenses
boolean
-
hourly_rate
string
-
fee
string
-
client_name
string
-
client_currency
string
-
_weld_synced
date
T
expense_categories_report
expense_category_id
string
-
expense_category_name
string
-
total_amount
double
-
billable_amount
double
-
currency
string
-
_weld_synced
date
T
project_user_assignment
id
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
double
-
budget
string
-
project_name
string
-
project_code
string
-
user_name
string
-
_weld_synced
date
T
expense_category
id
string
-
name
string
-
unit_name
string
-
unit_price
double
-
is_active
boolean
-
created_at
date
-
updated_at
date
-
_weld_synced
date
T
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
-
_weld_synced
date
T
expense
id
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
-
is_billed
boolean
-
locked_reason
string
-
created_at
date
-
updated_at
date
-
user_name
string
-
client_name
string
-
client_currency
string
-
project_name
string
-
project_code
string
-
expense_category_name
string
-
expense_category_unit_price
double
-
expense_category_unit_name
string
-
user_assignment_id
string
-
user_assignment_is_project_manager
boolean
-
user_assignment_is_active
boolean
-
user_assignment_use_default_rates
boolean
-
user_assignment_budget
double
-
user_assignment_created_at
date
-
user_assignment_updated_at
date
-
user_assignment_hourly_rate
double
-
invoice
string
-
_weld_synced
date
T
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
-
_weld_synced
date
T
expense_team_report
user_id
string
-
user_name
string
-
is_contractor
boolean
-
total_amount
double
-
billable_amount
double
-
currency
string
-
_weld_synced
date
T
time_clients_report
client_id
string
-
client_name
string
-
total_hours
double
-
billable_hours
double
-
currency
string
-
billable_amount
double
-
_weld_synced
date
T
invoice_item_category
id
string
-
name
string
-
use_as_service
boolean
-
use_as_expense
boolean
-
created_at
date
-
updated_at
date
-
_weld_synced
date
T
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
-
_weld_synced
date
T
expense_clients_report
client_id
string
-
client_name
string
-
total_amount
double
-
billable_amount
double
-
currency
string
-
_weld_synced
date
T
expense_projects_report
client_id
string
project_id
string
-
client_name
string
-
project_name
string
-
total_amount
double
-
billable_amount
double
-
currency
string
-
_weld_synced
date
T
role
id
string
-
name
string
-
created_at
date
-
updated_at
date
-
user_ids
string
-
_weld_synced
date
T
time_tasks_report
task_id
string
-
task_name
string
-
total_hours
double
-
billable_hours
double
-
currency
string
-
billable_amount
double
-
_weld_synced
date
T
client
id
string
-
name
string
-
is_active
boolean
-
address
string
-
statement_key
string
-
created_at
date
-
updated_at
date
-
currency
string
-
_weld_synced
date
T
user_cost_rate
-
_weld_synced
date
T
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
T
user
id
string
-
first_name
string
-
last_name
string
-
email
string
-
telephone
string
-
timezone
string
-
weekly_capacity
double
-
has_access_to_all_future_projects
boolean
-
is_contractor
boolean
-
is_active
boolean
-
calendar_integration_enabled
boolean
-
calendar_integration_source
string
-
created_at
date
-
updated_at
date
-
can_create_projects
boolean
-
default_hourly_rate
double
-
cost_rate
string
-
roles
string
-
access_roles
string
-
permissions_claims
string
-
avatar_url
string
-
_weld_synced
date
T
estimate_message
id
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
-
recipients
string
-
event_type
string
-
subject
string
-
body
string
-
_weld_synced
date
T
Table
S
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.