Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EventCurrentSeq | int | 4 | null |
|
|
|||
| EventCode | varchar | 15 | √ | null |
|
|
||
| EventDescription | varchar | 50 | √ | null |
|
|
||
| EventDate | datetime | 16,3 | √ | null |
|
|
||
| EventCreateDate | datetime | 16,3 | √ | null |
|
|
||
| EventInviteDate | datetime | 16,3 | √ | null |
|
|
||
| EventRSVPDate | datetime | 16,3 | √ | null |
|
|
||
| AttendeeSpouseFlag | int | 4 | null |
|
|
|||
| AttendeeID | int | 4 | null |
|
|
|||
| AttendeeSpouseID | int | 4 | √ | null |
|
|
||
| AttendeeMailName | varchar | 100 | √ | null |
|
|
||
| AttendeeMailSalutation | varchar | 100 | √ | null |
|
|
||
| AttendeeNameInternal | varchar | 100 | √ | null |
|
|
||
| AttendeeNameExternal | varchar | 100 | √ | null |
|
|
||
| AttendeeLegalFullName | varchar | 150 | √ | null |
|
|
||
| AttendeeSurname | varchar | 30 | √ | null |
|
|
||
| AttendeeTitle | varchar | 30 | √ | null |
|
|
||
| AttendeeInitials | varchar | 15 | √ | null |
|
|
||
| AttendeeSuffix | varchar | 20 | √ | null |
|
|
||
| AttendeePreferred | varchar | 20 | √ | null |
|
|
||
| AttendeePreferredFormal | varchar | 20 | √ | null |
|
|
||
| AttendeeGiven1 | varchar | 20 | √ | null |
|
|
||
| AttendeeGiven2 | varchar | 50 | √ | null |
|
|
||
| AttendeeAddressComma | varchar | 200 | √ | null |
|
|
||
| AttendeeAddressFull | varchar | 200 | √ | null |
|
|
||
| AttendeePostcode | varchar | 5 | √ | null |
|
|
||
| AttendeeCountryCode | varchar | 5 | √ | null |
|
|
||
| AttendeeState | varchar | 5 | √ | null |
|
|
||
| AttendeeAddressDPID | varchar | 8 | √ | null |
|
|
||
| AttendeeAddressDPIDBarcode | varchar | 60 | √ | null |
|
|
||
| AttendeeAddressSortPlanNumber | varchar | 3 | √ | null |
|
|
||
| AttendeeAddressPAFVersion | varchar | 10 | √ | null |
|
|
||
| AttendeeHomePhone | varchar | 15 | √ | null |
|
|
||
| AttendeeHomeFax | varchar | 15 | √ | null |
|
|
||
| AttendeeHomeEmail | varchar | 100 | √ | null |
|
|
||
| AttendeeMobilePhone | varchar | 15 | √ | null |
|
|
||
| AttendeeOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| AttendeeOccupCode | varchar | 15 | √ | null |
|
|
||
| AttendeeOccupDesc | varchar | 50 | √ | null |
|
|
||
| AttendeeOccupCompany | varchar | 50 | √ | null |
|
|
||
| AttendeeOccupPhone | varchar | 15 | √ | null |
|
|
||
| AttendeeOccupFax | varchar | 15 | √ | null |
|
|
||
| AttendeeOccupEmail | varchar | 100 | √ | null |
|
|
||
| AttendeeGender | varchar | 15 | √ | null |
|
|
||
| EventStartDate | datetime | 16,3 | √ | null |
|
|
||
| EventEndDate | datetime | 16,3 | √ | null |
|
|
||
| EventComment | varchar | 2147483647 | √ | null |
|
|
||
| EventHours | decimal | 8,2 | null |
|
|
|||
| EventStatus | varchar | 5 | null |
|
|
|||
| AttendeeTypeCode | varchar | 15 | √ | null |
|
|
||
| EventTickets | smallint | 2 | null |
|
|
|||
| EventTableNumber | int | 4 | null |
|
|
|||
| EventTablesOf | tinyint | 1 | √ | null |
|
|
||
| EventTableCaptainFlag | bit | 1 | null |
|
|
|||
| EventTableName | varchar | 50 | null |
|
|
|||
| EventTotalCost | money | 21,4 | null |
|
|
|||
| EventDepositReceived | money | 21,4 | null |
|
|
|||
| EventTotalReceived | money | 21,4 | null |
|
|
|||
| EventAdultCost | money | 21,4 | √ | null |
|
|
||
| EventStudentCost | money | 21,4 | √ | null |
|
|
||
| EventConcessionCost | money | 21,4 | √ | null |
|
|
||
| EventMaximumAttendance | smallint | 2 | √ | null |
|
|
||
| EventLocationContact | varchar | 50 | √ | null |
|
|
||
| EventLocationDescription | varchar | 50 | √ | null |
|
|
||
| EventLocationAddress1 | varchar | 40 | √ | null |
|
|
||
| EventLocationAddress2 | varchar | 40 | √ | null |
|
|
||
| EventLocationAddress3 | varchar | 40 | √ | null |
|
|
||
| EventLocationSuburb | varchar | 40 | √ | null |
|
|
||
| EventLocationState | varchar | 5 | √ | null |
|
|
||
| EventLocationPostCode | varchar | 5 | √ | null |
|
|
||
| EventLocationPhone | varchar | 15 | √ | null |
|
|
||
| EventOrganiser1 | varchar | 30 | √ | null |
|
|
||
| EventOrganiser2 | varchar | 30 | √ | null |
|
|
||
| EventOrganiser3 | varchar | 30 | √ | null |
|
|
||
| EventStaffID1 | int | 4 | √ | null |
|
|
||
| EventStaffID2 | int | 4 | √ | null |
|
|
||
| EventStaffID3 | int | 4 | √ | null |
|
|
||
| EventConcludedFlag | bit | 1 | √ | null |
|
|
||
| DietaryRequirements | varchar | 8000 | √ | null |
|
|
||
| PhysicalRequirements | varchar | 8000 | √ | null |
|
|
||
| RelatedAttendeeID | int | 4 | √ | null |
|
|
||
| DietaryRequirementCode | varchar | 15 | √ | null |
|
|
||
| EventsSeq | int | 4 | √ | null |
|
|
||
| AttendeeGuestFlag | int | 4 | null |
|
|
|||
| RelatedAttendeeName | varchar | 52 | null |
|
|
Table contained 0 rows