Subject Area : 430 - UI Component State
Subject Area Name Definition
430 - UI Component State Tables that define the UI state of UI components so that they preserve user configurations and layout.
ER Diagram Name Physical Display Level
Logical Column
Physical Column
Physical Name Entity/Table Name Logical Only Do Not Generate Definition
app_user Application User false A user authorized to use the FootPrints system. The user is either a Customer User or an Agent User. The application user holds the minimum information needed to identify the user and associate the user with a user profile, where user settings are stored. A contact is not necessarily an application user. An application user entry is required in order for the user to access any online functions.
Physical Name Attribute/Column Name Definition Physical Data Type
pwd Password This space intentionally left blank. varchar(255)
user_name User Name The name of the Application User. nvarchar(4000)
cust_login_type_id Customer Login Type Id A Foreign Key to the Customer Login Type table. int
app_user_id Application User Id The automatically generated primary key of the app_user table. bigint
lic_type_id License Type Id A Foreign Key to the License Type table. bigint
user_login User Login The login name used to access the Application. This may not be filled in if external application security is used. nvarchar(4000)
email_addr Email Address An email address for the Application User. nvarchar(4000)
delete_date Delete Date The value of a Application User, stored as a date. datetime
ui_component_state UI Component State false The EXTJS grid has the ability to store it's state allowing the preservation of grid layout properties. This table supports that. It might also be used for other UI control objects.
Physical Name Attribute/Column Name Definition Physical Data Type
ui_component_state_id UI Component State Id The automatically generated primary key of the ui_component_state table. bigint
state_key State Key A search key for the UI Component State, composed of letters and numbers. It must be unique when combined with the app user id. It is an intelligent key, but the only use is to store and retrieve values. varchar(255)
state_val State Value The value of a UI Component State, stored as a long text object. varchar(max)
app_user_id Application User Id A Foreign Key to the Application User table. Identifies the user that owns the layout. bigint