m_changerequest

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_changerequest_id numeric 10 null
cof_rv_requestpartner.m_changerequest_id Implied Constraint R
r_request.m_changerequest_id mchangerequest_rrequest R
r_request_v.m_changerequest_id Implied Constraint 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
m_changenotice_id numeric 10 √ null
m_changenotice.m_changenotice_id mcn_mcr R
documentno varchar 30 null
name varchar 60 null
description varchar 255 √ null
help varchar 2000 √ null
detailinfo text 2147483647 √ null
m_fixchangenotice_id numeric 10 √ null
m_changenotice.m_changenotice_id mfixchangenotice_mchangereques R
processed bpchar 1 'N'::bpchar
isapproved bpchar 1 'N'::bpchar
pp_product_bom_id numeric 10 √ null
pp_product_bom.pp_product_bom_id ppproductbom_mchangerequest R
m_changerequest_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_changerequest_pkey Primary key Asc m_changerequest_id
m_changerequest_uu_idx Must be unique Asc m_changerequest_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation