add postgres trigger to generate confirmation_id for submissions