mrp_routing_workcenter

-1 rows


Description

Work Center Usage

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_routing_workcenter_id_seq'::regclass)
mrp_bom_byproduct.operation_id mrp_bom_byproduct_operation_id_fkey N
mrp_bom_line.operation_id mrp_bom_line_operation_id_fkey N
mrp_routing_workcenter_dependencies_rel.blocked_by_id mrp_routing_workcenter_dependencies_rel_blocked_by_id_fkey C
mrp_routing_workcenter_dependencies_rel.operation_id mrp_routing_workcenter_dependencies_rel_operation_id_fkey C
mrp_routing_workcenter_product_template_attribute_value_rel.mrp_routing_workcenter_id mrp_routing_workcenter_product_t_mrp_routing_workcenter_id_fkey C
mrp_workorder.operation_id mrp_workorder_operation_id_fkey N
stock_move.operation_id stock_move_operation_id_fkey N
workcenter_id int4 10 null
mrp_workcenter.id mrp_routing_workcenter_workcenter_id_fkey R

Work Center
sequence int4 10 √ null

Sequence
bom_id int4 10 null
mrp_bom.id mrp_routing_workcenter_bom_id_fkey C

Bill of Material
time_mode_batch int4 10 √ null

Based on
create_uid int4 10 √ null
res_users.id mrp_routing_workcenter_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Operation
worksheet_type varchar 2147483647 √ null

Worksheet
worksheet_google_slide varchar 2147483647 √ null

Google Slide
time_mode varchar 2147483647 √ null

Duration Computation
note text 2147483647 √ null

Description
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
time_cycle_manual float8 17,17 √ null

Manual Duration

Indexes

Constraint Name Type Sort Column(s)
mrp_routing_workcenter_pkey Primary key Asc id
mrp_routing_workcenter__bom_id_index Performance Asc bom_id

Relationships

Close relationships within degrees of separation