ir_ui_menu

304 rows


Description

Menu

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_ui_menu_id_seq'::regclass)
ir_ui_menu.parent_id ir_ui_menu_parent_id_fkey R
ir_ui_menu_group_rel.menu_id ir_ui_menu_group_rel_menu_id_fkey C
wizard_ir_model_menu_create.menu_id wizard_ir_model_menu_create_menu_id_fkey C
sequence int4 10 √ null

Sequence
parent_id int4 10 √ null
ir_ui_menu.id ir_ui_menu_parent_id_fkey R

Parent Menu
create_uid int4 10 √ null
res_users.id ir_ui_menu_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id ir_ui_menu_write_uid_fkey N

Last Updated by
parent_path varchar 2147483647 √ null

Parent Path
web_icon varchar 2147483647 √ null

Web Icon File
action varchar 2147483647 √ null

Action
name jsonb 2147483647 null

Menu
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
ir_ui_menu_pkey Primary key Asc id
ir_ui_menu__parent_id_index Performance Asc parent_id
ir_ui_menu__parent_path_index Performance Asc parent_path

Relationships

Close relationships within degrees of separation