Table: dbo.Location
Columns
NameTypeConstraintsDescription
location_KEYint (4)NOT NULLPrimary key for this table
contact_KEYint (4)NOT NULLKey to a Contact record
client_KEYint (4)NOT NULLKey to a Client record
descriptionnvarchar (60)NOT NULLUser defined description
Primary key
NameColumnsDescription
PK_Locationlocation_KEY
Unique constraints
NameColumnsDescription
UK_Location$client_KEY$descriptionclient_KEY, description
UK_Location$contact_KEYcontact_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Location__Client__client_KEYclient_KEYClient (client_KEY)
FK_Location__Contact__contact_KEYcontact_KEYContact (contact_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Client_Primary_Location__Location__location_KEYlocation_KEYClient_Primary_Location
FK_Work_Location__Location__location_KEYlocation_KEYWork_Location

Schema diagram