final schema for tickets

schema is now fully working!