Datasets

Documentation Index

Fetch the complete documentation index at: https://docs.serial.okos.com/llms.txt

Use this file to discover all available pages before exploring further.

​

Introduction to the datasets Table

​

Table Structure

​

Usage and Functionality

1. Multi-type Data Support: The data_type column allows for different types of data to be stored, including quantitative measurements, qualitative assessments, images, files, checkboxes, and pass/fail results. This flexibility enables the system to handle diverse data collection requirements.
2. Process Integration: Each dataset is associated with a specific process through the process_id and process_revision columns. This allows for version control of processes and ensures that datasets are always linked to the correct process version.
3. Specification Limits: For quantitative data types, the lsl (Lower Specification Limit) and usl (Upper Specification Limit) columns allow for the definition of acceptable ranges. This is crucial for quality control and automated pass/fail determinations.
4. Component Linking: The child_component_id column enables datasets to be associated with specific components, which is particularly useful for tracking data across complex assemblies or multi-level bill of materials.
5. Active Status Tracking: The is_active column allows for soft deletion or archiving of datasets without removing them from the database. This is useful for maintaining historical data while focusing queries on current, active datasets.

​

Notes

• The prior_values array suggests that the system can track historical changes to dataset values, which could be useful for trend analysis or auditing purposes.
• The recent addition of the schema_id column indicates an evolution towards more structured data handling, potentially allowing for complex data parsing from log files or other structured data sources.
• Example usage in TypeScript:
  interface Dataset {
    id: string;
    name: string;
    process_id: string;
    data_type: DataType;
    company_id: string;
    order: number | null;
    created_at: string; // ISO 8601 format
    process_revision: number;
    lsl: number | null;
    usl: number | null;
    unit: string | null;
    child_component_id: string | null;
    expected_value: string | null;
    is_active: boolean;
    prior_values: string[] | null;
    schema_id: string | null;
  }
  
  // Example of creating a new dataset
  const newDataset: Partial<Dataset> = {
    name: "Component Length",
    process_id: "process-uuid",
    data_type: DataType.ParametricQuantitative,
    company_id: "company-uuid",
    lsl: 10.5,
    usl: 11.5,
    unit: "cm",
  };
  
• The order column allows for customizable sequencing of datasets within a process, which can be important for defining the flow of data collection steps.