ContactDetail

Metadata

  • Base Table Class: Static
  • Default Size: Enterprise + Firm + User = 200

Fields

NameTypeSize (bytes)Description
IdInteger (signed)8The unique identifier of this ContactDetail.
StatusSet of Status4
UserForeign key to User8
ContactTypeOne of ContactType1
DetailString255
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 ContactDetail.
OwnerGroupForeign key to Group8The Id of the Group that owns this ContactDetail.
OwnerFirmForeign key to Firm8The Id of the Firm that owns this ContactDetail.
CreateUserForeign key to User8The Id of the User that created this ContactDetail.
CreateTimestampInteger (unsigned)8The time at which this ContactDetail was created.
UpdateUserForeign key to User8The Id of the User that last updated this ContactDetail.
UpdateTimestampInteger (unsigned)8The time at which this ContactDetail was last updated.