LicenseInfo Model

Overview

The licenseinfo table is designed to store and manage software license details for various products, including license keys, activation statuses, product information, and customer-specific data. This table is used to track license issuance, activation counts, and expiration dates, helping organizations manage and monitor their licensed software deployments.

Fields

Field	Type	Description	Required
id	string	Unique identifier for the license record. Serves as the primary key.	❌
licenseKey	string	A unique license string/code that is used to activate a product. It's what the customer receives for installation or activation.	❌
key	string	Additional key identifier for the license. Sometimes used for hashed keys or tokens.	❌
product	any	Name of the licensed product.	❌
issuedTo	string	The entity or user to whom the license is issued.	❌
customer_id	string	Identifier of the customer associated with the license.	❌
issueDate	date	Date when the license was issued to the customer.	❌
expiryDate	date	End date of the license validity. After this date, the license may be invalid or require renewal.	❌
mailStatus	boolean	Boolean (0/1) indicating whether the license key was emailed to the recipient. Useful for tracking delivery.	❌
activationStatus	boolean	Boolean flag indicating whether the license has been activated at least once.	❌
activationTotalCount	any	A field storing the total number of allowed activations for this license.	❌
installedCount	any	Number of times the license has been installed.	❌
activationMode	string	Mode of activation (e.g., online, offline).Helps in enforcing license models.	❌
created_at	date	Timestamp when the record was created.	❌
modified_at	date	Timestamp when the record was last updated.	❌
isActivated	boolean	Boolean (0/1) to quickly check if the license is currently active. Useful for quick filtering.	❌
productInfoId	string	Reference to detailed product info in a different table, like release notes or technical specs.	❌
bundleId	string	ID linking to a bundle of features or modules associated with this license, if any.	❌
users	array	List of users associated with the license, possibly stored as JSON or another serialized format.	❌
xr_apps	array	List of extended reality (XR) applications associated with the license.	❌
application_id	string	Identifier for the site map associated with the license, possibly related to user access or environment.	❌
siteMapId	string	Reference to a site map configuration, potentially indicating where the product is deployed.	❌
orgId	string	The ID of the organization that owns the license. Useful in multi-tenant systems.	❌
systemInfo	any	Additional system-related information for the license. Used for validation and security.	❌

Sample JSON

{
  "id": "example_value",
  "licenseKey": "example_value",
  "key": "example_value",
  "product": "example_value",
  "issuedTo": "example_value",
  "customer_id": "example_value",
  "issueDate": "example_value",
  "expiryDate": "example_value",
  "mailStatus": "example_value",
  "activationStatus": "example_value",
  "activationTotalCount": "example_value",
  "installedCount": "example_value",
  "activationMode": "example_value",
  "created_at": "example_value",
  "modified_at": "example_value",
  "isActivated": "example_value",
  "productInfoId": "example_value",
  "bundleId": "example_value",
  "users": "example_value",
  "xr_apps": "example_value",
  "application_id": "example_value",
  "siteMapId": "example_value",
  "orgId": "example_value",
  "systemInfo": "example_value"
}