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.
 
 
 
 
 

108 lines
5.9 KiB

from datetime import datetime
from sqlalchemy import Column, DateTime, Integer, String, Text, DateTime, ForeignKey, Date, Double
from config.database import Base
from sqlalchemy.sql import func
# 定义数据资产目录表
class DataAstContent(Base):
__tablename__ = "t_data_ast_content"
content_onum = Column(Integer, primary_key=True, autoincrement=True, comment='目录序号')
content_name = Column(String(255), nullable=False, comment='目录名称')
content_stat = Column(String(10), nullable=False, comment='目录状态(有效/废弃/停用)')
content_intr = Column(Text, comment='目录简介')
content_pic = Column(String(255), comment='目录负责人')
supr_content_onum = Column(Integer, comment='上级目录序号')
leaf_node_flag = Column(Integer, default=1, comment='叶子节点标志')
upd_prsn = Column(String(255), nullable=False, comment='更新人员')
upd_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='更新时间')
class DataAstContentRela(Base):
__tablename__ = "t_data_ast_content_rela"
rela_onum = Column(Integer, primary_key=True, autoincrement=True, comment='关系序号')
content_onum = Column(Integer, nullable=False, comment='目录序号')
ast_onum = Column(Integer, nullable=False, comment='资产序号')
rela_type = Column(String(50), default='归属关系', comment='关系类型')
rela_eff_begn_date = Column(Date, nullable=True, comment='关系生效开始日期')
rela_eff_end_date = Column(Date, nullable=True, comment='关系生效结束日期')
upd_prsn = Column(String(255), nullable=False, comment='更新人员')
rela_status = Column(String(18), nullable=True, comment='关系状态')
# class DataAstInfo(Base):
# __tablename__ = "t_data_ast_info"
# data_ast_no = Column(Integer, primary_key=True, autoincrement=True, comment='数据资产编号')
# data_ast_eng_name = Column(String(255), nullable=False, 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='数据资产状态')
# data_ast_desc = Column(Text, nullable=True, comment='数据资产描述/说明')
# data_ast_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, default=datetime.now, comment='数据资产建立时间')
# data_ast_upd_time = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment='数据资产更新时间')
# data_ast_src = Column(String(255), nullable=True, comment='数据资产来源')
# ast_no = Column(Integer, nullable=True, comment='资产编号')
class DataAssetInfo(Base):
"""
数据资产信息表
"""
__tablename__ = 't_data_ast_info'
data_ast_no = Column(Integer, primary_key=True, autoincrement=True, comment='资产序号')
data_ast_eng_name = Column(String(255), nullable=False, 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='表状态(有效/废弃)')
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_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='资产编号')
class DataAstBookmarkRela(Base):
__tablename__ = "t_data_ast_bookmark_rela"
rela_onum = Column(Integer, primary_key=True, autoincrement=True, comment='唯一关系序号')
user_id = Column(String(20), nullable=False, comment='用户ID')
data_ast_no = Column(String(32), nullable=False, comment='数据资产编号')
bookmark_orde = Column(Integer, default=0, comment='收藏顺序')
bookmark_time = Column(DateTime, default=datetime.now, comment='收藏时间')
class UserDataAstRela(Base):
__tablename__ = "t_user_data_ast_rela"
rela_onum = Column(Integer, primary_key=True, autoincrement=True, comment='唯一关系序号')
data_ast_no = Column(String(32), nullable=False, comment='数据资产编号')
user_id = Column(String(20), nullable=False, comment='用户ID')
rela_type = Column(String(50), default='', comment='关系类型')
user_data_ast_clas = Column(Text, comment='用户数据资产分类标签')
user_data_ast_faq = Column(Text, comment='用户常见问题记录')
rela_eff_begn_date = Column(Date, nullable=False, comment='生效起始日期')
rela_eff_end_date = Column(Date, nullable=True, comment='生效终止日期')
class DataAstIndx(Base):
__tablename__ = "t_data_ast_indx"
ast_no = Column(String(32), primary_key=True, comment='资产编号')
indx_no = Column(String(32), primary_key=True, comment='指标编号')
indx_name = Column(String(100), nullable=False, comment='指标名称')
indx_val = Column(Double, default=0, comment='指标值')