Skip to content

SAIF.Presentation.Web.Controls.V2.Menu database tables

This library contains no direct database access: no SQL text, command objects, connection strings, or data-layer types appear in SAIFMenu.vb, SAIFMenuTop.vb, or SAIFImageButton.vb. All persistence is delegated to other components, so no table catalog rows apply directly to this library.

Table catalog

None. No table is referenced by SQL text or a stored-procedure call within this library.

Delegated persistence paths

Although this library issues no SQL of its own, two indirect persistence paths are exercised on its behalf:

Path Trigger Delegated component Nature
Menu authorisation data New NavigationContext(userid) on first use per session (see Acquire navigation data) SAIF.Presentation.Web.MVC.NavigationContext, which constructs clsMSOracleDataLayer with DB user MENU Reads the user's authorised menu items, categories, and page action flags from Oracle. The underlying tables (MENU_ITEM, MENU_PAGE, MENU_CATEGORY_CODE, MENU_SECURITY, MENU_SECURITY_USER, MENU_FAVORITE, BUSONLINE_APPS_CODE) are cataloged in SAIF.Business.Menu's own database documentation, not here.
User preferences Preferences.Add("SHOWAPPS", …) / Save() (see Expand or collapse the applications section) and the read in Restore menu state on page pre-load SAIF.Presentation.clsPreferences → SAIF.Framework.Preferences, DB user CLM Reads and writes the SHOWAPPS preference for application BOMENU. The preference storage table(s) are internal to the SAIF.BOF.Framework package.*

"BOMENU" is an application scope value, not a table or schema name, and "SHOWAPPS" is a preference key, not a column.

Table relationship diagram

No cross-table relationships were identified in this library's SQL, because this library contains no SQL. Relationships among the delegated tables (MENU_ITEM, MENU_PAGE, MENU_CATEGORY_CODE, etc.) are documented in SAIF.Business.Menu's database documentation.

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • SAIF.Presentation.Web.Controls.V2.Menu/SAIFMenu.vb
  • SAIF.Presentation.Web.Controls.V2.Menu/SAIFMenuTop.vb
  • SAIF.Presentation.Web.Core.Infragistics111/NavigationContext.vb
  • SAIF.Presentation/clsPreferences.vb