s_resource

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
s_resource_id numeric 10 null
ad_wf_node.s_resource_id sresource_adwfnode R
ad_workflow.s_resource_id sresource_adworkflow R
i_productplanning.s_resource_id sresource_iproductplanning R
m_product.s_resource_id sresource_mproduct R
mp_jobstandar_resource.s_resource_id sresource_mpjobstandarresource R
mp_maintain_resource.s_resource_id sresource_mpmaintainresource R
mp_ot_resource.s_resource_id sresource_mpotresource R
pp_cost_collector.s_resource_id sresource_ppcostcollector R
pp_mrp.s_resource_id sresource_ppmrp R
pp_order.s_resource_id sresource_pporder R
pp_order_node.s_resource_id sresource_ppordernode R
pp_order_workflow.s_resource_id sresource_pporderworkflow R
pp_product_planning.s_resource_id sresource_ppproductplanning R
s_resourceassignment.s_resource_id sresource_sresourceassignment R
s_resourceunavailable.s_resource_id sresource_sresunavailable C
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
value varchar 40 null
name varchar 60 null
description varchar 255 √ null
s_resourcetype_id numeric 10 null
s_resourcetype.s_resourcetype_id sresourcetype_sresource C
m_warehouse_id numeric 10 null
m_warehouse.m_warehouse_id mwarehouse_sresource R
isavailable bpchar 1 'Y'::bpchar
ad_user_id numeric 10 √ null
ad_user.ad_user_id aduser_sresource R
chargeableqty numeric 0 √ 0
percentutilization numeric 0 (100)::numeric
dailycapacity numeric 0 √ null
ismanufacturingresource bpchar 1 √ 'N'::bpchar
waitingtime numeric 0 √ null
manufacturingresourcetype bpchar 2 √ null
queuingtime numeric 0 √ null
planninghorizon numeric 10 √ (0)::numeric
s_resource_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
s_resource_pkey Primary key Asc s_resource_id
s_resource_uu_idx Must be unique Asc s_resource_uu

Check Constraints

Constraint Name Constraint
s_resource_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
chk_col_53272 ((percentutilization >= (0)::numeric))
s_resource_isavailable_check ((isavailable = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
s_resource_ismanufacturingresource_check ((ismanufacturingresource = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation