ServiceNow Table Relationships and Schema Map

Summary

In this video from the 'Tech with Pre' channel, Pritam continues his ServiceNow series, focusing on table relationships and schema maps. He explains critical concepts like one-to-many, many-to-many, and extended relationships between ServiceNow tables. The video covers examples such as the incident, user, and task tables, demonstrating how these relationships work. Pritam also explores different table types, such as base, extended, core, and custom tables, with a visual demonstration using schema maps in ServiceNow. The video is part of a broader series on ServiceNow, aimed at helping viewers understand key concepts for their exams and practical applications.

Takeaways

• 📊 The video focuses on ServiceNow and its various table relationships, essential for both exams and practical understanding.
• 📝 In the previous video, different field types in ServiceNow, like string and choice fields, were discussed, particularly in relation to the incident form.
• 🔗 One-to-many relationships occur when one table references another, such as the caller field in the incident form referencing the user table.
• 👥 Many-to-many relationships involve two or more tables being related, as seen with the group and roles tables in ServiceNow.
• 📂 Extended relationships exist when one table extends another, like incident, change, and problem tables extending the task table.
• 🗺️ The schema map in ServiceNow visually represents the relationships between tables, helping users understand these complex connections.
• 💡 Base tables are not extended from any other table but can be extended by other tables, such as the task table.
• 🔧 Custom tables are created by users or developers within ServiceNow and can be configured to meet specific needs.
• 📋 Core tables are default tables provided by ServiceNow, like the incident, problem, and change tables.
• 📚 The video ends with a preview of how to create custom tables and fields in ServiceNow, which will be covered in the next video.

Q & A

What is the main focus of the 17th video in the ServiceNow series?

The main focus of the 17th video is to teach viewers about table relationships and schema maps in ServiceNow, which are crucial for understanding how different ServiceNow tables interact with each other.

What are the different types of ServiceNow field types discussed in the previous video?

The previous video discussed various ServiceNow field types including string, choice, and analyzed field types present in the incident form.

How is the 'caller' field in the incident form an example of a one-to-many relationship?

The 'caller' field in the incident form is an example of a one-to-many relationship because one user (caller) can be associated with multiple incidents.

What is meant by a many-to-many relationship in ServiceNow?

A many-to-many relationship in ServiceNow occurs when two or more tables are related to one another, such as a group containing multiple roles and a role being assigned to multiple groups.

What is an extended relationship in ServiceNow?

An extended relationship in ServiceNow is where one or more tables can extend from another table, meaning all fields from the parent table are accessible in the extended table.

How can you demonstrate the one-to-many relationship in ServiceNow using the incident table?

You can demonstrate the one-to-many relationship by showing that the 'caller' field in the incident table references the 'user' table, indicating one user can have multiple incidents.

What is a base table in ServiceNow?

A base table in ServiceNow is a table that is not extended from any other table but can be extended by other tables, such as the task table.

How can you identify which tables extend from the task table in ServiceNow?

You can identify tables that extend from the task table by going to the table section in ServiceNow, filtering for tables with 'extensible' set to true, and then searching for 'task' to find tables that extend from it.

What is the purpose of a schema map in ServiceNow?

A schema map in ServiceNow provides a visual representation of the relationships between tables, showing which tables reference each other, extend, or are extended by others.

How can you access the schema map for a table in ServiceNow?

You can access the schema map for a table by going to the 'Tables and Columns' section, selecting the table, and then clicking on the 'Schema Map' option.

What will be covered in the next video of the ServiceNow series?

The next video will cover how to create a custom table in ServiceNow, including adding different fields and understanding how they work.