mp_jobstandar

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mp_jobstandar_id numeric 10 null
mp_jobstandar_task.mp_jobstandar_id mpjobstandar_mpjobstandartask R
mp_maintain.mp_jobstandar_id mpjobstandar_mpmaintain R
mp_ot.mp_jobstandar_id mpjobstandar_mpot R
mp_ot_request.mp_jobstandar_id mpjobstandar_mpotrequest R
name varchar 60 √ NULL::character varying
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_mpjobstandar R
a_asset_group_id numeric 10 √ NULL::numeric
a_asset_group.a_asset_group_id aassetgroup_mpjobstandar R
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_mpjobstandar R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_mpjobstandar R
updatedby numeric 10 null
ad_user.ad_user_id updatedby_mpjobstandar R
jobstandartype varchar 2 null
maintainarea varchar 2 √ NULL::character varying
updated timestamp 29,6 null
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_mpjobstandar R
isactive bpchar 1 null
mp_jobstandar_uu varchar 36 √ NULL::character varying
type varchar 10 'P'::character varying
cof_processing2 bpchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
mp_jobstandar_key Primary key Asc mp_jobstandar_id
mp_jobstandar_uu_idx Must be unique Asc mp_jobstandar_uu

Check Constraints

Constraint Name Constraint
mp_jobstandar_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation