Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| 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 |
|
|
||
| EventCurrentSeq | int | 4 | null |
|
|
|||
| AttendeeID | int | 4 | null |
|
|
|||
| AttendeePrimaryOnlyFlag | bit | 1 | 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 |
|
|
|||
| AttendeeSpouseNameInternal | varchar | 100 | √ | null |
|
|
||
| AttendeeSpouseNameExternal | varchar | 100 | √ | null |
|
|
||
| AttendeeSpouseLegalFullName | varchar | 150 | √ | null |
|
|
||
| AttendeeSpousePreferredFormal | varchar | 20 | √ | null |
|
|
||
| AttendeeSpouseSurname | varchar | 30 | √ | null |
|
|
||
| AttendeeSpouseTitle | varchar | 30 | √ | null |
|
|
||
| AttendeeSpouseInitials | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseSuffix | varchar | 20 | √ | null |
|
|
||
| AttendeeSpousePreferred | varchar | 20 | √ | null |
|
|
||
| AttendeeSpouseGiven1 | varchar | 20 | √ | null |
|
|
||
| AttendeeSpouseGiven2 | 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 |
|
|
|||
| AttendeeDefaultMobilePhone | 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 |
|
|
|||
| AttendeeSpouseHomeEmail | varchar | 100 | √ | null |
|
|
||
| AttendeeSpouseMobilePhone | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseDefaultMobilePhone | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseOccupMobilePhone | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseOccupCode | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseOccupDesc | varchar | 50 | √ | null |
|
|
||
| AttendeeSpouseOccupCompany | varchar | 50 | √ | null |
|
|
||
| AttendeeSpouseOccupPhone | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseOccupFax | varchar | 15 | √ | null |
|
|
||
| AttendeeSpouseOccupEmail | varchar | 100 | √ | null |
|
|
||
| AttendeeSpouseGender | 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 |
|
|
|||
| EventTickets | smallint | 2 | null |
|
|
|||
| EventTableNumber | smallint | 2 | 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 |
|
|
|||
| EventsSeq | int | 4 | null |
|
|
Table contained 0 rows