# SolarWinds Service Desk schema ERD

Table and field reference for the Fivetran SolarWinds Service Desk connector.

## 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 | PK, FK |
| name | Unknown |  |
| taggings_count | Unknown |  |

### release_approver

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### release_change

| Column | Type | Keys |
| --- | --- | --- |
| change_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### release_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| release_id | Unknown | PK, FK |
| 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 | PK, FK |
| release_id | Unknown | PK, FK |

### release_problem

| Column | Type | Keys |
| --- | --- | --- |
| problem_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### release_solution

| Column | Type | Keys |
| --- | --- | --- |
| release_id | Unknown | PK, FK |
| solution_id | Unknown | PK, FK |

### release_purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| purchase_order_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### 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 | PK, FK |
| problem_id | Unknown | PK, FK |

### problem_asset

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| problem_id | Unknown | PK, FK |

### problem_solution

| Column | Type | Keys |
| --- | --- | --- |
| problem_id | Unknown | PK, FK |
| solution_id | Unknown | PK, FK |

### problem_tag

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| problem_id | Unknown | PK, FK |
| id | Unknown |  |
| taggings_count | Unknown |  |

### problem_configuration_item

| Column | Type | Keys |
| --- | --- | --- |
| configuration_item_id | Unknown | PK, FK |
| problem_id | Unknown | PK, FK |

### problem_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| problem_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |

### hardware_display

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hardware_id | Unknown | PK, FK |
| 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 | PK, FK |
| chipset | Unknown |  |
| memory | Unknown |  |
| name | Unknown |  |
| reported_at | Unknown |  |
| samagent_object_hash | Unknown |  |

### hardware_controller

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hardware_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| description | Unknown |  |
| manufacturer | Unknown |  |
| name | Unknown |  |
| reported_at | Unknown |  |
| samagent_object_hash | Unknown |  |

### hardware_memory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| hardware_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| name | Unknown |  |
| taggings_count | Unknown |  |

### contract_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| contract_id | Unknown | PK, FK |
| 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 | PK, FK |
| users_id | Unknown | PK, FK |

### user_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |

### configuration_item_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| custom_field_id | Unknown | PK |
| configuration_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| incident_id | Unknown | PK, FK |

### configuration_item_problem

| Column | Type | Keys |
| --- | --- | --- |
| configuration_item_id | Unknown | PK, FK |
| problem_id | Unknown | PK, FK |

### configuration_item_purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| configuration_item_id | Unknown | PK, FK |
| purchase_order_id | Unknown | PK, FK |

### configuration_item_release

| Column | Type | Keys |
| --- | --- | --- |
| configuration_item_id | Unknown | PK, FK |
| release_id | Unknown | PK, FK |

### configuration_item_change

| Column | Type | Keys |
| --- | --- | --- |
| change_id | Unknown | PK, FK |
| configuration_item_id | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| custom_field_id | Unknown |  |
| name | Unknown |  |
| type_name | Unknown |  |
| value | Unknown |  |

### purchase_order_attachment

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| purchase_order_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| configuration_item_id | Unknown | PK, FK |

### change_purchase_order

| Column | Type | Keys |
| --- | --- | --- |
| change_id | Unknown | PK, FK |
| purchase_order_id | Unknown | PK, FK |
| href | Unknown |  |

### change_task

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_id | Unknown | PK, FK |
| href | Unknown |  |

### change_solution

| Column | Type | Keys |
| --- | --- | --- |
| change_id | Unknown | PK, FK |
| solution_id | Unknown | PK, FK |
| href | Unknown |  |

### change_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| change_id | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown |  |
| taggings_count | Unknown |  |

### catalog_item_variable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| catalog_item_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| type | Unknown |  |
| users | Unknown |  |

### group_custom_field

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| groups_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| cc | Unknown |  |

### incident_problem

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | Unknown | PK, FK |
| problem_id | Unknown | PK, FK |

### incident_change

| Column | Type | Keys |
| --- | --- | --- |
| change_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_solution

| Column | Type | Keys |
| --- | --- | --- |
| incident_id | Unknown | PK, FK |
| solution_id | Unknown | PK, FK |

### incident_sla_violation

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| 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 | PK, FK |
| release_id | Unknown | PK, FK |

### incident_configuration_item

| Column | Type | Keys |
| --- | --- | --- |
| configuration_item_id | Unknown | PK, FK |
| incident_id | Unknown | PK, FK |

### incident_custom_field_value

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| incident_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| purchase_order_id | Unknown | PK, FK |

### 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 |  |

## Relationships

- software(category_id) → category(id)
- software(vendor_id) → vendor(id)
- release_tag(release_id) → release(id)
- release_approver(id) → users(id)
- release_approver(release_id) → release(id)
- release_change(change_id) → change(id)
- release_change(release_id) → release(id)
- release_custom_field(user_id) → users(id)
- release_custom_field(release_id) → release(id)
- release_configuration_item(configuration_item_id) → configuration_item(id)
- release_configuration_item(release_id) → release(id)
- release_problem(problem_id) → problem(id)
- release_problem(release_id) → release(id)
- release_solution(solution_id) → solution(id)
- release_solution(release_id) → release(id)
- release_purchase_order(purchase_order_id) → purchase_order(id)
- release_purchase_order(release_id) → release(id)
- release(department_id) → department(id)
- release(created_by_id) → users(id)
- release(assignee_id) → users(id)
- release(requester_id) → users(id)
- release(site_id) → site(id)
- problem_change(change_id) → change(id)
- problem_change(problem_id) → problem(id)
- problem_asset(problem_id) → problem(id)
- problem_solution(solution_id) → solution(id)
- problem_solution(problem_id) → problem(id)
- problem_tag(problem_id) → problem(id)
- problem_configuration_item(configuration_item_id) → configuration_item(id)
- problem_configuration_item(problem_id) → problem(id)
- problem_custom_field_value(user_id) → users(id)
- problem_custom_field_value(problem_id) → problem(id)
- problem(department_id) → department(id)
- problem(created_by_id) → users(id)
- problem(assignee_id) → users(id)
- problem(role_id) → role(id)
- problem(reports_to_id) → users(id)
- problem(requester_id) → users(id)
- problem(site_id) → site(id)
- solution(creator_id) → users(id)
- solution_time_track(creator_id) → users(id)
- solution_time_track(parent_id) → solution(id)
- solution_time_track(solution_id) → solution(id)
- change_time_track(creator_id) → users(id)
- change_time_track(parent_id) → change(id)
- change_time_track(change_id) → change(id)
- hardware_custom_field_value(user_id) → users(id)
- hardware_custom_field_value(hardware_id) → hardware(id)
- hardware_bios(hardware_id) → hardware(id)
- hardware_network(hardware_id) → hardware(id)
- hardware_drive(hardware_id) → hardware(id)
- hardware_printer(id) → printer(id)
- hardware_printer(hardware_id) → hardware(id)
- hardware_display(hardware_id) → hardware(id)
- hardware_video(hardware_id) → hardware(id)
- hardware_controller(hardware_id) → hardware(id)
- hardware_input(hardware_id) → hardware(id)
- hardware_sound(hardware_id) → hardware(id)
- hardware_memory(hardware_id) → hardware(id)
- hardware_port(hardware_id) → hardware(id)
- hardware_storage(hardware_id) → hardware(id)
- hardware(category_id) → category(id)
- hardware(department_id) → department(id)
- hardware(owner_id) → users(id)
- hardware(site_id) → site(id)
- printer(site_id) → site(id)
- printer(department_id) → department(id)
- printer(technical_contact_id) → users(id)
- contract_tag(contract_id) → contract(id)
- contract_custom_field(contract_id) → contract(id)
- contract_item(contract_id) → contract(id)
- contract(department_id) → department(id)
- contract(site_id) → site(id)
- user_group(group_id) → groups(id)
- user_group(users_id) → users(id)
- user_custom_field(users_id) → users(id)
- users(department_id) → department(id)
- users(role_id) → role(id)
- users(reports_to_id) → users(id)
- users(site_id) → site(id)
- configuration_item_mobile(id) → mobile(id)
- configuration_item_mobile(configuration_item_id) → configuration_item(id)
- configuration_item_custom_field_value(configuration_item_id) → configuration_item(id)
- configuration_item_incident(incident_id) → incident(id)
- configuration_item_incident(configuration_item_id) → configuration_item(id)
- configuration_item_problem(problem_id) → problem(id)
- configuration_item_problem(configuration_item_id) → configuration_item(id)
- configuration_item_purchase_order(purchase_order_id) → purchase_order(id)
- configuration_item_purchase_order(configuration_item_id) → configuration_item(id)
- configuration_item_release(release_id) → release(id)
- configuration_item_release(configuration_item_id) → configuration_item(id)
- configuration_item_change(change_id) → change(id)
- configuration_item_change(configuration_item_id) → configuration_item(id)
- configuration_item(user_id) → users(id)
- configuration_item(department_id) → department(id)
- configuration_item(manager_id) → users(id)
- configuration_item(site_id) → site(id)
- purchase_order_item(purchase_order_id) → purchase_order(id)
- purchase_order_custom_field_value(purchase_order_id) → purchase_order(id)
- purchase_order_attachment(purchase_order_id) → purchase_order(id)
- purchase_order(vendor_id) → vendor(id)
- purchase_order(department_id) → department(id)
- purchase_order(buyer_id) → users(id)
- purchase_order(requester_id) → users(id)
- purchase_order(site_id) → site(id)
- other_asset_hardware_date(other_asset_id) → other_asset(id)
- other_asset_custom_field_value(other_asset_id) → other_asset(id)
- other_asset(category_id) → category(id)
- other_asset(department_id) → department(id)
- other_asset(owner_id) → users(id)
- other_asset(site_id) → site(id)
- problem_time_track(creator_id) → users(id)
- problem_time_track(parent_id) → problem(id)
- problem_time_track(problem_id) → problem(id)
- incident_time_track(creator_id) → users(id)
- incident_time_track(parent_id) → incident(id)
- incident_time_track(incident_id) → incident(id)
- change_configuration_item(configuration_item_id) → configuration_item(id)
- change_configuration_item(change_id) → change(id)
- change_purchase_order(purchase_order_id) → purchase_order(id)
- change_purchase_order(change_id) → change(id)
- change_task(change_id) → change(id)
- change_solution(solution_id) → solution(id)
- change_solution(change_id) → change(id)
- change_custom_field_value(user_id) → users(id)
- change_custom_field_value(change_id) → change(id)
- change(department_id) → department(id)
- change(created_by_id) → users(id)
- change(assignee_id) → users(id)
- change(requester_id) → users(id)
- change(site_id) → site(id)
- catalog_item_tag(catalog_item_id) → catalog_item(id)
- catalog_item_variable(catalog_item_id) → catalog_item(id)
- catalog_item(category_id) → category(id)
- catalog_item(department_id) → department(id)
- catalog_item(site_id) → site(id)
- mobile_custom_field_value(mobile_id) → mobile(id)
- mobile(user_id) → users(id)
- mobile(department_id) → department(id)
- mobile(technical_contact_id) → users(id)
- mobile(site_id) → site(id)
- group_membership(groups_id) → groups(id)
- group_custom_field(groups_id) → groups(id)
- groups(reports_to_id) → groups(id)
- risk_affected_asset(risk_id) → risk(id)
- category(parent_id) → category(id)
- incident_cc(incident_id) → incident(id)
- incident_problem(problem_id) → problem(id)
- incident_problem(incident_id) → incident(id)
- incident_change(change_id) → change(id)
- incident_change(incident_id) → incident(id)
- incident_solution(solution_id) → solution(id)
- incident_solution(incident_id) → incident(id)
- incident_sla_violation(assignee_id) → users(id)
- incident_sla_violation(incident_id) → incident(id)
- incident_release(release_id) → release(id)
- incident_release(incident_id) → incident(id)
- incident_configuration_item(configuration_item_id) → configuration_item(id)
- incident_configuration_item(incident_id) → incident(id)
- incident_custom_field_value(user_id) → users(id)
- incident_custom_field_value(incident_id) → incident(id)
- incident_statistic(incident_id) → incident(id)
- incident_request_variable(incident_id) → incident(id)
- incident_purchase_order(purchase_order_id) → purchase_order(id)
- incident_purchase_order(incident_id) → incident(id)
- incident(category_id) → category(id)
- incident(department_id) → department(id)
- incident(resolved_by_id) → users(id)
- incident(assignee_id) → users(id)
- incident(site_id) → site(id)