from flask_sqlalchemy import SQLAlchemy db = SQLAlchemy() class User(db.Model): __tablename__ = 'users' id = db.Column(db.Integer, primary_key=True) username = db.Column(db.String(80), unique=True, nullable=False) email = db.Column(db.String(120), unique=True, nullable=False) phone = db.Column(db.String(20)) notification_prefs = db.Column(db.String(20), default='all') portfolio_items = db.relationship('PortfolioItem', backref='user', lazy=True) settings = db.relationship('UserSettings', backref='user', uselist=False) class PortfolioItem(db.Model): __tablename__ = 'portfolio_items' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) symbol = db.Column(db.String(20), nullable=False) name = db.Column(db.String(100), nullable=False) shares = db.Column(db.Float, nullable=False) avg_price = db.Column(db.Float, nullable=False) notes = db.Column(db.Text) class UserSettings(db.Model): __tablename__ = 'user_settings' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) price_alerts = db.Column(db.Boolean, default=True) volume_alerts = db.Column(db.Boolean, default=True) news_alerts = db.Column(db.Boolean, default=False) alert_threshold = db.Column(db.Integer, default=5) class Alert(db.Model): __tablename__ = 'alerts' id = db.Column(db.Integer, primary_key=True) user_id = db.Column(db.Integer, db.ForeignKey('users.id'), nullable=False) symbol = db.Column(db.String(20), nullable=False) message = db.Column(db.String(255), nullable=False) date = db.Column(db.DateTime, nullable=False) severity = db.Column(db.String(20), nullable=False) read = db.Column(db.Boolean, default=False)