What are the 7 BaseEntity columns every table shares, and what does each do?

Every table inherits a common BaseEntity with seven columns. Id — the numeric (long) primary key used internally. PublicId — a GUID with a unique index, safe to expose in URLs/APIs without leaking sequential ids. CreatedUtc — when the row was created. CreatedBy — who created it. ModifiedUtc — when it was last changed (note: deliberately named ModifiedUtc, not…

Every table inherits a common BaseEntity with seven columns. Id — the numeric (long) primary key used internally. PublicId — a GUID with a unique index, safe to expose in URLs/APIs without leaking sequential ids. CreatedUtc — when the row was created. CreatedBy — who created it. ModifiedUtc — when it was last changed (note: deliberately named ModifiedUtc, not UpdatedUtc). ModifiedBy — who last changed it. IsDeleted — a soft-delete flag. The four audit columns give every record a consistent who/when trail; the public/private id split protects against id enumeration; and the soft-delete flag underpins safe, recoverable deletion across the whole system. Because this is inherited everywhere, the audit and deletion behavior is uniform across all ~49 entities.