Table sem5.dbo.SEM_SVA 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
SVA_ID char 32
AGENT_TYPE varchar 64  √  null
R_OS_TYPE int 4  √  null
COMPUTER_ID char 32  √  null
DOMAIN_ID char 32  √  null
GROUP_ID char 32  √  null
SVA_VERSION nvarchar 128  √  null
STATUS tinyint 1  √  null
MAJOR_VERSION int 4 ((0))
MINOR_VERSION int 4 ((0))
LAST_SERVER_ID char 32  √  null
LAST_SITE_ID char 32  √  null
CURRENT_CLIENT_ID char 32  √  null
TIMEZONE int 4 ((0))
SERVICES varchar 32  √  null
LAST_REBOOT_TIME bigint 8  √  null
HEARTBEAT int 4  √  null
CLIENT_COUNT int 4 ((0))
VSIC_CACHE_SIZE int 4 ((0))
VSIC_REQUESTS_NUM int 4 ((0))
VSIC_SUBMITS_NUM int 4 ((0))
VSIC_VERSION nvarchar 128  √  null
USN bigint 8
DELETED tinyint 1
TIME_STAMP bigint 8
CREATION_TIME bigint 8  √  null
LAST_UPDATE_TIME bigint 8  √  null
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

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
SVA_ID Primary key Asc PK_SEM_SVA_AGENT