product_product

48 rows


Description

Product Variant

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('product_product_id_seq'::regclass)
account_analytic_distribution_model.product_id account_analytic_distribution_model_product_id_fkey C
account_analytic_line.product_id account_analytic_line_product_id_fkey N
account_move_line.product_id account_move_line_product_id_fkey R
mrp_bom.product_id mrp_bom_product_id_fkey N
mrp_bom_byproduct.product_id mrp_bom_byproduct_product_id_fkey R
mrp_bom_line.product_id mrp_bom_line_product_id_fkey R
mrp_consumption_warning_line.product_id mrp_consumption_warning_line_product_id_fkey C
mrp_production.product_id mrp_production_product_id_fkey R
mrp_unbuild.product_id mrp_unbuild_product_id_fkey R
mrp_workcenter_capacity.product_id mrp_workcenter_capacity_product_id_fkey R
mrp_workorder.product_id mrp_workorder_product_id_fkey N
product_label_layout_product_product_rel.product_product_id product_label_layout_product_product_re_product_product_id_fkey C
product_packaging.product_id product_packaging_product_id_fkey C
product_pricelist_item.product_id product_pricelist_item_product_id_fkey C
product_product_stock_track_confirmation_rel.product_product_id product_product_stock_track_confirmatio_product_product_id_fkey C
product_replenish.product_id product_replenish_product_id_fkey C
product_supplierinfo.product_id product_supplierinfo_product_id_fkey N
product_tag_product_product_rel.product_product_id product_tag_product_product_rel_product_product_id_fkey C
product_variant_combination.product_product_id product_variant_combination_product_product_id_fkey C
purchase_order_line.product_id purchase_order_line_product_id_fkey N
res_company.sale_discount_product_id res_company_sale_discount_product_id_fkey N
res_company.sale_down_payment_product_id res_company_sale_down_payment_product_id_fkey N
sale_advance_payment_inv.product_id sale_advance_payment_inv_product_id_fkey N
sale_order_line.product_id sale_order_line_product_id_fkey R
sale_order_option.product_id sale_order_option_product_id_fkey R
sale_order_template_line.product_id sale_order_template_line_product_id_fkey N
sale_order_template_option.product_id sale_order_template_option_product_id_fkey R
stock_change_product_qty.product_id stock_change_product_qty_product_id_fkey C
stock_lot.product_id stock_lot_product_id_fkey R
stock_move.product_id stock_move_product_id_fkey R
stock_move_line.product_id stock_move_line_product_id_fkey C
stock_putaway_rule.product_id stock_putaway_rule_product_id_fkey C
stock_quant.product_id stock_quant_product_id_fkey R
stock_replenishment_option.product_id stock_replenishment_option_product_id_fkey N
stock_return_picking_line.product_id stock_return_picking_line_product_id_fkey C
stock_rules_report.product_id stock_rules_report_product_id_fkey C
stock_scrap.product_id stock_scrap_product_id_fkey R
stock_storage_category_capacity.product_id stock_storage_category_capacity_product_id_fkey C
stock_track_line.product_id stock_track_line_product_id_fkey N
stock_valuation_layer.product_id stock_valuation_layer_product_id_fkey R
stock_valuation_layer_revaluation.product_id stock_valuation_layer_revaluation_product_id_fkey C
stock_warehouse_orderpoint.product_id stock_warehouse_orderpoint_product_id_fkey C
stock_warn_insufficient_qty_scrap.product_id stock_warn_insufficient_qty_scrap_product_id_fkey C
stock_warn_insufficient_qty_unbuild.product_id stock_warn_insufficient_qty_unbuild_product_id_fkey C
product_tmpl_id int4 10 null
product_template.id product_product_product_tmpl_id_fkey C

Product Template
create_uid int4 10 √ null
res_users.id product_product_create_uid_fkey N

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

Last Updated by
default_code varchar 2147483647 √ null

Internal Reference
barcode varchar 2147483647 √ null

Barcode
combination_indices varchar 2147483647 √ null

Combination Indices
volume numeric 0 √ null

Volume
weight numeric 0 √ null

Weight
active bool 1 √ null

Active
can_image_variant_1024_be_zoomed bool 1 √ null

Can Variant Image 1024 be zoomed
write_date timestamp 29,6 √ null

Write Date
create_date timestamp 29,6 √ null

Created on
lot_properties_definition jsonb 2147483647 √ null

Lot Properties

Indexes

Constraint Name Type Sort Column(s)
product_product_pkey Primary key Asc id
product_product__barcode_index Performance Asc barcode
product_product__combination_indices_index Performance Asc combination_indices
product_product__default_code_index Performance Asc default_code
product_product__product_tmpl_id_index Performance Asc product_tmpl_id
product_product_combination_unique Must be unique Asc/Asc product_tmpl_id + combination_indices

Relationships

Close relationships within degrees of separation