Community


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
AbsenceEvents.ID FK_AbsenceEvents_CommunityID R
AccessLog.ID FK_AccessLog_Community R
ActionMessage.ActionedByUserID FK_ActionMessage_ActionedByUserID_Community_ID R
ActionMessage.TargetUserID FK_ActionMessage_TargetUserID_Community_ID R
ActionUserPreferences.ID FK_ActionUserPreferences_ID_Community_ID R
ActionUserSubscriptionPreferences.ID FK_ActionUserSubscriptionPreferences_ID_Community_ID R
CommunityAddressLinks.ID FK_CommunityAddressLinks_Community R
CommunityAlerts.ID FK_CommunityAlerts_ID_Community R
CommunityCheck.ID FK_CommunityCheck_Community R
CommunityCheck.VerifiedByID FK_CommunityCheck_Community_VerifiedByID R
CommunityCitizenships.ID FK_CommunityCitizenships_Community R
CommunityCommuniationMethods.ID FK_CommunityCommuniationMethods_Community R
CommunityCommunicationsCurrent.ID FK_CommunityCommunicationsCurrent_Community R
CommunityEventsAttributes.ID FK_CommunityEventsAttributes_Community R
CommunityEventsCurrent.ID FK_CommunityEventsCurrent_Community R
CommunityEventsCurrentGuests.GuestID FK_CommunityEventsCurrentGuests_Community_GuestID R
CommunityEventsCurrentGuests.ID FK_CommunityEventsCurrentGuests_Community_HostID R
CommunityEventsGuests.GuestID FK_CommunityEventsGuests_Community_GuestID R
CommunityInvolvement.ID FK_CommunityInvolvement_Community R
CommunityInvolvementActivity.ActivityByID FK_CommunityInvolvementActivity_Community_ActivityByID R
CommunityInvolvementActivity.ID FK_CommunityInvolvementActivity_Community_ID R
CommunityKeys.ID FK_CommunityKeys_Community R
CommunityLegal.ID FK_CommunityLegal_Community R
CommunityLoginsPage.ID FK_CommunityLoginsPage_ID_Community_ID R
CommunityMembership.ID FK_CommunityMembership_Community R
CommunityOccupHistory.ID FK_CommunityOccupHistory_Community R
CommunityQualifications.ID FK_CommunityQualifications_Community R
CommunitySkills.ID FK_CommunitySkills_Community R
CommunityVehicles.ID FK_CommunityVehicles_Community R
Constituencies.ID FK_Constituencies_Community R
DisabilityAdjustment.ID FK_DisabilityAdjustment_Community R
DonorProspects.ID FK_DonorProspects_Community R
EventAttendeeConsents.AttendeeID FK_EventAttendeeConsents_AttendeeID_Community R
EventAttendeeConsents.ConsentGivenByID FK_EventAttendeeConsents_ConsentGivenByID_Community R
EventObjectBookings.ResponsibleStaffId FK_EventObjectBookings_Community_ResponsibleStaffId R
EventSubGroup.ResponsibleStaffID FK_EventGroup_Community R
FutureStudentContacts.ID FK_FutureStudentContacts_ID_Community R
FutureStudentContacts.LinkedID FK_FutureStudentContacts_LinkedID_Community R
FutureStudents.ID FK_FutureStudents_Community R
JobPositionNotifications.ID FK_JobPositionNotifications_Community R
ObjectAccommodation.AgentID FK_ObjectAccommodation_AgentID R
ObjectAccommodation.LinkedID FK_ObjectAccommodation_LinkedID R
ObjectBookings.BookedByID FK_ObjectBookings_Community_BookedByID R
ObjectBookings.BorrowerID FK_ObjectBookings_Community_BorrowerID R
ObjectBookingsMasterMembers.ID FK_ObjectBookingsMasterMembers_Community R
ObjectLoans.ID FK_ObjectLoans_Community_ID R
ObjectLoans.IssuedByID FK_ObjectLoans_Community_IssuedByID R
ObjectLoans.ReturnedToID FK_ObjectLoans_Community_ReturnedToID R
Objects.LoanedToID FK_Objects_Community_LoanedToID R
Objects.ResponsibleID FK_Objects_Community_ResponsibleID R
ObjectTaskActivities.FollowUpID FK_ObjectTaskActivities_Community_FollowUpID R
ObjectTasks.AllocatedToID FK_ObjectTasks_Community_AllocatedToID R
ObjectTasks.InitiatedByID FK_ObjectTasks_Community_InitiatedByID R
ObjectTypeTaskStaff.ID FK_ObjectTypeTaskStaff_Community R
OnlineImportContactsCommunity.CommunityID FK_OnlineImportContactsCommunity_Community R
PastStudentClasses.CommPortalPrintID FK_PastStudentClasses_CommunityID R
PastStudentContacts.ID FK_PastStudentContacts_ID_Community R
PastStudentContacts.LinkedID FK_PastStudentContacts_LinkedID_Community R
PastStudents.ID FK_PastStudents_Community R
Staff.ID FK_Staff_Community R
StaffExternalTests.StaffID FK_StaffExternalTests_Community R
StaffScheduleStudentClasses.ID FK_StaffScheduleStudentClasses_Community R
StudentClasses.CommPortalPrintID FK_StudentClasses_CommunityID R
StudentContacts.ID FK_StudentContacts_ID_Community R
StudentContacts.LinkedID FK_StudentContacts_LinkedID_Community R
StudentCourses.AgentID FK_StudentCourses_Community_AgentID R
StudentCourses.CommissionAuthorisedID FK_StudentCourses_Community R
StudentCourses.ID FK_StudentCourses_ID R
StudentExternalTests.StudentID FK_StudentExternalTests_Community R
Students.ID FK_Students_Community R
StudentSchools.ID FK_StudentSchools_Community R
SubjectClassStaff.StaffID FK_SubjectClassStaff_Community R
TagListCommunity.ID FK_TagListCommunity_Community R
Tags.ID FK_Tags_Community R
tPastoralCare.ID FK_PastoralCare_Community R
Transport.ID FK_Transport_Community R
wkSubjectClassesbulk.ConfigUserID FK_wkSubjectClassesbulk_Community_ConfigUserID R
IDType varchar 1 ('I')
AddressID int 4 ((0))
SpouseID int 4 ((0))
SpouseFlag bit 1 ((0))
CommunityCreatedDate datetime 16,3 √ null
CommunityCreatedBy varchar 50 √ ('')
CommunityModifiedDate datetime 16,3 √ null
CommunityModifiedBy varchar 50 √ ('')
Surname varchar 30 ('')
SurnamePrevious varchar 30 ('')
Title varchar 30 ('')
Initials varchar 15 ('')
Suffix varchar 20 ('')
Preferred varchar 20 ('')
Given1 varchar 20 ('')
Given2 varchar 50 ('')
OccupCode varchar 15 √ ('')
OccupDesc varchar 50 ('')
OccupCompany varchar 50 ('')
OccupIndustryCode varchar 8 ('')
OccupPositionCode varchar 8 ('')
OccupPhone varchar 15 ('')
OccupFax varchar 15 ('')
OccupEmail varchar 100 ('')
MailFormat varchar 1 ('')
SalutFormat varchar 1 ('')
BirthDate datetime 16,3 √ null
DeceasedDate datetime 16,3 √ null
DeceasedFlag bit 1 ((0))
Gender varchar 15 ('')
MobilePhone varchar 15 ('')
Email varchar 100 ('')
ReligionCode varchar 5 ('')
CountryOfBirthCode varchar 5 ('')
HomeLanguageCode varchar 5 ('')
Education varchar 255 ('')
Qualifications varchar 255 ('')
HighestSecondaryYearLevel tinyint 1 ((0))
LastYearOfStudy int 4 ((0))
MaritalStatus varchar 1 ('')
MailNamePrimary varchar 100 ('')
MailNameJoint varchar 100 ('')
MailSalutationPrimary varchar 100 ('')
MailSalutationJoint varchar 100 ('')
OccupAddress1 varchar 40 ('')
OccupAddress2 varchar 40 ('')
OccupAddress3 varchar 40 ('')
OccupSuburb varchar 40 ('')
OccupState varchar 5 √ ('')
OccupCountryCode varchar 5 ('')
OccupPostCode varchar 5 ('')
OccupMobilePhone varchar 15 ('')
Comment varchar 2147483647 √ null
Biography varchar 2147483647 √ null
OccupAddressFull varchar 200 ('')
OccupAddressComma varchar 200 ('')
ParishCode varchar 5 ('')
NationalityCode varchar 5 ('')
InitialsOverrideFlag bit 1 ((0))
OccupCompanyAttn varchar 40 ('')
DefaultEmailCode varchar 1 ('')
Nationality2Code varchar 5 ('')
OccupDescIncludeInAddressFlag bit 1 ((1))
OccupAddressDPID varchar 8 ('')
OccupAddressSortPlanNumber varchar 3 ('')
OccupAddressPAFVersion varchar 10 ('')
OccupAddressDPIDBarcode varchar 60 ('')
ParkingSpace varchar 15 ('')
NetworkLogin varchar 100 ('')
Barcode varchar 20 ('')
SilentMobilePhoneFlag bit 1 ((0))
MobilePhoneActual varchar 15 ('')
SilentOccupMobilePhoneFlag bit 1 ((0))
OccupMobilePhoneActual varchar 15 ('')
DirectoryIncludeFlag bit 1 ((0))
DirectoryProvideFlag bit 1 ((0))
NameInternal varchar 100 ('')
NameInternalOverrideFlag bit 1 ((0))
NameExternal varchar 100 ('')
NameExternalOverrideFlag bit 1 ((0))
PreferredFormal varchar 20 ('')
LegalFullName varchar 150 ('')
LegalFullNameOverrideFlag bit 1 ((0))
UserFlag1 bit 1 ((0))
UserFlag2 bit 1 ((0))
UserFlag3 bit 1 ((0))
UserFlag4 bit 1 ((0))
UserFlag5 bit 1 ((0))
MailNamePrimaryOverrideFlag bit 1 ((0))
MailNameJointOverrideFlag bit 1 ((0))
MailSalutationPrimaryOverrideFlag bit 1 ((0))
MailSalutationJointOverrideFlag bit 1 ((0))
EthnicGroup1Code varchar 15 ('')
EthnicGroup2Code varchar 15 ('')
EthnicGroup3Code varchar 15 ('')
IndigenousGroup1Code varchar 15 ('')
IndigenousGroup2Code varchar 15 ('')
IndigenousGroup3Code varchar 15 ('')
IndigenousLanguageLevelCode varchar 15 ('')
CountryCitizenshipCode varchar 5 ('')
EarlyChildhoodParticipationCode varchar 15 ('')
SchoolAttainmentCode varchar 15 ('')
NeighbourIslandLanguageCode varchar 5 ('')
NeighbourIslandLanguageLevelCode varchar 15 ('')
DietaryRequirements varchar 2147483647 √ null
PhysicalRequirements varchar 2147483647 √ null
HighestQualificationLevel varchar 15 ('')
PublishToAssociatedFlag bit 1 ((0))
HighestNonNationalQualificationCode varchar 15 ('')
OccupDescIncludeInMailAddressFlag bit 1 ((0))
WorkWithChildrenCheckStatus varchar 15 ('')
WorkWithChildrenCheckRegistrationNumber varchar 30 ('')
WorkWithChildrenCheckExpiryDate datetime 16,3 √ null
ExternalSystemRegistrationNumber varchar 30 ('')
DefaultMobilePhoneCode varchar 1 ('P')
WebSite varchar 100 ('')
DietaryRequirementCode varchar 15 ('')
MaidenName varchar 30 ('')
OverideLegalSurname varchar 30 ('')
OccupAddressComment varchar 250 ('')
CommunityGUID varchar 32 (replace(newid(),'-',''))
WorkWithChildrenCheckVerifiedDate datetime 16,3 √ null
RefugeeFlag bit 1 ((0))
FacetimeAddress varchar 100 ('')
SkypeAddress varchar 100 ('')
FacebookUrl varchar 100 ('')
TwitterUrl varchar 100 ('')
LinkedInUrl varchar 100 ('')
IdamGuid uniqueidentifier 16 √ null
IdamLogin varchar 50 ('')
CurrentWWCRequiredFlag bit 1 ((0))
ExternalValidationFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK__Community__26B08FFB Primary key Asc ID
AK_AddressID Performance Asc AddressID
AK_Community_Barcode Performance Asc Barcode
AK_Community_CommunityGUID Performance Asc CommunityGUID
AK_Community_IdamGuid Performance Asc IdamGuid
AK_Community_NetworkLogin Performance Asc NetworkLogin
AK_Community_OccupCompany Performance Asc OccupCompany
AK_Community_Preferred Performance Asc Preferred
AK_Community_SpouseID Performance Asc SpouseID
AK_Community_Surname Performance Asc Surname

Relationships

Close relationships within degrees of separation