Table: Practice_User
Columns
Name | Type | Constraints | Description
practice_user_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
staff_KEY | int | NOT NULL |
salt | nvarchar (8) | NOT NULL |
password_hash | nvarchar (28) | NOT NULL | Specifies whether the user must change the password at the next logon.
must_change_password | bit | NOT NULL |

Primary key
Name | Columns | Description
PK_Practice_User$practice_user_KEY | practice_user_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Practice_User__staff_KEY | staff_KEY |
Indexes
Name | Columns | Description
IX_Practice_User$password_hash$staff_KEY | password_hash, staff_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Practice_User__Staff__staff_KEY | staff_KEY | Staff | on delete cascade;