You are viewing an old version of this page. View the current version.
Compare with Current View Page History
Version 1 Next »
Form element tables
sys_ui_form
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_form | FALSE | sys_ui_form | TRUE | TRUE | TRUE | TRUE |
Description: This table contains form view configurations. It consists of the following fields.
Field | Type | Description |
---|---|---|
title | String | The view title. |
user_id | Reference | Reference to the user, owner of the form. If user = null, then the view is shared. |
table_id | Reference | Reference to the sys_db_table table, the ID of the table that is a parent for the view. |
sys_ui_form_element
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_form_element | FALSE | sys_ui_form_element | TRUE | TRUE | TRUE | TRUE |
Description: A table for configurations of the section elements. It consists of the following fields:
Field | Type | Description |
---|---|---|
form_split_element_type | Enum form_split_element_type | (Contains from: begin_split, end_split, split). This column stores information about if the record is the form break-up element, and if yes, what kind of element is it. |
formatter | String | This column stores formatter name and shares info about the element: is it a widget and if yes, what kind of widget it is. |
column_id | Reference | Reference to the sys_db_column column. The ID of the column that is the form section element. |
position | Integer | The element position inside the section. |
form_section_id | Reference | Reference to the sys_ui_form_section table. The ID of the section that is a parent for the element. |
sys_ui_form_section
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_form_section | FALSE | sys_ui_form_section | TRUE | TRUE | TRUE | TRUE |
Description: The table for the configurations of the record view form sections. It consists of the following fields:
Field | Type | Description |
---|---|---|
position | String | Tabs order on the form view. The first section is general and will not be a tab. |
form_id | Reference | Reference to the sys_ui_form table. A form view that is a parent for the section. |
title | String | The title of the form. |
sys_ui_formatter
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_formatter | FALSE | sys_ui_formatter | TRUE | TRUE | TRUE | TRUE |
Description: The widget configuration table. It consists of the following fields:
Field | Type | Description |
---|---|---|
name | String | A widget name. |
active | Boolean | IF TRUE, then this widget is active. |
formatter | Choice | Available options: Activities. |
type | Choice | Available options: Formatter. |
table_id | Reference | Reference to the sys_db_table table, The ID of the table that will display the widget in its configuration of form section elements. |
List element tables
sys_ui_list
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_list | FALSE | sys_ui_list | TRUE | TRUE | TRUE | TRUE |
Description: This table contains configurations of list views of the tables. It consists of the following fields:
Field | Type | Description |
---|---|---|
title | String | The view title. |
user_id | Reference | Reference to the user, owner of the form view. If user = null, then the view is shared. |
table_id | Reference | Reference to the sys_db_table table, The ID of the table that is a parent for the view. |
sys_ui_list_column
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_list_column | FALSE | sys_ui_column | TRUE | TRUE | TRUE | TRUE |
Description: This table contains configurations of the columns of list views of the tables. It consists of the following fields:
Field | Type | Description |
---|---|---|
displayable_path | JSON | The dotWalking path to the column. |
column_id | Reference | Reference to the sys_db_column column. The ID of the column is shown in the list view. |
order | Integer | The order of the columns. |
list_id | Reference | Reference to the sys_ui_list table. The ID of the list view that is a parent for the column. |
sys_ui_related_list
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_related_list | FALSE | sys_ui_related_list | TRUE | TRUE | TRUE | TRUE |
Description: This table contains configurations of the related lists. It consists of the following fields:
Field | Type | Description |
---|---|---|
table_id | Reference | Reference to the sys_db_table table. The ID of the table that is a parent for the related list. |
user_id | Reference | Reference to the user, owner of the related list. If user = null then the list is shared. |
title | String | The related list title. |
sys_ui_related_list_element
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_ui_related_list | FALSE | sys_ui_related_list | TRUE | TRUE | TRUE | TRUE |
Description: This table contains configurations of the elements of the related lists. It consists of the following fields:
Field | Type | Description |
---|---|---|
related_column_id | Reference | Reference to the sys_db_column column, The ID of the related column. |
related_list_id | Reference | Reference to the sys_ui_related_list table, The ID of the related list that is a parent for the element. |
order | Integer | The elements order. |
title | String | The related list element title. |
sys_url_action
Name | Is_extendable | Title | Read Access | Create Access | Update Access | Delete Access |
---|---|---|---|---|---|---|
sys_url_action | FALSE | sys_url_action | TRUE | TRUE | TRUE | TRUE |
Description: The URL actions table. The actions are the links; after following them, some activities in the system will perform. It consists of the following fields:
Field | Type | Description |
---|---|---|
key | String | Generated hash. It will be inserted into URL and used as a keyword for a record search in a database when followed the URL. |
assigned_to | Reference | Reference to the user table, the user. |
executor_id | Reference | Reference to the user table, the user who has followed the link and run the action. |
script | Script | Server-side script, it will be executed after following the link. |
active | Boolean | IF TRUE, then this URL action is active. |
expire_on | Datetime | After this datetime following the link will not run the script. |
- No labels