The Database Structure: Tables, Records, and Fields

The Database Structure: Tables, Records, and Fields
A table is a group of records used to store application data. A record is comprised of fields that contain individual data and functions
When creating a table, you can create a new table or extend the table off of an existing table to inherit the existing table’s fields and functionalities, which creates a parent/child table relationship. One example of this is how the Incident, Problem, Change, and Request table extends off of the Task table to inherit its properties.

To create a new table:

1. Navigate to System Definition > Tables.

2. Click New.

3. Give your table a Label. We’ll label this table “Test Table”. This will automatically fill in the Name field.

4. To extend off of a table, type in the desired table in the Extends table field. This will transfer the extended table’s properties to the new table.

5. Now when we search “Test Table” in the filter navigator, we see the table that we created.

6. To create a Record, click new.

7. The record gets pre-populated with the fields that were inherited by the Task table. Number, Assigned to, Configuration item, Active, Priority, State, Parent, Short description, Description, and Work notes are all fields that have been inherited by the Task table.

8.