Research Article

Remote Data Acquisition and Management Technology of Power Equipment Based on Internet of Things

Table 1

System network security log data.

Data nameThe data showsStorage typePrimary key

Journal_idSystem network node idint (8)Yes
Journal_time receivedSecurity log reception timedatetime (16)No
Journal_time sendedSecurity log sending timedatetime (16)No
Journal_messageLog contentVarchar (1000)No
Journal_district server idRepeater idFK, bigintNo
Journal_is parseredAnalysis situationsmallintNo
Journal_dest IPTarget IPnvarchar (40)No
Journal_attack IPAttack IPnvarchar (40)No
Journal_log typeSecurity log typenvarchar (40)No
Journal_Syslog parser idParser idFK, bigintNo