Tables & Columns

As mentioned previously, the Tables & Columns module lists all the tables in the instance in a single page, thus allowing developers to quickly view the list of tables and columns for any given table and access the attributes of any of its columns. As shown in the following screenshot, the Tables & Columns page is a special page that consists of the following three sections:

• Table Names: A list containing the labels of all the tables followed by the system name of the table within square brackets. For example, in the following screenshot, Incident SLA is the label, while incident_sla is the system name of the table.
• Column Names: This displays a list of columns available in the selected table. Each column has a distinctive icon that is based on column attributes, such as the element table. Clicking on the plus icon can expand the reference field columns:

• Column Attributes: This is the rightmost section, where attributes of the selected column are shown. It usually consists of the type of the field, the system name of the element, and other field attributes based on the type of the selected field. If a field is extended from the parent class and is not part of the selected table, you may see a difference in the system name of the selected table and the Element Table attribute property.