IBM InfoSphere MDM Custom Domain Hub, Version 10.1The APPSOFTWARE table represents a software application whose configuration has been deployed. This entity contains configuration and management information that is specific to a particular application version. The natural key for this entity is the name and version pair.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| application_id | A numeric artificial key used to uniquely identify an application. | BIGINT | Not Null | Yes |
| name | The name of the application. This name corresponds to the application or J2EEApplication key properties found in the object name of the Application MBean. | VARCHAR(50) | Not Null | No |
| version | A string that represents the version of the application. The format of this string is: ##.##.## representing the major version, minor version and fix pack numbers. Optionally, for development purposes, the format can be extended to ##.##.##.#### where the last group represents the build number. | VARCHAR(20) | Not Null | No |
| config_schema | An XML schema representing the configuration definition schema used by this application version. | CLOB(5M) | Not Null | No |
| last_update_dt | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |
| last_update_user | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |
| config_xml | An XML representing the configuration definition used by this application version. | CLOB(5M) | Not Null | No |
