Table sem5.dbo.SEM_CONTENT
Keeps the client to content mapping

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
AGENT_ID char 32 GUID of the agent
PATTERN_IDX char 32 Pointer to pattern table
USN bigint 8 ((1)) Update serial number; used by replication
TIME_STAMP bigint 8 ((0)) Time that the record was modified; used to resolve merge conflict
DELETED tinyint 1 ((0)) The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
CLIENT_MONIKER varchar 40 ('')
SEQUENCE int 4 ((0))

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
AGENT_ID + CLIENT_MONIKER Primary key Asc/Asc PK_SEM_CONTENT
PATTERN_IDX + DELETED Performance Asc/Asc I_SEM_CONTENT_PATTERN_IDX_DEL