class CourseExercise(db.Model): id = db.Column(db.Integer(), primary_key=True) course_id = db.Column(db.Integer(), db.ForeignKey('course.id', ondelete='CASCADE')) number = db.Column(db.Integer()) title = db.Column(db.String(50)) archive = db.Column(db.LargeBinary())
class Role(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(50), unique=True)
class Tag(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(), nullable=False)
class Course(db.Model): id = db.Column(db.Integer(), primary_key=True) name = db.Column(db.String(50)) term = db.Column(db.String(50)) university = db.Column(db.String(50))
class Docu(db.Model): id = db.Column(db.Integer(), primary_key=True) key = db.Column(db.String(), nullable=False) text = db.Column(db.String(), nullable=False)