It stores AI-generated information about software products, including technical details, compatibility, alternatives, and metadata.
Data model
Fields
| Field |
Type |
Description |
| common_use_cases |
VARCHAR (1000) |
Common use cases of AI-generated software. |
| created_date* |
DATETIME |
Date of creation of the registry. |
| date_latest_version |
VARCHAR (100) |
Date of publication of the latest available version of the software. |
| details |
NVARCHAR (MAX) |
Extended technical description, key features and functionalities of the software. |
| id* |
INT |
Unique identifier of the software information record. |
| integration_dependencies |
VARCHAR (1000) |
Technical dependencies or integrations required by the software. |
| introduction |
NVARCHAR (MAX) |
Introduction or overview of AI-generated software. |
| language* |
INT |
The identifier of the language used to generate the AI content. |
| latest_version |
VARCHAR (100) |
The number of the last known stable version of the software. |
| license_type |
VARCHAR (100) |
Type of software license, for example: freeware, commercial, open source, etc. |
| modified_date* |
DATETIME |
Date of last modification of the registry. |
| open_source_alternatives |
VARCHAR (600) |
Recommended open source alternatives for the software. |
| os_compatibility |
VARCHAR (400) |
Software compatibility with operating systems. |
| paid_alternatives |
VARCHAR (600) |
Paid business alternatives for the software. |
| security_risk_category |
VARCHAR (400) |
Security risk category associated with the software (PUP, obsolete, vulnerable, etc.). |
| software_id* |
INT |
Software identifier in Table AAM_SOFTWARE_VERSION. |
| software_type |
VARCHAR (400) |
Functional classification of software according to its purpose or category. |
| system_requirements |
VARCHAR (MAX) |
Minimum or recommended system requirements required to run the software. |
| web_download |
VARCHAR (1000) |
Main download URL of the software. |
| web_manufacturer |
VARCHAR (1000) |
The software manufacturer’s official website. |
Primary Key
| PK_AAM_SOFTWARE_INFO_AI |
| id |
References
