Table sem5.dbo.SERIAL_NUMBERS
Internal temporary table

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
GROUP_ID char 32 GUID of a group
PROFILE_SERIAL_NO varchar 64 Profile serial number of the group
POLICY_LAST_MODIFIED bigint 8  √  null The time when the event is logged into system (GMT), which is server side time
IPS_SERIAL_NO varchar 64  √  null IPS serial number of the group

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
GROUP_ID Primary key Asc PK_SERIAL_NUMBERS
GROUP_ID Performance Asc I_SERIAL_NUMBERS_GROUPID