Table: dbo.Practice_User | |||
Columns | |||
Name | Type | Constraints | Description |
practice_user_KEY | int (4) | NOT NULL | Database assigned primary key for this table. |
update__staff_KEY | int (4) | NOT NULL | Key of the Staff who last modified this row. |
update_date | datetime (8, 3) | NOT NULL | The date and time this row was last modified. |
staff_KEY | int (4) | NOT NULL | |
salt | nvarchar (60) | NOT NULL | The salt used for the password hash. |
password_hash | nvarchar (128) | NOT NULL | Contains the password hash. |
must_change_password | bit (1) | NOT NULL | Specifies whether the user must change the password at the next logon. |
Primary key | |||
Name | Columns | Description | |
PK_Practice_User | practice_user_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Practice_User$staff_KEY | staff_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Practice_User__Staff__staff_KEY | staff_KEY | Staff (staff_KEY) |