Reserved Columns

In our database, we have designated several reserved columns that serve specific functions. They are auto-generated. These columns are:

1. uid (Type: UID)

   • Purpose: Serves as a unique identifier for each record.

   • Importance: Ensures each entry can be distinctly identified and referenced.

2. author (Type: String)

   • Purpose: Records the name or identifier of the individual or system that created or modified the entry.

   • Importance: Provides accountability and traceability for data changes.

3. createdAt (Type: String)

   • Purpose: Captures the date and time when the record was created.

   • Importance: Allows tracking of the data entry timeline, useful for audits and historical data analysis.

4. updatedAt (Type: String)

   • Purpose: Stores the date and time of the last update made to the record.

   • Importance: Essential for understanding the currency of the data and for tracking changes over time.

These columns are integral to the database's structure and functionality, and they cannot be altered or removed. They play a crucial role in maintaining data integrity, consistency, and traceability.