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