class ProcedureModel(db.Model):
__tablename__ = 'procedure'
id = db.column(db.Integer, primary_key=True)
procedure = db.column(db.String(), unique=True)
admin_id = db.Column(db.Integer, db.ForeignKey('admin.id'))
class PeriodModel(db.Model):
__tablename__ = 'period'
id = db.column(db.Integer, primary_key=True)
period = db.column(db.String(), unique=True)
admin_id = db.Column(db.Integer, db.ForeignKey('admin.id'))
class AssistantModel(db.Model):
__tablename__ = 'assistant'
id = db.Column(db.Integer, primary_key=True)
first_name = db.Column(db.String(), nullable=False)
last_name = db.Column(db.String(), nullable=False)
email = db.column(db.String(40), unique=True)
phone_number = db.column(db.String(10), unique=True)
admin_id = db.Column(db.Integer, db.ForeignKey('admin.id'))
class Maneuver(db.Model):
name = db.Column(db.Text)
category = db.Column(db.Text)
damage = db.Column(db.Integer)
dicead = db.Column(db.Integer)
twice = db.Column(db.Text)
multi = db.column(db.Text)
cost = db.column(db.Integer)
def __repr__(self):
return self.name