EventItems
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| BackOfficeID | int | |||
| LimitCapacity | bit | Default = 0 | ||
| PageLink | nvarchar(1024) | yes | ||
| DisplayName | nvarchar(100) | yes | ||
| ShowRelations | bit | Default = 1 | ||
| Attributes | ntext | yes | ||
| DisplayDesc | ntext | yes | ||
| Target | nvarchar(256) | yes | ||
| PageTabID | int | Default = 0 | ||
| BaseCurrencyID | uniqueidentifier | yes | ||
| DisplayOrder | int | Default = 0 | ||
| DocLinkID | int | Default = 0 | ||
| MaxRegPerCheckout | int | yes | ||
| SoldOutMessage | ntext | yes |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| ClientEventsID | int | ClientEvents.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_EventItems_ClientEventsID | ClientEventsID | |||
| PK_EventItems | ID | yes | yes | yes |
Referenced by
| Referenced by | Field |
|---|---|
| EventItemPrices | EventItemsID |