account_group

-1 rows


Description

Account Group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('account_group_id_seq'::regclass)
account_account.group_id account_account_group_id_fkey N
account_group.parent_id account_group_parent_id_fkey C
parent_id int4 10 √ null
account_group.id account_group_parent_id_fkey C

Parent
company_id int4 10 null
res_company.id account_group_company_id_fkey R

Company
create_uid int4 10 √ null
res_users.id account_group_create_uid_fkey N

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

Last Updated by
parent_path varchar 2147483647 √ null

Parent Path
code_prefix_start varchar 2147483647 √ null

Code Prefix Start
code_prefix_end varchar 2147483647 √ null

Code Prefix End
name jsonb 2147483647 null

Name
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
account_group_pkey Primary key Asc id
account_group__parent_id_index Performance Asc parent_id
account_group__parent_path_index Performance Asc parent_path

Check Constraints

Constraint Name Constraint
account_group_check_length_prefix ((char_length((COALESCE(code_prefix_start, ''::character varying))::text) = char_length((COALESCE(code_prefix_end, ''::character varying))::text)))

Relationships

Close relationships within degrees of separation