APPLICATIONURLPARTS
This table stores information about the location of the application needed by system alerts features to build links. It is NOT functional and needs to be kept in sync with the installation location.
Primary Key
| Primary Key |
Field Type |
| ID |
uniqueidentifier |
Fields
| Field |
Field Type |
Null |
Notes |
Description |
| ROOT |
nvarchar(1024) |
|
Default = '' |
The full path to the application web service end point. |
| SELECTEDDATABASE |
nvarchar(128) |
|
Default = '' |
The name of the database declared in the web.config to use. |
| 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) |
yes |
CONVERT(bigint, TS) |
Numeric representation of the timestamp. |
Foreign Keys
| Foreign Key |
Field Type |
Null |
Notes |
Description |
| ADDEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
| CHANGEDBYID |
uniqueidentifier |
|
CHANGEAGENT.ID
|
FK to CHANGEAGENT. |
Indexes
| Index Name |
Fields |
Unique |
Primary |
Clustered |
| IX_APPLICATIONURLPARTS_DATEADDED |
DATEADDED |
|
|
yes |
| IX_APPLICATIONURLPARTS_DATECHANGED |
DATECHANGED |
|
|
|
| PK_APPLICATIONURLPARTS |
ID |
yes |
yes |
|
Triggers