- <col> logid </col> <col> Bigint </col> <col> 8 </col>
- <col>
- Bigint (eight bit) 1-to-1 relationship with log
- </col>
- </row>
- <row>
- <col> source_ip </col> <col> Inet </col> <col> <para/> </col>
- <col>
- This is the IP-address (V4) of the host that sended the data.
- </col>
- </row>
- <row>
- <col> destination_ip </col> <col> Inet </col> <col> <para/> </col>
- <col>
- This is the IP-address (V4) of the host that was targetted.
- </col>
- </row>
- <row>
- <col> mac_address </col> <col> Macaddr </col> <col> <para/> </col>
- <col>
- This is the MAC-address logged
- </col>
- </row>
- <row>
- <col> packetlength </col> <col> Int </col> <col> <para/> </col>
- <col>
- The length of the packet
- </col>
- </row>
- <row>
- <col> protocol </col> <col> Text </col> <col> <para/> </col>
- <col>
- The protocol used for transmission(mostly TCP/UDP/ICMP).
- </col>
- </row>
- <row>
- <col> source_port </col> <col> Int </col> <col> <para/> </col>
- <col>
- The portnumber used at origin.
- </col>
- </row>
- <row>
- <col> destination_port </col> <col> Int </col> <col> <para/> </col>
- <col>
- The portnumber for the target
- </col>
- </row>
- <row>
- <col> messageid </col> <col> Text </col> <col> <para/> </col>
- <col>
- Messageid for e-mails
- </col>
- </row>
- <row>
- <col> system_username </col> <col> Text </col> <col> <para/> </col>
- <col>
- Username on the object
+ <col>log_advid</col><col>Bigint autonumber</col><col>8</col>
+ <col>Since some records can generate several log_adv records a unique identifyer is needed.
+ This record provides that.