Table: dbo.Client_N_Staff
List which firm staff are allowed access to each client.
Columns
NameTypeConstraintsDescription
client_n_staff_KEYint (4)NOT NULLPrimary key
client_KEYint (4)NOT NULLKey to parent client record.
staff_KEYint (4)NOT NULLLink to staff record that has access to the associated client.
Primary key
NameColumnsDescription
PK_Client_N_Staffclient_n_staff_KEY
Unique constraints
NameColumnsDescription
UK_Client_N_Staff$client_KEY$staff_KEYclient_KEY, staff_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_N_Staff__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_N_Staff__Staff__staff_KEYstaff_KEYStaff (staff_KEY)

Schema diagram