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 |