from app.extensions import db


class Account(db.Model):
    __tablename__ = "accounts"

    customerid = db.Column(db.String(50), primary_key=True)
    accountid = db.Column(db.String(11), nullable=False)
    registrationdate = db.Column(db.DateTime)
    accountcurrencycode = db.Column(db.String(3))
    schemecode = db.Column(db.String(5))
    lastinflowtransactiondate = db.Column(db.DateTime)
    accountstatus = db.Column(db.String(50))
    accountstatusdate = db.Column(db.DateTime)


    def __repr__(self):
        return f"<Account {self.accountid}>"