class Vehicle(db.Model): vec_id = db.Column(db.Integer, primary_key=True) Image_Front = db.Column(db.String(120), default='default.jpg', nullable=False) Image_Back = db.Column(db.String(120), default='default.jpg', nullable=False) Image_rside = db.Column(db.String(120), default='default.jpg', nullable=False) Image_lside = db.Column(db.String(120), default='default.jpg', nullable=False) count = db.Column(db.Integer, nullable=False, default=0) Company = db.Column(db.String(100), nullable=False) Model = db.Column(db.String(100), nullable=False) Colour = db.Column(db.String(100), nullable=False) check = db.relationship('Check', backref='check', lazy=True) buyer_id = db.Column(db.Integer, db.ForeignKey('buyers.buy_id')) seller_id = db.Column(db.Integer, db.ForeignKey('sellers.sel_id'), nullable=False) buyer = db.relationship('Buyers', backref=backref("buyers", uselist=False), lazy=True) seller = db.relationship('Sellers', backref=backref("seller", uselist=False), lazy=True) def __repr__(self): return (f'{self.vec_id},{self.buyer_id},{self.seller_id}')
class Sellers(db.Model): sel_id = db.Column(db.Integer, primary_key=True) User_i = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) vec_seller = db.relationship('Vehicle', backref='vec_seller', lazy=True) def __repr__(self): return (f'{self.User_i},{self.sel_id}')
class Buyers(db.Model): buy_id = db.Column(db.Integer, primary_key=True) User_i = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) vec_buyer = db.relationship('Vehicle', backref='vec_buyer', lazy=True) b_user = db.relationship('User', backref=backref("b_user", uselist=False), lazy=True) def __repr__(self): return (f'{self.User_id},{self.buy_id}')
class Check(db.Model): ckeck_id = db.Column(db.Integer, primary_key=True) cvec_id = db.Column(db.Integer, db.ForeignKey('vehicle.vec_id'), nullable=False) mil = db.Column(db.String(120), default='default.jpg', nullable=False) vin = db.Column(db.String(120), default='default.jpg', nullable=False) fin = db.Column(db.String(120), default='default.jpg', nullable=False) def __repr__(self): return (f'{self.ckeck_id},{self.cvec_id}')
class Sample(db.Model): id=db.Column(db.Integer,primary_key=True) patient_name=db.Column(db.Text(),nullable=False) Sample_type=db.Column(db.Text(),nullable=False) med_record_no=db.Column(db.Text(),nullable=False) patient_location=db.Column(db.Text(),nullable=False) collection_time=db.Column(db.DateTime(),default=datetime.utcnow) ordering_lab=db.Column(db.Text(),nullable=False) accepted=db.Column(db.Boolean()) lab_id=db.Column(db.Integer(),db.ForeignKey('user.id')) def __repr__(self): return 'sample of %s {} at %d'.format(self.patient_name,self.collection_time)
class Check(db.Model): ckeck_id = db.Column(db.Integer, primary_key=True) cvec_id = db.Column(db.Integer, db.ForeignKey('vehicle.vec_id'), nullable=False) mil = db.Column(db.String(120), default='default.pdf', nullable=False) vin = db.Column(db.String(120), default='default.pdf', nullable=False) fin = db.Column(db.String(120), default='default.pdf', nullable=False) vec_rel = db.relationship('Vehicle', backref=backref("vec_rel", uselist=False), lazy=True) def __repr__(self): return (f'{self.ckeck_id},{self.cvec_id}')