Footprints Data Model

Table
Table Name UI Component State
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
UI Component State Id The automatically generated primary key of the ui_component_state table. LONG Yes
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) Yes
State Value The value of a UI Component State, stored as a long text object. TEXT Yes
Application User Id A Foreign Key to the Application User table. Identifies the user that owns the layout. LONG No