class BusStop(db.Model): __tablename__ = 'stops' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(40), nullable=False) bus = db.Column(db.String(30), db.ForeignKey('busses.name'), nullable=False)
class User(UserMixin, db.Model): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(64), index=True, unique=True) email = db.Column(db.String(120), index=True, unique=True) password_hash = db.Column(db.String(128)) def __repr__(self): return '<User {}>'.format(self.username) def set_password(self, password): self.password_hash = generate_password_hash(password) def check_password(self, password): return check_password_hash(self.password_hash, password) @login.user_loader def load_user(id): return User.query.get(int(id))
class Classes(db.Model): __tablename__ = 'classes' id = db.Column(db.Integer, primary_key=True, nullable=False) courseNum = db.Column(db.String(15), nullable=False) sectionNum = db.Column(db.String(2), nullable=False) startTime = db.Column(db.String(4), nullable=False) endTime = db.Column(db.String(4), nullable=False) pm = db.Column(db.String(1), nullable=False) meetingDay = db.Column(db.String(3), nullable=False) campus = db.Column(db.String(10), nullable=False) building = db.Column(db.String(20), nullable=False)
class Schedule(db.Model): __tablename__ = 'schedules' id = db.Column(db.Integer, primary_key=True) student = db.Column(db.Integer, db.ForeignKey('students.id'), nullable=False) classID = db.Column(db.Integer, db.ForeignKey('classes.id'), nullable=False) timePref = db.Column(db.Integer, nullable=False) bus = db.Column(db.String(20), db.ForeignKey('busses.name'), nullable=False) stop = db.Column(db.Integer, db.ForeignKey('stops.id'), nullable=False)
class Bus(db.Model): __tablename__ = 'busses' name = db.Column(db.String(30), primary_key=True, unique=True) running = db.Column(db.String(1), nullable=False)
class Student(db.Model, UserMixin): __tablename__ = 'students' id = db.Column(db.Integer, primary_key=True, nullable=False) name = db.Column(db.String(25), nullable=False) number = db.Column(db.String(12), unique=True, nullable=False)