mp_ot

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mp_ot_id numeric 10 null
m_inventory.mp_ot_id mpot_minventory R
mp_assetmeter_log.mp_ot_id mpot_mpassetmeterlog N
mp_ot_task.mp_ot_id mpot_mpottask R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_mpot R
documentno varchar 30 null
updatedby numeric 10 null
ad_user.ad_user_id updatedby_mpot R
ad_user_id numeric 10 √ NULL::numeric
ad_user.ad_user_id aduser_mpot R
a_asset_id numeric 10 √ null
a_asset.a_asset_id aasset_mpot R
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_mpot R
datetrx timestamp 29,6 null
description varchar 255 √ NULL::character varying
docaction bpchar 2 'CO'::bpchar
docstatus varchar 2 'DR'::character varying
isactive bpchar 1 null
mp_maintain_id numeric 10 √ NULL::numeric
mp_maintain.mp_maintain_id mpmaintain_mpot R
processed bpchar 1 null
processing bpchar 1 √ NULL::bpchar
updated timestamp 29,6 null
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_mpot R
mp_ot_request_id numeric 10 √ NULL::numeric
mp_ot_request.mp_ot_request_id mpotrequest_mpot R
mp_jobstandar_id numeric 10 √ NULL::numeric
mp_jobstandar.mp_jobstandar_id mpjobstandar_mpot R
c_doctype_id numeric 10 NULL::numeric
c_doctype.c_doctype_id cdoctype_mpot R
mp_ot_uu varchar 36 √ NULL::character varying
cof_processing bpchar 5 √ NULL::bpchar
cof_equipments_id numeric 10 √ NULL::numeric
cof_equipments.cof_equipments_id cofequipments_mpot R

Indexes

Constraint Name Type Sort Column(s)
mp_ot_key Primary key Asc mp_ot_id
mp_ot_uu_idx Must be unique Asc mp_ot_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation