SupplierDocumentation
| 📊 Overview: 9 Fields | 3 Indexes | 1 Many-to-One Relations |
📝 Description
🗨️ Document management table linking suppliers to quality documents, certificates, and approvals. Stores supplier compliance documentation.
- Table ID: 85
- UUID: 39E8E2BA6606BA4E97B23381CEBA900D
- Primary Key: 🔑
ID - Generated: 🕐 2025-12-04T14:34:47Z
📑 Table of Contents
📋 Fields
| Field | Type | Constraints | Description |
| 🔑 ID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto | - |
| SupplierID | Long Integer | 🚫 Not Null | - |
| DocumentType | String (255) | 🚫 Not Null | - |
| DocumentReference | String (255) | 🚫 Not Null | - |
| File | BLOB Scalar | 🚫 Not Null | - |
| DateAdded | Date | 🚫 Not Null | - |
| DateValidUntil | Date | 🚫 Not Null | - |
| FileName | String (255) | 🚫 Not Null | - |
| Archived | Boolean | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
DateValidUntil | Keywords | regular | - |
ID | Keywords | regular | ✨ Yes |
Archived | Keywords | regular | - |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
SuppliersEntity | Suppliers | SupplierID → SupplierID_l | Active | - |
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:47Z