Table sem5.dbo.GUP_LIST
Keeps the list for Group Update Provider (GUP)

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
GUP_ID char 32
COMPUTER_ID char 32 Referencing Computer_ID in SEM_COMPUTER table
IP_ADDRESS bigint 8 Represents the GUP IP address
PORT int 4 Represents the GUP port
USN bigint 8 A USN-based serial number; this ID is not unique.
TIME_STAMP bigint 8 The time when the event is logged into system (GMT), which is server side time
DELETED tinyint 1 Delete row; 0 = Not deleted, 1 = Deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
GUP_ID Primary key Asc PK_GUP_LIST
COMPUTER_ID Performance Asc I_GUP_LIST_COMPUTER
USN Performance Asc I_GUP_LIST_USN