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 |