Table sem5.dbo.V_ENFORCER_TRAFFIC_LOG
Query traffic activities for Enforcers

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
USN bigint 8
DOMAIN_ID char 32
SITE_ID char 32
TIME_STAMP bigint 8
EVENT_ID int 4  √  null
EVENT_TIME bigint 8
ENFORCER_ID char 32
ENFORCER_TYPE tinyint 1
CLIENT_ID char 32  √  null
LOCAL_HOST_IP bigint 8
REMOTE_HOST_IP bigint 8
NETWORK_PROTOCOL tinyint 1
LOCAL_PORT int 4
REMOTE_PORT int 4
TRAFFIC_DIRECTION tinyint 1
BEGIN_TIME bigint 8  √  null
END_TIME bigint 8  √  null
BLOCKED tinyint 1
TOTAL_BYTES int 4
REPETITION int 4  √  null
ALERT tinyint 1
RESERVED_INT1 int 4  √  null
RESERVED_INT2 int 4  √  null
RESERVED_BIGINT1 bigint 8  √  null
RESERVED_BIGINT2 bigint 8  √  null
RESERVED_CHAR1 char 32  √  null
RESERVED_CHAR2 char 32  √  null
RESERVED_VARCHAR1 nvarchar 520  √  null
RESERVED_BINARY varbinary 2000  √  null
LOG_IDX char 32  √  null
LOCAL_HOST_IP_TEXT varchar 123  √  null
REMOTE_HOST_IP_TEXT varchar 123  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012