Store app categories associated with catalog apps
Data model
Fields
| Field | Type | Description |
|---|---|---|
| appcategory_id* | INT | Application category identifier. Reference to the AMDM_APPCATEGORY.id table |
| application_id* | INT | Application ID. Reference to the AMDM_APPSINFORMATION.id table |
Primary Key
| PK_AMDMAPPSINFORMATIONAPPCATEGORY |
|---|
| application_id, appcategory_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| appcategory_id* | dbo.AMDM_APPCATEGORY | id | FK02_AMDMAPPSINFOCATEGORY |
| application_id* | dbo.AMDM_APPSINFORMATION | id | FK01_AMDMAPPSINFOCATEGORY |