mysql model created, tan assignment implemented