14 lines
681 B
Python
14 lines
681 B
Python
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已删除') |