mp_maintain

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mp_maintain_id numeric 10 null
mp_maintain.mp_maintainparent_id mpmaintainparent_mpmaintain R
mp_maintain_task.mp_maintain_id mpmaintain_mpmaintaintask R
mp_ot.mp_maintain_id mpmaintain_mpot R
mp_ot_task.mp_maintain_id mpmaintain_mpottask R
mp_prognosis.mp_maintain_id mpmaintain_mpprognosis R
documentno varchar 30 null
ischild bpchar 1 √ NULL::bpchar
updatedby numeric 10 null
ad_user.ad_user_id updatedby_mpmaintain R
a_asset_group_id numeric 10 √ NULL::numeric
a_asset_group.a_asset_group_id aassetgroup_mpmaintain R
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_mpmaintain R
currentmp numeric 0 √ null
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_mpmaintain R
datelastot timestamp 29,6 √ null
datelastrunmp timestamp 29,6 √ null
datelastrun timestamp 29,6 √ null
datenextrun timestamp 29,6 √ null
description varchar 255 √ NULL::character varying
docstatus varchar 2 'AT'::character varying
interval numeric 0 √ null
isactive bpchar 1 null
lastmp numeric 0 √ null
lastread numeric 0 √ null
mp_jobstandar_id numeric 10 √ NULL::numeric
mp_jobstandar.mp_jobstandar_id mpjobstandar_mpmaintain R
mp_maintainparent_id numeric 10 √ NULL::numeric
mp_maintain.mp_maintain_id mpmaintainparent_mpmaintain R
nextmp numeric 0 √ null
programmingtype bpchar 1 'M'::bpchar
promuse numeric 0 √ null
priorityrule bpchar 1 √ NULL::bpchar
range numeric 0 √ null
updated timestamp 29,6 null
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_mpmaintain R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_mpmaintain R
mp_meter_id numeric 10 √ NULL::numeric
mp_meter.mp_meter_id mpmeter_mpmaintain R
copyfrom bpchar 1 √ NULL::bpchar
mp_maintain_uu varchar 36 √ NULL::character varying
c_doctype_id numeric 10 √ NULL::numeric
c_doctype.c_doctype_id cdoctype_mpmaintain R

Indexes

Constraint Name Type Sort Column(s)
mp_maintain_key Primary key Asc mp_maintain_id
mp_maintain_uu_idx Must be unique Asc mp_maintain_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation