Information for the PrayerRequest

Columns

  • Id (datatype: int) Required Primary Key
  • FirstName (datatype: nvarchar(50)) Required Primary Key
  • LastName (datatype: nvarchar(50)) Required Primary Key
  • Email (datatype: nvarchar(254)) Required Primary Key
  • CategoryId (datatype: int) Required Primary Key
  • Text (datatype: nvarchar(max)) Required Primary Key
  • Answer (datatype: nvarchar(max)) Required Primary Key
  • EnteredDateTime (datatype: datetime) Required Primary Key
  • ExpirationDate (datatype: date) Required Primary Key
  • GroupId (datatype: int) Required Primary Key
  • AllowComments (datatype: bit) Required Primary Key
  • IsUrgent (datatype: bit) Required Primary Key
  • IsPublic (datatype: bit) Required Primary Key
  • IsActive (datatype: bit) Required Primary Key
  • IsApproved (datatype: bit) Required Primary Key
  • FlagCount (datatype: int) Required Primary Key
  • PrayerCount (datatype: int) Required Primary Key
  • ApprovedOnDateTime (datatype: datetime) Required Primary Key
  • Guid (datatype: uniqueidentifier) Required Primary Key
  • CreatedDateTime (datatype: datetime) Required Primary Key
  • ModifiedDateTime (datatype: datetime) Required Primary Key
  • CreatedByPersonAliasId (datatype: int) Required Primary Key
  • ModifiedByPersonAliasId (datatype: int) Required Primary Key
  • ForeignKey (datatype: nvarchar(100)) Required Primary Key
  • RequestedByPersonAliasId (datatype: int) Required Primary Key
  • ApprovedByPersonAliasId (datatype: int) Required Primary Key
  • ForeignGuid (datatype: uniqueidentifier) Required Primary Key
  • ForeignId (datatype: int) Required Primary Key
  • CampusId (datatype: int) Required Primary Key
  • LanguageValueId (datatype: int) Required Primary Key