tables · table
RMParaIRGroup
The RMParaIRGroup table serves as a master lookup (reference) table for categorizing Raw Material Inspection Report (IR) parameters. It defines high-level inspection groups such as dimensional, chemical, mechanical, and metallurgical testing. This categorization is primarily used in quality control modules to organize specific inspection parameters defined in the itemparamas table.
Row count
6
Last entry
—
Source
tables
Columns
2| Column | Type | Nullable | Meaning |
|---|---|---|---|
ParaGroupCode | integer | No | Unique identifier for the inspection parameter group. |
ParaGroupName | string | No | Descriptive name of the inspection category. |
Full documentation
### 1. Overview The `RMParaIRGroup` table serves as a master lookup (reference) table for categorizing Raw Material Inspection Report (IR) parameters. It defines high-level inspection groups such as dimensional, chemical, mechanical, and metallurgical testing. This categorization is primarily used in quality control modules to organize specific inspection parameters defined in the `itemparamas` table. ### 2. Column Dictionary | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage | | :--- | :--- | :--- | :--- | :--- | :--- | | **ParaGroupCode** | integer | No | Unique identifier for the inspection parameter group. | 1, 2, 3, 4, 5, 6 | Primary Key / Join Key | | **ParaGroupName** | string | No | Descriptive name of the inspection category. | "DIMENSIONAL INSPECTION", "CHEMICAL TEST", "MECHANICAL TEST", etc. | Display labels in UI/Reports | ### 3. Relationships & Join Map The table acts as a parent/lookup table for parameter definitions. #### Primary Join (Internal Quality Schema) * **dbo.itemparamas**: Joined via `ParaGroupCode`. This relationship links high-level inspection groups (e.g., "CHEMICAL TEST") to specific parameters (e.g., Carbon %, Tensile Strength) defined for specific items. #### Likely Joins (Inferred from quality workflows) * **dbo.rminspectionreport**: While `ParaGroupCode` is not explicitly in the schema for the inspection report results, the reports are likely filtered or grouped by these categories during the Quality Assurance (QA) data entry process via `itemparamas`. ---