Approvals

πŸ“Š Overview: 13 Fields 2 Indexes 2 Many-to-One Relations

πŸ“ Description

πŸ—¨οΈ Workflow table tracking approval requests and decisions for product changes, tool modifications, and quality exceptions. Links to Product, Tools, and Staff.

ℹ️ Table Information

  • Table ID: 62
  • UUID: 6588D29DE7A2FE44BEEA0304F247C2A0
  • Primary Key: πŸ”‘ ID
  • Generated: πŸ• 2025-12-04T14:34:24Z

πŸ“‘ Table of Contents


πŸ“‹ Fields

Field Type Constraints Description
πŸ”‘ ID Long Integer πŸ”‘ PK, ✨ Unique, ⚑ Auto -
ToolID Long Integer 🚫 Not Null -
Customer String (255) 🚫 Not Null -
FullApproval Boolean 🚫 Not Null -
ApprovalType String (255) 🚫 Not Null -
ConditionalApproval Boolean 🚫 Not Null -
ConditionalUntil Date 🚫 Not Null -
Issue String (255) 🚫 Not Null -
BypassApproval Boolean 🚫 Not Null -
Comments String (255) 🚫 Not Null -
ApprovedBy String (255) 🚫 Not Null -
ApprovedWhen Date 🚫 Not Null -
MigrationID Long Integer - -

πŸ” Indexes

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

πŸ”— Many-to-One Relations

Relation Name Destination Table Source β†’ Destination State Description
ToolsEntity Tools ToolID β†’ Tool_ID Active -
CustomerEntity Customer Customer β†’ Customer_Code Active -

πŸ“¦ Classes


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