class Journey(db.Model): __tablename__ = 'journey' id = db.Column(db.Integer, primary_key=True) passengers_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) passengers = db.relationship('User', backref=db.backref('journey', lazy=True))
class Destination(db.Model): __tablename__ = 'destination' id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String, nullable=False) address = db.Column(db.String, nullable=False) postcode = db.Column(db.Integer, nullable=False)
class Available(db.Model): id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) user = db.relationship('User', backref=db.backref('available', lazy=True))
class CalendarEvent(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String, nullable=False) start = db.Column(db.DateTime, nullable=False) end = db.Column(db.DateTime, nullable=False)
class User(db.Model): __tablename__ = 'user' id = db.Column(db.Integer, primary_key=True, nullable=False) username = db.Column(db.String, unique=True, nullable=False) email = db.Column(db.String, unique=True, nullable=False) first_name = db.Column(db.String, nullable=False) last_name = db.Column(db.String, nullable=False) driver = db.Column(db.Boolean, nullable=False) rating = db.Column(db.Float, nullable=False) course = db.Column(db.String, nullable=False) music = db.Column(db.String, nullable=False) interests = db.Column(db.String, nullable=False) avatar = db.Column(db.String, nullable=False)