Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(100) | Default = '' | Contains the name of the lodging location. | |
COMMENT | nvarchar(256) | Default = '' | Comments for the lodging location. | |
ADDRESSBLOCK | nvarchar(150) | Default = '' | Contains the address lines for this lodging location.. | |
CITY | nvarchar(50) | Default = '' | Contains the address city for this lodging location.. | |
POSTCODE | nvarchar(12) | Default = '' | Contains the address post code for this lodging location.. | |
PHONENUMBER | nvarchar(100) | Default = '' | Contains the phone number to the lodging location. | |
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. | |
DISCOUNTCODE | nvarchar(20) | Default = '' | Contains a discount code that applies to the lodging location. | |
NUMBERNOFORMAT | nvarchar(100) (Computed) | dbo.UFN_PHONE_REMOVEFORMATTING(PHONENUMBER) | Stores a non-formatted version of the number. |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
CONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | Contains the contact information for this lodging location. | |
COUNTRYID | uniqueidentifier | COUNTRY.LOCALID | Contains the country for this lodging location. | |
STATEID | uniqueidentifier | STATE.LOCALID | Contains the state for this lodging location. | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_EVENTLODGINGLOCATION_CONSTITUENTID | CONSTITUENTID | |||
IX_EVENTLODGINGLOCATION_DATEADDED | DATEADDED | |||
IX_EVENTLODGINGLOCATION_DATECHANGED | DATECHANGED | |||
IX_EVENTLODGINGLOCATION_NUMBERNOFORMAT | NUMBERNOFORMAT | |||
IX_EVENTLODGINGLOCATION_STATEID | STATEID | |||
PK_EVENTLODGINGLOCATION | ID |
Trigger Name | Description |
---|---|
TR_EVENTLODGINGLOCATION_AUDIT_UPDATE | |
TR_EVENTLODGINGLOCATION_AUDIT_DELETE |
Referenced by | Field |
---|---|
EVENTLODGING | EVENTLODGINGLOCATIONID |
EVENTLODGINGLOCATIONROOMTYPE | EVENTLODGINGLOCATIONID |