ServiceTrade
Explore the interactive ERD
Table & Field Reference
invoice_recurrence_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
invoice_recurrence_id | Unknown | PKFK |
cost | Unknown | |
description | Unknown | |
price | Unknown | |
quantity | Unknown | |
uri | Unknown |
invoice_recurrence
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_id | Unknown | FK |
location_id | Unknown | FK |
service_line_id | Unknown | FK |
created | Unknown | |
customer_id | Unknown | |
customer_name | Unknown | |
customer_status | Unknown | |
customer_uri | Unknown | |
description | Unknown | |
ends_on | Unknown | |
frequency | Unknown | |
interval | Unknown | |
next_due | Unknown | |
uri | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_status | Unknown | |
vendor_uri | Unknown |
service_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
abbr | Unknown | |
icon | Unknown | |
name | Unknown | |
trade | Unknown |
account
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
name | Unknown | |
timezone | Unknown | |
uri | Unknown | |
feature_** |
appointment_office
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | PKFK |
city | Unknown | |
email | Unknown | |
lat | Unknown | |
legacy_id | Unknown | |
lon | Unknown | |
name | Unknown | |
phone_number | Unknown | |
postal_code | Unknown | |
primary_contact | Unknown | |
ref_number | Unknown | |
state | Unknown | |
status | Unknown | |
street | Unknown | |
taxable | Unknown | |
uri | Unknown |
appointment_service_request
| Column | Type | Keys |
|---|---|---|
appointment_id | Unknown | PKFK |
id | Unknown | PKFK |
appointment_tech
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | PKFK |
avatar | Json | |
email | Unknown | |
is_helper | Unknown | |
is_tech | Unknown | |
name | Unknown | |
status | Unknown | |
uri | Unknown |
appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
location_id | Unknown | FK |
created | Unknown | |
due_by | Unknown | |
name | Unknown | |
released | Unknown | |
status | Unknown | |
updated | Unknown | |
uri | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_status | Unknown | |
vendor_uri | Unknown | |
window_end | Unknown | |
window_start | Unknown |
quote_job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
quote_id | Unknown | PKFK |
quote_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
quote_id | Unknown | PKFK |
quote_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
quote_id | Unknown | PKFK |
name | Unknown | |
uri | Unknown |
quote_service_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
quote_id | Unknown | PKFK |
quote_deficiency_job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
quote_id | Unknown | PKFK |
quote
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assigned_office_id | Unknown | FK |
assigned_to_id | Unknown | FK |
contract_id | Unknown | FK |
location_id | Unknown | FK |
owner_id | Unknown | FK |
quote_item_id | Unknown | FK |
created | Unknown | |
customer_id | Unknown | |
customer_name | Unknown | |
customer_po | Unknown | |
customer_po_required | Unknown | |
customer_status | Unknown | |
customer_uri | Unknown | |
deficiency_severity | Unknown | |
description | Unknown | |
expires_on | Unknown | |
external_ids | Json | |
job_type | Unknown | |
latest_accepted | Unknown | |
latest_submission | Unknown | |
name | Unknown | |
notes | Unknown | |
quote_link_attachment_visibility | Unknown | |
quote_link_comment_visibility | Unknown | |
quote_request_id | Unknown | |
quote_request_name | Unknown | |
quote_request_status | Unknown | |
quote_request_type | Unknown | |
quote_request_uri | Unknown | |
ref_number | Unknown | |
respond_by | Unknown | |
sales_avatar | Json | |
sales_email | Unknown | |
sales_id | Unknown | |
sales_is_helper | Unknown | |
sales_is_tech | Unknown | |
sales_name | Unknown | |
sales_status | Unknown | |
sales_uri | Unknown | |
section_visibilities | Unknown | |
status | Unknown | |
sub_status | Unknown | |
tasking_detail_level | Unknown | |
term_id | Unknown | |
term_name | Unknown | |
term_uri | Unknown | |
updated | Unknown | |
uri | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_status | Unknown | |
vendor_uri | Unknown | |
visibility | Json |
contact
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
location_id | Unknown | FK |
address_city | Unknown | |
address_postal_code | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
alternate_phone | Unknown | |
created | Unknown | |
email | Unknown | |
external_id_device_magic | Unknown | |
external_id_master_company | Unknown | |
external_id_migration | Unknown | |
external_id_new_partner_id | Unknown | |
external_id_sage | Unknown | |
external_id_sage_employee_id | Unknown | |
external_id_sage_test | Unknown | |
first_name | Unknown | |
last_name | Unknown | |
mobile | Unknown | |
phone | Unknown | |
status | Unknown | |
type | Unknown | |
updated | Unknown | |
uri | Unknown |
user_role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
name | Unknown |
user_service_line
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
users_id | Unknown | PKFK |
user_activity
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
users_id | Unknown | PKFK |
activity | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
account_id | Unknown | FK |
company_id | Unknown | FK |
location_id | Unknown | FK |
manager_id | Unknown | FK |
service_line_id | Unknown | FK |
avatar | Json | |
created | Unknown | |
details | Unknown | |
email | Unknown | |
external_id | Json | |
first_name | Unknown | |
is_helper | Unknown | |
is_sales | Unknown | |
is_tech | Unknown | |
last_name | Unknown | |
mfa_required | Unknown | |
name | Unknown | |
phone | Unknown | |
status | Unknown | |
time_zone | Unknown | |
updated | Unknown | |
uri | Unknown | |
user_name | Unknown |
job_office
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
job_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | PKFK |
name | Unknown | |
uri | Unknown |
job_appointment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
job_id | Unknown | PKFK |
job
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assigned_office_id | Unknown | FK |
contract_id | Unknown | FK |
current_appointment_id | Unknown | FK |
location_id | Unknown | FK |
owner_id | Unknown | FK |
budgeted | Unknown | |
completed_on | Unknown | |
created | Unknown | |
custom_name | Unknown | |
customer_email | Unknown | |
customer_id | Unknown | |
customer_name | Unknown | |
customer_po | Unknown | |
customer_status | Unknown | |
customer_uri | Unknown | |
description | Unknown | |
display_status | Unknown | |
display_sub_status | Unknown | |
due_after | Unknown | |
due_by | Unknown | |
estimated_price | Unknown | |
external_id | Json | |
is_project | Unknown | |
ivr_activity | Unknown | |
ivr_open | Unknown | |
job_type_weight | Unknown | |
latest_clock_in | Unknown | |
name | Unknown | |
number | Unknown | |
percent_complete | Unknown | |
primary_contact | Unknown | |
project | Unknown | |
ref_number | Unknown | |
sales_avatar | Json | |
sales_email | Unknown | |
sales_id | Unknown | |
sales_is_helper | Unknown | |
sales_is_tech | Unknown | |
sales_name | Unknown | |
sales_status | Unknown | |
sales_uri | Unknown | |
scheduled_date | Unknown | |
section_visibilities | Unknown | |
service_line | Unknown | |
service_link_attachment_category_visibility | Unknown | |
service_link_attachment_visibility | Unknown | |
service_link_comment_visibility | Unknown | |
status | Unknown | |
sub_status | Unknown | |
terms | Unknown | |
type | Unknown | |
updated | Unknown | |
uri | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_status | Unknown | |
vendor_uri | Unknown | |
visibility | Json |
service_recurrence_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
service_recurrence_id | Unknown | PKFK |
description | Unknown | |
uri | Unknown |
service_recurrence_preferred_tech
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
service_recurrence_id | Unknown | PKFK |
avatar | Json | |
email | Unknown | |
is_helper | Unknown | |
is_tech | Unknown | |
name | Unknown | |
status | Unknown | |
uri | Unknown |
service_recurrence
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
contract_id | Unknown | FK |
location_id | Unknown | FK |
service_line_id | Unknown | FK |
created | Unknown | |
description | Unknown | |
duration | Unknown | |
ends_on | Unknown | |
estimated_price | Unknown | |
first_end | Unknown | |
first_start | Unknown | |
frequency | Unknown | |
frequency_category | Unknown | |
interval | Unknown | |
parent | Unknown | |
preferred_start_time | Unknown | |
preferred_vendor | Unknown | |
repeat_weekday | Unknown | |
scheduling_type | Unknown | |
tasking_duration | Unknown | |
updated | Unknown | |
uri | Unknown |
lib_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
service_line_id | Unknown | FK |
active | Unknown | |
code | Unknown | |
cost | Unknown | |
created | Unknown | |
external_id | Json | |
is_generic | Unknown | |
name | Unknown | |
price | Unknown | |
price_rule_type | Unknown | |
taxable | Unknown | |
type | Unknown | |
type_id | Unknown | |
updated | Unknown | |
uri | Unknown |
company_service_line_provided
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | PKFK |
abbr | Unknown | |
icon | Unknown | |
name | Unknown | |
trade | Unknown |
company
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address_city | Unknown | |
address_postal_code | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
created | Unknown | |
customer | Unknown | |
default_brand | Unknown | |
external_id_device_magic | Unknown | |
external_id_master_company | Unknown | |
external_id_migration | Unknown | |
external_id_new_partner_id | Unknown | |
external_id_sage | Unknown | |
external_id_sage_employee_id | Unknown | |
external_id_sage_test | Unknown | |
logo_aspect | Unknown | |
logo_content_url | Unknown | |
logo_id | Unknown | |
logo_uri | Unknown | |
managing_account | Unknown | |
name | Unknown | |
parts_vendor | Unknown | |
phone_number | Unknown | |
prime_contractor | Unknown | |
ref_number | Unknown | |
share_id | Unknown | |
status | Unknown | |
tags | Json | |
updated | Unknown | |
uri | Unknown | |
vendor | Unknown |
service_request_preferred_vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
service_request_id | Unknown | PKFK |
service_request_preferred_tech
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
service_request_id | Unknown | PKFK |
service_request
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
contract_id | Unknown | FK |
deficiency_id | Unknown | FK |
job_id | Unknown | FK |
location_id | Unknown | FK |
service_line_id | Unknown | FK |
service_recurrence_id | Unknown | FK |
budget | Unknown | |
change_order | Unknown | |
change_order_id | Unknown | |
change_order_reference_number | Unknown | |
change_order_status | Unknown | |
change_order_type | Unknown | |
change_order_uri | Unknown | |
closed_on | Unknown | |
created | Unknown | |
description | Unknown | |
duration | Unknown | |
estimated_price | Unknown | |
original_window_end | Unknown | |
original_window_start | Unknown | |
preferred_start_time | Unknown | |
quote_link_attachment_visibility | Unknown | |
quote_link_comment_visibility | Unknown | |
quote_requests | Json | |
service_link_attachment_category_visibility | Unknown | |
service_link_attachment_visibility | Unknown | |
service_link_comment_visibility | Unknown | |
status | Unknown | |
task_instances | Json | |
task_lists | Json | |
updated | Unknown | |
uri | Unknown | |
visibility | Json | |
window_end | Unknown | |
window_start | Unknown |
deficiency
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
job_id | Unknown | FK |
location_id | Unknown | FK |
owner_id | Unknown | FK |
service_line_id | Unknown | FK |
created | Unknown | |
description | Unknown | |
external_id | Json | |
last_reported_status | Unknown | |
proposed_fix | Unknown | |
ref_number | Unknown | |
report_source | Unknown | |
reported_on | Unknown | |
reporter_avatar | Json | |
reporter_email | Unknown | |
reporter_id | Unknown | |
reporter_is_helper | Unknown | |
reporter_is_tech | Unknown | |
reporter_name | Unknown | |
reporter_status | Unknown | |
reporter_uri | Unknown | |
resolution | Unknown | |
sales_avatar | Json | |
sales_email | Unknown | |
sales_id | Unknown | |
sales_is_helper | Unknown | |
sales_is_tech | Unknown | |
sales_name | Unknown | |
sales_status | Unknown | |
sales_uri | Unknown | |
severity | Unknown | |
status | Unknown | |
title | Unknown | |
updated | Unknown | |
uri | Unknown | |
visibility | Json |
location_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | PKFK |
name | Unknown | |
uri | Unknown |
location_office
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
location
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
company_id | Unknown | FK |
primary_contact_id | Unknown | FK |
address_city | Unknown | |
address_postal_code | Unknown | |
address_state | Unknown | |
address_street | Unknown | |
brand | Unknown | |
created | Unknown | |
distance | Unknown | |
email | Unknown | |
external_id | Json | |
general_manager | Unknown | |
geo_code_quality | Unknown | |
lat | Unknown | |
legacy_id | Unknown | |
lon | Unknown | |
name | Unknown | |
phone_number | Unknown | |
ref_number | Unknown | |
remit_to_address_city | Unknown | |
remit_to_address_email | Unknown | |
remit_to_address_phone | Unknown | |
remit_to_address_postal_code | Unknown | |
remit_to_address_state | Unknown | |
remit_to_address_street | Unknown | |
remit_to_source | Unknown | |
status | Unknown | |
store_number | Unknown | |
tax_group_code | Unknown | |
tax_group_combined_rate | Unknown | |
tax_group_id | Unknown | |
tax_group_name | Unknown | |
tax_group_state | Unknown | |
tax_group_uri | Unknown | |
taxable | Unknown | |
updated | Unknown | |
uri | Unknown |
invoice
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
location_id | Unknown | FK |
assigned_office_city | Unknown | |
assigned_office_id | Unknown | |
assigned_office_lat | Unknown | |
assigned_office_legacy_id | Unknown | |
assigned_office_lon | Unknown | |
assigned_office_name | Unknown | |
assigned_office_phone_number | Unknown | |
assigned_office_postal_code | Unknown | |
assigned_office_primary_contact | Unknown | |
assigned_office_ref_number | Unknown | |
assigned_office_state | Unknown | |
assigned_office_status | Unknown | |
assigned_office_street | Unknown | |
assigned_office_taxable | Unknown | |
assigned_office_uri | Unknown | |
assigned_user | Unknown | |
contract | Unknown | |
created | Unknown | |
customer_external_id | Json | |
customer_id | Unknown | |
customer_name | Unknown | |
customer_po | Unknown | |
customer_status | Unknown | |
customer_uri | Unknown | |
due_date | Unknown | |
invoice_number | Unknown | |
name | Unknown | |
notes | Unknown | |
paid | Unknown | |
partial | Unknown | |
payment_terms | Unknown | |
ref_number | Unknown | |
sent | Unknown | |
status | Unknown | |
sub_status | Unknown | |
tags | Json | |
tax_amount | Unknown | |
term_id | Unknown | |
term_name | Unknown | |
term_uri | Unknown | |
transaction_date | Unknown | |
type | Unknown | |
updated | Unknown | |
uri | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_status | Unknown | |
vendor_uri | Unknown | |
visibility | Json |
contract_rule_lib_item
| Column | Type | Keys |
|---|---|---|
contract_rule_id | Unknown | PKFK |
id | Unknown | PKFK |
contract_rule
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_id | Unknown | FK |
service_line_id | Unknown | FK |
created | Unknown | |
name | Unknown | |
price | Unknown | |
threshold | Unknown | |
type | Unknown | |
updated | Unknown | |
uri | Unknown |
asset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
location_id | Unknown | FK |
service_line_id | Unknown | FK |
asset_definition_display | Unknown | |
asset_definition_id | Unknown | |
asset_definition_type | Unknown | |
asset_definition_uri | Unknown | |
created | Unknown | |
display | Unknown | |
external_id_device_magic | Unknown | |
external_id_master_company | Unknown | |
external_id_migration | Unknown | |
external_id_new_partner_id | Unknown | |
external_id_sage | Unknown | |
external_id_sage_employee_id | Unknown | |
external_id_sage_test | Unknown | |
has_active_task_list | Unknown | |
is_abstract_group | Unknown | |
legacy_id | Unknown | |
name | Unknown | |
order_index | Unknown | |
parent_id | Unknown | |
parent_name | Unknown | |
parent_type | Unknown | |
parent_uri | Unknown | |
properties_area | Unknown | |
properties_barcode | Unknown | |
properties_device_manufacturer | Unknown | |
properties_device_model | Unknown | |
properties_device_number | Unknown | |
properties_device_range | Unknown | |
properties_device_type | Unknown | |
properties_device_zone_address | Unknown | |
properties_location_in_site | Unknown | |
properties_serial | Unknown | |
properties_system_name | Unknown | |
status | Unknown | |
task_list | Unknown | |
type | Unknown | |
updated | Unknown | |
uri | Unknown |
quote_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lib_item_id | Unknown | FK |
quote_id | Unknown | FK |
service_line_id | Unknown | FK |
service_request_id | Unknown | FK |
cost | Unknown | |
description | Unknown | |
price | Unknown | |
quantity | Unknown | |
tax_rate | Unknown | |
tax_rate_details | Json | |
uri | Unknown | |
visibility | Json |
clock_event_unpaired_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
clock_event_id | Unknown | PKFK |
appointment_id | Unknown | FK |
job_id | Unknown | FK |
user_id | Unknown | FK |
activity | Unknown | |
caller_id_name | Unknown | |
caller_id_num | Unknown | |
completed | Unknown | |
deficiency | Unknown | |
event_time | Unknown | |
event_type | Unknown | |
lat | Unknown | |
lon | Unknown | |
other_trade_deficiency | Unknown | |
red_tag | Unknown | |
source | Unknown | |
started | Unknown | |
uri | Unknown |
clock_event
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
appointment_id | Unknown | FK |
end_job_id | Unknown | FK |
end_user_id | Unknown | FK |
job_id | Unknown | FK |
user_id | Unknown | FK |
activity | Unknown | |
caller_id_name | Unknown | |
caller_id_num | Unknown | |
completed | Unknown | |
created | Unknown | |
deficiency | Unknown | |
elapsed_time | Unknown | |
end_activity | Unknown | |
end_appointment | Json | |
end_caller_id_name | Unknown | |
end_caller_id_num | Unknown | |
end_completed | Unknown | |
end_deficiency | Unknown | |
end_event_time | Unknown | |
end_event_type | Unknown | |
end_id | Unknown | |
end_lat | Unknown | |
end_lon | Unknown | |
end_other_trade_deficiency | Unknown | |
end_red_tag | Unknown | |
end_source | Unknown | |
end_started | Unknown | |
end_uri | Unknown | |
event_time | Unknown | |
event_type | Unknown | |
lat | Unknown | |
lon | Unknown | |
other_trade_deficiency | Unknown | |
red_tag | Unknown | |
source | Unknown | |
started | Unknown | |
uri | Unknown |
contract_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_id | Unknown | PKFK |
name | Unknown | |
uri | Unknown |
contract
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
owner_id | Unknown | FK |
active | Unknown | |
actual_margin | Unknown | |
agreement_type | Unknown | |
all_items_have_costs | Unknown | |
complexity | Unknown | |
created | Unknown | |
customer | Unknown | |
customer_po | Unknown | |
description | Unknown | |
entity_filter | Unknown | |
expected_margin | Unknown | |
expected_revenue | Unknown | |
expires_on | Unknown | |
external_id | Json | |
invoice_detail_level | Unknown | |
invoice_notes | Unknown | |
invoice_terms | Unknown | |
job_terms | Unknown | |
job_type | Unknown | |
location | Unknown | |
location_context | Unknown | |
name | Unknown | |
office | Unknown | |
owner | Unknown | |
parent | Unknown | |
payment_terms_id | Unknown | |
payment_terms_name | Unknown | |
payment_terms_order_index | Unknown | |
payment_terms_uri | Unknown | |
quote_detail_level | Unknown | |
quote_terms | Unknown | |
region | Unknown | |
revenue | Unknown | |
revenue_as_of | Unknown | |
review_on | Unknown | |
sales | Unknown | |
starts_on | Unknown | |
type | Unknown | |
updated | Unknown | |
uri | Unknown | |
vendor_id | Unknown | |
vendor_name | Unknown | |
vendor_status | Unknown | |
vendor_uri | Unknown |
job_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
job_id | Unknown | FK |
lib_item_id | Unknown | FK |
quote_item_id | Unknown | FK |
service_line_id | Unknown | FK |
service_request_id | Unknown | FK |
cost | Unknown | |
created | Unknown | |
external_id | Json | |
name | Unknown | |
quantity | Unknown | |
source | Unknown | |
time_used | Unknown | |
updated | Unknown | |
uri | Unknown | |
used_on | Unknown | |
visibility | Json |
service_request_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
lib_item_id | Unknown | FK |
service_line_id | Unknown | FK |
service_recurrence_id | Unknown | FK |
service_request_id | Unknown | FK |
description | Unknown | |
price | Unknown | |
quantity | Unknown | |
uri | Unknown |
invoice_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
invoice_id | Unknown | FK |
invoice_recurrence_id | Unknown | FK |
job_item_id | Unknown | FK |
lib_item_id | Unknown | FK |
service_line_id | Unknown | FK |
created | Unknown | |
description | Unknown | |
job_item | Unknown | |
order_index | Unknown | |
price | Unknown | |
quantity | Unknown | |
service_request | Unknown | |
sub_total | Unknown | |
tax_amount | Unknown | |
tax_group | Unknown | |
tax_rate | Unknown | |
tax_rate_detail | Json | |
total_price | Unknown | |
updated | Unknown | |
uri | Unknown | |
window_end | Unknown | |
window_start | Unknown |
deficiency_report
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
asset_id | Unknown | FK |
deficiency_id | Unknown | FK |
job_id | Unknown | FK |
service_line_id | Unknown | FK |
created | Unknown | |
description | Unknown | |
proposed_fix | Unknown | |
report_source | Unknown | |
reporter_avatar | Json | |
reporter_email | Unknown | |
reporter_id | Unknown | |
reporter_is_helper | Unknown | |
reporter_is_tech | Unknown | |
reporter_name | Unknown | |
reporter_status | Unknown | |
reporter_uri | Unknown | |
severity | Unknown | |
status | Unknown | |
updated | Unknown | |
uri | Unknown |