I have a table users which has column roles. there are other 2 tables based on the roles (students, teachers) how do I create something that when I add student to student table, I can add the same data to users?
I have implemented this using sqlalchemy orm in python but don't know how to do directly using sql.