screen_definition Table (370)

•
Environment: onsite, online
• 2 minutes to read
 • 2 minutes to read

A configurable screen

Fields

Name Description Type Null
id Primary key PK
name A field for entering the name of this entry String(255)
id_string A field for an id_string which may be used to access the screen String(255)
hierarchy_id The screen definition is inside this hierarchy folder FK hierarchy
screen_key This field holds the authentication key if used String(255)
layout_model An enum for which layout model this screen is using. layout_model ●
load_script_body The ejscript to execute the first time this screen is loaded, e.g. for form loading Clob ●
load_post_cgi_script_body The ejscript to execute after setFromCgi, e.g. when the page is submitted Clob ●
load_final_script_body The ejscript to execute just before the page is printed, after button/action scripts have been run Clob ●
creation_script The script used at the top of all other creation scripts on this page Clob ●
warn_on_navigate Decides if user will get a warning if he accidentally navigates away from unsaved changes for this screen Bool
description Optional description of what this screen is used for String(2047) ●
autosave Whether this screen uses autosave or not Bool ●

screen_definition table relationship diagram

Indexes

Fields Types Description
id PK Clustered, Unique
hierarchy_id FK Index

Relationships

Table Description
hierarchy This table contains folders used to group the extra tables in the system.
screen_definition_action An action to perform for a certain button in an screen
screen_definition_element An element in a configurable screen
screen_definition_hidden The name of a hidden variable to keep for this screen
screen_definition_language Custom language variables used for screens

Replication Flags

  • None

Security Flags

  • No access control via user's Role.