class Tbstatuslogjournalcommon(Base):
__tablename__ = 'tb_statuslogjournalcommon'
id = Column(BIGINT, primary_key=True, nullable=False)
SLF_ProductGUID = Column(CHAR(36), nullable=False)
SLF_IPAddressList = Column(VARCHAR(1024))
SLF_MACAddressList = Column(VARCHAR(256))
lutontmcm = Column(DATETIME)
class TbNtfUserGROUP(Base):
__tablename__ = 'tb_NtfUserGROUP'
GROUP_ID = Column(VARCHAR(64), primary_key=True, nullable=False)
Add_EMailAddress = Column(VARCHAR(1025))
Add_MobilePhoneNumber = Column(VARCHAR(257))
Add_PagerNumber = Column(VARCHAR(257))
UserNum = 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 TbInvestigateEntryPointSetting(Base):
__tablename__ = 'tb_InvestigateEntryPointSetting'
id = Column(INTEGER, primary_key=True, nullable=False)
IPAddress = Column(VARCHAR(256), nullable=False)
Protocol = Column(VARCHAR(16), nullable=False)
PortList = Column(VARCHAR(128), nullable=False)
Direction = Column(SMALLINT, nullable=False)
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 TbActiveUpdateComponent(Base):
__tablename__ = 'tb_ActiveUpdateComponent'
id = Column(INTEGER, primary_key=True, nullable=False)
StringID = Column(VARCHAR(128))
ComponentType = Column(INTEGER)
ComponentID = Column(INTEGER)
Category = Column(VARCHAR(32))
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 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 TbRelayNotificationTaskData(Base):
__tablename__ = 'tb_RelayNotificationTaskData'
NotificationDataKey = Column(UNIQUEIDENTIFIER,
primary_key=True,
nullable=False)
DataToken = Column(VARCHAR(32), nullable=False)
DataValue = 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 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 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 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 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 TbVASExceptionList(Base):
__tablename__ = 'tb_VASExceptionList'
VAS_ExceptionListID = Column(INTEGER, primary_key=True, nullable=False)
VAS_Properties = Column(INTEGER, nullable=False)
VAS_HostName = Column(NVARCHAR(64), nullable=False)
VAS_IPAddress1 = Column(VARCHAR(256), nullable=False)
VAS_IPAddress2 = Column(VARCHAR(256), nullable=False)
class TbPolicyTemplate(Base):
__tablename__ = 'tb_PolicyTemplate'
PT_ID = Column(VARCHAR(128), primary_key=True, nullable=False)
PT_SourceType = Column(INTEGER)
PT_SourceName = Column(VARCHAR(128))
PT_Filename = Column(VARCHAR(128))
PT_DisplayName = Column(NVARCHAR(128))
class TbVirtualTAMInterval(Base):
__tablename__ = 'tb_VirtualTAM_Interval'
VTI_ID = Column(CHAR(36), primary_key=True, nullable=False)
VTI_Frequency = Column(INTEGER, nullable=False)
VTI_FreqGrade = Column(INTEGER, nullable=False)
VTI_Enabled = Column(INTEGER)
VTI_ServerType = Column(VARCHAR(32))
VTI_Server = Column(VARCHAR(256), nullable=False)
class TbLoginUserSessionData(Base):
__tablename__ = 'tb_LoginUserSessionData'
id = Column(CHAR(36), primary_key=True, nullable=False)
LUSD_LoginToken = Column(VARCHAR(255), nullable=False)
LUSD_SessionTableName = Column(VARCHAR(255), nullable=False)
LUSD_Expired = Column(BIT, nullable=False)
LUSD_CreateTime = Column(DATETIME)
LUSD_UserID = Column(NVARCHAR(255))
class TbInventoryTagList(Base):
__tablename__ = 'tb_Inventory_TagList'
id = Column(INTEGER, primary_key=True, nullable=False)
TagID = Column(VARCHAR(16))
TagName = Column(NVARCHAR(256), nullable=False)
ResourceType = Column(VARCHAR(64), nullable=False)
Creator = Column(CHAR(36), nullable=False)
LastModifyTime = Column(DATETIME)
class TbsCloudPolicyWcuResourceMapping(Base):
__tablename__ = 'tb_sCloudPolicyWcuResourceMapping'
id = Column(BIGINT, primary_key=True, nullable=False)
ProductId = Column(VARCHAR(12), nullable=False)
PolicyId = Column(CHAR(36), nullable=False)
WcuName = Column(VARCHAR(50), nullable=False)
ResourceId = Column(VARCHAR(72), nullable=False)
CreateTime = Column(DATETIME, nullable=False)
class TbBifData(Base):
__tablename__ = 'tb_BifData'
Type = Column(VARCHAR(50), primary_key=True, nullable=False)
BIFKey = Column(VARCHAR(1024), primary_key=True, nullable=False)
BIFValue = Column(VARCHAR)
BIFRemark = Column(VARCHAR)
BIFAccountGuid = Column(CHAR(36))
LastUpdateTime = Column(DATETIME)
class TbUGNtfRelation(Base):
__tablename__ = 'tb_UGNtfRelation'
USER_ID = Column(VARCHAR(64), primary_key=True)
Event_ID = Column(VARCHAR(64))
ComponentID = Column(VARCHAR(64))
UG_ID = Column(VARCHAR(64))
TokenID = Column(VARCHAR(36))
Result = Column(INTEGER)
class TbProductSlot(Base):
__tablename__ = 'tb_ProductSlot'
id = Column(CHAR(36), primary_key=True, nullable=False)
ProductType = Column(INTEGER, nullable=False)
ProductVersion = Column(VARCHAR(19))
MenuVersion = Column(VARCHAR(8))
SlotID = Column(INTEGER, nullable=False)
CommandType = Column(INTEGER)
class L10NTMCM(Base):
__tablename__ = 'L10NTMCM'
id = Column(INTEGER, primary_key=True, nullable=False)
category = Column(INTEGER, nullable=False)
idmap = Column(INTEGER)
symbolic = Column(VARCHAR(128))
displayname = Column(NVARCHAR(2048))
lang = Column(VARCHAR(16))
class TbLogSuspiciousFile(Base):
__tablename__ = 'tb_LogSuspiciousFile'
id = Column(INTEGER, nullable=False)
MD5 = Column(VARCHAR(256), primary_key=True, nullable=False)
FileName = Column(NVARCHAR(512))
ContainerFolderName = Column(VARCHAR(256))
LastRequestTime = Column(DATETIME)
RetrievingStatus = Column(SMALLINT)
UploadingStatus = Column(SMALLINT)
class TempEntityResortInfo1(Base):
__tablename__ = 'temp_EntityResortInfo1'
id = Column(INTEGER, primary_key=True, nullable=False)
EntityGuid = Column(CHAR(36), nullable=False)
PolicyGuid = Column(CHAR(36))
PolicyLock = Column(SMALLINT)
Version = Column(VARCHAR(19))
BuildNumber = Column(VARCHAR(24))
IsSupport = Column(BIT)
class TbIPCountries(Base):
__tablename__ = 'tb_IPCountries'
id = Column(INTEGER, primary_key=True, nullable=False)
FromIP = Column(VARCHAR(15), nullable=False)
ToIP = Column(VARCHAR(15), nullable=False)
BeginNum = Column(BIGINT, nullable=False)
EndNum = Column(BIGINT, nullable=False)
CountryCode = Column(CHAR(2), nullable=False)
CountryName = Column(NVARCHAR(128), nullable=False)
class TbPolicySupportVersionInfo(Base):
__tablename__ = 'tb_PolicySupportVersionInfo'
ProductType = Column(INTEGER, primary_key=True, nullable=False)
NodeType = Column(INTEGER, primary_key=True, nullable=False)
Version = Column(VARCHAR(19))
BuildNumber = Column(VARCHAR(24))
IsLastVersion = Column(BIT, nullable=False)
EnablePolicyByPLS = Column(BIT)
IsDLPProduct = Column(BIT)
class TbSendPagerNotification(Base):
__tablename__ = 'tb_SendPagerNotification'
USER_ID = Column(VARCHAR(38), primary_key=True)
Event_ID = Column(VARCHAR(64), primary_key=True)
ComponentID = Column(VARCHAR(64))
EnableNotification = Column(BIT)
PagerMessage = Column(VARCHAR(1024))
SeledUGList = Column(VARCHAR(1024))
Result = Column(INTEGER)
class TbProcessInfo(Base):
__tablename__ = 'tb_ProcessInfo'
PI_Name = Column(VARCHAR(128), primary_key=True, nullable=False)
PI_State = Column(INTEGER, nullable=False)
PI_FileName = Column(VARCHAR(254), nullable=False)
PI_ListenPort = Column(INTEGER, nullable=False)
PI_HostName = Column(VARCHAR(254), nullable=False)
PI_IPList = Column(VARCHAR(1024))
PI_LastAccessTime = Column(DATETIME)
