class Address(db.Model):
"""Addresses table"""
id: int
name: str
__tablename__ = 'Address'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False, unique=True)
address = db.relationship('Employee', backref='Address', lazy='dynamic')
def __init__(self, name):
self.name = name
class Skill(db.Model):
"""Skills table"""
id: int
name: str
__tablename__ = 'Skill'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False, unique=True)
skill = db.relationship('Employee', backref='Skill', lazy='dynamic')
def __init__(self, name):
self.name = name
class Permission(db.Model):
"""Permissions table"""
__tablename__ = 'Permission'
id: int
name: str
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(50), nullable=False, unique=True)
permission = db.relationship('Employee',
backref='Permission',
lazy='dynamic')
def __init__(self, name):
self.name = name
class Location(db.Model):
"""Locations table"""
id: int
name: str
__tablename__ = 'Location'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False, unique=True)
location = db.relationship('Employee', backref='Location', lazy='dynamic')
def __init__(self, name):
self.name = name
def __repr__(self):
return '<Location: {}>'.format(self.name)
class Department(db.Model):
"""Departments table"""
id: int
name: str
manager: str
date_of_creation: str
__tablename__ = 'Department'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(100), nullable=False, unique=True)
manager = db.Column(db.String(100), nullable=False)
date_of_creation = db.Column(db.String(50), default=datetime.date.today())
department = db.relationship('Employee',
backref='Department',
lazy='dynamic')
def __init__(self, name, manager, date_of_creation):
self.name = name
self.manager = manager
self.date_of_creation = date_of_creation