Table: dbo.Client_Primary_Location
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLPrimary key for this table, Key to a Client record
location_KEYint (4)NOT NULLKey to a Location record
Primary key
NameColumnsDescription
PK_Client_Primary_Location$client_KEYclient_KEY
Unique constraints
NameColumnsDescription
UK_Client_Primary_Location$location_KEYlocation_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Client_Primary_Location__Client__client_KEYclient_KEYClient (client_KEY)
FK_Client_Primary_Location__Location__location_KEYlocation_KEYLocation (location_KEY)

Schema diagram