Primary Key | Field Type |
---|---|
ID | uniqueidentifier |
Field | Field Type | Null | Notes | Description |
---|---|---|---|---|
DEPARTURETIME | UDT_HOURMINUTE | Default = '' | The registrants travel departure time. | |
DEPARTUREDATE | datetime | The registrants travel departure date. | ||
DEPARTURENUMBER | nvarchar(25) | Default = '' | The number of the scheduled departure travel mode (ie flight number) | |
ARRIVALTIME | UDT_HOURMINUTE | Default = '' | The registrants travel arrival time. | |
ARRIVALDATE | datetime | The registrants travel arrival date. | ||
ARRIVALNUMBER | nvarchar(25) | Default = '' | The number of the scheduled arrival travel mode (ie flight 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 |
---|---|---|---|---|
REGISTRANTCONSTITUENTID | uniqueidentifier | CONSTITUENT.LOCALID | FK to CONSTITUENT | |
MAINEVENTID | uniqueidentifier | EVENT.ID | FK to EVENT | |
REGISTRANTDEPARTURETRAVELTYPECODEID | uniqueidentifier | EVENTREGISTRANTTRAVELTYPECODE.ID | FK to EVENTREGISTRANTTRAVELTYPECODE | |
REGISTRANTDEPARTURETRAVELNAMECODEID | uniqueidentifier | EVENTREGISTRANTTRAVELNAMECODE.ID | FK to EVENTREGISTRANTTRAVELNAMECODE | |
REGISTRANTARRIVALTRAVELTYPECODEID | uniqueidentifier | EVENTREGISTRANTTRAVELTYPECODE.ID | FK to EVENTREGISTRANTTRAVELTYPECODE | |
REGISTRANTARRIVALTRAVELNAMECODEID | uniqueidentifier | EVENTREGISTRANTTRAVELNAMECODE.ID | FK to EVENTREGISTRANTTRAVELNAMECODE | |
ADDEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. | |
CHANGEDBYID | uniqueidentifier | CHANGEAGENT.ID | FK to CHANGEAGENT. |
Index Name | Field(s) | Unique | Primary | Clustered |
---|---|---|---|---|
IX_REGISTRANTTRAVEL_DATEADDED | DATEADDED | |||
IX_REGISTRANTTRAVEL_DATECHANGED | DATECHANGED | |||
PK_REGISTRANTTRAVEL | ID | |||
UIX_REGISTRANTTRAVEL_REGISTRANTCONSTITUENTID_MAINEVENTID | REGISTRANTCONSTITUENTID, MAINEVENTID |
Trigger Name | Description |
---|---|
TR_REGISTRANTTRAVEL_AUDIT_UPDATE | |
TR_REGISTRANTTRAVEL_AUDIT_DELETE |