Table: dbo.Location
Columns
Name | Type | Constraints | Description
location_KEY | int (4) | NOT NULL | Primary key for this table
contact_KEY | int (4) | NOT NULL | Key to a Contact record
client_KEY | int (4) | NOT NULL | Key to a Client record
description | nvarchar (60) | NOT NULL | User defined description

Primary key
Name | Columns | Description
PK_Location | location_KEY |
Unique constraints
Name | Columns | Description
UK_Location$client_KEY$description | client_KEY, description |
UK_Location$contact_KEY | contact_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Location__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Location__Contact__contact_KEY | contact_KEY | Contact (contact_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Client_Primary_Location__Location__location_KEY | location_KEY | Client_Primary_Location |
FK_Work_Location__Location__location_KEY | location_KEY | Work_Location |