class Notification(db.Model):
__tablename__ = 'notification'
id = db.Column(db.Integer, primary_key=True)
days_before = db.Column(db.Integer, nullable=False)
document = db.relationship("Document",
uselist=False,
backref="notification")
class User(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)
class Document(db.Model):
__tablename__ = 'document'
id = db.Column(db.Integer, primary_key=True)
exp_date = db.Column(db.Datetime, nullable=False)
name = db.Column(db.String, nullable=False)
notification = db.relationship('Notification',
backref='document',
lazy=True)
class AutoTrain(db.Model):
__tablename__ = 'autotrain'
truck_id = db.Column(db.String, primary_key=True)
trailer_id = db.Column(db.String, primary_key=True)
driver_id = db.Column(db.Integer, primary_key=True)
driver_name = db.Column(db.String, nullable=False)
truck = db.relationship('Truck', uselist=False, back_populates='autotrain')
trailer = db.relationship('Trailer',
uselist=False,
back_populates='autotrain')
driver = db.relationship('Driver',
uselist=False,
back_populates='autotrain')
def __repr__(self):
return '<{} {} {} {}>'.format(self.truck_id, self.trailer_id,
self.driver_name, self.driver_id)
class Trailer(db.Model):
__tablename__ = 'trailer'
licence_plate = db.Column(db.String, primary_key=True)
document = db.relationship('Document', backref='trailer', lazy=True)
class Driver(db.Model):
__tablename__ = 'driver'
phone = db.Column(db.String, primary_key=True)
name = db.Column(db.String, nullable=False)
document = db.relationship('Document', backref='driver', lazy=True)