| 123456789101112131415161718192021222324252627 |
- from sqlalchemy import Column, String, Float, Integer, Text, Boolean, DateTime
- from sqlalchemy.ext.declarative import declarative_base
- Base = declarative_base()
- class DingEKu(Base):
- __tablename__ = '定额库'
- shuhao = Column('书号', String(50), primary_key=True)
- dingebianhao = Column('定额编号', String(50), primary_key=True)
- dingemingcheng = Column('定额名称', String(255))
- danwei = Column('单位', String(20))
- xiaohao = Column('消耗', Text)
- gongzuoneirong = Column('工作内容', Text)
- jibendinge = Column('基本定额', String(255))
- jijia = Column('基价', Float)
- gongfei = Column('工费', Float)
- liaofei = Column('料费', Float)
- jifei = Column('机费', Float)
- danzhong = Column('单重', Float)
- jiehao = Column('节号', String(50))
- liushuihao = Column('流水号', Integer)
- lock = Column('LOCK', Boolean)
- shiyong = Column('使用', Boolean)
- tiaoxuhao = Column('条目序号', Integer)
- daorushijian = Column('导入时间', DateTime)
|
