StockGuard / database /models.py
Anant0712's picture
Rename backend/database/models.py to database/models.py
ac97a2a verified
Raw History Blame Contribute Delete
1.86 kB
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)