USERPAGEHISTORY
The USERPAGEHISTORY table stores the recent history for each page by user
Primary Key
| Primary Key | Field Type |
|---|---|
| APPUSERID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| HISTORY | xml | yes | Contains the page history for the APPUSER | |
| DATECHANGED | datetime | Default = getdate() | Indicates the date this record was last changed |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| APPUSERID | uniqueidentifier | APPUSER.ID | FK to APPUSER | |
| PAGEID | uniqueidentifier | PAGEDEFINITIONCATALOG.ID | FK to PAGEDEFINITIONCATALOG |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_USERPAGEHISTORY | APPUSERID, PAGEID | yes | yes | yes |