SoftwareLicensePointsDefault Table
The SoftwareLicensePointsDefault
table stores a collection of default license points associated with a particular license type.
Database Column 
Details 

SoftwareLicensePoints DefaultID

Type: integer. Key. Generated ID A unique identifier for a default points record. 
SoftwareLicenseTypeID

Type: integer. Key The software license type to which this points record applies. Foreign key to the 
ProcessorType

Type: text (max 256 characters) The type of processor a computer must have for this criterion to apply, such as “AMD” or “Intel”. 
ComputerModelNo

Type: text (max 128 characters) The model number a computer must have for this criterion to apply, such aas “IBM PS701” or “IBM JS12”. 
MinCores

Type: integer The minimum number of processor cores a computer must have for this criterion to apply. 
MaxCores

Type: integer The maximum number of processor cores a computer must have for this criterion to apply. 
MinProcessors

Type: integer The minimum number of processors a computer must have for this criterion to apply. 
MaxProcessors

Type: integer The maximum number of processors a computer must have for this criterion to apply. 
MinSockets

Type: integer The minimum number of processor sockets a computer must have for this criterion to apply. 
MaxSockets

Type: integer The maximum number of processor sockets a computer must have for this criterion to apply. 
MinCoresPerSocket

Type: integer The minimum number of processor cores per socket a computer must have for this criterion to apply. 
MaxCoresPerSocket

Type: integer The maximum number of processor cores per socket a computer must have for this criterion to apply. 
Points

Type: decimal The points value per core or processor. 
DateEffective

Type: datetime. Nullable The date from which these default values are effective. This is used to group sets of rows into sets. 
Description

Type: text (max 1024 characters). Nullable A description of the points rules. 