Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EventCode | varchar | 15 | null |
|
|
|||
| Description | varchar | 50 | null |
|
|
|||
| EventConcludedFlag | bit | 1 | null |
|
|
|||
| EventDate | datetime | 16,3 | √ | null |
|
|
||
| EventCreateDate | datetime | 16,3 | √ | null |
|
|
||
| InviteDate | datetime | 16,3 | √ | null |
|
|
||
| RSVPDate | datetime | 16,3 | √ | null |
|
|
||
| LocationCode | varchar | 15 | null |
|
|
|||
| LocationContact | varchar | 50 | null |
|
|
|||
| Organiser1 | varchar | 30 | null |
|
|
|||
| Organiser2 | varchar | 30 | null |
|
|
|||
| Organiser3 | varchar | 30 | null |
|
|
|||
| StaffID1 | int | 4 | null |
|
|
|||
| StaffID2 | int | 4 | null |
|
|
|||
| StaffID3 | int | 4 | null |
|
|
|||
| EventAdultCost | money | 21,4 | √ | null |
|
|
||
| EventStudentCost | money | 21,4 | √ | null |
|
|
||
| EventConcessionCost | money | 21,4 | √ | null |
|
|
||
| MaximumAttendance | smallint | 2 | null |
|
|
|||
| TablesOf | tinyint | 1 | null |
|
|
|||
| BulkAddCriteria | varchar | 2147483647 | √ | null |
|
|
||
| EventsSeq | int identity | 4 | null |
|
|
|||
| WebShowFlag | bit | 1 | null |
|
|
|||
| WebDateFrom | datetime | 16,3 | √ | null |
|
|
||
| WebDateTo | datetime | 16,3 | √ | null |
|
|
||
| WebReturnEmail | varchar | 100 | null |
|
|
|||
| WebMerchantID | varchar | 20 | null |
|
|
|||
| WebExternalReference | varchar | 30 | null |
|
|
|||
| WebComment | varchar | 2147483647 | √ | null |
|
|
||
| Comment | varchar | 2147483647 | √ | null |
|
|
||
| AbsenceEventsSystemProcessNumber | int | 4 | √ | null |
|
|
||
| EventEndDate | datetime | 16,3 | √ | null |
|
|
||
| OnlinePaymentOptionLevelThreeSeq | int | 4 | √ | null |
|
|
||
| EventTypeCode | varchar | 15 | null |
|
|
|||
| MaximumTicketsPerAttendee | smallint | 2 | √ | null |
|
|
||
| ModifiedDateTime | datetime | 16,3 | √ | null |
|
|
||
| AttireCode | varchar | 15 | √ | null |
|
|
||
| Objectives | varchar | 2147483647 | √ | null |
|
|
||
| EventStatus | varchar | 15 | √ | null |
|
|
||
| VerifyDietaryRequirements | bit | 1 | √ | null |
|
|
||
| VerifyEmergencyContactDetails | bit | 1 | √ | null |
|
|
||
| VerifyDoctorDetails | bit | 1 | √ | null |
|
|
||
| VerifyDentistDetails | bit | 1 | √ | null |
|
|
||
| VerifyMedicareDetails | bit | 1 | √ | null |
|
|
||
| VerifyHealthInsurance | bit | 1 | √ | null |
|
|
||
| WebPage | varchar | 2147483647 | √ | null |
|
|
||
| PublicFlag | bit | 1 | √ | null |
|
|
||
| IsExcursion | bit | 1 | √ | null |
|
|
||
| IsDietaryRequirementsRelevant | bit | 1 | √ | null |
|
|
||
| ShowBloodType | bit | 1 | √ | null |
|
|
||
| ShowPhysicalRequirements | bit | 1 | √ | null |
|
|
||
| TermsAndConditions | varchar | 2147483647 | √ | null |
|
|
||
| TermsAndConditionsFlag | bit | 1 | null |
|
|
|||
| IncludeLocationHTMLFlag | bit | 1 | null |
|
|
|||
| IncludeLocationDescriptionFlag | bit | 1 | null |
|
|
|||
| IncludeLocationAddressFlag | bit | 1 | null |
|
|
|||
| VerifyMedicalConditionsFlag | bit | 1 | null |
|
|
|||
| VerifyMedicationFlag | bit | 1 | null |
|
|
|||
| VerifyAllergiesFlag | bit | 1 | null |
|
|
|||
| VerifyOngoingMedicalConsentsFlag | bit | 1 | null |
|
|
|||
| VerifyImmunisationsFlag | bit | 1 | null |
|
|
|||
| VerifyAbilitiesFlag | bit | 1 | null |
|
|
|||
| ConfirmationEmailFlag | bit | 1 | null |
|
|
Table contained 0 rows