What

Determine what types of queries and extra database structures would require to keep the ability to relate security check metrics to app and device metrics for a given client without the need for a new Type field and including the app and device metrics alongside security check metrics data.

Suggestions

• Split current metrics into separate tables
• Query into JSONB values for separate records in the mobileappmetrics table
• Create views for representing the app and device information for a given client (might have to support a time interval filter for the latest metrics record)