Table sem5.dbo.SEM_CLIENT
Keeps clients information

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 GUID of the domain
GROUP_ID char 32  √  null GUID of the group
GROUP_IS_OU tinyint 1  √  null If client is from ActiveDirectory
OU_GUID char 32  √  null OU's GUID if the client is from ActiveDirectory
POLICY_MODE int 4  √  null Enum {USER_MODE, COMPUTER_MODE}
COMPUTER_ID char 32  √  null GUID of the register computer
HARDWARE_KEY char 32  √  null Hash of Computer Hardware information
COMPUTER_NAME nvarchar 128  √  null Computer name
COMPUTER_DOMAIN_NAME nvarchar 512  √  null Computer description
DESCRIPTION nvarchar 512  √  null Domain name of the computer
USER_NAME nvarchar 512  √  null User login name
FULL_NAME nvarchar 512  √  null User full name
USER_DOMAIN_NAME nvarchar 512  √  null User login domain name
HASH char 32 Hash of POLICY_MODE,COMPUTER_NAME,COMPUTER_DOMAIN_NAME,USER_NAME,USER_DOMAIN_NAME
PIN_MARK tinyint 1  √  null A flag to mark if this client should synchronized with ActiveDirectory
EXTRA_FEATURE int 4  √  null
CREATOR tinyint 1  √  null
CREATION_TIME bigint 8  √  null Create time of the client
USN bigint 8 Update serial number; used by replication
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
DELETED tinyint 1 The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
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_CLIENT
COMPUTER_NAME + COMPUTER_DOMAIN_NAME Performance Asc/Asc I_SEM_CLIENT_CNAME
COMPUTER_ID + GROUP_ID Performance Asc/Asc I_SEM_CLIENT_COMP
COMPUTER_ID + USER_NAME + DELETED Performance Asc/Asc/Asc I_SEM_CLIENT_COMPUTER_ID_PLUS
DOMAIN_ID Performance Asc I_SEM_CLIENT_DOM
EXTRA_FEATURE Performance Asc I_SEM_CLIENT_EXTRA_FEATURE
GROUP_ID Performance Asc I_SEM_CLIENT_GRP
HASH Performance Asc I_SEM_CLIENT_HASH
HARDWARE_KEY Performance Asc I_SEM_CLIENT_HWK
USER_NAME + USER_DOMAIN_NAME Performance Asc/Asc I_SEM_CLIENT_UNAME
USN Performance Asc I_SEM_CLIENT_USN