MyBac Tables

All MyBSM (MyBAC)  related tables have prefix DSH .

Here list of relevant MyBAC tables with short description.

All tables are containing in the Managenet DB

DSH_AUTHORIZED_PRIVILEGES

here stores user privileges. For example if user not have license to use SLM area, he will not able to select SLM portlets.

VERSION  - version of change in the Privileges

PARENT_ENTITY_NAME - name of the parameter in Java.

PARENT_PRIMARY_KEY - Portlet ID from DSH_PORTLET_DEFS table

 

DSH_DEFS_CATEGORIES

here stores IDs dependencies between Portlet definition and Portlet Category.

PORTLET_CATEGORY_ID  - Category ID from DSH_PORTLET_CATEGORIES

PORTLET_DEF_ID  Portlet ID from DSH_PORTLET_DEFS table

 

DSH_FAVORITES

here stores favorite user pages ID with Title, Sequence  and Description columns .

FAV_ID - ID of favorite page

VERSION - version of this favorite

CUSTOMER_ID - Customer ID

USER_ID  -  User who created the favorite

PAGE_ID - Page ID from DSH_PAGES
SEQUENCE  - not relevant

TITLE - if was change between name and title

DESCRIPTION - descry of the Favorite page

 

DSH_JAVA_PORTLET_DEFS

one of the main tables, here stores all portlets definitions ID with path to servlets,  name of xml definition, display name  and etc..

PORTLET_DEF_ID  - Portlet ID from DSH_PORTLET_DEFS table

TYPE - type of portlets (java/wsrp)

WAR_FILE_PATH -application server path

APP_CONTEXT - context of application regarding to Portles

SERVLET_CONTEXT - context of the servlets

SERVLET_PATH - path to servlet file

PORTLET_XML_NAME - xml-definition file

DISPLAY_NAME - name of the portlets

CAN_EXPORT_WSRP - flag to possibility to export by WSRP

CAN_BE_DRILLED - flag to possibility to drill sown through a portlet

 

DSH_MODULES

this table contain all default and user defined modules.

MODULE_ID  - Id of the Module

VERSION - version of the module

CREATED_BY - user ID who created this module

CUSTOMER_ID - Customer ID

CREATION_DATE - date and time of a creation module

LAST_UPDATED_BY - User ID who changed the module in last time

LAST_UPDATE_DATE  - date and time of a modify module

NAME - Name of the module

UUID - UCMDB ID of the Module

DESCRIPTION - description of the Module

LAST_PUBLICATION_DATE -  not relevant

 

DSH_PAGE_GROUPS

this table contain user defined  group of pages

PAGE_GROUP_ID - ID of the Group of the pages (Personalize mode)

TITLE - Name of the Group (Personalize mode)

DESCRIPTION - description of the Group (Personalize mode)

USER_ID    - the User ID who has personalized groups

 CUSTOMER_ID - the Customer ID who has personalized groups

 

DSH_PAGES

this table contains all pages

PAGE_ID -ID of the Page

VERSION - Version of changes on the Pages

PAGE_SEQUENCE - the order for displays and rotation.

TITLE - Name of the Pages

MODULE_ID - the module who which contains this Page

AUTO_REFRESH - flag of the auto refreshing of the Module

REFRESH_INTERVAL - time of the refresh interval in the milliseconds

PAGE_GROUP_ID - the ID  (DSH_PAGE_GROUPS) of the group if this module was personalized

 

DSH_PORTLET_CATEGORIES

here stores  ID, Name  of all portlets categories .

PORTLET_CATEGORY_ID - category ID

VERSION - changes in the category

CUSTOMER_ID - the customer who has these categories

NAME - name of the categories

 

DSH_PORTLET_PREFERENCES 

here stores IDs dependencies between Portlets ID and Portlet Preferences .

DSH_PORTLETS 

here stores info regarding all portlets available in system.

PORTLET_ID - ID of the of portlet

VERSION - changes of the portlet

PORTLET_DEF_ID -  Type ID of the Portlets

PAGE_ID - ID of the page which contains this portlet

LAYOUT_WIDTH - 1 = narrow, 2 = wide

LAYOUT_COLUMN  - number of column layout

LAYOUT_ROW - the row of the layout

TITLE - Title of the Portlet

IS_MINIMIZED - N - not minimized, Y - is minimized

DSH_PREFERENCE_VALS

here stores preference for all portlets. 

 

DSH_USER_MODULE_PAGES

contains created pages by User (nor predefined) .

USER_MODULE_PAGE_ID - Module ID of the personalized modules

VERSION - Changes in the Module

USER_ID - User ID who has this Personalized Pages

PAGE_ID - the page ID

 

DSH_USER_PAGES

contains personalized user pages

USER_PAGE_ID  - id of the personalized pages

VERSION - changes of the portlet

CUSTOMER_ID - the customer who has these pages

PAGE_ID - general page ID

USER_ID - the uaer who has these pages

 

WSRP Poertles

All tables with WSRP prefix  - relates to portlets which are imported/exported using WSRP technology