class CarLicence(db.Model): __tablename__ = 'car_licence' licence_id = db.Column(db.Integer, primary_key=True) photo = db.Column(db.LargeBinary, nullable=False) assistant_id = db.Column(db.ForeignKey('assistant.assistant_id')) assistant = db.relationship( 'Assistant', primaryjoin='CarLicence.assistant_id == Assistant.assistant_id', backref='car_licences')
class Request(db.Model): __tablename__ = 'request' request_id = db.Column(db.Integer, primary_key=True) type_of_service = db.Column(db.String, nullable=False) current_location = db.Column(db.Text, nullable=False) accepted = db.Column(db.Boolean, nullable=False) distenation_ = db.Column('distenation ', db.Text, nullable=False) time_needed = db.Column(db.Integer, nullable=False) blind_id = db.Column(db.ForeignKey('blind.blind_id')) assistant_id = db.Column(db.ForeignKey('assistant.assistant_id')) assistant = db.relationship( 'Assistant', primaryjoin='Request.assistant_id == Assistant.assistant_id', backref='requests') blind = db.relationship('Blind', primaryjoin='Request.blind_id == Blind.blind_id', backref='requests')
class BlindNationalId(db.Model): __tablename__ = 'blind_national_id' id = db.Column(db.Integer, primary_key=True) photo = db.Column(db.LargeBinary, nullable=False) blind_id = db.Column(db.ForeignKey('blind.blind_id'), nullable=False) blind = db.relationship( 'Blind', primaryjoin='BlindNationalId.blind_id == Blind.blind_id', backref='blind_national_ids')
class AssistantNationalId(db.Model): __tablename__ = 'assistant_national_id' id = db.Column(db.Integer, primary_key=True) photo = db.Column(db.LargeBinary, nullable=False) assistant_id = db.Column(db.ForeignKey('assistant.assistant_id')) assistant = db.relationship( 'Assistant', primaryjoin= 'AssistantNationalId.assistant_id == Assistant.assistant_id', backref='assistant_national_ids')
class TrustedNationalId(db.Model): __tablename__ = 'trusted_national_id' id = db.Column(db.Integer, primary_key=True) photo = db.Column(db.LargeBinary, nullable=False) trusted_id = db.Column(db.ForeignKey('trusted_person.trusted_id'), nullable=False) trusted = db.relationship( 'TrustedPerson', primaryjoin='TrustedNationalId.trusted_id == TrustedPerson.trusted_id', backref='trusted_national_ids')
class TrustedPerson(db.Model): __tablename__ = 'trusted_person' trusted_id = db.Column(db.Integer, primary_key=True) name = db.Column(db.Text, nullable=False) phone = db.Column(db.Text(11), nullable=False) relation = db.Column(db.Text, nullable=False) blind_id = db.Column(db.ForeignKey('blind.blind_id'), nullable=False) blind = db.relationship( 'Blind', primaryjoin='TrustedPerson.blind_id == Blind.blind_id', backref='trusted_people')
class Trip(db.Model): __tablename__ = 'trips' trip_id = db.Column(db.Integer, primary_key=True) complete = db.Column(db.Boolean, nullable=False) state = db.Column(db.Boolean, nullable=False) total_distance = db.Column(db.Integer, nullable=False) total_time = db.Column(db.Integer, nullable=False) payment = db.Column(db.Float(2), nullable=False) request_id = db.Column(db.ForeignKey('request.request_id')) request = db.relationship( 'Request', primaryjoin='Trip.request_id == Request.request_id', backref='trips')