class Feedback(db.Model): __tablename__ = 'feedback' id = db.Column(db.Integer,primary_key=True,nullable=False) student_name = db.Column('student_name',db.Integer,db.ForeignKey('student.name')) course_name = db.Column('course_name', db.Integer, db.ForeignKey('course.name')) classes = db.Column(db.VARCHAR(140),nullable=False) teachers = db.Column(db.VARCHAR(140),nullable=False)
class Student(db.Model): __tablename__ = 'student' id=db.Column(db.Integer, primary_key=True, nullable=False) name = db.Column(db.VARCHAR(20), nullable=False) password = db.Column(db.VARCHAR(20), nullable=False) course = db.relationship('Course',secondary=selected, backref='student') def __int__(self,name,password): self.user=name self.pwd=password
class Course(db.Model): __tablename__ = 'course' id = db.Column(db.Integer, primary_key=True, nullable=False) name = db.Column(db.VARCHAR(20), nullable=False) teacher = db.Column(db.VARCHAR(20), nullable=False) class_room = db.Column(db.VARCHAR(20), nullable=False) score = db.Column(db.VARCHAR(20), nullable=False) def __init__(self, name, teacher, class_room, is_required): self.name = name self.teacher = teacher self.class_room = class_room self.required = is_required