Table sem5.dbo.SEM_SVA_CLIENT 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
CLIENT_ID char 32
DOMAIN_ID char 32  √  null
GROUP_ID char 32  √  null
GROUP_IS_OU tinyint 1  √  null
OU_GUID char 32  √  null
COMPUTER_ID char 32  √  null
HARDWARE_KEY char 32  √  null
COMPUTER_NAME nvarchar 128  √  null
COMPUTER_DOMAIN_NAME nvarchar 512  √  null
DESCRIPTION nvarchar 512  √  null
HASH char 32
PIN_MARK tinyint 1  √  null
EXTRA_FEATURE int 4  √  null
USN bigint 8
DELETED tinyint 1
TIME_STAMP bigint 8
CREATION_TIME bigint 8  √  null
CREATOR tinyint 1  √  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
RESERVED_BINARY varbinary 2000  √  null

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
CLIENT_ID Primary key Asc PK_SEM_SVA_CLIENT