from app.extensions import db


class Debt(db.Model):
    __tablename__ = 'debts'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(200), nullable=False)
    current_balance = db.Column(db.Numeric(10, 2), nullable=False)
    interest_rate = db.Column(db.Numeric(6, 4), nullable=False)    # e.g. 5.2500 for 5.25%
    min_payment = db.Column(db.Numeric(10, 2), nullable=False)
    due_date = db.Column(db.Text, nullable=True)                   # ISO 8601 specific date
    is_active = db.Column(db.Boolean, nullable=False, default=True)