## Model user
class User(Base):
    __tablename__ = "tbl_user"

    id = Column(Integer, primary_key=True)
    name = Column(Unicode(30), unique=True)
    password = Column(Unicode(40))
    password_check = Column(Unicode(40))
    email = Column(Unicode(255))
    description = Column(Unicode(255))
    created = Column(DateTime, default=datetime.datetime.utcnow())
    active = Column(Boolean, default=True)
    roles = relation('Role', secondary=user_role, backref='user')
    role_ids = association_proxy('roles','id')

## Model role
class Role(Base):
    __tablename__ = "tbl_role"

    id = Column(Integer, primary_key=True)
    name = Column(Unicode(30), unique=True)
    permission = Column(Unicode(30))
    users = relation('User',, backref='role')

## Relation
class UserRole(Base):
    __tablename__ = "tbl_user_role"

    user_id = Column(Integer, ForeignKey('tbl_user.id'), primary_key=True)
    role_id = Column(Integer, ForeignKey('tbl_role.id'), primary_key=True)
    position = Column(Integer)