tPastoralCare


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PastoralCareSeq int identity 4 √ null
PastoralCareActions.PastoralCareSeq FK_PastoralCareActions_PastoralCare R
PastoralCareComments.PastoralCareSeq FK_PastoralCareComments_PastoralCare R
PastoralCareContacts.PastoralCareSeq FK_PastoralCareContacts_PastoralCare R
ID int 4 ((0))
Community.ID FK_PastoralCare_Community R
ClassCode varchar 24 √ (NULL)
ItemDate datetime 16,3 √ (NULL)
MethodCode varchar 15 √ (NULL)
Details varchar 8000 ('')
PrivateDetails varchar 8000 ('')
InitiatorCode varchar 15 ('')
TypeCode varchar 15 ('')
CategoryCode varchar 15 ('')
ClassificationCode varchar 15 ('')
IsFollowUpFlag bit 1 ((0))
FollowUpDate datetime 16,3 √ (NULL)
ConfidentialFlag bit 1 ((0))
CreatedDate datetime 16,3 √ (NULL)
CreatedByID int 4 ((0))
ModifiedDate datetime 16,3 √ (NULL)
ModifiedByID int 4 √ ((0))
EmailSentDate datetime 16,3 √ (NULL)
EmailSentByID int 4 √ ((0))
DuplicateFromSeq int 4 √ null
SubjectClassesSeq int 4 √ null
SubjectClasses.SubjectClassesSeq FK_PastoralCare_SubjectClasses R

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PastoralCare Primary key Asc PastoralCareSeq
AK_PastoralCare_ID_ItemDate Performance Asc/Asc ID + ItemDate

Relationships

Close relationships within degrees of separation