ticket workflow & small DB schema fixes