Subject Area : 380 - Portal
Subject Area(s) of Model "Renoir Domain Model Detail"
# Name Definition ER Diagram Entity/Table
Total
. 380 - Portal Tables that define console, portal, and widget objects in the UI. Details.. Details..
ER Diagram(s) of Subject Area "380 - Portal"
# Name Physical Display Level
Total 2
. Logical Column
. Physical Column
Entity/Table(s) of Subject Area "380 - Portal"
# Physical Name Name Logical Only Do Not Generate Definition Attribute/Column
Total 5
. 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. Details..
. console Console false A console in the FootPrints 12 User Interface. A console can contain other consoles, for example the Home Page. Details..
. portal Portal false A portal in the FootPrints 12 User Interface. Details..
. portal_console Portal Console false The association between a Console and a Portal. Details..
. 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
Details..
Attribute/Column(s) of Entity/Table "Application User"
# Physical Name Name Definition Physical Data Type
Total 8
. 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
Attribute/Column(s) of Entity/Table "Console"
# Physical Name Name Definition Physical Data Type
Total 9
. 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
Attribute/Column(s) of Entity/Table "Portal"
# Physical Name Name Definition Physical Data Type
Total 9
. 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
Attribute/Column(s) of Entity/Table "Portal Console"
# Physical Name Name Definition Physical Data Type
Total 5
. 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
Attribute/Column(s) of Entity/Table "Widget"
# Physical Name Name Definition Physical Data Type
Total 9
. 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