mrp_bom_byproduct

-1 rows


Description

Byproduct

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_bom_byproduct_id_seq'::regclass)
mrp_bom_byproduct_product_template_attribute_value_rel.mrp_bom_byproduct_id mrp_bom_byproduct_product_template_at_mrp_bom_byproduct_id_fkey C
stock_move.byproduct_id stock_move_byproduct_id_fkey N
product_id int4 10 null
product_product.id mrp_bom_byproduct_product_id_fkey R

By-product
company_id int4 10 √ null
res_company.id mrp_bom_byproduct_company_id_fkey N

Company
product_uom_id int4 10 null
uom_uom.id mrp_bom_byproduct_product_uom_id_fkey R

Unit of Measure
bom_id int4 10 √ null
mrp_bom.id mrp_bom_byproduct_bom_id_fkey C

BoM
operation_id int4 10 √ null
mrp_routing_workcenter.id mrp_bom_byproduct_operation_id_fkey N

Produced in Operation
sequence int4 10 √ null

Sequence
create_uid int4 10 √ null
res_users.id mrp_bom_byproduct_create_uid_fkey N

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

Last Updated by
product_qty numeric 0 null

Quantity
cost_share numeric 0 √ null

Cost Share (%)
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
mrp_bom_byproduct_pkey Primary key Asc id
mrp_bom_byproduct__bom_id_index Performance Asc bom_id
mrp_bom_byproduct__company_id_index Performance Asc company_id

Relationships

Close relationships within degrees of separation