ir_module_category

92 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_module_category_id_seq'::regclass)
ir_module_category.parent_id ir_module_category_parent_id_fkey N
ir_module_module.category_id ir_module_module_category_id_fkey N
res_groups.category_id res_groups_category_id_fkey N
create_uid int4 10 √ null
res_users.id ir_module_category_create_uid_fkey N
create_date timestamp 29,6 √ null
write_date timestamp 29,6 √ null
write_uid int4 10 √ null
res_users.id ir_module_category_write_uid_fkey N
parent_id int4 10 √ null
ir_module_category.id ir_module_category_parent_id_fkey N
name jsonb 2147483647 null
sequence int4 10 √ null

Sequence
description jsonb 2147483647 √ null

Description
visible bool 1 √ null

Visible
exclusive bool 1 √ null

Exclusive

Indexes

Constraint Name Type Sort Column(s)
ir_module_category_pkey Primary key Asc id
ir_module_category__parent_id_index Performance Asc parent_id

Relationships

Close relationships within degrees of separation