Add new IT standards data fields to GEAR's API

[hatfieldjm4]

There are 4 new tables that have been added to the dev database (really only 2 new tables with 2 new lookup table to establish a M:M relationship with obj_technology):

• obj_operating system
• zk_technology_operating_system
• obj_technology_app_bundle
• zk_technology_app_bundle

The M:M relationship between obj_operating_system and obj_technology is fairly straightforward -- one mobile app can exist on either Android or iOS (i.e. we don't need to duplicate mobile software entries just to represent one being an iOS app and one being an Android app).

The M:M relationship between obj_technology_app_bundle and obj_technology is a little more complex. The "App Bundle" is basically a UID for the mobile app. We will need to maintain a list of the app bundle Ids in this table. In GEAR Manager, it will need to remain an open text field so that users can input new values. I'm not sure how we want to handle this on the back end -- do we want to add logic that looks in the database for a user-entered value to see if it exists in the obj_technology_app_bundle table already, or do we simply want to keep adding new app bundle Ids to the table without worrying about duplication?

Note: we are only using the App Bundle UIDs for mobile apps that are denied for use.