Events


Columns

Column Type Size Nulls Auto Default Children Parents Comments
EventCode varchar 15 ('')
CommunityEventsCurrent.EventCode FK_CommunityEventsCurrent_Events R
CommunityEventsCurrentGuests.EventCode FK_CommunityEventsCurrentGuests_Events_EventCode R
CommunityEventsGuests.EventCode FK_CommunityEventsGuests_Events_EventCode R
EventOrganisers.EventCode FK_EventOrganisers_Events R
Description varchar 50 ('')
EventConcludedFlag bit 1 ((0))
EventDate datetime 16,3 √ null
EventCreateDate datetime 16,3 √ (getdate())
InviteDate datetime 16,3 √ null
RSVPDate datetime 16,3 √ null
LocationCode varchar 15 ('')
LocationContact varchar 50 ('')
Organiser1 varchar 30 ('')
Organiser2 varchar 30 ('')
Organiser3 varchar 30 ('')
StaffID1 int 4 ((0))
StaffID2 int 4 ((0))
StaffID3 int 4 ((0))
EventAdultCost money 21,4 √ null
EventStudentCost money 21,4 √ null
EventConcessionCost money 21,4 √ null
MaximumAttendance smallint 2 ((0))
TablesOf tinyint 1 ((0))
BulkAddCriteria varchar 2147483647 √ null
EventsSeq int identity 4 √ null
CommunityEventsTickets.EventsSeq FK_CommunityEventsTickets_EventsSeq R
EventAbility.EventsSeq FK_EventAbility_Events R
EventAppointment.EventsSeq FK_EventAppointment_Events R
EventApprovalProcessActivity.EventsSeq FK_EventApprovalProcessActivity_Events R
EventConsents.EventsSeq FK_EventConsents_Events R
EventGeneralConsent.EventsSeq FK_EventGeneralConsent_Events R
EventGroup.EventsSeq FK_EventGroup_Events R
EventImmunisation.EventsSeq FK_EventImmunisation_EventsSeq R
EventMedicalCondition.EventsSeq FK_EventMedicalCondition_Events R
EventMembershipType.EventsSeq FK_EventMembershipType_Events R
EventObjectBookings.EventsSeq FK_EventObjectBookings_Events_EventsSeq R
WebShowFlag bit 1 ((0))
WebDateFrom datetime 16,3 √ null
WebDateTo datetime 16,3 √ null
WebReturnEmail varchar 100 ('')
WebMerchantID varchar 20 ('')
WebExternalReference varchar 30 ('')
WebComment varchar 2147483647 √ null
Comment varchar 2147483647 √ null
AbsenceEventsSystemProcessNumber int 4 √ (NULL)
SystemProcessControl.SystemProcessNumber FK_Events_AbsenceEventsSystemProcessNumber R
EventEndDate datetime 16,3 √ null
OnlinePaymentOptionLevelThreeSeq int 4 √ null
OnlinePaymentOptionLevelThree.OnlinePaymentOptionLevelThreeSeq FK_Events_OnlinePaymentOptionLevelThreeSeq R
EventTypeCode varchar 15 ('')
MaximumTicketsPerAttendee smallint 2 √ null
ModifiedDateTime datetime 16,3 √ (getdate())
AttireCode varchar 15 √ ('')
Objectives varchar 2147483647 √ ('')
EventStatus varchar 15 √ ('')
VerifyDietaryRequirements bit 1 √ ((0))
VerifyEmergencyContactDetails bit 1 √ ((0))
VerifyDoctorDetails bit 1 √ ((0))
VerifyDentistDetails bit 1 √ ((0))
VerifyMedicareDetails bit 1 √ ((0))
VerifyHealthInsurance bit 1 √ ((0))
WebPage varchar 2147483647 √ null
PublicFlag bit 1 √ ((0))
IsExcursion bit 1 √ ((0))
IsDietaryRequirementsRelevant bit 1 √ ((0))
ShowBloodType bit 1 √ ((1))
ShowPhysicalRequirements bit 1 √ ((1))
TermsAndConditions varchar 2147483647 √ (NULL)
TermsAndConditionsFlag bit 1 ((1))
IncludeLocationHTMLFlag bit 1 ((0))
IncludeLocationDescriptionFlag bit 1 ((0))
IncludeLocationAddressFlag bit 1 ((0))
VerifyMedicalConditionsFlag bit 1 ((1))
VerifyMedicationFlag bit 1 ((1))
VerifyAllergiesFlag bit 1 ((1))
VerifyOngoingMedicalConsentsFlag bit 1 ((1))
VerifyImmunisationsFlag bit 1 ((1))
VerifyAbilitiesFlag bit 1 ((1))
ConfirmationEmailFlag bit 1 ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_Events Primary key Asc EventCode
AK_Events_EventsSeq Must be unique Asc EventsSeq

Relationships

Close relationships within degrees of separation