Table: Practice_User
Columns
NameTypeConstraintsDescription
practice_user_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
staff_KEYintNOT NULL
saltnvarchar (8)NOT NULL
password_hashnvarchar (28)NOT NULLSpecifies whether the user must change the password at the next logon.
must_change_passwordbitNOT NULL
Primary key
NameColumnsDescription
PK_Practice_User$practice_user_KEYpractice_user_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Practice_User$staff_KEYstaff_KEY
Indexes
NameColumnsDescription
IX_Practice_User$password_hash$staff_KEYpassword_hash, staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Practice_User__Staff__staff_KEYstaff_KEYStaffon delete cascade;

Schema diagram