cloud.navigation_menu

Schema: cloud
English table: cloud.navigation_menu
Italian original table: hr.menu
Description: Navigation menu entries and hierarchy.

Overview

• Columns: 22
• Primary key: mn_id
• Outgoing foreign keys: 1
• Incoming foreign keys: 0
• Indexes: 5

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
mn_id	id	integer	NO		Primary key of the navigation menu record.
me_id	me_id	integer	NO		Menu entry identifier.
me_lng	me_lng	integer	NO		Language identifier for the menu entry label.
me_area	me_area	character varying(50)	NO		Application area associated with the menu entry.
me_name	me_name	character varying(50)	NO		Display name of the menu entry.
me_app_name	me_app_name	character varying(20)	NO		Application name associated with the menu entry.
me_father_id	me_father_id	integer	NO		Identifier of the parent menu entry.
me_prompt	me_prompt	character varying(40)	NO		Short prompt/tooltip for the menu entry.
me_icon	me_icon	character varying(50)	NO		Icon name or CSS class for the menu entry.
me_order	me_order	numeric(3,0)	NO		Display order of the menu entry.
me_page	me_page	character varying(200)	NO		Target page or route for the menu entry.
me_expr	me_expr	character varying(100)	NO		Visibility or enablement expression for the menu entry.
me_help_context	me_help_context	integer	NO		Help context identifier associated with the menu entry.
me_code	me_code	integer	NO		Numeric code of the menu entry.
me_module	me_module	character varying(100)	NO		Module identifier associated with the menu entry.
me_org_id	me_org_id	integer	NO		Organization identifier associated with the menu entry.
me_rap_id	me_rap_id	integer	NO		Authorization profile identifier (RAP) required for the menu entry.
me_haschild	me_haschild	boolean	NO		Flag indicating whether the menu entry has child items.
me_rap_id_escl	me_rap_id_escl	text	NO		List of excluded authorization profile identifiers (RAP).
tenant_id	tenant_id	integer	YES		Tenant identifier associated with the menu entry.
colcustom	colcustom	jsonb	YES	'{}'::jsonb	Custom attributes for the menu entry (JSON).
_deleted	_deleted	boolean	YES	false	Flag indicating whether the record is soft-deleted.

Relationships

Outgoing foreign keys

Constraint	Local columns	References	Referenced columns	On update	On delete
fk_tenant_id	tenant_id	cloud.tenants	ten_internal_id	RESTRICT	CASCADE

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: menu_pkey → mn_id
• Unique: k_me_id_unique → me_id, tenant_id

Indexes

Name	Unique	Method	Columns / expression
idx_menu_me_father_id_tenant	NO	btree	tenant_id, me_father_id) WHERE (_deleted = false
idx_menu_me_id_tenant	NO	btree	tenant_id, me_id) WHERE (_deleted = false
idx_menu_me_org_id_tenant	NO	btree	tenant_id, me_org_id) WHERE (_deleted = false
idx_menu_me_rap_id_tenant	NO	btree	tenant_id, me_rap_id) WHERE (_deleted = false
idx_menu_tenant	NO	btree	tenant_id

Navigation

• Back to main index
• [Back to cloud index]../)