from app.extensions import db


class Settings(db.Model):
    """
    Single-row settings table. Always access via Settings.query.first() or upsert with id=1.
    Never create more than one row.
    """
    __tablename__ = 'settings'

    id = db.Column(db.Integer, primary_key=True)   # always 1
    monthly_income = db.Column(db.Numeric(10, 2), nullable=True)
    extra_monthly_payment = db.Column(db.Numeric(10, 2), nullable=True)