ToolNotice

πŸ“Š Overview: 10 Fields 2 Indexes 3 Many-to-One Relations 1 One-to-Many Relations

πŸ“ Description

πŸ—¨οΈ Alert table flagging tool issues, damage, or required actions. Notifies staff of tool problems requiring attention or repair.

ℹ️ Table Information

  • Table ID: 134
  • UUID: 6950DFACF3DA9842AF4C96E83B43790D
  • Primary Key: πŸ”‘ ID
  • Generated: πŸ• 2025-12-04T14:35:33Z

πŸ“‘ Table of Contents


πŸ“‹ Fields

Field Type Constraints Description
πŸ”‘ ID Long Integer πŸ”‘ PK, ✨ Unique, ⚑ Auto -
ToolID Long Integer - -
CreationTimestamp String (255) - -
StaffID Long Integer - -
ProductionHold Boolean - -
Active Boolean - -
RunsActiveFor Long Integer - -
NoticeText String (255) - -
DeactivatedStaffID Long Integer - -
DeactivatedTimestamp String (255) - -

πŸ” Indexes

Field Type Kind Unique
ID Keywords regular ✨ Yes
ToolID Keywords regular -

πŸ”— Many-to-One Relations

Relation Name Destination Table Source β†’ Destination State Description
ToolsEntity Tools ToolID β†’ Tool_ID Active -
StaffEntity Staff StaffID β†’ StaffID Active -
DeactivatedStaffEntity Staff DeactivatedStaffID β†’ StaffID Active -

πŸ”— One-to-Many Relations

Relation Name Source Table Source β†’ Destination State Description
ToolNoticeWorksOrderSelection ToolNoticeWorksOrder ToolNoticeID β†’ ToolID Active -

πŸ“¦ Classes

πŸ“„ Forms


Generated from catalog.4DCatalog Generated at: 2025-12-04T14:35:33Z