class TbLogIntegrityMonitor(Base): __tablename__ = 'tb_LogIntegrityMonitor' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36), nullable=False) MsgLogType = Column(SMALLINT, nullable=False) CMGuid = Column(CHAR(36), nullable=False) ProductGUID = Column(CHAR(36), nullable=False) ProductID = Column(INTEGER, nullable=False) LogVersion = Column(SMALLINT, nullable=False) LogMinorVersion = Column(SMALLINT, nullable=False) LogReceivedUTCTime = Column(DATETIME, nullable=False) LogReceivedTime = Column(DATETIME, nullable=False) LogReceivedTimeZone = Column(INTEGER, nullable=False) LogGenUTCDatetime = Column(DATETIME, nullable=False) LogGenLocalDatetime = Column(DATETIME, nullable=False) TimeZoneInMins = Column(SMALLINT, nullable=False) DaylightSavingInMins = Column(SMALLINT, nullable=False) ComputerName = Column(NVARCHAR(128), nullable=False) ClientGUID = Column(CHAR(36)) EventID = Column(INTEGER) Status = Column(INTEGER) RuleID = Column(INTEGER) ChangeType = Column(INTEGER) UserName = Column(NVARCHAR(64)) ProcessName = Column(NVARCHAR(512)) Type = Column(VARCHAR(64)) KeyToEntityLocation = Column(NVARCHAR(2000)) Rank = Column(INTEGER) SeverityCode = Column(INTEGER) AssetValue = Column(INTEGER) ContentHashAfterChange = Column(VARCHAR(40)) ContentHashBeforeChange = Column(VARCHAR(40)) CLF_LogGenCMLocalTime = Column(DATETIME)
class TbReportSubscriptionTask(Base): __tablename__ = 'tb_ReportSubscriptionTask' RPT_SubscriptionID = Column(CHAR(36), primary_key=True, nullable=False) RPT_SubscriptionName = Column(NVARCHAR(256), nullable=False) RPT_TemplateVersion = Column(INTEGER, nullable=False) RPT_CreatedDate = Column(DATETIME) RPT_LastSubmittedDate = Column(DATETIME) RPT_NextSubmitDate = Column(DATETIME) RPT_EntityInfos = Column(IMAGE) RPT_OutputFormat = Column(INTEGER) RPT_Frequency = Column(INTEGER, nullable=False) RPT_FrequencyEveryX = Column(INTEGER, nullable=False) RPT_FrequencyOption = Column(INTEGER, nullable=False) RPT_IsUseCalendarDay = Column(SMALLINT) RPT_EnableAttachment = Column(SMALLINT, nullable=False) RPT_Recipients = Column(IMAGE) RPT_Issuer = Column(NVARCHAR(256), nullable=False) RPT_TaskStatus = Column(SMALLINT, nullable=False) RPT_Params = Column(IMAGE) RPT_Creator = Column(NVARCHAR(256), nullable=False) RPT_CasSendFlag = Column(INTEGER) RPT_CMServerID = Column(CHAR(36)) RPT_Description = Column(NVARCHAR(256)) RPT_LastSubmitTimeStamp = Column(DATETIME) RPT_NotificationSubject = Column(NVARCHAR(256)) RPT_NotificationBody = Column(NVARCHAR(2048)) RPT_OutputOrientation = Column(INTEGER)
class Tbstatuslogjournaladinfo(Base): __tablename__ = 'tb_statuslogjournaladinfo' id = Column(BIGINT, primary_key=True, nullable=False) SLF_ProductGUID = Column(CHAR(36), nullable=False) SLF_ADDomainName = Column(NVARCHAR(4000)) SLF_ADObjectGuid = Column(CHAR(36)) lutontmcm = Column(DATETIME)
class TbCasVirtualUserList(Base): __tablename__ = 'tb_CasVirtualUserList' id = Column(INTEGER, primary_key=True, nullable=False) CVUL_CMGuid = Column(CHAR(36)) CVUL_GUID = Column(CHAR(36)) CVUL_SAMAccountName = Column(NVARCHAR(32)) CVUL_Domain = Column(NVARCHAR(256))
class TbRCAMatchObjectJournal(Base): __tablename__ = 'tb_RCA_MatchObjectJournal' id = Column(BIGINT, primary_key=True, nullable=False) TaskID = Column(CHAR(36), nullable=False) AgentID = Column(CHAR(36), nullable=False) FileFullPath = Column(NVARCHAR(512)) FileCreationUTCTime = Column(DATETIME)
class TbPerformanceMetricLog(Base): __tablename__ = 'tb_PerformanceMetricLog' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36)) CLF_MsgLogType = Column(INTEGER) CLF_EntityID = Column(CHAR(36)) CLF_LogVersion = Column(INTEGER) CLF_LogMinorVersion = Column(VARCHAR(10)) CLF_ManagerID = Column(CHAR(36)) CLF_ComputerName = Column(NVARCHAR(128)) CLF_ProductType = Column(INTEGER) CLF_ProductVersion = Column(VARCHAR(21)) CLF_ProductPlatformCode = Column(INTEGER) CLF_ProductLanguageCode = Column(INTEGER) CLF_ServerityCode = Column(INTEGER) CLF_ComponentCode = Column(INTEGER) CLF_LogReplicatedFlag = Column(BIT) CLF_LogGenerationTime = Column(DATETIME) CLF_LogGenerationTimeZone = Column(VARCHAR(10)) CLF_LogReceivedTime = Column(DATETIME) CLF_LogReceivedTimeZone = Column(VARCHAR(10)) CLF_IsDayLightSaving = Column(INTEGER) CLF_ReasonCode = Column(VARCHAR(64)) CLF_ReasonCodeSource = Column(INTEGER) CLF_ReasonCodeSymbol = Column(VARCHAR(64)) CLF_ReasonCodeDescription = Column(NVARCHAR(1024)) CLF_RedAlertID = Column(VARCHAR(36)) PLF_SnapshotTime = Column(DATETIME) PLF_ServerName = Column(NVARCHAR(64)) PLF_MetricType = Column(INTEGER) PLF_MetricValue = Column(NVARCHAR(32))
class TbAVEventLog(Base): __tablename__ = 'tb_AVEventLog' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36)) CLF_MsgLogType = Column(INTEGER) CLF_LogMinorVersion = Column(VARCHAR(10)) CLF_EntityID = Column(CHAR(36)) CLF_ManagerID = Column(CHAR(36)) CLF_LogVersion = Column(INTEGER) CLF_ProductType = Column(INTEGER) CLF_ProductVersion = Column(VARCHAR(21)) CLF_ProductLanguageCode = Column(INTEGER) CLF_LogGenerationTime = Column(DATETIME) CLF_LogGenerationTimeZone = Column(VARCHAR(10)) CLF_LogReceivedTime = Column(DATETIME) CLF_LogReceivedTimeZone = Column(VARCHAR(10)) CLF_ServerityCode = Column(INTEGER) CLF_ComponentCode = Column(INTEGER) CLF_LogReplicatedFlag = Column(BIT) CLF_ComputerName = Column(NVARCHAR(128)) CLF_ProductPlatformCode = Column(INTEGER) CLF_IsDayLightSaving = Column(INTEGER) CLF_ReasonCode = Column(VARCHAR(64)) CLF_ReasonCodeSource = Column(INTEGER) ELF_EventType = Column(INTEGER) ELF_CommandStatusCode = Column(INTEGER, nullable=False) ELF_ErrorDescription = Column(NVARCHAR(1024)) ELF_TrackingID = Column(CHAR(36), nullable=False) ELF_Private_Detail = Column(IMAGE)
class TbRCATask(Base): __tablename__ = 'tb_RCA_Task' id = Column(BIGINT, primary_key=True, nullable=False) TaskID = Column(CHAR(36)) ScanSummaryID = Column(CHAR(36)) Criteria = Column(NVARCHAR(2048)) CriteriaType = Column(SMALLINT) AgentID = Column(CHAR(36), nullable=False) ServerID = Column(CHAR(36)) SLF_Key = Column(VARCHAR(256), nullable=False) Status = Column(SMALLINT) IsAffected = Column(BIT) IsSync = Column(BIT) CreationTime = Column(DATETIME) LastUpdateTime = Column(DATETIME) IsTimeout = Column(BIT) @classmethod def find_by_criteria_and_agent(cls, criteria, agent): agent_guid = TbEntityInfo.find_by_machine_name(agent).EI_EntityID return cm_session.query(cls).filter(and_(cls.Criteria == criteria, cls.AgentID == agent_guid)).first() @classmethod def find_by_criteria(cls, criteria): return cm_session.query(cls).filter(cls.Criteria == criteria).all()
class TbTotalSecurityCount(Base): __tablename__ = 'tb_TotalSecurityCount' CLF_EntityID = Column(CHAR(36), primary_key=True, nullable=False) CLF_CMServerID = Column(CHAR(36)) CLF_ProductType = Column(INTEGER, nullable=False) VLF_CleanFail = Column(INTEGER) VLF_DeleteFail = Column(INTEGER) VLF_MoveFail = Column(INTEGER) VLF_RenameFail = Column(INTEGER) VLF_BypassFail = Column(INTEGER) VLF_AttachStripFail = Column(INTEGER) VLF_TotalFail = Column(INTEGER) SL_Deliver = Column(INTEGER) VLF_DeleteSuccess = Column(INTEGER) SL_Forward = Column(INTEGER) SL_Quarantine = Column(INTEGER) SL_Postpone = Column(INTEGER) VLF_AttachStripSuccess = Column(INTEGER) VLF_TotalSuccess = Column(INTEGER) TVC_TotalClean = Column(INTEGER) TVC_TotalDelete = Column(INTEGER) TVC_TotalMove = Column(INTEGER) TVC_TotalRename = Column(INTEGER) TVC_TotalBypass = Column(INTEGER) TVC_TotalAttachStrip = Column(INTEGER) TVC_Total = Column(INTEGER) TVC_SummaryTime = Column(DATETIME) TVC_YEAR = Column(INTEGER) TVC_MONTH = Column(INTEGER) TVC_DAY = Column(INTEGER) CasStatus = Column(INTEGER)
class TbADEDetectionLog(Base): __tablename__ = 'tb_ADE_Detection_Log' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36), nullable=False) CLF_LogReceivedTime = Column(DATETIME, nullable=False) SLF_MsgType = Column(INTEGER, nullable=False) SLF_LogVersion = Column(INTEGER, nullable=False) SLF_LogMinorVersion = Column(INTEGER, nullable=False) SLF_ProductGUID = Column(CHAR(36), nullable=False) SLF_ProductID = Column(INTEGER, nullable=False) SLF_ComputerName = Column(NVARCHAR(128)) SLF_ProductVersion = Column(VARCHAR(21), nullable=False) SLF_LogGenerationTime = Column(DATETIME, nullable=False) SLF_LogGenerationTimeZone = Column(INTEGER, nullable=False) SLF_IsDayLightSaving = Column(BIT, nullable=False) SLF_ClientGUID = Column(CHAR(36)) SLF_HostName = Column(NVARCHAR(128)) SLF_ClientIP = Column(VARCHAR(256)) SLF_UserName = Column(NVARCHAR(128)) SLF_InstanceID = Column(CHAR(36)) SLF_RiskLevel = Column(INTEGER, nullable=False) SLF_LogLevel = Column(INTEGER, nullable=False) SLF_IsHidden = Column(BIT, nullable=False) SLF_PatternNumber = Column(VARCHAR(128)) SLF_RuleID = Column(NVARCHAR(128), nullable=False) SLF_CategoryID = Column(NVARCHAR(128), nullable=False) SLF_HasDetailTrace = Column(INTEGER)
class TbSystemInfo(Base): __tablename__ = 'tb_SystemInfo' SYS_SystemID = Column(CHAR(36), primary_key=True, nullable=False) SYS_SystemID_Guid = Column(UNIQUEIDENTIFIER) SYS_Registered = Column(BIT, nullable=False) SYS_SetupTime = Column(DATETIME) SYS_StartupTime = Column(DATETIME) SYS_ProductVersion = Column(VARCHAR(19), nullable=False) SYS_VirusPatternVersion = Column(VARCHAR(19)) SYS_VirusPtnLastUpdateTime = Column(DATETIME) SYS_SpamRuleVersion = Column(VARCHAR(19)) SYS_SpamRuleLastUpdateTime = Column(DATETIME) SYS_MMPVersion = Column(VARCHAR(19)) SYS_MMPVersionLastUpdateTime = Column(DATETIME) SYS_DCTVersion = Column(VARCHAR(19)) SYS_DCTVersionLastUpdateTime = Column(DATETIME) SYS_PATTERN2 = Column(VARCHAR(19)) SYS_PATTERN2LastUpdateTime = Column(DATETIME) SYS_CAVRule = Column(VARCHAR(19)) SYS_CAVRuleLastUpdateTime = Column(DATETIME) SYS_VATVersion = Column(VARCHAR(19)) SYS_VATVersionLastUpdateTime = Column(DATETIME) SYS_VIVersion = Column(VARCHAR(19)) SYS_VIVersionLastUpdateTime = Column(DATETIME) SYS_SpywareVersion = Column(VARCHAR(19)) SYS_SpywareLastUpdateTime = Column(DATETIME) SYS_CFWVersion = Column(VARCHAR(19)) SYS_CFWLastUpdateTime = Column(DATETIME) SYS_SpyCleanUpVersion = Column(VARCHAR(19)) SYS_SpyCleanUpLastUpdateTime = Column(DATETIME) SYS_ASpyVersion = Column(VARCHAR(19)) SYS_ASpyLastUpdateTime = Column(DATETIME) ET_VSAPI32_95 = Column(VARCHAR(19)) ET_VSAPI32_VXD = Column(VARCHAR(19)) ET_VSAPI32_NT_I386 = Column(VARCHAR(19)) ET_VSAPI32_NT_ALPHA = Column(VARCHAR(19)) ET_VSAPI32_NT_KD = Column(VARCHAR(19)) ET_VSAPI32_NLM = Column(VARCHAR(19)) ET_VSAPI32_OS2 = Column(VARCHAR(19)) ET_VSAPI32_DOS4G = Column(VARCHAR(19)) ET_VSAPI32_SOLARIS = Column(VARCHAR(19)) ET_VSAPI32_SOLARIS_X86 = Column(VARCHAR(19)) ET_VSAPI32_HPUX = Column(VARCHAR(19)) ET_VSAPI32_AIX = Column(VARCHAR(19)) ET_VSAPI32_SOLARIS_SPARC = Column(VARCHAR(19)) ET_VSAPI32_LINUX_X86 = Column(VARCHAR(19)) ET_PREVSAPI32_95 = Column(VARCHAR(19)) ET_PREVSAPI32_NT = Column(VARCHAR(19)) ET_PREVSAPI16 = Column(VARCHAR(19)) ET_VSAPI_ALL = Column(VARCHAR(19)) SYS_ProductBuild = Column(VARCHAR(19)) SYS_HotfixNumber = Column(VARCHAR(19)) SYS_SOExceptionChangeKey = Column(BIGINT) GlobalRetroScanUserID = Column(VARCHAR(64)) GlobalRetroScanUserKey = Column(VARCHAR(256)) MDR_SenderGUID = Column(CHAR(36)) @classmethod def get_CM_guid(cls): return cm_session.query(cls).first().SYS_SystemID
class TbNetworkContentInspectionEngineLog(Base): __tablename__ = 'tb_Network_Content_Inspection_Engine_Log' CMGuid = Column(CHAR(36)) id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36), nullable=False) SLF_MsgType = Column(INTEGER) SLF_ProductGUID = Column(CHAR(36), nullable=False) SLF_ClientGUID = Column(CHAR(36)) SLF_ProductID = Column(INTEGER) SLF_LogVersion = Column(INTEGER) SLF_LogMinorVersion = Column(INTEGER) SLF_LogGenUTCDatetime = Column(DATETIME) SLF_LogGenLocalDatetime = Column(DATETIME) SLF_TimeZoneInMins = Column(INTEGER) SLF_DaylightSavingInMins = Column(INTEGER) LogReceivedTime = Column(DATETIME) LogReceivedUTCTime = Column(DATETIME) LogReceivedTimeZone = Column(VARCHAR(10)) SLF_ComputerName = Column(NVARCHAR(128)) SLF_ProcessName = Column(NVARCHAR(256)) SLF_SourceIP = Column(VARCHAR(256)) SLF_SourcePort = Column(INTEGER) SLF_DestinationIP = Column(VARCHAR(256)) SLF_DestinationPort = Column(INTEGER) SLF_Action = Column(INTEGER) SLF_Direction = Column(INTEGER) SLF_PatternType = Column(INTEGER) SLF_Is_CCCA_Detection = Column(INTEGER) SLF_CCCA_DetectionSource = Column(INTEGER) SLF_CCCA_RiskLevel = Column(INTEGER) NCIE_ThreatName = Column(NVARCHAR(64)) CE_FilterID = Column(VARCHAR(35)) SLF_DestinationDomain = Column(NVARCHAR(256)) CLF_LogGenCMLocalTime = Column(DATETIME)
class TbSpywareLog(Base): __tablename__ = 'tb_SpywareLog' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36), nullable=False) MsgLogType = Column(INTEGER) ProductGUID = Column(CHAR(36)) CMGuid = Column(CHAR(36)) ClientGUID = Column(CHAR(36)) ProductID = Column(INTEGER) LogVersion = Column(INTEGER) LogMinorVersion = Column(INTEGER) ComputerName = Column(NVARCHAR(128)) LogGenUTCDatetime = Column(DATETIME) LogGenLocalDatetime = Column(DATETIME) TimeZoneInMins = Column(INTEGER) DaylightSavingInMins = Column(INTEGER) RedAlertID = Column(CHAR(36)) LoginUser = Column(NVARCHAR(64)) VirusName = Column(NVARCHAR(128)) ScanType = Column(INTEGER) EngineType = Column(INTEGER) EngineVersion = Column(NVARCHAR(32)) PatternType = Column(INTEGER) PatternVersion = Column(NVARCHAR(32)) Description = Column(NVARCHAR(1024)) LogCount = Column(INTEGER) LogReceivedTime = Column(DATETIME) LogReceivedUTCTime = Column(DATETIME) AggregatedUTCDatetime = Column(DATETIME) AggregatedLocalDatetime = Column(DATETIME) AggregatedCount = Column(INTEGER) ActionResult = Column(INTEGER) CE_FilterID = Column(VARCHAR(35)) CLF_LogGenCMLocalTime = Column(DATETIME)
class TbSecurityViolations(Base): __tablename__ = 'tb_SecurityViolations' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36)) CLF_MsgLogType = Column(INTEGER) CLF_EntityID = Column(CHAR(36)) CLF_ProductType = Column(INTEGER) CLF_LogVersion = Column(INTEGER) CLF_LogMinorVersion = Column(VARCHAR(10)) CLF_ManagerID = Column(CHAR(36)) CLF_ComputerName = Column(NVARCHAR(128)) CLF_ProductVersion = Column(VARCHAR(32)) CLF_ProductPlatformCode = Column(INTEGER) CLF_ProductLanguageCode = Column(INTEGER) CLF_ServerityCode = Column(INTEGER) CLF_ComponentCode = Column(INTEGER) CLF_LogGenerationTime = Column(DATETIME) CLF_LogGenerationTimeZone = Column(VARCHAR(10)) CLF_LogReceivedTime = Column(DATETIME) CLF_LogReceivedTimeZone = Column(VARCHAR(10)) CLF_IsDayLightSaving = Column(INTEGER) CLF_ReasonCode = Column(VARCHAR(64)) CLF_ReasonCodeSource = Column(INTEGER) CLF_ReasonCodeDescription = Column(NVARCHAR(1024)) ESV_IP = Column(VARCHAR(256)) ESV_MAC = Column(VARCHAR(17)) ESV_HostName = Column(NVARCHAR(64)) ESV_Policy = Column(NVARCHAR(64)) ESV_UserName = Column(NVARCHAR(64)) ESV_Services = Column(NVARCHAR(512)) ESV_Services_ID = Column(INTEGER) ESV_ViolationTime = Column(DATETIME) ESV_EnforcementAction = Column(NVARCHAR(64)) ESV_RemediationAction = Column(NVARCHAR(64)) ESV_Detail = Column(NVARCHAR(256))
class TbADVirtualUser(Base): __tablename__ = 'tb_AD_VirtualUser' GUID = Column(CHAR(36), primary_key=True, nullable=False) SAMAccountName = Column(NVARCHAR(64), nullable=False) Domain = Column(NVARCHAR(256), nullable=False) UnReferTimestamp = Column(DATETIME) CMGuid = Column(CHAR(36))
class TbLogThreatMitigation(Base): __tablename__ = 'tb_LogThreatMitigation' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36), nullable=False) MsgLogType = Column(INTEGER) LogVersion = Column(SMALLINT) LogMinorVersion = Column(SMALLINT) SLF_ProductGUID = Column(CHAR(36)) SLF_ProductID = Column(INTEGER) LogGenerationTime = Column(DATETIME) LogGenerationTimeZone = Column(VARCHAR(10)) LogGenUTCDatetime = Column(DATETIME) LogReceivedTime = Column(DATETIME) LogReceivedUTCTime = Column(DATETIME) LogReceivedTimeZone = Column(VARCHAR(10)) ComputerName = Column(NVARCHAR(128)) DaylightSavingInMins = Column(INTEGER) CollaborationID = Column(NVARCHAR(128)) EndpointIP = Column(NVARCHAR(256)) Endpoint = Column(NVARCHAR(254)) DataSource = Column(INTEGER) DataSourceHost = Column(NVARCHAR(254)) ThreatDescription = Column(NVARCHAR(254)) MitigationStatus = Column(INTEGER) MitigationDetails = Column(INTEGER)
class TbRelayEventNTFJobList(Base): __tablename__ = 'tb_Relay_Event_NTF_JobList' JOBID = Column(CHAR(36), primary_key=True, nullable=False) USER_ID = Column(VARCHAR(38)) Entity_ID = Column(VARCHAR(38)) Event_ID = Column(VARCHAR(64)) ComponentID = Column(VARCHAR(64)) CLF_ProductType = Column(INTEGER, nullable=False) CLF_ProductName = Column(VARCHAR(128)) CLF_ProductVersion = Column(VARCHAR(21)) CLF_LogGenerationTime = Column(DATETIME) CLF_LogGenerationTimeZone = Column(INTEGER) CLF_ComputerName = Column(NVARCHAR(128)) ELF_TrackingID = Column(CHAR(36)) ELF_OriginalMesssage = Column(VARCHAR(128)) ELF_StatusResult = Column(INTEGER) NJL_TaskState = Column(INTEGER) NJL_RetryTime = Column(INTEGER) NJL_FailMethod = Column(INTEGER) Result = Column(INTEGER) ProductInternalMessage = Column(VARCHAR(512)) ANJ_RedAlertID = Column(CHAR(36)) VOA_YEAR = Column(INTEGER, nullable=False) VOA_MONTH = Column(INTEGER, nullable=False) VOA_DAY = Column(INTEGER, nullable=False) CLF_IsDayLightSaving = Column(INTEGER)
class Teacher(db.Model, UserMixin): __tablename__ = 'Teacher' id = db.Column(CHAR(16), primary_key=True) pwd = db.Column(CHAR(128), nullable=False) tName = db.Column(NVARCHAR(32), nullable=False) Dept = db.Column(NVARCHAR(64), nullable=False) # 系别 Position = db.Column(NVARCHAR(8), nullable=False) # 职位: 教授 副教授 助理教授 讲师 辅导员 permission = Permission.USER def __init__(self, id, pwd, tName, dept, position): self.id = id self.tName = tName self.pwd = pwd self.dept = dept self.position = position # self.right = right def can(self, permission): return (self.permission & permission) == permission def get_id(self): return self.id def verify_password(self, pwd): # pwd_hash=generate_password_hash(pwd) if check_password_hash(self.pwd.strip(), pwd.strip()): return True else: return False def __repr__(self): return '<Teacher %r>' % self.tName
class TbFileHashDetectionLog(Base): __tablename__ = 'tb_FileHashDetectionLog' id = Column(BIGINT, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36), nullable=False) CMGuid = Column(CHAR(36)) SLF_LogType = Column(INTEGER, nullable=False) SLF_ProductGUID = Column(CHAR(36), nullable=False) SLF_ProductID = Column(INTEGER, nullable=False) SLF_LogVersion = Column(INTEGER, nullable=False) SLF_LogMinorVersion = Column(INTEGER, nullable=False) SLF_ComputerName = Column(NVARCHAR(128), nullable=False) SLF_ProductVersion = Column(VARCHAR(21), nullable=False) SLF_LogGenerationTime = Column(DATETIME, nullable=False) SLF_LogGenerationTimeZone = Column(INTEGER, nullable=False) SLF_IsDayLightSaving = Column(SMALLINT, nullable=False) SLF_Sender = Column(NVARCHAR(254)) SLF_Recipient = Column(NVARCHAR) SLF_Subject = Column(NVARCHAR(254)) SLF_EntryChannel = Column(INTEGER) SLF_ClientGUID = Column(CHAR(36)) SLF_ClientIP = Column(VARCHAR(256)) SLF_HostName = Column(VARCHAR(128)) SLF_TrueFileType = Column(VARCHAR(64)) SLF_FileSHA1 = Column(VARCHAR(64), nullable=False) SLF_FileSource = Column(NVARCHAR(1024)) SLF_SourceType = Column(SMALLINT, nullable=False) SLF_Action = Column(SMALLINT, nullable=False) SLF_ActionResult = Column(SMALLINT) SLF_ScanType = Column(SMALLINT, nullable=False) SLF_LogReceivedUTCTime = Column(DATETIME, nullable=False) SLF_FileCreatedUTCTime = Column(DATETIME, nullable=False) SLF_FileModifiedUTCTime = Column(DATETIME, nullable=False) CE_FilterID = Column(VARCHAR(35)) CLF_LogGenCMLocalTime = Column(DATETIME)
class Adminitrator(db.Model, UserMixin): __tablename__ = 'Adminitrator' # 简单起见 管理员都是全权限 id = db.Column(CHAR(16), primary_key=True) pwd = db.Column(CHAR(128), nullable=False) aName = db.Column(NVARCHAR(32), nullable=False) permission = Permission.ADMIN def __init__(self, id, pwd, aName): self.id = id self.aName = aName self.pwd = pwd # self.right = right def get_id(self): return self.id def can(self, permission): return (self.permission & permission) == permission def verify_password(self, pwd): # pwd_hash=generate_password_hash(pwd) if check_password_hash(self.pwd.strip(), pwd.strip()): return True else: return False def __repr__(self): return '<Adminitrator %r>' % self.aName
class TbDeploymentPlansTF(Base): __tablename__ = 'tb_DeploymentPlansTF' DPTF_PlanID = Column(CHAR(36)) DPTF_ScheduleID = Column(CHAR(36), primary_key=True, nullable=False) DPTF_Hour = Column(INTEGER) DPTF_Min = Column(INTEGER) DPTF_Folders = Column(NVARCHAR(450))
class Tbstatuslogjournalclienttree(Base): __tablename__ = 'tb_statuslogjournalclienttree' id = Column(BIGINT, primary_key=True, nullable=False) SLF_ProductGUID = Column(CHAR(36), nullable=False) SLF_ClientTreePath = Column(NVARCHAR(1000)) SLF_RealParentGuid = Column(CHAR(36)) lutontmcm = Column(DATETIME)
class TbSecurityStatistics(Base): __tablename__ = 'tb_SecurityStatistics' id = Column(INTEGER, primary_key=True, nullable=False) MsgLogID = Column(CHAR(36)) CLF_MsgLogType = Column(INTEGER) CLF_EntityID = Column(CHAR(36)) CLF_ProductType = Column(INTEGER) CLF_LogVersion = Column(INTEGER) CLF_LogMinorVersion = Column(VARCHAR(10)) CLF_ManagerID = Column(CHAR(36)) CLF_ComputerName = Column(NVARCHAR(128)) CLF_ProductVersion = Column(VARCHAR(32)) CLF_ProductPlatformCode = Column(INTEGER) CLF_ProductLanguageCode = Column(INTEGER) CLF_ServerityCode = Column(INTEGER) CLF_ComponentCode = Column(INTEGER) CLF_LogGenerationTime = Column(DATETIME) CLF_LogGenerationTimeZone = Column(VARCHAR(10)) CLF_LogReceivedTime = Column(DATETIME) CLF_LogReceivedTimeZone = Column(VARCHAR(10)) CLF_IsDayLightSaving = Column(INTEGER) CLF_ReasonCode = Column(VARCHAR(64)) CLF_ReasonCodeSource = Column(INTEGER) CLF_ReasonCodeDescription = Column(NVARCHAR(1024)) SVS_Name = Column(NVARCHAR(64)) SVS_ID = Column(INTEGER) SVS_Violation_Count = Column(INTEGER)
class TbReportTracking(Base): __tablename__ = 'tb_ReportTracking' RPT_ID = Column(CHAR(36), primary_key=True) RPT_CMServerID = Column(CHAR(36)) RPT_TemplateID = Column(INTEGER) RPT_SubmitDateTime = Column(DATETIME) RPT_LatestUpdateDateTime = Column(DATETIME) RPT_Name = Column(NVARCHAR(512)) RPT_IssueUser = Column(NVARCHAR(512)) RPT_MailList = Column(IMAGE) RPT_Format = Column(INTEGER) RPT_IsSchedule = Column(INTEGER) RPT_IsNeedAttacheInMail = Column(INTEGER) RPT_DateFrom = Column(DATETIME) RPT_DateTo = Column(DATETIME) RPT_Title = Column(NVARCHAR(256)) RPT_Description = Column(NVARCHAR(256)) RPT_NodeInfo = Column(IMAGE(256)) RPT_CasSendFlag = Column(INTEGER) RPT_IsAggReport = Column(INTEGER) RPT_LatestModifyTime = Column(DATETIME) RPT_LatestModifyUser = Column(NVARCHAR(64)) RPT_NewTemplatesName = Column(IMAGE) RPT_IP_SettingType = Column(INTEGER) RPT_IP_FIELD_1 = Column(VARCHAR(256)) RPT_IP_FIELD_2 = Column(VARCHAR(256))
class TbApplicationControlAudit(Base): __tablename__ = 'tb_ApplicationControlAudit' id = Column(INTEGER, primary_key=True, nullable=False) SLF_MsgType = Column(INTEGER) SLF_ProductID = Column(SMALLINT) SLF_LogVersion = Column(SMALLINT) SLF_LogMinorVersion = Column(SMALLINT) SLF_LogGenUTCDatetime = Column(DATETIME) SLF_LogGenLocalDatetime = Column(DATETIME) SLF_TimeZoneInMins = Column(SMALLINT) SLF_DaylightSavingInMins = Column(SMALLINT) SLF_ClientGUID = Column(CHAR(36)) SLF_ClientUserGUID = Column(CHAR(36)) SLF_ClientUserName = Column(NVARCHAR(128)) SLF_ClientUserDomain = Column(NVARCHAR(256)) SLF_ClientUserDepartment = Column(NVARCHAR(256)) SLF_ClientMachineArchitecture = Column(VARCHAR(64)) SLF_ApplicationFileHash = Column(VARCHAR(40)) SLF_ApplicationFileName = Column(NVARCHAR(256)) SLF_ApplicationFileOwner = Column(NVARCHAR(256)) SLF_ApplicationPath = Column(NVARCHAR(512)) SLF_ApplicationDriveType = Column(SMALLINT) SLF_ApplicationFileCreatedUTCDatetime = Column(DATETIME) SLF_ApplicationFileModifiedUTCDatetime = Column(DATETIME) SLF_ApplicationFileDeletedUTCDatetime = Column(DATETIME)
class TbADStaffTmp(Base): __tablename__ = 'tb_AD_StaffTmp' GUID = Column(CHAR(36), primary_key=True, nullable=False) SAMAccountName = Column(NVARCHAR(32), nullable=False) Domain = Column(NVARCHAR(256), nullable=False) Type = Column(INTEGER, nullable=False) ManagerGUID = Column(CHAR(36))
class Tbstatuslogjournal(Base): __tablename__ = 'tb_statuslogjournal' id = Column(BIGINT, primary_key=True, nullable=False) SLF_ProductGUID = Column(CHAR(36), nullable=False) SLF_ProductID = Column(INTEGER) SLF_ComputerName = Column(NVARCHAR(64)) SLF_LogGenUTCDatetime = Column(DATETIME) SLF_LogGenLocalDatetime = Column(DATETIME) SLF_TimeZoneInMins = Column(INTEGER) SLF_DaylightSavingInMins = Column(INTEGER) SLF_Status = Column(INTEGER) SLF_UpdateAgentType = Column(INTEGER) SLF_LastStartupTime = Column(DATETIME) lutontmcm = Column(DATETIME) EI_DomainName = Column(NVARCHAR(64)) EI_OS_Name = Column(NVARCHAR(128)) EI_OS_Version = Column(VARCHAR(64)) EI_OS_SPVersion = Column(VARCHAR(32)) EI_OS_Language = Column(INTEGER) EI_OS_ContryCode = Column(VARCHAR(8)) EI_UserGuid = Column(CHAR(36)) EI_UserAccount = Column(NVARCHAR(32)) EI_UserDomain = Column(NVARCHAR(256)) EI_SystemModel = Column(SMALLINT) EI_ParentGuid = Column(CHAR(36)) EI_UserMail = Column(NVARCHAR(450)) EI_NetworkQuarantineSetting = Column(SMALLINT) EI_NetworkQuarantineSettingResult = Column(SMALLINT) EI_IsOffPremise = Column(SMALLINT) SLF_LastCompliantState = Column(BIGINT) SLF_LastLogonTime = Column(DATETIME) SLF_LastLogoffTime = Column(DATETIME) EI_IsCoExist = Column(SMALLINT)
class TbRedAlertVirusTracking(Base): __tablename__ = 'tb_RedAlertVirusTracking' RAVT_ID = Column(CHAR(36), primary_key=True, nullable=False) RAVT_RedAlertID = Column(CHAR(36), nullable=False) RAVT_ProductType = Column(INTEGER) RAVT_VirusCount = Column(INTEGER) RAVT_CreateTime = Column(DATETIME)
class TbScheduleDownload(Base): __tablename__ = 'tb_ScheduleDownload' id = Column(CHAR(36), primary_key=True, nullable=False) SD_ComponentID = Column(INTEGER) SD_Enable = Column(BIT) SD_Frequency = Column(INTEGER) SD_TargetTime = Column(DATETIME) SD_FrequencyNRange = Column(INTEGER) SD_FrequencyWeekday = Column(INTEGER) SD_AutoDeployOption = Column(INTEGER) SD_DeploymentPlanID = Column(VARCHAR(50)) SD_UpdateSource = Column(VARCHAR(2048)) SD_EnableRetry = Column(BIT) SD_RetryTimes = Column(INTEGER) SD_ReDoNeeded = Column(INTEGER) SD_RetryPeriod = Column(INTEGER) SD_UpdateSourceType = Column(INTEGER) SD_TaskType = Column(INTEGER) SD_DetailedSettings = Column(VARCHAR(1024)) SD_RedAlertID = Column(CHAR(36)) SD_MMPIDs = Column(INTEGER) SD_IsIndividual = Column(INTEGER) SD_PatternMask = Column(VARCHAR(1024)) SD_SpamRuleMask = Column(VARCHAR(1024)) SD_EngineMask = Column(VARCHAR(1024)) SD_Language = Column(INTEGER) SD_Platform = Column(INTEGER) SD_ProductID = Column(INTEGER)
class TbSecurityViolationsPolicySummary(Base): __tablename__ = 'tb_SecurityViolations_Policy_Summary' MsgLogID = Column(CHAR(36), primary_key=True) CLF_EntityID = Column(CHAR(36), nullable=False) CLF_LogReceivedTime = Column(DATETIME, nullable=False) ESV_IP = Column(VARCHAR(256), nullable=False) ESV_Policy = Column(NVARCHAR(64), nullable=False)