Subject Area : 380 - Portal
Subject Area Name Definition
380 - Portal Tables that define console, portal, and widget objects in the UI.
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
console Console false A console in the FootPrints 12 User Interface. A console can contain other consoles, for example the Home Page.
Physical Name Attribute/Column Name Definition Physical Data Type
console_id Console Id The automatically generated primary key of the console table. bigint
source_console_id Source Console Id A Foreign Key to the Console table. bigint
console_guid Console GUID Identifier used from Javascript. varchar(255)
console_name Console Name Console name. nvarchar(4000)
widget_id Widget Id A Foreign Key to the Widget table. bigint
cntnr_type Container Type The name of the container type, such as workspace, cmdb etc. varchar(50)
sys_name System Name internal identifier of the console varchar(255)
console_descr Console Description Console Description. nvarchar(4000)
user_id User Id A Foreign Key to the Application User table. bigint
portal Portal false A portal in the FootPrints 12 User Interface.
Physical Name Attribute/Column Name Definition Physical Data Type
portal_id Portal Id The automatically generated primary key of the portal table. bigint
portal_guid Portal GUID The value of a Portal, stored as a string. varchar(255)
portal_name Portal Name Name of the portal. nvarchar(4000)
portal_theme Portal Theme Theme name to be used in Portal rendering. varchar(255)
portal_logo_guid Portal Logo GUID Logo to be displayed varchar(255)
portal_active_console_id Portal Active Console Id A Foreign Key to the Console table. bigint
is_sys Is System Indicates if Is System or user custom portal. bit
portal_descr Portal Description Portal Description. nvarchar(4000)
allow_anonymous_access Allow Anonymous Access Indicates if Allow Anonymous Access. bit
portal_console Portal Console false The association between a Console and a Portal.
Physical Name Attribute/Column Name Definition Physical Data Type
console_id Console Id A Foreign Key to the Console table. bigint
portal_id Portal Id A Foreign Key to the Portal table. bigint
is_vsble Is Visible Indicates if Is Visible. bit
console_index Console Index The order of the console in the portal. int
is_closable Is Closable Indicates if Is Closable. bit
widget Widget false 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
Physical Name Attribute/Column Name Definition Physical Data Type
widget_id Widget Id The automatically generated primary key of the widget table. bigint
parent_widget_id Parent Widget Id A Foreign Key to the Widget table. bigint
widget_guid Widget GUID The value of a Widget, stored as a string. varchar(255)
widget_descr Widget Description The value of a Widget, stored as a long text object. varchar(max)
widget_layout Widget Layout The value of a Widget, stored as a long text object. varchar(max)
widget_type Widget Type The value of a Widget, stored as a string. varchar(255)
widget_cfg Widget Configuration The value of a Widget, stored as a long text object. varchar(max)
widget_view_cfg Widget View Configuration The value of a Widget, stored as a long text object. varchar(max)
widget_index Widget Index The value of a Widget stored as boolean. int