tbl_pagemenulistnew

492 rows


Description

Module: HRMS Role Module
Purpose: Defines the master list of application pages, menus, and their associated permissions for the system navigation structure.
Data: Each row represents a navigable page or menu item with its URL path and default permission flags.
Process Usage:
- Used by the frontend application to dynamically build navigation menus and sidebar components.
- Serves as the foundation for role-based permission assignments in tbl_userrole.
Key Points:
- Supports hierarchical menu structures through parent-child relationships.
- Provides default permission templates that can be customized per role.
Business Impact: Centralizes UI navigation management, enables dynamic menu generation, and provides the base structure for access control configuration.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rolegid int8 19 null

Primary key
Format: Bigint (auto-increment)
Used as: Unique identifier for each page/menu item in the navigation structure.
rgpagename varchar 100 √ null

Type: Varchar
Meaning: The display name of the page as shown in navigation menus and breadcrumbs.
Usage: Provides human-readable page identification for users.
rgmenuname varchar 100 √ null

Type: Varchar
Meaning: The category or menu group where this page belongs in the navigation hierarchy.
Usage: Organizes pages into logical groups for better user experience.
rgpageurl varchar 100 √ null

Type: Varchar
Meaning: The application route or URL path used to access this page.
Usage: Defines the navigation endpoint for frontend routing.
pype int4 10 √ null

Type: Integer
Meaning: Classification type for the page/menu item (e.g., main menu, submenu, action button).
Usage: Determines how the item is rendered in the UI navigation structure.
pageview bool 1 √ null

Type: Boolean
Meaning: Default view permission flag for this page when assigned to roles.
Usage: Suggests baseline read access configuration for new role setups.
pagesave bool 1 √ null

Type: Boolean
Meaning: Default save/create permission flag for this page when assigned to roles.
Usage: Suggests baseline create access configuration for new role setups.
pageedit bool 1 √ null

Type: Boolean
Meaning: Default edit/update permission flag for this page when assigned to roles.
Usage: Suggests baseline update access configuration for new role setups.
pagedelete bool 1 √ null

Type: Boolean
Meaning: Default delete permission flag for this page when assigned to roles.
Usage: Suggests baseline delete access configuration for new role setups.
parentid int8 19 √ null

FK: public.tbl_pagemenulistnew.rolegid
Meaning: References a parent menu item for creating hierarchical navigation structures.
Dependency: Enables nested menus, submenus, and organized navigation trees.
essurl varchar 500 √ null
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Relationships

Close relationships within degrees of separation