class LoanClientAssociation(db.Model): loan_ref = db.Column(db.String(64), db.ForeignKey('loan.id'), primary_key=True) loan = db.relationship('Loan', backref='loan_client_associations') client_ref = db.Column(db.String(64), db.ForeignKey('client.id_number'), primary_key=True) client = db.relationship('Client', backref='loan_client_associations')
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(20), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) image_file = db.Column(db.String(20), nullable=False, default='default.jpg') password = db.Column(db.String(60), nullable=False) posts = db.relationship('Post', backref='author', lazy=True) post_index = db.Column(db.Integer()) address = db.Column(db.String(100)) city = db.Column(db.String(30)) blood_group = db.Column(db.String(10), nullable=False) phone = db.Column( db.Integer(), unique=True, ) about = db.Column(db.String(140)) last_seen = db.Column(db.DateTime, default=datetime.utcnow) donates = db.relationship('Donate', backref='author', lazy=True) followed = db.relationship('User', secondary=followers, primaryjoin=(followers.c.follower_id == id), secondaryjoin=(followers.c.followed_id == id), backref=db.backref('followers', lazy='dynamic'), lazy='dynamic') def __repr__(self): return f"User('{self.username}', '{self.email}', '{self.image_file}')" def avatar(self, size): digest = md5(self.email.lower().encode('utf-8')).hexdigest() return 'https://www.gravatar.com/avatar/{}?d=identicon&s={}'.format( digest, size) def follow(self, user): if not self.is_following(user): self.followed.append(user) def unfollow(self, user): if self.is_following(user): self.followed.remove(user) def is_following(self, user): return self.followed.filter( followers.c.followed_id == user.id).count() > 0 def followed_posts(self): followed = Post.query.join( followers, (followers.c.followed_id == Post.user_id)).filter( followers.c.follower_id == self.id) own = Post.query.filter_by(user_id=self.id) return followed.union(own).order_by(Post.timestamp.desc())
class Loan(db.Model): id = db.Column(db.Integer, primary_key=True) money = db.Column(db.Float, nullable=False) status = db.Column(db.String(64), nullable=False) bank_ref = db.Column(db.String(64), db.ForeignKey('bank.name'), nullable=False) bank = db.relationship('Bank', backref='loans')
class Account(db.Model): acnt_id = db.Column(db.Integer, primary_key=True) cust_id = db.Column(db.Integer, db.ForeignKey('customer.cust_id')) acnt_type = db.Column(db.String(20), index=False, unique=False) acnt_balance = db.Column(db.Integer, index=False, unique=False) acnt_status = db.Column(db.String(20), index=False, unique=False) acnt_last_tr_date = db.Column(db.DateTime, index=False, unique=False) acnt_message = db.Column(db.String(20), index=False, unique=False) transaction = db.relationship('Transaction', backref='customer')
class Account(db.Model): id = db.Column(db.String(64), primary_key=True) balance = db.Column(db.Float, nullable=False) open_date = db.Column(db.Integer, nullable=False) account_type = db.Column(db.String(64), nullable=False) bank_ref = db.Column(db.String(64), db.ForeignKey('bank.name'), nullable=False) bank = db.relationship('Bank', backref='accounts') __mapper_args__ = {'polymorphic_on': account_type}
class Staff(db.Model): id_number = db.Column(db.String(64), primary_key=True) name = db.Column(db.String(64), nullable=False) phone_number = db.Column(db.String(64), nullable=False) address = db.Column(db.String(64), nullable=False) joined_date = db.Column(db.Integer, nullable=False) kind = db.Column(db.String(64), nullable=False) department_ref = db.Column(db.Integer, db.ForeignKey('department.id'), nullable=False) department = db.relationship('Department', backref='staffs')
class Token(db.Model): token = db.Column(db.String(64), default=lambda: str(uuid.uuid4()), primary_key=True) expiresAt = db.Column(db.Integer, nullable=False, default=lambda: int(datetime.utcnow().timestamp()) + current_app.config['TOKEN_EXPIRE']) user_ref = db.Column(db.String(64), db.ForeignKey('user.username'), nullable=False) user = db.relationship('User', backref='tokens')
class Customer(db.Model): cust_id = db.Column(db.Integer, primary_key=True) cust_ssn = db.Column(db.Integer, index=True, unique=True) cust_name = db.Column(db.String(20), index=False, unique=False) cust_age = db.Column(db.Integer, index=False, unique=False) cust_addr1 = db.Column(db.Text, index=False, unique=False) cust_addr2 = db.Column(db.Text, index=False, unique=False, nullable=True) cust_city = db.Column(db.String(20), index=False, unique=False) cust_state = db.Column(db.String(20), index=False, unique=False) cust_last_update = db.Column(db.Date, index=False, unique=False) cust_status = db.Column(db.String(20), index=False, unique=False) cust_message = db.Column(db.String(20), index=False, unique=False) account = db.relationship('Account', backref='customer')
class Client(db.Model): id_number = db.Column(db.String(64), primary_key=True) name = db.Column(db.String(64), nullable=False) phone_number = db.Column(db.String(64), nullable=False) address = db.Column(db.String(64), nullable=False) contact_name = db.Column(db.String(64), nullable=False) contact_phone_number = db.Column(db.String(64), nullable=False) contact_email = db.Column(db.String(64), nullable=False) contact_relationship = db.Column(db.String(64), nullable=False) staff_ref = db.Column(db.String(64), db.ForeignKey('staff.id_number'), nullable=False) staff = db.relationship('Staff', backref='clients')
class User(db.Model, UserMixin): id = db.Column(db.Integer, primary_key=True) email = db.Column(db.String(120), unique=True, nullable=False) password = db.Column(db.String(60), nullable=False) first_name = db.Column(db.String(255), nullable=False) last_name = db.Column(db.String(255), nullable=False) admin = db.Column(db.Boolean, unique=False, default=False) balance = db.Column( db.Numeric(precision=10, scale=2, asdecimal=True, decimal_return_scale=2)) logs = db.relationship('TransactionLog', backref='user', lazy=True)
class CustomerAccount(db.Model): account_id = db.Column(db.Integer, primary_key=True, nullable=False) customer_id = db.Column(db.Integer, db.ForeignKey('customer.customer_id'), nullable=False) customer = db.relationship("Customer", backref=db.backref("customer", uselist=False)) account_type = db.Column(db.String(30), nullable=False) deposit_amount = db.Column(db.Integer, nullable=False) last_updated = db.Column(db.DateTime, nullable=False, default=datetime.datetime.now) def __repr__(self): return f'Account: {self.account_id} Customer_id: {self.customer_id}'
class TransactionInfo(db.Model): transaction_id = db.Column(db.String(100), primary_key=True, nullable=False) account_id = db.Column(db.Integer, db.ForeignKey('customer_account.account_id'), nullable=False) account = db.relationship("CustomerAccount", backref=db.backref("customer_account", uselist=False)) amount = db.Column(db.Integer, nullable=False) deposit = db.Column(db.Boolean, nullable=False) transfer = db.Column(db.Boolean, nullable=False) transfer_account_id = db.Column(db.Integer, nullable=False) action_date = db.Column(db.DateTime, nullable=False, default=datetime.datetime.now)
class Payment(db.Model): id = db.Column(db.Integer, primary_key=True) pay_date = db.Column(db.Integer, nullable=False) money = db.Column(db.Float, nullable=False) loan_ref = db.Column(db.Integer, db.ForeignKey('loan.id'), nullable=False) loan = db.relationship('Loan', backref='payments')