m_demanddetail

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
m_demanddetail_id numeric 10 null
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_demandline_id numeric 10 null
m_demandline.m_demandline_id mdemandline_mdemanddetail C
m_forecastline_id numeric 10 √ null
m_forecastline.m_forecastline_id mforecastline_mdemanddetail C
m_requisitionline_id numeric 10 √ null
m_requisitionline.m_requisitionline_id mreqline_mdemanddetail C
c_orderline_id numeric 10 √ null
c_orderline.c_orderline_id corderline_mdemanddetail C
m_demanddetail_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_demanddetail_pkey Primary key Asc m_demanddetail_id
m_demanddetail_uu_idx Must be unique Asc m_demanddetail_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation