product_category

-1 rows


Description

Product Category

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_category_id_seq'::regclass)
account_analytic_applicability.product_categ_id account_analytic_applicability_product_categ_id_fkey N
account_analytic_distribution_model.product_categ_id account_analytic_distribution_model_product_categ_id_fkey C
product_category.parent_id product_category_parent_id_fkey C
product_pricelist_item.categ_id product_pricelist_item_categ_id_fkey C
product_template.categ_id product_template_categ_id_fkey R
stock_putaway_rule.category_id stock_putaway_rule_category_id_fkey C
stock_route_categ.categ_id stock_route_categ_categ_id_fkey C
stock_valuation_layer.categ_id stock_valuation_layer_categ_id_fkey N
stock_warehouse_orderpoint.product_category_id stock_warehouse_orderpoint_product_category_id_fkey N
parent_id int4 10 √ null
product_category.id product_category_parent_id_fkey C

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

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

Last Updated by
name varchar 2147483647 null

Name
complete_name varchar 2147483647 √ null

Complete Name
parent_path varchar 2147483647 √ null

Parent Path
product_properties_definition jsonb 2147483647 √ null

Product Properties
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
removal_strategy_id int4 10 √ null
product_removal.id product_category_removal_strategy_id_fkey N

Force Removal Strategy
packaging_reserve_method varchar 2147483647 √ null

Reserve Packagings

Indexes

Constraint Name Type Sort Column(s)
product_category_pkey Primary key Asc id
product_category__parent_id_index Performance Asc parent_id
product_category__parent_path_index Performance Asc parent_path

Relationships

Close relationships within degrees of separation