Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| EventSeq | int | 4 | null |
|
|
|||
| AttendeeID | int | 4 | null |
|
|
|||
| AttendeeIDJoint | int | 4 | null |
|
|
|||
| EventCode | varchar | 15 | null |
|
|
|||
| EventDescription | varchar | 50 | null |
|
|
|||
| AttendeeMailName | varchar | 100 | null |
|
|
|||
| AttendeeNameInternal | varchar | 100 | null |
|
|
|||
| AttendeeNameExternal | varchar | 100 | null |
|
|
|||
| AttendeeLegalFullName | varchar | 150 | null |
|
|
|||
| AttendeeSurname | varchar | 30 | null |
|
|
|||
| AttendeeMailSalutation | varchar | 100 | 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 |
|
|
|||
| AttendeeOccupCode | varchar | 15 | √ | null |
|
|
||
| AttendeeOccupDesc | varchar | 50 | null |
|
|
|||
| AttendeeOccupCompany | varchar | 50 | null |
|
|
|||
| AttendeeOccupPhone | varchar | 15 | null |
|
|
|||
| AttendeeOccupFax | varchar | 15 | null |
|
|
|||
| AttendeeOccupEmail | varchar | 100 | null |
|
|
|||
| AttendeeOccupMobilePhone | varchar | 15 | null |
|
|
|||
| AttendeeGender | varchar | 15 | null |
|
|
|||
| AttendeeMobilePhone | varchar | 15 | null |
|
|
|||
| AttendeeDefaultMobilePhone | varchar | 15 | null |
|
|
|||
| AttendeeHomeEmail | varchar | 100 | 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 |
|
|
||
| EventInviteDate | datetime | 16,3 | √ | null |
|
|
||
| EventRSVPDate | datetime | 16,3 | √ | null |
|
|
||
| EventStartDate | datetime | 16,3 | √ | null |
|
|
||
| EventEndDate | datetime | 16,3 | √ | null |
|
|
||
| EventComment | varchar | 2147483647 | √ | null |
|
|
||
| EventHours | decimal | 8,2 | null |
|
|
|||
| EventStatus | varchar | 5 | null |
|
|
|||
| EventTableNumber | smallint | 2 | null |
|
|
|||
| EventTickets | smallint | 2 | null |
|
|
|||
| EventTablesOf | tinyint | 1 | null |
|
|
|||
| EventAdultCost | money | 21,4 | √ | null |
|
|
||
| EventStudentCost | money | 21,4 | √ | null |
|
|
||
| EventConcessionCost | money | 21,4 | √ | null |
|
|
||
| EventMaximumAtendance | smallint | 2 | null |
|
|
|||
| EventLocationContact | varchar | 50 | null |
|
|
|||
| EventLocationAddress1 | varchar | 40 | √ | null |
|
|
||
| EventLocationAddress2 | varchar | 40 | √ | null |
|
|
||
| EventLocatoinAddress3 | 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 |
|
|
Table contained 0 rows