mrp_workcenter_capacity

-1 rows


Description

Work Center Capacity

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_workcenter_capacity_id_seq'::regclass)
workcenter_id int4 10 null
mrp_workcenter.id mrp_workcenter_capacity_workcenter_id_fkey R

Work Center
product_id int4 10 null
product_product.id mrp_workcenter_capacity_product_id_fkey R

Product
create_uid int4 10 √ null
res_users.id mrp_workcenter_capacity_create_uid_fkey N

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

Last Updated by
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
capacity float8 17,17 √ null

Capacity
time_start float8 17,17 √ null

Setup Time (minutes)
time_stop float8 17,17 √ null

Cleanup Time (minutes)

Indexes

Constraint Name Type Sort Column(s)
mrp_workcenter_capacity_pkey Primary key Asc id
mrp_workcenter_capacity_unique_product Must be unique Asc/Asc workcenter_id + product_id

Check Constraints

Constraint Name Constraint
mrp_workcenter_capacity_positive_capacity ((capacity > (0)::double precision))

Relationships

Close relationships within degrees of separation