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