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
|