CommunityEventsCurrentGuests


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CommunityEventsCurrentGuestsSeq int identity 4 √ null
CommunityEventsCurrentGuestsAttributes.CommunityEventsCurrentGuestsSeq FK_CommunityEventsCurrentGuestsAttributes_CommunityEventsCurrentGuests R
EventCode varchar 15 ('')
Events.EventCode FK_CommunityEventsCurrentGuests_Events_EventCode R
ID int 4 ((0))
Community.ID FK_CommunityEventsCurrentGuests_Community_HostID R
Title varchar 30 ('')
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
Community.ID FK_CommunityEventsCurrentGuests_Community_GuestID R
OverrideTableNumber int 4 √ null
DietaryRequirementCode varchar 15 ('')
MobilePhone varchar 15 ('')
Email varchar 100 ('')
EventCurrentSeq int 4 √ null
CommunityEventsCurrent.EventCurrentSeq FK_CommunityEventsCurrentGuests_CommunityEventsCurrent R
ReceiptsOnlineReference varchar 150 ('')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_CommunityEventsCurrentGuests Primary key Asc CommunityEventsCurrentGuestsSeq
AK_CommunityEventsCurrentGuests_CommunityEventsCurrentGuestsSeq Performance Asc CommunityEventsCurrentGuestsSeq

Relationships

Close relationships within degrees of separation