class Answers(db.Model):
TestID = db.Column(db.Integer,
db.ForeignKey('testframe.TestID'),
primary_key=True)
QuestionID = db.Column(db.Integer,
db.ForeignKey('questions.QuestionID'),
primary_key=True)
Answer = db.Column(db.String(250))
class Pressure(db.Model):
TestID = db.Column(db.Integer, db.ForeignKey('testframe.TestID'),
primary_key=True)
CircleID = db.Column(db.Integer, db.ForeignKey('circles.CircleID'),
primary_key=True)
PressureID = db.Column(db.Integer, primary_key=True)
Xcoord = db.Column(db.Float)
Ycoord = db.Column(db.Float)
Pressure = db.Column(db.Float)
class TestFrame(db.Model):
__tablename__ = "testframe"
TestID = db.Column(db.Integer, primary_key=True)
PatientID = db.Column(db.Integer, primary_key=True)
DoctorID = db.Column(db.Integer,
db.ForeignKey('Doctor.DoctorID'),
nullable=False,
primary_key=True)
DateTaken = db.Column(db.DateTime)
TestName = db.Column(db.String(50), db.ForeignKey('json_files.name'))
TestLength = db.Column(db.Time)
class Circles(db.Model):
TestID = db.Column(db.Integer, db.ForeignKey('testframe.TestID'),
primary_key=True)
CircleID = db.Column(db.Integer, primary_key=True)
symbol = db.Column(db.String(1))
begin_circle = db.Column(db.Float)
end_circle = db.Column(db.Float)
total_time = db.Column(db.Float)