ProductMaterialOptions
| 📊 Overview: 6 Fields | 3 Indexes | 2 Many-to-One Relations |
📝 Description
🗨️ Junction table defining approved material alternatives for each product. Allows material substitutions while maintaining quality standards.
- Table ID: 40
- UUID: 35B5E95C0975EB4583DCBCAD2723FA54
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:05Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| ProductID | Long Integer | 🚫 Not Null | - |
| MaterialID | Long Integer | 🚫 Not Null | - |
| CreatedBy | String (255) | 🚫 Not Null | - |
| CreatedDate | String (255) | 🚫 Not Null | - |
| MigrationID | Long Integer | - | - |
🔍 Indexes
| Field | Type | Kind | Unique |
ID | Keywords | regular | ✨ Yes |
ProductID | Keywords | regular | - |
MaterialID | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
MaterialEntity | Material | MaterialID → Unique_ID | Active | - |
ProductEntity | Product | ProductID → Product_ID | Active | - |
📦 Classes
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:05Z