mrp_workcenter_productivity

-1 rows


Description

Workcenter Productivity Log

Columns

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

Work Center
company_id int4 10 null
res_company.id mrp_workcenter_productivity_company_id_fkey R

Company
workorder_id int4 10 √ null
mrp_workorder.id mrp_workcenter_productivity_workorder_id_fkey N

Work Order
user_id int4 10 √ null
res_users.id mrp_workcenter_productivity_user_id_fkey N

User
loss_id int4 10 null
mrp_workcenter_productivity_loss.id mrp_workcenter_productivity_loss_id_fkey R

Loss Reason
create_uid int4 10 √ null
res_users.id mrp_workcenter_productivity_create_uid_fkey N

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

Last Updated by
loss_type varchar 2147483647 √ null

Effectiveness
description text 2147483647 √ null

Description
date_start timestamp 29,6 null

Start Date
date_end timestamp 29,6 √ null

End Date
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
duration float8 17,17 √ null

Duration

Indexes

Constraint Name Type Sort Column(s)
mrp_workcenter_productivity_pkey Primary key Asc id
mrp_workcenter_productivity__company_id_index Performance Asc company_id
mrp_workcenter_productivity__workcenter_id_index Performance Asc workcenter_id
mrp_workcenter_productivity__workorder_id_index Performance Asc workorder_id

Relationships

Close relationships within degrees of separation