mp_assetmeter_log

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
mp_assetmeter_log_id numeric 10 null
cof_pneu_apontamento.mp_assetmeter_log_id mpassetmeterlog_cofpneuapontam R
cof_pneu_montagem.mp_assetmeter_log_id mpassetmeterlog_cofpneumontage R
ad_client_id numeric 10 null
ad_client.ad_client_id adclient_mpassetmeterlog R
ad_org_id numeric 10 null
ad_org.ad_org_id adorg_mpassetmeterlog R
amt numeric 0 √ null
created timestamp 29,6 null
createdby numeric 10 null
ad_user.ad_user_id createdby_mpassetmeterlog R
updatedby numeric 10 null
ad_user.ad_user_id updatedby_mpassetmeterlog R
datetrx timestamp 29,6 null
isactive bpchar 1 null
mp_assetmeter_id numeric 10 null
mp_assetmeter.mp_assetmeter_id mpassetmeter_mpassetmeterlog R
updated timestamp 29,6 null
description varchar 150 √ NULL::character varying
mp_assetmetersearch_id numeric 10 √ NULL::numeric
mp_assetmeter.mp_assetmeter_id mpassetmetersearch_mpassetmete R
mp_assetmeter_log_uu varchar 36 √ NULL::character varying
value varchar 22 √ NULL::character varying
totalamt numeric 0 √ null
mp_ot_id numeric 10 √ NULL::numeric
mp_ot.mp_ot_id mpot_mpassetmeterlog N
a_asset_id numeric 10 √ NULL::numeric
a_asset.a_asset_id aasset_mpassetmeterlog N
mp_prognosis_id numeric 10 √ NULL::numeric
mp_prognosis.mp_prognosis_id mpprognosis_mpassetmeterlog N

Indexes

Constraint Name Type Sort Column(s)
mp_assetmeter_log_key Primary key Asc mp_assetmeter_log_id
mp_assetmeter_log_uu_idx Must be unique Asc mp_assetmeter_log_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation