Footprints Data Model

Table
Table Name Widget
Table Definition A widget. A root widget contains subordinate widgets. Widget Types include: ACTION_PANE ADMINISTRATION ALL_ITEMS CALENDAR CHART NEW_ITEM ROOT SAVED_SEARCH_WIDGET TAB_PANE URL WIDGET_PANE

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Widget Id The automatically generated primary key of the widget table. LONG Yes
Widget GUID The value of a Widget, stored as a string. VARCHAR(255) Yes
Widget Description The value of a Widget, stored as a long text object. TEXT No
Widget Layout The value of a Widget, stored as a long text object. TEXT No
Widget Type The value of a Widget, stored as a string. VARCHAR(255) Yes
Widget Configuration The value of a Widget, stored as a long text object. TEXT No
Widget View Configuration The value of a Widget, stored as a long text object. TEXT No
Parent Widget Id A Foreign Key to the Widget table. LONG No
Widget Index The value of a Widget stored as boolean. INTEGER No