SolarWinds Service Desk
Explore the interactive ERD
Table & Field Reference
software
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
vendor_id | Unknown | FK |
created_at | Unknown | |
custom | Unknown | |
first_detected | Unknown | |
greynet | Unknown | |
hardwares_href | Unknown | |
hidden | Unknown | |
href | Unknown | |
installs | Unknown | |
is_primnary | Unknown | |
manufacturer | Unknown | |
name | Unknown | |
primary_id | Unknown | |
tags | Unknown | |
updated_at | Unknown | |
version | Unknown | |
windows_system_component | Unknown |
release_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
release_id | Unknown | PKFK |
name | Unknown | |
taggings_count | Unknown |
release_approver
| Column | Type | Keys |
|---|---|---|
id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_change
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
release_id | Unknown | PKFK |
user_id | Unknown | FK |
custom_field_id | Unknown | |
name | Unknown | |
options | Unknown | |
type_name | Unknown | |
value | Unknown |
release_configuration_item
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_problem
| Column | Type | Keys |
|---|---|---|
problem_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release_solution
| Column | Type | Keys |
|---|---|---|
release_id | Unknown | PKFK |
solution_id | Unknown | PKFK |
release_purchase_order
| Column | Type | Keys |
|---|---|---|
purchase_order_id | Unknown | PKFK |
release_id | Unknown | PKFK |
release
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
requester_id | Unknown | FK |
site_id | Unknown | FK |
build | Unknown | |
deploy | Unknown | |
description | Unknown | |
name | Unknown | |
number | Unknown | |
plan | Unknown | |
planned_end_at | Unknown | |
planned_start_at | Unknown | |
priority | Unknown | |
state | Unknown |
problem_change
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
problem_id | Unknown | PKFK |
problem_asset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
problem_id | Unknown | PKFK |
problem_solution
| Column | Type | Keys |
|---|---|---|
problem_id | Unknown | PKFK |
solution_id | Unknown | PKFK |
problem_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
problem_id | Unknown | PKFK |
id | Unknown | |
taggings_count | Unknown |
problem_configuration_item
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
problem_id | Unknown | PKFK |
problem_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
problem_id | Unknown | PKFK |
user_id | Unknown | FK |
custom_field_id | Unknown | |
name | Unknown | |
options | Unknown | |
type_name | Unknown | |
value | Unknown |
problem
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
reports_to_id | Unknown | FK |
requester_id | Unknown | FK |
role_id | Unknown | FK |
site_id | Unknown | FK |
created_at | Unknown | |
custom | Unknown | |
description | Unknown | |
description_no_html | Unknown | |
href | Unknown | |
name | Unknown | |
number | Unknown | |
other_assets | Json | |
priority | Unknown | |
root_cause | Unknown | |
state | Unknown | |
symptoms | Unknown | |
tasks | Json | |
updated_at | Unknown | |
workaround | Unknown |
solution
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
creator_id | Unknown | FK |
attachments | Json | |
created_at | Unknown | |
description | Unknown | |
description_no_html | Unknown | |
href | Unknown | |
is_allow_to_vote | Unknown | |
name | Unknown | |
number | Unknown | |
number_of_attachments | Unknown | |
number_of_shared_attachments | Unknown | |
shared_attachments | Json |
solution_time_track
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
solution_id | Unknown | PKFK |
creator_id | Unknown | FK |
parent_id | Unknown | FK |
created_at | Unknown | |
minutes | Unknown | |
name | Unknown | |
updated_at | Unknown |
change_time_track
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
change_id | Unknown | PKFK |
creator_id | Unknown | FK |
parent_id | Unknown | FK |
created_at | Unknown | |
minutes | Unknown | |
name | Unknown | |
updated_at | Unknown |
hardware_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
user_id | Unknown | FK |
custom_field_id | Unknown | |
name | Unknown | |
options | Unknown | |
type_name | Unknown | |
value | Unknown |
hardware_bios
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
bios_date | Unknown | |
manufacturer | Unknown | |
model | Unknown | |
previous_ssn | Unknown | |
reported_at | Unknown | |
ssn | Unknown | |
version | Unknown |
hardware_network
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
description | Unknown | |
dhcp | Unknown | |
gateway | Unknown | |
ip_address | Unknown | |
mac_address | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown | |
status | Unknown |
hardware_drive
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
drive_name | Unknown | |
drive_type | Unknown | |
free_space | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown | |
total_space | Unknown |
hardware_printer
| Column | Type | Keys |
|---|---|---|
hardware_id | Unknown | PKFK |
id | Unknown | PKFK |
hardware_display
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
description | Unknown | |
display_type | Unknown | |
manufacturer | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown | |
serial_number | Unknown |
hardware_video
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
chipset | Unknown | |
memory | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown |
hardware_controller
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
controller_type | Unknown | |
description | Unknown | |
manufacturer | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown | |
version | Unknown |
hardware_input
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
input_type | Unknown | |
manufacturer | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown |
hardware_sound
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
description | Unknown | |
manufacturer | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown |
hardware_memory
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
capacity | Unknown | |
description | Unknown | |
memory_type | Unknown | |
name | Unknown | |
purpose | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown | |
slot | Unknown | |
speed | Unknown |
hardware_port
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
description | Unknown | |
name | Unknown | |
port_type | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown |
hardware_storage
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
hardware_id | Unknown | PKFK |
description | Unknown | |
manufacturer | Unknown | |
model | Unknown | |
name | Unknown | |
reported_at | Unknown | |
samagent_object_hash | Unknown | |
size | Unknown | |
storage_type | Unknown |
hardware
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
department_id | Unknown | FK |
owner_id | Unknown | FK |
site_id | Unknown | FK |
active_directory | Unknown | |
address | Unknown | |
asset_tag | Unknown | |
audits_href | Unknown | |
barcode_encoding_format | Unknown | |
cpu | Unknown | |
created_at | Unknown | |
custom | Unknown | |
description | Unknown | |
detected_at | Unknown | |
domain | Unknown | |
external_ip | Unknown | |
hardware_spec_href | Unknown | |
hidden_softwares_href | Unknown | |
incidents_href | Unknown | |
ip | Unknown | |
latitude | Unknown | |
longitude | Unknown | |
memory | Unknown | |
model | Unknown | |
monitors | Unknown | |
name | Unknown | |
notes | Unknown | |
operating_system | Unknown | |
operating_system_version | Unknown | |
physical_memory | Unknown | |
processor_speed | Unknown | |
product_number | Unknown | |
purchase_orders_href | Unknown | |
risks_href | Unknown | |
serial_number | Unknown | |
softwares_href | Unknown | |
status_id | Unknown | |
status_name | Unknown | |
swap | Unknown | |
tags | Unknown | |
technical_contact_email | Unknown | |
updated_at | Unknown | |
username | Unknown |
printer
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
site_id | Unknown | FK |
technical_contact_id | Unknown | FK |
driver | Unknown | |
name | Unknown | |
port | Unknown | |
shared | Unknown |
contract_tag
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_id | Unknown | PKFK |
name | Unknown | |
taggings_count | Unknown |
contract_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
contract_id | Unknown | PKFK |
custom_field_id | Unknown | |
name | Unknown | |
type_name | Unknown | |
value | Unknown |
contract_item
| Column | Type | Keys |
|---|---|---|
_fivetran_id | String | PK |
contract_id | Unknown | FK |
created_at | Unknown | |
name | Unknown | |
notes | Unknown | |
quantity | Unknown | |
tags | Unknown | |
updated_at | Unknown | |
version | Unknown |
contract
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
site_id | Unknown | FK |
created_at | Unknown | |
end_date | Unknown | |
href | Unknown | |
manufacturer_name | Unknown | |
name | Unknown | |
note | Unknown | |
start_date | Unknown | |
status | Unknown | |
type | Unknown | |
updated_at | Unknown |
user_group
| Column | Type | Keys |
|---|---|---|
group_id | Unknown | PKFK |
users_id | Unknown | PKFK |
user_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
users_id | Unknown | PKFK |
custom_field_id | Unknown | |
name | Unknown | |
options | Unknown | |
type_name | Unknown | |
value | Unknown |
users
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
reports_to_id | Unknown | FK |
role_id | Unknown | FK |
site_id | Unknown | FK |
available_for_assignment | Unknown | |
avatar_color | Unknown | |
avatar_initials | Unknown | |
avatar_type | Unknown | |
can_be_available_for_assignment | Unknown | |
created_at | Unknown | |
disabled | Unknown | |
email | Unknown | |
last_login | Unknown | |
mobile_phone | Unknown | |
name | Unknown | |
phone | Unknown | |
provider | Unknown | |
title | Unknown | |
updated_at | Unknown |
configuration_item_mobile
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
id | Unknown | PKFK |
configuration_item_custom_field_value
| Column | Type | Keys |
|---|---|---|
custom_field_id | Unknown | PK |
configuration_item_id | Unknown | PKFK |
attachment | Unknown | |
entity | Unknown | |
id | Unknown | |
name | Unknown | |
options | Unknown | |
type | Unknown | |
type_name | Unknown | |
users | Unknown | |
value | Unknown |
configuration_item_incident
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
incident_id | Unknown | PKFK |
configuration_item_problem
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
problem_id | Unknown | PKFK |
configuration_item_purchase_order
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
purchase_order_id | Unknown | PKFK |
configuration_item_release
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
release_id | Unknown | PKFK |
configuration_item_change
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
configuration_item_id | Unknown | PKFK |
configuration_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
manager_id | Unknown | FK |
site_id | Unknown | FK |
user_id | Unknown | FK |
asset_tag | Unknown | |
assets | Json | |
attachments_count | Unknown | |
created_at | Unknown | |
deleted | Unknown | |
description | Unknown | |
discovery_hardwares | Json | |
name | Unknown | |
number | Unknown | |
origin | Unknown | |
other_assets | Json | |
parent_id | Unknown | |
parent_type | Unknown | |
state_id | Unknown | |
type_custom | Unknown | |
type_description | Unknown | |
type_icon_name | Unknown | |
type_id | Unknown | |
type_name | Unknown | |
type_parent_id | Unknown | |
type_updated_at | Unknown | |
updated_at | Unknown |
purchase_order_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
created_at | Unknown | |
description | Unknown | |
discount | Unknown | |
name | Unknown | |
part_number | Unknown | |
price | Unknown | |
quantity | Unknown | |
serial_number | Unknown | |
tax | Unknown | |
updated_at | Unknown |
purchase_order_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
custom_field_id | Unknown | |
name | Unknown | |
type_name | Unknown | |
value | Unknown |
purchase_order_attachment
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
purchase_order_id | Unknown | PKFK |
content_type | Unknown | |
filename | Unknown | |
secure_url | Unknown | |
size | Unknown | |
thumb_url | Unknown | |
url | Unknown |
purchase_order
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
buyer_id | Unknown | FK |
department_id | Unknown | FK |
requester_id | Unknown | FK |
site_id | Unknown | FK |
vendor_id | Unknown | FK |
billing_address | Unknown | |
created_at | Unknown | |
currency | Unknown | |
due_date | Unknown | |
href | Unknown | |
name | Unknown | |
notes | Unknown | |
number | Unknown | |
number_of_attachments | Unknown | |
order_date | Unknown | |
payment_terms | Unknown | |
recurrence | Unknown | |
shipping_address | Unknown | |
shipping_handling | Unknown | |
state | Unknown | |
tax | Unknown | |
terms_conditions | Unknown | |
total_cost | Unknown | |
updated_at | Unknown |
role
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
description | Unknown | |
name | Unknown | |
portal | Unknown | |
show_my_tasks | Unknown |
other_asset_hardware_date
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
other_asset_id | Unknown | PKFK |
date | Unknown | |
date_type | Unknown | |
notes | Unknown | |
user_type | Unknown | |
username | Unknown |
other_asset_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
other_asset_id | Unknown | PKFK |
attachment | Unknown | |
custom_field_id | Unknown | |
entity | Unknown | |
name | Unknown | |
options | Unknown | |
type | Unknown | |
type_name | Unknown | |
users | Unknown | |
value | Unknown |
other_asset
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
department_id | Unknown | FK |
owner_id | Unknown | FK |
site_id | Unknown | FK |
address | Unknown | |
asset_id | Unknown | |
asset_type_account_id | Unknown | |
asset_type_id | Unknown | |
asset_type_name | Unknown | |
asset_type_parent_id | Unknown | |
created_at | Unknown | |
custom | Unknown | |
description | Unknown | |
href | Unknown | |
incidents | Json | |
ip_address | Unknown | |
latitude | Unknown | |
lease_contract | Unknown | |
longitude | Unknown | |
maintenance_contract | Unknown | |
manufacturer | Unknown | |
model | Unknown | |
name | Unknown | |
purchase_orders | Json | |
serial_number | Unknown | |
status_id | Unknown | |
status_name | Unknown | |
tags | Json | |
tasks | Json | |
updated_at | Unknown | |
users | Unknown |
problem_time_track
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
problem_id | Unknown | PKFK |
creator_id | Unknown | FK |
parent_id | Unknown | FK |
created_at | Unknown | |
minutes | Unknown | |
name | Unknown | |
updated_at | Unknown |
vendor
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
address | Unknown | |
city | Unknown | |
contact_email | Unknown | |
contact_name | Unknown | |
contact_phone | Unknown | |
href | Unknown | |
name | Unknown | |
note | Unknown | |
state | Unknown | |
telephone | Unknown | |
url | Unknown | |
vendor_type_id | Unknown | |
vendor_type_name | Unknown | |
zip | Unknown |
department
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
default_assignee_id | Unknown | |
description | Unknown | |
name | Unknown |
incident_time_track
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
creator_id | Unknown | FK |
parent_id | Unknown | FK |
created_at | Unknown | |
minutes | Unknown | |
name | Unknown | |
updated_at | Unknown |
change_configuration_item
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
configuration_item_id | Unknown | PKFK |
change_purchase_order
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
purchase_order_id | Unknown | PKFK |
href | Unknown |
change_task
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
change_id | Unknown | PKFK |
href | Unknown |
change_solution
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
solution_id | Unknown | PKFK |
href | Unknown |
change_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
change_id | Unknown | PKFK |
user_id | Unknown | FK |
attachment | Unknown | |
custom_field_id | Unknown | |
entity | Unknown | |
name | Unknown | |
options | Unknown | |
type | Unknown | |
type_name | Unknown | |
value | Unknown |
change
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
created_by_id | Unknown | FK |
department_id | Unknown | FK |
requester_id | Unknown | FK |
site_id | Unknown | FK |
approve_denied_at | Unknown | |
approve_requested_at | Unknown | |
approved_at | Unknown | |
assets | Json | |
category | Unknown | |
cc | Json | |
created_at | Unknown | |
custom | Unknown | |
description | Unknown | |
description_no_html | Unknown | |
have_conflict | Unknown | |
href | Unknown | |
name | Unknown | |
number | Unknown | |
origin | Unknown | |
other_assets | Json | |
plan | Unknown | |
planned_end_at | Unknown | |
planned_start_at | Unknown | |
priority | Unknown | |
request_variables | Json | |
rollback_plan | Unknown | |
state | Unknown | |
sub_category | Unknown | |
tags | Json | |
test_plan | Unknown | |
type | Unknown | |
updated_at | Unknown | |
workflow_tasks | Json |
catalog_item_tag
| Column | Type | Keys |
|---|---|---|
name | Unknown | PK |
catalog_item_id | Unknown | PKFK |
id | Unknown | |
taggings_count | Unknown |
catalog_item_variable
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
catalog_item_id | Unknown | PKFK |
field_type | Unknown | |
helptext | Unknown | |
kind | Unknown | |
name | Unknown | |
options | Unknown | |
required | Unknown | |
sorted | Unknown |
catalog_item
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
category_id | Unknown | FK |
department_id | Unknown | FK |
site_id | Unknown | FK |
created_at | Unknown | |
currency | Unknown | |
custom | Unknown | |
description | Unknown | |
due_days | Unknown | |
href | Unknown | |
image_href | Unknown | |
name | Unknown | |
portal_homepage | Unknown | |
price | Unknown | |
request_count | Unknown | |
show_due_days | Unknown | |
show_price | Unknown | |
state | Unknown | |
tags | Unknown | |
updated_at | Unknown | |
url_id | Unknown | |
variables_unparsed | Unknown |
mobile_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
mobile_id | Unknown | PKFK |
custom_field_id | Unknown | |
name | Unknown | |
type_name | Unknown | |
value | Unknown |
mobile
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
department_id | Unknown | FK |
site_id | Unknown | FK |
technical_contact_id | Unknown | FK |
user_id | Unknown | FK |
company_issued | Unknown | |
description | Unknown | |
device_type | Unknown | |
imei | Unknown | |
manufacturer | Unknown | |
model | Unknown | |
serial_number | Unknown | |
status | Unknown |
group_membership
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
groups_id | Unknown | PKFK |
type | Unknown | |
users | Unknown |
group_custom_field
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
groups_id | Unknown | PKFK |
custom_field_id | Unknown | |
name | Unknown | |
type_name | Unknown | |
value | Unknown |
groups
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
reports_to_id | Unknown | FK |
description | Unknown | |
disabled | Unknown | |
is_user | Unknown | |
name | Unknown | |
send_notifications | Unknown | |
type | Unknown |
site
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
business_record | Unknown | |
description | Unknown | |
languages | Unknown | |
location | Unknown | |
name | Unknown | |
time_zone | Unknown |
risk_affected_asset
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
risk_id | Unknown | PKFK |
id | Unknown | |
name | Unknown | |
type | Unknown |
risk
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
at | Unknown | |
category | Unknown | |
created_at | Unknown | |
discarded | Unknown | |
name | Unknown | |
resolved | Unknown | |
severity | Unknown | |
updated | Unknown |
category
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
parent_id | Unknown | FK |
default_assignee_id | Unknown | |
default_tags | Unknown | |
name | Unknown |
incident_cc
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
incident_id | Unknown | PKFK |
cc | Unknown |
incident_problem
| Column | Type | Keys |
|---|---|---|
incident_id | Unknown | PKFK |
problem_id | Unknown | PKFK |
incident_change
| Column | Type | Keys |
|---|---|---|
change_id | Unknown | PKFK |
incident_id | Unknown | PKFK |
incident_solution
| Column | Type | Keys |
|---|---|---|
incident_id | Unknown | PKFK |
solution_id | Unknown | PKFK |
incident_sla_violation
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
assignee_id | Unknown | FK |
name | Unknown | |
resolved | Unknown | |
sla_id | Unknown | |
sla_type | Unknown | |
time_delay | Unknown | |
time_units | Unknown |
incident_release
| Column | Type | Keys |
|---|---|---|
incident_id | Unknown | PKFK |
release_id | Unknown | PKFK |
incident_configuration_item
| Column | Type | Keys |
|---|---|---|
configuration_item_id | Unknown | PKFK |
incident_id | Unknown | PKFK |
incident_custom_field_value
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
user_id | Unknown | FK |
attachment | Unknown | |
custom_field_id | Unknown | |
entity | Unknown | |
name | Unknown | |
option | Unknown | |
type | Unknown | |
type_name | Unknown | |
value | Unknown |
incident_statistic
| Column | Type | Keys |
|---|---|---|
index | Unknown | PK |
incident_id | Unknown | PKFK |
business_time_elapsed | Unknown | |
statistic_type | Unknown | |
time | Unknown | |
time_elapsed | Unknown | |
value | Unknown |
incident_request_variable
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
incident_id | Unknown | PKFK |
attachment | Unknown | |
custom_field_id | Unknown | |
entity | Unknown | |
name | Unknown | |
options | Unknown | |
type | Unknown | |
type_name | Unknown | |
users | Unknown | |
value | Unknown |
incident_purchase_order
| Column | Type | Keys |
|---|---|---|
incident_id | Unknown | PKFK |
purchase_order_id | Unknown | PKFK |
incident
| Column | Type | Keys |
|---|---|---|
id | Unknown | PK |
assignee_id | Unknown | FK |
category_id | Unknown | FK |
department_id | Unknown | FK |
resolved_by_id | Unknown | FK |
site_id | Unknown | FK |
assets | Json | |
created_at | Unknown | |
created_by_account_id | Unknown | |
created_by_avatar_color | Unknown | |
created_by_avatar_initials | Unknown | |
created_by_avatar_type | Unknown | |
created_by_customer_satisfaction_survey_time | Unknown | |
created_by_disabled | Unknown | |
created_by_email | Unknown | |
created_by_has_gravatar | Unknown | |
created_by_id | Unknown | |
created_by_name | Unknown | |
created_by_user_id | Unknown | |
custom | Unknown | |
customer_satisfaction_response | Unknown | |
customer_satisfaction_survey_completed_at | Unknown | |
customer_satisfaction_survey_sent_at | Unknown | |
description | Unknown | |
description_no_html | Unknown | |
discovery_hardwares | Json | |
due_at | Unknown | |
href | Unknown | |
href_account_domain | Unknown | |
is_customer_satisfied | Unknown | |
is_service_request | Unknown | |
name | Unknown | |
number | Unknown | |
number_of_comments | Unknown | |
origin | Unknown | |
other_assets | Json | |
priority | Unknown | |
requester_account_id | Unknown | |
requester_avatar_color | Unknown | |
requester_avatar_initials | Unknown | |
requester_avatar_type | Unknown | |
requester_disabled | Unknown | |
requester_email | Unknown | |
requester_id | Unknown | |
requester_name | Unknown | |
requester_user_id | Unknown | |
resolution | Unknown | |
resolution_code | Unknown | |
resolution_description | Unknown | |
resolution_type | Unknown | |
state | Unknown | |
subcategory_default_assignee_id | Unknown | |
subcategory_default_tag | Unknown | |
subcategory_deleted | Unknown | |
subcategory_id | Unknown | |
subcategory_name | Unknown | |
tasks | Json | |
total_time_spent | Unknown | |
updated_at | Unknown | |
user_saw_all_comments | Unknown |