bku_tbp.py

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm.exc import NoResultFound
from sqlalchemy.orm import (
    relationship,
    backref
    )
from sqlalchemy import (Column, Integer, String, SmallInteger, UniqueConstraint, 
                        Date, BigInteger, ForeignKey, func, extract, case, DateTime, Float)
from ..models import SipkdBase, SipkdDBSession

class BkuTbp(SipkdBase):
    __tablename__  = 'bkutbp'
    __table_args__ = {'extend_existing':True}    
    unitkey     = Column(String(10), primary_key=True)
    nobkuskpd   = Column(String(30), primary_key=True)
    notbp       = Column(String(50))
    idxttd      = Column(String(10))
    tglbkuskpd  = Column(DateTime)
    uraian      = Column(String(254))
    tglvalid    = Column(DateTime)
    keybend     = Column(String(10))