from sqlalchemy import Column, String, Float, DateTime, Text, JSON
from app.database import Base
from datetime import datetime

class OCModel(Base):
    __tablename__ = "purchase_orders"

    code = Column(String(50), primary_key=True, index=True)
    name = Column(String(255), index=True)
    status = Column(String(100))
    status_code = Column(String(10), nullable=True)
    buyer = Column(String(255), index=True)
    buyer_rut = Column(String(20), nullable=True)
    provider = Column(String(255), index=True)
    provider_rut = Column(String(20), nullable=True)
    date_creation = Column(DateTime, nullable=True)
    total_amount = Column(Float, nullable=True)
    currency = Column(String(10), nullable=True)
    type = Column(String(50), nullable=True)
    
    items = Column(JSON, nullable=True)
    raw_data = Column(JSON, nullable=True)
    
    last_updated = Column(DateTime, default=datetime.utcnow, onupdate=datetime.utcnow)