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='更新时间')