| Primary Key | Field Type |
|---|---|
 ID |
uniqueidentifier |
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 NAME |
nvarchar(100) | Default = '' | The name of the event's location. | |
| CAPACITY |
int | Default = 0 | Maximum capacity allowed for the event. | |
| ADDRESSBLOCK |
nvarchar(150) | Default = '' | Contains the location's address lines. | |
| CITY |
nvarchar(50) | Default = '' | Contains the location's city. | |
| POSTCODE |
nvarchar(12) | Default = '' | Contains the location's post code. | |
| PHONENUMBER |
nvarchar(100) | Default = '' | Stores the location's phone number. | |
| DATEADDED |
datetime | Default = getdate() | Indicates the date this record was added. | |
| DATECHANGED |
datetime | Default = getdate() | Indicates the date this record was last changed. | |
| TS |
timestamp | Timestamp. | ||
 TSLONG |
bigint (Computed) |  |
CONVERT(bigint, TS) | Numeric representation of the timestamp. |
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
 COUNTRYID |
uniqueidentifier | COUNTRY.LOCALID | FK to COUNTRY | |
| STATEID |
uniqueidentifier | |
STATE.LOCALID | FK to STATE |
| ADDEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
| CHANGEDBYID |
uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
| Index Name | Field(s) | Unique | Primary | Clustered |
|---|---|---|---|---|
 IX_EVENTLOCATION_DATEADDED |
DATEADDED | |
||
 IX_EVENTLOCATION_DATECHANGED |
DATECHANGED | |||
| PK_EVENTLOCATION |
ID | |
|
| Trigger Name | Description |
|---|---|
 TR_EVENTLOCATION_AUDIT_UPDATE |
|
| TR_EVENTLOCATION_AUDIT_DELETE |
| Referenced by | Field |
|---|---|
 BATCHEVENT |
EVENTLOCATIONID |
| EVENT |
EVENTLOCATIONID |
| EVENTLOCATIONROOM |
EVENTLOCATIONID |
| FACILITY |
ID |
| FAFEVENTBATCH |
EVENTLOCATIONID |
| ITINERARYITEM |
EVENTLOCATIONID |
| PROGRAMEVENTLOCATION |
EVENTLOCATIONID |
| PROGRAMLOCATION |
EVENTLOCATIONID |
| REVENUESPLITORDER |
EVENTLOCATIONID |
| SALESORDERITEMFACILITY |
EVENTLOCATIONID |
| TRACKITEM |
EVENTLOCATIONID |