Table: dbo.Practice_User
Columns
NameTypeConstraintsDescription
practice_user_KEYint (4)NOT NULLDatabase assigned primary key for this table.
update__staff_KEYint (4)NOT NULLKey of the Staff who last modified this row.
update_datedatetime (8, 3)NOT NULLThe date and time this row was last modified.
staff_KEYint (4)NOT NULL
saltnvarchar (60)NOT NULLThe salt used for the password hash.
password_hashnvarchar (128)NOT NULLContains the password hash.
must_change_passwordbit (1)NOT NULLSpecifies whether the user must change the password at the next logon.
Primary key
NameColumnsDescription
PK_Practice_Userpractice_user_KEY
Unique constraints
NameColumnsDescription
UK_Practice_User$staff_KEYstaff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Practice_User__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram