MIXERP-Table core.menus

#	Column Name	Nullable	Data Type	Max Length	Description
1	menu_id		integer	0	The primary key of this table, which is also a serial field.
2	menu_text		character varying	250	The name of the menu.
3	url		character varying	250	The location of the menu.
4	menu_code		character varying	12	The code of the menu, which is also a unique field.
5	level		smallint	0
6	parent_menu_id		integer	0	Foreign key to the table core.menus.
7	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
8	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
6	parent_menu_id	menus_parent_menu_id_fkey	core.menus.menu_id
7	audit_user_id	menus_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
menus_pkey	postgres	btree	menu_id
menus_menu_code_uix	postgres	btree	upper(menu_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	menu_id	nextval('core.menus_menu_id_seq'::regclass)
8	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description