| 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) |
|
|
