tbl_userrole

3454 rows


Description

Module: HRMS Role Module
Purpose: Defines granular page-level permissions and access rights for specific roles within the system.
Data: Each row represents a permission setting that grants a role specific capabilities (view, save, edit, delete) for a particular page or menu item.
Process Usage:
- Used by the security interceptor to validate user permissions when accessing application features.
- Enables fine-grained access control beyond basic role assignments.
Key Points:
- Implements role-based permission matrix at the UI component level.
- Supports hierarchical permission structures through parent-child relationships.
Business Impact: Provides precise control over feature access, ensures data security, and enables customized user experiences based on role capabilities.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
userrolegid bigserial 19 √ nextval('tbl_userrole_userrolegid_seq'::regclass)
tbl_userrolehistory.userrolegid Implied Constraint R

Primary key
Format: Bigint (auto-increment)
Used as: Unique identifier for each permission record.
roleid int4 10 √ null
tbl_rolemaster.roleid Implied Constraint R

FK: public.tbl_rolemaster.roleid
Meaning: The role to which these page permissions are assigned.
Dependency: Links permissions to specific roles in the system.
rgpagename varchar 100 √ null

Type: Varchar
Meaning: The name of the application page or feature being controlled.
Usage: Identifies the specific UI component for permission checks.
rgmenuname varchar 100 √ null

Type: Varchar
Meaning: The menu category or section where the page belongs.
Usage: Enables menu-level visibility and access control.
rgpageurl varchar 100 √ null

Type: Varchar
Meaning: The URL path or route identifier for the protected page.
Usage: Used by security filters to intercept and validate page access.
pagesave bool 1 √ false

Type: Boolean
Meaning: Grants permission to create new records on this page.
Usage: Controls create/save functionality for the assigned role.
pageedit bool 1 √ false

Type: Boolean
Meaning: Grants permission to modify existing records on this page.
Usage: Controls edit/update functionality for the assigned role.
pagedelete bool 1 √ false

Type: Boolean
Meaning: Grants permission to remove records on this page.
Usage: Controls delete functionality for the assigned role.
pageview bool 1 √ false

Type: Boolean
Meaning: Grants permission to access and view content on this page.
Usage: Controls basic read/access functionality for the assigned role.
rolegid int8 19 √ null

Type: Bigint
Meaning: Additional role grouping or classification identifier.
Usage: Supports complex role hierarchy and permission inheritance.
parentid int8 19 √ null

FK: public.tbl_userrole.userrolegid
Meaning: References a parent permission record for hierarchical permission structures.
Dependency: Enables permission inheritance and nested access control rules.
createdby varchar 50 √ null
createddate timestamp 29,6 √ null
modifiedby varchar 50 √ null
modifieddate timestamp 29,6 √ null

Indexes

Constraint Name Type Sort Column(s)
tbl_userrole_pk_tbl_userrole Primary key Asc userrolegid

Relationships

Close relationships within degrees of separation