Yeah I like that idea too... maybe we could work it into the adjustments table as a field called promotion_id?