assoc_user_role = Table(
"ab_user_role",
Model.metadata,
Column("id", Integer, Sequence("ab_user_role_id_seq"), primary_key=True),
Column("user_id", Integer, ForeignKey("ab_user.id")),
Column("role_id", Integer, ForeignKey("ab_role.id")),
UniqueConstraint("user_id", "role_id"),
extend_existing=True,
)
class MyUser(User):
tablename = "ab_user"
phone_number = Column(String(150))
email = Column(String(64), unique=False, nullable=True)
roles = relationship("Role", secondary=assoc_user_role, backref="myuser")