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)
