Tables and classes

If a table is not included in this list, it does not extend another table.

A table can "extend" another table.

A table that extends another table is called a child class, and the table it extends is the parent class.

If a table is extended, but itself is not extending another table, it is then called a base class.

For a child class record, the database stores new fields unique to the child class and stores the rest of the fields in the parent class. This means that one record in a child class exists both in the child class and the parent class. The record in the child class has a corresponding record (with the same sys_id identifier) in both the parent and child classes, which will always be accessed together as one record by the platform. When a record in one class is deleted, the platform automatically deletes its counterpart in its matching class.
Important: If you edit a field on a child table that is present on the parent table, you will also change it for the parent table and all other child tables.

To see the relationships between classes, use the schema map.

The following is a table of tables in the platform that extend other tables:
Note: If a table is not included here, it does not extend another table.
Table 1. Tables that extend other tables
Table Name and label Description Extension of
Adobe Software License

[ast_license_adobe]

Adobe Software License Base License Table

[ast_license_base]

Generic Software License

[ast_license_generic]

Generic Software License Base License Table

[ast_license_base]

Microsoft Software License

[ast_license_msft]

Microsoft Software License Base License Table

[ast_license_base]

Symantec Software License

[ast_license_symantec]

Symantec Software License Base License Table

[ast_license_base]

Service Contract

[ast_service]

Information about service contracts for asset management purposes. Contract

[ast_contract]

Warranty

[ast_warranty]

Warranty Contract

[ast_contract]

BSM Map Actions

[bsm_action]

Actions on the map. Diagrammer Actions

[diagrammer_action]

Catalog Client Scripts

[catalog_script_client]

Catalog Client Scripts Client Script

[sys_script_client]

Catalog UI Policy

[catalog_ui_policy]

Catalog UI Policy UI Policy

[sys_ui_policy]

Catalog UI Policy Action

[catalog_ui_policy_action]

Catalog UI Policy Action UI Policy Action

[sys_ui_policy_action]

Change Phase

[change_phase]

Change Phase Task

[task]

Change Request

[change_request]

Change Request Task

[task]

IMAC

[change_request_imac]

IMAC Change Request

[change_request]

Change Task

[change_task]

Change Task Task

[task]

Accessory

[cmdb_ci_acc]

Data about communication accessories such as phones and computers. Configuration Item

[cmdb_ci ]

AIX Server

[cmdb_ci_aix_server]

AIX Server Unix Server

[cmdb_ci_unix_server]

Apache Web Server

[cmdb_ci_apache_web_server]

Apache Web Server Web Server

[cmdb_ci_web_server]

Application

[cmdb_ci_appl]

Data such as TCP port, PID and configuration files, related to running processes. Configuration Item

[cmdb_ci]

Application Software

[cmdb_ci_application_software]

Data about installed software. Software

[cmdb_ci_spkg]

Application Server

[cmdb_ci_app_server]

A base table for various application servers such as TomCat and Websphere. Application

[cmdb_ci_appl]

Domino

[cmdb_ci_app_server_domino]

Domino Application Server

[cmdb_ci_app_server]

Java Server

[cmdb_ci_app_server_java]

Java Server Application Server

[cmdb_ci_app_server]

Jboss

[cmdb_ci_app_server_jboss]

Jboss Application

[cmdb_ci_app_server]

Tomcat

[cmdb_ci_app_server_tomcat]

Tomcat Application Server

[cmdb_ci_app_server]

BEA Weblogic

[cmdb_ci_app_server_weblogic]

BEA Weblogic Application Server

[cmdb_ci_app_server]

IBM Websphere

[cmdb_ci_app_server_websphere]

IBM Websphere Application Server

[cmdb_ci_app_server]

Business Process

[cmdb_ci_business_process]

Business Process Configuration Item

[cmdb_ci]

Circuit

[cmdb_ci_circuit]

Circuit Configuration Item

[cmdb_ci]

Cluster

[cmdb_ci_cluster]

Cluster Configuration Item

[cmdb_ci]

Cluster Node

[cmdb_ci_cluster_node]

Cluster Node Configuration Item

[cmdb_ci]

Cluster Resource

[cmdb_ci_cluster_resource]

Cluster Resource Configuration Item

[cmdb_ci]

Cluster Virtual IP

[cmdb_ci_cluster_vip]

Data about cluster VIP. Configuration Item

[cmdb_ci]

Communication Device

[cmdb_ci_comm]

Data about communication devices such as cellphones, phones, conference phones and wifi. Configuration Item

[cmdb_ci]

Computer

[cmdb_ci_computer]

Computer Configuration Item

[cmdb_ci]

Computer Room

[Roomcmdb_ci_computer_room]

Computer Room Configuration Item

[cmdb_ci]

Computer Room AC

[cmdb_ci_crac]

Computer room AC properties such as wattage and type of cooling. Configuration Item

[cmdb_ci]

Database

[cmdb_ci_database]

Database Configuration Item

[cmdb_ci]

Data Center

[cmdb_ci_datacenter]

Data such as computers' max power and power consumption, for the data center. Configuration Item

[cmdb_ci]

Database Catalog

[cmdb_ci_db_catalog]

Database Catalog Configuration Item

[cmdb_ci]

DB2 Catalog

[cmdb_ci_db_db2_catalog]

DB2 Catalog Database Catalog

[cmdb_ci_db_catalog]

DB2 Instance

[cmdb_ci_db_db2_instance]

DB2 Instance Database Instance

[cmdb_ci_db_instance]

Database Instance

[cmdb_ci_db_instance]

Data about database process. Application

[cmdb_ci_appl]

MSFT SQL Catalog

[cmdb_ci_db_mssql_catalog]

Database catalog for MSFT SQL. Database Catalog

[cmdb_ci_db_catalog]

MSFT SQL Instance

[cmdb_ci_db_mssql_instance]

Data about attributes specific for MSFT SQL instance. Database Instance

[cmdb_ci_db_instance]

MySQL Catalog

[cmdb_ci_db_mysql_catalog]

MySQL Catalog Database Catalog

[cmdb_ci_db_catalog]

MySQL Instance

[cmdb_ci_db_mysql_instance]

MySQL Instance Database Instance

[cmdb_ci_db_instance]

Oracle Catalog

[cmdb_ci_db_ora_catalog]

Oracle Catalog Database Catalog

[cmdb_ci_db_catalog]

Oracle Instance

[cmdb_ci_db_ora_instance]

Data specific for Oracle. Database Instance

[cmdb_ci_db_instance]

Sybase Catalog

[cmdb_ci_db_syb_catalog]

Sybase Catalog Database Catalog

[cmdb_ci_db_catalog]

Sybase Instance

[cmdb_ci_db_syb_instance]

Data specific for Sybase. Database Instance

[cmdb_ci_db_instance]

Desktop Software

[cmdb_ci_desktop_software]

Desktop Software Software

[cmdb_ci_spkg]

Directory Server

[cmdb_ci_directory_server]

Directory Server Infrastructure Service

[cmdb_ci_infra_service]

Disk

[cmdb_ci_disk]

Data about physical disks on the server. Configuration Item

[cmdb_ci]

Email Server

[cmdb_ci_email_server]

Email Server Infrastructure Service

[cmdb_ci_infra_service]

ESX Server

[cmdb_ci_esx_server]

Data about the physical ESX server where Vmware ESXi OS is running. Server

[cmdb_ci_server]

File System

[cmdb_ci_file_system]

Data such as mount point, capacity and type of file system for the file system information on the server. Configuration Item

[cmdb_ci]

NFS File System

[cmdb_ci_file_system_nfs]

Data about NFS file systems. File System

[cmdb_ci_file_system]

SMB File System

[cmdb_ci_file_system_smb]

SMB File System File System

[cmdb_ci_file_system]

FTP Server

[cmdb_ci_ftp_server]

FTP Server Infrastructure Service

[cmdb_ci_infra_service]

Group

[cmdb_ci_group]

Group Configuration Item

[cmdb_ci]

HPUX Server

[cmdb_ci_hpux_server]

HPUX Server Unix Server

[cmdb_ci_unix_server]

Infrastructure Service

[cmdb_ci_infra_service]

Infrastructure Service Application

[cmdb_ci_appl]

LDAP Service

[cmdb_ci_infra_service_ldap]

LDAP Service Infrastructure Service

[cmdb_ci_infra_service]

Infrastructure Software

[cmdb_ci_inf_software]

Infrastructure Software Software

[cmdb_ci_spkg]

IP Device

[cmdb_ci_ip_device]

IP Device Configuration Item

[cmdb_ci]

IP Network

[cmdb_ci_ip_network]

Data such as subnet, router and router_interface_type, about IP networks. Configuration Item

[cmdb_ci]

IP Phone

[cmdb_ci_ip_phone]

IP Phone Configuration Item

[cmdb_ci]

IP Router

[cmdb_ci_ip_router]

A specialization of the Network Gear table. Network Gear

[cmdb_ci_netgear]

IP Server

[cmdb_ci_ip_server]

IP Server Infrastructure Service

[cmdb_ci_infra_service]

IP Service

[cmdb_ci_ip_service]

IP Service Configuration Item

[cmdb_ci]

IP Switch

[cmdb_ci_ip_switch]

A specialization of the Network Gear table. Network Gear

[cmdb_ci_netgear]

iPlanet Web Server

[cmdb_ci_iplanet_web_server]

iPlanet Web Server Web Server

[cmdb_ci_web_server]

Linux Server

[cmdb_ci_linux_server]

Linux Server Server

[cmdb_ci_server]

IBM Mainframe

[cmdb_ci_mainframe]

IBM Mainframe Server

[cmdb_ci_server]

IBM Mainframe LPAR

[cmdb_ci_mainframe_lpar]

IBM Mainframe LPAR Server

[cmdb_ci_server]

Microsoft IIS Web Server

[cmdb_ci_microsoft_iis_web_server]

Microsoft IIS Web Server Web Server

[cmdb_ci_web_server]

Storage Device

[cmdb_ci_msd]

Storage Device Configuration Item

[cmdb_ci]

Network Gear

[cmdb_ci_netgear]

Data about network equipment such as routers, switches, hubs, gateways and bridges. Hardware

[cmdb_ci_hardware]

Netware Server

[cmdb_ci_netware_server]

Netware Server Server

[cmdb_ci_server]

Network Adapter

[cmdb_ci_network_adapter]

Data about network adapters such as netmasks and mac manufacturers. Configuration Item

[cmdb_ci]

Network Traffic

[cmdb_ci_net_traffic]

Network Traffic Configuration Item

[cmdb_ci]

NGINX Web Server

[cmdb_ci_nginx_web_server]

NGINX Web Server Web Server

[cmdb_ci_web_server]

OS/X Server

[cmdb_ci_osx_server]

OS/X Server Server

[cmdb_ci_server]

Patch

[cmdb_ci_patches]

Patch Configuration Item

[cmdb_ci]

PDU

[cmdb_ci_pdu]

PDU Configuration Item

[cmdb_ci]

Outlet

[cmdb_ci_pdu_outlet]

Outlet Configuration Item

[cmdb_ci]

Computer Peripheral

[cmdb_ci_peripheral]

Data such as monitors, docking stations, kvm switchs, projectors, scanners, keyboards and UPS, related to computer peripherals. Configuration Item

[cmdb_ci]

Printer

[cmdb_ci_printer]

Data such as pages per minute (PPM), printer type, paper type and resolution, related to printers. Hardware

[cmdb_ci_hardware]

Print Queue

[cmdb_ci_print_queue]

Print Queue Configuration Item

[cmdb_ci]

Rack

[cmdb_ci_rack]

Data such as rack units, rack units in use and power consumption, related to a rack in a datacenter. Configuration Item

[cmdb_ci]

Server

[cmdb_ci_server]

Additional data about servers, such as used for and server classification. Computer

[cmdb_ci_computer]

Business Service

[cmdb_ci_service]

Data such as used for, SLAs, business criticality and service classification, related to business service. Configuration Item

[cmdb_ci]

SNC Component

[cmdb_ci_snc_component]

SNC Component Configuration Item

[cmdb_ci]

Solaris Server

[cmdb_ci_solaris_server]

Solaris Server

[cmdb_ci_unix_server]

Software

[cmdb_ci_spkg]

Data such as version, install count, license count, package name, key (when SAM is enabled), related to software packages. Configuration Item

[cmdb_ci]

Tomcat Connector

[cmdb_ci_tomcat_connector]

Tomcat Connector Configuration Item

[cmdb_ci]

Unix Daemon

[cmdb_ci_unix_daemon]

Unix Daemon IP Service

[cmdb_ci_ip_service]

Unix Server

[cmdb_ci_unix_server]

Unix Server Server

[cmdb_ci_server]

UPS

[cmdb_ci_ups]

Data such as ups version, battery status and voltage parameters, related to UPS devices. Hardware

[cmdb_ci_hardware]

UPS Alarm

[cmdb_ci_ups_alarm]

UPS Alarm Configuration Item

[cmdb_ci]

UPS Bypass

[cmdb_ci_ups_bypass]

UPS Bypass Configuration Item

[cmdb_ci]

UPS Input

[cmdb_ci_ups_input]

UPS Input Configuration Item

[cmdb_ci]

UPS Output

[cmdb_ci_ups_output]

UPS Output Configuration Item

[cmdb_ci]

Virtual Machine HyperVisor

[cmdb_ci_vm]

Data such as VMWare/Parallells/Solaris, related to Virtual Machine hypervisors. Application

[cmdb_ci_appl]

Parallels

[cmdb_ci_vm_parallels]

Parallels Virtual Machine

[cmdb_ci_vm]

VMware

[cmdb_ci_vm_vmware]

VMWare specialization of Virtual Machine. Virtual Machine

[cmdb_ci_vm]

Zones

[cmdb_ci_vm_zones]

Zones Virtual Machine

[cmdb_ci_vm]

Virtual Private Network

[cmdb_ci_vpn]

Virtual Private Network Configuration Item

[cmdb_ci]

Websphere Cell

[cmdb_ci_websphere_cell]

Websphere Cell Configuration Item

[cmdb_ci]

Web Application

[cmdb_ci_web_application]

Data such as document base and application server, related to web applications. Application

[cmdb_ci_appl]

Web Server

[cmdb_ci_web_server]

This is a specialization of the Server class for Windows. Infrastructure Service

[cmdb_ci_infra_service]

Web Service

[cmdb_ci_web_service]

Web Service Application

[cmdb_ci_appl]

Web Site

[cmdb_ci_web_site]

Data such as Web Server (Apache, IIS), related to Web sites. Application

[cmdb_ci_appl]

Windows Service

[cmdb_ci_windows_service]

Windows Service IP Service

[cmdb_ci_ip_service]

Windows Cluster

[cmdb_ci_win_cluster]

Windows Cluster Cluster

[cmdb_ci_cluster]

Windows Cluster Node

[cmdb_ci_win_cluster_node]

Windows Cluster Node Cluster Node

[cmdb_ci_cluster_node]

Windows Cluster Resource

[cmdb_ci_win_cluster_resource]

Windows Cluster Resource Cluster Resource

[cmdb_ci_cluster_resource]

Windows Server

[cmdb_ci_win_server]

Windows Server Server

[cmdb_ci_server]

Zone

[cmdb_ci_zone]

Zone Configuration Item

[cmdb_ci]

CI CPU Metrics

[cmdb_metric_cpu]

CI CPU Metrics CI Metric

[cmdb_metric]

CI DB Connection Metric

[cmdb_metric_db_connections]

CI DB Connection Metric CI Metric

[cmdb_metric]

Errors Logged

[cmdb_metric_errors]

Errors Logged CI Metric

[cmdb_metric]

Events Processed

[cmdb_metric_events_processed]

Events Processed CI Metric

[cmdb_metric]

Events Logged

[cmdb_metric_event_logs]

Events Logged CI Metric

[cmdb_metric]

CI Java Metric

[cmdb_metric_java]

CI Java Metric CI Metric

[cmdb_metric]

Linux Memory Metrics

[cmdb_metric_linux_memory]

Linux Memory Metrics CI Metric

[cmdb_metric]

CI Load Metrics

[cmdb_metric_load]

CI Load Metrics CI Metric

[cmdb_metric]

CI Log Count

[cmdb_metric_logs]

CI Log Count CI Metric

[cmdb_metric]

CI MySQL Metrics

[cmdb_metric_mysql_statements]

CI MySQL Metrics CI Metric

[cmdb_metric]

CI Oracle Metrics

[cmdb_metric_oracle]

CI Oracle Metrics CI Metric

[cmdb_metric]

Partition Read/Write Statistics

[cmdb_metric_partition]

Partition Read/Write Statistics CI Metric

[cmdb_metric]

CI Semaphore Metrics

[cmdb_metric_semaphores]

CI Semaphore Metrics CI Metric

[cmdb_metric]

CI Service-Now Metrics

[cmdb_metric_service_now]

CI Service-Now Metrics CI Metric

[cmdb_metric]

SQL Response Metrics

[cmdb_metric_sql]

SQL Response Metrics CI Metric

[cmdb_metric]

CI Transaction Metrics

[cmdb_metric_transactions]

CI Transaction Metrics CI Metric

[cmdb_metric]

Multiprobe

[discovery_probes_multi]

Multiprobe Probe

[discovery_probes]

SNMP Probe

[discovery_probes_snmp]

SNMP Probe Probe

[discovery_probes]

WMI Probe

[discovery_probes_wmi]

WMI Probe Probe

[discovery_probes]

ECC Agent Counter Metric

[ecc_agent_counter_metric]

ECC Agent Counter Metric ECC Agent Metric

[ecc_agent_metric]

ECC Agent Memory Metric

[ecc_agent_memory_metric]

ECC Agent Memory Metric ECC Agent Metric

[ecc_agent_metric]

ECC Agent RGR Metric

[ecc_agent_rgr_metric]

ECC Agent RGR Metric ECC Agent Metric

[ecc_agent_metric]

ECC Agent Scalar Metric

[ecc_agent_scalar_metric]

ECC Agent Scalar Metric ECC Agent Metric

[ecc_agent_metric]

Catalog Checkout Panel

[expert_panel_catalog_checkout]

Catalog Checkout Panel Wizard Panel

[expert_panel]

Catalog Order

[expert_panel_catalog_order]

Catalog Order Wizard Panel

[expert_panel]

KB Viewer

[expert_panel_knowledge]

KB Viewer Wizard Panel

[expert_panel]

Record Generator

[expert_panel_template]

Record Generator Wizard Panel

[expert_panel]

Wizard Client Script

[expert_script_client]

Wizard Client Script Client Script

[sys_script_client]

Wizard Variable

[expert_variable]

Wizard Variable Question

[question]

Import Log

[import_log]

Import Log Log Entry

[syslog]

Computer

[imp_computer]

Computer Import Set Row

[sys_import_set_row]

Location

[imp_location]

Location Import Set Row

[sys_import_set_row]

Notification

[imp_notification]

Notification Import Set Row

[sys_import_set_row]

User

[imp_user]

User Import Set Row

[sys_import_set_row]

Incident

[incident]

Incident Task

[task]

Variable

[item_option_new]

Variable Question

[question]

KB Submission

[kb_submission]

KB Submission Task

[task]

OLA

[ola]

OLA SLA

[sla]

Plan MySQL

[plan_mysql]

Plan MySQL Plan Execution

[plan_execution]

Plan Oracle

[plan_oracle]

Plan Oracle Plan Execution

[plan_execution]

Problem

[problem]

Problem Task

[task]

Approval Steps

[process_step_approval]

Approval Steps Process Steps

[process_step]

Release Phase

[release_phase]

Represents the stages of work required to complete a release. Task

[task]

Release Task

[release_task]

Represents the tasks required to create individual features. Task

[task]

Scheduled Data Import

[scheduled_data_import]

Scheduled Data Import Scheduled Job

[sysauto]

Scheduled Data Import

[scheduled_import_set]

Scheduled Data Import scheduled_data_import

[]

Dynamic Category

[sc_category_top_n]

Dynamic Category Category

[sc_category]

Content Item

[sc_cat_item_content]

Content Item Catalog Item

[sc_cat_item]

Execution Plan Approval Task

[sc_cat_item_dt_approval]

Execution Plan Approval Task Execution Plan Task

[sc_cat_item_delivery_task]

Order Guide

[sc_cat_item_guide]

Order Guide Catalog Item

[sc_cat_item]

Record Producer

[sc_cat_item_producer]

Record Producer Catalog Item

[sc_cat_item]

Wizard Launcher

[sc_cat_item_wizard]

Wizard Launcher Catalog Item

[sc_cat_item]

Request

[sc_request]

Request Task

[task]

Requested Item

[sc_req_item]

Requested Item Task

[task]

Catalog Task

[sc_task]

Catalog Task Task

[task]

Question

[survey_question_new]

Question Question

[question]

Group Approval

[sysapproval_group]

Group Approval Task

[task]

Scheduled Email of Report

[sysauto_report]

Scheduled Email of Report Scheduled Job

[sysauto]

Scheduled Script Extension

[sysauto_script]

Scheduled Script Extension Scheduled Job

[sysauto]

Scheduled Entity Generation

[sysauto_template]

Scheduled Entity Generation Scheduled Job

[sysauto]

Email Notification

[sysevent_email_action]

Email Notification Rule

[sysrule]

Inbound Email Actions

[sysevent_in_email_action]

Inbound Email Actions Rule

[sysrule]

Script Action

[sysevent_script_action]

Script Action Rule

[sysrule]

Transaction Log Entry

[syslog_transaction]

Transaction Log Entry Rule

[syslog]

Approval Rules

[sysrule_approvals]

Approval Rules Rule

[sysrule]

Assignment Rules

[sysrule_assignment]

Assignment Rules Rule

[sysrule]

Service Level Agreement

[sysrule_escalate]

Service Level Agreement Rule

[sysrule]

Inactivity Monitor

[sysrule_escalate_am]

Inactivity Monitor Service Level Agreement

[sysrule_escalate]

View Rule

[sysrule_view]

View Rule Rule

[sysrule]

Ticket

[ticket]

Ticket Task

[task]

Variables

[var_dictionary]

Variables Dictionary

[sys_dictionary]

Edit Field

[v_field_editor]

Edit Field Create Field

[v_field_creator]

Edit Table

[v_table_editor]

Edit Table Create Table

[v_table_creator]

Create Web Service

[v_ws_creator]

Create Web Service Create Table

[v_table_creator]

Edit Web Service

[v_ws_editor]

Edit Web Service Create Web Service

[v_ws_creator]

Create Web Service Field

[v_ws_field_creator]

Create Web Service Field Create Field

[v_field_creator]

Edit Web Service Field

[v_ws_field_editor]

Edit Web Service Field Edit Field

[v_field_editor]

Activity Variables

[wf_activity_variable]

Variables for activities. Variables

[var_dictionary]

Workflow Log Entry

[wf_log]

All of the events and history of the workflow. Log Entry

[syslog]

Workflow SC Variable

[wf_variable]

The Service Catalog variables for a workflow. Variable

[item_option_new]

Workflow Schedule

[wf_workflow_schedule]

Definitions of the times to run specific workflows. Scheduled Script Execution

[sysauto_script]