from datetime import datetime
from app.extensions import db


class Notification(db.Model):
    __tablename__ = "notifications"
    id = db.Column(db.Integer, primary_key=True)
    user_id = db.Column(db.Integer, db.ForeignKey("users.id"), nullable=False)
    type = db.Column(db.String(40), default="info")
    title = db.Column(db.String(150))
    body = db.Column(db.Text)
    data = db.Column(db.Text)
    icon = db.Column(db.String(16), default="📢")
    read = db.Column(db.Boolean, default=False)
    created_at = db.Column(db.DateTime, default=datetime.utcnow)

    user = db.relationship("User", foreign_keys=[user_id])