Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CommunityEventsGuestsSeq | int identity | 4 | √ | null |
|
|
||||
| EventCode | varchar | 15 | ('') |
|
|
|||||
| ID | int | 4 | ((0)) |
|
|
|||||
| Surname | varchar | 30 | ('') |
|
|
|||||
| Preferred | varchar | 20 | ('') |
|
|
|||||
| OccupCompany | varchar | 50 | ('') |
|
|
|||||
| OccupIndustryCode | varchar | 8 | ('') |
|
|
|||||
| OccupPositionCode | varchar | 8 | ('') |
|
|
|||||
| DietaryRequirements | varchar | 2147483647 | √ | null |
|
|
||||
| PhysicalRequirements | varchar | 2147483647 | √ | null |
|
|
||||
| GuestID | int | 4 | √ | null |
|
|
||||
| OverrideTableNumber | int | 4 | √ | null |
|
|
||||
| Title | varchar | 30 | ('') |
|
|
|||||
| DietaryRequirementCode | varchar | 15 | ('') |
|
|
|||||
| MobilePhone | varchar | 15 | ('') |
|
|
|||||
| varchar | 100 | ('') |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_CommunityEventsGuests | Primary key | Asc | CommunityEventsGuestsSeq |
| AK_CommunityEventsGuests_CommunityEventsGuestsSeq | Performance | Asc | CommunityEventsGuestsSeq |
Relationships
Close relationships within degrees of separation
