class Position(Base):
name = db.Column(db.String(32))
level = db.Column(db.Integer)
department_id = db.Column(db.Integer, db.ForeignKey("department.id"))
# 根据职位信息查询所对应的权限信息
position_permission_map = db.relationship(
"Permission",
secondary='position_permission',
backref='permission_position_map')
# 根据职位查询所对应的员工对象
position_person_map = db.relationship("Person",
backref="person_position_map",
cascade="all,delete-orphan")
class Person(Base):
username = db.Column(db.String(100), unique=True)
password = db.Column(db.String(100))
nickname = db.Column(db.String(100))
gender = db.Column(db.String(32), nullable=True)
age = db.Column(db.Integer, nullable=True)
wordid = db.Column(db.String(32), nullable=True)
phone = db.Column(db.String(64), nullable=True)
email = db.Column(db.String(64), nullable=True)
photo = db.Column(db.String(64), nullable=True)
address = db.Column(db.Text, nullable=True)
score = db.Column(db.Integer, nullable=True)
position_id = db.Column(db.Integer, db.ForeignKey("position.id"))
person_attendances_map = db.relationship("Attendance",
backref='attendance_person_map',
cascade="all,delete-orphan")