Skip to main content

​
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:
Column NameData TypeConstraintsDescription
iduuidprimary keyUnique identifier for each entry
company_iduuidnot null, foreign key (companies)Associated company ID
process_entry_iduuidnot null, foreign key (process_entries)Related process entry ID
unique_identifier_iduuidnot null, foreign key (unique_identifiers)Associated unique identifier ID
valuetextnot nullThe actual qualitative value stored
dataset_iduuidnot null, foreign key (datasets)ID of the dataset this entry belongs to
created_attimestamp with time zonenot null, default now()Timestamp of when the entry was created

​
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.