📊 Overview: 49 Fields 4 Indexes 1 Many-to-One Relations
🗨️ Quality management table tracking non-conformance reports (NCRs) for defects, quality issues, and corrective actions. Links to WorksOrders, Products, and Staff for root cause analysis.
Table ID: 19UUID: 0EF85BE67B5AB047BDF434F47974C7C3Primary Key: 🔑 IDGenerated: 🕐 2025-12-04T14:33:45Z Field Type Constraints Description Reference_No String (15)✨ Unique, ⚠️ Required, 🚫 Not Null - Tool_ID Long Integer🚫 Not Null - Date Date🚫 Not Null - NatureOfConcern String🚫 Not Null - Reply_Due String (30)🚫 Not Null - Responded_On Date🚫 Not Null - Completed_Yes Boolean🚫 Not Null - Completed_No Boolean🚫 Not Null - Is_A_PQI Boolean🚫 Not Null - Type_Of_Concern String (15)🚫 Not Null - Part_IssueLevel String (5)🚫 Not Null - Works_Order_No Long Integer🚫 Not Null - ConcernRecdBy String (20)🚫 Not Null - ConcernRecdDate Date🚫 Not Null - WIP_Quantity Long Integer🚫 Not Null - WIP_Location String (15)🚫 Not Null - WIP_Status String (9)🚫 Not Null - WIP_ActionTaken String🚫 Not Null - WIP_Signed String (20)🚫 Not Null - WIP_Date Date🚫 Not Null - Stock_Quantity Long Integer🚫 Not Null - Stock_Location String (15)🚫 Not Null - Stock_Status String (9)🚫 Not Null - Stock_ActionTaken String🚫 Not Null - Stock_Signed String (15)🚫 Not Null - Stock_Date Date🚫 Not Null - CauseofConcern String🚫 Not Null - NoofInternalPQI Integer🚫 Not Null - NoofExternalPQI Integer🚫 Not Null - Recurrence_Action String🚫 Not Null - QualityImprove_Action String🚫 Not Null - QualityImprove_Sign String (15)🚫 Not Null - QualityImprove_Date Date🚫 Not Null - Customer String (3)🚫 Not Null - CauseOfNonDetection_txt String🚫 Not Null - ActionNonDetection_txt String🚫 Not Null - Recurrence_Signed String (15)🚫 Not Null - Recurrence_Date Date🚫 Not Null - ActionNonDetection_Signed String (15)🚫 Not Null - ActionNonDetection_Date Date🚫 Not Null - Effective_Action String🚫 Not Null - Effective_Signed String (15)🚫 Not Null - Effective_Date Date🚫 Not Null - Field_44 String (255)- - FMEA String🚫 Not Null - FMEA_Signed String (255)🚫 Not Null - FMEA_Date Date🚫 Not Null - 🔑 ID Long Integer🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null - CreateWorkRequest Boolean🚫 Not Null -
Field Type Kind Unique Tool_IDKeywords regular - IDKeywords regular ✨ Yes Is_A_PQIKeywords regular - Reference_NoKeywords regular ✨ Yes
Relation Name Destination Table Source → Destination State Description ToolsEntityTools Tool_ID → Tool_IDActive -
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:33:45Z