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 ServiceRelationship(db.Model): """ 业务关系,描述客户与银行的联系 """ __tablename__ = 'servicerelationship' branchName = db.Column(db.String(20), db.ForeignKey('branch.branchName'), primary_key=True) clientId = db.Column(db.String(20), db.ForeignKey('client.id'), primary_key=True)
class OpenChequeAccount(db.Model): """ 开设支票账户 """ __tablename__ = 'openchequeaccount' accountId = db.Column(db.String(20), db.ForeignKey('chequeaccount.id'), primary_key=True) clientId = db.Column(db.String(20), db.ForeignKey('client.id'), primary_key=True)
class OpenDepositAccount(db.Model): """ 开设储蓄账户 """ __tablename__ = 'opendepositaccount' accountId = db.Column(db.String(20), db.ForeignKey('depositaccount.id'), primary_key=True) clientId = db.Column(db.String(20), db.ForeignKey('client.id'), primary_key=True)
class Serve(db.Model): """ 服务。员工服务客户的关系。 """ __tablename__ = 'serve' clientId = db.Column(db.String(20), db.ForeignKey('client.id'), primary_key=True) staffId = db.Column(db.String(20), db.ForeignKey('staff.id'), primary_key=True) ServiceType = db.Column(db.String(20))
class OpenAccount(db.Model): """ 开户 用户每开设一个支票账户或储蓄账户的同时也需要在此处创建一条记录。 其用处为一个客户在一个支行只能开设一个储蓄账户和一个支票账户。 该类的目的不在于查询,只在于实施该限制 """ __tablename__ = 'openaccount' branchName = db.Column(db.String(20), db.ForeignKey('branch.branchName'), primary_key=True) id = db.Column(db.String(20), db.ForeignKey('client.id'), primary_key=True) depositAccountId = db.Column(db.String(20)) chequeAccountId = db.Column(db.String(20))
class Transaction(db.Model): tr_id = db.Column(db.Integer, primary_key=True) tr_amount = db.Column(db.Integer, index=False, unique=False) tr_type = db.Column(db.String(20), index=False, unique=False) tr_date = db.Column(db.DateTime, index=False, unique=False) tr_src= db.Column(db.Integer, db.ForeignKey('account.acnt_id')) tr_trgt= db.Column(db.Integer, index=False, unique=False)
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 ChequeAccount(db.Model): """ 支票账户类 """ __tablename__ = 'chequeaccount' id = db.Column(db.String(20), primary_key=True) branchName = db.Column(db.String(20), db.ForeignKey('branch.branchName')) accountBalance = db.Column(db.Float) openTime = db.Column(db.DateTime) visitTime = db.Column(db.DateTime) creditLimit = db.Column(db.Float)
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 Post(db.Model): id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(100), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) content = db.Column(db.Text, nullable=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Post('{self.title}', '{self.date_posted}')"
class Donate(db.Model): id = db.Column(db.Integer, primary_key=True) name_blood = db.Column(db.String(10), nullable=False) quantity = db.Column(db.Integer(), nullable=False) date_posted = db.Column(db.DateTime, nullable=False, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False) def __repr__(self): return f"Donate('{self.name_blood}', '{self.quantity}', '{self.date_posted}')"
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 OwnLoan(db.Model): """ 拥有。客户拥有贷款的关系 """ __tablename__ = 'ownloan' branchName = db.Column(db.String(20), primary_key=True) loanId = db.Column(db.String(6), primary_key=True) clientId = db.Column(db.String(20), db.ForeignKey('client.id'), primary_key=True) __table_args__ = (db.ForeignKeyConstraint( ['branchName', 'loanId'], ['loan.branchName', 'loan.loanId']), )
class TransactionLog(db.Model): id = db.Column(db.Integer, primary_key=True) date = db.Column(db.DateTime, default=datetime.datetime.utcnow) amount = db.Column( db.Numeric(precision=10, scale=2, asdecimal=True, decimal_return_scale=2)) from_account = db.Column(db.String(120), nullable=False) to_account = db.Column(db.String(120), nullable=False) positive = db.Column(db.Boolean, unique=False, default=False) user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=False)
class DepositAccount(db.Model): """ 储蓄账户类 """ __tablename__ = 'depositaccount' id = db.Column(db.String(20), primary_key=True) branchName = db.Column(db.String(20), db.ForeignKey('branch.branchName')) accountBalance = db.Column(db.Float) openTime = db.Column(db.DateTime) visitTime = db.Column(db.DateTime) interestRate = db.Column(db.Float) currencyType = db.Column(db.String(20))
class Loan(db.Model): """ 贷款类 """ __tablename__ = 'loan' branchName = db.Column(db.String(20), db.ForeignKey('branch.branchName')) loanId = db.Column(db.String(6)) loanAmount = db.Column(db.Float) payNum = db.Column(db.Integer) __table_args__ = (db.PrimaryKeyConstraint('branchName', 'loanId', name='PK_Loan'), )
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 Department(db.Model): """ 部门类 """ __tablename__ = 'department' branchName = db.Column(db.String(20), db.ForeignKey('branch.branchName')) deptId = db.Column(db.Integer) deptName = db.Column(db.String(20)) deptType = db.Column(db.String(20), nullable=True) deptManagerID = db.Column(db.String(20), unique=True, nullable=True) __table_args__ = (db.PrimaryKeyConstraint('branchName', 'deptId', name='PK_Dept'), )
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 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)
from bank import db, login_manager from datetime import datetime from flask_login import UserMixin from hashlib import md5 @login_manager.user_loader def load_user(user_id): return User.query.get(int(user_id)) followers = db.Table( 'followers', db.Column('follower_id', db.Integer, db.ForeignKey('user.id')), db.Column('followed_id', db.Integer, db.ForeignKey('user.id'))) 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(
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')