18 lines
662 B
Python
18 lines
662 B
Python
from sqlalchemy import Column, Integer, String, Boolean, DECIMAL, TIMESTAMP, DATE, TEXT, VARCHAR
|
|
from datetime import datetime
|
|
from . import Base
|
|
|
|
class Pricing_Oil_Oil(Base):
|
|
__tablename__ = 'pricing_oil_oil'
|
|
__table_args__ = {"schema": "public"}
|
|
|
|
id = Column(Integer, primary_key=True, autoincrement=True, unique=False)
|
|
|
|
price_from_supplier = Column(DECIMAL(6, 2))
|
|
price_for_customer = Column(DECIMAL(6, 2))
|
|
price_for_employee = Column(DECIMAL(6, 2))
|
|
price_same_day = Column(DECIMAL(6, 2))
|
|
price_prime = Column(DECIMAL(6, 2))
|
|
price_emergency = Column(DECIMAL(6, 2))
|
|
date = Column(TIMESTAMP(), default=datetime.utcnow())
|