ToolLog
| 📊 Overview: 6 Fields | 1 Indexes | 1 Many-to-One Relations |
📝 Description
🗨️ Audit table logging tool movements, usage, maintenance activities, and status changes. Provides complete tool history for lifecycle tracking.
ℹ️ Table Information
- Table ID: 37
- UUID: FD6A501D6913B94C884BCFC8E8930241
- Primary Key: 🔑
UniqueID - Generated: 🕐 2025-12-04T14:34:03Z
📑 Table of Contents
- 📋 Fields (6)
- 🔍 Indexes (1)
- 🔗 Many-to-One Relations (1)
- 🔗 Related Items
- Classes (1)
📋 Fields
| Field | Type | Constraints | Description |
|---|---|---|---|
| 🔑 UniqueID | Long Integer | 🔑 PK, ✨ Unique, ⚡ Auto, 🚫 Not Null | - |
| Tool_ID | Long Integer | 🚫 Not Null | - |
| Date | Date | 🚫 Not Null | - |
| Description | String | 🚫 Not Null | - |
| PO_ID | Long Integer | 🚫 Not Null | - |
| Reason | String (255) | 🚫 Not Null | - |
🔍 Indexes
| Field | Type | Kind | Unique |
|---|---|---|---|
UniqueID | B-Tree | regular | ✨ Yes |
🔗 Many-to-One Relations
| Relation Name | Destination Table | Source → Destination | State | Description |
|---|---|---|---|---|
ToolsEntity | Tools | Tool_ID → Tool_ID | Active | - |
🔗 Related Items
📦 Classes
- ToolLogEntity - ORDA Entity class for ToolLog table
Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:03Z