CustomerContacts

πŸ“Š Overview: 4 Fields 1 Indexes 1 Many-to-One Relations

πŸ“ Description

πŸ—¨οΈ Master data table storing contact persons for each customer. Includes names, roles, email, phone numbers, and communication preferences.

ℹ️ Table Information

  • Table ID: 78
  • UUID: 4BCC18B6E22B7B4CB1440CD3608A0D8D
  • Primary Key: πŸ”‘ ID
  • Generated: πŸ• 2025-12-04T14:34:40Z

πŸ“‘ Table of Contents


πŸ“‹ Fields

Field Type Constraints Description
πŸ”‘ ID Long Integer πŸ”‘ PK, ✨ Unique, ⚑ Auto -
Customer String (255) 🚫 Not Null -
Email String (255) 🚫 Not Null -
MigrationID Long Integer - -

πŸ” Indexes

Field Type Kind Unique
ID Keywords regular ✨ Yes

πŸ”— Many-to-One Relations

Relation Name Destination Table Source β†’ Destination State Description
CustomerEntity Customer Customer β†’ Customer_Code Active -

πŸ“¦ Classes

πŸ“„ Forms


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