Table sem5.dbo.LICENSE
Keeps the license 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
DELETED tinyint 1 The deleted flag of the schema object:
1 = Deleted
0 = Not Deleted
CHAINID char 32 foreign key to LICENSE_CHAIN table
TIME_STAMP bigint 8 Time that the record was modified; used to resolve merge conflict
TYPE char 1 License type
SERIAL_NUM char 16 License serial number, read from license file
FULFILLMENT_ID char 16 License fulfilment id, read from license file
SERIAL_ID char 16 License serial id, read from license file
USN bigint 8 Update serial number; used to detect data change
START_DATE bigint 8 License start date time, read from license file
END_DATE bigint 8 License end date time, read from license file
METER_COUNT int 4 seat count, read from license file
GRACE_COUNT_PCT int 4 grace seat percentage value, read from license file
WARN_POLICY bigint 8 number of days, prior to end, to start the warning. read from license file
GRACE_POLICY bigint 8 number of days of grace, specified in license file. End date includes the grace days as well. Hence expiration date = end date - grace days
PRODUCT_ID varchar 32 product code , indicating sepe/sepsb product type, version and suffix. Read from license file
PRODUCT_NAME varchar 128 Example:
Symantec Endpoint Protection Small Business Edition 12.0 Trial License
WARN_DATE bigint 8  √  null The date to start the warning window, computed based on end date and warn policy ( end date - warn days)
EXPIRE_DATE bigint 8  √  null end date - grace days
GRACE_COUNT int 4  √  null actual grace count, computed based on seat count and grace percentage
PRODUCT_TYPE varchar 32 Enteprise or small business product type : SEPSB / SEPE
RENEWAL_URL varchar 256  √  null URL for the license renewal, created using slic library API

Analyzed at Mon Oct 29 12:07 PDT 2012

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