from sqlalchemy import * from sqlalchemy.orm import declarative_base from datetime import datetime Base = declarative_base() class Code_Model(Base): __tablename__ = 'wl_code' code_id = Column( Integer,primary_key=True,autoincrement=True) code_name = Column( String(100),nullable=False) meaning = Column( String(100),nullable=False) type = Column( String(100),nullable=False) status = Column( Integer,default=1,nullable=False) create_date = Column(DATETIME, default=datetime.now) update_date = Column(DATETIME, default=datetime.now, onupdate=datetime.now) delete_status = Column(Integer,default=0,comment='删除状态:0未删除,1已删除')