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)