Hi All,

Today I would be covering different tables for Forms and their relationship with each other.

Table 1: sys_ui_form (Form)

This table store the information of form with views and table name. So on one table, there can be multiple forms with different views. So it stores the form information with table name and view name on it. Example: Form with workspace view, default view or some custom view.

See the screenshot below:

Table 2: sys_ui_section (Form UI Sections)

This table stores the information of section added on the form so if there are 4 section added on the form. This table will have 4 records associated with the table name used in table 1. Also it shows the caption of each section if given else shows as empty

Example shown for Service Operations Workspace view:

Table 3: sys_ui_form_section

This table stores the form section which connects with table 2 with its ui section sys_id. This stores the information of each form section with position 0,1,2.... etc. UI Section table stores the section name with its view.

See the screenshot below:

Table 4: sys_ui_element

This table stores all the fields added in each section. This has a relationship with the table no 2. It shows the elements or fields with sys_id of table 2 associated with it.

See the screenshot below:

Hope it help you.

Please mark it helpful if it helps you.

Thanks,

Shamma