m_changenotice

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_changenotice_id numeric 10 null
dd_networkdistribution.m_changenotice_id mchangenotice_ddnetworkdistrib R
m_bom.m_changenotice_id mcn_mbom R
m_bomproduct.m_changenotice_id mcn_mbomproduct N
m_changerequest.m_changenotice_id mcn_mcr R
m_changerequest.m_fixchangenotice_id mfixchangenotice_mchangereques R
pp_order_bom.m_changenotice_id mchangenotice_pporderbom R
pp_order_bomline.m_changenotice_id mchangenotice_pporderbomline R
pp_order_bomline_v.m_changenotice_id Implied Constraint R
pp_order_bomline_vt.m_changenotice_id Implied Constraint R
pp_product_bom.m_changenotice_id mchangenotice_ppproductbom R
pp_product_bomline.m_changenotice_id mchangenotice_ppproductbomline R
pp_product_bomline_v.m_changenotice_id Implied Constraint R
pp_product_bomline_vt.m_changenotice_id Implied Constraint R
r_group.m_changenotice_id mchangenotice_rgroup R
r_request.m_fixchangenotice_id mfixchangenotice_rrequest R
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
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
detailinfo text 2147483647 √ null
processing bpchar 1 √ null
processed bpchar 1 'N'::bpchar
isapproved bpchar 1 'N'::bpchar
m_changenotice_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_changenotice_pkey Primary key Asc m_changenotice_id
m_changenotice_uu_idx Must be unique Asc m_changenotice_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation