Database Structure and Hierarchy

Everything in servicenow is built on a mariadb datavase, containing tables which you access through the servicenow graphical user interface GUI

The database contains tables, tables contain records, records contain fields - a field is an individual piece of data in a record

Record Hierarchy

Information is documented and saved in fields

Many fields make up a record, which can be viewed and edited using a form

One or more records make up a searchable, sortable list

Note: Servicenow often uses the term record to describe all teha dat saved within a particular form. the form is simply the way that the user can view and modify that record

Table components

A table is a collection of records in the database

Each record corresponds to a row in a table

Each field corresponds to a column in a table and represents individual pieces of that in a record

Records are identified by a 32-character, globally uniqure id, called a sys_id

Field Attribuites

Each field has three key attributes: a label, a name and a value

The label is a user-friendly term which allows people to identify the field in the user intreface

The name is a unique term that the system uses to identify the field in scripts and automated business processes

The values are actual data