from sqlalchemy import Column, Integer, String, Text, DateTime, ForeignKey, Float from sqlalchemy.orm import relationship from datetime import datetime from app.db.database import Base class DailyDigest(Base): __tablename__ = "daily_digests" id = Column(Integer, primary_key=True, index=True) date_str = Column(String(50), unique=True, index=True) # e.g., "2026-07-22" title = Column(String(255), nullable=False) overall_summary = Column(Text, nullable=False) top_highlights = Column(Text, nullable=True) # JSON or markdown string of top 3 highlights created_at = Column(DateTime, default=datetime.utcnow) items = relationship("DigestItem", back_populates="daily_digest", cascade="all, delete-orphan") class DigestItem(Base): __tablename__ = "digest_items" id = Column(Integer, primary_key=True, index=True) daily_digest_id = Column(Integer, ForeignKey("daily_digests.id"), nullable=True) title = Column(String(500), nullable=False) url = Column(String(1000), nullable=False) source = Column(String(100), nullable=False) # HackerNews, TechCrunch, GitHub Trends category = Column(String(100), default="Tech") # AI, Web, Security, Mobile, Open Source, etc. summary = Column(Text, nullable=False) key_takeaway = Column(Text, nullable=True) importance_score = Column(Float, default=5.0) published_at = Column(DateTime, default=datetime.utcnow) created_at = Column(DateTime, default=datetime.utcnow) daily_digest = relationship("DailyDigest", back_populates="items") class DeviceToken(Base): __tablename__ = "device_tokens" id = Column(Integer, primary_key=True, index=True) token = Column(String(500), unique=True, index=True, nullable=False) device_type = Column(String(50), default="android") # android | ios created_at = Column(DateTime, default=datetime.utcnow) updated_at = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)