ClientUserPasswordHistory
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | int |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| Password | nvarchar(255) | yes | ||
| DateUsed | datetime | yes | Default = getutcdate() |
Foreign Keys
| Foreign Key | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| UserID | int | ClientUsers.ID |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| IX_ClientUserPasswordHistory_UserID_DateUsed | UserID, DateUsed (DESC) | |||
| PK_PASSWORDHISTORY | ID | yes | yes | yes |