add opening_id column to candidate model