DB

Tables (4)

Collect (monitor)

  • Idx (Key2) — INT — Primary key — NOT NULL
  • DstPort (Key) — INT — Foreign key → PortInfo.DstPort — NOT NULL
  • SrcIPv4 (Field9) — VARCHAR(15)
  • SrcMAC (Field) — VARCHAR(17)
  • SrcPort (Field2) — INT
  • DstIPv4 (Field3) — VARCHAR(15)
  • DstMAC (Field4) — VARCHAR(17)
  • TimeStamp (Field7) — TIMESTAMP
  • Protocol (Field6) — VARCHAR(10)
  • Size (Field8) — INT
  • Country (Field10) — VARCHAR(5)

IPv4Info (BadIPv4)

  • Addr (Key) — VARCHAR(15) — Primary key — NOT NULL
  • Reason (Field) — INT

MACInfo (BadMAC)

  • Addr (Key) — VARCHAR(17) — Primary key — NOT NULL
  • Reason (Field) — INT

PortInfo (CopyOfBadMAC)

  • DstPort (Key) — INT — Primary key — NOT NULL
  • Payload60_40 (Field) — INT
  • Payload40_20 (Field2) — INT
  • Payload20_00 (Field3) — INT
  • Request60_40 (Field4) — INT
  • Request40_20 (Field5) — INT
  • Request20_00 (Field6) — INT