from sqlalchemy import Column, Integer, String, Float, Date, Boolean, func, PrimaryKeyConstraint
from main import Base2

class ELANG_SAMPAH(Base2):
    __table_args__ = (
        {"schema": "public"},
        # PrimaryKeyConstraint('BRAND', 'kpi_name', 'tampung', 'ROLE','lmtd','mtd','GROWTH','JABATAN','asof_dt'),
    )
    __tablename__ = "ELANG_SAMPAH"
    
    BRAND = Column(String(255),primary_key=True)
    kpi_name = Column(String(255),primary_key=True)
    tampung = Column(Date,primary_key=True)
    ROLE = Column(String(255),primary_key=True)
    lmtd = Column(Float,primary_key=True)
    mtd = Column(Float,primary_key=True)
    GROWTH = Column(Float,primary_key=True)
    JABATAN = Column(String(255),primary_key=True)
    URUTAN2 = Column(Float,primary_key=True)
    URUTAN = Column(Float,primary_key=True)
    asof_dt = Column(Date,primary_key=True)