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