res_partner_category

-1 rows


Description

Partner Tags

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_partner_category_id_seq'::regclass)
account_analytic_distribution_model.partner_category_id account_analytic_distribution_model_partner_category_id_fkey C
account_reconcile_model_res_partner_category_rel.res_partner_category_id account_reconcile_model_res_partne_res_partner_category_id_fkey C
res_partner_category.parent_id res_partner_category_parent_id_fkey C
res_partner_res_partner_category_rel.category_id res_partner_res_partner_category_rel_category_id_fkey C
color int4 10 √ null

Color
parent_id int4 10 √ null
res_partner_category.id res_partner_category_parent_id_fkey C

Parent Category
create_uid int4 10 √ null
res_users.id res_partner_category_create_uid_fkey N

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

Last Updated by
parent_path varchar 2147483647 √ null

Parent Path
name jsonb 2147483647 null

Tag Name
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)
res_partner_category_pkey Primary key Asc id
res_partner_category__parent_id_index Performance Asc parent_id
res_partner_category__parent_path_index Performance Asc parent_path

Relationships

Close relationships within degrees of separation