m_promotion

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 NULL::numeric
ad_org_id numeric 10 NULL::numeric
created timestamp 29,6 statement_timestamp()
createdby numeric 10 null
description varchar 255 √ null
isactive bpchar 1 'Y'::bpchar
m_promotion_id numeric 10 null
c_orderline.m_promotion_id mpromotion_corderline R
m_promotiondistribution.m_promotion_id mpromotion_mpromotiondistribut R
m_promotionline.m_promotion_id mpromotion_mpromotionline R
m_promotionprecondition.m_promotion_id mpromotion_mpromotionprecondit R
m_promotionreward.m_promotion_id mpromotion_mpromotionreward R
rv_commissionrundetail.m_promotion_id Implied Constraint R
rv_orderdetail.m_promotion_id Implied Constraint R
name varchar 60 null
promotionpriority numeric 10 0
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 null
c_campaign_id numeric 10 √ NULL::numeric
c_campaign.c_campaign_id ccampaign_mpromotion R
m_promotion_uu varchar 36 √ NULL::character varying

Indexes

Constraint Name Type Sort Column(s)
m_promotion_key Primary key Asc m_promotion_id
m_promotion_uu_idx Must be unique Asc m_promotion_uu

Check Constraints

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

Relationships

Close relationships within degrees of separation