FieldHistory

๐Ÿ“Š Overview: 7 Fields 5 Indexes

๐Ÿ“ Description

๐Ÿ—จ๏ธ Audit table recording field-level changes to critical data. Tracks before/after values, timestamps, and users for compliance and traceability.

โ„น๏ธ Table Information

  • Table ID: 102
  • UUID: D4E78D9BFB953A4889052AAB5F6072AF
  • Primary Key: ๐Ÿ”‘ ID
  • Generated: ๐Ÿ• 2025-12-04T14:35:03Z

๐Ÿ“‘ Table of Contents


๐Ÿ“‹ Fields

Field Type Constraints Description
๐Ÿ”‘ ID Long Integer ๐Ÿ”‘ PK, โœจ Unique, โšก Auto -
Table Long Integer ๐Ÿšซ Not Null -
Field Long Integer ๐Ÿšซ Not Null -
PrimaryKey Long Integer ๐Ÿšซ Not Null -
ChangedBy String (255) ๐Ÿšซ Not Null -
ChangedDateTime String (255) ๐Ÿšซ Not Null -
Value String (255) ๐Ÿšซ Not Null -

๐Ÿ” Indexes

Field Type Kind Unique
PrimaryKey Keywords regular -
ID Keywords regular โœจ Yes
Table B-Tree regular -
Table Keywords regular -
Field Keywords regular -

๐Ÿ“ฆ Classes

  • FieldHistory - ORDA DataClass class for FieldHistory table

๐Ÿ“„ Forms


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