CalendarEntry

Metadata

  • Base Table Class: Static
  • Default Size: Calendar * Constants::MaxEntriesPerCalendar = 50000

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this CalendarEntry.
StatusSet of Status4
CalendarForeign key to Calendar8This is a reference to the Calendar table. It is keyed by the Calendar column in this table to the Id column in the Calendar table.
CalendarDateTypeSet of CalendarDateType1
DateInteger (signed)4Represents a date as an integer in YYYYMMDD format.
DayOfWeekOne of DayOfWeek1The day of the week to which the Calendar Entry applies
UpdateNumberInteger (unsigned)8A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record.
OwnerUserForeign key to User8The Id of the User that owns this CalendarEntry.
OwnerGroupForeign key to Group8The Id of the Group that owns this CalendarEntry.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this CalendarEntry.
CreateUserForeign key to User8The Id of the User that created this CalendarEntry.
CreateTimestampInteger (unsigned)8The time at which this CalendarEntry was created.
UpdateUserForeign key to User8The Id of the User that last updated this CalendarEntry.
UpdateTimestampInteger (unsigned)8The time at which this CalendarEntry was last updated.