mrp_workcenter

3 rows


Description

Work Center

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('mrp_workcenter_id_seq'::regclass)
account_analytic_account_mrp_workcenter_rel.mrp_workcenter_id account_analytic_account_mrp_workcenter__mrp_workcenter_id_fkey C
mrp_routing_workcenter.workcenter_id mrp_routing_workcenter_workcenter_id_fkey R
mrp_workcenter_alternative_rel.alternative_workcenter_id mrp_workcenter_alternative_rel_alternative_workcenter_id_fkey C
mrp_workcenter_alternative_rel.workcenter_id mrp_workcenter_alternative_rel_workcenter_id_fkey C
mrp_workcenter_capacity.workcenter_id mrp_workcenter_capacity_workcenter_id_fkey R
mrp_workcenter_mrp_workcenter_tag_rel.mrp_workcenter_id mrp_workcenter_mrp_workcenter_tag_rel_mrp_workcenter_id_fkey C
mrp_workcenter_productivity.workcenter_id mrp_workcenter_productivity_workcenter_id_fkey R
mrp_workorder.workcenter_id mrp_workorder_workcenter_id_fkey R
resource_id int4 10 null
resource_resource.id mrp_workcenter_resource_id_fkey R

Resource
company_id int4 10 √ null
res_company.id mrp_workcenter_company_id_fkey N

Company
resource_calendar_id int4 10 √ null
resource_calendar.id mrp_workcenter_resource_calendar_id_fkey N

Working Hours
sequence int4 10 null

Sequence
color int4 10 √ null

Color
create_uid int4 10 √ null
res_users.id mrp_workcenter_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 √ null

Work Center
code varchar 2147483647 √ null

Code
working_state varchar 2147483647 √ null

Workcenter Status
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_efficiency float8 17,17 √ null

Time Efficiency
default_capacity float8 17,17 √ null

Capacity
costs_hour float8 17,17 √ null

Cost per hour
time_start float8 17,17 √ null

Setup Time
time_stop float8 17,17 √ null

Cleanup Time
oee_target float8 17,17 √ null

OEE Target
analytic_distribution jsonb 2147483647 √ null

Analytic Distribution

Indexes

Constraint Name Type Sort Column(s)
mrp_workcenter_pkey Primary key Asc id
mrp_workcenter__company_id_index Performance Asc company_id
mrp_workcenter__resource_calendar_id_index Performance Asc resource_calendar_id
mrp_workcenter__resource_id_index Performance Asc resource_id
mrp_workcenter_analytic_distribution_accounts_gin_index Performance

Relationships

Close relationships within degrees of separation