Footprints Data Model

Table
Name widget
Comment
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

Column
Name Datatype Comment Is PK Is FK
widget_id bigint The automatically generated primary key of the widget table. Yes No
parent_widget_id bigint A Foreign Key to the Widget table. No Yes
widget_guid varchar(255) The value of a Widget, stored as a string. No No
widget_descr varchar(max) The value of a Widget, stored as a long text object. No No
widget_layout varchar(max) The value of a Widget, stored as a long text object. No No
widget_type varchar(255) The value of a Widget, stored as a string. No No
widget_cfg varchar(max) The value of a Widget, stored as a long text object. No No
widget_view_cfg varchar(max) The value of a Widget, stored as a long text object. No No
widget_index int The value of a Widget stored as boolean. No No