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