You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

31 lines
1.6 KiB

10 months ago
from sqlalchemy import Column, Integer, String, DateTime
from config.database import Base
from datetime import datetime
class SysDasset(Base):
"""
数据资产管理表
"""
__tablename__ = 'sys_dasset'
dasset_id = Column(Integer, primary_key=True, autoincrement=True, comment='数据资产ID')
dasset_parent_id = Column(Integer, default=0, comment='父资产ID')
dasset_ancestors = Column(String(50), nullable=True, default='', comment='祖级列表')
dasset_name = Column(String(30), nullable=True, default='', comment='数据资产名称')
dasset_remark = Column(String(225), nullable=True, default='', comment='数据资产说明')
dasset_order_num = Column(Integer, default=0, comment='排序编号')
dasset_area = Column(String(50), nullable=True, default='', comment='资产范围')
clas = Column(String(500), nullable=True, default='', comment='标签')
usages = Column(String(500), nullable=True, default='', comment='用法')
data_sec_cifd = Column(String(50), nullable=True, default='', comment='数据安全分级')
status = Column(String(1), nullable=True, default=0, comment='部门状态(0正常 1停用)')
del_flag = Column(String(1), nullable=True, default=0, comment='删除标志(0代表存在 2代表删除)')
create_by = Column(String(64), nullable=True, default='', comment='创建者')
create_time = Column(DateTime, nullable=True, default=datetime.now(), comment='创建时间')
update_by = Column(String(64), nullable=True, default='', comment='更新者')
update_time = Column(DateTime, nullable=True, default=datetime.now(), comment='更新时间')