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

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 -

πŸ“¦ Classes


Generated from catalog.4DCatalog Generated at: 2025-12-04T14:34:03Z