TechnopediaProductReleaseInfo Table

TechnopediaProductReleaseInfo table stores Technopedia product release information.

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 TechnopediaProductReleaseInfo table

Database Column

Details

ProductID

Type: big integer. Key

Technopedia release ProductID.

ReleaseID

Type: big integer. Key

Technopedia release ReleaseID.

FlexeraID

Type: text (max 256 characters). Key

Mapped FlexeraID for a Technopedia Release.

SoftwareTitleID

Type: integer. Key. Nullable

Foreign key to the SoftwareTitle table.

Manufacturer

Type: text (max 2000 characters). Nullable

Manufacturer name.

ProductFamily

Type: text (max 2000 characters). Nullable

Brand/family in which the software product belongs to.

ProductName

Type: text (max 2000 characters). Nullable

The name of the software product.

Component

Type: text (max 2000 characters). Nullable

The component of the software product (if applicable).

Edition

Type: text (max 2000 characters). Nullable

Software product’s edition name.

VersionGroup

Type: text (max 2000 characters). Nullable

The name of version group (or market version) of the software product.

Version

Type: text (max 2000 characters). Nullable

Software patch’s name/number.

PatchLevel

Type: text (max 2000 characters). Nullable

Technopedia software patch’s level (Critical or Optional).

SubVersion

Type: text (max 2000 characters). Nullable

The notion that indicates the stage within the lifecycle of a product version from its initial inception to the final/end form and beyond.

IsMajorRelease

Type: boolean. Nullable

The field is set to True if the the Technopedia release is a major release.

UpdatedDate

Type: datetime

The date the record was last updated.