from __future__ import absolute_import
from dostadmin import db
from sqlalchemy import Table

AdminUserRole = Table(
    "adminuserrole",
    db.Model.metadata,
    db.Column("id", db.Integer, primary_key=True),
    db.Column("adminuser_id", db.Integer, db.ForeignKey("adminuser.id")),
    db.Column("role_id", db.Integer, db.ForeignKey("role.id")),
)


class Role(db.Model):
    __tablename__ = "role"
    id = db.Column("id", db.Integer, primary_key=True)
    name = db.Column("name", db.String(30), unique=True)