modified schema for adv_id