Parametric Qualitative

​

Introduction to the Parametric_Qualitative Table

The parametric_qualitative table is designed to store qualitative parametric data within the Serial database. This table plays a crucial role in the system by capturing text-based measurements or observations associated with specific process entries and unique identifiers.

​

Table Structure

The parametric_qualitative table is structured to efficiently store and relate qualitative data to other entities in the database. Here’s a detailed breakdown of its columns:

​

Usage and Functionality

The parametric_qualitative table is designed to be a flexible and integral part of the data collection system. Here are some key points about its usage:

1. Qualitative Data Storage: This table specifically handles text-based parametric data, allowing for the storage of descriptive or categorical information that can’t be represented numerically.
2. Process and Identifier Association: Each entry in the table is linked to a specific process entry and unique identifier, allowing for precise tracking of qualitative data throughout the manufacturing or inspection process.
3. Dataset Organization: The inclusion of a dataset_id allows for grouping related qualitative parameters, which can be useful for reporting and analysis purposes.

​

Notes

• Insertion policies are in place to ensure that users can only add data for their associated company, as demonstrated by this SQL policy:
  CREATE POLICY "Insert - Data - SameCompany" ON "public"."parametric_qualitative"
  FOR INSERT TO "authenticated"
  WITH CHECK (("company_id" IN ( SELECT "privileges"."company_id"
     FROM "public"."privileges"
    WHERE ("privileges"."supabase_uid" = "auth"."user_id"()))));
  
• This table works in conjunction with the parametric_quantitative table to provide a complete picture of parametric data in the system. While parametric_qualitative handles text-based data, parametric_quantitative would handle numerical measurements.

By leveraging the parametric_qualitative table, the Serial application can effectively capture, store, and manage qualitative parametric data, enabling comprehensive tracking and analysis of non-numerical attributes throughout the manufacturing or quality control process.