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.
67 lines
4.3 KiB
67 lines
4.3 KiB
|
|
from sqlalchemy import Column, String, Integer, Text, DateTime
|
|
from sqlalchemy.sql import func
|
|
from config.database import Base
|
|
|
|
class DataAssetInfoAppr(Base):
|
|
__tablename__ = 't_data_ast_info_appr'
|
|
|
|
onum = Column(String(255), primary_key=True, comment='数据资产序号')
|
|
data_ast_eng_name = Column(String(255), nullable=True, comment='数据资产英文名称')
|
|
data_ast_cn_name = Column(String(255), nullable=True, comment='数据资产中文名称')
|
|
data_ast_type = Column(String(50), nullable=True, comment='数据资产类型')
|
|
data_ast_stat = Column(String(50), nullable=True, comment='数据资产状态（1：有效 0：无效）')
|
|
data_ast_desc = Column(Text, nullable=True, comment='数据资产描述/说明')
|
|
data_ast_screen = Column(String(255), nullable=True, comment='资产应用场景')
|
|
data_ast_scren_clas = Column(String(255), nullable=True, comment='应用场景分类')
|
|
data_ast_cont = Column(Text, nullable=True, comment='数据资产内容')
|
|
data_ast_faq = Column(Text, nullable=True, comment='数据资产常见问题')
|
|
data_ast_estb_time = Column(DateTime, nullable=True, server_default=func.now(), comment='数据资产建立时间')
|
|
data_ast_upd_time = Column(DateTime, nullable=True, server_default=func.now(), onupdate=func.now(), comment='数据资产更新时间')
|
|
data_ast_src = Column(String(255), nullable=True, comment='数据资产来源')
|
|
ast_no = Column(Integer, nullable=True, comment='数据资产编号')
|
|
data_ast_clas = Column(String(255), nullable=True, comment='数据资产标签')
|
|
version_no = Column(String(50), nullable=True, comment='版本号')
|
|
changeType = Column(String(10), default=None, comment='变更类型')
|
|
flowId = Column(String(50), default=None, comment='审批Id')
|
|
oldInstId = Column(String(50), default=None, comment='原始正式id')
|
|
compareId = Column(String(50), default=None, comment='原始数据id（用于对比差异）')
|
|
approStatus = Column(String(10), default=None, comment='审批状态（waiting,申请中,pending审核中，succeed,rejected已审核，canceled已取消）')
|
|
create_by = Column(String(255), nullable=True, comment='创建人')
|
|
create_time = Column(DateTime, nullable=True, server_default=func.now(), comment='创建时间')
|
|
upd_prsn = Column(String(255), nullable=True, comment='更新人')
|
|
upd_time = Column(DateTime, nullable=True, server_default=func.now(), onupdate=func.now(), comment='更新时间')
|
|
|
|
|
|
# class MetadataSuppInfo(Base):
|
|
# __tablename__ = 't_metadata_supp_info'
|
|
|
|
# onum = Column(String(36), primary_key=True, comment='唯一编号')
|
|
# crrct_ver_num = Column(String(50), comment='补录版本号')
|
|
# ssys_cd = Column(String(50), comment='系统代码')
|
|
# mdl_name = Column(String(50), comment='模型名称')
|
|
# tab_eng_name = Column(String(250), comment='表英文名称')
|
|
# tab_crrct_name = Column(String(250), comment='表补录名称')
|
|
# tab_desc = Column(String(500), comment='表描述')
|
|
# pic = Column(String(64), comment='表图片')
|
|
# gov_flag = Column(String(1), comment='治理标志（0否 1是）')
|
|
# rec_stat = Column(String(1), comment='记录状态（0有效 1无效）')
|
|
# tab_clas = Column(Text, comment='表分类')
|
|
# rec_subm_prsn = Column(String(255), comment='记录提交人')
|
|
# upd_time = Column(DateTime, default=func.now(), onupdate=func.now(), comment='更新时间')
|
|
|
|
# class MetadataExtractInfo(Base):
|
|
# __tablename__ = 't_metadata_extract_info'
|
|
|
|
# onum = Column(Integer, primary_key=True, comment='唯一编号')
|
|
# extract_ver_num = Column(String(50), comment='采集版本号')
|
|
# ver_desc = Column(String(250), comment='版本描述')
|
|
# ssys_cd = Column(String(50), comment='系统代码')
|
|
# data_whs_name = Column(String(50), comment='数据仓库名称')
|
|
# mdl_name = Column(String(50), comment='模式名称')
|
|
# tab_no = Column(Integer, comment='表编号')
|
|
# tab_type = Column(String(50), comment='表类型')
|
|
# tab_eng_name = Column(String(250), comment='表英文名称')
|
|
# tab_cn_name = Column(String(250), comment='表中文名称')
|
|
# tab_rec_num = Column(Integer, comment='记录数')
|
|
# upd_time = Column(DateTime, default=func.now(), onupdate=func.now(), comment='更新时间')
|