SoftwareTitleLicense Table

The SoftwareTitleLicense table links software (application) titles to licenses.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.
Table 1. Database columns for SoftwareTitleLicense table

Database Column

Details

SoftwareTitleID

Type: integer. Key

The application. Foreign key to the SoftwareTitle table.

SoftwareLicenseID

Type: integer. Key

The license covering this application. Foreign key to the SoftwareLicense table.

CompliancePriority

Type: integer. Nullable

Installations of this application will consume the linked licenses in this table in order of priority. When NULL, the default priority stored in SoftwareLicenseType table will be used.

LicenseKeyValue

Type: text (max 400 characters). Nullable

The license (installation) key value to be used when this license covers an installation of this application.

SoftwareTitleLicense ReasonID

Type: integer

The reason that this application has been added to this license. Foreign key to the SoftwareTitleLicenseReason table.

CreationUser

Type: text (max 128 characters). Nullable

The operator who created the record.

CreationDate

Type: datetime

The date the record was created.