res_groups

34 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_groups_id_seq'::regclass)
digest_tip.group_id digest_tip_group_id_fkey N
discuss_channel.group_public_id discuss_channel_group_public_id_fkey N
discuss_channel_res_groups_rel.res_groups_id discuss_channel_res_groups_rel_res_groups_id_fkey C
ir_act_server_group_rel.gid ir_act_server_group_rel_gid_fkey C
ir_act_window_group_rel.gid ir_act_window_group_rel_gid_fkey C
ir_model_access.group_id ir_model_access_group_id_fkey R
ir_model_fields_group_rel.group_id ir_model_fields_group_rel_group_id_fkey C
ir_ui_menu_group_rel.gid ir_ui_menu_group_rel_gid_fkey C
ir_ui_view_group_rel.group_id ir_ui_view_group_rel_group_id_fkey C
res_groups_implied_rel.gid res_groups_implied_rel_gid_fkey C
res_groups_implied_rel.hid res_groups_implied_rel_hid_fkey C
res_groups_report_rel.gid res_groups_report_rel_gid_fkey C
res_groups_spreadsheet_dashboard_rel.res_groups_id res_groups_spreadsheet_dashboard_rel_res_groups_id_fkey C
res_groups_users_rel.gid res_groups_users_rel_gid_fkey C
rule_group_rel.group_id rule_group_rel_group_id_fkey C
name jsonb 2147483647 null
category_id int4 10 √ null
ir_module_category.id res_groups_category_id_fkey N

Application
color int4 10 √ null

Color Index
create_uid int4 10 √ null
res_users.id res_groups_create_uid_fkey N

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

Last Updated by
comment jsonb 2147483647 √ null

Comment
share bool 1 √ null

Share Group
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
res_groups_pkey Primary key Asc id
res_groups__category_id_index Performance Asc category_id
res_groups_name_uniq Must be unique Asc/Asc category_id + name

Relationships

Close relationships within degrees of separation