File size: 944 Bytes
d0501ec | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | 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)
|