Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
NAME | nvarchar(154) | Default = '' | The name of this group. | |
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. | |
STARTDATETIME | datetime (Computed) | dbo.UFN_ITINERARY_STARTDATETIME(ID) | ||
ENDDATETIME | datetime (Computed) | dbo.UFN_ITINERARY_ENDDATETIME(ID) |
Foreign Key | Field Type | Null | Notes | Description |
---|---|---|---|---|
RESERVATIONID | uniqueidentifier | RESERVATION.ID | The reservation the itinerary belongs to. | |
LEADERID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
TRACKID | uniqueidentifier | TRACK.ID | The track the itinerary was created from. | |
GROUPSALESGROUPTYPECODEID | uniqueidentifier | GROUPSALESGROUPTYPECODE.ID | Describes teh group type associated with this itinerary. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_ITINERARY_DATEADDED | DATEADDED | |||
IX_ITINERARY_DATECHANGED | DATECHANGED | |||
IX_ITINERARY_LEADERID | LEADERID | |||
IX_ITINERARY_RESERVATIONID | RESERVATIONID | |||
PK_ITINERARY | ID |
Trigger Name | Description |
---|---|
TR_ITINERARY_AUDIT_UPDATE | |
TR_ITINERARY_AUDIT_DELETE |
Referenced by | Field |
---|---|
ITINERARYATTENDEE | ITINERARYID |
ITINERARYITEM | ITINERARYID |
ITINERARYRESOURCE | ITINERARYID |
ITINERARYSTAFFRESOURCE | ITINERARYID |