ref: master
core/types/order_product.py
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
from core.database import Base from sqlalchemy import Integer, Column, ForeignKey, DateTime from datetime import datetime as dt class OrderProduct(Base): __tablename__ = "order_products" id = Column(Integer, primary_key=True) product_id = Column(Integer, ForeignKey('products.id'), nullable=False) order_id = Column(Integer, ForeignKey('orders.id'), nullable=False) quantity = Column(Integer, default=1, nullable=False) created_at = Column(DateTime, nullable=False) updated_at = Column(DateTime, nullable=False) def __init__(self, order_id, product_id, quantity): self.order_id = order_id self.product_id = product_id self.quantity = quantity |