| from sqlalchemy import Column, Integer, String, Float, DateTime | |
| from datetime import datetime | |
| from .database import Base | |
| class Invoice(Base): | |
| __tablename__ = "invoices" | |
| id = Column(Integer, primary_key=True, index=True) | |
| filename = Column(String, index=True) | |
| issuer = Column(String, index=True, nullable=True) | |
| total_value = Column(Float, nullable=True) | |
| status = Column(String, default="pending") # pending, processed, failed | |
| created_at = Column(DateTime, default=datetime.utcnow) | |