Table sem5.dbo.LICENSE_CHAIN
Keeps the license chain 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
ID char 32
CHECKSUM char 32 foreign key to LICENSE_CHAIN table
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
USN bigint 8 Update serial number; used to detect data change
EXPIRE_DATE bigint 8  √  null Expiration date of the chain : end date - grace days
METER_COUNT int 4 seat count, from license file
GRACE_COUNT int 4  √  null actual grace count, computed based on seat count and grace percentage
WARN_DATE bigint 8  √  null The date to start the warning window, computed based on end date and warn policy (end date - warn days)
RENEWAL_URL varchar 256  √  null URL for the license renewal, created using slic API
CLIENT_PRODUCT_TYPE tinyint 1 ((0)) This holds value for SEP, SNAC
SEP=0
SNAC=1
DELETED tinyint 1 ((0)) The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted

Analyzed at Mon Oct 29 12:07 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PK_LICENSE_CHAIN